APPS.IGI_CIS2007_IGIPVERP_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 73: /* calling PO API to update PO tables - AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL */

69: p_source => 'VERIFY',
70: p_effective_date =>cur_igi_cis_verify_headers_rec.cis_verification_date
71: );
72:
73: /* calling PO API to update PO tables - AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL */
74: pr_po_api(cur_igi_cis_verify_headers_rec.vendor_id,
75: cur_igi_cis_verify_headers_rec.verification_number,
76: l_match_flag,
77: cur_igi_cis_verify_headers_rec.cis_verification_date,

Line 245: /* PO API to update AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL */

241: EXCEPTION
242: WHEN no_data_found THEN
243: RETURN 'NOTPAID';
244: END igi_cis_is_vendor_paid;
245: /* PO API to update AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL */
246: PROCEDURE pr_po_api
247: (
248: p_vendor_id IN NUMBER,
249: p_verification_no IN VARCHAR2,

Line 262: l_org_id ap_supplier_sites_all.org_id%TYPE;

258: ) IS
259:
260: /* Bug#7218825 - CIS WITHHOLDING PROJECT DUE TO AP ENHANCEMENT 6639866 ON 12.1 */
261:
262: l_org_id ap_supplier_sites_all.org_id%TYPE;
263: l_create_awt_dists_type ap_system_parameters_all.CREATE_AWT_DISTS_TYPE%TYPE;
264:
265: Cursor c_povs_orgs(c_vendor_id NUMBER) is
266: select distinct org_id

Line 267: from ap_supplier_sites_all

263: l_create_awt_dists_type ap_system_parameters_all.CREATE_AWT_DISTS_TYPE%TYPE;
264:
265: Cursor c_povs_orgs(c_vendor_id NUMBER) is
266: select distinct org_id
267: from ap_supplier_sites_all
268: where vendor_id = c_vendor_id
269: and upper(allow_awt_flag) = 'Y';
270:
271: Cursor c_awt_type(c_org_id NUMBER) is

Line 378: UPDATE ap_supplier_sites_all povs

374: then
375:
376: /* Updating all the vendor sites of the vendor */
377:
378: UPDATE ap_supplier_sites_all povs
379: SET povs.awt_group_id = p_awt_group_id, povs.allow_awt_flag = 'Y'
380: WHERE povs.vendor_id = p_vendor_id
381: AND povs.org_id = l_org_id
382: AND povs.allow_awt_flag = 'Y'; --Bug 5642191

Line 386: UPDATE ap_supplier_sites_all povs

382: AND povs.allow_awt_flag = 'Y'; --Bug 5642191
383:
384: /* Updating all the vendor sites of the debt factor vendors */
385:
386: UPDATE ap_supplier_sites_all povs
387: SET povs.awt_group_id = p_awt_group_id, povs.allow_awt_flag = 'Y'
388: WHERE povs.vendor_id IN
389: (SELECT pov.vendor_id
390: FROM ap_suppliers pov

Line 402: UPDATE ap_supplier_sites_all povs

398: then
399:
400: /* Updating all the vendor sites of the vendor */
401:
402: UPDATE ap_supplier_sites_all povs
403: SET povs.pay_awt_group_id = p_awt_group_id, povs.allow_awt_flag = 'Y'
404: WHERE povs.vendor_id = p_vendor_id
405: AND povs.org_id = l_org_id
406: AND povs.allow_awt_flag = 'Y'; --Bug 5642191

Line 410: UPDATE ap_supplier_sites_all povs

406: AND povs.allow_awt_flag = 'Y'; --Bug 5642191
407:
408: /* Updating all the vendor sites of the debt factor vendors */
409:
410: UPDATE ap_supplier_sites_all povs
411: SET povs.pay_awt_group_id = p_awt_group_id, povs.allow_awt_flag = 'Y'
412: WHERE povs.vendor_id IN
413: (SELECT pov.vendor_id
414: FROM ap_suppliers pov

Line 426: UPDATE ap_supplier_sites_all povs

422: then
423:
424: /* Updating all the vendor sites of the vendor */
425:
426: UPDATE ap_supplier_sites_all povs
427: SET povs.awt_group_id = p_awt_group_id,
428: povs.pay_awt_group_id = p_awt_group_id,
429: povs.allow_awt_flag = 'Y'
430: WHERE povs.vendor_id = p_vendor_id

Line 436: UPDATE ap_supplier_sites_all povs

432: AND povs.allow_awt_flag = 'Y'; --Bug 5642191
433:
434: /* Updating all the vendor sites of the debt factor vendors */
435:
436: UPDATE ap_supplier_sites_all povs
437: SET povs.awt_group_id = p_awt_group_id,
438: povs.pay_awt_group_id = p_awt_group_id,
439: povs.allow_awt_flag = 'Y'
440: WHERE povs.vendor_id IN