DBA Data[Home] [Help]

APPS.AHL_VENDORMERGE_GRP dependencies on AHL_VENDOR_CUSTOMER_RELS

Line 86: UPDATE ahl_vendor_customer_rels

82: WHERE vendor_id = p_dup_vendor_id
83: AND vendor_site_id = p_dup_vendor_site_id;
84:
85: -- OSP Vendor Table
86: UPDATE ahl_vendor_customer_rels
87: SET vendor_site_id = p_vendor_site_id,
88: last_updated_by = FND_GLOBAL.user_id,
89: last_update_date = SYSDATE
90: WHERE vendor_site_id = p_dup_vendor_site_id;

Line 100: -- update table ahl_vendor_customer_rels(vendor_site_id, customer_site_id).

96: last_update_date = SYSDATE
97: WHERE supplier_id = p_dup_vendor_id;
98:
99: -- Parameter party_id and party_site_id are included, but not sure whether we need to
100: -- update table ahl_vendor_customer_rels(vendor_site_id, customer_site_id).
101:
102: -- Standard check of p_commit.
103: IF FND_API.To_Boolean(p_commit) THEN
104: COMMIT WORK;