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_STRY_UTL_PUB

Line 297: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,

293: -- IF PG_DEBUG < 10 THEN
294: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
295: iex_debug_pub.logmessage ('**** BEGIN update_workitem_Status ************');
296: END IF;
297: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
298: p_init_msg_list => FND_API.G_TRUE,
299: p_commit => FND_API.G_FALSE,
300: x_msg_count => l_msg_count,
301: x_msg_data => l_msg_data,

Line 546: x_schedule_start:=IEX_STRY_UTL_PUB.get_Date

542: IF p_strategy_work_item_rec.pre_execution_wait IS NOT NULL THEN
543: c_rec.schedule_wait := p_strategy_work_item_rec.pre_execution_wait;
544: c_rec.schedule_uom := p_strategy_work_item_rec.pre_execution_time_uom;
545: END IF;
546: x_schedule_start:=IEX_STRY_UTL_PUB.get_Date
547: (p_date =>SYSDATE,
548: l_UOM =>c_rec.schedule_uom,
549: l_UNIT =>c_rec.schedule_wait);
550: -- IF PG_DEBUG < 10 THEN

Line 559: x_schedule_end:=IEX_STRY_UTL_PUB.get_Date

555: IF p_strategy_work_item_rec.escalate_wait_time IS NOT NULL THEN
556: c_rec.closure_time_limit := p_strategy_work_item_rec.escalate_wait_time;
557: c_rec.closure_time_uom := p_strategy_work_item_rec.escalate_wait_time_uom;
558: END IF;
559: x_schedule_end:=IEX_STRY_UTL_PUB.get_Date
560: (p_date =>x_schedule_start,
561: l_UOM =>c_rec.closure_time_uom,
562: l_UNIT =>c_rec.closure_time_limit);
563: -- IF PG_DEBUG < 10 THEN

Line 586: l_optional_date:= IEX_STRY_UTL_PUB.get_Date

582: c_rec.option_wait_time := p_strategy_work_item_rec.optional_wait_time;
583: END IF;
584: --populate optional wait period
585: if c_rec.optional_yn =wf_yes THEN
586: l_optional_date:= IEX_STRY_UTL_PUB.get_Date
587: (p_date =>x_schedule_start,
588: l_UOM =>c_rec.option_wait_time_uom,
589: l_UNIT =>c_rec.option_wait_time);
590: -- IF PG_DEBUG < 10 THEN

Line 1331: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM

1327: END IF;
1328: x_return_status :=l_return_Status;
1329: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1330: --update nextwork item i nthe strategy table
1331: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM
1332: (p_api_version => l_api_version,
1333: p_init_msg_list => FND_API.G_TRUE,
1334: p_commit => FND_API.G_FALSE,
1335: x_msg_count => l_msg_count,

Line 1365: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(x_work_item_id);

1361:
1362: --Begin bug#5874874 gnramasa 25-Apr-2007
1363: --Update the UWQ summary table after creating workitem in OPEN status.
1364: if l_wkitem_status='OPEN' then
1365: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(x_work_item_id);
1366: end if;
1367: --End bug#5874874 gnramasa 25-Apr-2007
1368:
1369: exception

Line 2015: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,

2011: ELSIF l_strategy_status IS NULL OR (l_strategy_status NOT IN('CLOSED','CANCELLED')) THEN
2012: l_strategy_status := 'CLOSED';
2013: END IF;
2014:
2015: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
2016: p_init_msg_list => FND_API.G_TRUE,
2017: p_commit => FND_API.G_FALSE,
2018: x_msg_count => l_msg_count,
2019: x_msg_data => l_msg_data,

Line 2659: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);

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
2661: commit work;
2662: END;
2663: END IF;

Line 2958: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);

2954: if l_strategy_status = 'CANCELLED' then
2955: --Begin bug#5874874 gnramasa 25-Apr-2007
2956: --Update the UWQ summary table after CANCELLING the strategy.
2957: if l_work_item_id is not null then
2958: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
2959: end if;
2960: --End bug#5874874 gnramasa 25-Apr-2007
2961: l_return := wf_no;
2962: result := wf_engine.eng_completed ||':'||l_return;

Line 3042: l_execution_time:= IEX_STRY_UTL_PUB.get_Date

3038: if (l_post_execution_wait = 0) then
3039: l_return := wf_no;
3040: else
3041: begin
3042: l_execution_time:= IEX_STRY_UTL_PUB.get_Date
3043: (p_date =>sysdate,
3044: l_UOM =>l_execution_time_uom,
3045: l_UNIT =>l_post_execution_wait);
3046: exception

Line 3073: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);

3069:
3070: --Begin bug#5874874 gnramasa 25-Apr-2007
3071: --Update the UWQ summary table after completing the workitem.
3072: if l_work_item_id is not null then
3073: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
3074: end if;
3075: --End bug#5874874 gnramasa 25-Apr-2007
3076:
3077: result := wf_engine.eng_completed ||':'||l_return;

Line 3179: l_schedule:= IEX_STRY_UTL_PUB.get_Date

3175: if (l_pre_execution_wait = 0) then
3176: l_return := wf_no;
3177: else
3178: begin
3179: l_schedule:= IEX_STRY_UTL_PUB.get_Date
3180: (p_date =>sysdate,
3181: l_UOM =>l_schedule_uom,
3182: l_UNIT =>l_pre_execution_wait);
3183: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3753: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,

3749: -- IF PG_DEBUG < 10 THEN
3750: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3751: iex_debug_pub.logmessage('UPDATE_WORK_ITEM: ' || 'value of workitem id '||l_work_item_id);
3752: END IF;
3753: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
3754: p_init_msg_list => FND_API.G_TRUE,
3755: p_commit => FND_API.G_FALSE,
3756: x_msg_count => l_msg_count,
3757: x_msg_data => l_msg_data,

Line 4043: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,

4039: END IF;
4040:
4041: abort_processes(l_strategy_id);
4042:
4043: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
4044: p_init_msg_list => FND_API.G_TRUE,
4045: p_commit => FND_API.G_FALSE,
4046: x_msg_count => l_msg_count,
4047: x_msg_data => l_msg_data,

Line 4752: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);

4748: END IF;
4749: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
4750: begin
4751: iex_debug_pub.logmessage('UPDATE_ESC_FLAG: Refreshing UWQ Summary..');
4752: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
4753: exception
4754: when others then
4755: iex_debug_pub.logmessage('UPDATE_ESC_FLAG:Exception when refreshing UWQ Summary: '||SQLERRM);
4756: end;