DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on JAI_CONSTANTS

Line 86: where regime_code = jai_constants.service_regime;

82: cursor c_jai_regimes
83: IS
84: select regime_id
85: from JAI_RGM_DEFINITIONS
86: where regime_code = jai_constants.service_regime;
87:
88: l_api_name CONSTANT VARCHAR2(30) := 'get_service_account';
89: BEGIN
90:

Line 126: ,p_organization_type => jai_constants.orgn_type_io

122: CLOSE c_jai_regimes;
123:
124: IF lb_charge_service_interim THEN
125: ln_service_interim_account := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_service_regime_id
126: ,p_organization_type => jai_constants.orgn_type_io
127: ,p_organization_id => p_organization_id
128: ,p_location_id => p_location_id
129: ,p_tax_type => p_tax_type
130: ,p_account_name => jai_constants.recovery_interim);

Line 130: ,p_account_name => jai_constants.recovery_interim);

126: ,p_organization_type => jai_constants.orgn_type_io
127: ,p_organization_id => p_organization_id
128: ,p_location_id => p_location_id
129: ,p_tax_type => p_tax_type
130: ,p_account_name => jai_constants.recovery_interim);
131: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'recovery interim acct: '||ln_service_interim_account);
133: END IF;
134:

Line 138: ,p_organization_type => jai_constants.orgn_type_io

134:
135: RETURN ln_service_interim_account;
136: ELSIF lb_service_reverse_charge THEN
137: ln_service_reverse_account := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_service_regime_id
138: ,p_organization_type => jai_constants.orgn_type_io
139: ,p_organization_id => p_organization_id
140: ,p_location_id => p_location_id
141: ,p_tax_type => p_tax_type
142: ,p_account_name => 'REVERSE_CHARGE');

Line 149: ,p_organization_type => jai_constants.orgn_type_io

145: END IF;
146: RETURN ln_service_reverse_account;
147: ELSIF lb_service_reverse_liablility THEN
148: ln_service_interim_account := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_service_regime_id
149: ,p_organization_type => jai_constants.orgn_type_io
150: ,p_organization_id => p_organization_id
151: ,p_location_id => p_location_id
152: ,p_tax_type => p_tax_type
153: ,p_account_name => jai_constants.liability_interim);

Line 153: ,p_account_name => jai_constants.liability_interim);

149: ,p_organization_type => jai_constants.orgn_type_io
150: ,p_organization_id => p_organization_id
151: ,p_location_id => p_location_id
152: ,p_tax_type => p_tax_type
153: ,p_account_name => jai_constants.liability_interim);
154: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
155: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'ln_service_interim_liablity: '||ln_service_interim_account);
156: END IF;
157: RETURN ln_service_interim_account;

Line 784: IF pr_ap_inv_dist_item.assets_tracking_flag = jai_constants.YES THEN

780: lv_tax_line_to_inst_flag := 'Y';
781: --Added by Wenqiong on 21-Feb-2013 for bug16360225 begin
782: --Copy below logic from line=2 for non recoverable taxes.
783: IF pv_tax_type ='NR' THEN
784: IF pr_ap_inv_dist_item.assets_tracking_flag = jai_constants.YES THEN
785: v_assets_tracking_flag := jai_constants.YES;
786: END IF;
787:
788: lv_modvat_flag := jai_constants.NO ;

Line 785: v_assets_tracking_flag := jai_constants.YES;

781: --Added by Wenqiong on 21-Feb-2013 for bug16360225 begin
782: --Copy below logic from line=2 for non recoverable taxes.
783: IF pv_tax_type ='NR' THEN
784: IF pr_ap_inv_dist_item.assets_tracking_flag = jai_constants.YES THEN
785: v_assets_tracking_flag := jai_constants.YES;
786: END IF;
787:
788: lv_modvat_flag := jai_constants.NO ;
789:

Line 788: lv_modvat_flag := jai_constants.NO ;

784: IF pr_ap_inv_dist_item.assets_tracking_flag = jai_constants.YES THEN
785: v_assets_tracking_flag := jai_constants.YES;
786: END IF;
787:
788: lv_modvat_flag := jai_constants.NO ;
789:
790: --
791: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
792: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 817: IF pr_ap_inv_dist_item.assets_tracking_flag = jai_constants.YES THEN

813: lv_ap_line_to_inst_flag := 'Y';
814: lv_tax_line_to_inst_flag := 'Y';
815:
816:
817: IF pr_ap_inv_dist_item.assets_tracking_flag = jai_constants.YES THEN
818: v_assets_tracking_flag := jai_constants.YES;
819: END IF;
820:
821: lv_modvat_flag := jai_constants.NO ;

Line 818: v_assets_tracking_flag := jai_constants.YES;

814: lv_tax_line_to_inst_flag := 'Y';
815:
816:
817: IF pr_ap_inv_dist_item.assets_tracking_flag = jai_constants.YES THEN
818: v_assets_tracking_flag := jai_constants.YES;
819: END IF;
820:
821: lv_modvat_flag := jai_constants.NO ;
822:

Line 821: lv_modvat_flag := jai_constants.NO ;

