APPS.ARI_SELF_SERVICE_PKG dependencies on UMX_REG_REQUESTS

Line 145: | DESCRIPTION Inserts a record into umx_reg_requests table on the initiation

141:
142: /* =======================================================================
143: | PROCEDURE LogAccessRequest
144: |
145: | DESCRIPTION Inserts a record into umx_reg_requests table on the initiation
146: |of the UMX Add Access Flow
147: |
148: |
149: | PARAMETERS

Line 167: CURSOR C1 IS SELECT rowid FROM UMX_REG_REQUESTS

163: l_reg_request_id VARCHAR2(200) := null;
164: l_justification VARCHAR2(200);
165: l_ame_transaction_type_id VARCHAR2(200);
166:
167: CURSOR C1 IS SELECT rowid FROM UMX_REG_REQUESTS
168: WHERE REG_REQUEST_ID = p_reg_request_id;
169: CURSOR C2 IS SELECT UMX_REG_REQUESTS_S.nextval FROM sys.dual;
170:
171: CURSOR C3 IS SELECT Reg_Request_Id

Line 169: CURSOR C2 IS SELECT UMX_REG_REQUESTS_S.nextval FROM sys.dual;

165: l_ame_transaction_type_id VARCHAR2(200);
166:
167: CURSOR C1 IS SELECT rowid FROM UMX_REG_REQUESTS
168: WHERE REG_REQUEST_ID = p_reg_request_id;
169: CURSOR C2 IS SELECT UMX_REG_REQUESTS_S.nextval FROM sys.dual;
170:
171: CURSOR C3 IS SELECT Reg_Request_Id
172: FROM UMX_REG_REQUESTS
173: WHERE Created_By = nvl(FND_GLOBAL.user_id,-1)

Line 172: FROM UMX_REG_REQUESTS

168: WHERE REG_REQUEST_ID = p_reg_request_id;
169: CURSOR C2 IS SELECT UMX_REG_REQUESTS_S.nextval FROM sys.dual;
170:
171: CURSOR C3 IS SELECT Reg_Request_Id
172: FROM UMX_REG_REQUESTS
173: WHERE Created_By = nvl(FND_GLOBAL.user_id,-1)
174: AND Reg_Service_Code = p_reg_service_code
175: AND Status_Code = 'UNASSIGNED';
176:

Line 246: INSERT INTO UMX_REG_REQUESTS(

242: arp_standard.debug(l_debug_info||' '||l_justification);
243: END IF;
244:
245: IF (l_reg_request_id IS NULL) THEN
246: INSERT INTO UMX_REG_REQUESTS(
247: Reg_Request_Id,
248: Reg_Service_Type,
249: Status_Code,
250: Requested_Start_Date,