DBA Data[Home] [Help]

APPS.CSM_HA_EVENT_PKG dependencies on WF_ITEM_TYPES

Line 602: delete from wf_item_types_tl

598:
599: delete from wf_lookup_types_tl
600: where ITEM_TYPE = p_item_type;
601:
602: delete from wf_item_types_tl
603: where NAME = p_item_type;
604:
605: delete from wf_item_types
606: where NAME = p_item_type;

Line 605: delete from wf_item_types

601:
602: delete from wf_item_types_tl
603: where NAME = p_item_type;
604:
605: delete from wf_item_types
606: where NAME = p_item_type;
607:
608: END WFRMITT;
609:

Line 632: from wf_item_types

628:
629: IF rec.WF_ITEM_TYPE IS NOT NULL THEN
630: BEGIN
631: SELECT 1 into l_t
632: from wf_item_types
633: where upper(NAME) = upper(rec.WF_ITEM_TYPE);
634:
635: WFRMITT(rec.WF_ITEM_TYPE);
636: -- COMMIT; --as the volume of data might be huge