APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_PO_TAXES

Line 2816: INSERT INTO JAI_PO_TAXES(

2812: END IF;
2813:
2814: IF operation = 'I' THEN
2815: IF p_operation_flag <> -1 THEN
2816: INSERT INTO JAI_PO_TAXES(
2817: line_focus_id, line_location_id, po_line_id, po_header_id,
2818: tax_line_no,
2819: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
2820: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI

Line 2863: INSERT INTO JAI_PO_TAXES(

2859: --=====================================================
2860:
2861: ELSE
2862:
2863: INSERT INTO JAI_PO_TAXES(
2864: Line_Focus_Id, Line_Location_Id, Po_Line_Id, Po_Header_Id,
2865: Tax_Line_No,
2866: Precedence_1, Precedence_2, Precedence_3, Precedence_4, Precedence_5,
2867: Precedence_6, Precedence_7, Precedence_8, Precedence_9, Precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI

Line 2892: UPDATE JAI_PO_TAXES

2888:
2889: ELSIF operation = 'U' THEN
2890:
2891: IF v_line_id IS NOT NULL THEN
2892: UPDATE JAI_PO_TAXES
2893: SET Tax_Amount = ROUND(NVL( tax_amt_tab(row_count), 0 ),REC.ROUNDING_FACTOR),
2894: tax_target_amount = DECODE(NVL(base_tax_amt_tab(row_count), 0), 0, NVL(tax_amt_tab(row_count),0),
2895: NVL(base_tax_amt_tab(row_count), 0)) * p_currency_conv_factor ,
2896: last_updated_by = p_last_updated_by,

Line 2902: UPDATE JAI_PO_TAXES

2898: last_update_login = p_last_update_login
2899: WHERE po_line_id = p_line_id
2900: AND line_location_id = v_line_id;
2901: ELSE
2902: UPDATE JAI_PO_TAXES
2903: SET Tax_Amount = ROUND(NVL( tax_amt_tab(row_count), 0 ), REC.ROUNDING_FACTOR),
2904: tax_target_amount = DECODE(NVL(base_tax_amt_tab(row_count), 0), 0, NVL(tax_amt_tab(row_count),0),
2905: NVL(base_tax_amt_tab(row_count), 0)) * p_currency_conv_factor ,
2906: last_updated_by = p_last_updated_by,