DBA Data[Home] [Help]

APPS.AP_PARTYMERGE_GRP dependencies on AP_SUPPLIER_CONTACTS

Line 592: UPDATE ap_supplier_contacts

588: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
590: END IF;
591:
592: UPDATE ap_supplier_contacts
593: --po_vendor_contacts
594: SET per_party_id = new_per_party_id
595: WHERE per_party_id = old_per_party_id;
596:

Line 650: UPDATE ap_supplier_contacts

646: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
648: END IF;
649:
650: UPDATE ap_supplier_contacts
651: --po_vendor_contacts
652: SET rel_party_id = new_rel_party_id
653: WHERE rel_party_id = old_rel_party_id;
654:

Line 708: UPDATE ap_supplier_contacts

704: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
706: END IF;
707:
708: UPDATE ap_supplier_contacts
709: -- po_vendor_contacts
710: SET party_site_id = new_party_site_id
711: WHERE party_site_id = old_party_site_id;
712:

Line 763: UPDATE ap_supplier_contacts

759: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
760: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
761: END IF;
762:
763: UPDATE ap_supplier_contacts
764: SET relationship_id = new_relship_id
765: WHERE relationship_id = old_relship_id;
766:
767: EXCEPTION

Line 817: UPDATE ap_supplier_contacts

813: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
814: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
815: END IF;
816:
817: UPDATE ap_supplier_contacts
818: SET org_contact_id = new_orgcontact_id
819: WHERE org_contact_id = old_orgcontact_id;
820:
821: EXCEPTION