DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on JAI_PO_QUOT_LINES_T

Line 3008: FROM JAI_PO_QUOT_LINES_T

3004: created_by,
3005: last_update_date,
3006: last_updated_by,
3007: last_update_login
3008: FROM JAI_PO_QUOT_LINES_T
3009: WHERE nvl(error_flag, 'N') <> 'Y'
3010: ORDER BY po_header_id, po_line_id
3011: )
3012: LOOP

Line 3052: DELETE FROM JAI_PO_QUOT_LINES_T

3048: v_error_mesg := 'Error from called unit jai_po_tax_pkg.copy_quot_taxes -> '||v_errbuf;
3049: RAISE error_from_called_unit;
3050: END IF;
3051:
3052: DELETE FROM JAI_PO_QUOT_LINES_T
3053: WHERE rowid = v_rowid;
3054:
3055: COMMIT;
3056:

Line 3069: UPDATE JAI_PO_QUOT_LINES_T

3065:
3066: ROLLBACK;
3067:
3068: -- update the record for error
3069: UPDATE JAI_PO_QUOT_LINES_T
3070: SET error_flag = 'Y',
3071: processing_time = SYSDATE,
3072: error_message = v_error_mesg
3073: WHERE ROWID = v_rowid;