DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on JAI_PO_QUOT_LINES_T

Line 2287: FROM JAI_PO_QUOT_LINES_T

2283: created_by,
2284: last_update_date,
2285: last_updated_by,
2286: last_update_login
2287: FROM JAI_PO_QUOT_LINES_T
2288: WHERE nvl(error_flag, 'N') <> 'Y'
2289: ORDER BY po_header_id, po_line_id
2290: )
2291: LOOP

Line 2331: DELETE FROM JAI_PO_QUOT_LINES_T

2327: v_error_mesg := 'Error from called unit jai_po_tax_pkg.copy_quot_taxes -> '||v_errbuf;
2328: RAISE error_from_called_unit;
2329: END IF;
2330:
2331: DELETE FROM JAI_PO_QUOT_LINES_T
2332: WHERE rowid = v_rowid;
2333:
2334: COMMIT;
2335:

Line 2348: UPDATE JAI_PO_QUOT_LINES_T

2344:
2345: ROLLBACK;
2346:
2347: -- update the record for error
2348: UPDATE JAI_PO_QUOT_LINES_T
2349: SET error_flag = 'Y',
2350: processing_time = SYSDATE,
2351: error_message = v_error_mesg
2352: WHERE ROWID = v_rowid;