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_STRATEGIES

Line 58: select jtf_object_type,jtf_object_id from iex_strategies

54: select distinct item_key from wf_item_attr_values_ondemand
55: where name = 'WRITEOFF_ID' and text_value = c_id and item_type = 'IEXWRREQ';
56:
57: cursor get_strategy_info(c_strategy_id IN number) is
58: select jtf_object_type,jtf_object_id from iex_strategies
59: where strategy_id = c_strategy_id;
60: -- end bug 7703319
61:
62: BEGIN

Line 207: from iex_strategies a,

203: iex_debug_pub.logmessage ('**** BEGIN CHECK_WORK_ITEM_OPEN ************');
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

Line 236: select count(*) INTO v_result from iex_strategies

232: -- IF PG_DEBUG < 10 THEN
233: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
234: iex_debug_pub.logmessage ('**** BEGIN CHECK_CURRENT_WORK_ITEM ************');
235: END IF;
236: select count(*) INTO v_result from iex_strategies
237: where strategy_id =p_strategy_id
238: and next_work_item_id =p_work_item_id
239: and status_code ='OPEN';
240: return v_result;

Line 826: FROM IEX_STRATEGIES stry

822: , xref.WORK_ITEM_ORDER ORDER_BY
823: , TO_NUMBER(NULL) WORK_ITEM_ID
824: , xref.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
825: , 'NOTCREATED' STATUS
826: FROM IEX_STRATEGIES stry
827: , IEX_STRATEGY_WORK_TEMP_XREF xref
828: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
829: WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID
830: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID

Line 859: FROM IEX_STRATEGIES stry

855: , uitem.WORK_ITEM_ORDER ORDER_BY
856: , TO_NUMBER(NULL) WORK_ITEM_ID
857: , uitem.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
858: , uitem.operation STATUS
859: FROM IEX_STRATEGIES stry
860: , IEX_STRATEGY_user_items uitem
861: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
862: WHERE stry.STRATEGY_ID = uitem.STRATEGY_ID
863: and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID

Line 881: select account_number,location from iex_strategies_bali_v

877: */
878:
879: -- Start Bug 6717880/7170165 by Ehuh
880: Cursor c_get_accloc(p_str_id number) Is
881: select account_number,location from iex_strategies_bali_v
882: where strategy_id = p_str_id;
883:
884: l_location varchar2(50);
885: l_acct_number varchar2(50);

Line 968: from iex_strategies

964: -- get_resource(p_party_id,l_competence_tab,l_resource_id);
965: begin
966: select jtf_object_type, jtf_object_id, cust_account_id,customer_site_use_id
967: into l_object_code, l_object_id, l_cust_account_id,l_siteuse_id
968: from iex_strategies
969: where strategy_id = p_strategy_id;
970: exception
971: when others then
972: iex_debug_pub.logmessage ('populate_schedule_times: More than one row for this Strategy. Exception on selecting strategy!!!!!');

Line 1526: select strategy_template_id from iex_strategies

1522:
1523:
1524:
1525: cursor c_get_strat_template_id (p_strategy_id NUMBER) IS
1526: select strategy_template_id from iex_strategies
1527: where strategy_id =p_strategy_id;
1528:
1529:
1530: cursor c_get_next_witem(p_strategy_id NUMBER,

Line 1579: FROM IEX_STRATEGIES stry

1575: , xref.WORK_ITEM_ORDER ORDER_BY
1576: , TO_NUMBER(NULL) WORK_ITEM_ID
1577: , xref.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
1578: , 'NOTCREATED' STATUS
1579: FROM IEX_STRATEGIES stry
1580: , IEX_STRATEGY_WORK_TEMP_XREF xref
1581: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
1582: WHERE stry.STRATEGY_TEMPLATE_ID = xref.STRATEGY_TEMP_ID
1583: and xref.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID

Line 1612: FROM IEX_STRATEGIES stry

1608: , uitem.WORK_ITEM_ORDER ORDER_BY
1609: , TO_NUMBER(NULL) WORK_ITEM_ID
1610: , uitem.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID
1611: , uitem.operation STATUS
1612: FROM IEX_STRATEGIES stry
1613: , IEX_STRATEGY_user_items uitem
1614: , IEX_STRY_TEMP_WORK_ITEMS_VL stry_temp_wkitem
1615: WHERE stry.STRATEGY_ID = uitem.STRATEGY_ID
1616: and uitem.WORK_ITEM_TEMP_ID = stry_temp_wkitem.WORK_ITEM_TEMP_ID

Line 1943: select strategy_template_id from iex_strategies

1939: l_strategy_template_id NUMBER;
1940: l_error VARCHAR2(32767);
1941:
1942: cursor c_get_strat_template_id (p_strategy_id NUMBER) IS
1943: select strategy_template_id from iex_strategies
1944: where strategy_id =p_strategy_id;
1945: l_value VARCHAR2(300);
1946: Begin
1947: -- initialize variable

Line 3329: --But status of the strategy in table IEX_STRATEGIES is still 'ONHOLD'.

3325: --begin bug#4506922 schekuri 03-Dec-2005
3326: --When the delinquency corresponding to the strategy becomes CURRENT or CLOSED,
3327: --strategy management concurrent program calls the procedure IEX_STRATEGY_WF.SEND_SIGNAL.
3328: --This procedure just updates the "STRATEGY_STATUS" attribute to "CLOSED" and completes the current activity.
3329: --But status of the strategy in table IEX_STRATEGIES is still 'ONHOLD'.
3330: --If workflow is waiting at WAIT_ON_HOLD_SIGNAL node, it will be completed and it goes to ONHOLD_CHECK node.
3331: --Since the status of the strategy in table IEX_STRATEGIES is still 'ONHOLD', it again goes to WAIT_ON_HOLD_SIGNAL node
3332: --and waits for 23 hrs. To avoid this added the following code.
3333: l_value :=wf_engine.GetActivityLabel(actid);

Line 3331: --Since the status of the strategy in table IEX_STRATEGIES is still 'ONHOLD', it again goes to WAIT_ON_HOLD_SIGNAL node

3327: --strategy management concurrent program calls the procedure IEX_STRATEGY_WF.SEND_SIGNAL.
3328: --This procedure just updates the "STRATEGY_STATUS" attribute to "CLOSED" and completes the current activity.
3329: --But status of the strategy in table IEX_STRATEGIES is still 'ONHOLD'.
3330: --If workflow is waiting at WAIT_ON_HOLD_SIGNAL node, it will be completed and it goes to ONHOLD_CHECK node.
3331: --Since the status of the strategy in table IEX_STRATEGIES is still 'ONHOLD', it again goes to WAIT_ON_HOLD_SIGNAL node
3332: --and waits for 23 hrs. To avoid this added the following code.
3333: l_value :=wf_engine.GetActivityLabel(actid);
3334: if instr(l_value,'STRATEGY_WORKFLOW')>0 then
3335: l_strategy_status := wf_engine.GetItemAttrText(

Line 3353: from iex_Strategies

3349: itemkey => itemkey,
3350: aname => 'STRATEGY_ID');
3351:
3352: select decode(count(*),0,'N','Y') into l_result
3353: from iex_Strategies
3354: where strategy_id =l_strategy_id
3355: and status_code ='ONHOLD';
3356:
3357: --begin bug#4506922 schekuri 03-Dec-2005