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

Line 30: iex_strategy_work_items b

26: cursor c_get_itemtype is
27: select a.workflow_item_type itemtype,
28: b.work_item_id
29: from iex_stry_temp_work_items_vl a,
30: iex_strategy_work_items b
31: where a.work_item_temp_id =b.WORK_ITEM_TEMPLATE_ID
32: and b.strategy_id =p_strategy_id
33: and a.workflow_item_type IS NOT NULL;
34:

Line 37: from iex_strategy_work_items a,

33: and a.workflow_item_type IS NOT NULL;
34:
35: cursor c_workitems is
36: select a.work_item_id
37: from iex_strategy_work_items a,
38: iex_stry_temp_work_items_vl b
39: where a.strategy_id = p_strategy_id
40: and a.work_item_template_id =b.work_item_temp_id
41: and (b.fulfil_temp_id IS NOT NULL or b.xdo_template_id IS NOT NULL) ;

Line 208: ieX_strategy_work_items b

204: END IF;
205: select count(*)
206: INTO v_result
207: from iex_strategies a,
208: ieX_strategy_work_items b
209: where a.strategy_id =p_strategy_id
210: and a.strategy_id =b.strategy_id
211: and a.next_work_item_id =b.work_item_id
212: and b.status_code ='OPEN'

Line 787: ,iex_strategy_work_items swit

783: ,nvl(swit.status_code,'NOTCREATED') STATUS
784: ,swit.work_item_id WORK_ITEM_ID
785: ,swit.strategy_id STRATEGY_ID
786: from iex_strategy_work_temp_xref sxref
787: ,iex_strategy_work_items swit
788: where sxref.strategy_temp_id =p_template_id
789: and swit.work_item_template_id(+) =sxref.work_item_temp_id
790: and swit.strategy_id(+) =p_strategy_id
791: union all

Line 799: ,iex_strategy_work_items swit

795: ,nvl(swit.status_code,'NOTCREATED') STATUS
796: ,swit.work_item_id WORK_ITEM_ID
797: ,susit.strategy_id STRATEGY_ID
798: from iex_strategy_user_items susit
799: ,iex_strategy_work_items swit
800: where susit.strategy_id =p_strategy_id
801: and swit.work_item_template_id(+) =susit.work_item_temp_id
802: and swit.strategy_id(+) =p_strategy_id
803: order by order_by;

Line 813: from iex_strategy_work_items wkitem,

809: wkitem.work_item_order ORDER_BY,
810: wkitem.work_item_id WORK_ITEM_ID,
811: wkitem.work_item_template_id WORK_ITEM_TEMPLATE_ID,
812: wkitem.status_code STATUS
813: from iex_strategy_work_items wkitem,
814: iex_stry_temp_work_items_vl stry_temp_wkitem
815: WHERE
816: wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id
817: and wkitem.strategy_id =p_strategy_id

