APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_RESOURCE_EXTN_AUD

Line 1684: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

1680: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1681: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1682: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1683:
1684: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1685: l_row_id varchar2(24) := null;
1686: /* Moved the initial assignment of below variables to inside begin */
1687: l_is_to_be_updated varchar2(1);
1688: l_update_extn varchar2(1);

Line 2617: select jtf_rs_resource_extn_aud_s.nextval

2613: --update the jtf_rs_resource_extns.
2614: if (l_is_to_be_updated = 'Y') then
2615:
2616: ---fnd_file.put_line(fnd_file.log,'resource id:' || l_c_resource.resource_id);
2617: select jtf_rs_resource_extn_aud_s.nextval
2618: into l_resource_extn_aud_id
2619: from dual;
2620:
2621: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW

Line 2621: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW

2617: select jtf_rs_resource_extn_aud_s.nextval
2618: into l_resource_extn_aud_id
2619: from dual;
2620:
2621: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW
2622: (
2623: X_ROWID => l_row_id ,
2624: x_resource_audit_id => l_resource_extn_aud_id ,
2625: x_resource_id => l_c_resource.resource_id ,