APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 877: , 'JAI_AR_TRX_TAX_LINES'

873: /** For bill_only_invoice tax source table is ja_in_ra_cust_trx_tax_lines*/
874: lv_recalculation_sql :=
875: replace ( lv_recalculation_sql
876: , '$$TAX_SOURCE_TABLE$$'
877: , 'JAI_AR_TRX_TAX_LINES'
878: );
879: /** replace join condition */
880: lv_recalculation_sql :=
881: replace ( lv_recalculation_sql

Line 1793: , 'JAI_AR_TRX_TAX_LINES'

1789: /** For bill_only_invoice tax source table is ja_in_ra_cust_trx_tax_lines*/
1790: lv_recalculation_sql :=
1791: replace ( lv_recalculation_sql
1792: , '$$TAX_SOURCE_TABLE$$'
1793: , 'JAI_AR_TRX_TAX_LINES'
1794: );
1795: /** replace join condition */
1796: lv_recalculation_sql :=
1797: replace ( lv_recalculation_sql

Line 2618: INSERT INTO JAI_AR_TRX_TAX_LINES(

2614: --if (v_register_code='BOND_REG') --and (rec.tax_type_val<>1))
2615: --then
2616: --if (rec.tax_type_val<>1) then
2617:
2618: INSERT INTO JAI_AR_TRX_TAX_LINES(
2619: customer_trx_line_id, link_to_cust_trx_line_id, tax_line_no,
2620: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
2621: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2622: tax_id, tax_rate, qty_rate, uom,

Line 2643: INSERT INTO JAI_AR_TRX_TAX_LINES(customer_trx_line_id,

2639:
2640: /*
2641: end if;
2642: else
2643: INSERT INTO JAI_AR_TRX_TAX_LINES(customer_trx_line_id,
2644: link_to_cust_trx_line_id,
2645: tax_line_no,
2646: precedence_1,precedence_2, precedence_3, precedence_4,precedence_5,
2647: precedence_6,precedence_7, precedence_8, precedence_9,precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI

Line 2671: UPDATE JAI_AR_TRX_TAX_LINES

2667:
2668: --2001/03/30 Manohar Mishra
2669: -- Added the following IF condition
2670: --if ((v_register_code<>'BOND_REG') and (rec.tax_type_val<>1)) then
2671: UPDATE JAI_AR_TRX_TAX_LINES
2672: SET tax_amount = ROUND(NVL(tax_amt_tab(row_count), 0), REC.ROUNDING_FACTOR),
2673: 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)),
2674: func_tax_amount = NVL(func_tax_amt_tab(row_count),0) * v_currency_conv_factor,
2675: last_update_date = p_last_update_date,

Line 3283: update JAI_AR_TRX_TAX_LINES

3279: ); */ --commented by bgowrava for bug#5631784
3280:
3281: if p_action = jai_constants.recalculate_taxes then
3282:
3283: update JAI_AR_TRX_TAX_LINES
3284: set tax_amount = tax_amt_tab(row_count)
3285: ,func_tax_amount = nvl(func_tax_amt_tab(row_count),0) * nvl(v_currency_conv_factor ,1)
3286: ,base_tax_amount = round( nvl(tax_amt_tab(row_count),0), rec.rounding_factor)
3287: ,last_update_date = p_last_update_date