APPS.JTF_UM_USER_ADMIN_PVT dependencies on FND_GLOBAL

Line 7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_UM_USER_ADMIN_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'JTFVUUAB.pls';
6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9: G_MODULE VARCHAR2(40) := 'JTF.UM.PLSQL.USERADMIN';
10: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(G_MODULE);
11:

Line 8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_UM_USER_ADMIN_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'JTFVUUAB.pls';
6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9: G_MODULE VARCHAR2(40) := 'JTF.UM.PLSQL.USERADMIN';
10: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(G_MODULE);
11:
12:

Line 239: last_updated_by = fnd_global.user_id,

235:
236: -- 2. Set the usertype_reg table status to REJECTED
237: UPDATE JTF_UM_USERTYPE_REG
238: SET status_code = 'REJECTED',
239: last_updated_by = fnd_global.user_id,
240: last_update_date = sysdate,
241: last_approver_comment = 'USER DELETED',
242: effective_end_date = sysdate
243: WHERE user_id = l_userid

Line 250: last_updated_by = fnd_global.user_id,

246:
247: -- 3. Find all the PENDING enrollments and set USER_REJECTED.
248: UPDATE JTF_UM_SUBSCRIPTION_REG
249: SET status_code = 'USER_REJECTED',
250: last_updated_by = fnd_global.user_id,
251: last_update_date = sysdate,
252: last_approver_comment = 'USER DELETED',
253: effective_end_date = sysdate
254: WHERE user_id = l_userid

Line 269: last_updated_by = fnd_global.user_id,

265:
266: -- 1. Set the usertype_reg table status to REJECTED
267: UPDATE JTF_UM_USERTYPE_REG
268: SET status_code = 'REJECTED',
269: last_updated_by = fnd_global.user_id,
270: last_update_date = sysdate,
271: last_approver_comment = 'USER DELETED',
272: effective_end_date = sysdate
273: WHERE user_id = l_userid

Line 336: last_updated_by = fnd_global.user_id,

332:
333: -- 2. Find all the PENDING enrollments and set USER_REJECTED.
334: UPDATE JTF_UM_SUBSCRIPTION_REG
335: SET status_code = 'USER_REJECTED',
336: last_updated_by = fnd_global.user_id,
337: last_update_date = sysdate,
338: last_approver_comment = 'USER DELETED',
339: effective_end_date = sysdate
340: WHERE user_id = l_userid

Line 414: l_USER_ID NUMBER := FND_GLOBAL.USER_ID;

410: x_user_reg_id out NOCOPY number,
411: x_approval_id out NOCOPY number) is
412:
413: l_wf_item_type varchar2(200);
414: l_USER_ID NUMBER := FND_GLOBAL.USER_ID;
415: l_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
416: --x_usertype_reg_id NUMBER;
417: l_respKey varchar2(50) := 'JTF_PENDING_APPROVAL';
418: l_status varchar2(10) := 'PENDING';

Line 415: l_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

411: x_approval_id out NOCOPY number) is
412:
413: l_wf_item_type varchar2(200);
414: l_USER_ID NUMBER := FND_GLOBAL.USER_ID;
415: l_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
416: --x_usertype_reg_id NUMBER;
417: l_respKey varchar2(50) := 'JTF_PENDING_APPROVAL';
418: l_status varchar2(10) := 'PENDING';
419: l_application_id number := 690;