APPS.CZ_BOM_SYNCH dependencies on CZ_DB_SETTINGS

Line 1571: FROM cz_db_settings

1567:
1568: BEGIN
1569:
1570: SELECT TO_NUMBER(value) INTO CommitBlockSize
1571: FROM cz_db_settings
1572: WHERE UPPER(setting_id) = COMMIT_BLOCK_SETTING_ID
1573: AND UPPER(section_name) = DBSETTINGS_SECTION_NAME;
1574:
1575: EXCEPTION

Line 1891: FROM cz_db_settings

1887: SELECT DECODE(UPPER(value), '1', 1, 'ON', 1, 'Y', 1, 'YES', 1,'TRUE', 1, 'ENABLE', 1,
1888: '0', 0, 'OFF', 0, 'N', 0, 'NO', 0,'FALSE', 0, 'DISABLE', 0,
1889: 1) --default value
1890: INTO VerifyItemProperties
1891: FROM cz_db_settings
1892: WHERE UPPER(setting_id) = VERIFY_PROPERTIES_SETTING_ID
1893: AND UPPER(section_name) = DBSETTINGS_SECTION_NAME;
1894:
1895: EXCEPTION

Line 1905: FROM cz_db_settings

1901:
1902: --Get the number of days from now after which a date is considered to be the epoch end date.
1903:
1904: SELECT TO_NUMBER(value) INTO DaysTillEpochEnd
1905: FROM cz_db_settings
1906: WHERE UPPER(setting_id) = DAYSTILLEPOCHEND_SETTING_ID
1907: AND UPPER(section_name) = DBSETTINGS_SECTION_NAME;
1908:
1909: EXCEPTION