DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_DB_SETTINGS

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

72: BEGIN
73: SELECT CZ_PS_NODES_S.NEXTVAL INTO currentPSNode FROM dual;
74: currPSSeqVal:=currentPSNode;
75:
76: SELECT TO_NUMBER(value) INTO mINCREMENT FROM cz_db_settings
77: WHERE UPPER(setting_id)=UPPER('OracleSequenceIncr') AND section_name='SCHEMA';
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN
80: mINCREMENT:=20;