APPS.CZ_POPULATORS_PKG dependencies on CZ_DB_SETTINGS

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

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

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

1531: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
1532:
1533: BEGIN
1534: BEGIN
1535: SELECT UPPER(value) INTO mCREATE_DEBUG_VIEWS FROM CZ_DB_SETTINGS
1536: WHERE UPPER(setting_id)='CREATEPOPVIEWS';
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: mCREATE_DEBUG_VIEWS:='N';

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

1538: WHEN OTHERS THEN
1539: mCREATE_DEBUG_VIEWS:='N';
1540: END;
1541: BEGIN
1542: SELECT UPPER(value) INTO mUSE_IMPORT FROM CZ_DB_SETTINGS
1543: WHERE UPPER(setting_id)='USEIMPORT';
1544: EXCEPTION
1545: WHEN OTHERS THEN
1546: mUSE_IMPORT:='N';

Line 1550: SELECT value INTO mUSE_LOCKING FROM CZ_DB_SETTINGS

1546: mUSE_IMPORT:='N';
1547: END;
1548:
1549: BEGIN
1550: SELECT value INTO mUSE_LOCKING FROM CZ_DB_SETTINGS
1551: WHERE setting_id = 'USE_LOCKING' AND rownum<2;
1552:
1553: IF UPPER(mUSE_LOCKING) IN('0','N','NO') THEN
1554: mDB_SETTING_USE_SECURITY := FALSE;

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

1559: mDB_SETTING_USE_SECURITY := TRUE;
1560: END;
1561:
1562: BEGIN
1563: SELECT UPPER(value) INTO mALWAYS_REGENERATE FROM CZ_DB_SETTINGS
1564: WHERE UPPER(setting_id)='ALWAYS_REGENERATE_POPULATORS';
1565: EXCEPTION
1566: WHEN OTHERS THEN
1567: mALWAYS_REGENERATE := 'N';