817: IF pr_ap_inv_dist_item.assets_tracking_flag = jai_constants.YES THEN
818: v_assets_tracking_flag := jai_constants.YES;
819: END IF;
820:
821: lv_modvat_flag := jai_constants.NO ;
822:
823: --
824: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
825: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 860: lv_modvat_flag := jai_constants.NO ;

856: ELSIF ( line = 2 )
857: THEN
858: v_tax_amount := pn_nrec_tax_amt ;
859: lv_tax_line_amount := v_tax_amount ;
860: lv_modvat_flag := jai_constants.NO ;
861: lv_ap_line_to_inst_flag := 'N';
862: lv_tax_line_to_inst_flag := 'Y';
863:
864: --recoverable part without project infor

Line 1045: IF p_tax_line_rec.modvat_flag = jai_constants.no OR line = 2 OR line = 4

1041: v_tax_variance_inv_cur := v_tax_amt_dist * (r_ap_dist.invoice_price_variance / r_ap_dist.amount);
1042: v_tax_variance_fun_cur := v_tax_variance_inv_cur * nvl(r_invoice_info.exchange_rate, 1);
1043: END IF;
1044:
1045: IF p_tax_line_rec.modvat_flag = jai_constants.no OR line = 2 OR line = 4
1046: THEN
1047: v_assets_tracking_flag := r_ap_dist.assets_tracking_flag;
1048: lv_project_accounting_context := r_ap_dist.project_accounting_context;
1049: lv_pa_addition_flag := r_ap_dist.pa_addition_flag;

Line 1056: if p_tax_line_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then

1052: ln_dist_code_combination_id := Nvl(ln_dist_code_combination_id,r_ap_dist.dist_code_combination_id);
1053:
1054:
1055: ln_base_amount := null ;
1056: if p_tax_line_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
1057: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt(
1058: p_invoice_id => ln_invoice_id ,
1059: p_line_location_id => pr_ap_inv_line_item.po_line_location_id ,
1060: p_transaction_id => null ,

Line 1594: and jrr.registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */

1590: cursor c_regime_tax_type(cp_regime_code varchar2, cp_tax_type varchar2) is
1591: select jrr.regime_id,attribute_code tax_type
1592: from JAI_RGM_REGISTRATIONS jrr,JAI_RGM_DEFINITIONS jrd
1593: where jrr.regime_id = jrd.regime_id
1594: and jrr.registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
1595: AND jrd.regime_code = cp_regime_code
1596: and jrr.attribute_code = cp_tax_type;
1597:
1598: CURSOR c_tax(t_id NUMBER) IS

Line 1718: open c_regime_tax_type(jai_constants.service_regime, pr_tax_line_rec.tax_type);

1714: OPEN get_account_type;
1715: FETCH get_account_type INTO lv_account_type;
1716: CLOSE get_account_type;
1717:
1718: open c_regime_tax_type(jai_constants.service_regime, pr_tax_line_rec.tax_type);
1719: fetch c_regime_tax_type into r_service_regime_tax_type;
1720: close c_regime_tax_type;
1721:
1722:

Line 1723: open c_regime_tax_type(jai_constants.vat_regime, pr_tax_line_rec.tax_type);

1719: fetch c_regime_tax_type into r_service_regime_tax_type;
1720: close c_regime_tax_type;
1721:
1722:
1723: open c_regime_tax_type(jai_constants.vat_regime, pr_tax_line_rec.tax_type);
1724: fetch c_regime_tax_type into r_vat_regime_tax_type;
1725: close c_regime_tax_type;
1726:
1727: OPEN c_tax(pr_tax_line_rec.tax_id);

Line 1742: if pr_tax_line_rec.modvat_flag = jai_constants.YES and nvl(pr_tax_line_rec.mod_cr_percentage, -1) > 0 then

1738: fetch c_get_excise_costing_flag into lv_excise_costing_flag;
1739: close c_get_excise_costing_flag ;
1740: END IF;
1741:
1742: if pr_tax_line_rec.modvat_flag = jai_constants.YES and nvl(pr_tax_line_rec.mod_cr_percentage, -1) > 0 then
1743:
1744: --recoverable tax
1745: pv_tax_type := 'RE';
1746:

Line 1885: if pr_tax_line_rec.modvat_flag = jai_constants.YES

1881:
1882:
1883: Fnd_File.put_line(Fnd_File.LOG, 'pr_tax_line_rec.modvat_flag ='||pr_tax_line_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
1884:
1885: if pr_tax_line_rec.modvat_flag = jai_constants.YES
1886: and nvl(pr_tax_line_rec.mod_cr_percentage, -1) > 0
1887: and nvl(pr_tax_line_rec.mod_cr_percentage, -1) < 100
1888: then
1889: --

Line 1901: if pr_tax_line_rec.modvat_flag = jai_constants.YES then

1897: pv_tax_type := 'PR';
1898:
1899: end if;
1900:
1901: if pr_tax_line_rec.modvat_flag = jai_constants.YES then
1902: pn_inclurec_tax_amt := round ( nvl(pr_tax_line_rec.tax_amount,0) * (pr_tax_line_rec.mod_cr_percentage/100) , c_tax_rec.rounding_factor) ;
1903: end if;
1904: if nvl(pr_ap_inv_dist_item.invoice_price_variance, -1) <>-1
1905: and