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_STRY_UTL_PUB dependencies on IEX_STRATEGY_WORK_ITEMS

Line 112: ,iex_strategy_work_items swit

108: ,nvl(swit.status_code,'NOTCREATED') STATUS
109: ,swit.work_item_id WORK_ITEM_ID
110: ,swit.strategy_id STRATEGY_ID
111: from iex_strategy_work_temp_xref sxref
112: ,iex_strategy_work_items swit
113: where sxref.strategy_temp_id =c_template_id
114: and swit.work_item_template_id(+) =sxref.work_item_temp_id
115: and swit.strategy_id(+) =c_strategy_id
116: union all

Line 124: ,iex_strategy_work_items swit

120: ,nvl(swit.status_code,'NOTCREATED') STATUS
121: ,swit.work_item_id WORK_ITEM_ID
122: ,susit.strategy_id STRATEGY_ID
123: from iex_strategy_user_items susit
124: ,iex_strategy_work_items swit
125: where susit.strategy_id =c_strategy_id
126: and swit.work_item_template_id(+) =susit.work_item_temp_id
127: and swit.strategy_id(+) =c_strategy_id
128: order by order_by;

Line 262: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;

258: l_return_status VARCHAR2(1);
259: l_msg_count NUMBER;
260: l_msg_data VARCHAR2(32767);
261: l_api_version_number CONSTANT NUMBER := 2.0;
262: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
263: l_strategy_rec IEX_strategy_PVT.strategy_Rec_Type;
264: l_object_version_number NUMBER;
265:
266: Cursor c_get_work_items (p_strategy_id NUMBER) is

Line 268: FROM iex_strategy_work_items

264: l_object_version_number NUMBER;
265:
266: Cursor c_get_work_items (p_strategy_id NUMBER) is
267: SELECT work_item_id, object_version_number
268: FROM iex_strategy_work_items
269: WHERE strategy_id = p_strategy_id
270: and status_code IN ('OPEN','PRE-WAIT'); -- Changed for bug#7703351 by PNAVEENK on 22-1-2009
271: -- NOT IN ('COMPLETE' ,'CANCELLED','CLOSED','TIMEOUT');
272:

Line 338: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || 'Before Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items');

334: :=c_get_work_items_rec.object_version_number;
335: l_strategy_work_item_Rec.execute_end := sysdate;
336: -- IF PG_DEBUG < 10 THEN
337: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
338: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || 'Before Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items');
339: END IF;
340: -- IF PG_DEBUG < 10 THEN
341: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
342: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || '---------------------------------');

Line 345: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(

341: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
342: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || '---------------------------------');
343: END IF;
344:
345: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
346: P_Api_Version_Number =>l_api_version_number,
347: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
348: P_Init_Msg_List =>FND_API.G_TRUE,
349: p_commit =>FND_API.G_TRUE,

Line 357: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||

353: x_return_status => l_return_status,
354: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );
355: -- IF PG_DEBUG < 10 THEN
356: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
357: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||
358: 'and Status =>'||l_return_status);
359: END IF;
360: IF l_return_status = FND_API.G_RET_STS_ERROR then
361: AddFailMsg( p_object => 'STRATEGY_WORK_ITEMS',

Line 497: FROM iex_strategy_work_items

493: l_object_version_number NUMBER;
494:
495: Cursor c_get_work_items (p_strategy_id NUMBER) is
496: SELECT work_item_id, object_version_number
497: FROM iex_strategy_work_items
498: WHERE strategy_id = p_strategy_id;
499:
500:
501: BEGIN

Line 665: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;

661: l_return_status VARCHAR2(1);
662: l_msg_count NUMBER;
663: l_msg_data VARCHAR2(32767);
664: l_api_version_number CONSTANT NUMBER := 2.0;
665: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
666: l_object_version_number NUMBER;
667:
668: Cursor c_get_work_items (p_work_item_id NUMBER) is
669: SELECT object_version_number

Line 670: FROM iex_strategy_work_items

666: l_object_version_number NUMBER;
667:
668: Cursor c_get_work_items (p_work_item_id NUMBER) is
669: SELECT object_version_number
670: FROM iex_strategy_work_items
671: WHERE work_item_id =p_work_item_id;
672:
673:
674:

Line 739: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'Before Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items');

735: :=c_get_work_items_rec.object_version_number;
736: l_strategy_work_item_Rec.execute_end := sysdate;
737: -- IF PG_DEBUG < 10 THEN
738: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
739: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'Before Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items');
740: END IF;
741: -- IF PG_DEBUG < 10 THEN
742: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
743: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || '---------------------------------');

Line 746: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(

742: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
743: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || '---------------------------------');
744: END IF;
745:
746: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
747: P_Api_Version_Number =>l_api_version_number,
748: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
749: P_Init_Msg_List =>FND_API.G_TRUE,
750: p_commit =>FND_API.G_TRUE,

Line 758: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||

754: x_return_status => l_return_status,
755: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );
756: -- IF PG_DEBUG < 10 THEN
757: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
758: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||
759: 'and Status =>'||l_return_status);
760: END IF;
761: IF l_return_status = FND_API.G_RET_STS_ERROR then
762: AddFailMsg( p_object => 'STRATEGY_WORK_ITEMS',

Line 988: FROM iex_strategy_work_items

984:
985: x_work_item_done NUMBER :=0;
986: BEGIN
987: SELECT count(*) into x_work_item_done
988: FROM iex_strategy_work_items
989: WHERE strategy_id = p_strategy_id
990: and status_code not in ('CANCELLED','COMPLETE');
991:
992: return x_work_item_done;

Line 1280: iex_strategy_work_items wkitem,

1276: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
1277: wkitem.work_item_order wkitem_order,
1278: wkitem.escalated_yn escalated_yn
1279: from iex_strategies strat,
1280: iex_strategy_work_items wkitem,
1281: iex_stry_temp_work_items_b stry_temp_wkitem
1282: where wkitem.work_item_id=p_work_item_id
1283: AND wkitem.strategy_id = strat.strategy_id
1284: AND wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id;

Line 1539: iex_strategy_work_items_pvt.strategy_work_item_Rec_Type,

1535: **/
1536:
1537: /*
1538: PROCEDURE UPDATE_AND_SENDSIGNAL( P_strategy_work_item_Rec IN
1539: iex_strategy_work_items_pvt.strategy_work_item_Rec_Type,
1540: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1541: x_return_status OUT NOCOPY VARCHAR2,
1542: x_msg_count OUT NOCOPY NUMBER,
1543: x_msg_data OUT NOCOPY VARCHAR2)IS

Line 1557: iex_strategy_work_items_pvt.update_strategy_work_items(

1553: SAVEPOINT UPDATE_AND_SENDSIGNAL;
1554:
1555: x_return_status := FND_API.G_RET_STS_SUCCESS;
1556:
1557: iex_strategy_work_items_pvt.update_strategy_work_items(
1558: p_api_version_number => 2.0,
1559: p_init_msg_list => FND_API.G_TRUE,
1560: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1561: p_commit => p_commit,