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