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.OE_BLANKET_WF dependencies on WF_ENGINE

Line 162: l_aname wf_engine.nametabtyp;

158: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
159: l_start_date DATE;
160: l_end_date DATE;
161: l_pre_notification_percent NUMBER;
162: l_aname wf_engine.nametabtyp;
163: l_avalue wf_engine.numtabtyp;
164: l_final_timer NUMBER;
165: l_start_timer NUMBER;
166: l_return_status VARCHAR2(30);

Line 163: l_avalue wf_engine.numtabtyp;

159: l_start_date DATE;
160: l_end_date DATE;
161: l_pre_notification_percent NUMBER;
162: l_aname wf_engine.nametabtyp;
163: l_avalue wf_engine.numtabtyp;
164: l_final_timer NUMBER;
165: l_start_timer NUMBER;
166: l_return_status VARCHAR2(30);
167: --

Line 185: wf_engine.setitemattrnumber(itemtype=>itemtype,

181:
182: -- start date has not been reached
183: IF l_start_date > sysdate THEN
184: l_start_timer := (l_start_date - sysdate) * 1440;
185: wf_engine.setitemattrnumber(itemtype=>itemtype,
186: itemkey=>itemkey,
187: aname=>'BLANKET_START_TIMER',
188: avalue=>l_start_timer);
189: oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),

Line 220: l_pre_notification_percent := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'PRE_EXPIRE_TIME_PERCENT');

216: END IF;
217:
218: --if you are here, that means expiration date exists and is in the future
219:
220: l_pre_notification_percent := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'PRE_EXPIRE_TIME_PERCENT');
221:
222: oe_debug_pub.add('sysdate:' || to_char(sysdate, 'DD-MON-RRRR') || ' and end date:' || to_char(l_end_date, 'DD-MON-RRRR'),1);
223:
224: IF l_pre_notification_percent = 0 THEN

Line 228: wf_engine.setitemattrnumber(itemtype=>itemtype,

224: IF l_pre_notification_percent = 0 THEN
225: -- set the FINAL timer only is enough
226: -- this assumes expiration_date is already set to 23:59:59
227: l_final_timer := (l_end_date - sysdate) * 1440;
228: wf_engine.setitemattrnumber(itemtype=>itemtype,
229: itemkey=>itemkey,
230: aname=>'BLANKET_FINAL_EXPIRE_TIMER',
231: avalue=>l_final_timer);
232: oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),

Line 245: wf_engine.SetItemAttrNumber(itemtype=>itemtype,

241: ELSIF to_char(sysdate, 'DD-MON-RRRR') = to_char(l_end_date, 'DD-MON-RRRR') THEN
242: -- pre notification percentage is non-zero
243: -- end_date is today midnight, we should send the reminder
244:
245: wf_engine.SetItemAttrNumber(itemtype=>itemtype,
246: itemkey=>itemkey,
247: aname=> 'BLANKET_FINAL_EXPIRE_TIMER',
248: avalue=> (l_end_date - sysdate) * 1440);
249: oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),

Line 264: wf_engine.SetItemAttrNumberArray(itemtype=>itemtype

260: l_avalue(1) := Ceil((l_end_date - sysdate) * l_pre_notification_percent/100) * 1440;
261: l_aname(2) := 'BLANKET_PRE_EXPIRE_TIMER';
262: l_avalue(2) := ((l_end_date - sysdate) * 1440) - l_avalue(1);
263:
264: wf_engine.SetItemAttrNumberArray(itemtype=>itemtype
265: , itemkey=>itemkey
266: , aname=>l_aname
267: , avalue=>l_avalue
268: );

Line 320: l_header_id := to_number(wf_engine.setctx_itemkey);

316: where notification_id = to_number(document_id);
317: EXCEPTION
318: WHEN NO_DATA_FOUND THEN
319: -- if viewing method is email
320: l_header_id := to_number(wf_engine.setctx_itemkey);
321: END;
322:
323: SELECT order_number
324: INTO l_blanket_number

Line 368: l_header_id := to_number(wf_engine.setctx_itemkey);

364: where notification_id = to_number(document_id);
365: EXCEPTION
366: WHEN NO_DATA_FOUND THEN
367: -- if viewing method is email
368: l_header_id := to_number(wf_engine.setctx_itemkey);
369: END;
370:
371: SELECT obhe.end_date_active
372: INTO l_end_date

Line 409: l_aname wf_engine.nametabtyp;

405: l_salesrep VARCHAR2(240);
406: l_sold_to VARCHAR2(240);
407: l_customer_number VARCHAR2(30);--bug5562980
408: l_end_date DATE;
409: l_aname wf_engine.nametabtyp;
410: l_avaluetext wf_engine.texttabtyp;
411: --
412: BEGIN
413: IF l_debug_level > 0 THEN

Line 410: l_avaluetext wf_engine.texttabtyp;

406: l_sold_to VARCHAR2(240);
407: l_customer_number VARCHAR2(30);--bug5562980
408: l_end_date DATE;
409: l_aname wf_engine.nametabtyp;
410: l_avaluetext wf_engine.texttabtyp;
411: --
412: BEGIN
413: IF l_debug_level > 0 THEN
414: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Expired:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

Line 446: wf_engine.SetItemAttrTextArray(itemtype=>itemtype,

442: l_avaluetext(2) := l_sold_to;
443: l_aname(3) := 'BLANKET_EXPIRE_DATE';
444: l_avaluetext(3) := l_end_date;
445:
446: wf_engine.SetItemAttrTextArray(itemtype=>itemtype,
447: itemkey=>itemkey,
448: aname=>l_aname,
449: avalue=>l_avaluetext);
450:

Line 537: l_blanket_number := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'TRANSACTION_NUMBER');

533: END IF;
534: OE_STANDARD_WF.Set_Msg_Context(actid);
535: IF (funcmode = 'RUN') then
536: -- check for releases of blanket
537: l_blanket_number := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'TRANSACTION_NUMBER');
538: OE_BLANKET_WF_UTIL.Check_Release(p_blanket_number => l_blanket_number, x_return_status => l_return_status);
539: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
540: --Blanket release check failed, return incomplete
541: --UI will display the message

