DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on WIP_TXN_INTERFACE_ERRORS

Line 1306: DELETE wip_txn_interface_errors wite

1302: END LOOP;
1303:
1304: l_stmt_num := 30;
1305:
1306: DELETE wip_txn_interface_errors wite
1307: WHERE wite.transaction_id in
1308: ( SELECT wt.transaction_id
1309: FROM wip_transactions wt
1310: WHERE wt.pm_cost_collector_group_id = l_group_id

Line 6461: UPDATE wip_txn_interface_errors wtie

6457: wt.program_update_date = sysdate
6458: WHERE wt.transaction_id = p_transaction_id ;
6459:
6460: l_stmt_num := 20;
6461: UPDATE wip_txn_interface_errors wtie
6462: SET wtie.error_message = p_error_explanation,
6463: wtie.last_update_date = sysdate,
6464: wtie.last_updated_by = p_user_id,
6465: wtie.last_update_login = p_login_id,

Line 6476: INSERT INTO wip_txn_interface_errors

6472:
6473: IF SQL%NOTFOUND THEN
6474:
6475: l_stmt_num := 30;
6476: INSERT INTO wip_txn_interface_errors
6477: ( transaction_id,
6478: error_message,
6479: error_column,
6480: last_update_date,