[Home] [Help]
62: dv.paid_invoices_flag C_PAID_INVOICES_FLAG,
63: a.segment1 C_NEW_VENDOR_NUMBER,
64: b.segment1 C_OLD_VENDOR_NUMBER
65: FROM ap_duplicate_vendors_all dv,
66: ap_suppliers a,
67: ap_suppliers b,
68: ap_supplier_sites_all c,
69: ap_supplier_sites_all d
70: WHERE dv.process_flag='S'
63: a.segment1 C_NEW_VENDOR_NUMBER,
64: b.segment1 C_OLD_VENDOR_NUMBER
65: FROM ap_duplicate_vendors_all dv,
66: ap_suppliers a,
67: ap_suppliers b,
68: ap_supplier_sites_all c,
69: ap_supplier_sites_all d
70: WHERE dv.process_flag='S'
71: AND a.vendor_id=dv.vendor_id
97: dv.paid_invoices_flag C_PAID_INVOICES_FLAG,
98: a.segment1 C_NEW_VENDOR_NUMBER,
99: b.segment1 C_OLD_VENDOR_NUMBER
100: FROM ap_duplicate_vendors_all dv,
101: ap_suppliers a,
102: ap_suppliers b,
103: ap_supplier_sites_all c,
104: ap_supplier_sites_all d
105: WHERE dv.process_flag in ('S','D')
98: a.segment1 C_NEW_VENDOR_NUMBER,
99: b.segment1 C_OLD_VENDOR_NUMBER
100: FROM ap_duplicate_vendors_all dv,
101: ap_suppliers a,
102: ap_suppliers b,
103: ap_supplier_sites_all c,
104: ap_supplier_sites_all d
105: WHERE dv.process_flag in ('S','D')
106: AND a.vendor_id=dv.vendor_id
177: FND_FILE.Put_Line(FND_FILE.Log,'Calling IBY API - Start');
178:
179: SELECT count(apps.vendor_site_id)
180: INTO l_active_site_count
181: FROM ap_suppliers aps, ap_supplier_sites_all apps
182: WHERE aps.vendor_id = l_invoice_row.C_DUP_VENDOR_ID
183: AND aps.vendor_id = apps.vendor_id
184: AND apps.vendor_site_id <> l_invoice_row.C_DUP_VENDOR_SITE_ID
185: AND apps.pay_site_flag = 'Y'
1034: l_relationship_rec.object_table_name := 'HZ_PARTIES';
1035: l_relationship_rec.relationship_code := 'CONTACT_OF';
1036: l_relationship_rec.relationship_type := 'CONTACT';
1037: l_relationship_rec.status := 'A';
1038: l_relationship_rec.created_by_module:='AP_SUPPLIERS_API';
1039:
1040: -- Added the following code for bug 9639308
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
1112: l_org_contact_rec.rank
1113: FROM hz_org_contacts
1114: WHERE org_contact_id = contact_loop_c.org_contact_id;
1115:
1116: l_org_contact_rec.created_by_module := 'AP_SUPPLIERS_API';
1117: l_org_contact_rec.party_rel_rec := l_relationship_rec;
1118:
1119: FND_FILE.Put_Line(FND_FILE.Log,'Inside if clause before calling hz_party_contact_v2pub.create_org_contact');
1120:
1166: FROM hz_party_sites
1167: WHERE party_site_id = contact_loop_c.party_site_id;
1168:
1169: l_party_site_rec.location_id := l_location_id;
1170: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';
1171: l_party_site_rec.application_id := 200;
1172: l_party_site_rec.party_id := l_party_id;
1173:
1174: BEGIN
1295: FROM hz_contact_points
1296: WHERE contact_point_id = contact_point_loop_c.contact_point_id;
1297:
1298: l_contact_point_rec.owner_table_id := l_party_id;
1299: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';
1300:
1301: -- Creation of new contact points with new party_id
1302: hz_contact_point_v2pub.Create_contact_point('T',l_contact_point_rec,l_edi_rec,l_email_rec,
1303: l_phone_rec,l_telex_rec,l_web_rec,l_contact_point_id,
1547: FROM hz_contact_points
1548: WHERE contact_point_id = contact_point_loop_c.contact_point_id;
1549:
1550: l_contact_point_rec.owner_table_id := p_to_party_site_id;
1551: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';
1552:
1553: -- Creation of new contact points with new party_site_id
1554: hz_contact_point_v2pub.Create_contact_point('T',l_contact_point_rec,l_edi_rec,l_email_rec,
1555: l_phone_rec,l_telex_rec,l_web_rec,l_contact_point_id,