APPS.IGI_CIS2007_TAX_EFF_DATE dependencies on AP_AWT_GROUP_TAXES

Line 5: , p_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE

1: PACKAGE BODY igi_cis2007_tax_eff_date AS
2: -- $Header: igiefdtb.pls 120.1.12010000.2 2008/12/19 12:58:32 gaprasad ship $
3: PROCEDURE main(p_vendor_id IN ap_suppliers.vendor_id%TYPE
4: , p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%TYPE
5: , p_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE
6: , p_pay_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE /* Bug 7218825 */
7: , p_source IN VARCHAR2
8: , p_effective_date IN DATE) IS
9:

Line 6: , p_pay_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE /* Bug 7218825 */

2: -- $Header: igiefdtb.pls 120.1.12010000.2 2008/12/19 12:58:32 gaprasad ship $
3: PROCEDURE main(p_vendor_id IN ap_suppliers.vendor_id%TYPE
4: , p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%TYPE
5: , p_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE
6: , p_pay_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE /* Bug 7218825 */
7: , p_source IN VARCHAR2
8: , p_effective_date IN DATE) IS
9:
10: -- c_vendor_sites is the cursor which is used

Line 31: CURSOR c_new_tax_rate(p_tax_group_id ap_awt_group_taxes.group_id%TYPE

27: AND povs.allow_awt_flag = 'Y'
28: AND org_id IS NOT NULL;
29:
30: -- c_new_tax_rate will be used to get the new rate for the tax_group_id and org
31: CURSOR c_new_tax_rate(p_tax_group_id ap_awt_group_taxes.group_id%TYPE
32: , p_org_id ap_awt_group_taxes.org_id%TYPE) IS
33: SELECT atr.tax_rate new_tax_rate
34: FROM ap_tax_codes_all atc,
35: ap_awt_group_taxes_all agt,

Line 32: , p_org_id ap_awt_group_taxes.org_id%TYPE) IS

28: AND org_id IS NOT NULL;
29:
30: -- c_new_tax_rate will be used to get the new rate for the tax_group_id and org
31: CURSOR c_new_tax_rate(p_tax_group_id ap_awt_group_taxes.group_id%TYPE
32: , p_org_id ap_awt_group_taxes.org_id%TYPE) IS
33: SELECT atr.tax_rate new_tax_rate
34: FROM ap_tax_codes_all atc,
35: ap_awt_group_taxes_all agt,
36: ap_awt_tax_rates_all atr

Line 35: ap_awt_group_taxes_all agt,

31: CURSOR c_new_tax_rate(p_tax_group_id ap_awt_group_taxes.group_id%TYPE
32: , p_org_id ap_awt_group_taxes.org_id%TYPE) IS
33: SELECT atr.tax_rate new_tax_rate
34: FROM ap_tax_codes_all atc,
35: ap_awt_group_taxes_all agt,
36: ap_awt_tax_rates_all atr
37: WHERE agt.group_id = p_tax_group_id
38: AND agt.tax_name = atc.name
39: AND atc.name = atr.tax_name

Line 74: l_old_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE;

70: l_update_flag VARCHAR2(2);
71: l_tax_name_exists_flag boolean;
72: l_start_date DATE;
73: l_update_date DATE;
74: l_old_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE;
75: l_site_old_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE;
76:
77: l_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE; /* Bug 7218825 */
78:

Line 75: l_site_old_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE;

71: l_tax_name_exists_flag boolean;
72: l_start_date DATE;
73: l_update_date DATE;
74: l_old_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE;
75: l_site_old_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE;
76:
77: l_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE; /* Bug 7218825 */
78:
79: BEGIN

Line 77: l_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE; /* Bug 7218825 */

73: l_update_date DATE;
74: l_old_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE;
75: l_site_old_tax_grp_id ap_awt_group_taxes_all.group_id%TYPE;
76:
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 */

Line 153: FROM ap_awt_group_taxes_all agt,

149: --Fetch the old tax name
150: BEGIN
151: SELECT atc.name tax_name
152: INTO l_old_tax_name
153: FROM ap_awt_group_taxes_all agt,
154: ap_tax_codes_all atc
155: WHERE agt.group_id = nvl(l_site_old_tax_grp_id, l_old_tax_grp_id)
156: AND atc.tax_type = 'AWT'
157: AND agt.tax_name = atc.name