[Home] [Help]
1329: x_strategy_template_id out NOCOPY number) IS
1330: /*
1331: CURSOR c_strategyTemp(pCategoryType varchar2, pDelinquencyID number) IS
1332: SELECT ST.strategy_temp_id, ST.strategy_rank, OBF.ENTITY_NAME
1333: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
1334: where ST.category_type = pCategoryType and ST.Check_List_YN = 'N' AND
1335: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and
1336: OBF.OBJECT_FILTER_TYPE(+) = 'IEXSTRAT'
1337: and not exists
1409:
1410: IF l_DefaultStrategyLevel = 10 or l_DefaultStrategyLevel = 20 or l_DefaultStrategyLevel = 30 THEN
1411: OPEN c_strategyTemp
1412: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
1413: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
1414: where ST.Check_List_YN = l_No AND
1415: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> l_No) and
1416: st.strategy_level = l_DefaultStrategyLevel and
1417: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and
1433: ORDER BY to_number(strategy_rank) DESC;
1434: ELSE
1435: OPEN c_strategyTemp
1436: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
1437: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
1438: where ST.category_type = chk_obj_type and ST.Check_List_YN = l_No AND
1439: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> l_No) and
1440: st.strategy_level = l_DefaultStrategyLevel and
1441: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and
1566: FUNCTION GetDefaultStrategyTempID return NUMBER IS
1567: l_StrategyTempID number;
1568: lCursorStrategyTempID number;
1569: Cursor C_getFirstTempID IS
1570: Select st.Strategy_Temp_ID FROM IEX_STRATEGY_TEMPLATES_B st where
1571: st.Check_List_YN = l_No AND st.ENABLED_FLAG <> l_No
1572: -- Bug 7392752 by Ehuh
1573: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE)) AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
1574: and exists (select 1 from iex_strategy_template_groups tg