DBA Data[Home] [Help]

APPS.ARI_SELF_SERVICE_PKG dependencies on FND_GLOBAL

Line 173: WHERE Created_By = nvl(FND_GLOBAL.user_id,-1)

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:
177: BEGIN

Line 268: nvl(FND_GLOBAL.user_id,-1),

264: p_reg_request_id,
265: l_reg_service_type,
266: 'UNASSIGNED',
267: sysdate,
268: nvl(FND_GLOBAL.user_id,-1),
269: sysdate,
270: nvl(FND_GLOBAL.user_id,-1),
271: sysdate,
272: nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id),

Line 270: nvl(FND_GLOBAL.user_id,-1),

266: 'UNASSIGNED',
267: sysdate,
268: nvl(FND_GLOBAL.user_id,-1),
269: sysdate,
270: nvl(FND_GLOBAL.user_id,-1),
271: sysdate,
272: nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id),
273: nvl(FND_GLOBAL.user_id,-1),
274: nvl(FND_GLOBAL.user_id,-1),

Line 272: nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id),

268: nvl(FND_GLOBAL.user_id,-1),
269: sysdate,
270: nvl(FND_GLOBAL.user_id,-1),
271: sysdate,
272: nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id),
273: nvl(FND_GLOBAL.user_id,-1),
274: nvl(FND_GLOBAL.user_id,-1),
275: l_wf_role_name,
276: p_reg_service_code,

Line 273: nvl(FND_GLOBAL.user_id,-1),

269: sysdate,
270: nvl(FND_GLOBAL.user_id,-1),
271: sysdate,
272: nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id),
273: nvl(FND_GLOBAL.user_id,-1),
274: nvl(FND_GLOBAL.user_id,-1),
275: l_wf_role_name,
276: p_reg_service_code,
277: nvl(FND_GLOBAL.resp_appl_id,-1),

Line 274: nvl(FND_GLOBAL.user_id,-1),

270: nvl(FND_GLOBAL.user_id,-1),
271: sysdate,
272: nvl(FND_GLOBAL.conc_login_id,FND_GLOBAL.login_id),
273: nvl(FND_GLOBAL.user_id,-1),
274: nvl(FND_GLOBAL.user_id,-1),
275: l_wf_role_name,
276: p_reg_service_code,
277: nvl(FND_GLOBAL.resp_appl_id,-1),
278: l_ame_transaction_type_id,

Line 277: nvl(FND_GLOBAL.resp_appl_id,-1),

273: nvl(FND_GLOBAL.user_id,-1),
274: nvl(FND_GLOBAL.user_id,-1),
275: l_wf_role_name,
276: p_reg_service_code,
277: nvl(FND_GLOBAL.resp_appl_id,-1),
278: l_ame_transaction_type_id,
279: l_justification
280: );
281: OPEN C1;