DBA Data[Home] [Help]

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 1619: --delete from pa_transaction_controls

1615: -- and used bulk delete.
1616:
1617: -- Delete transaction controls
1618: --x_err_stage := 'Delete txn controls for task '|| x_task_id;
1619: --delete from pa_transaction_controls
1620: --where task_id in
1621: --(SELECT TASK_ID
1622: -- FROM PA_TASKS
1623: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1795: delete from pa_transaction_controls

1791:
1792: -- Delete transaction controls
1793: x_err_stage := 'Delete txn controls for task '|| x_task_id;
1794: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1795: delete from pa_transaction_controls
1796: where task_id =l_task_id_tab(i)
1797: and project_id = l_project_id;
1798:
1799: