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 242: ieX_strategy_work_items b

238: END IF;
239: select count(*)
240: INTO v_result
241: from iex_strategies a,
242: ieX_strategy_work_items b
243: where a.strategy_id =p_strategy_id
244: and a.strategy_id =b.strategy_id
245: and a.next_work_item_id =b.work_item_id
246: and b.status_code ='OPEN'

Line 511: p_strategy_work_item_rec IN IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE,

507: (
508: p_work_item_temp_id IN NUMBER,
509: itemtype IN varchar2,
510: itemkey IN varchar2,
511: p_strategy_work_item_rec IN IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE,
512: x_schedule_start OUT NOCOPY DATE,
513: x_schedule_end OUT NOCOPY DATE
514: ) IS
515:

Line 849: ,iex_strategy_work_items swit

845: ,nvl(swit.status_code,'NOTCREATED') STATUS
846: ,swit.work_item_id WORK_ITEM_ID
847: ,swit.strategy_id STRATEGY_ID
848: from iex_strategy_work_temp_xref sxref
849: ,iex_strategy_work_items swit
850: where sxref.strategy_temp_id =p_template_id
851: and swit.work_item_template_id(+) =sxref.work_item_temp_id
852: and swit.strategy_id(+) =p_strategy_id
853: union all

Line 861: ,iex_strategy_work_items swit

857: ,nvl(swit.status_code,'NOTCREATED') STATUS
858: ,swit.work_item_id WORK_ITEM_ID
859: ,susit.strategy_id STRATEGY_ID
860: from iex_strategy_user_items susit
861: ,iex_strategy_work_items swit
862: where susit.strategy_id =p_strategy_id
863: and swit.work_item_template_id(+) =susit.work_item_temp_id
864: and swit.strategy_id(+) =p_strategy_id
865: order by order_by;

Line 890: from iex_strategy_work_items wkitem,

886: wkitem.escalate_wait_time_uom escalate_wait_time_uom,
887: wkitem.NOTIFY_YN NOTIFY_YN,
888: wkitem.resource_id resource_id,
889: wkitem.custom_workflow_type custom_workflow_type
890: from iex_strategy_work_items wkitem,
891: iex_stry_temp_work_items_vl stry_temp_wkitem
892: WHERE
893: wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id
894: and wkitem.strategy_id =p_strategy_id

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

