DBA Data[Home] [Help]

APPS.IEX_STRATEGY_TEMPLATES_PKG dependencies on IEX_STRATEGY_TEMPLATES_B

Line 12: from IEX_STRATEGY_TEMPLATES_B B

8: begin
9: delete from IEX_STRATEGY_TEMPLATES_TL T
10: where not exists
11: (select NULL
12: from IEX_STRATEGY_TEMPLATES_B B
13: where B.STRATEGY_TEMP_ID = T.STRATEGY_TEMP_ID
14: );
15:
16: update IEX_STRATEGY_TEMPLATES_TL T

Line 215: INSERT INTO IEX_STRATEGY_TEMPLATES_B (

211: IEX_DEBUG_PUB.logmessage('Copy STRATEGY_RANK Template ' || tempCur.STRATEGY_RANK);
212: IEX_DEBUG_PUB.logmessage('Copy ENABLED_FLAG Template ' || tempCur.ENABLED_FLAG);
213: IEX_DEBUG_PUB.logmessage('Copy Strategy Template ' || tempCur.STRATEGY_TEMP_ID);
214:
215: INSERT INTO IEX_STRATEGY_TEMPLATES_B (
216: OBJECT_VERSION_NUMBER,
217: CREATED_BY,
218: CREATION_DATE,
219: LAST_UPDATE_DATE,

Line 263: IEX_DEBUG_PUB.logmessage('Done inserting... IEX_STRATEGY_TEMPLATES_B');

259: tempCur.STRATEGY_ORDER_ID
260: );
261:
262:
263: IEX_DEBUG_PUB.logmessage('Done inserting... IEX_STRATEGY_TEMPLATES_B');
264:
265: INSERT INTO IEX_STRATEGY_TEMPLATES_tl (
266: CREATED_BY,
267: CREATION_DATE,