DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_EXTNS_AUD_PVT dependencies on FND_PROFILE

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

77: FND_MSG_PUB.Initialize;
78: END IF;
79:
80: l_date := sysdate;
81: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
82: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
83:
84:
85: select jtf_rs_resource_extn_aud_s.nextval

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

78: END IF;
79:
80: l_date := sysdate;
81: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
82: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
83:
84:
85: select jtf_rs_resource_extn_aud_s.nextval
86: into l_resource_extn_aud_id

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

286: FND_MSG_PUB.Initialize;
287: END IF;
288:
289: l_date := sysdate;
290: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
291: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
292:
293:
294: select jtf_rs_resource_extn_aud_s.nextval

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

287: END IF;
288:
289: l_date := sysdate;
290: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
291: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
292:
293:
294: select jtf_rs_resource_extn_aud_s.nextval
295: into l_resource_extn_aud_id

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

628: FND_MSG_PUB.Initialize;
629: END IF;
630:
631: l_date := sysdate;
632: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
633: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
634:
635:
636: open rr_old_cur(p_resource_id);

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

629: END IF;
630:
631: l_date := sysdate;
632: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
633: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
634:
635:
636: open rr_old_cur(p_resource_id);
637: FETCH rr_old_cur into rr_old_rec;

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

1189: FND_MSG_PUB.Initialize;
1190: END IF;
1191:
1192: l_date := sysdate;
1193: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1194: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1195:
1196:
1197: open rr_old_cur(p_resource_id);

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

1190: END IF;
1191:
1192: l_date := sysdate;
1193: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1194: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1195:
1196:
1197: open rr_old_cur(p_resource_id);
1198: FETCH rr_old_cur into rr_old_rec;

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

1899: FND_MSG_PUB.Initialize;
1900: END IF;
1901:
1902: l_date := sysdate;
1903: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1904: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1905:
1906:
1907: open rr_old_cur(p_resource_id);

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

1900: END IF;
1901:
1902: l_date := sysdate;
1903: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1904: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1905:
1906:
1907: open rr_old_cur(p_resource_id);
1908: FETCH rr_old_cur into rr_old_rec;