APPS.AP_VENDOR_PUB_PKG dependencies on AP_SUPPLIER_CONTACTS

Line 11923: INSERT INTO ap_supplier_contacts(

11919: SELECT po_vendor_contacts_s.nextval
11920: INTO l_vendor_contact_rec.vendor_contact_id
11921: FROM dual;
11922:
11923: INSERT INTO ap_supplier_contacts(
11924: per_party_id,
11925: relationship_id,
11926: rel_party_id,
11927: party_site_id,

Line 12114: UPDATE ap_supplier_contacts set

12110: p_vendor_contact_rec.ORG_PARTY_SITE_ID IS NOT NULL AND
12111: p_vendor_contact_rec.VENDOR_CONTACT_ID IS NOT NULL
12112: )
12113: THEN
12114: UPDATE ap_supplier_contacts set
12115: last_update_date = SYSDATE,
12116: last_updated_by = g_user_id,
12117: last_update_login = g_login_id,
12118: inactive_date =p_vendor_contact_rec.inactive_date

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

14207: IS
14208: l_api_name CONSTANT VARCHAR2(30) := 'Update_Address_Assignments_DFF';
14209: l_api_version CONSTANT NUMBER := 1.0;
14210: l_count NUMBER := 0;
14211: l_event_vendor_contact_id AP_SUPPLIER_CONTACTS.vendor_contact_id%TYPE; --Bug 7307669
14212: BEGIN
14213:
14214: -- Standard Start of API savepoint
14215: SAVEPOINT Update_Address_Assign_DFF_PUB;

Line 14244: UPDATE ap_supplier_contacts

14240: || ', org_party_site_id: '|| p_org_party_site_id);
14241: END IF;
14242:
14243:
14244: UPDATE ap_supplier_contacts
14245: SET attribute_category=p_attribute_category,
14246: attribute1 = p_attribute1,
14247: attribute2 = p_attribute2,
14248: attribute3 = p_attribute3,

Line 14278: FROM ap_supplier_contacts

14274:
14275: BEGIN -- Bug 7307669 : Begin
14276: SELECT vendor_contact_id
14277: INTO l_event_vendor_contact_id
14278: FROM ap_supplier_contacts
14279: WHERE per_party_id=p_contact_party_id
14280: AND org_party_site_id=p_org_party_site_id
14281: AND NVL(inactive_date, SYSDATE+1 ) > SYSDATE ;
14282: