Subversion Repositories DevTools

Rev

Rev 5122 | Blame | Compare with Previous | Last modification | View Log | RSS feed

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|                                                   |
'|  _DeleteBuildStandard
'|                                                   |
'=====================================================
%>
<%
Option explicit
Response.Expires = 0
%>
<!--#include file="common/conf.asp"-->
<!--#include file="common/globals.asp"-->
<!--#include file="common/formating.asp"-->
<!--#include file="common/qstr.asp"-->
<!--#include file="common/common_subs.asp"-->
<!--#include file="common/_form_window_common.asp"-->
<%
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_general.asp"-->
<!--#include file="_access_control_login.asp"-->
<%
'------------ VARIABLE DEFINITION -------------
'------------ CONSTANTS DECLARATION -----------
'------------ VARIABLE INIT -------------------
'------------ CONDITIONS ----------------------
'----------------------------------------------
%>
<%
'--------------------------------------------------------------------------------------------------------------------------
Sub DeleteBuildStandard (bsa_id)
        On Error Resume Next
        OraDatabase.Parameters.Add "BSA_ID",    bsa_id, ORAPARM_INPUT, ORATYPE_NUMBER 
        objEH.TryORA ( OraSession )
        OraDatabase.ExecuteSQL "BEGIN DELETE FROM BUILD_STANDARDS_ADDENDUM WHERE BSA_ID = :BSA_ID; END;"
        objEH.CatchORA ( OraSession )   
        OraDatabase.Parameters.Remove "BSA_ID"
End Sub
'--------------------------------------------------------------------------------------------------------------------------
%>
<%
'**************************** M  A  I  N ******************************
' --- Form is Valid ---
Call DeleteBuildStandard(Request("bsa_id"))

If objEH.Finally Then
        Call OpenInWindow ("admin_gbe_buildstandard.asp")
End If
'**********************************************************************
%>
<%
'------------ RUN AFTER CODE RUN --------------
'----------------------------------------------
'----------------------------------------------
Call Destroy_All_Objects
%>