DBA Data[Home] [Help]

APPS.CSM_HA_EVENT_PKG dependencies on FND_PROFILE

Line 654: x:=FND_PROFILE.SAVE('CSM_HA_MODE',p_value,'SITE');

650:
651: CSM_UTIL_PKG.LOG('Setting HA Profile to value :'||p_value,
652: 'CSM_HA_EVENT_PKG.SET_HA_PROFILE', FND_LOG.LEVEL_PROCEDURE);
653:
654: x:=FND_PROFILE.SAVE('CSM_HA_MODE',p_value,'SITE');
655: COMMIT;
656: END SET_HA_PROFILE;
657:
658: FUNCTION GET_HA_PROFILE_VALUE return VARCHAR2

Line 665: FROM FND_PROFILE_OPTION_VALUES

661: BEGIN
662:
663: BEGIN
664: SELECT trim(PROFILE_OPTION_VALUE) INTO l_prf
665: FROM FND_PROFILE_OPTION_VALUES
666: WHERE (APPLICATION_ID,PROFILE_OPTION_ID) IN (SELECT APPLICATION_ID,PROFILE_OPTION_ID
667: FROM FND_PROFILE_OPTIONS
668: WHERE PROFILE_OPTION_NAME ='CSM_HA_MODE')
669: AND LEVEL_ID=10001 AND LEVEL_VALUE=0;

Line 667: FROM FND_PROFILE_OPTIONS

663: BEGIN
664: SELECT trim(PROFILE_OPTION_VALUE) INTO l_prf
665: FROM FND_PROFILE_OPTION_VALUES
666: WHERE (APPLICATION_ID,PROFILE_OPTION_ID) IN (SELECT APPLICATION_ID,PROFILE_OPTION_ID
667: FROM FND_PROFILE_OPTIONS
668: WHERE PROFILE_OPTION_NAME ='CSM_HA_MODE')
669: AND LEVEL_ID=10001 AND LEVEL_VALUE=0;
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN