DBA Data[Home] [Help]

APPS.OE_ORDER_EXTN_IMPORT_PVT dependencies on OE_ORDER_LINES_ALL

Line 177: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Deriving Line_id from OE_ORDER_LINES_ALL...');

173: COMMIT;
174: END IF;
175: END IF;
176:
177: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Deriving Line_id from OE_ORDER_LINES_ALL...');
178: FOR i IN l_line_cur
179: LOOP
180: IF i.line_id IS NULL THEN
181: BEGIN

Line 183: FROM oe_order_lines_all

179: LOOP
180: IF i.line_id IS NULL THEN
181: BEGIN
182: SELECT line_id INTO l_line_id
183: FROM oe_order_lines_all
184: WHERE order_source_id = i.order_source_id
185: AND orig_sys_document_ref = i.orig_sys_document_ref
186: AND orig_sys_line_ref = i.orig_sys_line_ref
187: AND NVL(orig_sys_shipment_ref,FND_API.G_MISS_CHAR) = NVL(i.orig_sys_shipment_ref,FND_API.G_MISS_CHAR)

Line 243: , p_object_name => 'OE_ORDER_LINES_ALL'

239: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data
240: ( p_api_version => 1.0
241: , p_application_id => 660
242: , p_attr_group_type => 'OE_LINE_ATTRIBUTES_EXT'
243: , p_object_name => 'OE_ORDER_LINES_ALL'
244: , p_hz_party_id => 'OPERATIONS:5877'
245: , p_interface_table_name => 'OE_LINES_EXT_IFACE_ALL'
246: , p_data_set_id => l_data_set_id
247: ,p_related_class_codes_query => l_rel_sql