[Home] [Help]
710: 10. 20-Nov-2008 JMEENA for bug#6488296( FP of 6475430)
711: Added OR condition in procedure ja_in_calc_prec_taxes as we are passing p_action null in case of 'CASH' Receipt.
712:
713: 11. 14-Sep-2009 JMEENA for bug#8905076
714: Modified the update statement of table JAI_OM_WSH_LINE_TAXES and used base_tax_amt_tab instead of
715: tax_amt_tab to update the column base_tax_amount.
716:
717: 12. 4-Nov-2009 Xiao Lv for bug#8789761
718: Added variable base_tax_amount_nr_tab with type of tax_amt_num_tab to calculate base tax amount.
1049: /** replace the correct tax source table */
1050: lv_recalculation_sql :=
1051: replace ( lv_recalculation_sql
1052: , '$$TAX_SOURCE_TABLE$$'
1053: , 'JAI_OM_WSH_LINE_TAXES'
1054: );
1055: /** replace join condition */
1056: lv_recalculation_sql :=
1057: replace ( lv_recalculation_sql
2788: /** replace the correct tax source table */
2789: lv_recalculation_sql :=
2790: replace ( lv_recalculation_sql
2791: , '$$TAX_SOURCE_TABLE$$'
2792: , 'JAI_OM_WSH_LINE_TAXES'
2793: );
2794: /** replace join condition */
2795: lv_recalculation_sql :=
2796: replace ( lv_recalculation_sql
4452: ); */ --commented by bgowrava for bug#5631784
4453:
4454: if p_action = jai_constants.recalculate_taxes then
4455: --Used base_tax_amt_tab instead of tax_amt_tab to update column base_tax_amount for bug#8905076 by JMEENA
4456: update JAI_OM_WSH_LINE_TAXES
4457: set tax_amount = tax_amt_tab(row_count)
4458: ,func_tax_amount = nvl(func_tax_amt_tab(row_count),0) * nvl(v_currency_conv_factor ,1)
4459: ,base_tax_amount = round( nvl(base_tax_amt_tab(row_count),0), rec.rounding_factor)
4460: ,last_update_date = p_last_update_date