APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_PO_TAXES

Line 4016: INSERT INTO JAI_PO_TAXES(

4012: END IF;
4013:
4014: IF operation = 'I' THEN
4015: IF p_operation_flag <> -1 THEN
4016: INSERT INTO JAI_PO_TAXES(
4017: line_focus_id, line_location_id, po_line_id, po_header_id,
4018: tax_line_no,
4019: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
4020: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI

Line 4063: INSERT INTO JAI_PO_TAXES(

4059: --=====================================================
4060:
4061: ELSE
4062:
4063: INSERT INTO JAI_PO_TAXES(
4064: Line_Focus_Id, Line_Location_Id, Po_Line_Id, Po_Header_Id,
4065: Tax_Line_No,
4066: Precedence_1, Precedence_2, Precedence_3, Precedence_4, Precedence_5,
4067: Precedence_6, Precedence_7, Precedence_8, Precedence_9, Precedence_10, -- Date 31/10/2006 Bug 5228046 added by SACSETHI

Line 4092: UPDATE JAI_PO_TAXES

4088:
4089: ELSIF operation = 'U' THEN
4090:
4091: IF v_line_id IS NOT NULL THEN
4092: UPDATE JAI_PO_TAXES
4093: SET Tax_Amount = ROUND(NVL( tax_amt_tab(row_count), 0 ),REC.ROUNDING_FACTOR),
4094: tax_target_amount = DECODE(NVL(base_tax_amt_tab(row_count), 0), 0, NVL(tax_amt_tab(row_count),0),
4095: NVL(base_tax_amt_tab(row_count), 0)) * p_currency_conv_factor ,
4096: last_updated_by = p_last_updated_by,

Line 4102: UPDATE JAI_PO_TAXES

4098: last_update_login = p_last_update_login
4099: WHERE po_line_id = p_line_id
4100: AND line_location_id = v_line_id;
4101: ELSE
4102: UPDATE JAI_PO_TAXES
4103: SET Tax_Amount = ROUND(NVL( tax_amt_tab(row_count), 0 ), REC.ROUNDING_FACTOR),
4104: tax_target_amount = DECODE(NVL(base_tax_amt_tab(row_count), 0), 0, NVL(tax_amt_tab(row_count),0),
4105: NVL(base_tax_amt_tab(row_count), 0)) * p_currency_conv_factor ,
4106: last_updated_by = p_last_updated_by,