DBA Data[Home] [Help]

APPS.XDP_PURGE dependencies on WF_ITEM_TYPES

Line 675: FROM wf_item_types

671: END IF;
672:
673: IF (p_run_mode = 'PURGE') AND (l_wi.item_key IS NOT NULL) THEN
674: SELECT persistence_type INTO l_PType
675: FROM wf_item_types
676: WHERE NAME = l_wi.item_type;
677:
678: IF SQL%NOTFOUND THEN
679: RETURN; -- DO NOTHING

Line 1500: FROM wf_item_types WHERE NAME = 'XDPRECOV';

1496:
1497: IF p_run_mode = 'PURGE' THEN
1498: IF G_PURGE_WORK_FLOW = 'TRUE' THEN
1499: SELECT persistence_type INTO WF_PURGE.PERSISTENCE_TYPE
1500: FROM wf_item_types WHERE NAME = 'XDPRECOV';
1501: WF_PURGE.TOTAL('XDPRECOV', NULL, p_time_to);
1502: END IF;
1503: END IF;
1504: