APPS.CZ_POPULATORS_PKG dependencies on CZ_DB_SETTINGS

Line 131: SELECT TO_NUMBER(value) INTO mINCREMENT FROM cz_db_settings

127: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
128:
129: PROCEDURE Get_Seq_Increment IS
130: BEGIN
131: SELECT TO_NUMBER(value) INTO mINCREMENT FROM cz_db_settings
132: WHERE UPPER(setting_id)=UPPER('OracleSequenceIncr') AND section_name='SCHEMA';
133: END Get_Seq_Increment;
134:
135: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 1561: SELECT UPPER(value) INTO mCREATE_DEBUG_VIEWS FROM CZ_DB_SETTINGS

1557: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
1558:
1559: BEGIN
1560: BEGIN
1561: SELECT UPPER(value) INTO mCREATE_DEBUG_VIEWS FROM CZ_DB_SETTINGS
1562: WHERE UPPER(setting_id)='CREATEPOPVIEWS';
1563: EXCEPTION
1564: WHEN OTHERS THEN
1565: mCREATE_DEBUG_VIEWS:='N';

Line 1568: SELECT UPPER(value) INTO mUSE_IMPORT FROM CZ_DB_SETTINGS

1564: WHEN OTHERS THEN
1565: mCREATE_DEBUG_VIEWS:='N';
1566: END;
1567: BEGIN
1568: SELECT UPPER(value) INTO mUSE_IMPORT FROM CZ_DB_SETTINGS
1569: WHERE UPPER(setting_id)='USEIMPORT';
1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: mUSE_IMPORT:='N';

Line 1576: SELECT value INTO mUSE_LOCKING FROM CZ_DB_SETTINGS

1572: mUSE_IMPORT:='N';
1573: END;
1574:
1575: BEGIN
1576: SELECT value INTO mUSE_LOCKING FROM CZ_DB_SETTINGS
1577: WHERE setting_id = 'USE_LOCKING' AND rownum<2;
1578:
1579: IF UPPER(mUSE_LOCKING) IN('0','N','NO') THEN
1580: mDB_SETTING_USE_SECURITY := FALSE;

Line 1589: SELECT UPPER(value) INTO mALWAYS_REGENERATE FROM CZ_DB_SETTINGS

1585: mDB_SETTING_USE_SECURITY := TRUE;
1586: END;
1587:
1588: BEGIN
1589: SELECT UPPER(value) INTO mALWAYS_REGENERATE FROM CZ_DB_SETTINGS
1590: WHERE UPPER(setting_id)='ALWAYS_REGENERATE_POPULATORS';
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: mALWAYS_REGENERATE := 'N';