DBA Data[Home] [Help]

APPS.IGI_CIS2007_TAX_EFF_DATE dependencies on IGI_CIS2007_UTIL_PKG

Line 81: l_tax_grp_id := IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(p_vendor_id,p_vendor_site_id,p_tax_grp_id,p_pay_tax_grp_id); /* Bug 7218825 */

77: l_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE; /* Bug 7218825 */
78:
79: BEGIN
80:
81: l_tax_grp_id := IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(p_vendor_id,p_vendor_site_id,p_tax_grp_id,p_pay_tax_grp_id); /* Bug 7218825 */
82:
83: --Check for repeated call, if exists return
84: IF(g_old_p_vendor_id = p_vendor_id
85: AND g_old_p_vendor_site_id = p_vendor_site_id

Line 103: l_tax_grp_id := IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(lcr_vendor_site.vendor_id,lcr_vendor_site.vendor_site_id,p_tax_grp_id,p_pay_tax_grp_id); /* Bug 7218825 */

99: FOR lcr_vendor_site IN c_vendor_sites(p_vendor_id, p_vendor_site_id)
100: LOOP --Start of Vendor Sites Loop
101: BEGIN
102:
103: l_tax_grp_id := IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(lcr_vendor_site.vendor_id,lcr_vendor_site.vendor_site_id,p_tax_grp_id,p_pay_tax_grp_id); /* Bug 7218825 */
104:
105: --Get the new tax rate id for the vendor and vendor site
106: OPEN c_new_tax_rate(l_tax_grp_id, lcr_vendor_site.org_id); /* Bug 7218825 */
107: FETCH c_new_tax_rate

Line 114: SELECT decode(p_source, 'VENDOR SITE FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po_site.vendor_id,po_site.vendor_site_id, po_site.awt_group_id, po_site.pay_awt_group_id)

110:
111: BEGIN
112:
113: --Fetch the old tax group id for the vendor or vendor site
114: SELECT decode(p_source, 'VENDOR SITE FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po_site.vendor_id,po_site.vendor_site_id, po_site.awt_group_id, po_site.pay_awt_group_id)
115: , 'VENDOR FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
116: , 'CDROM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
117: , 'VERIFY', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id))
118: INTO l_old_tax_grp_id

Line 115: , 'VENDOR FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)

111: BEGIN
112:
113: --Fetch the old tax group id for the vendor or vendor site
114: SELECT decode(p_source, 'VENDOR SITE FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po_site.vendor_id,po_site.vendor_site_id, po_site.awt_group_id, po_site.pay_awt_group_id)
115: , 'VENDOR FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
116: , 'CDROM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
117: , 'VERIFY', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id))
118: INTO l_old_tax_grp_id
119: FROM ap_suppliers po,

Line 116: , 'CDROM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)

112:
113: --Fetch the old tax group id for the vendor or vendor site
114: SELECT decode(p_source, 'VENDOR SITE FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po_site.vendor_id,po_site.vendor_site_id, po_site.awt_group_id, po_site.pay_awt_group_id)
115: , 'VENDOR FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
116: , 'CDROM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
117: , 'VERIFY', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id))
118: INTO l_old_tax_grp_id
119: FROM ap_suppliers po,
120: ap_supplier_sites_all po_site

Line 117: , 'VERIFY', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id))

113: --Fetch the old tax group id for the vendor or vendor site
114: SELECT decode(p_source, 'VENDOR SITE FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po_site.vendor_id,po_site.vendor_site_id, po_site.awt_group_id, po_site.pay_awt_group_id)
115: , 'VENDOR FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
116: , 'CDROM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
117: , 'VERIFY', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id))
118: INTO l_old_tax_grp_id
119: FROM ap_suppliers po,
120: ap_supplier_sites_all po_site
121: WHERE po.vendor_id = p_vendor_id

Line 134: SELECT IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po_site.vendor_id,po_site.vendor_site_id, po_site.awt_group_id, po_site.pay_awt_group_id)

130: END;
131:
132: --Fetch the old tax group id for the vendor site
133: BEGIN
134: SELECT IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po_site.vendor_id,po_site.vendor_site_id, po_site.awt_group_id, po_site.pay_awt_group_id)
135: INTO l_site_old_tax_grp_id
136: FROM ap_suppliers po,
137: ap_supplier_sites_all po_site
138: WHERE po.vendor_id = p_vendor_id