APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_RESOURCE_EXTN_AUD

Line 1752: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1751:
1752: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1753: l_row_id varchar2(24) := null;
1754: /* Moved the initial assignment of below variables to inside begin */
1755: l_is_to_be_updated varchar2(1);
1756: l_update_extn varchar2(1);

Line 3068: select jtf_rs_resource_extn_aud_s.nextval

3064: --update the jtf_rs_resource_extns.
3065: if (l_is_to_be_updated = 'Y') then
3066:
3067: ---fnd_file.put_line(fnd_file.log,'resource id:' || l_c_resource.resource_id);
3068: select jtf_rs_resource_extn_aud_s.nextval
3069: into l_resource_extn_aud_id
3070: from dual;
3071:
3072: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW

Line 3072: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW

3068: select jtf_rs_resource_extn_aud_s.nextval
3069: into l_resource_extn_aud_id
3070: from dual;
3071:
3072: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW
3073: (
3074: X_ROWID => l_row_id ,
3075: x_resource_audit_id => l_resource_extn_aud_id ,
3076: x_resource_id => l_c_resource.resource_id ,