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 OE_GLOBALS

Line 30: where item_type = OE_GLOBALS.G_WFI_NGO

26:
27: select count(1)
28: into l_count
29: from wf_items
30: where item_type = OE_GLOBALS.G_WFI_NGO
31: and item_key = itemkey;
32:
33: IF l_count = 0 THEN
34: /* only if it has not gone through negotiation QA check

Line 66: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_BKT,

62: -- negotiation flow exists, no need to QA check
63:
64: -- UI will always display any msg
65:
66: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_BKT,
67: p_item_key => itemkey,
68: p_flow_status_code => 'DRAFT_SUBMITTED',
69: p_draft_submitted_flag => 'Y',
70: x_return_status => l_return_status);

Line 120: where item_type = OE_GLOBALS.G_WFI_NGO

116: IF (funcmode = 'RUN') THEN
117: select count(1)
118: into l_count
119: from wf_items
120: where item_type = OE_GLOBALS.G_WFI_NGO
121: and item_key = itemkey;
122:
123: IF l_count > 0 THEN
124: resultout := 'COMPLETE:Y';

Line 191: p_item_type => OE_GLOBALS.G_WFI_BKT,

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),
190: p_flow_status_code => 'AWAITING_START_DATE',
191: p_item_type => OE_GLOBALS.G_WFI_BKT,
192: x_return_status => l_return_status);
193:
194: resultout := 'COMPLETE:AWAITING_START_DATE';
195: IF l_debug_level > 0 THEN

Line 202: p_item_type => OE_GLOBALS.G_WFI_BKT,

198: return;
199: ELSIF l_end_date is null THEN --start date reached, but no end date
200: oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),
201: p_flow_status_code => 'ACTIVE',
202: p_item_type => OE_GLOBALS.G_WFI_BKT,
203: x_return_status => l_return_status);
204: resultout := 'COMPLETE:NO_END_DATE';
205: IF l_debug_level > 0 THEN
206: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Date: No end date', 1);

Line 234: p_item_type => OE_GLOBALS.G_WFI_BKT,

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),
233: p_flow_status_code => 'ACTIVE',
234: p_item_type => OE_GLOBALS.G_WFI_BKT,
235: x_return_status => l_return_status);
236: resultout := 'COMPLETE:NO_REMINDER';
237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Dates: NO REMINDER', 1);

Line 251: p_item_type => OE_GLOBALS.G_WFI_BKT,

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),
250: p_flow_status_code => 'ACTIVE',
251: p_item_type => OE_GLOBALS.G_WFI_BKT,
252: x_return_status => l_return_status);
253: resultout := 'COMPLETE:EXPIRE_TODAY';
254: IF l_debug_level > 0 THEN
255: oe_debug_pub.add('OE_Blanket_WF.Calculate_Effective_Dates: EXPIRE TODAY', 1);

Line 271: p_item_type => OE_GLOBALS.G_WFI_BKT,

267: , avalue=>l_avalue
268: );
269: oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),
270: p_flow_status_code => 'ACTIVE',
271: p_item_type => OE_GLOBALS.G_WFI_BKT,
272: x_return_status => l_return_status);
273: resultout := 'COMPLETE:START_DATE_REACHED';
274: END IF; -- end if of expiration date is today or future
275:

Line 418: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,

414: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Expired:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
415: END IF;
416: OE_STANDARD_WF.Set_Msg_Context(actid);
417: IF (funcmode = 'RUN') then
418: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,
419: p_item_key => itemkey,
420: p_flow_status_code => 'EXPIRED',
421: x_return_status => l_return_status);
422:

Line 488: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,

484: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Terminate_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
485: END IF;
486: OE_STANDARD_WF.Set_Msg_Context(actid);
487: IF (funcmode = 'RUN') then
488: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,
489: p_item_key => itemkey,
490: p_flow_status_code => 'TERMINATED',
491: x_return_status => l_return_status);
492:

Line 548: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,

544: OE_STANDARD_WF.Clear_Msg_Context;
545: return;
546: END IF;
547: -- update open_flag to N
548: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,
549: p_item_key => itemkey,
550: p_flow_status_code => 'CLOSED',--bug#5589336
551: p_open_flag => 'N',
552: x_return_status => l_return_status);

Line 608: where item_type = OE_GLOBALS.G_WFI_BKT

604: BEGIN
605: select wpa.activity_name
606: into l_activity_name
607: from wf_item_activity_statuses wias, wf_process_activities wpa
608: where item_type = OE_GLOBALS.G_WFI_BKT
609: and item_key = to_char(p_header_id)
610: and activity_status = 'NOTIFIED'
611: and wpa.activity_name in ('WAIT_FOR_START_DATE', 'BLANKET_NO_END_DATE', 'WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION', 'BLANKET_SUBMIT_DRAFT_ELIGIBLE')
612: and wias.process_activity = wpa.instance_id;

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 673: where item_type = OE_GLOBALS.G_WFI_BKT

669: BEGIN
670: select wpa.activity_name
671: into l_activity_name
672: from wf_item_activity_statuses wias, wf_process_activities wpa
673: where item_type = OE_GLOBALS.G_WFI_BKT
674: and item_key = to_char(p_header_id)
675: and activity_status = 'NOTIFIED'
676: and wpa.activity_name = 'BLANKET_SUBMIT_DRAFT_ELIGIBLE'
677: and wias.process_activity = wpa.instance_id;

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 737: where item_type = OE_GLOBALS.G_WFI_BKT

733: BEGIN
734: select wpa.activity_name
735: into l_activity_name
736: from wf_item_activity_statuses wias, wf_process_activities wpa
737: where item_type = OE_GLOBALS.G_WFI_BKT
738: and item_key = to_char(p_header_id)
739: and activity_status = 'NOTIFIED'
740: and wpa.activity_name = 'CLOSE_BLANKET_ELIGIBLE'
741: and wias.process_activity = wpa.instance_id;

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 814: where item_type = OE_GLOBALS.G_WFI_BKT

810: BEGIN
811: select wpa.activity_name
812: into l_activity_name
813: from wf_item_activity_statuses wias, wf_process_activities wpa
814: where item_type = OE_GLOBALS.G_WFI_BKT
815: and item_key = to_char(p_header_id)
816: and activity_status = 'NOTIFIED'
817: and wpa.activity_name in ('WAIT_FOR_START_DATE', 'BLANKET_NO_END_DATE', 'WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION')
818: and wias.process_activity = wpa.instance_id;

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 917: where item_type = OE_GLOBALS.G_WFI_BKT

913: BEGIN
914: select wpa.activity_name
915: into l_activity_name
916: from wf_item_activity_statuses wias, wf_process_activities wpa
917: where item_type = OE_GLOBALS.G_WFI_BKT
918: and item_key = to_char(p_header_id)
919: and activity_status = 'NOTIFIED'
920: and wpa.activity_name = 'CLOSE_BLANKET_ELIGIBLE'
921: and wias.process_activity = wpa.instance_id;

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 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: