APPS.CSM_HA_SERVICE_PUB dependencies on CSM_HA_SERVICE_PUB

Line 1: PACKAGE BODY CSM_HA_SERVICE_PUB AS

1: PACKAGE BODY CSM_HA_SERVICE_PUB AS
2: /* $Header: csmhsrvb.pls 120.0.12010000.1 2010/04/08 06:39:15 saradhak noship $*/
3:
4: Function GET_HA_STATUS return VARCHAR2
5: IS

Line 20: SELECT DECODE(CSM_HA_SERVICE_PUB.GET_HA_STATUS,

16:
17: Function IS_WF_ITEM_TYPE_ENABLED( p_item_type IN VARCHAR2) return VARCHAR2
18: IS
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;

Line 40: SELECT DECODE(CSM_HA_SERVICE_PUB.GET_HA_STATUS,

36:
37: Function IS_WF_EVENT_ENABLED( p_event_name IN VARCHAR2) return VARCHAR2
38: IS
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

Line 61: SELECT DECODE(CSM_HA_SERVICE_PUB.GET_HA_STATUS,

57:
58: Function IS_WF_BES_ENABLED(p_sub_guid IN RAW) return VARCHAR2
59: IS
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

Line 78: END CSM_HA_SERVICE_PUB;

74:
75: return l_status;
76: END IS_WF_BES_ENABLED;
77:
78: END CSM_HA_SERVICE_PUB;
79: