DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE dependencies on PA_WF_PROCESSES

Line 942: delete from pa_wf_processes where

938: Note added by sdebroy : 12-MAR-2004 ****/
939:
940: -- Start of changes for Bug 2898598
941:
942: delete from pa_wf_processes where
943: entity_key1 = TO_CHAR(x_project_id)
944: and item_type <> 'PABUDWF'
945: and (item_key,item_type) not in
946: (select item_key,item_type from wf_items);/*Bug 9276888 Delete those records from

Line 947: pa_wf_processes for which WF Purge has been run. */

943: entity_key1 = TO_CHAR(x_project_id)
944: and item_type <> 'PABUDWF'
945: and (item_key,item_type) not in
946: (select item_key,item_type from wf_items);/*Bug 9276888 Delete those records from
947: pa_wf_processes for which WF Purge has been run. */
948:
949: FOR i IN ( SELECT item_type,item_key
950: FROM pa_wf_processes
951: WHERE entity_key1 = TO_CHAR(x_project_id)

Line 950: FROM pa_wf_processes

946: (select item_key,item_type from wf_items);/*Bug 9276888 Delete those records from
947: pa_wf_processes for which WF Purge has been run. */
948:
949: FOR i IN ( SELECT item_type,item_key
950: FROM pa_wf_processes
951: WHERE entity_key1 = TO_CHAR(x_project_id)
952: and item_type <> 'PABUDWF') --Bug 9040747
953:
954: LOOP

Line 971: DELETE FROM pa_wf_processes

967: itemkey => i.item_key );
968:
969: END LOOP;
970:
971: DELETE FROM pa_wf_processes
972: WHERE entity_key1 = TO_CHAR(x_project_id)
973: and item_type <> 'PABUDWF'; --Bug 9040747;
974:
975: -- End of changes for bug 2898598