APPS.PJM_TASK_AUTO_ASSIGN dependencies on WIP_TXN_INTERFACE_ERRORS

Line 188: UPDATE wip_txn_interface_errors

184: WHERE transaction_id = X_transaction_id;
185:
186: L_stmt_num := 20;
187:
188: UPDATE wip_txn_interface_errors
189: SET error_message = X_error_msg
190: , last_update_date = sysdate
191: , last_updated_by = L_user_id
192: , request_id = L_request_id

Line 203: INSERT INTO wip_txn_interface_errors

199: if sql%notfound then
200:
201: L_stmt_num := 30;
202:
203: INSERT INTO wip_txn_interface_errors
204: ( transaction_id
205: , error_message
206: , error_column
207: , last_update_date

Line 1238: DELETE FROM wip_txn_interface_errors

1234:
1235: PJM_CONC.put_line( 'Processing resource transaction ' || X_transaction_id );
1236:
1237: L_stmt_num := 10;
1238: DELETE FROM wip_txn_interface_errors
1239: WHERE transaction_id = X_transaction_id
1240: AND error_column = 'TASK_ID';
1241:
1242: --