APPS.OE_ORDER_IMPORT_WF dependencies on OE_ORDER_HEADERS

Line 910: From oe_order_headers

906: oe_debug_pub.add( 'IN ELSIF L_ORDER_IMPORT => ' || L_ORDER_IMPORTED ) ;
907: END IF;
908: Select header_id, sold_to_org_id
909: Into l_header_id, l_party_id
910: From oe_order_headers
911: Where header_id = l_header_id
912: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
913: IF l_debug_level > 0 THEN
914: oe_debug_pub.add( 'HEADER_ID IN ELSIF =>' || L_HEADER_ID ) ;

Line 940: fnd_message.set_token ('OPT_TABLE', 'in oe_order_headers');

936: fnd_message.set_token ('DOC_ID', l_orig_sys_document_ref);
937: oe_msg_pub.add;
938: else
939: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
940: fnd_message.set_token ('OPT_TABLE', 'in oe_order_headers');
941: fnd_message.set_token ('DOC_ID', l_header_id);
942: oe_msg_pub.add;
943: end if;
944: null;

Line 1238: From oe_order_headers

1234: If l_order_imported = G_WFR_COMPLETE Then
1235:
1236: Select header_id, xml_message_id, sold_to_org_id, ship_to_org_id
1237: Into l_header_id, l_document_id, l_party_id, l_party_site_id
1238: From oe_order_headers
1239: Where order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
1240: And orig_sys_document_ref = l_orig_sys_document_ref
1241: And decode(l_customer_key_profile, 'Y',
1242: nvl(sold_to_org_id, -999), 1)

Line 1267: From oe_order_headers

1263:
1264: Else
1265: Select header_id, xml_message_id, sold_to_org_id, ship_to_org_id
1266: Into l_header_id, l_document_id, l_party_id, l_party_site_id
1267: From oe_order_headers
1268: Where header_id = p_itemkey
1269: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
1270: End If;
1271:

Line 1687: FROM oe_order_headers

1683: OE_STANDARD_WF.Set_Msg_Context(p_actid);
1684: If p_itemtype = Oe_Globals.G_WFI_HDR Then
1685: SELECT order_source_id, orig_sys_document_ref, sold_to_org_id, change_sequence, order_number, order_type_id, org_id
1686: INTO l_order_source_id, l_orig_sys_document_ref, l_sold_to_org_id, l_change_sequence, l_order_number, l_order_type_id, l_org_id
1687: FROM oe_order_headers
1688: WHERE header_id = p_itemkey;
1689:
1690: -- start bug 3688227
1691: -- this message context should be header, since this activity will

Line 1857: from oe_order_headers

1853: );
1854: begin
1855: select orig_sys_document_ref, sold_to_org_id, change_sequence
1856: into l_orig_sys_document_ref, l_customer_number, l_change_sequence
1857: from oe_order_headers
1858: where header_id = l_header_id;
1859: exception
1860: when others then
1861: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2301: From oe_order_headers

2297:
2298: Begin
2299: Select orig_sys_document_ref
2300: Into l_orig_sys_document_ref
2301: From oe_order_headers
2302: Where header_id = l_header_id;
2303: -- start bug 3688227
2304: OE_MSG_PUB.update_msg_context(
2305: p_orig_sys_document_ref => l_orig_sys_document_ref

Line 2442: From oe_order_headers

2438:
2439: Begin
2440: Select order_number, order_type_id, header_id
2441: Into l_document_num, l_order_type_id, l_header_id
2442: From oe_order_headers
2443: Where orig_sys_document_ref = l_orig_sys_document_ref
2444: And decode(l_customer_key_profile, 'Y',
2445: nvl(sold_to_org_id, -999), 1)
2446: = decode(l_customer_key_profile, 'Y',

Line 2501: From oe_order_headers

2497: -- try to get document num for "success" POA
2498:
2499: Select order_number, order_type_id, header_id
2500: Into l_document_num, l_order_type_id, l_header_id
2501: From oe_order_headers
2502: Where orig_sys_document_ref = l_orig_sys_document_ref
2503: And decode(l_customer_key_profile, 'Y',
2504: nvl(sold_to_org_id, -999), 1)
2505: = decode(l_customer_key_profile, 'Y',