Rev 119 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<%@LANGUAGE="VBSCRIPT"%><%'====================================================='| |'| _RemoveApplicationUser |'| |'=====================================================%><%Option explicitResponse.Expires = 0%><!--#include file="common/conf.asp"--><!--#include file="common/globals.asp"--><!--#include file="common/common_subs.asp"--><%'------------ ACCESS CONTROL ------------------%><%'------------ VARIABLE DEFINITION -------------'------------ CONSTANTS DECLARATION -----------'------------ VARIABLE INIT -------------------'------------ CONDITIONS ----------------------'----------------------------------------------%><%'--------------------------------------------------------------------------------------------------------------------------Sub RemoveApplicationUser ()On Error Resume NextOraDatabase.Parameters.Add "USER_ID_LIST", Request("user_id_list"), ORAPARM_INPUT, ORATYPE_VARCHAR2OraDatabase.Parameters.Add "APP_ID", Request("app_id"), ORAPARM_INPUT, ORATYPE_NUMBEROraDatabase.Parameters.Add "INCLUDE_ALL", Request("everyone"), ORAPARM_INPUT, ORATYPE_CHARobjEH.TryORA ( OraSession )OraDatabase.ExecuteSQL _"BEGIN pk_User.Remove_Application_User ( :USER_ID_LIST, :APP_ID, :INCLUDE_ALL ); END;"'--- Log Action ---'objEH.LogAction _'objAccessControl.UserId, _'enumAT_EVENT_COMMENT, _'"Sub RemoveProductFromOs PROD_ID_LIST="& Request("prod_id_list") &", OS_ID="& Request("os_id") , _'SCRIPT_NAME, _'"Removed Products from OS.", _'OraDatabaseobjEH.CatchORA ( OraSession )OraDatabase.Parameters.Remove "USER_ID_LIST"OraDatabase.Parameters.Remove "INCLUDE_ALL"OraDatabase.Parameters.Remove "APP_ID"End Sub'--------------------------------------------------------------------------------------------------------------------------%><%'**************************** M A I N ******************************' --- Form is Valid ---Response.Write(Request("user_id_list"))'Call RemoveApplicationUser()'If objEH.Finally Then' Call OpenInWindow ( Request("rfile") &"?"& objPMod.ComposeURL() )'End If'**********************************************************************%><%'------------ RUN AFTER CODE RUN --------------'----------------------------------------------Call Destroy_All_Objects%>