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 1858: from oe_order_headers

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

Line 2302: From oe_order_headers

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

Line 2443: From oe_order_headers

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

Line 2502: From oe_order_headers

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