[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_line_tbl(K).operation := 'UPDATE';
l_line_tbl(k).operation := OE_GLOBALS.G_OPR_UPDATE;
l_line_tbl(k).operation :='UPDATE';
SELECT distinct l.ship_set_id, h.order_number
FROM oe_order_headers h
,oe_order_lines_all l
, oe_sets s
WHERE h.order_number >= nvl(p_order_number_low,h.order_number)
AND h.order_number <= nvl(p_order_number_high,h.order_number)
AND h.header_id = l.header_id
AND h.org_id = l.org_id
AND h.open_flag = 'Y'
AND trunc(l.Schedule_ship_date) BETWEEN trunc(l_start_date) and trunc(l_end_date)
AND l.open_flag = 'Y'
AND l.ship_set_id IS NOT NULL
AND l.ship_set_id = s.set_id
AND h.header_id = s.header_id
AND s.set_name = nvl(l_set_name,s.set_name)
AND l.shipped_quantity IS NULL
AND l.fulfilled_quantity IS NULL
ORDER BY l.ship_set_id ;
SELECT l.line_id
FROM oe_order_lines l
WHERE l.ship_set_id = l_ship_set_id
FOR UPDATE;
Select Set_Name from
oe_sets where
set_id = p_set_id;
OE_Set_Util.Update_Set
(p_Set_Id => l_set_line_tbl(1).ship_set_id,
p_Ship_From_Org_Id => l_set_line_tbl(1).Ship_From_Org_Id,
p_Ship_To_Org_Id => l_set_line_tbl(1).Ship_To_Org_Id,
p_Schedule_Ship_Date => l_set_line_tbl(1).Schedule_Ship_Date,
p_Schedule_Arrival_Date => l_set_line_tbl(1).Schedule_Arrival_Date,
p_Freight_Carrier_Code => l_set_line_tbl(1).Freight_Carrier_Code,
p_Shipping_Method_Code => l_set_line_tbl(1).Shipping_Method_Code,
p_shipment_priority_code => l_set_line_tbl(1).shipment_priority_code,
X_Return_Status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);