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_NEGOTIATE_WF dependencies on OE_GLOBALS

Line 29: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_NGO,

25: p_entity_code => 'HEADER'
26: ,p_entity_id => to_number(itemkey)
27: ,p_header_id => to_number(itemkey));
28:
29: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_NGO,
30: p_item_key => itemkey,
31: p_flow_status_code => 'LOST',
32: p_open_flag => 'N',
33: x_return_status => l_return_status);

Line 243: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,

239: END IF;
240:
241: END IF; -- blanket or quote
242:
243: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,
244: p_item_key => itemkey,
245: p_flow_status_code => 'DRAFT_SUBMITTED',
246: p_draft_submitted_flag => 'Y',
247: x_return_status => l_return_status);

Line 307: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,

303: p_entity_code => 'HEADER'
304: ,p_entity_id => to_number(itemkey)
305: ,p_header_id => to_number(itemkey));
306:
307: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,
308: p_item_key => itemkey,
309: p_flow_status_code => 'PENDING_CUSTOMER_ACCEPTANCE',
310: x_return_status => l_return_status);
311:

Line 359: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,

355: p_entity_code => 'HEADER'
356: ,p_entity_id => to_number(itemkey)
357: ,p_header_id => to_number(itemkey));
358:
359: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,
360: p_item_key => itemkey,
361: p_flow_status_code => 'CUSTOMER_ACCEPTED',
362: x_return_status => l_return_status);
363:

Line 413: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,

409: p_entity_code => 'HEADER'
410: ,p_entity_id => to_number(itemkey)
411: ,p_header_id => to_number(itemkey));
412:
413: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,
414: p_item_key => itemkey,
415: p_flow_status_code => 'DRAFT_CUSTOMER_REJECTED',
416: p_draft_submitted_flag => 'N',
417: x_return_status => l_return_status);

Line 611: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,

607: p_entity_code => 'HEADER'
608: ,p_entity_id => to_number(itemkey)
609: ,p_header_id => to_number(itemkey));
610:
611: OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_NGO,
612: p_item_key => itemkey,
613: p_flow_status_code => 'OFFER_EXPIRED',
614: p_open_flag => 'N',
615: x_return_status => l_return_status);

Line 706: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, l_header_id, 'SALES_DOCUMENT_TYPE_CODE');

702: -- if viewing method is email
703: l_header_id := to_number(wf_engine.setctx_itemkey);
704: END;
705:
706: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, l_header_id, 'SALES_DOCUMENT_TYPE_CODE');
707: IF l_sales_document_type_code = 'B' THEN
708: SELECT order_number
709: INTO l_blanket_number
710: FROM oe_blanket_headers_all

Line 785: where item_type = OE_GLOBALS.G_WFI_NGO

781: BEGIN
782: select wpa.activity_name
783: into l_activity_name
784: from wf_item_activity_statuses wias, wf_process_activities wpa
785: where item_type = OE_GLOBALS.G_WFI_NGO
786: and item_key = to_char(p_header_id)
787: and activity_status = wf_engine.eng_notified
788: and wpa.activity_name in ('SUBMIT_DRAFT_ELIGIBLE', 'NEGOTIATION_COMPLETE_ELIGIBLE')
789: and wias.process_activity = wpa.instance_id;

Line 794: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN

790:
791: EXCEPTION
792: WHEN OTHERS THEN
793:
794: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
795: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
796: ELSE -- assume blanket
797: fnd_message.set_name('ONT', 'OE_NTF_BSA');
798: END IF;

Line 822: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'LOST');

818: p_reason_comments => p_reason_comments,
819: x_reason_id => l_reason_id,
820: x_return_status => l_return_status);
821:
822: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'LOST');
823:
824: IF l_debug_level > 0 THEN
825: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost normally', 1);
826: END IF;

Line 904: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');

900: END IF;
901: END IF;
902: -- END Bug3435165
903:
904: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
905: select wpa.activity_name
906: into l_activity_name
907: from wf_item_activity_statuses wias, wf_process_activities wpa
908: where item_type = OE_GLOBALS.G_WFI_NGO

Line 908: where item_type = OE_GLOBALS.G_WFI_NGO

904: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
905: select wpa.activity_name
906: into l_activity_name
907: from wf_item_activity_statuses wias, wf_process_activities wpa
908: where item_type = OE_GLOBALS.G_WFI_NGO
909: and item_key = to_char(p_header_id)
910: and activity_status = wf_engine.eng_notified
911: and wpa.activity_name = l_customer_acceptance
912: and wias.process_activity = wpa.instance_id;

Line 953: WF_ENGINE.CompleteActivityInternalName(itemtype => OE_GLOBALS.G_WFI_NGO,

949: ,p_order_source_id => null
950: ,p_source_document_type_id => null);
951:
952:
953: WF_ENGINE.CompleteActivityInternalName(itemtype => OE_GLOBALS.G_WFI_NGO,
954: itemkey => to_char(p_header_id),
955: activity => l_activity_name,
956: result => 'ACCEPT');
957: IF l_debug_level > 0 THEN

