APPS.CZ_LOGIC_GEN dependencies on CZ_DB_SETTINGS

Line 11295: FROM cz_db_settings

11291: --after which the transaction is commited, if commit is not disabled at all by
11292: --TwoPhaseCommit parameter set to 1.
11293:
11294: SELECT TO_NUMBER(value) INTO CommitBlockSize
11295: FROM cz_db_settings
11296: WHERE LOWER(setting_id) = COMMIT_BLOCK_SETTING_ID
11297: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11298:
11299: IF(CommitBlockSize <= 0) THEN CommitBlockSize := DEFAULT_COMMIT_BLOCK_SIZE; END IF;

Line 11306: /* Making the optimizations unconditional, cz_db_settings ignored.

11302: WHEN OTHERS THEN
11303: CommitBlockSize := DEFAULT_COMMIT_BLOCK_SIZE;
11304: END;
11305:
11306: /* Making the optimizations unconditional, cz_db_settings ignored.
11307: BEGIN
11308:
11309: --Get the NotTrue optimization flag, no optimization by default.
11310:

Line 11315: FROM cz_db_settings

11311: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11312: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11313: 0) --default value
11314: INTO OptimizeNotTrue
11315: FROM cz_db_settings
11316: WHERE LOWER(setting_id) = OPTIMIZE_NOTTRUE_SETTING_ID
11317: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11318:
11319: EXCEPTION

Line 11332: FROM cz_db_settings

11328: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11329: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11330: 0) --default value
11331: INTO OptimizeAllAnyOf
11332: FROM cz_db_settings
11333: WHERE LOWER(setting_id) = OPTIMIZE_ALLANYOF_SETTING_ID
11334: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11335:
11336: EXCEPTION

Line 11350: FROM cz_db_settings

11346: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11347: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11348: 0) --default value
11349: INTO ChangeChildrenOrder
11350: FROM cz_db_settings
11351: WHERE LOWER(setting_id) = CHILDREN_ORDER_SETTING_ID
11352: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11353:
11354: EXCEPTION

Line 11360: --Enable all three optimizations here ignoring cz_db_settings.

11356: ChangeChildrenOrder := 0;
11357: END;
11358: */
11359:
11360: --Enable all three optimizations here ignoring cz_db_settings.
11361:
11362: OptimizeNotTrue := 1;
11363: OptimizeAllAnyOf := 1;
11364: ChangeChildrenOrder := 1;

Line 11374: FROM cz_db_settings

11370: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11371: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11372: 1) --default value
11373: INTO GenerateGatedCombo
11374: FROM cz_db_settings
11375: WHERE LOWER(setting_id) = GATED_COMBO_SETTING_ID
11376: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11377:
11378: EXCEPTION

Line 11391: FROM cz_db_settings

11387: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11388: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11389: 1) --default value
11390: INTO StopOnFatalRuleError
11391: FROM cz_db_settings
11392: WHERE LOWER(setting_id) = STOP_ON_ERROR_SETTING_ID
11393: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11394:
11395: EXCEPTION

Line 11408: FROM cz_db_settings

11404: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11405: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11406: 1) --default value
11407: INTO GenerateUpdatedOnly
11408: FROM cz_db_settings
11409: WHERE LOWER(setting_id) = UPDATED_ONLY_SETTING_ID
11410: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11411:
11412: EXCEPTION