APPS.AP_VENDOR_PUB_PKG dependencies on AP_SUPPLIER_CONTACTS

Line 14714: INSERT INTO ap_supplier_contacts(

14710: SELECT po_vendor_contacts_s.nextval
14711: INTO l_vendor_contact_rec.vendor_contact_id
14712: FROM dual;
14713:
14714: INSERT INTO ap_supplier_contacts(
14715: per_party_id,
14716: relationship_id,
14717: rel_party_id,
14718: party_site_id,

Line 14924: UPDATE ap_supplier_contacts set

14920: p_vendor_contact_rec.ORG_PARTY_SITE_ID IS NOT NULL AND
14921: p_vendor_contact_rec.VENDOR_CONTACT_ID IS NOT NULL
14922: )
14923: THEN
14924: UPDATE ap_supplier_contacts set
14925: last_update_date = SYSDATE,
14926: last_updated_by = g_user_id,
14927: last_update_login = g_login_id,
14928: inactive_date =p_vendor_contact_rec.inactive_date

Line 15443: from ap_supplier_contacts

15439:
15440: IF x_per_party_valid <> 'N' THEN
15441: BEGIN
15442: Select org_contact_id into p_vendor_contact_rec.org_contact_id
15443: from ap_supplier_contacts
15444: where per_party_id = p_vendor_contact_rec.per_party_id
15445: and relationship_id = p_vendor_contact_rec.relationship_id
15446: and rel_party_id = p_vendor_contact_rec.rel_party_id
15447: and rownum < 2 ;

Line 15456: -- exists in ap_supplier_contacts

15452: END IF ;
15453:
15454: IF x_per_party_valid <> 'N' THEN
15455: --check if same combination of per_party_id / org_party_site_id
15456: -- exists in ap_supplier_contacts
15457: Select count(*) into l_combo_ct from ap_supplier_contacts
15458: where per_party_id = p_vendor_contact_rec.per_party_id
15459: and relationship_id = p_vendor_contact_rec.relationship_id
15460: and rel_party_id = p_vendor_contact_rec.rel_party_id

Line 15457: Select count(*) into l_combo_ct from ap_supplier_contacts

15453:
15454: IF x_per_party_valid <> 'N' THEN
15455: --check if same combination of per_party_id / org_party_site_id
15456: -- exists in ap_supplier_contacts
15457: Select count(*) into l_combo_ct from ap_supplier_contacts
15458: where per_party_id = p_vendor_contact_rec.per_party_id
15459: and relationship_id = p_vendor_contact_rec.relationship_id
15460: and rel_party_id = p_vendor_contact_rec.rel_party_id
15461: and NVL(org_party_site_id, -1) = NVL(p_vendor_contact_rec.org_party_site_id, -1) ;

Line 17844: l_event_vendor_contact_id AP_SUPPLIER_CONTACTS.vendor_contact_id%TYPE; --Bug 7307669

17840: IS
17841: l_api_name CONSTANT VARCHAR2(30) := 'Update_Address_Assignments_DFF';
17842: l_api_version CONSTANT NUMBER := 1.0;
17843: l_count NUMBER := 0;
17844: l_event_vendor_contact_id AP_SUPPLIER_CONTACTS.vendor_contact_id%TYPE; --Bug 7307669
17845: BEGIN
17846:
17847: -- Standard Start of API savepoint
17848: SAVEPOINT Update_Address_Assign_DFF_PUB;

Line 17877: UPDATE ap_supplier_contacts

17873: || ', org_party_site_id: '|| p_org_party_site_id);
17874: END IF;
17875:
17876:
17877: UPDATE ap_supplier_contacts
17878: SET attribute_category=p_attribute_category,
17879: attribute1 = p_attribute1,
17880: attribute2 = p_attribute2,
17881: attribute3 = p_attribute3,

Line 17911: FROM ap_supplier_contacts

17907:
17908: BEGIN -- Bug 7307669 : Begin
17909: SELECT vendor_contact_id
17910: INTO l_event_vendor_contact_id
17911: FROM ap_supplier_contacts
17912: WHERE per_party_id=p_contact_party_id
17913: AND org_party_site_id=p_org_party_site_id
17914: AND NVL(inactive_date, SYSDATE+1 ) > SYSDATE ;
17915: