APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_OM_OE_SO_TAXES

Line 3503: INSERT INTO JAI_OM_OE_SO_TAXES(

3499: nvl(p_last_updated_by,1), nvl(p_last_update_login,1) );
3500:
3501: -- end, Vijay Shankar for Bug# 2837970
3502: ELSIF transaction_name = 'SALES_ORDER' THEN
3503: INSERT INTO JAI_OM_OE_SO_TAXES(
3504: line_id, header_id, tax_line_no,
3505: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
3506: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI
3507: tax_id, tax_rate, qty_rate, uom,

Line 3645: UPDATE JAI_OM_OE_SO_TAXES

3641: );
3642:
3643: ELSIF transaction_name = 'SO_LINES_UPDATE' THEN
3644:
3645: UPDATE JAI_OM_OE_SO_TAXES
3646: SET tax_amount = ROUND(NVL(tax_amt_tab(row_count),0), REC.ROUNDING_FACTOR),
3647: 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)),
3648: func_tax_amount = NVL(func_tax_amt_tab(row_count),0) * v_currency_conv_factor,
3649: last_update_date = p_last_update_date,