APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on AP_SUPPLIER_CONTACTS

Line 977: Add last update values to the ap_supplier_contacts update */

973: /* Bug 9639308 Procedure rewritten to check for existing org contacts and relationships,
974: Improve error handling,
975: Remove the commit
976: Streamline c_contact_point cursor
977: Add last update values to the ap_supplier_contacts update */
978: -- Bug 7297864- End
979: CURSOR c_contact_point (l_dup_from_party_id NUMBER, l_per_party_id NUMBER) /* bug 9604355 */
980: IS
981: select hcpp.contact_point_id contact_point_id,

Line 1021: FROM ap_supplier_contacts

1017: per_party_id,
1018: org_party_site_id,
1019: org_contact_id,
1020: party_site_id
1021: FROM ap_supplier_contacts
1022: WHERE org_party_site_id = p_from_party_site_id
1023: )
1024: LOOP
1025:

Line 1045: FROM ap_supplier_contacts apc

1041: -- First check if relation already exists for the contact and supplier that we are trying to link. If so, no need to create new relationship.
1042: BEGIN
1043: SELECT vendor_contact_id
1044: INTO l_new_vendor_contact_id
1045: FROM ap_supplier_contacts apc
1046: WHERE per_party_id = l_relationship_rec.subject_id
1047: --AND NVL(org_party_site_id, -1) = contact_loop_c.to_party_site_id;
1048: AND NVL(org_party_site_id, -1) = p_to_party_site_id;
1049: EXCEPTION

Line 1326: FND_FILE.Put_Line(FND_FILE.Log,'before creating ap_supplier_contacts');

1322: END;
1323: END LOOP;
1324:
1325: END;
1326: FND_FILE.Put_Line(FND_FILE.Log,'before creating ap_supplier_contacts');
1327: FND_FILE.Put_Line(FND_FILE.Log,'contact_loop_c.vendor_contact_id '
1328: ||contact_loop_c.vendor_contact_id);
1329:
1330: BEGIN

Line 1333: --UPDATE ap_supplier_contacts

1329:
1330: BEGIN
1331: /* Bug 9559145 -- commenting below and writing new insert statement*/
1332:
1333: --UPDATE ap_supplier_contacts
1334: --SET org_party_site_id = p_to_party_site_id,
1335: -- rel_party_id = l_party_id,
1336: -- relationship_id = l_relationship_id,
1337: -- party_site_id = l_party_site_id,

Line 1349: INSERT INTO AP_SUPPLIER_CONTACTS

1345: --WHERE vendor_contact_id = contact_loop_c.vendor_contact_id;
1346:
1347: FND_FILE.Put_Line(FND_FILE.Log,'creating new contact for to_party');
1348:
1349: INSERT INTO AP_SUPPLIER_CONTACTS
1350: ( VENDOR_CONTACT_ID,
1351: LAST_UPDATE_DATE,
1352: LAST_UPDATED_BY,
1353: VENDOR_SITE_ID,

Line 1455: FROM AP_SUPPLIER_CONTACTS

1451: l_party_id,
1452: l_party_site_id,
1453: l_org_contact_id,
1454: p_to_party_site_id
1455: FROM AP_SUPPLIER_CONTACTS
1456: WHERE vendor_contact_id = contact_loop_c.vendor_contact_id;
1457:
1458: FND_FILE.Put_Line(FND_FILE.Log,'No.of rows inserted '||SQL%ROWCOUNT);
1459: