APPS.PA_PROJECT_CORE dependencies on PA_TRANSACTION_CONTROLS

Line 347: delete from pa_transaction_controls

343: delete from pa_credit_receivers
344: where project_id = x_project_id;
345:
346: -- Delete transaction controls
347: delete from pa_transaction_controls
348: where project_id = x_project_id;
349:
350: -- Delete billing assignments
351: delete from pa_billing_assignments

Line 1635: --delete from pa_transaction_controls

1631: -- and used bulk delete.
1632:
1633: -- Delete transaction controls
1634: --x_err_stage := 'Delete txn controls for task '|| x_task_id;
1635: --delete from pa_transaction_controls
1636: --where task_id in
1637: --(SELECT TASK_ID
1638: -- FROM PA_TASKS
1639: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1811: delete from pa_transaction_controls

1807:
1808: -- Delete transaction controls
1809: x_err_stage := 'Delete txn controls for task '|| x_task_id;
1810: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1811: delete from pa_transaction_controls
1812: where task_id =l_task_id_tab(i)
1813: and project_id = l_project_id;
1814:
1815: