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
87: from dual;
88:
89: /* CALL TABLE HANDLER */
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
296: from dual;
297:
298: /* CALL TABLE HANDLER */
782: l_user_id_o := rr_old_rec.user_id;
783: l_user_id_n := p_user_id;
784: end if;
785:
786: select jtf_rs_resource_extn_aud_s.nextval
787: into l_resource_extn_aud_id
788: from dual;
789:
790: /* CALL TABLE HANDLER */
1556:
1557:
1558:
1559:
1560: select jtf_rs_resource_extn_aud_s.nextval
1561: into l_resource_extn_aud_id
1562: from dual;
1563:
1564: /* CALL TABLE HANDLER */
1969: l_source_pager := rr_old_rec.source_pager;
1970: l_user_name := rr_old_rec.user_name;
1971:
1972:
1973: select jtf_rs_resource_extn_aud_s.nextval
1974: into l_resource_extn_aud_id
1975: from dual;
1976:
1977: --CALL TABLE HANDLER