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
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:
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
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(
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
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(