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 1201: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

1197: FND_MSG_PUB.Initialize;
1198: END IF;
1199:
1200: l_date := sysdate;
1201: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1202: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1203:
1204:
1205: open rr_old_cur(p_resource_id);

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

1198: END IF;
1199:
1200: l_date := sysdate;
1201: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1202: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1203:
1204:
1205: open rr_old_cur(p_resource_id);
1206: FETCH rr_old_cur into rr_old_rec;

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

1913: FND_MSG_PUB.Initialize;
1914: END IF;
1915:
1916: l_date := sysdate;
1917: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1918: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1919:
1920:
1921: open rr_old_cur(p_resource_id);

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

1914: END IF;
1915:
1916: l_date := sysdate;
1917: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1918: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1919:
1920:
1921: open rr_old_cur(p_resource_id);
1922: FETCH rr_old_cur into rr_old_rec;