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;