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
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
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
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
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);
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;
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);
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;
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);
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;