APPS.CZ_LOGIC_GEN dependencies on CZ_DB_SETTINGS

Line 11220: FROM cz_db_settings

11216: --after which the transaction is commited, if commit is not disabled at all by
11217: --TwoPhaseCommit parameter set to 1.
11218:
11219: SELECT TO_NUMBER(value) INTO CommitBlockSize
11220: FROM cz_db_settings
11221: WHERE LOWER(setting_id) = COMMIT_BLOCK_SETTING_ID
11222: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11223:
11224: IF(CommitBlockSize <= 0) THEN CommitBlockSize := DEFAULT_COMMIT_BLOCK_SIZE; END IF;

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

11227: WHEN OTHERS THEN
11228: CommitBlockSize := DEFAULT_COMMIT_BLOCK_SIZE;
11229: END;
11230:
11231: /* Making the optimizations unconditional, cz_db_settings ignored.
11232: BEGIN
11233:
11234: --Get the NotTrue optimization flag, no optimization by default.
11235:

Line 11240: FROM cz_db_settings

11236: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11237: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11238: 0) --default value
11239: INTO OptimizeNotTrue
11240: FROM cz_db_settings
11241: WHERE LOWER(setting_id) = OPTIMIZE_NOTTRUE_SETTING_ID
11242: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11243:
11244: EXCEPTION

Line 11257: FROM cz_db_settings

11253: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11254: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11255: 0) --default value
11256: INTO OptimizeAllAnyOf
11257: FROM cz_db_settings
11258: WHERE LOWER(setting_id) = OPTIMIZE_ALLANYOF_SETTING_ID
11259: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11260:
11261: EXCEPTION

Line 11275: FROM cz_db_settings

11271: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11272: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11273: 0) --default value
11274: INTO ChangeChildrenOrder
11275: FROM cz_db_settings
11276: WHERE LOWER(setting_id) = CHILDREN_ORDER_SETTING_ID
11277: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11278:
11279: EXCEPTION

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

11281: ChangeChildrenOrder := 0;
11282: END;
11283: */
11284:
11285: --Enable all three optimizations here ignoring cz_db_settings.
11286:
11287: OptimizeNotTrue := 1;
11288: OptimizeAllAnyOf := 1;
11289: ChangeChildrenOrder := 1;

Line 11299: FROM cz_db_settings

11295: SELECT DECODE(LOWER(value), '1', 1, 'on', 1, 'y', 1, 'yes', 1,'true', 1, 'enable', 1,
11296: '0', 0, 'off', 0, 'n', 0, 'no', 0,'false', 0, 'disable', 0,
11297: 1) --default value
11298: INTO GenerateGatedCombo
11299: FROM cz_db_settings
11300: WHERE LOWER(setting_id) = GATED_COMBO_SETTING_ID
11301: AND LOWER(section_name) = DBSETTINGS_SECTION_NAME;
11302:
11303: EXCEPTION

Line 11316: FROM cz_db_settings

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

Line 11333: FROM cz_db_settings

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