APPS.IGI_CIS2007_UTIL_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 62: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%TYPE,

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: )
66: IS

Line 88: l_org_id ap_supplier_sites_all.org_id%TYPE;

84:
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;

Line 91: l_awt_group_id_pvs ap_supplier_sites_all.awt_group_id%TYPE;

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:
95: BEGIN

Line 92: l_pay_awt_group_id_pvs ap_supplier_sites_all.pay_awt_group_id%TYPE;

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:
95: BEGIN
96:

Line 103: from ap_supplier_sites_all

99: IF (l_tax_grp_id IS NULL) and (l_pay_tax_grp_id IS NULL) THEN
100:
101: select org_id,awt_group_id,pay_awt_group_id
102: into l_org_id,l_awt_group_id_pvs,l_pay_awt_group_id_pvs
103: from ap_supplier_sites_all
104: where
105: vendor_id = l_vendor_id and
106: vendor_site_id = l_vendor_site_id and
107: upper(allow_awt_flag) = 'Y';