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_STRATEGY_PVT dependencies on IEX_STRATEGIES

Line 27: v_strategy_id iex_strategies.strategy_id%TYPE;

23: IS
24: l_api_name CONSTANT VARCHAR2(30) := 'Create_strategy';
25: l_api_version_number CONSTANT NUMBER := 2.0;
26: l_return_status_full VARCHAR2(1);
27: v_strategy_id iex_strategies.strategy_id%TYPE;
28: v_object_version_number iex_strategies.object_version_number%TYPE;
29: v_rowid VARCHAR2(24);
30: v_strategy_level iex_strategies.strategy_level%TYPE;
31:

Line 28: v_object_version_number iex_strategies.object_version_number%TYPE;

24: l_api_name CONSTANT VARCHAR2(30) := 'Create_strategy';
25: l_api_version_number CONSTANT NUMBER := 2.0;
26: l_return_status_full VARCHAR2(1);
27: v_strategy_id iex_strategies.strategy_id%TYPE;
28: v_object_version_number iex_strategies.object_version_number%TYPE;
29: v_rowid VARCHAR2(24);
30: v_strategy_level iex_strategies.strategy_level%TYPE;
31:
32:

Line 30: v_strategy_level iex_strategies.strategy_level%TYPE;

26: l_return_status_full VARCHAR2(1);
27: v_strategy_id iex_strategies.strategy_id%TYPE;
28: v_object_version_number iex_strategies.object_version_number%TYPE;
29: v_rowid VARCHAR2(24);
30: v_strategy_level iex_strategies.strategy_level%TYPE;
31:
32:
33: Cursor c2 is SELECT IEX_STRATEGIES_S.nextval from dual;
34: Cursor c3 is SELECT strategy_level from iex_strategy_templates_b

Line 33: Cursor c2 is SELECT IEX_STRATEGIES_S.nextval from dual;

29: v_rowid VARCHAR2(24);
30: v_strategy_level iex_strategies.strategy_level%TYPE;
31:
32:
33: Cursor c2 is SELECT IEX_STRATEGIES_S.nextval from dual;
34: Cursor c3 is SELECT strategy_level from iex_strategy_templates_b
35: where strategy_temp_id = p_STRATEGY_rec.STRATEGY_TEMPLATE_ID;
36: BEGIN
37:

Line 127: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'Before Calling iex_strategies_pkg.insert_row');

