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 757: wf_engine.getitemattrtext (oe_globals.g_wfi_ngo,

753: END;
754:
755: -- AME ER END
756: l_sales_document_type_code :=
757: wf_engine.getitemattrtext (oe_globals.g_wfi_ngo,
758: l_header_id,
759: 'SALES_DOCUMENT_TYPE_CODE'
760: );
761:

Line 840: where item_type = OE_GLOBALS.G_WFI_NGO

836: BEGIN
837: select wpa.activity_name
838: into l_activity_name
839: from wf_item_activity_statuses wias, wf_process_activities wpa
840: where item_type = OE_GLOBALS.G_WFI_NGO
841: and item_key = to_char(p_header_id)
842: and activity_status = wf_engine.eng_notified
843: and wpa.activity_name in ('SUBMIT_DRAFT_ELIGIBLE', 'NEGOTIATION_COMPLETE_ELIGIBLE')
844: and wias.process_activity = wpa.instance_id;

Line 849: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN

845:
846: EXCEPTION
847: WHEN OTHERS THEN
848:
849: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
850: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
851: ELSE -- assume blanket
852: fnd_message.set_name('ONT', 'OE_NTF_BSA');
853: END IF;

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

873: p_reason_comments => p_reason_comments,
874: x_reason_id => l_reason_id,
875: x_return_status => l_return_status);
876:
877: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'LOST');
878:
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost normally', 1);
881: END IF;

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

955: END IF;
956: END IF;
957: -- END Bug3435165
958:
959: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
960: select wpa.activity_name
961: into l_activity_name
962: from wf_item_activity_statuses wias, wf_process_activities wpa
963: where item_type = OE_GLOBALS.G_WFI_NGO

Line 963: where item_type = OE_GLOBALS.G_WFI_NGO

959: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
960: select wpa.activity_name
961: into l_activity_name
962: from wf_item_activity_statuses wias, wf_process_activities wpa
963: where item_type = OE_GLOBALS.G_WFI_NGO
964: and item_key = to_char(p_header_id)
965: and activity_status = wf_engine.eng_notified
966: and wpa.activity_name = l_customer_acceptance
967: and wias.process_activity = wpa.instance_id;

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

1004: ,p_order_source_id => null
1005: ,p_source_document_type_id => null);
1006:
1007:
1008: WF_ENGINE.CompleteActivityInternalName(itemtype => OE_GLOBALS.G_WFI_NGO,
1009: itemkey => to_char(p_header_id),
1010: activity => l_activity_name,
1011: result => 'ACCEPT');
1012: IF l_debug_level > 0 THEN

Line 1068: where item_type = OE_GLOBALS.G_WFI_NGO

1064: BEGIN
1065: select wpa.activity_name
1066: into l_activity_name
1067: from wf_item_activity_statuses wias, wf_process_activities wpa
1068: where item_type = OE_GLOBALS.G_WFI_NGO
1069: and item_key = to_char(p_header_id)
1070: and activity_status = wf_engine.eng_notified
1071: and wpa.activity_name = l_customer_acceptance
1072: and wias.process_activity = wpa.instance_id;

Line 1077: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN

1073:
1074: EXCEPTION
1075: WHEN OTHERS THEN
1076:
1077: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
1078: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1079: ELSE -- assume blanket
1080: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1081: END IF;

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

1101: x_reason_id => l_reason_id,
1102: x_return_status => l_return_status);
1103:
1104:
1105: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'REJECT');
1106: IF l_debug_level > 0 THEN
1107: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected normally', 1);
1108: END IF;
1109: EXCEPTION

Line 1151: where item_type = OE_GLOBALS.G_WFI_NGO

1147: BEGIN
1148: select wpa.activity_name
1149: into l_activity_name
1150: from wf_item_activity_statuses wias, wf_process_activities wpa
1151: where item_type = OE_GLOBALS.G_WFI_NGO
1152: and item_key = to_char(p_header_id)
1153: and activity_status = wf_engine.eng_notified
1154: and wpa.activity_name in ('WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION')
1155: and wias.process_activity = wpa.instance_id;

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

1155: and wias.process_activity = wpa.instance_id;
1156:
1157: EXCEPTION
1158: WHEN OTHERS THEN
1159: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
1160: IF l_sales_document_type_code = 'O' THEN
1161: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1162: ELSE -- assume blanket
1163: fnd_message.set_name('ONT', 'OE_NTF_BSA');

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

1175: -- ok to go date changed
1176: IF l_debug_level > 0 THEN
1177: oe_debug_pub.add('Calling WF_ENGINE to completeactivity' ,3);
1178: END IF;
1179: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);
1182: END IF;
1183: EXCEPTION

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

1252: END IF;
1253: END IF;
1254: -- END Bug3435165
1255:
1256: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
1257: IF l_sales_document_type_code = 'O' THEN
1258: l_entity_code := 'HEADER';
1259: ELSE
1260: l_entity_code := 'BLANKET_HEADER';

Line 1279: where item_type = OE_GLOBALS.G_WFI_NGO

1275:
1276: select wpa.activity_name
1277: into l_activity_name
1278: from wf_item_activity_statuses wias, wf_process_activities wpa
1279: where item_type = OE_GLOBALS.G_WFI_NGO
1280: and item_key = to_char(p_header_id)
1281: and activity_status = wf_engine.eng_notified
1282: and wpa.activity_name = l_submit_draft_eligible
1283: and wias.process_activity = wpa.instance_id;

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

1300: END IF;
1301: return;
1302: END;
1303: -- ok to go Submit Draft
1304: WF_ENGINE.CompleteActivityInternalName(itemtype => OE_GLOBALS.G_WFI_NGO,
1305: itemkey => to_char(p_header_id),
1306: activity => l_activity_name,
1307: result => 'COMPLETE');
1308: IF l_debug_level > 0 THEN

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

1344: IF l_debug_level > 0 THEN
1345: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes_Internal:'||To_char(p_header_id) ,1 ) ;
1346: END IF;
1347:
1348: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, To_char(p_header_id), 'SALES_DOCUMENT_TYPE_CODE');
1349: IF l_sales_document_type_code = 'O' THEN
1350:
1351: select sold_to_org_id, expiration_date, salesrep_id
1352: into l_sold_to_org_id, l_expiration_date, l_salesrep_id

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

1368: l_aname(3) := 'EXPIRATION_DATE';
1369: --Bug 12884612: Use date mask while converting to text
1370: l_avaluetext(3) := to_char(l_expiration_date,'DD-MON-RRRR');
1371:
1372: wf_engine.SetItemAttrTextArray(itemtype=>OE_GLOBALS.G_WFI_NGO,
1373: itemkey=>To_char(p_header_id),
1374: aname=>l_aname,
1375: avalue=>l_avaluetext);
1376:

Line 1533: where item_type = OE_GLOBALS.G_WFI_NGO

1529:
1530: select wpa.activity_name
1531: into l_activity_name
1532: from wf_item_activity_statuses wias, wf_process_activities wpa
1533: where item_type = OE_GLOBALS.G_WFI_NGO
1534: and item_key = to_char(p_header_id)
1535: and activity_status = wf_engine.eng_notified
1536: and wpa.activity_name = l_customer_acceptance
1537: and wias.process_activity = wpa.instance_id;