eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_CHECKLIST_UTILITY dependencies on IEX_STRATEGY_TEMPLATE_GROUPS

Line 216: -- WHERE istl.strategy_temp_id > 10000 and NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg -- bug 6067428

212: PROCEDURE checkUpgradeStrategies( x_return_status OUT NOCOPY VARCHAR2) IS
213:
214: CURSOR c_CheckStrategyGroups IS
215: SELECT COUNT(1) FROM IEX_STRATEGY_TEMPLATES_B istl
216: -- WHERE istl.strategy_temp_id > 10000 and NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg -- bug 6067428
217: WHERE istl.strategy_temp_id >= 10000 and NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
218: WHERE istg.STRATEGY_TEMP_ID = ISTL.STRATEGY_TEMP_ID);
219:
220: l_Upgrades NUMBER := 0;

Line 217: WHERE istl.strategy_temp_id >= 10000 and NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg

213:
214: CURSOR c_CheckStrategyGroups IS
215: SELECT COUNT(1) FROM IEX_STRATEGY_TEMPLATES_B istl
216: -- WHERE istl.strategy_temp_id > 10000 and NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg -- bug 6067428
217: WHERE istl.strategy_temp_id >= 10000 and NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
218: WHERE istg.STRATEGY_TEMP_ID = ISTL.STRATEGY_TEMP_ID);
219:
220: l_Upgrades NUMBER := 0;
221: l_max_group NUMBER := 0;

Line 230: INSERT INTO IEX_STRATEGY_TEMPLATE_GROUPS (

226: FETCH C_CheckStrategyGroups INTO l_Upgrades;
227: close c_CheckStrategyGroups;
228: if l_Upgrades > 0 then
229: IEX_DEBUG_PUB.logmessage('Inserting into StrategyGroups');
230: INSERT INTO IEX_STRATEGY_TEMPLATE_GROUPS (
231: OBJECT_VERSION_NUMBER,
232: CREATED_BY,
233: CREATION_DATE,
234: LAST_UPDATE_DATE,

Line 261: ISTL.STRATEGY_TEMP_ID, --IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL, -- bug 9256394

257: ISTL.LAST_UPDATE_DATE,
258: ISTL.LAST_UPDATED_BY,
259: ISTL.LAST_UPDATE_LOGIN,
260: ISTL.REQUEST_ID,
261: ISTL.STRATEGY_TEMP_ID, --IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL, -- bug 9256394
262: ISTL.STRATEGY_NAME,
263: ISTL.STRATEGY_RANK,
264: ISTL.ENABLED_FLAG,
265: ISTL.CATEGORY_TYPE,

Line 279: AND NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg

275: ISTL.STRATEGY_TEMP_ID
276: FROM IEX_STRATEGY_TEMPLATES_VL ISTL
277: WHERE istl.strategy_temp_id >= 10000
278: AND (istl.strategy_temp_group_id is NULL or istl.strategy_temp_group_id = 0)
279: AND NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
280: WHERE istg.STRATEGY_TEMP_ID = ISTL.STRATEGY_TEMP_ID);
281:
282: UPDATE IEX_STRATEGY_TEMPLATES_b istl
283: SET istl.STRATEGY_TEMP_GROUP_ID =

Line 284: (SELECT istg.GROUP_ID FROM IEX_STRATEGY_TEMPLATE_GROUPS istg

280: WHERE istg.STRATEGY_TEMP_ID = ISTL.STRATEGY_TEMP_ID);
281:
282: UPDATE IEX_STRATEGY_TEMPLATES_b istl
283: SET istl.STRATEGY_TEMP_GROUP_ID =
284: (SELECT istg.GROUP_ID FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
285: WHERE istg.strategy_temp_id = istl.strategy_temp_id)
286: WHERE istl.strategy_temp_id >= 10000
287: AND (istl.strategy_temp_group_id is NULL or istl.strategy_temp_group_id = 0);
288: commit;

Line 293: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval into l_next_seq from dual;

289:
290: begin
291: select max(strategy_temp_id) into l_max_group from iex_strategy_templates_b;
292:
293: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval into l_next_seq from dual;
294:
295: while l_next_seq <= l_max_group loop
296: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval INTO l_next_seq from dual;
297: end loop;

Line 296: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval INTO l_next_seq from dual;

292:
293: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval into l_next_seq from dual;
294:
295: while l_next_seq <= l_max_group loop
296: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval INTO l_next_seq from dual;
297: end loop;
298:
299: exception
300: when others then

Line 343: from iex_object_filters obj, iex_strategy_template_groups stg

339:
340: -- Bug 8479638 by ehuh 5/6/2009
341: Cursor c_object_filter Is
342: select obj.object_id,obj.object_filter_id,obj.last_updated_by,obj.last_update_login
343: from iex_object_filters obj, iex_strategy_template_groups stg
344: where stg.group_id = obj.object_id
345: and obj.object_filter_type = 'IEXSTRAT'
346: and obj.object_id > 10000
347: and (stg.object_filter_id is null or stg.object_filter_id = 0);

Line 357: update iex_strategy_template_groups

353: IEX_DEBUG_PUB.logmessage('Update CheckList ' || p_checklist_item_id);
354:
355: -- Bug 8479638 by ehuh 5/6/2009
356: For rec_object_filter IN c_object_filter LOOP
357: update iex_strategy_template_groups
358: set object_filter_id=rec_object_filter.object_filter_id,last_update_date=sysdate,last_updated_by=rec_object_filter.last_updated_by,last_update_login=rec_object_filter.last_update_login
359: where group_id = rec_object_filter.object_id;
360: End LOOP;
361: