APPS.JTF_RS_PARTY_MERGE_PUB dependencies on JTF_RS_RESOURCE_EXTN_AUD

Line 215: insert into JTF_RS_RESOURCE_EXTN_AUD (

211: -- x_to_id := p_from_id;
212:
213: if(nvl(l_address_id, fnd_api.g_miss_num) <> nvl(cat_rec.address_id, fnd_api.g_miss_num))
214: then
215: insert into JTF_RS_RESOURCE_EXTN_AUD (
216: RESOURCE_AUDIT_ID,
217: RESOURCE_ID,
218: OLD_SOURCE_ID,
219: NEW_SOURCE_ID,

Line 230: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,

226: LAST_UPDATED_BY,
227: LAST_UPDATE_DATE,
228: LAST_UPDATE_LOGIN
229: ) values (
230: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,
231: cat_rec.resource_id,
232: p_from_fk_id,
233: p_to_fk_id,
234: cat_rec.address_id,

Line 245: insert into JTF_RS_RESOURCE_EXTN_AUD (

241: l_date,
242: l_login_id
243: );
244: else
245: insert into JTF_RS_RESOURCE_EXTN_AUD (
246: RESOURCE_AUDIT_ID,
247: RESOURCE_ID,
248: OLD_SOURCE_ID,
249: NEW_SOURCE_ID,

Line 258: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,

254: LAST_UPDATED_BY,
255: LAST_UPDATE_DATE,
256: LAST_UPDATE_LOGIN
257: ) values (
258: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,
259: cat_rec.resource_id,
260: p_from_fk_id,
261: p_to_fk_id,
262: cat_rec.object_version_number + 1,

Line 374: insert into JTF_RS_RESOURCE_EXTN_AUD (

370: -- x_to_id := p_from_id;
371:
372: if(nvl(l_address_id, fnd_api.g_miss_num) <> nvl(cat_rec.address_id, fnd_api.g_miss_num))
373: then
374: insert into JTF_RS_RESOURCE_EXTN_AUD (
375: RESOURCE_AUDIT_ID,
376: RESOURCE_ID,
377: OLD_SOURCE_ID,
378: NEW_SOURCE_ID,

Line 389: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,

385: LAST_UPDATED_BY,
386: LAST_UPDATE_DATE,
387: LAST_UPDATE_LOGIN
388: ) values (
389: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,
390: cat_rec.resource_id,
391: p_from_fk_id,
392: p_to_fk_id,
393: cat_rec.address_id,

Line 404: insert into JTF_RS_RESOURCE_EXTN_AUD (

400: l_date,
401: l_login_id
402: );
403: else
404: insert into JTF_RS_RESOURCE_EXTN_AUD (
405: RESOURCE_AUDIT_ID,
406: RESOURCE_ID,
407: OLD_SOURCE_ID,
408: NEW_SOURCE_ID,

Line 417: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,

413: LAST_UPDATED_BY,
414: LAST_UPDATE_DATE,
415: LAST_UPDATE_LOGIN
416: ) values (
417: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,
418: cat_rec.resource_id,
419: p_from_fk_id,
420: p_to_fk_id,
421: cat_rec.object_version_number + 1,

Line 630: insert into JTF_RS_RESOURCE_EXTN_AUD (

626: object_version_number = object_version_number + 1
627: where resource_id = from_rec.resource_id;
628: -- x_to_id := p_from_id;
629:
630: insert into JTF_RS_RESOURCE_EXTN_AUD (
631: RESOURCE_AUDIT_ID,
632: RESOURCE_ID,
633: OLD_ADDRESS_ID,
634: NEW_ADDRESS_ID,

Line 643: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,

639: LAST_UPDATED_BY,
640: LAST_UPDATE_DATE,
641: LAST_UPDATE_LOGIN
642: ) values (
643: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,
644: from_rec.resource_id,
645: p_from_fk_id,
646: p_to_fk_id,
647: from_rec.object_version_number + 1,

Line 788: insert into JTF_RS_RESOURCE_EXTN_AUD (

784:
785: -- x_to_id := p_from_id;
786:
787:
788: insert into JTF_RS_RESOURCE_EXTN_AUD (
789: RESOURCE_AUDIT_ID,
790: RESOURCE_ID,
791: OLD_CONTACT_ID,
792: NEW_CONTACT_ID,

Line 801: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,

797: LAST_UPDATED_BY,
798: LAST_UPDATE_DATE,
799: LAST_UPDATE_LOGIN
800: ) values (
801: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,
802: res_rec.resource_id,
803: p_from_fk_id,
804: p_to_fk_id,
805: res_rec.object_version_number + 1,

Line 1244: insert into JTF_RS_RESOURCE_EXTN_AUD (

1240: where resource_id = res_rec.resource_id;
1241:
1242: -- x_to_id := p_from_id;
1243:
1244: insert into JTF_RS_RESOURCE_EXTN_AUD (
1245: RESOURCE_AUDIT_ID,
1246: RESOURCE_ID,
1247: OLD_SUPPORT_SITE_ID,
1248: NEW_SUPPORT_SITE_ID,

Line 1257: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,

1253: LAST_UPDATED_BY,
1254: LAST_UPDATE_DATE,
1255: LAST_UPDATE_LOGIN
1256: ) values (
1257: JTF_RS_RESOURCE_EXTN_AUD_S.NEXTVAL,
1258: res_rec.resource_id,
1259: p_from_fk_id,
1260: p_to_fk_id,
1261: res_rec.object_version_number + 1,