APPS.IEX_STRATEGY_TEMPLATES_PKG dependencies on IEX_STRATEGY_TEMPLATE_GROUPS

Line 139: select IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL

135:
136: RETURN_STATUS := 'A';
137:
138: IEX_DEBUG_PUB.logmessage('Copy Strategy Group ');
139: select IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL
140: into nNextGroupID from DUAL;
141:
142: IEX_DEBUG_PUB.logmessage('Next Strategy GROUP_ID ID = ' || nNextGroupID);
143: IEX_DEBUG_PUB.logmessage('AAAAAAAAAAAAA = ' || nNextGroupID);

Line 146: INSERT INTO IEX_STRATEGY_TEMPLATE_GROUPS (

142: IEX_DEBUG_PUB.logmessage('Next Strategy GROUP_ID ID = ' || nNextGroupID);
143: IEX_DEBUG_PUB.logmessage('AAAAAAAAAAAAA = ' || nNextGroupID);
144: RETURN_STATUS := 'B';
145:
146: INSERT INTO IEX_STRATEGY_TEMPLATE_GROUPS (
147: OBJECT_VERSION_NUMBER,
148: CREATED_BY,
149: CREATION_DATE,
150: LAST_UPDATE_DATE,

Line 191: FROM IEX_STRATEGY_TEMPLATE_GROUPS istl

187: ISTL.OBJECT_FILTER_ID,
188: ISTL.STRATEGY_LEVEL,
189: ISTL.SCORE_TOLERANCE,
190: ISTL.STRATEGY_TEMP_ID
191: FROM IEX_STRATEGY_TEMPLATE_GROUPS istl
192: WHERE istl.GROUP_ID = p_GROUP_ID AND
193: NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
194: WHERE istg.GROUP_NAME = 'Copy of ' || istl.GROUP_NAME );
195:

Line 193: NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg

189: ISTL.SCORE_TOLERANCE,
190: ISTL.STRATEGY_TEMP_ID
191: FROM IEX_STRATEGY_TEMPLATE_GROUPS istl
192: WHERE istl.GROUP_ID = p_GROUP_ID AND
193: NOT EXISTS (SELECT 1 FROM IEX_STRATEGY_TEMPLATE_GROUPS istg
194: WHERE istg.GROUP_NAME = 'Copy of ' || istl.GROUP_NAME );
195:
196: IEX_DEBUG_PUB.logmessage('Done copying the Group ');
197: IEX_DEBUG_PUB.logmessage('BBBBBBBBBBBB = ' || nNextGroupID);