Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6049 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'======================================================
4
'   _DisableUserAccount.asp
5
'======================================================
6
%>
7
<%
8
Option explicit
9
Response.Expires = 0
10
%>
11
<!--#include file="common/globals.asp"-->
12
<!--#include file="common/config.asp"-->
13
<!--#include file="common/common_subs.asp"-->
14
<!--#include file="common/_code_behind_common.asp"-->
15
<%
16
'------------ ACCESS CONTROL ------------------
17
%>
18
<!--#include file="_access_control_general.asp"-->
19
<%
20
'------------ VARIABLE DEFINITION -------------
21
'------------ CONSTANTS DECLARATION -----------
22
'------------ VARIABLE INIT -------------------
23
'------------ CONDITIONS ----------------------
24
'----------------------------------------------
25
%>
26
<%
27
'--------------------------------------------------------------------------------------------------------------------------
28
Sub DisableUserAccount ()
29
	On Error Resume Next
30
 
31
	OraDatabase.Parameters.Add "USER_ID_LIST", 	Request("user_id_list"), 	ORAPARM_INPUT, ORATYPE_VARCHAR2
32
 
33
	objEH.TryORA ( OraSession )
34
 
35
		OraDatabase.ExecuteSQL _
36
		"BEGIN   pk_User.Disable_Users ( :USER_ID_LIST, 0 );   END;"
37
 
38
		'--- Log Action ---
39
		'objEH.LogAction  _
40
		'objAccessControl.UserId, _
41
		'enumAT_EVENT_COMMENT, _
42
		'"Sub RemoveProductFromOs PROD_ID_LIST="& Request("prod_id_list") &", OS_ID="& Request("os_id") , _
43
		'SCRIPT_NAME, _
44
		'"Removed Products from OS.", _
45
		'OraDatabase 
46
 
47
	objEH.CatchORA ( OraSession )
48
 
49
	OraDatabase.Parameters.Remove "USER_ID_LIST"
50
 
51
End Sub
52
'--------------------------------------------------------------------------------------------------------------------------
53
%>
54
<%
55
'**************************** M  A  I  N ******************************
56
' --- Form is Valid ---
57
Call DisableUserAccount()
58
 
59
If objEH.Finally Then
60
	Call OpenInWindow ( Request("rfile") &"?removed=ok"& objPMod.ComposeURLWithout("user_id,rfile") )
61
End If
62
'**********************************************************************
63
%>
64
<%
65
'------------ RUN AFTER CODE RUN --------------
66
'----------------------------------------------
67
%><!--#include file="common/globals_destructor.asp"-->