APPS.IGI_CIS2007_IGIPVERP_PKG dependencies on AP_SUPPLIERS

Line 6: l_awt_group_id ap_suppliers.awt_group_id%TYPE;

2: -- $Header: igipverb.pls 120.2.12010000.3 2008/12/19 13:43:28 gaprasad ship $
3:
4: /* PO API to update the CORE tables */
5: PROCEDURE pr_po_core_update(p_header_id IN NUMBER) IS
6: l_awt_group_id ap_suppliers.awt_group_id%TYPE;
7: l_match_flag ap_suppliers.match_status_flag%TYPE;
8: l_request_id ap_suppliers.verification_request_id%TYPE;
9: CURSOR cur_igi_cis_verify_headers IS
10: SELECT vendor_id,

Line 7: l_match_flag ap_suppliers.match_status_flag%TYPE;

3:
4: /* PO API to update the CORE tables */
5: PROCEDURE pr_po_core_update(p_header_id IN NUMBER) IS
6: l_awt_group_id ap_suppliers.awt_group_id%TYPE;
7: l_match_flag ap_suppliers.match_status_flag%TYPE;
8: l_request_id ap_suppliers.verification_request_id%TYPE;
9: CURSOR cur_igi_cis_verify_headers IS
10: SELECT vendor_id,
11: verification_number,

Line 8: l_request_id ap_suppliers.verification_request_id%TYPE;

4: /* PO API to update the CORE tables */
5: PROCEDURE pr_po_core_update(p_header_id IN NUMBER) IS
6: l_awt_group_id ap_suppliers.awt_group_id%TYPE;
7: l_match_flag ap_suppliers.match_status_flag%TYPE;
8: l_request_id ap_suppliers.verification_request_id%TYPE;
9: CURSOR cur_igi_cis_verify_headers IS
10: SELECT vendor_id,
11: verification_number,
12: match_status,

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 280: UPDATE ap_suppliers pov

276:
277: BEGIN
278: /* Updating the AWT Group id for the vendor */
279:
280: UPDATE ap_suppliers pov
281: SET pov.verification_number = decode(p_verification_no,
282: NULL,
283: pov.verification_number,
284: p_verification_no),

Line 351: UPDATE ap_suppliers pov

347: p_sc_ref_id))
348: WHERE pov.vendor_id = p_vendor_id;
349:
350: /* Updating the debt factor vendors of the parent vendor */
351: UPDATE ap_suppliers pov
352: SET pov.awt_group_id = p_awt_group_id,
353: pov.pay_awt_group_id = p_awt_group_id, /* Also Updating the PAY_AWT_GROUP_ID for Bug#7218825 */
354: pov.allow_awt_flag = 'Y'
355: WHERE pov.cis_parent_vendor_id = p_vendor_id

Line 390: FROM ap_suppliers pov

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
391: WHERE pov.cis_parent_vendor_id = p_vendor_id
392: AND pov.vendor_type_lookup_code NOT IN
393: ('SOLETRADER', 'PARTNERSHIP', 'TRUST', 'COMPANY'))
394: AND povs.org_id = l_org_id

Line 414: FROM ap_suppliers pov

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
415: WHERE pov.cis_parent_vendor_id = p_vendor_id
416: AND pov.vendor_type_lookup_code NOT IN
417: ('SOLETRADER', 'PARTNERSHIP', 'TRUST', 'COMPANY'))
418: AND povs.org_id = l_org_id

Line 442: FROM ap_suppliers pov

438: povs.pay_awt_group_id = p_awt_group_id,
439: povs.allow_awt_flag = 'Y'
440: WHERE povs.vendor_id IN
441: (SELECT pov.vendor_id
442: FROM ap_suppliers pov
443: WHERE pov.cis_parent_vendor_id = p_vendor_id
444: AND pov.vendor_type_lookup_code NOT IN
445: ('SOLETRADER', 'PARTNERSHIP', 'TRUST', 'COMPANY'))
446: AND povs.org_id = l_org_id