123: END IF;
124:
125: -- IF PG_DEBUG < 10 THEN
126: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
127: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'Before Calling iex_strategies_pkg.insert_row');
128: END IF;
129:
130: -- Invoke table handler(IEX_STRATEGIES_PKG.Insert_Row)
131: IEX_STRATEGIES_PKG.Insert_Row(

Line 130: -- Invoke table handler(IEX_STRATEGIES_PKG.Insert_Row)

126: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
127: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'Before Calling iex_strategies_pkg.insert_row');
128: END IF;
129:
130: -- Invoke table handler(IEX_STRATEGIES_PKG.Insert_Row)
131: IEX_STRATEGIES_PKG.Insert_Row(
132: x_rowid =>v_rowid
133: , x_STRATEGY_ID => v_STRATEGY_id
134: ,x_STATUS_CODE => p_STRATEGY_rec.STATUS_CODE

Line 131: IEX_STRATEGIES_PKG.Insert_Row(

127: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'Before Calling iex_strategies_pkg.insert_row');
128: END IF;
129:
130: -- Invoke table handler(IEX_STRATEGIES_PKG.Insert_Row)
131: IEX_STRATEGIES_PKG.Insert_Row(
132: x_rowid =>v_rowid
133: , x_STRATEGY_ID => v_STRATEGY_id
134: ,x_STATUS_CODE => p_STRATEGY_rec.STATUS_CODE
135: ,x_STRATEGY_TEMPLATE_ID => p_STRATEGY_rec.STRATEGY_TEMPLATE_ID

Line 264: From IEX_STRATEGIES

260: REQUEST_ID,
261: PROGRAM_APPLICATION_ID,
262: PROGRAM_ID,
263: PROGRAM_UPDATE_DATE
264: From IEX_STRATEGIES
265: -- Hint: Developer need to provide Where clause
266: For Update NOWAIT;
267: */
268: l_api_name CONSTANT VARCHAR2(30) := 'Update_strategy';

Line 270: l_object_version_number iex_strategies.object_version_number%TYPE:=p_strategy_rec.object_version_number;

266: For Update NOWAIT;
267: */
268: l_api_name CONSTANT VARCHAR2(30) := 'Update_strategy';
269: l_api_version_number CONSTANT NUMBER := 2.0;
270: l_object_version_number iex_strategies.object_version_number%TYPE:=p_strategy_rec.object_version_number;
271:
272: BEGIN
273: -- IF PG_DEBUG < 10 THEN
274: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 307: -- Invoke table handler(IEX_strategies_PKG.lock_Row)

303: -- IF PG_DEBUG < 10 THEN
304: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
305: IEX_DEBUG_PUB.LogMessage('Update_strategy: ' || 'Before Calling iex_strategy_pkg.lock_row');
306: END IF;
307: -- Invoke table handler(IEX_strategies_PKG.lock_Row)
308:
309: -- call locking table handler
310: IEX_STRATEGIES_PKG.lock_row (
311: p_strategy_rec.strategy_id,

Line 310: IEX_STRATEGIES_PKG.lock_row (

306: END IF;
307: -- Invoke table handler(IEX_strategies_PKG.lock_Row)
308:
309: -- call locking table handler
310: IEX_STRATEGIES_PKG.lock_row (
311: p_strategy_rec.strategy_id,
312: l_object_version_number
313: );
314:

Line 316: -- Invoke table handler(IEX_STRATEGIES_PKG.Update_Row)

312: l_object_version_number
313: );
314:
315:
316: -- Invoke table handler(IEX_STRATEGIES_PKG.Update_Row)
317: IEX_STRATEGIES_PKG.Update_Row(
318: x_STRATEGY_ID => p_STRATEGY_rec.STRATEGY_ID
319: ,x_STATUS_CODE => p_STRATEGY_rec.STATUS_CODE
320: ,x_STRATEGY_TEMPLATE_ID => p_STRATEGY_rec.STRATEGY_TEMPLATE_ID

Line 317: IEX_STRATEGIES_PKG.Update_Row(

313: );
314:
315:
316: -- Invoke table handler(IEX_STRATEGIES_PKG.Update_Row)
317: IEX_STRATEGIES_PKG.Update_Row(
318: x_STRATEGY_ID => p_STRATEGY_rec.STRATEGY_ID
319: ,x_STATUS_CODE => p_STRATEGY_rec.STATUS_CODE
320: ,x_STRATEGY_TEMPLATE_ID => p_STRATEGY_rec.STRATEGY_TEMPLATE_ID
321: ,x_DELINQUENCY_ID => p_STRATEGY_rec.DELINQUENCY_ID

Line 448: -- Invoke table handler(IEX_STRATEGIES_PKG.Delete_Row)

444:
445: --
446: -- Api body
447: --
448: -- Invoke table handler(IEX_STRATEGIES_PKG.Delete_Row)
449: IEX_STRATEGIES_PKG.Delete_Row(p_STRATEGY_ID);
450:
451: --
452: -- End of API body

Line 449: IEX_STRATEGIES_PKG.Delete_Row(p_STRATEGY_ID);

445: --
446: -- Api body
447: --
448: -- Invoke table handler(IEX_STRATEGIES_PKG.Delete_Row)
449: IEX_STRATEGIES_PKG.Delete_Row(p_STRATEGY_ID);
450:
451: --
452: -- End of API body
453: --