APPS.IEX_STRATEGY_TEMPLATES_PKG dependencies on DUAL

Line 140: into nNextGroupID from DUAL;

136: RETURN_STATUS := 'A';
137:
138: IEX_DEBUG_PUB.logmessage('Copy Strategy Group ');
139: select IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL
140: into nNextGroupID from DUAL;
141:
142: IEX_DEBUG_PUB.logmessage('Next Strategy GROUP_ID ID = ' || nNextGroupID);
143: IEX_DEBUG_PUB.logmessage('AAAAAAAAAAAAA = ' || nNextGroupID);
144: RETURN_STATUS := 'B';

Line 205: into nNextTempID from DUAL;

201:
202: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);
203:
204: select IEX_STRATEGY_TEMPLATES_S.NEXTVAL
205: into nNextTempID from DUAL;
206:
207: IEX_DEBUG_PUB.logmessage('Next Strategy Template ID = ' || nNextTempID);
208: IEX_DEBUG_PUB.logmessage('Copy FND_GLOBAL.USER_ID ' || FND_GLOBAL.USER_ID);
209: IEX_DEBUG_PUB.logmessage('Copy LAST_UPDATE_LOGIN ' || tempCur.LAST_UPDATE_LOGIN);

Line 331: into nNextXrefID FROM DUAL;

327: IEX_DEBUG_PUB.logmessage('Copy XRef for Template = ' || tempCur.STRATEGY_TEMP_ID ||
328: ' and Xref ID = ' || xrefCur.WORK_TEMP_XREF_ID );
329:
330: select IEX_STRATEGY_WORK_TEMP_XREF_S.NEXTVAL
331: into nNextXrefID FROM DUAL;
332:
333: IEX_DEBUG_PUB.logmessage('Next Work Item Xref ID from seq = ' || nNextXrefID);
334:
335: INSERT INTO IEX_STRATEGY_WORK_TEMP_XREF(