APPS.OE_ORDER_EXTN_IMPORT_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 67: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Deriving Header_id from OE_ORDER_HEADERS_ALL...');

63: END IF;
64:
65: END IF;
66:
67: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Deriving Header_id from OE_ORDER_HEADERS_ALL...');
68: FOR i IN l_header_cur
69: LOOP
70: IF i.header_id IS NULL THEN
71: BEGIN

Line 73: FROM oe_order_headers_all

69: LOOP
70: IF i.header_id IS NULL THEN
71: BEGIN
72: SELECT header_id INTO l_header_id
73: FROM oe_order_headers_all
74: WHERE order_source_id = i.order_source_id
75: AND orig_sys_document_ref = i.orig_sys_document_ref
76: AND org_id = Nvl(i.org_id,l_org_id)
77: AND (sold_to_org_id is NULL OR decode(l_customer_key_profile, 'Y',nvl(sold_to_org_id, FND_API.G_MISS_NUM), 1)

Line 129: , p_object_name => 'OE_ORDER_HEADERS_ALL'

125: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data
126: ( p_api_version => 1.0
127: , p_application_id => 660
128: , p_attr_group_type => 'OE_HEADER_ATTRIBUTES_EXT'
129: , p_object_name => 'OE_ORDER_HEADERS_ALL'
130: , p_hz_party_id => 'OPERATIONS:5877'
131: , p_interface_table_name => 'OE_HEADERS_EXT_IFACE_ALL'
132: , p_data_set_id => l_data_set_id
133: ,p_related_class_codes_query => l_rel_sql