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: BEGIN

Line 228: INSERT INTO IEX_STRATEGY_TEMPLATE_GROUPS (

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

Line 259: IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL,

255: ISTL.LAST_UPDATE_DATE,
256: ISTL.LAST_UPDATED_BY,
257: ISTL.LAST_UPDATE_LOGIN,
258: ISTL.REQUEST_ID,
259: IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL,
260: ISTL.STRATEGY_NAME,
261: ISTL.STRATEGY_RANK,
262: ISTL.ENABLED_FLAG,
263: ISTL.CATEGORY_TYPE,

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

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

Line 281: (SELECT istg.GROUP_ID FROM IEX_STRATEGY_TEMPLATE_GROUPS istg

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