892:
893: BEGIN
894:
895: select application_installed into v_is_installed
896: from bix_dm_apps_dependency
897: where application_short_name = 'BIX_DM_OTS_INSTALLED';
898:
899: return v_is_installed;
900:
909:
910: BEGIN
911:
912: select application_installed into v_is_installed
913: from bix_dm_apps_dependency
914: where application_short_name = 'BIX_DM_OAO_INSTALLED';
915:
916: return v_is_installed;
917:
926:
927: BEGIN
928:
929: select application_installed into v_is_installed
930: from bix_dm_apps_dependency
931: where application_short_name = 'BIX_DM_OSR_INSTALLED';
932:
933: return v_is_installed;
934: