DBA Data[Home] [Help]

APPS.JTF_RS_DYNAMIC_GROUPS_PUB dependencies on FND_PROFILE

Line 95: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

91: END IF;
92:
93: --GET USER ID AND SYSDATE
94: l_date := sysdate;
95: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
96: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
97:
98: -- Commented the below code to validate usage since it is calling from pvt API
99: --call usage validation

Line 96: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

92:
93: --GET USER ID AND SYSDATE
94: l_date := sysdate;
95: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
96: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
97:
98: -- Commented the below code to validate usage since it is calling from pvt API
99: --call usage validation
100:

Line 275: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

271: END IF;
272:
273: --GET USER ID AND SYSDATE
274: l_date := sysdate;
275: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
276: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
277:
278:
279: --call private api for insert

Line 276: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

272:
273: --GET USER ID AND SYSDATE
274: l_date := sysdate;
275: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
276: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
277:
278:
279: --call private api for insert
280: jtf_rs_dynamic_groups_pvt.update_dynamic_groups(

Line 409: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

405: END IF;
406:
407: --GET USER ID AND SYSDATE
408: l_date := sysdate;
409: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
410: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
411:
412:
413: --call private api for delete

Line 410: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);

406:
407: --GET USER ID AND SYSDATE
408: l_date := sysdate;
409: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
410: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
411:
412:
413: --call private api for delete
414: jtf_rs_dynamic_groups_pvt.delete_dynamic_groups(