Line 1013: where item_type = OE_GLOBALS.G_WFI_NGO

1009: BEGIN
1010: select wpa.activity_name
1011: into l_activity_name
1012: from wf_item_activity_statuses wias, wf_process_activities wpa
1013: where item_type = OE_GLOBALS.G_WFI_NGO
1014: and item_key = to_char(p_header_id)
1015: and activity_status = wf_engine.eng_notified
1016: and wpa.activity_name = l_customer_acceptance
1017: and wias.process_activity = wpa.instance_id;

Line 1022: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN

1018:
1019: EXCEPTION
1020: WHEN OTHERS THEN
1021:
1022: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
1023: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1024: ELSE -- assume blanket
1025: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1026: END IF;

Line 1050: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'REJECT');

1046: x_reason_id => l_reason_id,
1047: x_return_status => l_return_status);
1048:
1049:
1050: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'REJECT');
1051: IF l_debug_level > 0 THEN
1052: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected normally', 1);
1053: END IF;
1054: EXCEPTION

Line 1096: where item_type = OE_GLOBALS.G_WFI_NGO

1092: BEGIN
1093: select wpa.activity_name
1094: into l_activity_name
1095: from wf_item_activity_statuses wias, wf_process_activities wpa
1096: where item_type = OE_GLOBALS.G_WFI_NGO
1097: and item_key = to_char(p_header_id)
1098: and activity_status = wf_engine.eng_notified
1099: and wpa.activity_name in ('WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION')
1100: and wias.process_activity = wpa.instance_id;

Line 1104: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');

1100: and wias.process_activity = wpa.instance_id;
1101:
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
1105: IF l_sales_document_type_code = 'O' THEN
1106: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1107: ELSE -- assume blanket
1108: fnd_message.set_name('ONT', 'OE_NTF_BSA');

Line 1124: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');

1120: -- ok to go date changed
1121: IF l_debug_level > 0 THEN
1122: oe_debug_pub.add('Calling WF_ENGINE to completeactivity' ,3);
1123: END IF;
1124: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');
1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);
1127: END IF;
1128: EXCEPTION

Line 1201: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');

1197: END IF;
1198: END IF;
1199: -- END Bug3435165
1200:
1201: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
1202: IF l_sales_document_type_code = 'O' THEN
1203: l_entity_code := 'HEADER';
1204: ELSE
1205: l_entity_code := 'BLANKET_HEADER';

Line 1224: where item_type = OE_GLOBALS.G_WFI_NGO

1220:
1221: select wpa.activity_name
1222: into l_activity_name
1223: from wf_item_activity_statuses wias, wf_process_activities wpa
1224: where item_type = OE_GLOBALS.G_WFI_NGO
1225: and item_key = to_char(p_header_id)
1226: and activity_status = wf_engine.eng_notified
1227: and wpa.activity_name = l_submit_draft_eligible
1228: and wias.process_activity = wpa.instance_id;

Line 1249: WF_ENGINE.CompleteActivityInternalName(itemtype => OE_GLOBALS.G_WFI_NGO,

1245: END IF;
1246: return;
1247: END;
1248: -- ok to go Submit Draft
1249: WF_ENGINE.CompleteActivityInternalName(itemtype => OE_GLOBALS.G_WFI_NGO,
1250: itemkey => to_char(p_header_id),
1251: activity => l_activity_name,
1252: result => 'COMPLETE');
1253: IF l_debug_level > 0 THEN

Line 1293: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, To_char(p_header_id), 'SALES_DOCUMENT_TYPE_CODE');

1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes_Internal:'||To_char(p_header_id) ,1 ) ;
1291: END IF;
1292:
1293: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, To_char(p_header_id), 'SALES_DOCUMENT_TYPE_CODE');
1294: IF l_sales_document_type_code = 'O' THEN
1295:
1296: select sold_to_org_id, expiration_date, salesrep_id
1297: into l_sold_to_org_id, l_expiration_date, l_salesrep_id

Line 1316: wf_engine.SetItemAttrTextArray(itemtype=>OE_GLOBALS.G_WFI_NGO,

1312: l_avaluetext(2) := l_sold_to;
1313: l_aname(3) := 'EXPIRATION_DATE';
1314: l_avaluetext(3) := l_expiration_date;
1315:
1316: wf_engine.SetItemAttrTextArray(itemtype=>OE_GLOBALS.G_WFI_NGO,
1317: itemkey=>To_char(p_header_id),
1318: aname=>l_aname,
1319: avalue=>l_avaluetext);
1320:

Line 1466: where item_type = OE_GLOBALS.G_WFI_NGO

1462:
1463: select wpa.activity_name
1464: into l_activity_name
1465: from wf_item_activity_statuses wias, wf_process_activities wpa
1466: where item_type = OE_GLOBALS.G_WFI_NGO
1467: and item_key = to_char(p_header_id)
1468: and activity_status = wf_engine.eng_notified
1469: and wpa.activity_name = l_customer_acceptance
1470: and wias.process_activity = wpa.instance_id;