DBA Data[Home] [Help]

APPS.CZ_CONFIG_API_PVT dependencies on CZ_DB_SETTINGS

Line 946: SELECT UPPER(LTRIM(RTRIM(value))) INTO v_table_name FROM cz_db_settings

942: v_table_name VARCHAR2(100) := NULL;
943:
944: BEGIN
945:
946: SELECT UPPER(LTRIM(RTRIM(value))) INTO v_table_name FROM cz_db_settings
947: WHERE UPPER(setting_id) = 'CUSTOM_CONFIG_TABLE'
948: AND UPPER(section_name) = 'CONFIGURATION';
949:
950: copy_custom_data(p_old_config_hdr_id, p_old_config_rev_nbr,

Line 1498: FROM CZ_DB_SETTINGS

1494:
1495: --------------------------------------------------------------------------------
1496: BEGIN
1497: SELECT NVL(cz_utils.conv_num(value),DEFAULT_INCR) INTO id_increment
1498: FROM CZ_DB_SETTINGS
1499: WHERE section_name='SCHEMA' AND setting_id='OracleSequenceIncr';
1500:
1501: END CZ_CONFIG_API_PVT;