Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|			      _DestroyOs 					 	 |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
Response.Expires = 0
12
%>
13
<!--#include file="common/globals.asp"-->
14
<!--#include file="common/config.asp"-->
15
<!--#include file="common/common_subs.asp"-->
16
<!--#include file="common/_code_behind_common.asp"-->
17
<%
18
'------------ ACCESS CONTROL ------------------
19
%>
20
<!--#include file="_access_control_general.asp"-->
21
<%
22
'------------ VARIABLE DEFINITION -------------
23
'------------ CONSTANTS DECLARATION -----------
24
'------------ VARIABLE INIT -------------------
25
'------------ CONDITIONS ----------------------
26
'----------------------------------------------
27
%>
28
<%
29
'--------------------------------------------------------------------------------------------------------------------------------
30
Sub DestroyOs ()
31
	On Error Resume Next
32
 
33
	OraDatabase.Parameters.Add "OS_ID_LIST", Request("os_id_list"), 		ORAPARM_INPUT, ORATYPE_VARCHAR2
17 rsolanki 34
	OraDatabase.Parameters.Add "USER_ID", 	 objAccessControl.UserId, 		ORAPARM_INPUT, ORATYPE_NUMBER
13 rsolanki 35
 
36
	objEH.TryORA ( OraSession )
37
 
38
	OraDatabase.ExecuteSQL _
17 rsolanki 39
	"BEGIN   pk_Operating_System.Destroy_Os ( :OS_ID_LIST, :USER_ID );   END;"
13 rsolanki 40
 
41
	objEH.CatchORA ( OraSession )
42
 
43
 
44
	OraDatabase.Parameters.Remove "OS_ID_LIST"
17 rsolanki 45
	OraDatabase.Parameters.Remove "USER_ID"
13 rsolanki 46
 
47
End Sub
48
'--------------------------------------------------------------------------------------------------------------------------
49
%>
50
<%
51
'**************************** M  A  I  N ******************************
52
' --- Form is Valid ---
53
Call DestroyOs()
54
 
55
If objEH.Finally Then
29 jtweddle 56
	Call OpenInWindow ( "NodeDefault.asp?DONE=OK"& objPMod.ComposeURLWithout("rfile") )
13 rsolanki 57
End If
58
'**********************************************************************
59
%>
60
<%
61
'------------ RUN AFTER CODE RUN --------------
62
'----------------------------------------------
63
%><!--#include file="common/globals_destructor.asp"-->