DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_PS_NODES_S

Line 73: SELECT CZ_PS_NODES_S.NEXTVAL INTO currentPSNode FROM dual;

69: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
70:
71: PROCEDURE Initialize IS
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';

Line 94: SELECT CZ_PS_NODES_S.nextval INTO currPSSeqVal FROM dual;

90:
91: IF currentPSNode 92: currentPSNode:=currentPSNode+1;
93: ELSE
94: SELECT CZ_PS_NODES_S.nextval INTO currPSSeqVal FROM dual;
95: currentPSNode:=currPSSeqVal;
96: END IF;
97: RETURN currentPSNode;
98: END getPSSeqVal;