APPS.CSM_HA_SERVICE_PUB dependencies on CSM_HA_ACTIVE_WF_COMPONENTS

Line 23: FROM CSM_HA_ACTIVE_WF_COMPONENTS

19: CURSOR c_status IS
20: SELECT DECODE(CSM_HA_SERVICE_PUB.GET_HA_STATUS,
21: 'HA_RECORD',ENABLED_ON_RECORD,
22: 'HA_APPLY',ENABLED_ON_APPLY)
23: FROM CSM_HA_ACTIVE_WF_COMPONENTS
24: WHERE WF_ITEM_TYPE=p_item_type;
25:
26: l_status VARCHAR2(1);
27: BEGIN

Line 43: FROM CSM_HA_ACTIVE_WF_COMPONENTS

39: CURSOR c_status IS
40: SELECT DECODE(CSM_HA_SERVICE_PUB.GET_HA_STATUS,
41: 'HA_RECORD',ENABLED_ON_RECORD,
42: 'HA_APPLY',ENABLED_ON_APPLY)
43: FROM CSM_HA_ACTIVE_WF_COMPONENTS
44: WHERE WF_EVENT_NAME=p_event_name
45: AND WF_EVENT_SUBSCRIPTION_GUID IS NULL;
46:
47: l_status VARCHAR2(1);

Line 64: FROM CSM_HA_ACTIVE_WF_COMPONENTS

60: CURSOR c_status IS
61: SELECT DECODE(CSM_HA_SERVICE_PUB.GET_HA_STATUS,
62: 'HA_RECORD',ENABLED_ON_RECORD,
63: 'HA_APPLY',ENABLED_ON_APPLY)
64: FROM CSM_HA_ACTIVE_WF_COMPONENTS
65: WHERE WF_EVENT_NAME IS NOT NULL
66: AND WF_EVENT_SUBSCRIPTION_GUID =p_sub_guid;
67:
68: l_status VARCHAR2(1);