APPS.IGI_CIS2007_UTIL_PKG dependencies on AP_SUPPLIERS

Line 15: p_vendor_id IN ap_suppliers.vendor_id%TYPE,

11: * Note: This procedure is called from package AP_VENDORS_PKG (apvndhrb.pls)
12: * Care should be taken while modifying this package
13: */
14: PROCEDURE SUPPLIER_UPDATE(
15: p_vendor_id IN ap_suppliers.vendor_id%TYPE,
16: p_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE,
17: p_pay_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE /* Bug 7218825 */
18: )
19: IS

Line 61: p_vendor_id IN ap_suppliers.vendor_id%TYPE,

57: * Note: This procedure is called from package AP_VENDOR_SITES_PKG (apvndsib.pls)
58: * Care should be taken while modifying this package
59: */
60: PROCEDURE SUPPLIER_SITE_UPDATE(
61: p_vendor_id IN ap_suppliers.vendor_id%TYPE,
62: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%TYPE,
63: p_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE,
64: p_pay_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE /* Bug 7218825 */
65: )

Line 89: l_awt_group_id_po ap_suppliers.awt_group_id%TYPE;

85: FUNCTION get_payables_option_based_awt(l_vendor_id NUMBER,l_vendor_site_id NUMBER,l_tax_grp_id NUMBER,l_pay_tax_grp_id NUMBER)
86: RETURN NUMBER IS
87:
88: l_org_id ap_supplier_sites_all.org_id%TYPE;
89: l_awt_group_id_po ap_suppliers.awt_group_id%TYPE;
90: l_pay_awt_group_id_po ap_suppliers.pay_awt_group_id%TYPE;
91: l_awt_group_id_pvs ap_supplier_sites_all.awt_group_id%TYPE;
92: l_pay_awt_group_id_pvs ap_supplier_sites_all.pay_awt_group_id%TYPE;
93: l_create_awt_dists_type ap_system_parameters_all.CREATE_AWT_DISTS_TYPE%TYPE;

Line 90: l_pay_awt_group_id_po ap_suppliers.pay_awt_group_id%TYPE;

86: RETURN NUMBER IS
87:
88: l_org_id ap_supplier_sites_all.org_id%TYPE;
89: l_awt_group_id_po ap_suppliers.awt_group_id%TYPE;
90: l_pay_awt_group_id_po ap_suppliers.pay_awt_group_id%TYPE;
91: l_awt_group_id_pvs ap_supplier_sites_all.awt_group_id%TYPE;
92: l_pay_awt_group_id_pvs ap_supplier_sites_all.pay_awt_group_id%TYPE;
93: l_create_awt_dists_type ap_system_parameters_all.CREATE_AWT_DISTS_TYPE%TYPE;
94:

Line 158: from ap_suppliers

154: IF (l_tax_grp_id IS NULL) and (l_pay_tax_grp_id IS NULL) THEN
155:
156: select awt_group_id,pay_awt_group_id
157: into l_awt_group_id_po,l_pay_awt_group_id_po
158: from ap_suppliers
159: where
160: vendor_id = l_vendor_id;
161:
162: If (l_awt_group_id_po IS NOT NULL) and (l_pay_awt_group_id_po IS NOT NULL) and