DBA Data[Home] [Help]

APPS.CZ_UI_GENERATOR dependencies on CZ_DB_SETTINGS

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

669: currUISeqVal:=currentUINode;
670: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO currTXTSeqVal FROM dual;
671: currentTXTNode:=currTXTSeqVal;
672:
673: SELECT TO_NUMBER(value) INTO mINCREMENT FROM cz_db_settings
674: WHERE UPPER(setting_id)=UPPER('OracleSequenceIncr') AND section_name='SCHEMA';
675: EXCEPTION
676: WHEN NO_DATA_FOUND THEN
677: mINCREMENT:=20;

Line 10275: SELECT VALUE INTO mCONCAT_SYMBOL FROM CZ_DB_SETTINGS

10271:
10272: --
10273: -- find concatenation symbol - it is used for "Name and Decsription" UI labels --
10274: --
10275: SELECT VALUE INTO mCONCAT_SYMBOL FROM CZ_DB_SETTINGS
10276: WHERE UPPER(SETTING_ID)='UI_NODE_NAME_CONCAT_CHARS' AND rownum<2;
10277: mCONCAT_SYMBOL:=' '||mCONCAT_SYMBOL||' ';
10278: EXCEPTION
10279: WHEN NO_DATA_FOUND THEN