DBA Data[Home] [Help]

APPS.GCS_WEBADI_PKG dependencies on GCS_SYSTEM_OPTIONS

Line 1804: gcs_system_options gso

1800: fem_object_definition_b fodb,
1801: fem_object_definition_tl fodt,
1802: fem_hierarchies fh,
1803: fem_global_vs_combo_defs fgvcd,
1804: gcs_system_options gso
1805: WHERE foct.language = USERENV('LANG')
1806: AND fodb.object_definition_id = fodt.object_definition_id
1807: AND foct.object_name = p_hierarchy_name
1808: AND foct.object_id = fodt.object_id

Line 1901: -- An API to set the value for the GCS_SYSTEM_OPTIONS.INTERCO_MAP_ENABLED_FLAG

1897: --
1898: -- Procedure
1899: -- handle_interco_map_flag
1900: -- Purpose
1901: -- An API to set the value for the GCS_SYSTEM_OPTIONS.INTERCO_MAP_ENABLED_FLAG
1902: -- Arguments
1903: -- Notes
1904: --
1905: PROCEDURE handle_interco_map_flag IS

Line 1931: ' UPDATE GCS_SYSTEM_OPTIONS

1927: IF l_cnt > 0 THEN
1928: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1929: fnd_log.STRING(fnd_log.level_procedure,
1930: g_pkg_name || '.' || l_api_name ,
1931: ' UPDATE GCS_SYSTEM_OPTIONS
1932: SET INTERCO_MAP_ENABLED_FLAG = ''Y''; ');
1933: END IF;
1934: UPDATE GCS_SYSTEM_OPTIONS
1935: SET INTERCO_MAP_ENABLED_FLAG = 'Y';

Line 1934: UPDATE GCS_SYSTEM_OPTIONS

1930: g_pkg_name || '.' || l_api_name ,
1931: ' UPDATE GCS_SYSTEM_OPTIONS
1932: SET INTERCO_MAP_ENABLED_FLAG = ''Y''; ');
1933: END IF;
1934: UPDATE GCS_SYSTEM_OPTIONS
1935: SET INTERCO_MAP_ENABLED_FLAG = 'Y';
1936:
1937: ELSE
1938: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

Line 1941: ' UPDATE GCS_SYSTEM_OPTIONS

1937: ELSE
1938: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1939: fnd_log.STRING(fnd_log.level_procedure,
1940: g_pkg_name || '.' || l_api_name ,
1941: ' UPDATE GCS_SYSTEM_OPTIONS
1942: SET INTERCO_MAP_ENABLED_FLAG = ''N''; ');
1943: END IF;
1944: UPDATE GCS_SYSTEM_OPTIONS
1945: SET INTERCO_MAP_ENABLED_FLAG = 'N';

Line 1944: UPDATE GCS_SYSTEM_OPTIONS

1940: g_pkg_name || '.' || l_api_name ,
1941: ' UPDATE GCS_SYSTEM_OPTIONS
1942: SET INTERCO_MAP_ENABLED_FLAG = ''N''; ');
1943: END IF;
1944: UPDATE GCS_SYSTEM_OPTIONS
1945: SET INTERCO_MAP_ENABLED_FLAG = 'N';
1946:
1947: END IF;
1948: COMMIT;