APPS.JAI_AR_UTILS_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 33: Fix: Modified cursor tax_cur, get JAI_AR_TRX_TAX_LINES.tax_amount instead of JAI_CMN_TAXES_ALL.tax_amount

29: 03/12/2009 Modified by Xiao for bug#9109910
30: Issue: tax_amount is Zero after Trx Line amount changed.
31: Analysis: for adhoc tax, tax_amount is updated as JAI_CMN_TAXES_ALL.tax_amount, which is always Zero
32: when adhoc tax is defined in table JAI_CMN_TAXES_ALL.
33: Fix: Modified cursor tax_cur, get JAI_AR_TRX_TAX_LINES.tax_amount instead of JAI_CMN_TAXES_ALL.tax_amount
34: to update tax_amount.
35:
36: 02-Sep-2010 Bug 10043656 Modified by Peng Zheng
37: New Tax Category Default logic for GST

Line 143: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b ,

139: )
140: )tax_type_val,
141: b.mod_cr_Percentage, b.vendor_id, b.tax_type
142: , b.inclusive_tax_flag -- Added by Jia Li for Tax Inclusive Computations on 2007/12/11
143: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b ,
144: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
145: WHERE a.link_to_cust_trx_line_id = p_line_id
146: AND a.tax_id = b.tax_id
147: AND rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/

Line 1430: UPDATE JAI_AR_TRX_TAX_LINES

1426:
1427: IF transaction_name = 'AR_LINES_UPDATE'
1428: THEN
1429: IF NVL(rec.adhoc_flag,'N') = 'Y' THEN
1430: UPDATE JAI_AR_TRX_TAX_LINES
1431: SET tax_amount = nvl(rec.tax_amount,0),
1432: base_tax_amount = nvl(rec.base_tax_amount,0),
1433: func_tax_amount = nvl(rec.func_tax_amount,0),
1434: last_update_date = p_last_update_date,

Line 1440: UPDATE JAI_AR_TRX_TAX_LINES

1436: last_update_login = p_last_update_login
1437: WHERE link_to_cust_trx_line_id = P_line_id
1438: AND tax_line_no = rec.lno;
1439: ELSE
1440: UPDATE JAI_AR_TRX_TAX_LINES
1441: SET tax_amount = nvl(tax_amt_tab(rec.lno),0),
1442: base_tax_amount = decode(nvl(base_tax_amt_tab(rec.lno), 0), 0, nvl(tax_amt_tab(rec.lno),0), nvl(base_tax_amt_tab(rec.lno), 0)),
1443: func_tax_amount = ROUND(nvl(tax_amt_tab(rec.lno),0) * v_currency_conv_factor, rounding_factor_tab(rec.lno)),
1444: last_update_date = p_last_update_date,