APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 1067: , 'JAI_AR_TRX_TAX_LINES'

1063: /** For bill_only_invoice tax source table is ja_in_ra_cust_trx_tax_lines*/
1064: lv_recalculation_sql :=
1065: replace ( lv_recalculation_sql
1066: , '$$TAX_SOURCE_TABLE$$'
1067: , 'JAI_AR_TRX_TAX_LINES'
1068: );
1069: /** replace join condition */
1070: lv_recalculation_sql :=
1071: replace ( lv_recalculation_sql

Line 2806: , 'JAI_AR_TRX_TAX_LINES'

2802: /** For bill_only_invoice tax source table is ja_in_ra_cust_trx_tax_lines*/
2803: lv_recalculation_sql :=
2804: replace ( lv_recalculation_sql
2805: , '$$TAX_SOURCE_TABLE$$'
2806: , 'JAI_AR_TRX_TAX_LINES'
2807: );
2808: /** replace join condition */
2809: lv_recalculation_sql :=
2810: replace ( lv_recalculation_sql

Line 3790: INSERT INTO JAI_AR_TRX_TAX_LINES(

3786: get_created_from(p_header_id, l_created_from);
3787:
3788: if (l_created_from = 'ARXTWMAI' and p_max_rgm_tax_line>0) then
3789:
3790: INSERT INTO JAI_AR_TRX_TAX_LINES(
3791: customer_trx_line_id, link_to_cust_trx_line_id, tax_line_no,
3792: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
3793: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3794: tax_id, tax_rate, qty_rate, uom,

Line 3814: INSERT INTO JAI_AR_TRX_TAX_LINES(

3810: );
3811:
3812: else
3813:
3814: INSERT INTO JAI_AR_TRX_TAX_LINES(
3815: customer_trx_line_id, link_to_cust_trx_line_id, tax_line_no,
3816: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
3817: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3818: tax_id, tax_rate, qty_rate, uom,

Line 3843: INSERT INTO JAI_AR_TRX_TAX_LINES(customer_trx_line_id,

3839:
3840: /*
3841: end if;
3842: else
3843: INSERT INTO JAI_AR_TRX_TAX_LINES(customer_trx_line_id,
3844: link_to_cust_trx_line_id,
3845: tax_line_no,
3846: precedence_1,precedence_2, precedence_3, precedence_4,precedence_5,
3847: precedence_6,precedence_7, precedence_8, precedence_9,precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI

Line 3871: UPDATE JAI_AR_TRX_TAX_LINES

3867:
3868: --2001/03/30 Manohar Mishra
3869: -- Added the following IF condition
3870: --if ((v_register_code<>'BOND_REG') and (rec.tax_type_val<>1)) then
3871: UPDATE JAI_AR_TRX_TAX_LINES
3872: SET tax_amount = ROUND(NVL(tax_amt_tab(row_count), 0), REC.ROUNDING_FACTOR),
3873: base_tax_amount = DECODE(NVL(base_tax_amt_tab(row_count), 0), 0, NVL(tax_amt_tab(row_count),0), NVL(base_tax_amt_tab(row_count), 0)),
3874: func_tax_amount = NVL(func_tax_amt_tab(row_count),0) * v_currency_conv_factor,
3875: last_update_date = p_last_update_date,

Line 4516: update JAI_AR_TRX_TAX_LINES

4512: ); */ --commented by bgowrava for bug#5631784
4513:
4514: if p_action = jai_constants.recalculate_taxes then
4515:
4516: update JAI_AR_TRX_TAX_LINES
4517: set tax_amount = tax_amt_tab(row_count)
4518: ,func_tax_amount = nvl(func_tax_amt_tab(row_count),0) * nvl(v_currency_conv_factor ,1)
4519: ,base_tax_amount = round( nvl(tax_amt_tab(row_count),0), rec.rounding_factor)
4520: ,last_update_date = p_last_update_date