APPS.OE_ORDER_IMPORT_WF dependencies on OE_HEADERS_INTERFACE

Line 70: From oe_headers_interface

66: If l_org_id is Null Then
67: Begin
68: Select org_id
69: Into l_org_id
70: From oe_headers_interface
71: Where orig_sys_document_ref = p_itemkey
72: And order_source_id = '20';
73: Exception
74: When Others Then

Line 576: From oe_headers_interface

572:
573: Begin
574: Select request_id
575: Into l_request_id
576: From oe_headers_interface
577: Where order_source_id = 20
578: And orig_sys_document_ref = l_orig_sys_document_ref
579: And request_id = nvl(l_request_id, request_id)
580: And decode(l_customer_key_profile, 'Y',

Line 896: from oe_headers_interface

892: END IF;
893: -- check the usage of the ship_to_org_id
894: Select sold_to_org_id, ship_to_org_id
895: into l_party_id, l_party_site_id
896: from oe_headers_interface
897: where orig_sys_document_ref = l_orig_sys_document_ref
898: And xml_transaction_type_code = l_xml_transaction_type_code
899: And request_id = l_request_id
900: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;

Line 935: fnd_message.set_token ('OPT_TABLE', 'in oe_headers_interface');

931: oe_debug_pub.add( 'L_PARTY_ID in when no data found => ' || L_PARTY_ID ) ;
932: END IF;
933: if l_order_imported = G_WFR_INCOMPLETE Then
934: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
935: fnd_message.set_token ('OPT_TABLE', 'in oe_headers_interface');
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');

Line 1250: from oe_headers_interface

1246: Else
1247: -- check the usage of the ship_to_org_id
1248: Select xml_message_id, sold_to_org_id, ship_to_org_id
1249: into l_document_id, l_party_id, l_party_site_id
1250: from oe_headers_interface
1251: where order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
1252: And orig_sys_document_ref = l_orig_sys_document_ref
1253: And decode(l_customer_key_profile, 'Y',
1254: nvl(sold_to_org_id, -999), 1)