APPS.IEX_STRATEGY_WF dependencies on IEX_STRY_UTL_PUB

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

259: -- IF PG_DEBUG < 10 THEN
260: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
261: iex_debug_pub.logmessage ('**** BEGIN update_workitem_Status ************');
262: END IF;
263: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
264: p_init_msg_list => FND_API.G_TRUE,
265: p_commit => FND_API.G_FALSE,
266: x_msg_count => l_msg_count,
267: x_msg_data => l_msg_data,

Line 497: x_schedule_start:=IEX_STRY_UTL_PUB.get_Date

493: iex_debug_pub.logmessage ('**** BEGIN populate_schedule_times ************');
494: END IF;
495: FOR c_rec in c_get_witem_temp(p_work_item_temp_id)
496: LOOP
497: x_schedule_start:=IEX_STRY_UTL_PUB.get_Date
498: (p_date =>SYSDATE,
499: l_UOM =>c_rec.schedule_uom,
500: l_UNIT =>c_rec.schedule_wait);
501: -- IF PG_DEBUG < 10 THEN

Line 505: x_schedule_end:=IEX_STRY_UTL_PUB.get_Date

501: -- IF PG_DEBUG < 10 THEN
502: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
503: iex_debug_pub.logmessage('populate_schedule_times: ' || 'schedulestart'||x_schedule_start);
504: END IF;
505: x_schedule_end:=IEX_STRY_UTL_PUB.get_Date
506: (p_date =>x_schedule_start,
507: l_UOM =>c_rec.closure_time_uom,
508: l_UNIT =>c_rec.closure_time_limit);
509: -- IF PG_DEBUG < 10 THEN

Line 524: l_optional_date:= IEX_STRY_UTL_PUB.get_Date

520: end if;
521:
522: --populate optional wait period
523: if c_rec.optional_yn =wf_yes THEN
524: l_optional_date:= IEX_STRY_UTL_PUB.get_Date
525: (p_date =>x_schedule_start,
526: l_UOM =>c_rec.option_wait_time_uom,
527: l_UNIT =>c_rec.option_wait_time);
528: -- IF PG_DEBUG < 10 THEN

Line 1167: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM

1163: END IF;
1164: x_return_status :=l_return_Status;
1165: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
1166: --update nextwork item i nthe strategy table
1167: IEX_STRY_UTL_PUB.UPDATE_NEXT_WORK_ITEM
1168: (p_api_version => l_api_version,
1169: p_init_msg_list => FND_API.G_TRUE,
1170: p_commit => FND_API.G_FALSE,
1171: x_msg_count => l_msg_count,

Line 1201: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(x_work_item_id);

1197:
1198: --Begin bug#5874874 gnramasa 25-Apr-2007
1199: --Update the UWQ summary table after creating workitem in OPEN status.
1200: if l_wkitem_status='OPEN' then
1201: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(x_work_item_id);
1202: end if;
1203: --End bug#5874874 gnramasa 25-Apr-2007
1204:
1205: exception

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

1846: l_strategy_status := 'CLOSED';
1847:
1848: END IF;
1849:
1850: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
1851: p_init_msg_list => FND_API.G_TRUE,
1852: p_commit => FND_API.G_FALSE,
1853: x_msg_count => l_msg_count,
1854: x_msg_data => l_msg_data,

Line 2481: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);

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
2483: commit work;
2484: END;
2485: END IF;

Line 2735: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);

2731: if l_strategy_status = 'CANCELLED' then
2732: --Begin bug#5874874 gnramasa 25-Apr-2007
2733: --Update the UWQ summary table after CANCELLING the strategy.
2734: if l_work_item_id is not null then
2735: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
2736: end if;
2737: --End bug#5874874 gnramasa 25-Apr-2007
2738: l_return := wf_no;
2739: result := wf_engine.eng_completed ||':'||l_return;

Line 2811: l_execution_time:= IEX_STRY_UTL_PUB.get_Date

2807: if (l_post_execution_wait = 0) then
2808: l_return := wf_no;
2809: else
2810: begin
2811: l_execution_time:= IEX_STRY_UTL_PUB.get_Date
2812: (p_date =>sysdate,
2813: l_UOM =>l_execution_time_uom,
2814: l_UNIT =>l_post_execution_wait);
2815: exception

Line 2842: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);

2838:
2839: --Begin bug#5874874 gnramasa 25-Apr-2007
2840: --Update the UWQ summary table after completing the workitem.
2841: if l_work_item_id is not null then
2842: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
2843: end if;
2844: --End bug#5874874 gnramasa 25-Apr-2007
2845:
2846: result := wf_engine.eng_completed ||':'||l_return;

Line 2935: l_schedule:= IEX_STRY_UTL_PUB.get_Date

2931: if (l_pre_execution_wait = 0) then
2932: l_return := wf_no;
2933: else
2934: begin
2935: l_schedule:= IEX_STRY_UTL_PUB.get_Date
2936: (p_date =>sysdate,
2937: l_UOM =>l_schedule_uom,
2938: l_UNIT =>l_pre_execution_wait);
2939: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

3441: -- IF PG_DEBUG < 10 THEN
3442: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3443: iex_debug_pub.logmessage('UPDATE_WORK_ITEM: ' || 'value of workitem id '||l_work_item_id);
3444: END IF;
3445: IEX_STRY_UTL_PUB.UPDATE_WORK_ITEM (p_api_version => l_api_version,
3446: p_init_msg_list => FND_API.G_TRUE,
3447: p_commit => FND_API.G_FALSE,
3448: x_msg_count => l_msg_count,
3449: x_msg_data => l_msg_data,

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

3731: END IF;
3732:
3733: abort_processes(l_strategy_id);
3734:
3735: IEX_STRY_UTL_PUB.CLOSE_STRY_AND_WITEMS(p_api_version => l_api_version,
3736: p_init_msg_list => FND_API.G_TRUE,
3737: p_commit => FND_API.G_FALSE,
3738: x_msg_count => l_msg_count,
3739: x_msg_data => l_msg_data,

Line 4443: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);

4439: END IF;
4440: if l_return_status =FND_API.G_RET_STS_SUCCESS THEN
4441: begin
4442: iex_debug_pub.logmessage('UPDATE_ESC_FLAG: Refreshing UWQ Summary..');
4443: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_work_item_id);
4444: exception
4445: when others then
4446: iex_debug_pub.logmessage('UPDATE_ESC_FLAG:Exception when refreshing UWQ Summary: '||SQLERRM);
4447: end;