DBA Data[Home] [Help]

APPS.PJM_TASK_AUTO_ASSIGN dependencies on WIP_TRANSACTIONS

Line 176: UPDATE wip_transactions

172: L_prog_id := fnd_global.conc_program_id;
173:
174: L_stmt_num := 10;
175:
176: UPDATE wip_transactions
177: SET pm_cost_collected = 'E'
178: , last_update_date = sysdate
179: , last_updated_by = L_user_id
180: , request_id = L_request_id

Line 1188: FROM wip_transactions t

1184: , t.transaction_type /*Added for Bug 7028109 (FP of 6820737)*/
1185: , e.primary_item_id
1186: , e.entity_type
1187: , wta.cost_element_id /*Added for Bug 7028109 (FP of 6820737)*/
1188: FROM wip_transactions t
1189: , wip_entities e
1190: , wip_transaction_accounts wta
1191: WHERE t.transaction_id = C_transaction_id
1192: AND t.wip_entity_id = e.wip_entity_id

Line 1325: UPDATE wip_transactions w

1321:
1322: if (L_task_id is not null) then
1323:
1324: L_stmt_num := 40;
1325: UPDATE wip_transactions w
1326: SET task_id = L_task_id
1327: WHERE transaction_id = X_transaction_id;
1328:
1329: else