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 144: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO mNext_Text_Id FROM dual;

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

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

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