DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on WIP_TXN_INTERFACE_ERRORS

Line 1272: DELETE wip_txn_interface_errors wite

1268: END LOOP;
1269:
1270: l_stmt_num := 30;
1271:
1272: DELETE wip_txn_interface_errors wite
1273: WHERE wite.transaction_id in
1274: ( SELECT wt.transaction_id
1275: FROM wip_transactions wt
1276: WHERE wt.pm_cost_collector_group_id = l_group_id

Line 6334: UPDATE wip_txn_interface_errors wtie

6330: wt.program_update_date = sysdate
6331: WHERE wt.transaction_id = p_transaction_id ;
6332:
6333: l_stmt_num := 20;
6334: UPDATE wip_txn_interface_errors wtie
6335: SET wtie.error_message = p_error_explanation,
6336: wtie.last_update_date = sysdate,
6337: wtie.last_updated_by = p_user_id,
6338: wtie.last_update_login = p_login_id,

Line 6349: INSERT INTO wip_txn_interface_errors

6345:
6346: IF SQL%NOTFOUND THEN
6347:
6348: l_stmt_num := 30;
6349: INSERT INTO wip_txn_interface_errors
6350: ( transaction_id,
6351: error_message,
6352: error_column,
6353: last_update_date,