Line 833: AND not exists ( select 'x' from iex_strategy_work_items wkitem where

829: WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID
830: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
831: and stry.strategy_id =p_strategy_id
832: --not in workitems table
833: AND not exists ( select 'x' from iex_strategy_work_items wkitem where
834: wkitem.strategy_id = stry.strategy_id
835: and wkitem.work_item_template_id = xref.work_item_temp_id
836: and wkitem.work_item_order = xref.work_item_order
837: and wkitem.strategy_id =p_strategy_id

Line 867: ( select 'x' from iex_strategy_work_items wkitem

863: and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
864: and stry.strategy_id =p_strategy_id
865: AND not exists
866: -- exclude useritem whoch is already a workitem
867: ( select 'x' from iex_strategy_work_items wkitem
868: where wkitem.strategy_id = stry.strategy_id
869: and wkitem.work_item_template_id = uitem.work_item_temp_id
870: and uitem.work_item_order = wkitem.work_item_order
871: and wkitem.strategy_id =p_strategy_id)

Line 901: l_strategy_work_item_rec IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;

897: from iex_stry_temp_work_items_vl
898: where work_item_temp_id =p_work_item_temp_id;
899:
900:
901: l_strategy_work_item_rec IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;
902: l_return_status VARCHAR2(1) ;
903: l_msg_count NUMBER;
904: l_msg_data VARCHAR2(32767);
905: x_work_item_id NUMBER;

Line 1150: iex_strategy_work_items_pvt.create_strategy_work_items

1146: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1147: iex_debug_pub.logmessage ('before calling create_work_pvt.create');
1148: END IF;
1149:
1150: iex_strategy_work_items_pvt.create_strategy_work_items
1151: (P_Api_Version_Number =>2.0,
1152: P_Init_Msg_List =>FND_API.G_TRUE,
1153: P_Commit =>FND_API.G_FALSE,
1154: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,

Line 1186: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

1182:
1183: if x_work_item_id is not null then
1184: begin
1185: select a.name,b.status_code into l_workitem_name , l_wkitem_status ----bug#5874874 gnramasa
1186: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
1187: where b.work_item_template_id = a.work_item_temp_id
1188: and b.work_item_id = x_work_item_id;
1189:
1190: wf_engine.SetItemAttrText(itemtype =>itemtype,

Line 1540: ,iex_strategy_work_items swit

1536: ,nvl(swit.status_code,'NOTCREATED') STATUS
1537: ,swit.work_item_id WORK_ITEM_ID
1538: ,swit.strategy_id STRATEGY_ID
1539: from iex_strategy_work_temp_xref sxref
1540: ,iex_strategy_work_items swit
1541: where sxref.strategy_temp_id =p_template_id
1542: and swit.work_item_template_id(+) =sxref.work_item_temp_id
1543: and swit.strategy_id(+) =p_strategy_id
1544: union all

Line 1552: ,iex_strategy_work_items swit

1548: ,nvl(swit.status_code,'NOTCREATED') STATUS
1549: ,swit.work_item_id WORK_ITEM_ID
1550: ,susit.strategy_id STRATEGY_ID
1551: from iex_strategy_user_items susit
1552: ,iex_strategy_work_items swit
1553: where susit.strategy_id =p_strategy_id
1554: and swit.work_item_template_id(+) =susit.work_item_temp_id
1555: and swit.strategy_id(+) =p_strategy_id
1556: order by order_by;

Line 1566: from iex_strategy_work_items wkitem,

1562: wkitem.work_item_order ORDER_BY,
1563: wkitem.work_item_id WORK_ITEM_ID,
1564: wkitem.work_item_template_id WORK_ITEM_TEMPLATE_ID,
1565: wkitem.status_code STATUS
1566: from iex_strategy_work_items wkitem,
1567: iex_stry_temp_work_items_vl stry_temp_wkitem
1568: WHERE
1569: wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id
1570: and wkitem.strategy_id =p_strategy_id

Line 1586: AND not exists ( select 'x' from iex_strategy_work_items wkitem where

1582: WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID
1583: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
1584: and stry.strategy_id =p_strategy_id
1585: --not in workitems table
1586: AND not exists ( select 'x' from iex_strategy_work_items wkitem where
1587: wkitem.strategy_id = stry.strategy_id
1588: and wkitem.work_item_template_id = xref.work_item_temp_id
1589: and wkitem.work_item_order = xref.work_item_order
1590: and wkitem.strategy_id =p_strategy_id

Line 1620: ( select 'x' from iex_strategy_work_items wkitem

1616: and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
1617: and stry.strategy_id =p_strategy_id
1618: AND not exists
1619: -- exclude useritem whoch is already a workitem
1620: ( select 'x' from iex_strategy_work_items wkitem
1621: where wkitem.strategy_id = stry.strategy_id
1622: and wkitem.work_item_template_id = uitem.work_item_temp_id
1623: and uitem.work_item_order = wkitem.work_item_order
1624: and wkitem.strategy_id =p_strategy_id)

Line 2473: SELECT STATUS_CODE INTO l_status_code FROM IEX_STRATEGY_WORK_ITEMS WHERE WORK_ITEM_ID = l_work_item_id;

2469: itemtype => itemtype,
2470: itemkey => itemkey,
2471: aname => 'WORK_ITEMID');
2472:
2473: SELECT STATUS_CODE INTO l_status_code FROM IEX_STRATEGY_WORK_ITEMS WHERE WORK_ITEM_ID = l_work_item_id;
2474:
2475: if (l_status_code = 'PRE-WAIT') THEN
2476: BEGIN
2477:

Line 2478: UPDATE IEX_STRATEGY_WORK_ITEMS SET STATUS_CODE = 'OPEN' WHERE WORK_ITEM_ID = l_work_item_id;

2474:
2475: if (l_status_code = 'PRE-WAIT') THEN
2476: BEGIN
2477:
2478: UPDATE IEX_STRATEGY_WORK_ITEMS SET STATUS_CODE = 'OPEN' WHERE WORK_ITEM_ID = l_work_item_id;
2479: --Begin bug#5874874 gnramasa 25-Apr-2007
2480: --Update the UWQ summary table after workitem's status changes to OPEN from PRE-WAIT.
2481: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
2482: --End bug#5874874 gnramasa 25-Apr-2007

Line 2793: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

2789: --End bug#5502077 schekuri 30-Apr-2007
2790: begin
2791: select a.post_execution_wait, a.execution_time_uom
2792: into l_post_execution_wait, l_execution_time_uom
2793: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
2794: where b.work_item_template_id = a.work_item_temp_id
2795: and b.work_item_id = l_work_item_id;
2796: exception
2797: when others then

Line 2917: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

2913:
2914: begin
2915: select a.pre_execution_wait, a.schedule_uom
2916: into l_pre_execution_wait, l_schedule_uom
2917: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
2918: where b.work_item_template_id = a.work_item_temp_id
2919: and b.work_item_id = l_work_item_id;
2920: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2921: iex_debug_pub.logMessage('Collections cal_pre_wait pre_execution_wait = ' ||l_pre_execution_wait);

Line 3372: from iex_strategy_work_items

3368: if l_work_item_id is not null then
3369: begin
3370: select count(*)
3371: into l_timeout_wi
3372: from iex_strategy_work_items
3373: where work_item_id=l_work_item_id
3374: and status_code='TIMEOUT';
3375: exception
3376: when others then

Line 4332: SELECT STATUS_CODE INTO l_status_code FROM IEX_STRATEGY_WORK_ITEMS WHERE WORK_ITEM_ID = l_work_item_id;

4328: end if;
4329:
4330: if (l_work_item_id is not null ) then
4331:
4332: SELECT STATUS_CODE INTO l_status_code FROM IEX_STRATEGY_WORK_ITEMS WHERE WORK_ITEM_ID = l_work_item_id;
4333:
4334: iex_debug_pub.logMessage('Got the Status ' || l_status_code );
4335:
4336: if (l_status_code = 'PRE-WAIT') THEN

Line 4338: UPDATE IEX_STRATEGY_WORK_ITEMS SET STATUS_CODE = 'OPEN' WHERE WORK_ITEM_ID = l_work_item_id;

4334: iex_debug_pub.logMessage('Got the Status ' || l_status_code );
4335:
4336: if (l_status_code = 'PRE-WAIT') THEN
4337:
4338: UPDATE IEX_STRATEGY_WORK_ITEMS SET STATUS_CODE = 'OPEN' WHERE WORK_ITEM_ID = l_work_item_id;
4339: END IF;
4340: end if;
4341:
4342: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 4390: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;

4386: l_party_id NUMBER;
4387: exc EXCEPTION;
4388: l_error VARCHAR2(32767);
4389: l_object_version_number number;
4390: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
4391: l_status_code iex_strategy_work_items.status_code%type;
4392: Cursor c_get_work_items (p_work_item_id NUMBER) is
4393: SELECT status_code, object_version_number
4394: FROM iex_strategy_work_items

Line 4391: l_status_code iex_strategy_work_items.status_code%type;

4387: exc EXCEPTION;
4388: l_error VARCHAR2(32767);
4389: l_object_version_number number;
4390: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
4391: l_status_code iex_strategy_work_items.status_code%type;
4392: Cursor c_get_work_items (p_work_item_id NUMBER) is
4393: SELECT status_code, object_version_number
4394: FROM iex_strategy_work_items
4395: WHERE work_item_id = p_work_item_id;

Line 4394: FROM iex_strategy_work_items

4390: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
4391: l_status_code iex_strategy_work_items.status_code%type;
4392: Cursor c_get_work_items (p_work_item_id NUMBER) is
4393: SELECT status_code, object_version_number
4394: FROM iex_strategy_work_items
4395: WHERE work_item_id = p_work_item_id;
4396: BEGIN
4397: -- IF PG_DEBUG < 10 THEN
4398: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 4427: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(

4423: close c_get_work_items;
4424: l_strategy_work_item_Rec.work_item_id := l_work_item_id;
4425: l_strategy_work_item_Rec.object_version_number :=l_object_version_number;
4426: l_strategy_work_item_Rec.escalated_yn := 'Y';
4427: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
4428: P_Api_Version_Number =>l_api_version_number,
4429: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
4430: P_Init_Msg_List =>FND_API.G_TRUE,
4431: p_commit =>FND_API.G_TRUE,