APPS.CSM_HA_EVENT_PKG dependencies on WF_PROCESS_ACTIVITIES

Line 506: (select INSTANCE_ID from WF_PROCESS_ACTIVITIES

502: IS
503: BEGIN
504: delete from WF_ITEM_ACTIVITY_STATUSES_H
505: where PROCESS_ACTIVITY in
506: (select INSTANCE_ID from WF_PROCESS_ACTIVITIES
507: where PROCESS_ITEM_TYPE = p_item_type
508: or ACTIVITY_ITEM_TYPE = p_item_type);
509:
510: delete from WF_ITEM_ACTIVITY_STATUSES

Line 512: (select INSTANCE_ID from WF_PROCESS_ACTIVITIES

508: or ACTIVITY_ITEM_TYPE = p_item_type);
509:
510: delete from WF_ITEM_ACTIVITY_STATUSES
511: where PROCESS_ACTIVITY in
512: (select INSTANCE_ID from WF_PROCESS_ACTIVITIES
513: where PROCESS_ITEM_TYPE = p_item_type
514: or ACTIVITY_ITEM_TYPE = p_item_type);
515:
516: delete from wf_item_attribute_values

Line 544: where exists (select 'X' from wf_process_activities PAC

540: delete from wf_routing_rules
541: where message_type = p_item_type;
542:
543: delete from wf_activity_transitions PAT
544: where exists (select 'X' from wf_process_activities PAC
545: where PAT.FROM_PROCESS_ACTIVITY = PAC.instance_id
546: and PAC.PROCESS_ITEM_TYPE = p_item_type);
547:
548: delete from wf_activity_attr_values ATV

Line 549: where exists (select 'X' from wf_process_activities PAC

545: where PAT.FROM_PROCESS_ACTIVITY = PAC.instance_id
546: and PAC.PROCESS_ITEM_TYPE = p_item_type);
547:
548: delete from wf_activity_attr_values ATV
549: where exists (select 'X' from wf_process_activities PAC
550: where ATV.PROCESS_ACTIVITY_ID = PAC.instance_id
551: and PAC.PROCESS_ITEM_TYPE = p_item_type);
552:
553: delete from wf_process_activities

Line 553: delete from wf_process_activities

549: where exists (select 'X' from wf_process_activities PAC
550: where ATV.PROCESS_ACTIVITY_ID = PAC.instance_id
551: and PAC.PROCESS_ITEM_TYPE = p_item_type);
552:
553: delete from wf_process_activities
554: where PROCESS_ITEM_TYPE = p_item_type;
555:
556: delete from wf_activity_attributes_tl
557: where ACTIVITY_ITEM_TYPE = p_item_type;

Line 564: and not exists(select 'X' from wf_process_activities PAC

560: where ACTIVITY_ITEM_TYPE = p_item_type;
561:
562: delete from wf_activities_tl ACTL
563: where ACTL.ITEM_TYPE = p_item_type
564: and not exists(select 'X' from wf_process_activities PAC
565: where PAC.ACTIVITY_ITEM_TYPE='WFSTD'
566: and PAC.ACTIVITY_ITEM_TYPE=p_item_type
567: and PAC.ACTIVITY_NAME = ACTL.NAME);
568:

Line 571: and not exists(select 'X' from wf_process_activities PAC

567: and PAC.ACTIVITY_NAME = ACTL.NAME);
568:
569: delete from wf_activities ACT
570: where ACT.ITEM_TYPE = p_item_type
571: and not exists(select 'X' from wf_process_activities PAC
572: where PAC.ACTIVITY_ITEM_TYPE='WFSTD'
573: and PAC.ACTIVITY_ITEM_TYPE=p_item_type
574: and PAC.ACTIVITY_NAME = ACT.NAME);
575: