DBA Data[Home] [Help]

APPS.CZ_POPULATORS_PKG dependencies on CZ_INTL_TEXTS_S

Line 41: mINTL_TEXT_SEQUENCE VARCHAR2(255) := 'CZ_INTL_TEXTS_S';

37:
38: FAILED_TO_LOCK_MODEL EXCEPTION;
39:
40: mPS_NODE_SEQUENCE VARCHAR2(255) := 'CZ_PS_NODES_S';
41: mINTL_TEXT_SEQUENCE VARCHAR2(255) := 'CZ_INTL_TEXTS_S';
42:
43: mINCREMENT NUMBER := 20;
44:
45: mNext_PS_Node_Id NUMBER;

Line 147: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO mNext_Text_Id FROM dual;

143: IF p_seq_name=mPS_NODE_SEQUENCE THEN
144: SELECT CZ_PS_NODES_S.NEXTVAL INTO mNext_PS_Node_Id FROM dual;
145: mBase_PS_Node_Id:=mNext_PS_Node_Id;
146: ELSIF p_seq_name=mINTL_TEXT_SEQUENCE THEN
147: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO mNext_Text_Id FROM dual;
148: mBase_Text_Id := mNext_Text_Id;
149: END IF;
150:
151: END Initialize_Sequence;

Line 171: SELECT CZ_INTL_TEXTS_S.nextval INTO mBase_Text_Id FROM dual;

167: ELSIF p_seq_name=mINTL_TEXT_SEQUENCE THEN
168: IF (mNext_Text_Id < mBase_Text_Id+mINCREMENT-1) THEN
169: mNext_Text_Id := mNext_Text_Id + 1;
170: ELSE
171: SELECT CZ_INTL_TEXTS_S.nextval INTO mBase_Text_Id FROM dual;
172: mNext_Text_Id:=mBase_Text_Id;
173: END IF;
174: RETURN mNext_Text_Id;
175: END IF;