APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_OM_OE_SO_TAXES

Line 2457: INSERT INTO JAI_OM_OE_SO_TAXES(

2453: nvl(p_last_updated_by,1), nvl(p_last_update_login,1) );
2454:
2455: -- end, Vijay Shankar for Bug# 2837970
2456: ELSIF transaction_name = 'SALES_ORDER' THEN
2457: INSERT INTO JAI_OM_OE_SO_TAXES(
2458: line_id, header_id, tax_line_no,
2459: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
2460: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
2461: tax_id, tax_rate, qty_rate, uom,

Line 2599: UPDATE JAI_OM_OE_SO_TAXES

2595: );
2596:
2597: ELSIF transaction_name = 'SO_LINES_UPDATE' THEN
2598:
2599: UPDATE JAI_OM_OE_SO_TAXES
2600: SET tax_amount = ROUND(NVL(tax_amt_tab(row_count),0), REC.ROUNDING_FACTOR),
2601: 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)),
2602: func_tax_amount = NVL(func_tax_amt_tab(row_count),0) * v_currency_conv_factor,
2603: last_update_date = p_last_update_date,