APPS.CZ_POPULATORS_PKG dependencies on DUAL

Line 144: SELECT CZ_PS_NODES_S.NEXTVAL INTO mNext_PS_Node_Id FROM dual;

140:
141: Get_Seq_Increment;
142:
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;

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 163: SELECT CZ_PS_NODES_S.nextval INTO mBase_PS_Node_Id FROM dual;

159: IF p_seq_name=mPS_NODE_SEQUENCE THEN
160: IF (mNext_PS_Node_Id < mBase_PS_Node_Id+mINCREMENT-1) THEN
161: mNext_PS_Node_Id := mNext_PS_Node_Id + 1;
162: ELSE
163: SELECT CZ_PS_NODES_S.nextval INTO mBase_PS_Node_Id FROM dual;
164: mNext_PS_Node_Id:=mBase_PS_Node_Id;
165: END IF;
166: RETURN mNext_PS_Node_Id;
167: ELSIF p_seq_name=mINTL_TEXT_SEQUENCE THEN

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;

Line 460: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;

456: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
457: FND_MSG_PUB.initialize;
458: END IF;
459:
460: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
461:
462: --
463: -- check global flag that equals '1' if model is already locked
464: -- by calling sequirity package

Line 664: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO p_run_id FROM dual;

660:
661: --
662: -- Allocate run_id for CZ_IMP_PS_NODES
663: --
664: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO p_run_id FROM dual;
665:
666: --
667: -- by defualt feature has a type "List of Options" --
668: --

Line 1023: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;

1019: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
1020: FND_MSG_PUB.initialize;
1021: END IF;
1022:
1023: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
1024:
1025: --
1026: -- check global flag that equals '1' if model is already locked
1027: -- by calling sequirity package

Line 1385: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;

1381: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
1382: FND_MSG_PUB.initialize;
1383: END IF;
1384:
1385: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
1386:
1387: --
1388: -- check global flag that equals '1' if model is already locked
1389: -- by calling sequirity package

Line 1531: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;

1527: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
1528: FND_MSG_PUB.initialize;
1529: END IF;
1530:
1531: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
1532:
1533: --
1534: -- check global flag that equals '1' if model is already locked
1535: -- by calling sequirity package