Line 629: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');

625:
626: -- ok to go date change
627: -- if it is at blanket_submit_draft_eligible, no need to go date change, calculate effective date later will figure out the right timers
628: IF l_activity_name <> 'BLANKET_SUBMIT_DRAFT_ELIGIBLE' THEN
629: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');
630: END IF;
631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add('EXITING OE_Blanket_WF.Blanket_Date_Changed normally', 1);

Line 695: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'COMPLETE');

691: return;
692: END;
693:
694: -- ok to go submit draft
695: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'COMPLETE');
696:
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add('EXITING OE_Blanket_WF.Submit_Draft', 1);
699: END IF;

Line 756: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'COMPLETE');

752:
753: END;
754:
755: -- ok to go submit draft
756: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'COMPLETE');
757:
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add('EXITING OE_Blanket_WF.Close', 1);
760: END IF;

Line 798: l_aname wf_engine.nametabtyp;

794: l_salesrep VARCHAR2(240);
795: l_sold_to VARCHAR2(240);
796: l_customer_number VARCHAR2(30);--bug5562980
797: l_end_date DATE;
798: l_aname wf_engine.nametabtyp;
799: l_avaluetext wf_engine.texttabtyp;
800: l_terminator VARCHAR2(100);
801: l_return_status VARCHAR2(240);
802: l_reason_id NUMBER;

Line 799: l_avaluetext wf_engine.texttabtyp;

795: l_sold_to VARCHAR2(240);
796: l_customer_number VARCHAR2(30);--bug5562980
797: l_end_date DATE;
798: l_aname wf_engine.nametabtyp;
799: l_avaluetext wf_engine.texttabtyp;
800: l_terminator VARCHAR2(100);
801: l_return_status VARCHAR2(240);
802: l_reason_id NUMBER;
803: --

Line 848: WF_ENGINE.SetItemAttrText(itemtype=>OE_GLOBALS.G_WFI_BKT,

844: INTO l_terminator
845: FROM FND_USER
846: WHERE USER_ID = p_terminated_by;
847:
848: WF_ENGINE.SetItemAttrText(itemtype=>OE_GLOBALS.G_WFI_BKT,
849: itemkey=>to_char(p_header_id),
850: aname=>'TERMINATOR',
851: avalue=>l_terminator);
852:

Line 870: wf_engine.SetItemAttrTextArray(itemtype=>OE_GLOBALS.G_WFI_BKT,

866: l_avaluetext(2) := l_sold_to;
867: l_aname(3) := 'BLANKET_EXPIRE_DATE';
868: l_avaluetext(3) := l_end_date;
869:
870: wf_engine.SetItemAttrTextArray(itemtype=>OE_GLOBALS.G_WFI_BKT,
871: itemkey=>to_char(p_header_id),
872: aname=>l_aname,
873: avalue=>l_avaluetext);
874:

Line 877: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'TERMINATE');

873: avalue=>l_avaluetext);
874:
875: -- end header attributes
876:
877: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'TERMINATE');
878:
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add('EXITING OE_Blanket_WF.Terminate', 1);
881: END IF;

Line 935: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'EXTEND');

931: return;
932: END;
933:
934: -- ok to go extend
935: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'EXTEND');
936:
937: IF l_debug_level > 0 THEN
938: oe_debug_pub.add('EXITING OE_Blanket_WF.Extend', 1);
939: END IF;

Line 967: l_aname wf_engine.nametabtyp;

963: l_salesrep VARCHAR2(240);
964: l_sold_to VARCHAR2(240);
965: l_customer_number VARCHAR2(30);--bug5562980
966: l_end_date DATE;
967: l_aname wf_engine.nametabtyp;
968: l_avaluetext wf_engine.texttabtyp;
969: --
970: BEGIN
971: IF l_debug_level > 0 THEN

Line 968: l_avaluetext wf_engine.texttabtyp;

964: l_sold_to VARCHAR2(240);
965: l_customer_number VARCHAR2(30);--bug5562980
966: l_end_date DATE;
967: l_aname wf_engine.nametabtyp;
968: l_avaluetext wf_engine.texttabtyp;
969: --
970: BEGIN
971: IF l_debug_level > 0 THEN
972: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Header_Attributes_Internal:'||To_char(p_header_id),1);

Line 990: wf_engine.SetItemAttrTextArray(itemtype=>OE_GLOBALS.G_WFI_BKT,

986: l_avaluetext(2) := l_sold_to;
987: l_aname(3) := 'BLANKET_EXPIRE_DATE';
988: l_avaluetext(3) := l_end_date;
989:
990: wf_engine.SetItemAttrTextArray(itemtype=>OE_GLOBALS.G_WFI_BKT,
991: itemkey=>To_char(p_header_id),
992: aname=>l_aname,
993: avalue=>l_avaluetext);
994:

Line 1075: wf_engine.setitemattrnumber(itemtype=>itemtype,

1071:
1072:
1073: l_final_timer := (l_end_date - Sysdate) * 1440;
1074: IF l_final_timer > 0 THEN
1075: wf_engine.setitemattrnumber(itemtype=>itemtype,
1076: itemkey=>itemkey,
1077: aname=>'BLANKET_FINAL_EXPIRE_TIMER',
1078: avalue=>l_final_timer);
1079: resultout := 'COMPLETE';