DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on INV_SALESORDER

Line 4842: inv_salesorder.get_oeheader_for_salesorder(

4838: DEBUG('p_dock_door_id: '||p_dock_door_id, 'Overship Staged Lines');
4839: END IF;
4840:
4841: -- get oe_order_header_id from sales order header id
4842: inv_salesorder.get_oeheader_for_salesorder(
4843: p_salesorder_id => p_mso_id
4844: , x_oe_header_id => l_oe_order_header_id
4845: , x_return_status => l_return_status
4846: );

Line 5561: l_mso_id := inv_salesorder.get_salesorder_for_oeheader(l_header_id);

5557: END IF;
5558:
5559: IF (l_sub_reservable = 1
5560: AND l_item_reservable = 1) THEN
5561: l_mso_id := inv_salesorder.get_salesorder_for_oeheader(l_header_id);
5562: l_reservation_record.demand_source_type_id := get_demand_src_type(l_header_id);
5563: l_reservation_record.demand_source_header_id := l_mso_id;
5564: l_reservation_record.demand_source_line_id := l_line_id;
5565: l_reservation_record.demand_source_line_detail := NULL;

Line 7905: , p_demand_source_header_id => inv_salesorder.get_salesorder_for_oeheader(p_header_id)

7901: , p_is_revision_control => l_is_revision_control
7902: , p_is_lot_control => l_is_lot_control
7903: , p_is_serial_control => l_is_serial_control
7904: , p_demand_source_type_id => l_demand_source_type_id
7905: , p_demand_source_header_id => inv_salesorder.get_salesorder_for_oeheader(p_header_id)
7906: , p_demand_source_line_id => p_line_id
7907: , p_revision => p_revision
7908: , p_lot_number => NULL
7909: , p_subinventory_code => NULL

Line 10143: inv_salesorder.get_oeheader_for_salesorder(

10139: RAISE fnd_api.g_exc_error;
10140: END IF;
10141:
10142: -- get oe_order_header_id from sales order header id
10143: inv_salesorder.get_oeheader_for_salesorder(
10144: p_salesorder_id => l_mtl_reservation_tab(resv_index).demand_source_header_id
10145: , x_oe_header_id => l_oe_order_header_id
10146: , x_return_status => l_return_status
10147: );

Line 10915: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(p_order_header_id);

10911: l_overship_case := 'Y';
10912: END IF;
10913:
10914: -- query reservations for header_id, line_id
10915: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(p_order_header_id);
10916: l_qry_reservation_record.demand_source_header_id := l_demand_source_header_id;
10917: l_qry_reservation_record.demand_source_line_id := p_order_line_id;
10918: l_qry_reservation_record.demand_source_type_id := l_demand_source_type_id;
10919: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

Line 12305: l_qry_reservation_record.demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_wds_cur.order_header_id);

12301:
12302: -- for each line in WDS from p_lpn_id
12303: FOR l_wds_cur IN wds_cur LOOP
12304: l_qry_reservation_record.demand_source_line_id := l_wds_cur.order_line_id;
12305: l_qry_reservation_record.demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_wds_cur.order_header_id);
12306: l_qry_reservation_record.demand_source_type_id := get_demand_src_type(l_wds_cur.order_header_id);
12307: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
12308:
12309: IF (l_debug = 1) THEN

Line 12674: inv_salesorder.get_oeheader_for_salesorder(

12670: END IF;
12671:
12672: l_order_line_id := l_mtl_reservation_tab(l_index_r).demand_source_line_id;
12673: -- get oe_order_header_id from sales order header id
12674: inv_salesorder.get_oeheader_for_salesorder(
12675: p_salesorder_id => l_mtl_reservation_tab(l_index_r).demand_source_header_id
12676: , x_oe_header_id => l_order_header_id
12677: , x_return_status => l_return_status
12678: );

Line 13118: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_loaded_lines_rec.order_header_id);

13114:
13115: IF (l_loaded_lines_rec.revision = l_lpn_cont_rec.revision --{
13116: OR l_loaded_lines_rec.revision IS NULL) THEN
13117: -- get demand source header id
13118: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_loaded_lines_rec.order_header_id);
13119: l_demand_source_type_id := get_demand_src_type(l_loaded_lines_rec.order_header_id);
13120: l_order_line_id := l_loaded_lines_rec.order_line_id;
13121:
13122: -- get total reserved quantity for line