922: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
923: AND stry_temp_wkitem.enabled_flag ='Y' -- added for bug 7299555 pnaveenk
924: and stry.strategy_id =p_strategy_id
925: --not in workitems table
926: AND not exists ( select 'x' from iex_strategy_work_items wkitem where
927: wkitem.strategy_id = stry.strategy_id
928: and wkitem.work_item_template_id = xref.work_item_temp_id
929: and wkitem.work_item_order = xref.work_item_order
930: and wkitem.strategy_id =p_strategy_id

Line 976: ( select 'x' from iex_strategy_work_items wkitem

972: AND stry_temp_wkitem.enabled_flag = 'Y' -- added for bug 7299555
973: and stry.strategy_id =p_strategy_id
974: AND not exists
975: -- exclude useritem whoch is already a workitem
976: ( select 'x' from iex_strategy_work_items wkitem
977: where wkitem.strategy_id = stry.strategy_id
978: and wkitem.work_item_template_id = uitem.work_item_temp_id
979: and uitem.work_item_order = wkitem.work_item_order
980: and wkitem.strategy_id =p_strategy_id)

Line 1009: l_strategy_work_item_rec IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;

1005: category_type,fulfil_temp_id
1006: from iex_stry_temp_work_items_vl
1007: where work_item_temp_id =p_work_item_temp_id;
1008:
1009: l_strategy_work_item_rec IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;
1010: l_return_status VARCHAR2(1) ;
1011: l_msg_count NUMBER;
1012: l_msg_data VARCHAR2(32767);
1013: x_work_item_id NUMBER;

Line 1314: iex_strategy_work_items_pvt.create_strategy_work_items

1310: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1311: iex_debug_pub.logmessage ('before calling create_work_pvt.create');
1312: END IF;
1313:
1314: iex_strategy_work_items_pvt.create_strategy_work_items
1315: (P_Api_Version_Number =>2.0,
1316: P_Init_Msg_List =>FND_API.G_TRUE,
1317: P_Commit =>FND_API.G_FALSE,
1318: p_validation_level =>FND_API.G_VALID_LEVEL_FULL,

Line 1350: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

1346:
1347: if x_work_item_id is not null then
1348: begin
1349: select a.name,b.status_code into l_workitem_name , l_wkitem_status ----bug#5874874 gnramasa
1350: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
1351: where b.work_item_template_id = a.work_item_temp_id
1352: and b.work_item_id = x_work_item_id;
1353:
1354: wf_engine.SetItemAttrText(itemtype =>itemtype,

Line 1704: ,iex_strategy_work_items swit

1700: ,nvl(swit.status_code,'NOTCREATED') STATUS
1701: ,swit.work_item_id WORK_ITEM_ID
1702: ,swit.strategy_id STRATEGY_ID
1703: from iex_strategy_work_temp_xref sxref
1704: ,iex_strategy_work_items swit
1705: where sxref.strategy_temp_id =p_template_id
1706: and swit.work_item_template_id(+) =sxref.work_item_temp_id
1707: and swit.strategy_id(+) =p_strategy_id
1708: union all

Line 1716: ,iex_strategy_work_items swit

1712: ,nvl(swit.status_code,'NOTCREATED') STATUS
1713: ,swit.work_item_id WORK_ITEM_ID
1714: ,susit.strategy_id STRATEGY_ID
1715: from iex_strategy_user_items susit
1716: ,iex_strategy_work_items swit
1717: where susit.strategy_id =p_strategy_id
1718: and swit.work_item_template_id(+) =susit.work_item_temp_id
1719: and swit.strategy_id(+) =p_strategy_id
1720: order by order_by;

Line 1730: from iex_strategy_work_items wkitem,

1726: wkitem.work_item_order ORDER_BY,
1727: wkitem.work_item_id WORK_ITEM_ID,
1728: wkitem.work_item_template_id WORK_ITEM_TEMPLATE_ID,
1729: wkitem.status_code STATUS
1730: from iex_strategy_work_items wkitem,
1731: iex_stry_temp_work_items_vl stry_temp_wkitem
1732: WHERE
1733: wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id
1734: and wkitem.strategy_id =p_strategy_id

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

1746: WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID
1747: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
1748: and stry.strategy_id =p_strategy_id
1749: --not in workitems table
1750: AND not exists ( select 'x' from iex_strategy_work_items wkitem where
1751: wkitem.strategy_id = stry.strategy_id
1752: and wkitem.work_item_template_id = xref.work_item_temp_id
1753: and wkitem.work_item_order = xref.work_item_order
1754: and wkitem.strategy_id =p_strategy_id

Line 1784: ( select 'x' from iex_strategy_work_items wkitem

1780: and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID
1781: and stry.strategy_id =p_strategy_id
1782: AND not exists
1783: -- exclude useritem whoch is already a workitem
1784: ( select 'x' from iex_strategy_work_items wkitem
1785: where wkitem.strategy_id = stry.strategy_id
1786: and wkitem.work_item_template_id = uitem.work_item_temp_id
1787: and uitem.work_item_order = wkitem.work_item_order
1788: and wkitem.strategy_id =p_strategy_id)

Line 2623: iex_strategy_work_items b

2619:
2620: CURSOR c_user_item_workflow(p_work_item_id NUMBER) IS
2621: SELECT a.custom_workflow_type
2622: FROM iex_strategy_user_items a,
2623: iex_strategy_work_items b
2624: WHERE a.strategy_id = b.strategy_id
2625: AND a.work_item_order = b.work_item_order
2626: AND b.work_item_id = p_work_item_id;
2627:

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

2647: aname => 'WORK_ITEMID');
2648:
2649: iex_debug_pub.logmessage('l_work_item_id ' || l_work_item_id);
2650:
2651: SELECT STATUS_CODE INTO l_status_code FROM IEX_STRATEGY_WORK_ITEMS WHERE WORK_ITEM_ID = l_work_item_id;
2652:
2653: if (l_status_code = 'PRE-WAIT') THEN
2654: BEGIN
2655:

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

2652:
2653: if (l_status_code = 'PRE-WAIT') THEN
2654: BEGIN
2655:
2656: UPDATE IEX_STRATEGY_WORK_ITEMS SET STATUS_CODE = 'OPEN' WHERE WORK_ITEM_ID = l_work_item_id;
2657: --Begin bug#5874874 gnramasa 25-Apr-2007
2658: --Update the UWQ summary table after workitem's status changes to OPEN from PRE-WAIT.
2659: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
2660: --End bug#5874874 gnramasa 25-Apr-2007

Line 2784: FROM iex_strategy_work_items

2780: l_work_type VARCHAR2(100);
2781:
2782: CURSOR c_witem_details(p_work_item_id number) IS
2783: SELECT xdo_temp_id
2784: FROM iex_strategy_work_items
2785: WHERE work_item_id = p_work_item_id;
2786:
2787: BEGIN
2788: -- initialize variable

Line 2930: FROM iex_strategy_work_items

2926: l_curr_dmethod varchar2(10);
2927:
2928: CURSOR c_witem_details(p_work_item_id number) IS
2929: SELECT post_execution_wait,execution_time_uom
2930: FROM iex_strategy_work_items
2931: WHERE work_item_id = p_work_item_id;
2932:
2933: BEGIN
2934: -- initialize variable

Line 3022: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

3018:
3019: IF l_post_execution_wait IS NULL THEN
3020: select a.post_execution_wait, a.execution_time_uom
3021: into l_post_execution_wait, l_execution_time_uom
3022: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
3023: where b.work_item_template_id = a.work_item_temp_id
3024: and b.work_item_id = l_work_item_id;
3025: END IF;
3026: -- end for bug 10133319

Line 3115: FROM iex_strategy_work_items

3111: l_strategy_status varchar2(100);
3112:
3113: CURSOR c_witem_details(p_work_item_id number) IS
3114: SELECT pre_execution_wait,pre_execution_time_uom
3115: FROM iex_strategy_work_items
3116: WHERE work_item_id = p_work_item_id;
3117:
3118: BEGIN
3119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3159: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

3155:
3156: IF l_pre_execution_wait IS NULL then
3157: select a.pre_execution_wait, a.schedule_uom
3158: into l_pre_execution_wait, l_schedule_uom
3159: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
3160: where b.work_item_template_id = a.work_item_temp_id
3161: and b.work_item_id = l_work_item_id;
3162: END IF;
3163: -- end bug 10133319

Line 3339: FROM iex_strategy_work_items

3335: l_optional VARCHAR2(1);
3336:
3337: CURSOR c_optional(p_work_item_id number) IS
3338: SELECT optional_yn
3339: FROM iex_strategy_work_items
3340: WHERE work_item_id = p_work_item_id;
3341:
3342: BEGIN
3343: -- IF PG_DEBUG < 10 THEN

Line 3422: FROM iex_strategy_work_items

3418: l_escalate VARCHAR2(1);
3419:
3420: CURSOR c_escalate(p_work_item_id NUMBER) IS
3421: SELECT escalate_yn
3422: FROM iex_strategy_work_items
3423: WHERE work_item_id = p_work_item_id;
3424:
3425: BEGIN
3426: -- IF PG_DEBUG < 10 THEN

Line 3501: FROM iex_strategy_work_items

3497: l_notify VARCHAR2(1);
3498:
3499: CURSOR c_notify(p_work_item_id NUMBER) IS
3500: SELECT notify_yn
3501: FROM iex_strategy_work_items
3502: WHERE work_item_id = p_work_item_id;
3503:
3504: BEGIN
3505: -- IF PG_DEBUG < 10 THEN

Line 3680: from iex_strategy_work_items

3676: if l_work_item_id is not null then
3677: begin
3678: select count(*)
3679: into l_timeout_wi
3680: from iex_strategy_work_items
3681: where work_item_id=l_work_item_id
3682: and status_code='TIMEOUT';
3683: exception
3684: when others then

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

4636: end if;
4637:
4638: if (l_work_item_id is not null ) then
4639:
4640: SELECT STATUS_CODE INTO l_status_code FROM IEX_STRATEGY_WORK_ITEMS WHERE WORK_ITEM_ID = l_work_item_id;
4641:
4642: iex_debug_pub.logMessage('Got the Status ' || l_status_code );
4643:
4644: if (l_status_code = 'PRE-WAIT') THEN

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

4642: iex_debug_pub.logMessage('Got the Status ' || l_status_code );
4643:
4644: if (l_status_code = 'PRE-WAIT') THEN
4645:
4646: UPDATE IEX_STRATEGY_WORK_ITEMS SET STATUS_CODE = 'OPEN' WHERE WORK_ITEM_ID = l_work_item_id;
4647: END IF;
4648: end if;
4649:
4650: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 4698: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;

4694: l_party_id NUMBER;
4695: exc EXCEPTION;
4696: l_error VARCHAR2(32767);
4697: l_object_version_number number;
4698: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
4699: l_status_code iex_strategy_work_items.status_code%type;
4700: Cursor c_get_work_items (p_work_item_id NUMBER) is
4701: SELECT status_code, object_version_number
4702: FROM iex_strategy_work_items

Line 4699: l_status_code iex_strategy_work_items.status_code%type;

4695: exc EXCEPTION;
4696: l_error VARCHAR2(32767);
4697: l_object_version_number number;
4698: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
4699: l_status_code iex_strategy_work_items.status_code%type;
4700: Cursor c_get_work_items (p_work_item_id NUMBER) is
4701: SELECT status_code, object_version_number
4702: FROM iex_strategy_work_items
4703: WHERE work_item_id = p_work_item_id;

Line 4702: FROM iex_strategy_work_items

4698: l_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
4699: l_status_code iex_strategy_work_items.status_code%type;
4700: Cursor c_get_work_items (p_work_item_id NUMBER) is
4701: SELECT status_code, object_version_number
4702: FROM iex_strategy_work_items
4703: WHERE work_item_id = p_work_item_id;
4704: l_resource_id number; -- added for bug 8919933 PNAVEENK
4705: BEGIN
4706: -- IF PG_DEBUG < 10 THEN

Line 4736: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(

4732: close c_get_work_items;
4733: l_strategy_work_item_Rec.work_item_id := l_work_item_id;
4734: l_strategy_work_item_Rec.object_version_number :=l_object_version_number;
4735: l_strategy_work_item_Rec.escalated_yn := 'Y';
4736: IEX_STRATEGY_WORK_ITEMS_PVT.Update_strategy_work_items(
4737: P_Api_Version_Number =>l_api_version_number,
4738: P_strategy_work_item_Rec =>l_strategy_work_item_Rec,
4739: P_Init_Msg_List =>FND_API.G_TRUE,
4740: p_commit =>FND_API.G_TRUE,

Line 4777: SELECT resource_id INTO l_resource_id FROM IEX_STRATEGY_WORK_ITEMS WHERE WORK_ITEM_ID = l_work_item_id;

4773:
4774:
4775: if (l_work_item_id is not null ) then
4776:
4777: SELECT resource_id INTO l_resource_id FROM IEX_STRATEGY_WORK_ITEMS WHERE WORK_ITEM_ID = l_work_item_id;
4778:
4779: end if;
4780: iex_debug_pub.logMessage('Current resource id ' || l_resource_id );
4781: