APPS.PJM_TASK_AUTO_ASSIGN dependencies on MTL_MATERIAL_TRANSACTIONS

Line 103: -- error columns in MTL_MATERIAL_TRANSACTIONS

99: -- Name : Flag_INV_Error
100: --
101: -- Function : This procedure marks the transaction as Cost
102: -- Collection failed and populates the appropriate
103: -- error columns in MTL_MATERIAL_TRANSACTIONS
104: --
105: -- Parameters :
106: -- IN : X_transaction_id NUMBER
107: --

Line 123: UPDATE mtl_material_transactions

119: BEGIN
120:
121: L_stmt_num := 10;
122:
123: UPDATE mtl_material_transactions
124: SET error_code = X_error_code
125: , error_explanation = X_error_msg
126: , pm_cost_collected = 'E'
127: , last_update_date = sysdate

Line 847: FROM mtl_material_transactions

843: , to_project_id
844: , to_task_id
845: , source_project_id
846: , source_task_id
847: FROM mtl_material_transactions
848: WHERE transaction_id = C_transaction_id;
849:
850: CURSOR c_wip ( C_transaction_id NUMBER )
851: IS

Line 866: FROM mtl_material_transactions t

862: null)
863: , e.primary_item_id
864: , t.department_id
865: , o.standard_operation_id
866: FROM mtl_material_transactions t
867: , wip_entities e
868: , wip_operations o
869: WHERE transaction_id = C_transaction_id
870: AND e.organization_id = t.organization_id

Line 971: UPDATE mtl_material_transactions m

967:
968: if (L_task_id is not null) then
969:
970: L_stmt_num := 40;
971: UPDATE mtl_material_transactions m
972: SET task_id = L_task_id
973: WHERE transaction_id = X_transaction_id;
974:
975: else

Line 1037: UPDATE mtl_material_transactions m

1033:
1034: if (L_to_task_id is not null) then
1035:
1036: L_stmt_num := 60;
1037: UPDATE mtl_material_transactions m
1038: SET to_task_id = L_to_task_id
1039: WHERE transaction_id = X_transaction_id;
1040:
1041: else

Line 1101: UPDATE mtl_material_transactions m

1097:
1098: if (L_src_task_id is not null) then
1099:
1100: L_stmt_num := 80;
1101: UPDATE mtl_material_transactions m
1102: SET source_task_id = L_src_task_id
1103: WHERE transaction_id = X_transaction_id;
1104:
1105: else