167: STRATEGY_TEMP_ID
168: )
169: SELECT
170: 1,
171: FND_GLOBAL.USER_ID,
172: SYSDATE,
173: SYSDATE,
174: FND_GLOBAL.USER_ID,
175: ISTL.LAST_UPDATE_LOGIN,
170: 1,
171: FND_GLOBAL.USER_ID,
172: SYSDATE,
173: SYSDATE,
174: FND_GLOBAL.USER_ID,
175: ISTL.LAST_UPDATE_LOGIN,
176: ISTL.REQUEST_ID,
177: nNextGroupID,
178: 'Copy of ' || ISTL.GROUP_NAME,
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);
210: IEX_DEBUG_PUB.logmessage('Copy REQUEST_ID Template ' || tempCur.REQUEST_ID);
211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);
212: IEX_DEBUG_PUB.logmessage('Copy ENABLED_FLAG Template ' || tempCur.ENABLED_FLAG);
236: STRATEGY_ORDER_ID
237: )
238: VALUES(
239: 1,
240: FND_GLOBAL.USER_ID,
241: SYSDATE,
242: SYSDATE,
243: FND_GLOBAL.USER_ID,
244: FND_GLOBAL.USER_ID,-- bug 6671798 tempCur.LAST_UPDATE_LOGIN,
239: 1,
240: FND_GLOBAL.USER_ID,
241: SYSDATE,
242: SYSDATE,
243: FND_GLOBAL.USER_ID,
244: FND_GLOBAL.USER_ID,-- bug 6671798 tempCur.LAST_UPDATE_LOGIN,
245: tempCur.REQUEST_ID,
246: nNextTempID,
247: tempCur.STRATEGY_RANK,
240: FND_GLOBAL.USER_ID,
241: SYSDATE,
242: SYSDATE,
243: FND_GLOBAL.USER_ID,
244: FND_GLOBAL.USER_ID,-- bug 6671798 tempCur.LAST_UPDATE_LOGIN,
245: tempCur.REQUEST_ID,
246: nNextTempID,
247: tempCur.STRATEGY_RANK,
248: tempCur.ENABLED_FLAG,
273: SOURCE_LANG,
274: LANGUAGE
275: )
276: VALUES (
277: FND_GLOBAL.USER_ID,
278: SYSDATE,
279: SYSDATE,
280: FND_GLOBAL.USER_ID,
281: FND_GLOBAL.USER_ID,-- bug 6671798 tempCur.LAST_UPDATE_LOGIN,
276: VALUES (
277: FND_GLOBAL.USER_ID,
278: SYSDATE,
279: SYSDATE,
280: FND_GLOBAL.USER_ID,
281: FND_GLOBAL.USER_ID,-- bug 6671798 tempCur.LAST_UPDATE_LOGIN,
282: nNextTempID,
283: 'Copy of ' || tempCur.strategy_name,
284: userenv('LANG'),
277: FND_GLOBAL.USER_ID,
278: SYSDATE,
279: SYSDATE,
280: FND_GLOBAL.USER_ID,
281: FND_GLOBAL.USER_ID,-- bug 6671798 tempCur.LAST_UPDATE_LOGIN,
282: nNextTempID,
283: 'Copy of ' || tempCur.strategy_name,
284: userenv('LANG'),
285: userenv('LANG')
348: nNextTempID,
349: xrefCur.WORK_ITEM_TEMP_ID,
350: xrefCur.WORK_ITEM_ORDER,
351: xrefCur.REQUIRED_YN,
352: FND_GLOBAL.USER_ID,
353: SYSDATE,
354: SYSDATE,
355: FND_GLOBAL.USER_ID,
356: FND_GLOBAL.USER_ID,-- bug 6671798 xrefCur.LAST_UPDATE_LOGIN,
351: xrefCur.REQUIRED_YN,
352: FND_GLOBAL.USER_ID,
353: SYSDATE,
354: SYSDATE,
355: FND_GLOBAL.USER_ID,
356: FND_GLOBAL.USER_ID,-- bug 6671798 xrefCur.LAST_UPDATE_LOGIN,
357: 1);
358:
359: END LOOP; /* xrefCur */
352: FND_GLOBAL.USER_ID,
353: SYSDATE,
354: SYSDATE,
355: FND_GLOBAL.USER_ID,
356: FND_GLOBAL.USER_ID,-- bug 6671798 xrefCur.LAST_UPDATE_LOGIN,
357: 1);
358:
359: END LOOP; /* xrefCur */
360: