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','INERROR_CHECK_NOTIFY'); -- 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 351: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(

347: l_strategy_work_item_Rec.status_code := 'CANCELLED';
348: end if;
349: -- End for bug 8740185
350:
351: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
352: P_Api_Version_Number =>l_api_version_number,
353: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
354: P_Init_Msg_List => p_init_msg_list, --FND_API.G_TRUE, bug 9462104
355: p_commit => p_commit, --FND_API.G_TRUE,

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

359: x_return_status => l_return_status,
360: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );
361: -- IF PG_DEBUG < 10 THEN
362: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
363: iex_debug_pub.logMessage('CLOSE_STRY_AND_WITEMS: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||
364: 'and Status =>'||l_return_status);
365: END IF;
366: IF l_return_status = FND_API.G_RET_STS_ERROR then
367: AddFailMsg( p_object => 'STRATEGY_WORK_ITEMS',

Line 503: FROM iex_strategy_work_items

499: l_object_version_number NUMBER;
500:
501: Cursor c_get_work_items (p_strategy_id NUMBER) is
502: SELECT work_item_id, object_version_number
503: FROM iex_strategy_work_items
504: WHERE strategy_id = p_strategy_id;
505:
506:
507: BEGIN

Line 671: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;

667: l_return_status VARCHAR2(1);
668: l_msg_count NUMBER;
669: l_msg_data VARCHAR2(32767);
670: l_api_version_number CONSTANT NUMBER := 2.0;
671: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
672: l_object_version_number NUMBER;
673:
674: Cursor c_get_work_items (p_work_item_id NUMBER) is
675: SELECT object_version_number

Line 676: FROM iex_strategy_work_items

672: l_object_version_number NUMBER;
673:
674: Cursor c_get_work_items (p_work_item_id NUMBER) is
675: SELECT object_version_number
676: FROM iex_strategy_work_items
677: WHERE work_item_id =p_work_item_id;
678:
679:
680:

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

741: :=c_get_work_items_rec.object_version_number;
742: l_strategy_work_item_Rec.execute_end := sysdate;
743: -- IF PG_DEBUG < 10 THEN
744: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
745: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'Before Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items');
746: END IF;
747: -- IF PG_DEBUG < 10 THEN
748: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
749: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || '---------------------------------');

Line 752: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(

748: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
749: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || '---------------------------------');
750: END IF;
751:
752: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
753: P_Api_Version_Number =>l_api_version_number,
754: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
755: P_Init_Msg_List => p_init_msg_list, --FND_API.G_TRUE,
756: p_commit => p_commit , --FND_API.G_TRUE,

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

760: x_return_status => l_return_status,
761: XO_OBJECT_VERSION_NUMBER =>l_object_version_number );
762: -- IF PG_DEBUG < 10 THEN
763: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
764: iex_debug_pub.logMessage('UPDATE_WORK_ITEM: ' || 'After Calling IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items '||
765: 'and Status =>'||l_return_status);
766: END IF;
767: IF l_return_status = FND_API.G_RET_STS_ERROR then
768: AddFailMsg( p_object => 'STRATEGY_WORK_ITEMS',

Line 994: FROM iex_strategy_work_items

990:
991: x_work_item_done NUMBER :=0;
992: BEGIN
993: SELECT count(*) into x_work_item_done
994: FROM iex_strategy_work_items
995: WHERE strategy_id = p_strategy_id
996: and status_code not in ('CANCELLED','COMPLETE');
997:
998: return x_work_item_done;

Line 1290: iex_strategy_work_items wkitem,

1286: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
1287: wkitem.work_item_order wkitem_order,
1288: wkitem.escalated_yn escalated_yn
1289: from iex_strategies strat,
1290: iex_strategy_work_items wkitem,
1291: iex_stry_temp_work_items_b stry_temp_wkitem
1292: where wkitem.work_item_id=p_work_item_id
1293: AND wkitem.strategy_id = strat.strategy_id
1294: AND wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id;

Line 1558: iex_strategy_work_items_pvt.strategy_work_item_Rec_Type,

1554: **/
1555:
1556: /*
1557: PROCEDURE UPDATE_AND_SENDSIGNAL( P_strategy_work_item_Rec IN
1558: iex_strategy_work_items_pvt.strategy_work_item_Rec_Type,
1559: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1560: x_return_status OUT NOCOPY VARCHAR2,
1561: x_msg_count OUT NOCOPY NUMBER,
1562: x_msg_data OUT NOCOPY VARCHAR2)IS

Line 1576: iex_strategy_work_items_pvt.update_strategy_work_items(

1572: SAVEPOINT UPDATE_AND_SENDSIGNAL;
1573:
1574: x_return_status := FND_API.G_RET_STS_SUCCESS;
1575:
1576: iex_strategy_work_items_pvt.update_strategy_work_items(
1577: p_api_version_number => 2.0,
1578: p_init_msg_list => FND_API.G_TRUE,
1579: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1580: p_commit => p_commit,

Line 1651: from iex_strategy_work_items

1647:
1648: PROCEDURE update_wf_attributes (p_resource_id NUMBER , p_resourceto_id NUMBER ) IS
1649: cursor c_str_wf(p_resource_id number) is
1650: select strategy_id
1651: from iex_strategy_work_items
1652: where resource_id = p_resource_id;
1653:
1654: cursor c_fulfil_wf(p_resource_id number) is
1655: select work_item_id

Line 1656: from iex_strategy_work_items a,

1652: where resource_id = p_resource_id;
1653:
1654: cursor c_fulfil_wf(p_resource_id number) is
1655: select work_item_id
1656: from iex_strategy_work_items a,
1657: iex_stry_temp_work_items_b b
1658: where a.work_item_template_id = b.work_item_temp_id
1659: and b.work_type = 'AUTOMATIC'
1660: and a.resource_id = p_resource_id;

Line 1664: from iex_strategy_work_items a,

1660: and a.resource_id = p_resource_id;
1661:
1662: cursor c_custom_wf(p_resource_id number) is
1663: select work_item_id, b.workflow_item_type
1664: from iex_strategy_work_items a,
1665: iex_stry_temp_work_items_b b
1666: where a.work_item_template_id = b.work_item_temp_id
1667: and b.work_type = 'WORKFLOW'
1668: and a.resource_id = p_resource_id;