APPS.CZ_POPULATORS_PKG dependencies on DUAL

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

137:
138: Get_Seq_Increment;
139:
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;

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

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

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;

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

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

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

656:
657: --
658: -- Allocate run_id for CZ_IMP_PS_NODES
659: --
660: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO p_run_id FROM dual;
661:
662: --
663: -- by defualt feature has a type "List of Options" --
664: --

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

1008: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
1009: FND_MSG_PUB.initialize;
1010: END IF;
1011:
1012: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
1013:
1014: --
1015: -- check global flag that equals '1' if model is already locked
1016: -- by calling sequirity package

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

1355: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
1356: FND_MSG_PUB.initialize;
1357: END IF;
1358:
1359: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
1360:
1361: --
1362: -- check global flag that equals '1' if model is already locked
1363: -- by calling sequirity package

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

1501: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
1502: FND_MSG_PUB.initialize;
1503: END IF;
1504:
1505: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
1506:
1507: --
1508: -- check global flag that equals '1' if model is already locked
1509: -- by calling sequirity package