The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure Delete_Dependents
Delete dependents call out for line.
Keep your dependenceis on line here
bug fix 2127356: log update_shipping req here.
bug fix 2670775: Reverse Limits here.
-----------------------------------------------------------*/
Procedure Delete_Dependents
( p_line_id IN NUMBER
,p_item_type_code IN VARCHAR2
,p_line_category_code IN VARCHAR2
,p_config_header_id IN NUMBER
,p_config_rev_nbr IN NUMBER
,p_schedule_status_code IN VARCHAR2
,p_shipping_interfaced_flag IN VARCHAR2
,p_ordered_quantity IN NUMBER -- BUG 2670775 Reverse Limits
,p_price_request_code IN VARCHAR2 -- BUG 2670775 Reverse Limits
,p_transaction_phase_code IN VARCHAR2 default null -- Bug 3315331
)IS
l_return_status varchar2(30);
l_delete_lines_tbl OE_ORDER_PUB.Request_Tbl_Type; -- For bug 3754586
oe_debug_pub.add('Entering in Delete Dependents');
/* set the set type in g_set_tbl to invalid if the line is being deleted */
IF OE_SET_UTIL.g_set_tbl.count > 0 THEN
if l_debug_level > 0 then
oe_debug_pub.add('Table Count : '||OE_SET_UTIL.g_set_tbl.count,3);
OE_Atchmt_Util.Delete_Attachments
( p_entity_code => OE_GLOBALS.G_ENTITY_LINE
, p_entity_id => p_line_id
, x_return_status => l_return_status
);
OE_SCHEDULE_UTIL.Delete_row(p_line_id => p_line_id);
OE_Line_Adj_Util.delete_row(p_line_id => p_line_id);
OE_Line_PAttr_Util.delete_row(p_line_id => p_line_id);
OE_Line_Scredit_Util.delete_row(p_line_id => p_line_id);
OE_Lot_Serial_Util.delete_row(p_line_id => p_line_id);
OE_Order_WF_Util.delete_row(p_type => 'LINE', p_id => p_line_id);
OE_Holds_PUB.Delete_Holds(p_line_id => p_line_id );
select header_id
into l_header_id
from oe_order_lines_all
where line_id = p_line_id;
OE_Line_Payment_Util.delete_row
(p_line_id => p_line_id
,p_header_id => l_header_id
);
/* Log and Execute the delayed request logged for update shipping
as they will get deleted in the next step */
if l_debug_level > 0 then
oe_debug_pub.ADD('p_shipping_interfaced_flag '|| p_shipping_interfaced_flag,1);
oe_debug_pub.ADD('Update Shipping,Delete '|| p_line_id,1);
The code for logging and processing the delayed request for update shipping
was removed for bug 3754586 , instead we call update_shipping_from_oe
This was done for the following reason :
In case of multiple lines call to process order with some lines getting
deleted and others getting updated, we see that WSHcheck scripts api is called
even for DELETE case at the time of delayes request execution whereas we want
the call to be made at actually databse delete in delete_row api.
*/
-- Preparing the table for calling Update_Shipping_From_OE for the deleted line
l_delete_lines_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_LINE;
l_delete_lines_tbl(1).entity_id := p_line_id;
l_delete_lines_tbl(1).param1 := FND_API.G_TRUE;
l_delete_lines_tbl(1).param2 := FND_API.G_FALSE;
l_delete_lines_tbl(1).request_unique_key1 := OE_GLOBALS.G_OPR_DELETE;
OE_Shipping_Integration_PVT.Update_Shipping_From_OE
(p_update_lines_tbl => l_delete_lines_tbl,
x_return_status => l_return_status
);
OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
p_delete_against => FALSE, -- bug 5114189
p_entity_id => p_line_id,
x_return_status => l_return_status
);
, 'Delete_Dependents'
);
END Delete_Dependents;
l_update_shipping VARCHAR2(1) := FND_API.G_FALSE;
l_update_commitment_flag VARCHAR2(1) := 'N';
l_update_commitment_applied VARCHAR2(1) := 'N';
l_delete_payment_count NUMBER;
l_po_NeedByDate_Update VARCHAR2(10); -- Adeed for IR ISO CMS project
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
IF NVL(OE_Order_Cache.g_header_rec.payment_type_code,'NULL') <> 'CREDIT_CARD'
AND p_x_line_rec.booked_flag ='Y'
THEN
-- Log Delayed Request for Verify Payment
if l_debug_level > 0 then
oe_debug_pub.ADD('log verify payment delayed request for change in Canceled Qty');
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
oe_debug_pub.add('Line is already shipped,will not update shipping', 1);
SELECT Count(1)
INTO l_ship_inv_count
FROM wsh_delivery_details wdd
WHERE wdd.source_code='OE'
AND wdd.source_line_id=p_x_line_rec.line_id
AND (wdd.released_status IN ('C','I')
OR oe_interfaced_flag='Y');
oe_debug_pub.add('the line is neither picked, shipped or interfaced. can call update shipping', 1);
-- Need to Call Shipping Update
IF l_ship_inv_count>0
THEN
if l_debug_level > 0 then
oe_debug_pub.add('Line is already shipped,will not update shipping', 1);
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND ((p_old_line_rec.calculate_price_flag in ('N','P') and p_x_line_rec.calculate_price_flag = 'Y')
OR (p_old_line_rec.calculate_price_flag = 'N' and p_x_line_rec.calculate_price_flag = 'P'))
THEN
if l_debug_level > 0 then
oe_debug_pub.add('setting price flag because of calculate price flag change', 3);
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE OR
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
p_x_line_rec.split_from_line_id IS NULL)) AND
p_x_line_rec.ato_line_id is NULL AND
( p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
(p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
p_x_line_rec.line_id = p_x_line_rec.top_model_line_id))
THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('LINE ID : '||p_x_line_rec.line_id,2);
l_update_shipping := FND_API.G_TRUE;
IF ( p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT' )
-- QUOTING change
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('item update: logging request for eval_hold_source');
ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
--change made for bug 1998333 Begin
if nvl(l_item_chg_prof,'N') = 'N' then
--retaining the old behaviour
p_x_line_rec.calculate_price_flag := 'Y';
update_adjustment_flags(p_old_line_rec,p_x_line_rec);
IF ( p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT')
-- QUOTING change
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('invoice site update: logging request for eval_hold_source');
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
--R12 CC Encryption
select count(payment_type_code) into
l_delete_payment_count from oe_payments
where header_id = p_x_line_rec.header_id
and line_id = p_x_line_rec.line_id and
payment_type_code in ('ACH','DIRECT_DEBIT','CREDIT_CARD');
IF l_delete_payment_count > 0 THEN
OE_delayed_requests_Pvt.log_request
(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
p_entity_id => p_x_line_rec.line_id,
p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
p_requesting_entity_id => p_x_line_rec.line_id,
p_request_type => OE_GLOBALS.G_DELETE_PAYMENTS,
p_param1 => p_x_line_rec.header_id,
p_param2 => to_char(p_old_line_rec.invoice_to_org_id),
x_return_status => l_return_status);
IF ( p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT')
-- QUOTING change
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
OE_delayed_requests_Pvt.log_request(
p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
p_entity_id => p_x_line_rec.line_id,
p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
p_requesting_entity_id => p_x_line_rec.line_id,
p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
p_param1 => 'H',
p_param2 => p_x_line_rec.blanket_number,
x_return_status => l_return_status);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
if l_debug_level > 0 then
oe_debug_pub.add('before checking profile ONT_HONOR_ITEM_CHANGE',5);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
if l_debug_level > 0 then
oe_debug_pub.add('before checking profile ONT_HONOR_ITEM_CHANGE',5);
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
--bug 3942402
IF NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id, p_old_line_rec.inventory_item_id) THEN
IF (nvl(p_x_line_rec.inventory_item_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
and nvl(p_old_line_rec.inventory_item_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)
and p_x_line_rec.calculate_price_flag in ('N','P')
and nvl(l_item_chg_prof,'N') = 'N' then
if l_debug_level > 0 then
oe_debug_pub.add('Changing calculate price flag to Y');
IF NOT OE_Internal_Requisition_Pvt.G_Update_ISO_From_Req THEN
IF NOT OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add(' Header Level Cancellation is FALSE',5);
, p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
, x_return_status => l_return_status
);
, p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
, x_return_status => l_return_status
);
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
p_x_line_rec.ato_line_id is NULL AND
p_old_line_rec.ordered_quantity = 0 AND
( p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
(p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
p_x_line_rec.line_id = p_x_line_rec.top_model_line_id))
THEN
p_x_line_rec.explosion_date := null;
l_update_shipping := FND_API.G_TRUE;
IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE and
p_x_line_rec.split_by = 'SYSTEM' and
NVL(p_x_line_rec.split_action_code,'X') = 'SPLIT')
OR
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
p_x_line_rec.split_from_line_id IS NOT NULL AND
nvl(p_x_line_rec.split_by, 'USER') = 'SYSTEM') THEN
-- don't call credit checking for system split when tax value changes.
l_param1 := 'No_Credit_Checking';
IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE and
p_x_line_rec.split_by = 'SYSTEM' and
NVL(p_x_line_rec.split_action_code,'X') = 'SPLIT') THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('Logging Reverse Limits delayed request for parent line');
IF ( p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NVL(p_x_line_rec.split_action_code,'X') = 'SPLIT' ) THEN
l_update_commitment_flag := 'Y';
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
/* INVCONV 02/JUN/00 ordered_quantity2 needs to be calculated
for split line process items - PARENT
=======================================================*/
IF p_x_line_rec.split_action_code = 'SPLIT' AND
p_x_line_rec.line_category_code <> 'RETURN' AND
p_x_line_rec.split_by = 'USER'
THEN
/*
p_x_line_rec.ordered_quantity2 :=
oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
if p_x_line_rec.booked_flag ='Y' then
IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = TRUE THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('multpayments: logging delayed request for verify payment as payment term is changed');
END IF; -- if operation is update
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
OE_GLOBALS.Equal(p_x_line_rec.reference_line_id,p_old_line_rec.reference_line_id) THEN --bug 5260190
p_x_line_rec.calculate_price_flag := 'Y';
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE OR
p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
IF p_x_line_rec.split_from_line_id is NULL THEN -- Bug 5676051
OE_delayed_requests_Pvt.log_request(
p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
p_entity_id => p_x_line_rec.line_id,
p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
p_requesting_entity_id => p_x_line_rec.line_id,
p_param1 => p_x_line_rec.operation, --Bug 4651421
p_param2 => p_x_line_rec.split_by,
p_param3 => p_x_line_rec.split_action_code,
p_param4 => to_char(p_x_line_rec.split_from_line_id),
p_request_type => OE_GLOBALS.G_INSERT_RMA,
x_return_status => l_return_status);
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
p_x_line_rec.booked_flag ='Y'
THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('logging delayed request for Verify Payment
forchange in Request date');
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
THEN
IF NVL(OE_Order_Cache.g_header_rec.payment_type_code, 'NULL') <> 'CREDIT_CARD' AND
p_x_line_rec.booked_flag ='Y' AND
(to_date(p_x_line_rec.schedule_ship_date, 'DD/MM/YYYY') <>
to_date(p_x_line_rec.request_date, 'DD/MM/YYYY'))
THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('logging delayed request for Verify Payment
for change in Scheduled Ship date');
l_po_NeedByDate_Update := NVL(FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM'),'NO');
oe_debug_pub.add(' Need By Date update is allowed ? '||l_po_NeedByDate_Update);
IF NOT OE_Internal_Requisition_Pvt.G_Update_ISO_From_Req
AND NOT OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL AND
l_po_NeedByDate_Update = 'YES' THEN
-- Log a delayed request to update the change in Schedule Ship Date to
-- Requisition Line. This request will be logged only if the change is
-- not initiated from Requesting Organization, and it is not a case of
-- Internal Sales Order Full Cancellation. It will even not be logged
-- Purchasing profile option does not allow update of Need By Date when
-- Schedule Ship Date changes on internal sales order line
OE_delayed_requests_Pvt.log_request
( p_entity_code => OE_GLOBALS.G_ENTITY_LINE
, p_entity_id => p_x_line_rec.line_id
, p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
, p_requesting_entity_id => p_x_line_rec.line_id
, p_request_unique_key1 => p_x_line_rec.header_id -- Order Hdr_id
, p_request_unique_key2 => p_x_line_rec.source_document_id -- Req Hdr_id
, p_request_unique_key3 => p_x_line_rec.source_document_line_id -- Req Line_id
, p_date_param1 => p_x_line_rec.schedule_ship_date
, p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
, x_return_status => l_return_status
);
l_po_NeedByDate_Update := NVL(FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM'),'NO');
oe_debug_pub.add(' Need By Date update is allowed ? '||l_po_NeedByDate_Update);
IF NOT OE_Internal_Requisition_Pvt.G_Update_ISO_From_Req
AND NOT OE_SALES_CAN_UTIL.G_IR_ISO_HDR_CANCEL AND
OE_Schedule_GRP.G_ISO_Planning_Update THEN -- Added for IR ISO Tracking bug 7667702
-- l_po_NeedByDate_Update = 'YES' THEN -- Commented for IR ISO Tracking bug 7667702
IF l_po_NeedByDate_Update = 'YES' THEN -- Added for IR ISO Tracking bug 7667702
-- Log a delayed request to update the change in Schedule Arrival Date to
-- Requisition Line. This request will be logged only if the change is
-- not initiated from Requesting Organization, and it is not a case of
-- Internal Sales Order Full Cancellation. It will even not be logged
-- Purchasing profile option does not allow update of Need By Date when
-- Schedule Arrival Date changes on internal sales order line
OE_delayed_requests_Pvt.log_request
( p_entity_code => OE_GLOBALS.G_ENTITY_LINE
, p_entity_id => p_x_line_rec.line_id
, p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
, p_requesting_entity_id => p_x_line_rec.line_id
, p_request_unique_key1 => p_x_line_rec.header_id -- Order Hdr_id
, p_request_unique_key2 => p_x_line_rec.source_document_id -- Req Hdr_id
, p_request_unique_key3 => p_x_line_rec.source_document_line_id -- Req Line_id
, p_date_param1 => p_x_line_rec.schedule_arrival_date
-- Note: p_date_param1 is used for both Schedule_Ship_Date and
-- Schedule_Arrival_Date, as while executing G_UPDATE_REQUISITION delayed
-- request via OE_Process_Requisition_Pvt.Update_Internal_Requisition,
-- it can expect change with respect to Ship or Arrival date. Thus, will
-- not raise any issues.
, p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
, x_return_status => l_return_status
);
oe_debug_pub.add(' Need By Date is not allowed to update. Updating MTL_Supply only',5);
OE_SCHEDULE_UTIL.Update_PO(p_x_line_rec.schedule_arrival_date,
p_x_line_rec.source_document_id,
p_x_line_rec.source_document_line_id);
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Ordered quantity UOM and update the field shipped quantity
-- Call API to convert the shipping quantity to shipped quantity from
-- shipping quantity UOM to ordered quantity UOM and assign the returned
-- quantity to shipped quantity of p_x_line_rec.
if l_debug_level > 0 then
oe_debug_pub.ADD('Order Quantity UOM : '|| p_x_line_rec.order_quantity_uom,2);
oe_debug_pub.ADD('OPM Process shipping update ',1);
oe_debug_pub.ADD('OPM Process shipping update conversion gives shipped quantity of ' || l_temp_shipped_quantity,1);
l_update_shipping := FND_API.G_TRUE;
IF ( p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT')
-- QUOTING change
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('ship from update: logging request for eval_hold_source', 1);
SELECT wms_enabled_flag
INTO l_wms_org_flag_new
FROM mtl_parameters
WHERE organization_id= p_x_line_rec.ship_from_org_id;
SELECT wms_enabled_flag
INTO l_wms_org_flag_old
FROM mtl_parameters
WHERE organization_id= p_old_line_rec.ship_from_org_id;
l_update_shipping := FND_API.G_TRUE;
oe_debug_pub.add('subinventory update', 1);
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
IF ( p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT')
-- QUOTING change
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('ship to update: logging request for eval_hold_source', 1);
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
and p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
and p_x_line_rec.split_by = 'SYSTEM'
and NVL(p_x_line_rec.split_action_code,'X') = 'SPLIT'
and p_x_line_rec.calculate_price_flag = 'Y' Then
p_x_line_rec.calculate_price_flag :='P';
SELECT calculate_price_flag
INTO l_orig_line_calc_price_flag
FROM OE_ORDER_LINES_ALL
WHERE LINE_ID = p_x_line_rec.split_from_line_id;
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
-- Log Verify Payment only if the Tax Value has
-- Increased AND Payment Type Code is Credit Card.
IF p_x_line_rec.tax_value > p_old_line_rec.tax_value AND
OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' THEN
-- Set flag to log Verify Payment Delayed Request
if l_debug_level > 0 then
oe_debug_pub.ADD('Log Verify Payment delayed request in Tax Value');
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
IF( p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND p_x_line_rec.booked_flag ='Y') THEN
-- Log Delayed Request for Verify Payment
if l_debug_level > 0 then
oe_debug_pub.ADD('log verify payment delayed request for change in List price');
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
-- Additional task : Log Verify Payment always when the payment Type
-- code is not CREDIT CARD. For CREDIT CARD, log this request only if
-- the Unit Selling Price has increased.
IF OE_Order_Cache.g_header_rec.payment_type_code = 'CREDIT_CARD' THEN
IF p_x_line_rec.unit_selling_price > p_old_line_rec.unit_selling_price
then
-- Log request here if commitment id is null
IF p_x_line_rec.commitment_id is null THEN
-- if it is not a prepaid order, log Verify Payment delayed request.
-- if it is a prepaid order, check the shipped_quantity to make
-- sure to not collect fund again during repricing at shipment.
IF OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id) = 'N'
OR (OE_PrePayment_UTIL.is_prepaid_order(p_x_line_rec.header_id)
= 'Y' AND p_x_line_rec.booked_flag ='Y'
AND p_x_line_rec.shipped_quantity IS NULL) THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('Log Verify Payment delayed request in Selling Price');
Select 'Y'
INTO l_is_model
FROM oe_order_lines
WHERE line_id = p_x_line_rec.service_reference_line_id
AND item_type_code in ('INCLUDED', 'MODEL', 'CLASS', 'OPTION', 'KIT') ; -- Included KIT Item Type Code for bug 2938790
Select 'Y'
INTO l_is_model
FROM oe_order_lines l
WHERE top_model_line_id = p_x_line_rec.service_reference_line_id
AND item_type_code = 'INCLUDED'
AND exists (select null from mtl_system_items mtl where
mtl.inventory_item_id = l.inventory_item_id and
mtl.serviceable_product_flag = 'Y' and
mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') )
AND ROWNUM = 1;
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) or
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE and
p_x_line_rec.split_from_line_id is NOT NULL)) then
IF p_x_line_rec.service_reference_type_code = 'ORDER' and
p_x_line_rec.service_reference_line_id is NOT NULL and
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE or
p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE) and
l_is_model = 'Y' THEN
OE_Delayed_Requests_Pvt.log_request(
p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
p_entity_id => p_x_line_rec.line_id,
p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
p_requesting_entity_id => p_x_line_rec.line_id,
p_request_type => OE_GLOBALS.G_INSERT_SERVICE,
x_return_status => l_return_status);
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) or
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE and
p_x_line_rec.split_from_line_id is NOT NULL)) then
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('operation : '|| p_x_line_rec.operation);
select distinct 'Y'
into l_serviceable_item
from mtl_system_items mtl
where mtl.inventory_item_id = p_x_line_rec.inventory_item_id
and mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
and mtl.serviceable_product_flag='Y';
select distinct 'Y'
into l_serviced_model
from oe_order_lines
where item_type_code = 'SERVICE'
and service_reference_line_id = p_x_line_rec.top_model_line_id
and service_reference_type_code = 'ORDER';
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
-- Need to Call Shipping Update
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
l_update_shipping := FND_API.G_TRUE;
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('created By update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Creation date update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Customer update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Delver to site update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Line Type update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Payment Term update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Price List update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Project update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Shipping Method update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Source Type update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('task id update: logging request for eval_hold_source');
AND p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT'
AND NVL(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
IF l_debug_level > 0 then
oe_debug_pub.ADD('Top Model update: logging request for eval_hold_source');
l_update_commitment_applied := 'Y';
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
p_x_line_rec.ato_line_id is NULL AND
( p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
(p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
p_x_line_rec.line_id = p_x_line_rec.top_model_line_id))
THEN
p_x_line_rec.explosion_date := null;
END IF; -- End if phase is updated and complete neg is 'Y'
(p_x_line_rec.operation=OE_GLOBALS.G_OPR_UPDATE AND NOT OE_GLOBALS.Equal(p_x_line_rec.contingency_id,p_old_line_rec.contingency_id)) OR
NVL(p_x_line_rec.transaction_phase_code, 'F') = 'N') THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('Item_type_code:'||p_x_line_rec.item_type_code||'-Do not default Contingency Attributes for this line' );
, p_operation => OE_GLOBALS.G_OPR_DELETE);
-- Log the delayed request for Update Shipping if any of the attributes in
-- which Shipping is interested has been changed and the line has been
-- interfaced with Shipping.
IF (p_x_line_rec.shipping_interfaced_flag = 'Y' AND
(l_update_shipping = FND_API.G_TRUE OR l_explosion_date_changed = FND_API.G_TRUE) AND
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND NVL(p_x_line_rec.split_action_code,'X') <> 'SPLIT')) THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('Logging update shipping delayed request for line ID : '|| to_char(p_x_line_rec.line_id) ,1);
p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,
p_request_unique_key1 => p_x_line_rec.operation,
p_param1 => l_update_shipping,
p_param2 => l_explosion_date_changed,
p_param5 => l_ordered_quantity_changed,
x_return_status => l_return_status);
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
BEGIN
Select 'Y'
INTO l_is_model
FROM oe_order_lines
WHERE line_id = p_x_line_rec.service_reference_line_id
AND item_type_code in ('INCLUDED', 'MODEL', 'CLASS', 'OPTION') ;
oe_debug_pub.add('CSH Before log request --G_UPDATE_SERVICE', 1);
p_request_type => OE_GLOBALS.G_UPDATE_SERVICE,
x_return_status => l_return_status);
l_retrobill_operation:='UPDATE';
Elsif p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
and p_x_line_rec.split_by = 'SYSTEM'
and NVL(p_x_line_rec.split_action_code,'X') = 'SPLIT'
and p_x_line_rec.calculate_price_flag = 'Y' Then
p_x_line_rec.calculate_price_flag :='P';
/* SELECT DECODE( TAX_CALCULATION_EVENT_CODE, 'ENTERING', 0,
'BOOKING', 1,
'SHIPPING', 2,
'INVOICING', 3,
-1)
into l_tax_calculation_event_code
from oe_transaction_types_all
where transaction_type_id = OE_Order_Cache.g_header_rec.order_type_id;
select nvl(tax_calculation_flag,'N') into l_tax_commt_flag
from ra_cust_trx_types ract where ract.cust_trx_type_id =
(
select nvl(cust_type.subsequent_trx_type_id,cust_type.cust_trx_type_id)
from ra_cust_trx_types_all cust_type,ra_customer_trx_all cust_trx where
cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
and cust_trx.customer_trx_id = p_x_line_rec.commitment_id
);
IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NVL(p_x_line_rec.split_action_code,'X') = 'SPLIT' ) OR
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
p_x_line_rec.split_from_line_id IS NOT NULL) THEN
if l_debug_level > 0 then
oe_debug_pub.ADD('Line is being Split, Suppress Verify Payment', 1);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
l_commitment_applied_amount
:= OE_Commitment_PVT.get_commitment_applied_amount
(p_header_id => p_x_line_rec.header_id ,
p_line_id => p_x_line_rec.line_id ,
p_commitment_id => p_x_line_rec.commitment_id);
AND l_update_commitment_applied <> 'Y' THEN
if l_debug_level > 0 then
oe_debug_pub.add('Logging delayed request for Commitment.', 2);
AND l_update_commitment_flag = 'Y'
AND OE_Commitment_Pvt.Do_Commitment_Sequencing
-- QUOTING change
AND nvl(p_x_line_rec.transaction_phase_code,'F') = 'F'
THEN
-- lkxu, bug 1786533.
IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NVL(p_x_line_rec.split_action_code,'X') = 'SPLIT' ) THEN
if l_debug_level > 0 then
oe_debug_pub.add('Logging delayed request for updating commitment for line '||p_x_line_rec.line_id, 2);
p_request_type =>OE_GLOBALS.G_UPDATE_COMMITMENT,
x_return_status =>l_return_status);
IF l_update_commitment_applied = 'Y'
AND nvl(p_x_line_rec.transaction_phase_code,'F') = 'F' THEN
if l_debug_level > 0 then
oe_debug_pub.add('Logging delayed request for Commitment Applied Amount '|| p_x_line_rec.commitment_applied_amount, 3);
p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED,
p_param1 => p_x_line_rec.commitment_applied_amount,
p_param2 => p_x_line_rec.header_id,
p_param3 => p_x_line_rec.commitment_id,
x_return_status => l_return_status);
** order right after quantity on the lines was updated to 0.
*/
IF p_x_line_rec.ordered_quantity = 0 AND
p_old_line_rec.ordered_quantity = 0 AND
OE_GLOBALS.g_recursion_mode = 'N' AND -- Bug 3379121
OE_OE_FORM_CANCEL_LINE.g_ord_lvl_can THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('Line Ord Qty already 0, Calling Check_Constraints based on Order Cancel Global');
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
( ( NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_from_org_id
,p_old_line_rec.ship_from_org_id)
AND p_old_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) OR
( NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_to_org_id
,p_old_line_rec.ship_to_org_id)
AND p_old_line_rec.ship_to_org_id <> FND_API.G_MISS_NUM) OR
( NOT OE_GLOBALS.EQUAL(p_x_line_rec.inventory_item_id
,p_old_line_rec.inventory_item_id)
AND p_old_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) OR
( NOT OE_GLOBALS.EQUAL(p_x_line_rec.order_quantity_uom
,p_old_line_rec.order_quantity_uom)
AND p_old_line_rec.order_quantity_uom <> FND_API.G_MISS_CHAR) OR
( NOT OE_GLOBALS.EQUAL(p_x_line_rec.ordered_quantity
,p_old_line_rec.ordered_quantity)
AND p_old_line_rec.ordered_quantity <> FND_API.G_MISS_NUM) OR
( NOT OE_GLOBALS.EQUAL(p_x_line_rec.schedule_ship_date
,p_old_line_rec.schedule_ship_date)
AND p_old_line_rec.schedule_ship_date <> FND_API.G_MISS_DATE) OR
( NOT OE_GLOBALS.EQUAL(p_x_line_rec.schedule_arrival_date
,p_old_line_rec.schedule_arrival_date)
AND p_old_line_rec.schedule_arrival_date <> FND_API.G_MISS_DATE) OR
( NOT OE_GLOBALS.EQUAL(p_x_line_rec.freight_terms_code
,p_old_line_rec.freight_terms_code)
AND p_old_line_rec.freight_terms_code <> FND_API.G_MISS_CHAR)))
THEN
IF OE_GLOBALS.G_FTE_REINVOKE IS NULL THEN
Select Count(*) into l_fte_count
from oe_price_adjustments where
header_id = p_x_line_rec.header_id
and LIST_LINE_TYPE_CODE = 'OM_CALLED_CHOOSE_SHIP_METHOD';
p_x_line_rec.OPERATION = OE_GLOBALS.G_OPR_UPDATE and
p_x_line_rec.return_context IS NULL ) THEN
p_x_line_rec.reference_customer_trx_line_id := NULL;
IF p_x_line_rec.auto_selected_quantity = FND_API.G_MISS_NUM THEN
p_x_line_rec.auto_selected_quantity := p_old_line_rec.auto_selected_quantity;
IF p_x_line_rec.last_updated_by = FND_API.G_MISS_NUM THEN
p_x_line_rec.last_updated_by := p_old_line_rec.last_updated_by;
IF p_x_line_rec.last_update_date = FND_API.G_MISS_DATE THEN
p_x_line_rec.last_update_date := p_old_line_rec.last_update_date;
IF p_x_line_rec.last_update_login = FND_API.G_MISS_NUM THEN
p_x_line_rec.last_update_login := p_old_line_rec.last_update_login;
IF p_x_line_rec.program_update_date = FND_API.G_MISS_DATE THEN
p_x_line_rec.program_update_date := p_old_line_rec.program_update_date;
IF p_x_line_rec.auto_selected_quantity = FND_API.G_MISS_NUM THEN
p_x_line_rec.auto_selected_quantity := NULL;
IF p_x_line_rec.last_updated_by = FND_API.G_MISS_NUM THEN
p_x_line_rec.last_updated_by := NULL;
IF p_x_line_rec.last_update_date = FND_API.G_MISS_DATE THEN
p_x_line_rec.last_update_date := NULL;
IF p_x_line_rec.last_update_login = FND_API.G_MISS_NUM THEN
p_x_line_rec.last_update_login := NULL;
IF p_x_line_rec.program_update_date = FND_API.G_MISS_DATE THEN
p_x_line_rec.program_update_date := NULL;
Procedure Update_Row
-----------------------------------------------------------*/
PROCEDURE Update_Row
( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
)
IS
l_org_id NUMBER;
oe_debug_pub.add('Entering OE_LINE_UTIL.UPDATE_ROW', 1);
SELECT lock_control
INTO l_lock_control
FROM oe_order_lines
WHERE line_id = p_line_rec.line_id;
OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
p_Line_rec =>p_line_rec,
p_line_id => p_line_rec.line_id,
x_index => l_index,
x_return_status => l_return_status);
OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.update_row is: ' || l_return_status);
OE_DEBUG_PUB.ADD('JFC: Line Booked Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.booked_flag);
OE_DEBUG_PUB.ADD('JFC: Line Flow Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.flow_status_code);
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);
OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Update_row');
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);
UPDATE OE_ORDER_LINES
SET ACCOUNTING_RULE_ID = p_line_rec.accounting_rule_id
, ACCOUNTING_RULE_DURATION = p_line_rec.accounting_rule_duration
, CALCULATE_PRICE_FLAG = p_line_rec.calculate_price_flag
, ACTUAL_ARRIVAL_DATE = p_line_rec.actual_arrival_date
, ACTUAL_SHIPMENT_DATE = p_line_rec.actual_shipment_date
, AGREEMENT_ID = p_line_rec.agreement_id
, ARRIVAL_SET_ID = p_line_rec.arrival_set_id
, ATO_LINE_ID = p_line_rec.ato_line_id
, ATTRIBUTE1 = p_line_rec.attribute1
, ATTRIBUTE10 = p_line_rec.attribute10
, ATTRIBUTE11 = p_line_rec.attribute11
, ATTRIBUTE12 = p_line_rec.attribute12
, ATTRIBUTE13 = p_line_rec.attribute13
, ATTRIBUTE14 = p_line_rec.attribute14
, ATTRIBUTE15 = p_line_rec.attribute15
, ATTRIBUTE16 = p_line_rec.attribute16 --For bug 2184255
, ATTRIBUTE17 = p_line_rec.attribute17
, ATTRIBUTE18 = p_line_rec.attribute18
, ATTRIBUTE19 = p_line_rec.attribute19
, ATTRIBUTE2 = p_line_rec.attribute2
, ATTRIBUTE20 = p_line_rec.attribute20
, ATTRIBUTE3 = p_line_rec.attribute3
, ATTRIBUTE4 = p_line_rec.attribute4
, ATTRIBUTE5 = p_line_rec.attribute5
, ATTRIBUTE6 = p_line_rec.attribute6
, ATTRIBUTE7 = p_line_rec.attribute7
, ATTRIBUTE8 = p_line_rec.attribute8
, ATTRIBUTE9 = p_line_rec.attribute9
, AUTO_SELECTED_QUANTITY = p_line_rec.auto_selected_quantity
, AUTHORIZED_TO_SHIP_FLAG = p_line_rec.authorized_to_ship_flag
, BOOKED_FLAG = p_line_rec.booked_flag
, CANCELLED_FLAG = p_line_rec.cancelled_flag
, CANCELLED_QUANTITY = p_line_rec.cancelled_quantity
, COMMITMENT_ID = p_line_rec.commitment_id
, COMPONENT_CODE = p_line_rec.component_code
, COMPONENT_SEQUENCE_ID = p_line_rec.component_sequence_id
, CONFIG_HEADER_ID = p_line_rec.config_header_id
, CONFIG_REV_NBR = p_line_rec.config_rev_nbr
, CONFIG_DISPLAY_SEQUENCE = p_line_rec.config_display_sequence
, CONFIGURATION_ID = p_line_rec.configuration_id
, CONTEXT = p_line_rec.context
, CREATED_BY = p_line_rec.created_by
, CREATION_DATE = p_line_rec.creation_date
, CREDIT_INVOICE_LINE_ID = p_line_rec.credit_invoice_line_id
, CUSTOMER_LINE_NUMBER = p_line_rec.customer_line_number
, CUSTOMER_SHIPMENT_NUMBER = p_line_rec.customer_shipment_number
, CUSTOMER_ITEM_NET_PRICE = p_line_rec.customer_item_net_price
, CUSTOMER_PAYMENT_TERM_ID = p_line_rec.customer_payment_term_id
, CUSTOMER_DOCK_CODE = p_line_rec.customer_dock_code
, CUSTOMER_JOB = p_line_rec.customer_job
, CUSTOMER_PRODUCTION_LINE = p_line_rec.customer_production_line
, CUST_PRODUCTION_SEQ_NUM = p_line_rec.cust_production_seq_num
, CUSTOMER_TRX_LINE_ID = p_line_rec.customer_trx_line_id
, CUST_MODEL_SERIAL_NUMBER = p_line_rec.cust_model_serial_number
, CUST_PO_NUMBER = p_line_rec.cust_po_number
, DELIVERY_LEAD_TIME = p_line_rec.delivery_lead_time
, DELIVER_TO_CONTACT_ID = p_line_rec.deliver_to_contact_id
, DELIVER_TO_ORG_ID = p_line_rec.deliver_to_org_id
, DEMAND_BUCKET_TYPE_CODE = p_line_rec.demand_bucket_type_code
, DEMAND_CLASS_CODE = p_line_rec.demand_class_code
, DEP_PLAN_REQUIRED_FLAG = p_line_rec.dep_plan_required_flag
--, DROP_SHIP_FLAG = p_line_rec.drop_ship_flag
, EARLIEST_ACCEPTABLE_DATE = p_line_rec.earliest_acceptable_date
, END_ITEM_UNIT_NUMBER = p_line_rec.end_item_unit_number
, EXPLOSION_DATE = p_line_rec.explosion_date
, FIRST_ACK_CODE = p_line_rec.first_ack_code
, FIRST_ACK_DATE = p_line_rec.first_ack_date
, FOB_POINT_CODE = p_line_rec.fob_point_code
, FREIGHT_CARRIER_CODE = p_line_rec.freight_carrier_code
, FREIGHT_TERMS_CODE = p_line_rec.freight_terms_code
, FULFILLED_QUANTITY = p_line_rec.fulfilled_quantity
, FULFILLED_FLAG = p_line_rec.fulfilled_flag
, FULFILLMENT_METHOD_CODE = p_line_rec.fulfillment_method_code
, FULFILLMENT_DATE = p_line_rec.fulfillment_date
, GLOBAL_ATTRIBUTE1 = p_line_rec.global_attribute1
, GLOBAL_ATTRIBUTE10 = p_line_rec.global_attribute10
, GLOBAL_ATTRIBUTE11 = p_line_rec.global_attribute11
, GLOBAL_ATTRIBUTE12 = p_line_rec.global_attribute12
, GLOBAL_ATTRIBUTE13 = p_line_rec.global_attribute13
, GLOBAL_ATTRIBUTE14 = p_line_rec.global_attribute14
, GLOBAL_ATTRIBUTE15 = p_line_rec.global_attribute15
, GLOBAL_ATTRIBUTE16 = p_line_rec.global_attribute16
, GLOBAL_ATTRIBUTE17 = p_line_rec.global_attribute17
, GLOBAL_ATTRIBUTE18 = p_line_rec.global_attribute18
, GLOBAL_ATTRIBUTE19 = p_line_rec.global_attribute19
, GLOBAL_ATTRIBUTE2 = p_line_rec.global_attribute2
, GLOBAL_ATTRIBUTE20 = p_line_rec.global_attribute20
, GLOBAL_ATTRIBUTE3 = p_line_rec.global_attribute3
, GLOBAL_ATTRIBUTE4 = p_line_rec.global_attribute4
, GLOBAL_ATTRIBUTE5 = p_line_rec.global_attribute5
, GLOBAL_ATTRIBUTE6 = p_line_rec.global_attribute6
, GLOBAL_ATTRIBUTE7 = p_line_rec.global_attribute7
, GLOBAL_ATTRIBUTE8 = p_line_rec.global_attribute8
, GLOBAL_ATTRIBUTE9 = p_line_rec.global_attribute9
, GLOBAL_ATTRIBUTE_CATEGORY = p_line_rec.global_attribute_category
, HEADER_ID = p_line_rec.header_id
, INDUSTRY_ATTRIBUTE1 = p_line_rec.industry_attribute1
, INDUSTRY_ATTRIBUTE10 = p_line_rec.industry_attribute10
, INDUSTRY_ATTRIBUTE11 = p_line_rec.industry_attribute11
, INDUSTRY_ATTRIBUTE12 = p_line_rec.industry_attribute12
, INDUSTRY_ATTRIBUTE13 = p_line_rec.industry_attribute13
, INDUSTRY_ATTRIBUTE14 = p_line_rec.industry_attribute14
, INDUSTRY_ATTRIBUTE15 = p_line_rec.industry_attribute15
, INDUSTRY_ATTRIBUTE16 = p_line_rec.industry_attribute16
, INDUSTRY_ATTRIBUTE17 = p_line_rec.industry_attribute17
, INDUSTRY_ATTRIBUTE18 = p_line_rec.industry_attribute18
, INDUSTRY_ATTRIBUTE19 = p_line_rec.industry_attribute19
, INDUSTRY_ATTRIBUTE20 = p_line_rec.industry_attribute20
, INDUSTRY_ATTRIBUTE21 = p_line_rec.industry_attribute21
, INDUSTRY_ATTRIBUTE22 = p_line_rec.industry_attribute22
, INDUSTRY_ATTRIBUTE23 = p_line_rec.industry_attribute23
, INDUSTRY_ATTRIBUTE24 = p_line_rec.industry_attribute24
, INDUSTRY_ATTRIBUTE25 = p_line_rec.industry_attribute25
, INDUSTRY_ATTRIBUTE26 = p_line_rec.industry_attribute26
, INDUSTRY_ATTRIBUTE27 = p_line_rec.industry_attribute27
, INDUSTRY_ATTRIBUTE28 = p_line_rec.industry_attribute28
, INDUSTRY_ATTRIBUTE29 = p_line_rec.industry_attribute29
, INDUSTRY_ATTRIBUTE30 = p_line_rec.industry_attribute30
, INDUSTRY_ATTRIBUTE2 = p_line_rec.industry_attribute2
, INDUSTRY_ATTRIBUTE3 = p_line_rec.industry_attribute3
, INDUSTRY_ATTRIBUTE4 = p_line_rec.industry_attribute4
, INDUSTRY_ATTRIBUTE5 = p_line_rec.industry_attribute5
, INDUSTRY_ATTRIBUTE6 = p_line_rec.industry_attribute6
, INDUSTRY_ATTRIBUTE7 = p_line_rec.industry_attribute7
, INDUSTRY_ATTRIBUTE8 = p_line_rec.industry_attribute8
, INDUSTRY_ATTRIBUTE9 = p_line_rec.industry_attribute9
, INDUSTRY_CONTEXT = p_line_rec.industry_context
, INTMED_SHIP_TO_CONTACT_ID = p_line_rec.intermed_ship_to_contact_id
, INTMED_SHIP_TO_ORG_ID = p_line_rec.intermed_ship_to_org_id
, INVENTORY_ITEM_ID = p_line_rec.inventory_item_id
, INVOICE_INTERFACE_STATUS_CODE = p_line_rec.invoice_interface_status_code
, INVOICE_TO_CONTACT_ID = p_line_rec.invoice_to_contact_id
, INVOICE_TO_ORG_ID = p_line_rec.invoice_to_org_id
, INVOICED_QUANTITY = p_line_rec.invoiced_quantity
, INVOICING_RULE_ID = p_line_rec.invoicing_rule_id
, ORDERED_ITEM_ID = p_line_rec.ordered_item_id
, ITEM_IDENTIFIER_TYPE = p_line_rec.item_identifier_type
, ORDERED_ITEM = p_line_rec.ordered_item
, ITEM_REVISION = p_line_rec.item_revision
, ITEM_TYPE_CODE = p_line_rec.item_type_code
, LAST_ACK_CODE = p_line_rec.last_ack_code
, LAST_ACK_DATE = p_line_rec.last_ack_date --bug6448638
, LAST_UPDATED_BY = p_line_rec.last_updated_by
, LATEST_ACCEPTABLE_DATE = p_line_rec.latest_acceptable_date
, LAST_UPDATE_DATE = p_line_rec.last_update_date
, LAST_UPDATE_LOGIN = p_line_rec.last_update_login
, LINE_CATEGORY_CODE = p_line_rec.line_category_code
, LINE_NUMBER = p_line_rec.line_number
, LINE_TYPE_ID = p_line_rec.line_type_id
, LINK_TO_LINE_ID = p_line_rec.link_to_line_id
, MODEL_GROUP_NUMBER = p_line_rec.model_group_number
-- , MFG_COMPONENT_SEQUENCE_ID = p_line_rec.mfg_component_sequence_id
, MFG_LEAD_TIME = p_line_rec.mfg_lead_time
, OPEN_FLAG = p_line_rec.open_flag
, OPTION_FLAG = p_line_rec.option_flag
, OPTION_NUMBER = p_line_rec.option_number
, ORDERED_QUANTITY = p_line_rec.ordered_quantity
, ORDERED_QUANTITY2 = p_line_rec.ordered_quantity2
, ORDER_QUANTITY_UOM = p_line_rec.order_quantity_uom
, ORDERED_QUANTITY_UOM2 = p_line_rec.ordered_quantity_uom2
--We should not allow to update org_id(operting unit)
-- , ORG_ID = p_line_rec.org_id
, ORDER_SOURCE_ID = p_line_rec.order_source_id
, ORIG_SYS_DOCUMENT_REF = p_line_rec.orig_sys_document_ref
, ORIG_SYS_LINE_REF = p_line_rec.orig_sys_line_ref
, ORIG_SYS_SHIPMENT_REF = p_line_rec.orig_sys_shipment_ref
, CHANGE_SEQUENCE = p_line_rec.change_sequence
, OVER_SHIP_REASON_CODE = p_line_rec.over_ship_reason_code
, OVER_SHIP_RESOLVED_FLAG = p_line_rec.over_ship_resolved_flag
, PAYMENT_TERM_ID = p_line_rec.payment_term_id
, PLANNING_PRIORITY = p_line_rec.planning_priority
, PREFERRED_GRADE = p_line_rec.preferred_grade
, PRICE_LIST_ID = p_line_rec.price_list_id
, PRICE_REQUEST_CODE = p_line_rec.price_request_code -- PROMOTIONS SEP/01
, PRICING_ATTRIBUTE1 = p_line_rec.pricing_attribute1
, PRICING_ATTRIBUTE10 = p_line_rec.pricing_attribute10
, PRICING_ATTRIBUTE2 = p_line_rec.pricing_attribute2
, PRICING_ATTRIBUTE3 = p_line_rec.pricing_attribute3
, PRICING_ATTRIBUTE4 = p_line_rec.pricing_attribute4
, PRICING_ATTRIBUTE5 = p_line_rec.pricing_attribute5
, PRICING_ATTRIBUTE6 = p_line_rec.pricing_attribute6
, PRICING_ATTRIBUTE7 = p_line_rec.pricing_attribute7
, PRICING_ATTRIBUTE8 = p_line_rec.pricing_attribute8
, PRICING_ATTRIBUTE9 = p_line_rec.pricing_attribute9
, PRICING_CONTEXT = p_line_rec.pricing_context
, PRICING_DATE = p_line_rec.pricing_date
, PRICING_QUANTITY = p_line_rec.pricing_quantity
, PRICING_QUANTITY_UOM = p_line_rec.pricing_quantity_uom
, PROGRAM_APPLICATION_ID = p_line_rec.program_application_id
, PROGRAM_ID = p_line_rec.program_id
, PROGRAM_UPDATE_DATE = p_line_rec.program_update_date
, PROJECT_ID = p_line_rec.project_id
, PROMISE_DATE = p_line_rec.promise_date
, RE_SOURCE_FLAG = p_line_rec.re_source_flag
, REFERENCE_CUSTOMER_TRX_LINE_ID = p_line_rec.reference_customer_trx_line_id
, REFERENCE_HEADER_ID = p_line_rec.reference_header_id
, REFERENCE_LINE_ID = p_line_rec.reference_line_id
, REFERENCE_TYPE = p_line_rec.reference_type
, REQUEST_DATE = p_line_rec.request_date
, REQUEST_ID = p_line_rec.request_id
, RETURN_ATTRIBUTE1 = p_line_rec.return_attribute1
, RETURN_ATTRIBUTE10 = p_line_rec.return_attribute10
, RETURN_ATTRIBUTE11 = p_line_rec.return_attribute11
, RETURN_ATTRIBUTE12 = p_line_rec.return_attribute12
, RETURN_ATTRIBUTE13 = p_line_rec.return_attribute13
, RETURN_ATTRIBUTE14 = p_line_rec.return_attribute14
, RETURN_ATTRIBUTE15 = p_line_rec.return_attribute15
, RETURN_ATTRIBUTE2 = p_line_rec.return_attribute2
, RETURN_ATTRIBUTE3 = p_line_rec.return_attribute3
, RETURN_ATTRIBUTE4 = p_line_rec.return_attribute4
, RETURN_ATTRIBUTE5 = p_line_rec.return_attribute5
, RETURN_ATTRIBUTE6 = p_line_rec.return_attribute6
, RETURN_ATTRIBUTE7 = p_line_rec.return_attribute7
, RETURN_ATTRIBUTE8 = p_line_rec.return_attribute8
, RETURN_ATTRIBUTE9 = p_line_rec.return_attribute9
, RETURN_CONTEXT = p_line_rec.return_context
, RETURN_REASON_CODE = p_line_rec.return_reason_code
, RLA_SCHEDULE_TYPE_CODE = p_line_rec.rla_schedule_type_code
, SALESREP_ID = p_line_rec.salesrep_id
, SCHEDULE_ARRIVAL_DATE = p_line_rec.schedule_arrival_date
, SCHEDULE_SHIP_DATE = p_line_rec.schedule_ship_date
, SCHEDULE_STATUS_CODE = p_line_rec.schedule_status_code
, SHIPMENT_NUMBER = p_line_rec.shipment_number
, SHIPMENT_PRIORITY_CODE = p_line_rec.shipment_priority_code
, SHIPPED_QUANTITY = p_line_rec.shipped_quantity
, SHIPPED_QUANTITY2 = p_line_rec.shipped_quantity2 -- OPM B1661023 04/02/01
, SHIPPING_METHOD_CODE = p_line_rec.shipping_method_code
, SHIPPING_QUANTITY = p_line_rec.shipping_quantity
, SHIPPING_QUANTITY2 = p_line_rec.shipping_quantity2 -- OPM B1661023 04/02/01
, SHIPPING_QUANTITY_UOM = p_line_rec.shipping_quantity_uom
, SHIP_FROM_ORG_ID = p_line_rec.ship_from_org_id
, SUBINVENTORY = p_line_rec.subinventory
, SHIP_TOLERANCE_ABOVE = p_line_rec.ship_tolerance_above
, SHIP_TOLERANCE_BELOW = p_line_rec.ship_tolerance_below
, SHIPPABLE_FLAG = p_line_rec.shippable_flag
, SHIPPING_INTERFACED_FLAG = p_line_rec.shipping_interfaced_flag
, SHIP_TO_CONTACT_ID = p_line_rec.ship_to_contact_id
, SHIP_TO_ORG_ID = p_line_rec.ship_to_org_id
, SHIP_MODEL_COMPLETE_FLAG = p_line_rec.ship_model_complete_flag
, SHIP_SET_ID = p_line_rec.ship_set_id
, SOLD_TO_ORG_ID = p_line_rec.sold_to_org_id
, SOLD_FROM_ORG_ID = p_line_rec.sold_from_org_id
, SORT_ORDER = p_line_rec.sort_order
, SOURCE_DOCUMENT_ID = p_line_rec.source_document_id
, SOURCE_DOCUMENT_LINE_ID = p_line_rec.source_document_line_id
, SOURCE_DOCUMENT_TYPE_ID = p_line_rec.source_document_type_id
, SOURCE_TYPE_CODE = p_line_rec.source_type_code
, SPLIT_FROM_LINE_ID = p_line_rec.split_from_line_id
, LINE_SET_ID = p_line_rec.line_set_id
, SPLIT_BY = p_line_rec.split_by
, MODEL_REMNANT_FLAG = p_line_rec.model_remnant_flag
, TASK_ID = p_line_rec.task_id
, TAX_CODE = p_line_rec.tax_code
, TAX_DATE = p_line_rec.tax_date
, TAX_EXEMPT_FLAG = p_line_rec.tax_exempt_flag
, TAX_EXEMPT_NUMBER = p_line_rec.tax_exempt_number
, TAX_EXEMPT_REASON_CODE = p_line_rec.tax_exempt_reason_code
, TAX_POINT_CODE = p_line_rec.tax_point_code
, TAX_RATE = p_line_rec.tax_rate
, TAX_VALUE = p_line_rec.tax_value
, TOP_MODEL_LINE_ID = p_line_rec.top_model_line_id
, UNIT_LIST_PRICE = p_line_rec.unit_list_price
, UNIT_LIST_PRICE_PER_PQTY = p_line_rec.unit_list_price_per_pqty
, UNIT_SELLING_PRICE = p_line_rec.unit_selling_price
, UNIT_SELLING_PRICE_PER_PQTY = p_line_rec.unit_selling_price_per_pqty
, VISIBLE_DEMAND_FLAG = p_line_rec.visible_demand_flag
, VEH_CUS_ITEM_CUM_KEY_ID = p_line_rec.veh_cus_item_cum_key_id
, SHIPPING_INSTRUCTIONS = p_line_rec.shipping_instructions
, PACKING_INSTRUCTIONS = p_line_rec.packing_instructions
, SERVICE_TXN_REASON_CODE = p_line_rec.service_txn_reason_code
, SERVICE_TXN_COMMENTS = p_line_rec.service_txn_comments
, SERVICE_DURATION = p_line_rec.service_duration
, SERVICE_PERIOD = p_line_rec.service_period
, SERVICE_START_DATE = p_line_rec.service_start_date
, SERVICE_END_DATE = p_line_rec.service_end_date
, SERVICE_COTERMINATE_FLAG = p_line_rec.service_coterminate_flag
, UNIT_LIST_PERCENT = p_line_rec.unit_list_percent
, UNIT_SELLING_PERCENT = p_line_rec.unit_selling_percent
, UNIT_PERCENT_BASE_PRICE = p_line_rec.unit_percent_base_price
, SERVICE_NUMBER = p_line_rec.service_number
, SERVICE_REFERENCE_TYPE_CODE = p_line_rec.service_reference_type_code
, SERVICE_REFERENCE_LINE_ID = p_line_rec.service_reference_line_id
, SERVICE_REFERENCE_SYSTEM_ID = p_line_rec.service_reference_system_id
, TP_CONTEXT = p_line_rec.tp_context
, TP_ATTRIBUTE1 = p_line_rec.tp_attribute1
, TP_ATTRIBUTE2 = p_line_rec.tp_attribute2
, TP_ATTRIBUTE3 = p_line_rec.tp_attribute3
, TP_ATTRIBUTE4 = p_line_rec.tp_attribute4
, TP_ATTRIBUTE5 = p_line_rec.tp_attribute5
, TP_ATTRIBUTE6 = p_line_rec.tp_attribute6
, TP_ATTRIBUTE7 = p_line_rec.tp_attribute7
, TP_ATTRIBUTE8 = p_line_rec.tp_attribute8
, TP_ATTRIBUTE9 = p_line_rec.tp_attribute9
, TP_ATTRIBUTE10 = p_line_rec.tp_attribute10
, TP_ATTRIBUTE11 = p_line_rec.tp_attribute11
, TP_ATTRIBUTE12 = p_line_rec.tp_attribute12
, TP_ATTRIBUTE13 = p_line_rec.tp_attribute13
, TP_ATTRIBUTE14 = p_line_rec.tp_attribute14
, TP_ATTRIBUTE15 = p_line_rec.tp_attribute15
, FLOW_STATUS_CODE = p_line_rec.flow_status_code
, MARKETING_SOURCE_CODE_ID = p_line_rec.marketing_source_code_id
, ORIGINAL_INVENTORY_ITEM_ID = p_line_rec.Original_Inventory_Item_Id
, ORIGINAL_ITEM_IDENTIFIER_TYPE = p_line_rec.Original_item_identifier_Type
, ORIGINAL_ORDERED_ITEM_ID = p_line_rec.Original_ordered_item_id
, ORIGINAL_ORDERED_ITEM = p_line_rec.Original_ordered_item
, ITEM_RELATIONSHIP_TYPE = p_line_rec.item_relationship_type
, ITEM_SUBSTITUTION_TYPE_CODE = p_line_rec.Item_substitution_type_code
, LATE_DEMAND_PENALTY_FACTOR = p_line_rec.Late_Demand_Penalty_Factor
, OVERRIDE_ATP_DATE_CODE = p_line_rec.Override_atp_date_code
, FIRM_DEMAND_FLAG = p_line_rec.firm_demand_flag
, EARLIEST_SHIP_DATE = p_line_rec.earliest_ship_date
, USER_ITEM_DESCRIPTION = p_line_rec.User_Item_Description
, BLANKET_NUMBER = p_line_rec.Blanket_Number
, BLANKET_LINE_NUMBER = p_line_rec.Blanket_Line_Number
, BLANKET_VERSION_NUMBER = p_line_rec.Blanket_Version_Number
--MRG B
, UNIT_COST = p_line_rec.unit_cost
--MRG E
, LOCK_CONTROL = l_lock_control
-- Changes for quoting
, transaction_phase_code = p_line_rec.transaction_phase_code
, source_document_version_number = p_line_rec.source_document_version_number
-- end changes for quoting
, MINISITE_ID = p_line_rec.Minisite_Id
, IB_OWNER = p_line_rec.Ib_owner
, IB_INSTALLED_AT_LOCATION = p_line_rec.Ib_INSTALLED_AT_LOCATION
, IB_CURRENT_LOCATION = p_line_rec.Ib_current_location
, END_CUSTOMER_ID = p_line_rec.End_Customer_Id
, END_CUSTOMER_CONTACT_ID = p_line_rec.End_Customer_CONTACT_Id
, END_CUSTOMER_SITE_USE_ID = p_line_rec.End_Customer_site_use_Id
/* , SUPPLIER_SIGNATURE = p_line_rec.SUPPLIER_SIGNATURE
, SUPPLIER_SIGNATURE_DATE = p_line_rec.SUPPLIER_SIGNATURE_DATE
, CUSTOMER_SIGNATURE = p_line_rec.CUSTOMER_SIGNATURE
, CUSTOMER_SIGNATURE_DATE = p_line_rec.CUSTOMER_SIGNATURE_DATE
*/
--retro{
, RETROBILL_REQUEST_ID = p_line_rec.retrobill_request_id
--retro
-- Override List Price
, ORIGINAL_LIST_PRICE = p_line_rec.original_list_price
--key Transaction Dates
, ORDER_FIRMED_DATE = p_line_rec.order_firmed_date
, ACTUAL_FULFILLMENT_DATE = p_line_rec.actual_fulfillment_date
--recurring charges
, CHARGE_PERIODICITY_CODE = p_line_rec.charge_periodicity_code
-- INVCONV
, CANCELLED_QUANTITY2 = p_line_rec.cancelled_quantity2
, SHIPPING_QUANTITY_UOM2 = p_line_rec.shipping_quantity_uom2
, FULFILLED_QUANTITY2 = p_line_rec.fulfilled_quantity2
--Customer Acceptance
, CONTINGENCY_ID = p_line_rec.CONTINGENCY_ID
, REVREC_EVENT_CODE = p_line_rec.REVREC_EVENT_CODE
, REVREC_EXPIRATION_DAYS = p_line_rec.REVREC_EXPIRATION_DAYS
, ACCEPTED_QUANTITY = p_line_rec.ACCEPTED_QUANTITY
, REVREC_COMMENTS = p_line_rec.REVREC_COMMENTS
, REVREC_SIGNATURE = p_line_rec.REVREC_SIGNATURE
, REVREC_SIGNATURE_DATE = p_line_rec.REVREC_SIGNATURE_DATE
, ACCEPTED_BY = p_line_rec.ACCEPTED_BY
, REVREC_REFERENCE_DOCUMENT = p_line_rec.REVREC_REFERENCE_DOCUMENT
, REVREC_IMPLICIT_FLAG = p_line_rec.REVREC_IMPLICIT_FLAG
WHERE LINE_ID = p_line_rec.line_id
AND HEADER_ID = p_line_rec.header_id ;
oe_debug_pub.add('Exiting OE_LINE_UTIL.UPDATE_ROW', 1);
, 'Update_Row'
);
END Update_Row;
Procedure Insert_Row
-----------------------------------------------------------*/
PROCEDURE Insert_Row
( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
)
IS
l_org_id NUMBER ;
oe_debug_pub.add('Entering OE_LINE_UTIL.INSERT_ROW', 1);
INSERT INTO OE_ORDER_LINES
( ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, ACTUAL_ARRIVAL_DATE
, ACTUAL_SHIPMENT_DATE
, AGREEMENT_ID
, ARRIVAL_SET_ID
, ATO_LINE_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16 --For bug 2184255
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE2
, ATTRIBUTE20
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTO_SELECTED_QUANTITY
, AUTHORIZED_TO_SHIP_FLAG
, BOOKED_FLAG
, CANCELLED_FLAG
, CANCELLED_QUANTITY
, COMPONENT_CODE
, COMPONENT_NUMBER
, COMPONENT_SEQUENCE_ID
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, CONFIG_DISPLAY_SEQUENCE
, CONFIGURATION_ID
, CONTEXT
, CREATED_BY
, CREATION_DATE
, CREDIT_INVOICE_LINE_ID
, CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_NET_PRICE
, CUSTOMER_PAYMENT_TERM_ID
, CUSTOMER_DOCK_CODE
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUST_PRODUCTION_SEQ_NUM
, CUSTOMER_TRX_LINE_ID
, CUST_MODEL_SERIAL_NUMBER
, CUST_PO_NUMBER
, DELIVERY_LEAD_TIME
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG_ID
, DEMAND_BUCKET_TYPE_CODE
, DEMAND_CLASS_CODE
, DEP_PLAN_REQUIRED_FLAG
--, DROP_SHIP_FLAG
, EARLIEST_ACCEPTABLE_DATE
, END_ITEM_UNIT_NUMBER
, EXPLOSION_DATE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, FULFILLED_QUANTITY
, FULFILLED_FLAG
, FULFILLMENT_METHOD_CODE
, FULFILLMENT_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, HEADER_ID
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_CONTEXT
, INTMED_SHIP_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID
, INVENTORY_ITEM_ID
, INVOICE_INTERFACE_STATUS_CODE
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG_ID
, INVOICED_QUANTITY
, INVOICING_RULE_ID
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, ORDERED_ITEM
, ITEM_REVISION
, ITEM_TYPE_CODE
, LAST_ACK_CODE
, LAST_ACK_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LATEST_ACCEPTABLE_DATE
, LINE_CATEGORY_CODE
, LINE_ID
, LINE_NUMBER
, LINE_TYPE_ID
, LINK_TO_LINE_ID
, MODEL_GROUP_NUMBER
-- , MFG_COMPONENT_SEQUENCE_ID
, MFG_LEAD_TIME
, OPEN_FLAG
, OPTION_FLAG
, OPTION_NUMBER
, ORDERED_QUANTITY
, ORDERED_QUANTITY2 --OPM Added 02/JUN/00
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY_UOM2 --OPM Added 02/JUN/00
, ORG_ID -- MOAC change
, ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, CHANGE_SEQUENCE
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, PAYMENT_TERM_ID
, PLANNING_PRIORITY
, PREFERRED_GRADE --OPM Added 02/JUN/00
, PRICE_LIST_ID
, PRICE_REQUEST_CODE --PROMOTIONS SEP/01
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_CONTEXT
, PRICING_DATE
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, PROMISE_DATE
, RE_SOURCE_FLAG
, REFERENCE_CUSTOMER_TRX_LINE_ID
, REFERENCE_HEADER_ID
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, REQUEST_DATE
, REQUEST_ID
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_CONTEXT
, RETURN_REASON_CODE
, RLA_SCHEDULE_TYPE_CODE
, SALESREP_ID
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SCHEDULE_STATUS_CODE
, SHIPMENT_NUMBER
, SHIPMENT_PRIORITY_CODE
, SHIPPED_QUANTITY
, SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, SHIPPING_QUANTITY_UOM
, SHIP_FROM_ORG_ID
, SUBINVENTORY
, SHIP_SET_ID
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIPPABLE_FLAG
, SHIPPING_INTERFACED_FLAG
, SHIP_TO_CONTACT_ID
, SHIP_TO_ORG_ID
, SHIP_MODEL_COMPLETE_FLAG
, SOLD_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SORT_ORDER
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID
, SOURCE_DOCUMENT_TYPE_ID
, SOURCE_TYPE_CODE
, SPLIT_FROM_LINE_ID
, LINE_SET_ID
, SPLIT_BY
, model_remnant_flag
, TASK_ID
, TAX_CODE
, TAX_DATE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_POINT_CODE
, TAX_RATE
, TAX_VALUE
, TOP_MODEL_LINE_ID
, UNIT_LIST_PRICE
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE
, UNIT_SELLING_PRICE_PER_PQTY
, VISIBLE_DEMAND_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_PERIOD
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, FLOW_STATUS_CODE
, MARKETING_SOURCE_CODE_ID
, CALCULATE_PRICE_FLAG
, COMMITMENT_ID
, UPGRADED_FLAG
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ITEM_RELATIONSHIP_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE
, LATE_DEMAND_PENALTY_FACTOR
, OVERRIDE_ATP_DATE_CODE
, FIRM_DEMAND_FLAG
, EARLIEST_SHIP_DATE
, USER_ITEM_DESCRIPTION
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
, BLANKET_VERSION_NUMBER
--MRG B
, UNIT_COST
--MRG E
, LOCK_CONTROL
-- Changes for quoting
, transaction_phase_code
, source_document_version_number
-- end changes for quoting
, Minisite_ID
, Ib_Owner
, Ib_installed_at_location
, Ib_current_location
, End_customer_ID
, End_customer_contact_ID
, End_customer_site_use_ID
/* , Supplier_signature
, Supplier_signature_date
, Customer_signature
, Customer_signature_date */
--retro{
, RETROBILL_REQUEST_ID
--retro}
, ORIGINAL_LIST_PRICE -- Override List Price
-- Key Transaction Dates
, order_firmed_date
, actual_fulfillment_date
--recurring charges
, charge_periodicity_code
-- INVCONV
, CANCELLED_QUANTITY2
, SHIPPING_QUANTITY_UOM2
, FULFILLED_QUANTITY2
--Customer Acceptance
, CONTINGENCY_ID
, REVREC_EVENT_CODE
, REVREC_EXPIRATION_DAYS
, ACCEPTED_QUANTITY
, REVREC_COMMENTS
, REVREC_SIGNATURE
, REVREC_SIGNATURE_DATE
, ACCEPTED_BY
, REVREC_REFERENCE_DOCUMENT
, REVREC_IMPLICIT_FLAG
)
VALUES
( p_line_rec.accounting_rule_id
, p_line_rec.accounting_rule_duration
, p_line_rec.actual_arrival_date
, p_line_rec.actual_shipment_date
, p_line_rec.agreement_id
, p_line_rec.arrival_set_id
, p_line_rec.ato_line_id
, p_line_rec.attribute1
, p_line_rec.attribute10
, p_line_rec.attribute11
, p_line_rec.attribute12
, p_line_rec.attribute13
, p_line_rec.attribute14
, p_line_rec.attribute15
, p_line_rec.attribute16 --For bug 2184255
, p_line_rec.attribute17
, p_line_rec.attribute18
, p_line_rec.attribute19
, p_line_rec.attribute2
, p_line_rec.attribute20
, p_line_rec.attribute3
, p_line_rec.attribute4
, p_line_rec.attribute5
, p_line_rec.attribute6
, p_line_rec.attribute7
, p_line_rec.attribute8
, p_line_rec.attribute9
, p_line_rec.auto_selected_quantity
, p_line_rec.authorized_to_ship_flag
, p_line_rec.booked_flag
, p_line_rec.cancelled_flag
, p_line_rec.cancelled_quantity
, p_line_rec.component_code
, p_line_rec.component_number
, p_line_rec.component_sequence_id
, p_line_rec.config_header_id
, p_line_rec.config_rev_nbr
, p_line_rec.config_display_sequence
, p_line_rec.configuration_id
, p_line_rec.context
, p_line_rec.created_by
, p_line_rec.creation_date
, p_line_rec.credit_invoice_line_id
, p_line_rec.customer_line_number
, p_line_rec.customer_shipment_number
, p_line_rec.customer_item_net_price
, p_line_rec.customer_payment_term_id
, p_line_rec.customer_dock_code
, p_line_rec.customer_job
, p_line_rec.customer_production_line
, p_line_rec.cust_production_seq_num
, p_line_rec.customer_trx_line_id
, p_line_rec.cust_model_serial_number
, p_line_rec.cust_po_number
, p_line_rec.delivery_lead_time
, p_line_rec.deliver_to_contact_id
, p_line_rec.deliver_to_org_id
, p_line_rec.demand_bucket_type_code
, p_line_rec.demand_class_code
, p_line_rec.dep_plan_required_flag
--, p_line_rec.drop_ship_flag
, p_line_rec.earliest_acceptable_date
, p_line_rec.end_item_unit_number
, p_line_rec.explosion_date
, p_line_rec.first_ack_code
, p_line_rec.first_ack_date
, p_line_rec.fob_point_code
, p_line_rec.freight_carrier_code
, p_line_rec.freight_terms_code
, p_line_rec.fulfilled_quantity
, p_line_rec.fulfilled_flag
, p_line_rec.fulfillment_method_code
, p_line_rec.fulfillment_date
, p_line_rec.global_attribute1
, p_line_rec.global_attribute10
, p_line_rec.global_attribute11
, p_line_rec.global_attribute12
, p_line_rec.global_attribute13
, p_line_rec.global_attribute14
, p_line_rec.global_attribute15
, p_line_rec.global_attribute16
, p_line_rec.global_attribute17
, p_line_rec.global_attribute18
, p_line_rec.global_attribute19
, p_line_rec.global_attribute2
, p_line_rec.global_attribute20
, p_line_rec.global_attribute3
, p_line_rec.global_attribute4
, p_line_rec.global_attribute5
, p_line_rec.global_attribute6
, p_line_rec.global_attribute7
, p_line_rec.global_attribute8
, p_line_rec.global_attribute9
, p_line_rec.global_attribute_category
, p_line_rec.header_id
, p_line_rec.industry_attribute1
, p_line_rec.industry_attribute10
, p_line_rec.industry_attribute11
, p_line_rec.industry_attribute12
, p_line_rec.industry_attribute13
, p_line_rec.industry_attribute14
, p_line_rec.industry_attribute15
, p_line_rec.industry_attribute16
, p_line_rec.industry_attribute17
, p_line_rec.industry_attribute18
, p_line_rec.industry_attribute19
, p_line_rec.industry_attribute20
, p_line_rec.industry_attribute21
, p_line_rec.industry_attribute22
, p_line_rec.industry_attribute23
, p_line_rec.industry_attribute24
, p_line_rec.industry_attribute25
, p_line_rec.industry_attribute26
, p_line_rec.industry_attribute27
, p_line_rec.industry_attribute28
, p_line_rec.industry_attribute29
, p_line_rec.industry_attribute30
, p_line_rec.industry_attribute2
, p_line_rec.industry_attribute3
, p_line_rec.industry_attribute4
, p_line_rec.industry_attribute5
, p_line_rec.industry_attribute6
, p_line_rec.industry_attribute7
, p_line_rec.industry_attribute8
, p_line_rec.industry_attribute9
, p_line_rec.industry_context
, p_line_rec.intermed_ship_to_contact_id
, p_line_rec.intermed_ship_to_org_id
, p_line_rec.inventory_item_id
, p_line_rec.invoice_interface_status_code
, p_line_rec.invoice_to_contact_id
, p_line_rec.invoice_to_org_id
, p_line_rec.invoiced_quantity
, p_line_rec.invoicing_rule_id
, p_line_rec.ordered_item_id
, p_line_rec.item_identifier_type
, p_line_rec.ordered_item
, p_line_rec.item_revision
, p_line_rec.item_type_code
, p_line_rec.last_ack_code
, p_line_rec.last_ack_date
, p_line_rec.last_updated_by
, p_line_rec.last_update_date
, p_line_rec.last_update_login
, p_line_rec.latest_acceptable_date
, p_line_rec.line_category_code
, p_line_rec.line_id
, p_line_rec.line_number
, p_line_rec.line_type_id
, p_line_rec.link_to_line_id
, p_line_rec.model_group_number
--, p_line_rec.mfg_component_sequence_id
, p_line_rec.mfg_lead_time
, p_line_rec.open_flag
, p_line_rec.option_flag
, p_line_rec.option_number
, p_line_rec.ordered_quantity
, p_line_rec.ordered_quantity2 --OPM 02/JUN/00
, p_line_rec.order_quantity_uom
, p_line_rec.ordered_quantity_uom2 --OPM 02/JUN/00
, l_org_id --MOAC change
, p_line_rec.order_source_id
, p_line_rec.orig_sys_document_ref
, p_line_rec.orig_sys_line_ref
, p_line_rec.orig_sys_shipment_ref
, p_line_rec.change_sequence
, p_line_rec.over_ship_reason_code
, p_line_rec.over_ship_resolved_flag
, p_line_rec.payment_term_id
, p_line_rec.planning_priority
, p_line_rec.preferred_grade --OPM 02/JUN/00
, p_line_rec.price_list_id
, l_price_request_code --PROMOTIONS SEP/01 --bug 4446805
, p_line_rec.pricing_attribute1
, p_line_rec.pricing_attribute10
, p_line_rec.pricing_attribute2
, p_line_rec.pricing_attribute3
, p_line_rec.pricing_attribute4
, p_line_rec.pricing_attribute5
, p_line_rec.pricing_attribute6
, p_line_rec.pricing_attribute7
, p_line_rec.pricing_attribute8
, p_line_rec.pricing_attribute9
, p_line_rec.pricing_context
, p_line_rec.pricing_date
, p_line_rec.pricing_quantity
, p_line_rec.pricing_quantity_uom
, p_line_rec.program_application_id
, p_line_rec.program_id
, p_line_rec.program_update_date
, p_line_rec.project_id
, p_line_rec.promise_date
, p_line_rec.re_source_flag
, p_line_rec.reference_customer_trx_line_id
, p_line_rec.reference_header_id
, p_line_rec.reference_line_id
, p_line_rec.reference_type
, p_line_rec.request_date
, p_line_rec.request_id
, p_line_rec.return_attribute1
, p_line_rec.return_attribute10
, p_line_rec.return_attribute11
, p_line_rec.return_attribute12
, p_line_rec.return_attribute13
, p_line_rec.return_attribute14
, p_line_rec.return_attribute15
, p_line_rec.return_attribute2
, p_line_rec.return_attribute3
, p_line_rec.return_attribute4
, p_line_rec.return_attribute5
, p_line_rec.return_attribute6
, p_line_rec.return_attribute7
, p_line_rec.return_attribute8
, p_line_rec.return_attribute9
, p_line_rec.return_context
, p_line_rec.return_reason_code
, p_line_rec.rla_schedule_type_code
, p_line_rec.salesrep_id
, p_line_rec.schedule_arrival_date
, p_line_rec.schedule_ship_date
, p_line_rec.schedule_status_code
, p_line_rec.shipment_number
, p_line_rec.shipment_priority_code
, p_line_rec.shipped_quantity
, p_line_rec.shipped_quantity2 -- OPM B1661023 04/02/01
, p_line_rec.shipping_method_code
, p_line_rec.shipping_quantity
, p_line_rec.shipping_quantity2 -- OPM B1661023 04/02/01
, p_line_rec.shipping_quantity_uom
, p_line_rec.ship_from_org_id
, p_line_Rec.subinventory
, p_line_rec.ship_set_id
, p_line_rec.ship_tolerance_above
, p_line_rec.ship_tolerance_below
, p_line_rec.shippable_flag
, p_line_rec.shipping_interfaced_flag
, p_line_rec.ship_to_contact_id
, p_line_rec.ship_to_org_id
, p_line_rec.ship_model_complete_flag
, p_line_rec.sold_to_org_id
, l_sold_from_org
, p_line_rec.sort_order
, p_line_rec.source_document_id
, p_line_rec.source_document_line_id
, p_line_rec.source_document_type_id
, p_line_rec.source_type_code
, p_line_rec.split_from_line_id
, p_line_rec.line_set_id
, p_line_rec.split_by
, p_line_rec.model_remnant_flag
, p_line_rec.task_id
, p_line_rec.tax_code
, p_line_rec.tax_date
, p_line_rec.tax_exempt_flag
, p_line_rec.tax_exempt_number
, p_line_rec.tax_exempt_reason_code
, p_line_rec.tax_point_code
, p_line_rec.tax_rate
, p_line_rec.tax_value
, p_line_rec.top_model_line_id
, p_line_rec.unit_list_price
, p_line_rec.unit_list_price_per_pqty
, p_line_rec.unit_selling_price
, p_line_rec.unit_selling_price_per_pqty
, p_line_rec.visible_demand_flag
, p_line_rec.veh_cus_item_cum_key_id
, p_line_rec.shipping_instructions
, p_line_rec.packing_instructions
, p_line_rec.service_txn_reason_code
, p_line_rec.service_txn_comments
, p_line_rec.service_duration
, p_line_rec.service_period
, p_line_rec.service_start_date
, p_line_rec.service_end_date
, p_line_rec.service_coterminate_flag
, p_line_rec.unit_list_percent
, p_line_rec.unit_selling_percent
, p_line_rec.unit_percent_base_price
, p_line_rec.service_number
, p_line_rec.service_reference_type_code
, p_line_rec.service_reference_line_id
, p_line_rec.service_reference_system_id
, p_line_rec.tp_context
, p_line_rec.tp_attribute1
, p_line_rec.tp_attribute2
, p_line_rec.tp_attribute3
, p_line_rec.tp_attribute4
, p_line_rec.tp_attribute5
, p_line_rec.tp_attribute6
, p_line_rec.tp_attribute7
, p_line_rec.tp_attribute8
, p_line_rec.tp_attribute9
, p_line_rec.tp_attribute10
, p_line_rec.tp_attribute11
, p_line_rec.tp_attribute12
, p_line_rec.tp_attribute13
, p_line_rec.tp_attribute14
, p_line_rec.tp_attribute15
, p_line_rec.flow_status_code
, p_line_rec.marketing_source_code_id
, p_line_rec.calculate_price_flag
, p_line_rec.commitment_id
, l_upgraded_flag
, p_line_rec.original_inventory_item_id
, p_line_rec.original_item_identifier_Type
, p_line_rec.original_ordered_item_id
, p_line_rec.original_ordered_item
, p_line_rec.item_relationship_type
, p_line_rec.item_substitution_type_code
, p_line_rec.late_demand_penalty_factor
, p_line_rec.Override_atp_date_code
, p_line_rec.Firm_demand_flag
, p_line_rec.Earliest_ship_date
, p_line_rec.user_item_description
, p_line_rec.Blanket_Number
, p_line_rec.Blanket_Line_Number
, p_line_rec.Blanket_Version_Number
--MRG B
, p_line_rec.unit_cost
--MRG E
, l_lock_control
-- Changes for quoting
, p_line_rec.transaction_phase_code
, p_line_rec.source_document_version_number
-- end changes for quoting
, p_line_rec.Minisite_Id
, p_line_rec.Ib_owner
, p_line_rec.Ib_installed_at_location
, p_line_rec.Ib_current_location
, p_line_rec.End_customer_Id
, p_line_rec.End_customer_contact_Id
, p_line_rec.End_customer_site_use_Id
/* , p_line_rec.Supplier_signature
, p_line_rec.Supplier_signature_date
, p_line_rec.customer_signature
, p_line_rec.customer_signature_date */
--retro{
, p_line_rec.retrobill_request_id
--retro}
, p_line_rec.original_list_price -- Override List Price
-- key Transaction Dates
, p_line_rec.order_firmed_date
, p_line_rec.actual_fulfillment_date
--recurring charges
, p_line_rec.charge_periodicity_code
-- INVCONV
, p_line_rec.cancelled_quantity2
, p_line_rec.shipping_quantity_uom2
, p_line_rec.fulfilled_quantity2
, p_line_rec.CONTINGENCY_ID
, p_line_rec.REVREC_EVENT_CODE
, p_line_rec.REVREC_EXPIRATION_DAYS
, p_line_rec.ACCEPTED_QUANTITY
, p_line_rec.REVREC_COMMENTS
, p_line_rec.REVREC_SIGNATURE
, p_line_rec.REVREC_SIGNATURE_DATE
, p_line_rec.ACCEPTED_BY
, p_line_rec.REVREC_REFERENCE_DOCUMENT
, p_line_rec.REVREC_IMPLICIT_FLAG
);
OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
p_Line_rec =>p_line_rec,
p_old_line_rec => NULL,
p_line_id => p_line_rec.line_id,
x_index => l_index,
x_return_status => l_return_status);
OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.inset_row is: ' || l_return_status);
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);
OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.insert_row');
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);
oe_debug_pub.add('Exiting OE_LINE_UTIL.INSERT_ROW', 1);
, 'Insert_Row'
);
END Insert_Row;
Procedure Delete_Row
-----------------------------------------------------------*/
PROCEDURE Delete_Row
( p_line_id IN NUMBER := FND_API.G_MISS_NUM
,p_header_id IN NUMBER := FND_API.G_MISS_NUM)
IS
l_return_status VARCHAR2(30);
SELECT line_id, item_type_code,
config_header_id, config_rev_nbr,
line_category_code, schedule_status_code,
shipping_interfaced_flag,
ordered_quantity, price_request_code
,transaction_phase_code
FROM OE_ORDER_LINES
WHERE HEADER_ID = p_header_id;
SELECT line_id, item_type_code
FROM OE_ORDER_LINES
WHERE service_reference_line_id = p_line_id
AND service_reference_type_code = 'ORDER'; --bug 3056313
oe_debug_pub.add('Entering OE_LINE_UTIL.DELETE_ROW', 1);
oe_debug_pub.add('Entering delete '||to_char(l_org_id), 1); */
oe_debug_pub.add('JFC: in delete row, l_line_id'|| l_line.line_id , 1);
/* Set the operation on the record so that globals are updated as well */
l_new_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
p_line_rec =>l_new_line_rec,
p_line_id =>l_line.line_id,
x_index => l_index,
x_return_status => l_return_status);
OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row is: ' || l_return_status);
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
OE_Config_Pvt.Delete_Config
( p_config_hdr_id => l_line.config_header_id,
p_config_rev_nbr => l_line.config_rev_nbr,
x_return_status => l_return_status );
oe_debug_pub.add(' Header - Before delete dependent');
Delete_Dependents
( p_line_id => l_line_id
,p_item_type_code => l_item_type_code
,p_line_category_code => l_line_category_code
,p_config_header_id => l_config_header_id
,p_config_rev_nbr => l_config_rev_nbr
,p_schedule_status_code => l_schedule_status_code
,p_shipping_interfaced_flag => l_shipping_interfaced_flag
,p_ordered_quantity => l_ordered_quantity -- BUG 2670775 Reverse Limits
,p_price_request_code => l_price_request_code -- BUG 2670775 Reverse Limits
,p_transaction_phase_code => l_transaction_phase_code -- Bug 3315331
);
DELETE FROM OE_ORDER_LINES_HISTORY
WHERE HEADER_ID = p_header_id;
DELETE FROM OE_ORDER_LINES
WHERE HEADER_ID = p_header_id;
oe_debug_pub.add('hdr missing delete_row,line_id: '||p_line_id, 1);
lsqlstmt := 'Select line_id, item_type_code, line_category_code,
config_header_id, config_rev_nbr,
schedule_status_code, shipping_interfaced_flag,
ordered_quantity, price_request_code
from oe_order_lines
where top_model_line_id = :x and
line_id <> :y';
oe_debug_pub.add(' model - Before delete dependent' || l_line_id);
Delete_Dependents
( p_line_id => l_line_id
,p_item_type_code => l_item_type_code
,p_line_category_code => l_line_category_code
,p_config_header_id => l_config_header_id
,p_config_rev_nbr => l_config_rev_nbr
,p_schedule_status_code => l_schedule_status_code
,p_shipping_interfaced_flag => l_shipping_interfaced_flag
,p_ordered_quantity => l_ordered_quantity -- BUG 2670775 Reverse Limits
,p_price_request_code => l_price_request_code); -- BUG 2670775 Reverse Limits
lsqlstmt := 'Select line_id, item_type_code, line_category_code,
config_header_id, config_rev_nbr,
schedule_status_code, shipping_interfaced_flag,
ordered_quantity, price_request_code
from oe_order_lines
where service_reference_type_code = ' || '''' || 'ORDER' || ''' ' ||
'AND service_reference_line_id = :x'; --bug 3056313
oe_debug_pub.add('Service - Before delete dependent' || l_line_id);
Delete_Dependents
( p_line_id => l_line_id
,p_item_type_code => l_item_type_code
,p_line_category_code => l_line_category_code
,p_config_header_id => l_config_header_id
,p_config_rev_nbr => l_config_rev_nbr
,p_schedule_status_code => l_schedule_status_code
,p_shipping_interfaced_flag => l_shipping_interfaced_flag
,p_ordered_quantity => l_ordered_quantity -- BUG 2670775 Reverse Limits
,p_price_request_code => l_price_request_code ); -- BUG 2670775 Reverse Limits
DELETE FROM OE_ORDER_LINES
WHERE SERVICE_REFERENCE_LINE_ID = l_tmp_line_id
AND SERVICE_REFERENCE_TYPE_CODE = 'ORDER'; -- bug 3056313
'Delete oe_order_lines where top_model_line_id = :x
and line_id <> :y'
USING
p_line_id,
p_line_id;
/* Keep all your dependencies in Delete Dependents Procedure */
oe_debug_pub.add('calling delete dep for the line', 1);
Delete_Dependents
( p_line_id => l_line_rec.line_id
,p_item_type_code => l_line_rec.item_type_code
,p_line_category_code => l_line_rec.line_category_code
,p_config_header_id => l_line_rec.config_header_id
,p_config_rev_nbr => l_line_rec.config_rev_nbr
,p_schedule_status_code => l_line_rec.schedule_status_code
,p_shipping_interfaced_flag => l_line_rec.shipping_interfaced_flag
,p_ordered_quantity => l_line_rec.ordered_quantity -- BUG 2670775 Reverse Limits
,p_price_request_code => l_line_rec.price_request_code); -- BUG 2670775 Reverse Limits
OE_Config_Pvt.Delete_Config
( p_config_hdr_id => l_line_rec.config_header_id,
p_config_rev_nbr => l_line_rec.config_rev_nbr,
x_return_status => l_return_status );
/* Delete all the dependents for service line */
oe_debug_pub.add('Item Type for delete: ' || l_line_rec.item_type_code);
/* When a standard line is being deleted, check if it has any service */
/* lines attached to it. If so, get the line_id of the service line and */
/* use this to delete the dependents */
-- 02/NOV Reverse Limits add ordered_quantity, price_request_code to select
lsqlstmt := 'Select line_id, item_type_code, line_category_code,
config_header_id, config_rev_nbr,
schedule_status_code, shipping_interfaced_flag,
ordered_quantity,price_request_code
from oe_order_lines
where service_reference_type_code = ' || '''' || 'ORDER' || ''' ' ||
'and service_reference_line_id = :x'; -- bug 3056313
oe_debug_pub.add('Service - Before delete dependent' || l_line_id);
Delete_Dependents
( p_line_id => l_line_id
,p_item_type_code => l_item_type_code
,p_line_category_code => l_line_category_code
,p_config_header_id => l_config_header_id
,p_config_rev_nbr => l_config_rev_nbr
,p_schedule_status_code => l_schedule_status_code
,p_shipping_interfaced_flag => l_shipping_interfaced_flag
,p_ordered_quantity => l_ordered_quantity -- BUG 2670775 Reverse Limits
,p_price_request_code => l_price_request_code); -- BUG 2670775 Reverse Limits
DELETE FROM OE_ORDER_LINES_HISTORY
WHERE LINE_ID = p_line_id
AND NVL(AUDIT_FLAG, 'Y') = 'Y'
AND NVL(VERSION_FLAG, 'N') = 'N'
AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
UPDATE OE_ORDER_LINES_HISTORY
SET AUDIT_FLAG = 'N'
WHERE LINE_ID = p_line_id
AND NVL(AUDIT_FLAG, 'Y') = 'Y'
AND (NVL(VERSION_FLAG, 'N') = 'Y'
OR NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
oe_debug_pub.add('JPN: Delete all lines now');
/* Set the operation on the record so that globals are updated as well */
l_new_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
l_new_line_rec.last_update_date :=l_line_rec.last_update_date;
OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
p_line_rec =>l_new_line_rec,
p_line_id =>l_line_rec.line_id,
x_index => l_index,
x_return_status => l_return_status);
OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting standard line is: ' || l_return_status);
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
DELETE FROM OE_ORDER_LINES
WHERE LINE_ID = p_line_id;
oe_debug_pub.add('JFC: in delete row, service line_id= '|| l_svc.line_id , 1);
/* Set the operation on the record so that globals are updated as well */
l_new_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
p_line_rec =>l_new_line_rec,
p_line_id =>l_svc.line_id,
x_index => l_index,
x_return_status => l_return_status);
OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting service line is: ' || l_return_status);
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
DELETE FROM OE_ORDER_LINES
WHERE SERVICE_REFERENCE_LINE_ID = p_line_id
AND SERVICE_REFERENCE_TYPE_CODE = 'ORDER'; -- bug 3056313
WSH_DCP_PVT.g_dc_table.DELETE;
||'from delete row-'|| l_header_id, 1);
oe_debug_pub.add('OM call to WSH DCP Caught in delete', 1);
('Update_Shipping_From_OE, DCP post process'|| sqlerrm);
oe_debug_pub.add('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
,'Delete_Row');
END Delete_Row;
SELECT ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, ACTUAL_ARRIVAL_DATE
, ACTUAL_SHIPMENT_DATE
, AGREEMENT_ID
, ARRIVAL_SET_ID
, ATO_LINE_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16 --For bug 2184255
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE2
, ATTRIBUTE20
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTO_SELECTED_QUANTITY
, AUTHORIZED_TO_SHIP_FLAG
, BOOKED_FLAG
, CANCELLED_FLAG
, CANCELLED_QUANTITY
, COMPONENT_CODE
, COMPONENT_NUMBER
, COMPONENT_SEQUENCE_ID
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, CONFIG_DISPLAY_SEQUENCE
, CONFIGURATION_ID
, CONTEXT
, CREATED_BY
, CREATION_DATE
, CREDIT_INVOICE_LINE_ID
, CUSTOMER_DOCK_CODE
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUST_PRODUCTION_SEQ_NUM
, CUSTOMER_TRX_LINE_ID
, CUST_MODEL_SERIAL_NUMBER
, CUST_PO_NUMBER
, CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_NET_PRICE
, DELIVERY_LEAD_TIME
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG_ID
, DEMAND_BUCKET_TYPE_CODE
, DEMAND_CLASS_CODE
, DEP_PLAN_REQUIRED_FLAG
, EARLIEST_ACCEPTABLE_DATE
, END_ITEM_UNIT_NUMBER
, EXPLOSION_DATE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, FULFILLED_QUANTITY
, FULFILLED_FLAG
, FULFILLMENT_METHOD_CODE
, FULFILLMENT_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, HEADER_ID
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_CONTEXT
, INTMED_SHIP_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID
, INVENTORY_ITEM_ID
, INVOICE_INTERFACE_STATUS_CODE
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG_ID
, INVOICED_QUANTITY
, INVOICING_RULE_ID
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, ORDERED_ITEM
, ITEM_REVISION
, ITEM_TYPE_CODE
, LAST_ACK_CODE
, LAST_ACK_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LATEST_ACCEPTABLE_DATE
, LINE_CATEGORY_CODE
, LINE_ID
, LINE_NUMBER
, LINE_TYPE_ID
, LINK_TO_LINE_ID
, MODEL_GROUP_NUMBER
-- , MFG_COMPONENT_SEQUENCE_ID
, MFG_LEAD_TIME
, OPEN_FLAG
, OPTION_FLAG
, OPTION_NUMBER
, ORDERED_QUANTITY
, ORDERED_QUANTITY2 --OPM 02/JUN/00
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
, ORG_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, PAYMENT_TERM_ID
, PLANNING_PRIORITY
, PREFERRED_GRADE --OPM 02/JUN/00
, PRICE_LIST_ID
, PRICE_REQUEST_CODE --PROMOTIONS MAY/01
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_CONTEXT
, PRICING_DATE
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, PROMISE_DATE
, RE_SOURCE_FLAG
, REFERENCE_CUSTOMER_TRX_LINE_ID
, REFERENCE_HEADER_ID
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, REQUEST_DATE
, REQUEST_ID
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_CONTEXT
, RETURN_REASON_CODE
, RLA_SCHEDULE_TYPE_CODE
, SALESREP_ID
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SCHEDULE_STATUS_CODE
, SHIPMENT_NUMBER
, SHIPMENT_PRIORITY_CODE
, SHIPPED_QUANTITY
, SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, SHIPPING_QUANTITY_UOM
, SHIPPING_QUANTITY_UOM2 -- INVCONV
, SHIP_FROM_ORG_ID
, SUBINVENTORY
, SHIP_SET_ID
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIPPABLE_FLAG
, SHIPPING_INTERFACED_FLAG
, SHIP_TO_CONTACT_ID
, SHIP_TO_ORG_ID
, SHIP_MODEL_COMPLETE_FLAG
, SOLD_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SORT_ORDER
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID
, SOURCE_DOCUMENT_TYPE_ID
, SOURCE_TYPE_CODE
, SPLIT_FROM_LINE_ID
, LINE_SET_ID
, SPLIT_BY
, MODEL_REMNANT_FLAG
, TASK_ID
, TAX_CODE
, TAX_DATE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_POINT_CODE
, TAX_RATE
, TAX_VALUE
, TOP_MODEL_LINE_ID
, UNIT_LIST_PRICE
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE
, UNIT_SELLING_PRICE_PER_PQTY
, VISIBLE_DEMAND_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_PERIOD
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, FLOW_STATUS_CODE
, MARKETING_SOURCE_CODE_ID
, CALCULATE_PRICE_FLAG
, COMMITMENT_ID
, ORDER_SOURCE_ID -- aksingh
, UPGRADED_FLAG
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ITEM_RELATIONSHIP_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE
, LATE_DEMAND_PENALTY_FACTOR
, OVERRIDE_ATP_DATE_CODE
, FIRM_DEMAND_FLAG
, EARLIEST_SHIP_DATE
, USER_ITEM_DESCRIPTION
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
, BLANKET_VERSION_NUMBER
, UNIT_COST
, LOCK_CONTROL
, CHANGE_SEQUENCE
, transaction_phase_code
, source_document_version_number
, MINISITE_ID
, Ib_Owner
, Ib_installed_at_location
, Ib_current_location
, End_customer_ID
, End_customer_contact_ID
, End_customer_site_use_ID
, RETROBILL_REQUEST_ID
, ORIGINAL_LIST_PRICE -- Override List Price
, order_firmed_date
, actual_fulfillment_date
, charge_periodicity_code
, cancelled_quantity2
, fulfilled_quantity2
, CONTINGENCY_ID
, REVREC_EVENT_CODE
, REVREC_EXPIRATION_DAYS
, ACCEPTED_QUANTITY
, REVREC_COMMENTS
, REVREC_SIGNATURE
, REVREC_SIGNATURE_DATE
, ACCEPTED_BY
, REVREC_REFERENCE_DOCUMENT
, REVREC_IMPLICIT_FLAG
FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
WHERE LINE_ID = p_line_id;
, x_line_rec.AUTO_SELECTED_QUANTITY
, x_line_rec.AUTHORIZED_TO_SHIP_FLAG
, x_line_rec.BOOKED_FLAG
, x_line_rec.CANCELLED_FLAG
, x_line_rec.CANCELLED_QUANTITY
, x_line_rec.COMPONENT_CODE
, x_line_rec.COMPONENT_NUMBER
, x_line_rec.COMPONENT_SEQUENCE_ID
, x_line_rec.CONFIG_HEADER_ID
, x_line_rec.CONFIG_REV_NBR
, x_line_rec.CONFIG_DISPLAY_SEQUENCE
, x_line_rec.CONFIGURATION_ID
, x_line_rec.CONTEXT
, x_line_rec.CREATED_BY
, x_line_rec.CREATION_DATE
, x_line_rec.CREDIT_INVOICE_LINE_ID
, x_line_rec.CUSTOMER_DOCK_CODE
, x_line_rec.CUSTOMER_JOB
, x_line_rec.CUSTOMER_PRODUCTION_LINE
, x_line_rec.CUST_PRODUCTION_SEQ_NUM
, x_line_rec.CUSTOMER_TRX_LINE_ID
, x_line_rec.CUST_MODEL_SERIAL_NUMBER
, x_line_rec.CUST_PO_NUMBER
, x_line_rec.CUSTOMER_LINE_NUMBER
, x_line_rec.CUSTOMER_SHIPMENT_NUMBER
, x_line_rec.CUSTOMER_ITEM_NET_PRICE
, x_line_rec.DELIVERY_LEAD_TIME
, x_line_rec.DELIVER_TO_CONTACT_ID
, x_line_rec.DELIVER_TO_ORG_ID
, x_line_rec.DEMAND_BUCKET_TYPE_CODE
, x_line_rec.DEMAND_CLASS_CODE
, x_line_rec.DEP_PLAN_REQUIRED_FLAG
, x_line_rec.EARLIEST_ACCEPTABLE_DATE
, x_line_rec.END_ITEM_UNIT_NUMBER
, x_line_rec.EXPLOSION_DATE
, x_line_rec.FIRST_ACK_CODE
, x_line_rec.FIRST_ACK_DATE
, x_line_rec.FOB_POINT_CODE
, x_line_rec.FREIGHT_CARRIER_CODE
, x_line_rec.FREIGHT_TERMS_CODE
, x_line_rec.FULFILLED_QUANTITY
, x_line_rec.FULFILLED_FLAG
, x_line_rec.FULFILLMENT_METHOD_CODE
, x_line_rec.FULFILLMENT_DATE
, x_line_rec.GLOBAL_ATTRIBUTE1
, x_line_rec.GLOBAL_ATTRIBUTE10
, x_line_rec.GLOBAL_ATTRIBUTE11
, x_line_rec.GLOBAL_ATTRIBUTE12
, x_line_rec.GLOBAL_ATTRIBUTE13
, x_line_rec.GLOBAL_ATTRIBUTE14
, x_line_rec.GLOBAL_ATTRIBUTE15
, x_line_rec.GLOBAL_ATTRIBUTE16
, x_line_rec.GLOBAL_ATTRIBUTE17
, x_line_rec.GLOBAL_ATTRIBUTE18
, x_line_rec.GLOBAL_ATTRIBUTE19
, x_line_rec.GLOBAL_ATTRIBUTE2
, x_line_rec.GLOBAL_ATTRIBUTE20
, x_line_rec.GLOBAL_ATTRIBUTE3
, x_line_rec.GLOBAL_ATTRIBUTE4
, x_line_rec.GLOBAL_ATTRIBUTE5
, x_line_rec.GLOBAL_ATTRIBUTE6
, x_line_rec.GLOBAL_ATTRIBUTE7
, x_line_rec.GLOBAL_ATTRIBUTE8
, x_line_rec.GLOBAL_ATTRIBUTE9
, x_line_rec.GLOBAL_ATTRIBUTE_CATEGORY
, x_line_rec.HEADER_ID
, x_line_rec.INDUSTRY_ATTRIBUTE1
, x_line_rec.INDUSTRY_ATTRIBUTE10
, x_line_rec.INDUSTRY_ATTRIBUTE11
, x_line_rec.INDUSTRY_ATTRIBUTE12
, x_line_rec.INDUSTRY_ATTRIBUTE13
, x_line_rec.INDUSTRY_ATTRIBUTE14
, x_line_rec.INDUSTRY_ATTRIBUTE15
, x_line_rec.INDUSTRY_ATTRIBUTE16
, x_line_rec.INDUSTRY_ATTRIBUTE17
, x_line_rec.INDUSTRY_ATTRIBUTE18
, x_line_rec.INDUSTRY_ATTRIBUTE19
, x_line_rec.INDUSTRY_ATTRIBUTE20
, x_line_rec.INDUSTRY_ATTRIBUTE21
, x_line_rec.INDUSTRY_ATTRIBUTE22
, x_line_rec.INDUSTRY_ATTRIBUTE23
, x_line_rec.INDUSTRY_ATTRIBUTE24
, x_line_rec.INDUSTRY_ATTRIBUTE25
, x_line_rec.INDUSTRY_ATTRIBUTE26
, x_line_rec.INDUSTRY_ATTRIBUTE27
, x_line_rec.INDUSTRY_ATTRIBUTE28
, x_line_rec.INDUSTRY_ATTRIBUTE29
, x_line_rec.INDUSTRY_ATTRIBUTE30
, x_line_rec.INDUSTRY_ATTRIBUTE2
, x_line_rec.INDUSTRY_ATTRIBUTE3
, x_line_rec.INDUSTRY_ATTRIBUTE4
, x_line_rec.INDUSTRY_ATTRIBUTE5
, x_line_rec.INDUSTRY_ATTRIBUTE6
, x_line_rec.INDUSTRY_ATTRIBUTE7
, x_line_rec.INDUSTRY_ATTRIBUTE8
, x_line_rec.INDUSTRY_ATTRIBUTE9
, x_line_rec.INDUSTRY_CONTEXT
, x_line_rec.INTERMED_SHIP_TO_CONTACT_ID
, x_line_rec.INTERMED_SHIP_TO_ORG_ID
, x_line_rec.INVENTORY_ITEM_ID
, x_line_rec.INVOICE_INTERFACE_STATUS_CODE
, x_line_rec.INVOICE_TO_CONTACT_ID
, x_line_rec.INVOICE_TO_ORG_ID
, x_line_rec.INVOICED_QUANTITY
, x_line_rec.INVOICING_RULE_ID
, x_line_rec.ORDERED_ITEM_ID
, x_line_rec.ITEM_IDENTIFIER_TYPE
, x_line_rec.ORDERED_ITEM
, x_line_rec.ITEM_REVISION
, x_line_rec.ITEM_TYPE_CODE
, x_line_rec.LAST_ACK_CODE
, x_line_rec.LAST_ACK_DATE
, x_line_rec.LAST_UPDATED_BY
, x_line_rec.LAST_UPDATE_DATE
, x_line_rec.LAST_UPDATE_LOGIN
, x_line_rec.LATEST_ACCEPTABLE_DATE
, x_line_rec.LINE_CATEGORY_CODE
, x_line_rec.LINE_ID
, x_line_rec.LINE_NUMBER
, x_line_rec.LINE_TYPE_ID
, x_line_rec.LINK_TO_LINE_ID
, x_line_rec.MODEL_GROUP_NUMBER
-- , x_line_rec.MFG_COMPONENT_SEQUENCE_ID
, x_line_rec.MFG_LEAD_TIME
, x_line_rec.OPEN_FLAG
, x_line_rec.OPTION_FLAG
, x_line_rec.OPTION_NUMBER
, x_line_rec.ORDERED_QUANTITY
, x_line_rec.ORDERED_QUANTITY2 --OPM 02/JUN/00
, x_line_rec.ORDER_QUANTITY_UOM
, x_line_rec.ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
, x_line_rec.ORG_ID
, x_line_rec.ORIG_SYS_DOCUMENT_REF
, x_line_rec.ORIG_SYS_LINE_REF
, x_line_rec.ORIG_SYS_SHIPMENT_REF
, x_line_rec.OVER_SHIP_REASON_CODE
, x_line_rec.OVER_SHIP_RESOLVED_FLAG
, x_line_rec.PAYMENT_TERM_ID
, x_line_rec.PLANNING_PRIORITY
, x_line_rec.PREFERRED_GRADE --OPM 02/JUN/00
, x_line_rec.PRICE_LIST_ID
, x_line_rec.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
, x_line_rec.PRICING_ATTRIBUTE1
, x_line_rec.PRICING_ATTRIBUTE10
, x_line_rec.PRICING_ATTRIBUTE2
, x_line_rec.PRICING_ATTRIBUTE3
, x_line_rec.PRICING_ATTRIBUTE4
, x_line_rec.PRICING_ATTRIBUTE5
, x_line_rec.PRICING_ATTRIBUTE6
, x_line_rec.PRICING_ATTRIBUTE7
, x_line_rec.PRICING_ATTRIBUTE8
, x_line_rec.PRICING_ATTRIBUTE9
, x_line_rec.PRICING_CONTEXT
, x_line_rec.PRICING_DATE
, x_line_rec.PRICING_QUANTITY
, x_line_rec.PRICING_QUANTITY_UOM
, x_line_rec.PROGRAM_APPLICATION_ID
, x_line_rec.PROGRAM_ID
, x_line_rec.PROGRAM_UPDATE_DATE
, x_line_rec.PROJECT_ID
, x_line_rec.PROMISE_DATE
, x_line_rec.RE_SOURCE_FLAG
, x_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
, x_line_rec.REFERENCE_HEADER_ID
, x_line_rec.REFERENCE_LINE_ID
, x_line_rec.REFERENCE_TYPE
, x_line_rec.REQUEST_DATE
, x_line_rec.REQUEST_ID
, x_line_rec.RETURN_ATTRIBUTE1
, x_line_rec.RETURN_ATTRIBUTE10
, x_line_rec.RETURN_ATTRIBUTE11
, x_line_rec.RETURN_ATTRIBUTE12
, x_line_rec.RETURN_ATTRIBUTE13
, x_line_rec.RETURN_ATTRIBUTE14
, x_line_rec.RETURN_ATTRIBUTE15
, x_line_rec.RETURN_ATTRIBUTE2
, x_line_rec.RETURN_ATTRIBUTE3
, x_line_rec.RETURN_ATTRIBUTE4
, x_line_rec.RETURN_ATTRIBUTE5
, x_line_rec.RETURN_ATTRIBUTE6
, x_line_rec.RETURN_ATTRIBUTE7
, x_line_rec.RETURN_ATTRIBUTE8
, x_line_rec.RETURN_ATTRIBUTE9
, x_line_rec.RETURN_CONTEXT
, x_line_rec.RETURN_REASON_CODE
, x_line_rec.RLA_SCHEDULE_TYPE_CODE
, x_line_rec.SALESREP_ID
, x_line_rec.SCHEDULE_ARRIVAL_DATE
, x_line_rec.SCHEDULE_SHIP_DATE
, x_line_rec.SCHEDULE_STATUS_CODE
, x_line_rec.SHIPMENT_NUMBER
, x_line_rec.SHIPMENT_PRIORITY_CODE
, x_line_rec.SHIPPED_QUANTITY
, x_line_rec.SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
, x_line_rec.SHIPPING_METHOD_CODE
, x_line_rec.SHIPPING_QUANTITY
, x_line_rec.SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, x_line_rec.SHIPPING_QUANTITY_UOM
, x_line_rec.SHIPPING_QUANTITY_UOM2
, x_line_rec.SHIP_FROM_ORG_ID
, x_line_rec.SUBINVENTORY
, x_line_rec.SHIP_SET_ID
, x_line_rec.SHIP_TOLERANCE_ABOVE
, x_line_rec.SHIP_TOLERANCE_BELOW
, x_line_rec.SHIPPABLE_FLAG
, x_line_rec.SHIPPING_INTERFACED_FLAG
, x_line_rec.SHIP_TO_CONTACT_ID
, x_line_rec.SHIP_TO_ORG_ID
, x_line_rec.SHIP_MODEL_COMPLETE_FLAG
, x_line_rec.SOLD_TO_ORG_ID
, x_line_rec.SOLD_FROM_ORG_ID
, x_line_rec.SORT_ORDER
, x_line_rec.SOURCE_DOCUMENT_ID
, x_line_rec.SOURCE_DOCUMENT_LINE_ID
, x_line_rec.SOURCE_DOCUMENT_TYPE_ID
, x_line_rec.SOURCE_TYPE_CODE
, x_line_rec.SPLIT_FROM_LINE_ID
, x_line_rec.LINE_SET_ID
, x_line_rec.SPLIT_BY
, x_line_rec.MODEL_REMNANT_FLAG
, x_line_rec.TASK_ID
, x_line_rec.TAX_CODE
, x_line_rec.TAX_DATE
, x_line_rec.TAX_EXEMPT_FLAG
, x_line_rec.TAX_EXEMPT_NUMBER
, x_line_rec.TAX_EXEMPT_REASON_CODE
, x_line_rec.TAX_POINT_CODE
, x_line_rec.TAX_RATE
, x_line_rec.TAX_VALUE
, x_line_rec.TOP_MODEL_LINE_ID
, x_line_rec.UNIT_LIST_PRICE
, x_line_rec.UNIT_LIST_PRICE_PER_PQTY
, x_line_rec.UNIT_SELLING_PRICE
, x_line_rec.UNIT_SELLING_PRICE_PER_PQTY
, x_line_rec.VISIBLE_DEMAND_FLAG
, x_line_rec.VEH_CUS_ITEM_CUM_KEY_ID
, x_line_rec.SHIPPING_INSTRUCTIONS
, x_line_rec.PACKING_INSTRUCTIONS
, x_line_rec.SERVICE_TXN_REASON_CODE
, x_line_rec.SERVICE_TXN_COMMENTS
, x_line_rec.SERVICE_DURATION
, x_line_rec.SERVICE_PERIOD
, x_line_rec.SERVICE_START_DATE
, x_line_rec.SERVICE_END_DATE
, x_line_rec.SERVICE_COTERMINATE_FLAG
, x_line_rec.UNIT_LIST_PERCENT
, x_line_rec.UNIT_SELLING_PERCENT
, x_line_rec.UNIT_PERCENT_BASE_PRICE
, x_line_rec.SERVICE_NUMBER
, x_line_rec.SERVICE_REFERENCE_TYPE_CODE
, x_line_rec.SERVICE_REFERENCE_LINE_ID
, x_line_rec.SERVICE_REFERENCE_SYSTEM_ID
, x_line_rec.TP_CONTEXT
, x_line_rec.TP_ATTRIBUTE1
, x_line_rec.TP_ATTRIBUTE2
, x_line_rec.TP_ATTRIBUTE3
, x_line_rec.TP_ATTRIBUTE4
, x_line_rec.TP_ATTRIBUTE5
, x_line_rec.TP_ATTRIBUTE6
, x_line_rec.TP_ATTRIBUTE7
, x_line_rec.TP_ATTRIBUTE8
, x_line_rec.TP_ATTRIBUTE9
, x_line_rec.TP_ATTRIBUTE10
, x_line_rec.TP_ATTRIBUTE11
, x_line_rec.TP_ATTRIBUTE12
, x_line_rec.TP_ATTRIBUTE13
, x_line_rec.TP_ATTRIBUTE14
, x_line_rec.TP_ATTRIBUTE15
, x_line_rec.FLOW_STATUS_CODE
, x_line_rec.MARKETING_SOURCE_CODE_ID
, x_line_rec.CALCULATE_PRICE_FLAG
, x_line_rec.COMMITMENT_ID
, x_line_rec.ORDER_SOURCE_ID -- aksingh
, x_line_rec.UPGRADED_FLAG
, x_line_rec.ORIGINAL_INVENTORY_ITEM_ID
, x_line_rec.ORIGINAL_ITEM_IDENTIFIER_TYPE
, x_line_rec.ORIGINAL_ORDERED_ITEM_ID
, x_line_rec.ORIGINAL_ORDERED_ITEM
, x_line_rec.ITEM_RELATIONSHIP_TYPE
, x_line_rec.ITEM_SUBSTITUTION_TYPE_CODE
, x_line_rec.LATE_DEMAND_PENALTY_FACTOR
, x_line_rec.OVERRIDE_ATP_DATE_CODE
, x_line_rec.FIRM_DEMAND_FLAG
, x_line_rec.EARLIEST_SHIP_DATE
, x_line_rec.USER_ITEM_DESCRIPTION
, x_line_rec.BLANKET_NUMBER
, x_line_rec.BLANKET_LINE_NUMBER
, x_line_rec.BLANKET_VERSION_NUMBER
, x_line_rec.UNIT_COST
, x_line_rec.LOCK_CONTROL
, x_line_rec.CHANGE_SEQUENCE
, x_line_rec.transaction_phase_code
, x_line_rec.source_document_version_number
, x_line_rec.MINISITE_ID
, x_line_rec.Ib_Owner
, x_line_rec.Ib_installed_at_location
, x_line_rec.Ib_current_location
, x_line_rec.End_customer_ID
, x_line_rec.End_customer_contact_ID
, x_line_rec.End_customer_site_use_ID
, x_line_rec.RETROBILL_REQUEST_ID
, x_line_rec.ORIGINAL_LIST_PRICE -- Override List Price
, x_line_rec.order_firmed_date
, x_line_rec.actual_fulfillment_date
, x_line_rec.charge_periodicity_code
, x_line_rec.cancelled_quantity2
, x_line_rec.fulfilled_quantity2
, x_line_rec.CONTINGENCY_ID
, x_line_rec.REVREC_EVENT_CODE
, x_line_rec.REVREC_EXPIRATION_DAYS
, x_line_rec.ACCEPTED_QUANTITY
, x_line_rec.REVREC_COMMENTS
, x_line_rec.REVREC_SIGNATURE
, x_line_rec.REVREC_SIGNATURE_DATE
, x_line_rec.ACCEPTED_BY
, x_line_rec.REVREC_REFERENCE_DOCUMENT
, x_line_rec.REVREC_IMPLICIT_FLAG;
When you add/delete columns to query_rows function,
Please do the same changes in OE_Config_Util package body
Query_Config function.
-----------------------------------------------------------*/
PROCEDURE Query_Rows
( p_line_id IN NUMBER :=
FND_API.G_MISS_NUM
, p_header_id IN NUMBER :=
FND_API.G_MISS_NUM
, p_line_set_id IN NUMBER :=
FND_API.G_MISS_NUM
, x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
)
IS
l_org_id NUMBER;
SELECT ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, ACTUAL_ARRIVAL_DATE
, ACTUAL_SHIPMENT_DATE
, AGREEMENT_ID
, ARRIVAL_SET_ID
, ATO_LINE_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16 --For bug 2184255
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE2
, ATTRIBUTE20
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTO_SELECTED_QUANTITY
, AUTHORIZED_TO_SHIP_FLAG
, BOOKED_FLAG
, CANCELLED_FLAG
, CANCELLED_QUANTITY
, COMPONENT_CODE
, COMPONENT_NUMBER
, COMPONENT_SEQUENCE_ID
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, CONFIG_DISPLAY_SEQUENCE
, CONFIGURATION_ID
, CONTEXT
, CREATED_BY
, CREATION_DATE
, CREDIT_INVOICE_LINE_ID
, CUSTOMER_DOCK_CODE
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUST_PRODUCTION_SEQ_NUM
, CUSTOMER_TRX_LINE_ID
, CUST_MODEL_SERIAL_NUMBER
, CUST_PO_NUMBER
, CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_NET_PRICE
, DELIVERY_LEAD_TIME
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG_ID
, DEMAND_BUCKET_TYPE_CODE
, DEMAND_CLASS_CODE
, DEP_PLAN_REQUIRED_FLAG
, EARLIEST_ACCEPTABLE_DATE
, END_ITEM_UNIT_NUMBER
, EXPLOSION_DATE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, FULFILLED_QUANTITY
, FULFILLED_FLAG
, FULFILLMENT_METHOD_CODE
, FULFILLMENT_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, HEADER_ID
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_CONTEXT
, INTMED_SHIP_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID
, INVENTORY_ITEM_ID
, INVOICE_INTERFACE_STATUS_CODE
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG_ID
, INVOICED_QUANTITY
, INVOICING_RULE_ID
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, ORDERED_ITEM
, ITEM_REVISION
, ITEM_TYPE_CODE
, LAST_ACK_CODE
, LAST_ACK_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LATEST_ACCEPTABLE_DATE
, LINE_CATEGORY_CODE
, LINE_ID
, LINE_NUMBER
, LINE_TYPE_ID
, LINK_TO_LINE_ID
, MODEL_GROUP_NUMBER
-- , MFG_COMPONENT_SEQUENCE_ID
, MFG_LEAD_TIME
, OPEN_FLAG
, OPTION_FLAG
, OPTION_NUMBER
, ORDERED_QUANTITY
, ORDERED_QUANTITY2 --OPM 02/JUN/00
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
, ORG_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, PAYMENT_TERM_ID
, PLANNING_PRIORITY
, PREFERRED_GRADE --OPM 02/JUN/00
, PRICE_LIST_ID
, PRICE_REQUEST_CODE --PROMOTIONS SEP/01
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_CONTEXT
, PRICING_DATE
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, PROMISE_DATE
, RE_SOURCE_FLAG
, REFERENCE_CUSTOMER_TRX_LINE_ID
, REFERENCE_HEADER_ID
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, REQUEST_DATE
, REQUEST_ID
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_CONTEXT
, RETURN_REASON_CODE
, RLA_SCHEDULE_TYPE_CODE
, SALESREP_ID
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SCHEDULE_STATUS_CODE
, SHIPMENT_NUMBER
, SHIPMENT_PRIORITY_CODE
, SHIPPED_QUANTITY
, SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, SHIPPING_QUANTITY_UOM
, SHIPPING_QUANTITY_UOM2 -- INVCONV
, SHIP_FROM_ORG_ID
, SUBINVENTORY
, SHIP_SET_ID
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIPPABLE_FLAG
, SHIPPING_INTERFACED_FLAG
, SHIP_TO_CONTACT_ID
, SHIP_TO_ORG_ID
, SHIP_MODEL_COMPLETE_FLAG
, SOLD_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SORT_ORDER
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID
, SOURCE_DOCUMENT_TYPE_ID
, SOURCE_TYPE_CODE
, SPLIT_FROM_LINE_ID
, LINE_SET_ID
, SPLIT_BY
, MODEL_REMNANT_FLAG
, TASK_ID
, TAX_CODE
, TAX_DATE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_POINT_CODE
, TAX_RATE
, TAX_VALUE
, TOP_MODEL_LINE_ID
, UNIT_LIST_PRICE
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE
, UNIT_SELLING_PRICE_PER_PQTY
, VISIBLE_DEMAND_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_PERIOD
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, FLOW_STATUS_CODE
, MARKETING_SOURCE_CODE_ID
, CALCULATE_PRICE_FLAG
, COMMITMENT_ID
, ORDER_SOURCE_ID -- aksingh
, upgraded_flag
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ITEM_RELATIONSHIP_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE
, LATE_DEMAND_PENALTY_FACTOR
, OVERRIDE_ATP_DATE_CODE
, FIRM_DEMAND_FLAG
, EARLIEST_SHIP_DATE
, USER_ITEM_DESCRIPTION
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
, BLANKET_VERSION_NUMBER
--MRG B
, UNIT_COST
--MRG E
, LOCK_CONTROL
, NVL(OPTION_NUMBER, -1) OPN
, NVL(COMPONENT_NUMBER, -1) CPN
, NVL(SERVICE_NUMBER, -1) SVN
, CHANGE_SEQUENCE
-- Changes to quoting
, transaction_phase_code
, source_document_version_number
-- End changes to quoting
, MINISITE_ID
, Ib_Owner
, Ib_installed_at_location
, Ib_current_location
, End_customer_ID
, End_customer_contact_ID
, End_customer_site_use_ID
/* , Supplier_signature
, Supplier_signature_date
, Customer_signature
, Customer_signature_date */
--retro{
, RETROBILL_REQUEST_ID
--retro}
, ORIGINAL_LIST_PRICE -- Override List Price
-- key Transaction Dates
, order_firmed_date
, actual_fulfillment_date
--recurring charges
, charge_periodicity_code
-- INVCONV
, CANCELLED_QUANTITY2
, FULFILLED_QUANTITY2
--Customer Acceptance
,CONTINGENCY_ID
,REVREC_EVENT_CODE
,REVREC_EXPIRATION_DAYS
,ACCEPTED_QUANTITY
,REVREC_COMMENTS
,REVREC_SIGNATURE
,REVREC_SIGNATURE_DATE
,ACCEPTED_BY
,REVREC_REFERENCE_DOCUMENT
,REVREC_IMPLICIT_FLAG
FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
WHERE HEADER_ID = p_header_id
ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
SELECT ACCOUNTING_RULE_ID
, ACCOUNTING_RULE_DURATION
, ACTUAL_ARRIVAL_DATE
, ACTUAL_SHIPMENT_DATE
, AGREEMENT_ID
, ARRIVAL_SET_ID
, ATO_LINE_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16 --For bug 2184255
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE2
, ATTRIBUTE20
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTO_SELECTED_QUANTITY
, AUTHORIZED_TO_SHIP_FLAG
, BOOKED_FLAG
, CANCELLED_FLAG
, CANCELLED_QUANTITY
, COMPONENT_CODE
, COMPONENT_NUMBER
, COMPONENT_SEQUENCE_ID
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, CONFIG_DISPLAY_SEQUENCE
, CONFIGURATION_ID
, CONTEXT
, CREATED_BY
, CREATION_DATE
, CREDIT_INVOICE_LINE_ID
, CUSTOMER_DOCK_CODE
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUST_PRODUCTION_SEQ_NUM
, CUSTOMER_TRX_LINE_ID
, CUST_MODEL_SERIAL_NUMBER
, CUST_PO_NUMBER
, CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_NET_PRICE
, DELIVERY_LEAD_TIME
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG_ID
, DEMAND_BUCKET_TYPE_CODE
, DEMAND_CLASS_CODE
, DEP_PLAN_REQUIRED_FLAG
, EARLIEST_ACCEPTABLE_DATE
, END_ITEM_UNIT_NUMBER
, EXPLOSION_DATE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, FULFILLED_QUANTITY
, FULFILLED_FLAG
, FULFILLMENT_METHOD_CODE
, FULFILLMENT_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE_CATEGORY
, HEADER_ID
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_CONTEXT
, INTMED_SHIP_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID
, INVENTORY_ITEM_ID
, INVOICE_INTERFACE_STATUS_CODE
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG_ID
, INVOICED_QUANTITY
, INVOICING_RULE_ID
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, ORDERED_ITEM
, ITEM_REVISION
, ITEM_TYPE_CODE
, LAST_ACK_CODE
, LAST_ACK_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LATEST_ACCEPTABLE_DATE
, LINE_CATEGORY_CODE
, LINE_ID
, LINE_NUMBER
, LINE_TYPE_ID
, LINK_TO_LINE_ID
, MODEL_GROUP_NUMBER
-- , MFG_COMPONENT_SEQUENCE_ID
, MFG_LEAD_TIME
, OPEN_FLAG
, OPTION_FLAG
, OPTION_NUMBER
, ORDERED_QUANTITY
, ORDERED_QUANTITY2 --OPM 02/JUN/00
, ORDER_QUANTITY_UOM
, ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
, ORG_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, PAYMENT_TERM_ID
, PLANNING_PRIORITY
, PREFERRED_GRADE --OPM 02/JUN/00
, PRICE_LIST_ID
, PRICE_REQUEST_CODE --PROMOTIONS SEP/01
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_CONTEXT
, PRICING_DATE
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, PROMISE_DATE
, RE_SOURCE_FLAG
, REFERENCE_CUSTOMER_TRX_LINE_ID
, REFERENCE_HEADER_ID
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, REQUEST_DATE
, REQUEST_ID
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_CONTEXT
, RETURN_REASON_CODE
, RLA_SCHEDULE_TYPE_CODE
, SALESREP_ID
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SCHEDULE_STATUS_CODE
, SHIPMENT_NUMBER
, SHIPMENT_PRIORITY_CODE
, SHIPPED_QUANTITY
, SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, SHIPPING_QUANTITY_UOM
, SHIPPING_QUANTITY_UOM2 -- INVCONV
, SHIP_FROM_ORG_ID
, SUBINVENTORY
, SHIP_SET_ID
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIPPABLE_FLAG
, SHIPPING_INTERFACED_FLAG
, SHIP_TO_CONTACT_ID
, SHIP_TO_ORG_ID
, SHIP_MODEL_COMPLETE_FLAG
, SOLD_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SORT_ORDER
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID
, SOURCE_DOCUMENT_TYPE_ID
, SOURCE_TYPE_CODE
, SPLIT_FROM_LINE_ID
, LINE_SET_ID
, SPLIT_BY
, MODEL_REMNANT_FLAG
, TASK_ID
, TAX_CODE
, TAX_DATE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_POINT_CODE
, TAX_RATE
, TAX_VALUE
, TOP_MODEL_LINE_ID
, UNIT_LIST_PRICE
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE
, UNIT_SELLING_PRICE_PER_PQTY
, VISIBLE_DEMAND_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_PERIOD
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, FLOW_STATUS_CODE
, MARKETING_SOURCE_CODE_ID
, CALCULATE_PRICE_FLAG
, COMMITMENT_ID
, ORDER_SOURCE_ID -- aksingh
, upgraded_flag
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ITEM_RELATIONSHIP_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE
, LATE_DEMAND_PENALTY_FACTOR
, OVERRIDE_ATP_DATE_CODE
, FIRM_DEMAND_FLAG
, EARLIEST_SHIP_DATE
, USER_ITEM_DESCRIPTION
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
, BLANKET_VERSION_NUMBER
--MRG B
, UNIT_COST
--MRG E
, LOCK_CONTROL
, NVL(OPTION_NUMBER, -1) OPN
, NVL(COMPONENT_NUMBER, -1) CPN
, NVL(SERVICE_NUMBER, -1) SVN
, CHANGE_SEQUENCE
-- Changes to quoting
, transaction_phase_code
, source_document_version_number
-- End changes to quoting
, MINISITE_ID
, Ib_Owner
, Ib_installed_at_location
, Ib_current_location
, End_customer_ID
, End_customer_contact_ID
, End_customer_site_use_ID
/* , Supplier_signature
, Supplier_signature_date
, Customer_signature
, Customer_signature_date */
--retro{
, RETROBILL_REQUEST_ID
--retro}
, ORIGINAL_LIST_PRICE -- Override List Price
-- key Transaction Dates
, order_firmed_date
, actual_fulfillment_date
--recurring charges
, charge_periodicity_code
-- INVCONV
, CANCELLED_QUANTITY2
, FULFILLED_QUANTITY2
--Customer Acceptance
,CONTINGENCY_ID
,REVREC_EVENT_CODE
,REVREC_EXPIRATION_DAYS
,ACCEPTED_QUANTITY
,REVREC_COMMENTS
,REVREC_SIGNATURE
,REVREC_SIGNATURE_DATE
,ACCEPTED_BY
,REVREC_REFERENCE_DOCUMENT
,REVREC_IMPLICIT_FLAG
FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
WHERE LINE_SET_ID = p_line_set_id
ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
, x_line_tbl(i).AUTO_SELECTED_QUANTITY
, x_line_tbl(i).AUTHORIZED_TO_SHIP_FLAG
, x_line_tbl(i).BOOKED_FLAG
, x_line_tbl(i).CANCELLED_FLAG
, x_line_tbl(i).CANCELLED_QUANTITY
, x_line_tbl(i).COMPONENT_CODE
, x_line_tbl(i).COMPONENT_NUMBER
, x_line_tbl(i).COMPONENT_SEQUENCE_ID
, x_line_tbl(i).CONFIG_HEADER_ID
, x_line_tbl(i).CONFIG_REV_NBR
, x_line_tbl(i).CONFIG_DISPLAY_SEQUENCE
, x_line_tbl(i).CONFIGURATION_ID
, x_line_tbl(i).CONTEXT
, x_line_tbl(i).CREATED_BY
, x_line_tbl(i).CREATION_DATE
, x_line_tbl(i).CREDIT_INVOICE_LINE_ID
, x_line_tbl(i).CUSTOMER_DOCK_CODE
, x_line_tbl(i).CUSTOMER_JOB
, x_line_tbl(i).CUSTOMER_PRODUCTION_LINE
, x_line_tbl(i).CUST_PRODUCTION_SEQ_NUM
, x_line_tbl(i).CUSTOMER_TRX_LINE_ID
, x_line_tbl(i).CUST_MODEL_SERIAL_NUMBER
, x_line_tbl(i).CUST_PO_NUMBER
, x_line_tbl(i).CUSTOMER_LINE_NUMBER
, x_line_tbl(i).CUSTOMER_SHIPMENT_NUMBER
, x_line_tbl(i).CUSTOMER_ITEM_NET_PRICE
, x_line_tbl(i).DELIVERY_LEAD_TIME
, x_line_tbl(i).DELIVER_TO_CONTACT_ID
, x_line_tbl(i).DELIVER_TO_ORG_ID
, x_line_tbl(i).DEMAND_BUCKET_TYPE_CODE
, x_line_tbl(i).DEMAND_CLASS_CODE
, x_line_tbl(i).DEP_PLAN_REQUIRED_FLAG
, x_line_tbl(i).EARLIEST_ACCEPTABLE_DATE
, x_line_tbl(i).END_ITEM_UNIT_NUMBER
, x_line_tbl(i).EXPLOSION_DATE
, x_line_tbl(i).FIRST_ACK_CODE
, x_line_tbl(i).FIRST_ACK_DATE
, x_line_tbl(i).FOB_POINT_CODE
, x_line_tbl(i).FREIGHT_CARRIER_CODE
, x_line_tbl(i).FREIGHT_TERMS_CODE
, x_line_tbl(i).FULFILLED_QUANTITY
, x_line_tbl(i).FULFILLED_FLAG
, x_line_tbl(i).FULFILLMENT_METHOD_CODE
, x_line_tbl(i).FULFILLMENT_DATE
, x_line_tbl(i).GLOBAL_ATTRIBUTE1
, x_line_tbl(i).GLOBAL_ATTRIBUTE10
, x_line_tbl(i).GLOBAL_ATTRIBUTE11
, x_line_tbl(i).GLOBAL_ATTRIBUTE12
, x_line_tbl(i).GLOBAL_ATTRIBUTE13
, x_line_tbl(i).GLOBAL_ATTRIBUTE14
, x_line_tbl(i).GLOBAL_ATTRIBUTE15
, x_line_tbl(i).GLOBAL_ATTRIBUTE16
, x_line_tbl(i).GLOBAL_ATTRIBUTE17
, x_line_tbl(i).GLOBAL_ATTRIBUTE18
, x_line_tbl(i).GLOBAL_ATTRIBUTE19
, x_line_tbl(i).GLOBAL_ATTRIBUTE2
, x_line_tbl(i).GLOBAL_ATTRIBUTE20
, x_line_tbl(i).GLOBAL_ATTRIBUTE3
, x_line_tbl(i).GLOBAL_ATTRIBUTE4
, x_line_tbl(i).GLOBAL_ATTRIBUTE5
, x_line_tbl(i).GLOBAL_ATTRIBUTE6
, x_line_tbl(i).GLOBAL_ATTRIBUTE7
, x_line_tbl(i).GLOBAL_ATTRIBUTE8
, x_line_tbl(i).GLOBAL_ATTRIBUTE9
, x_line_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY
, x_line_tbl(i).HEADER_ID
, x_line_tbl(i).INDUSTRY_ATTRIBUTE1
, x_line_tbl(i).INDUSTRY_ATTRIBUTE10
, x_line_tbl(i).INDUSTRY_ATTRIBUTE11
, x_line_tbl(i).INDUSTRY_ATTRIBUTE12
, x_line_tbl(i).INDUSTRY_ATTRIBUTE13
, x_line_tbl(i).INDUSTRY_ATTRIBUTE14
, x_line_tbl(i).INDUSTRY_ATTRIBUTE15
, x_line_tbl(i).INDUSTRY_ATTRIBUTE16
, x_line_tbl(i).INDUSTRY_ATTRIBUTE17
, x_line_tbl(i).INDUSTRY_ATTRIBUTE18
, x_line_tbl(i).INDUSTRY_ATTRIBUTE19
, x_line_tbl(i).INDUSTRY_ATTRIBUTE20
, x_line_tbl(i).INDUSTRY_ATTRIBUTE21
, x_line_tbl(i).INDUSTRY_ATTRIBUTE22
, x_line_tbl(i).INDUSTRY_ATTRIBUTE23
, x_line_tbl(i).INDUSTRY_ATTRIBUTE24
, x_line_tbl(i).INDUSTRY_ATTRIBUTE25
, x_line_tbl(i).INDUSTRY_ATTRIBUTE26
, x_line_tbl(i).INDUSTRY_ATTRIBUTE27
, x_line_tbl(i).INDUSTRY_ATTRIBUTE28
, x_line_tbl(i).INDUSTRY_ATTRIBUTE29
, x_line_tbl(i).INDUSTRY_ATTRIBUTE30
, x_line_tbl(i).INDUSTRY_ATTRIBUTE2
, x_line_tbl(i).INDUSTRY_ATTRIBUTE3
, x_line_tbl(i).INDUSTRY_ATTRIBUTE4
, x_line_tbl(i).INDUSTRY_ATTRIBUTE5
, x_line_tbl(i).INDUSTRY_ATTRIBUTE6
, x_line_tbl(i).INDUSTRY_ATTRIBUTE7
, x_line_tbl(i).INDUSTRY_ATTRIBUTE8
, x_line_tbl(i).INDUSTRY_ATTRIBUTE9
, x_line_tbl(i).INDUSTRY_CONTEXT
, x_line_tbl(i).INTERMED_SHIP_TO_CONTACT_ID
, x_line_tbl(i).INTERMED_SHIP_TO_ORG_ID
, x_line_tbl(i).INVENTORY_ITEM_ID
, x_line_tbl(i).INVOICE_INTERFACE_STATUS_CODE
, x_line_tbl(i).INVOICE_TO_CONTACT_ID
, x_line_tbl(i).INVOICE_TO_ORG_ID
, x_line_tbl(i).INVOICED_QUANTITY
, x_line_tbl(i).INVOICING_RULE_ID
, x_line_tbl(i).ORDERED_ITEM_ID
, x_line_tbl(i).ITEM_IDENTIFIER_TYPE
, x_line_tbl(i).ORDERED_ITEM
, x_line_tbl(i).ITEM_REVISION
, x_line_tbl(i).ITEM_TYPE_CODE
, x_line_tbl(i).LAST_ACK_CODE
, x_line_tbl(i).LAST_ACK_DATE
, x_line_tbl(i).LAST_UPDATED_BY
, x_line_tbl(i).LAST_UPDATE_DATE
, x_line_tbl(i).LAST_UPDATE_LOGIN
, x_line_tbl(i).LATEST_ACCEPTABLE_DATE
, x_line_tbl(i).LINE_CATEGORY_CODE
, x_line_tbl(i).LINE_ID
, x_line_tbl(i).LINE_NUMBER
, x_line_tbl(i).LINE_TYPE_ID
, x_line_tbl(i).LINK_TO_LINE_ID
, x_line_tbl(i).MODEL_GROUP_NUMBER
-- , x_line_tbl(i).MFG_COMPONENT_SEQUENCE_ID
, x_line_tbl(i).MFG_LEAD_TIME
, x_line_tbl(i).OPEN_FLAG
, x_line_tbl(i).OPTION_FLAG
, x_line_tbl(i).OPTION_NUMBER
, x_line_tbl(i).ORDERED_QUANTITY
, x_line_tbl(i).ORDERED_QUANTITY2 --OPM 02/JUN/00
, x_line_tbl(i).ORDER_QUANTITY_UOM
, x_line_tbl(i).ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
, x_line_tbl(i).ORG_ID
, x_line_tbl(i).ORIG_SYS_DOCUMENT_REF
, x_line_tbl(i).ORIG_SYS_LINE_REF
, x_line_tbl(i).ORIG_SYS_SHIPMENT_REF
, x_line_tbl(i).OVER_SHIP_REASON_CODE
, x_line_tbl(i).OVER_SHIP_RESOLVED_FLAG
, x_line_tbl(i).PAYMENT_TERM_ID
, x_line_tbl(i).PLANNING_PRIORITY
, x_line_tbl(i).PREFERRED_GRADE --OPM 02/JUN/00
, x_line_tbl(i).PRICE_LIST_ID
, x_line_tbl(i).PRICE_REQUEST_CODE --PROMOTIONS MAY/01
, x_line_tbl(i).PRICING_ATTRIBUTE1
, x_line_tbl(i).PRICING_ATTRIBUTE10
, x_line_tbl(i).PRICING_ATTRIBUTE2
, x_line_tbl(i).PRICING_ATTRIBUTE3
, x_line_tbl(i).PRICING_ATTRIBUTE4
, x_line_tbl(i).PRICING_ATTRIBUTE5
, x_line_tbl(i).PRICING_ATTRIBUTE6
, x_line_tbl(i).PRICING_ATTRIBUTE7
, x_line_tbl(i).PRICING_ATTRIBUTE8
, x_line_tbl(i).PRICING_ATTRIBUTE9
, x_line_tbl(i).PRICING_CONTEXT
, x_line_tbl(i).PRICING_DATE
, x_line_tbl(i).PRICING_QUANTITY
, x_line_tbl(i).PRICING_QUANTITY_UOM
, x_line_tbl(i).PROGRAM_APPLICATION_ID
, x_line_tbl(i).PROGRAM_ID
, x_line_tbl(i).PROGRAM_UPDATE_DATE
, x_line_tbl(i).PROJECT_ID
, x_line_tbl(i).PROMISE_DATE
, x_line_tbl(i).RE_SOURCE_FLAG
, x_line_tbl(i).REFERENCE_CUSTOMER_TRX_LINE_ID
, x_line_tbl(i).REFERENCE_HEADER_ID
, x_line_tbl(i).REFERENCE_LINE_ID
, x_line_tbl(i).REFERENCE_TYPE
, x_line_tbl(i).REQUEST_DATE
, x_line_tbl(i).REQUEST_ID
, x_line_tbl(i).RETURN_ATTRIBUTE1
, x_line_tbl(i).RETURN_ATTRIBUTE10
, x_line_tbl(i).RETURN_ATTRIBUTE11
, x_line_tbl(i).RETURN_ATTRIBUTE12
, x_line_tbl(i).RETURN_ATTRIBUTE13
, x_line_tbl(i).RETURN_ATTRIBUTE14
, x_line_tbl(i).RETURN_ATTRIBUTE15
, x_line_tbl(i).RETURN_ATTRIBUTE2
, x_line_tbl(i).RETURN_ATTRIBUTE3
, x_line_tbl(i).RETURN_ATTRIBUTE4
, x_line_tbl(i).RETURN_ATTRIBUTE5
, x_line_tbl(i).RETURN_ATTRIBUTE6
, x_line_tbl(i).RETURN_ATTRIBUTE7
, x_line_tbl(i).RETURN_ATTRIBUTE8
, x_line_tbl(i).RETURN_ATTRIBUTE9
, x_line_tbl(i).RETURN_CONTEXT
, x_line_tbl(i).RETURN_REASON_CODE
, x_line_tbl(i).RLA_SCHEDULE_TYPE_CODE
, x_line_tbl(i).SALESREP_ID
, x_line_tbl(i).SCHEDULE_ARRIVAL_DATE
, x_line_tbl(i).SCHEDULE_SHIP_DATE
, x_line_tbl(i).SCHEDULE_STATUS_CODE
, x_line_tbl(i).SHIPMENT_NUMBER
, x_line_tbl(i).SHIPMENT_PRIORITY_CODE
, x_line_tbl(i).SHIPPED_QUANTITY
, x_line_tbl(i).SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
, x_line_tbl(i).SHIPPING_METHOD_CODE
, x_line_tbl(i).SHIPPING_QUANTITY
, x_line_tbl(i).SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, x_line_tbl(i).SHIPPING_QUANTITY_UOM
, x_line_tbl(i).SHIPPING_QUANTITY_UOM2
, x_line_tbl(i).SHIP_FROM_ORG_ID
, x_line_tbl(i).SUBINVENTORY
, x_line_tbl(i).SHIP_SET_ID
, x_line_tbl(i).SHIP_TOLERANCE_ABOVE
, x_line_tbl(i).SHIP_TOLERANCE_BELOW
, x_line_tbl(i).SHIPPABLE_FLAG
, x_line_tbl(i).SHIPPING_INTERFACED_FLAG
, x_line_tbl(i).SHIP_TO_CONTACT_ID
, x_line_tbl(i).SHIP_TO_ORG_ID
, x_line_tbl(i).SHIP_MODEL_COMPLETE_FLAG
, x_line_tbl(i).SOLD_TO_ORG_ID
, x_line_tbl(i).SOLD_FROM_ORG_ID
, x_line_tbl(i).SORT_ORDER
, x_line_tbl(i).SOURCE_DOCUMENT_ID
, x_line_tbl(i).SOURCE_DOCUMENT_LINE_ID
, x_line_tbl(i).SOURCE_DOCUMENT_TYPE_ID
, x_line_tbl(i).SOURCE_TYPE_CODE
, x_line_tbl(i).SPLIT_FROM_LINE_ID
, x_line_tbl(i).LINE_SET_ID
, x_line_tbl(i).SPLIT_BY
, x_line_tbl(i).MODEL_REMNANT_FLAG
, x_line_tbl(i).TASK_ID
, x_line_tbl(i).TAX_CODE
, x_line_tbl(i).TAX_DATE
, x_line_tbl(i).TAX_EXEMPT_FLAG
, x_line_tbl(i).TAX_EXEMPT_NUMBER
, x_line_tbl(i).TAX_EXEMPT_REASON_CODE
, x_line_tbl(i).TAX_POINT_CODE
, x_line_tbl(i).TAX_RATE
, x_line_tbl(i).TAX_VALUE
, x_line_tbl(i).TOP_MODEL_LINE_ID
, x_line_tbl(i).UNIT_LIST_PRICE
, x_line_tbl(i).UNIT_LIST_PRICE_PER_PQTY
, x_line_tbl(i).UNIT_SELLING_PRICE
, x_line_tbl(i).UNIT_SELLING_PRICE_PER_PQTY
, x_line_tbl(i).VISIBLE_DEMAND_FLAG
, x_line_tbl(i).VEH_CUS_ITEM_CUM_KEY_ID
, x_line_tbl(i).SHIPPING_INSTRUCTIONS
, x_line_tbl(i).PACKING_INSTRUCTIONS
, x_line_tbl(i).SERVICE_TXN_REASON_CODE
, x_line_tbl(i).SERVICE_TXN_COMMENTS
, x_line_tbl(i).SERVICE_DURATION
, x_line_tbl(i).SERVICE_PERIOD
, x_line_tbl(i).SERVICE_START_DATE
, x_line_tbl(i).SERVICE_END_DATE
, x_line_tbl(i).SERVICE_COTERMINATE_FLAG
, x_line_tbl(i).UNIT_LIST_PERCENT
, x_line_tbl(i).UNIT_SELLING_PERCENT
, x_line_tbl(i).UNIT_PERCENT_BASE_PRICE
, x_line_tbl(i).SERVICE_NUMBER
, x_line_tbl(i).SERVICE_REFERENCE_TYPE_CODE
, x_line_tbl(i).SERVICE_REFERENCE_LINE_ID
, x_line_tbl(i).SERVICE_REFERENCE_SYSTEM_ID
, x_line_tbl(i).TP_CONTEXT
, x_line_tbl(i).TP_ATTRIBUTE1
, x_line_tbl(i).TP_ATTRIBUTE2
, x_line_tbl(i).TP_ATTRIBUTE3
, x_line_tbl(i).TP_ATTRIBUTE4
, x_line_tbl(i).TP_ATTRIBUTE5
, x_line_tbl(i).TP_ATTRIBUTE6
, x_line_tbl(i).TP_ATTRIBUTE7
, x_line_tbl(i).TP_ATTRIBUTE8
, x_line_tbl(i).TP_ATTRIBUTE9
, x_line_tbl(i).TP_ATTRIBUTE10
, x_line_tbl(i).TP_ATTRIBUTE11
, x_line_tbl(i).TP_ATTRIBUTE12
, x_line_tbl(i).TP_ATTRIBUTE13
, x_line_tbl(i).TP_ATTRIBUTE14
, x_line_tbl(i).TP_ATTRIBUTE15
, x_line_tbl(i).FLOW_STATUS_CODE
, x_line_tbl(i).MARKETING_SOURCE_CODE_ID
, x_line_tbl(i).CALCULATE_PRICE_FLAG
, x_line_tbl(i).COMMITMENT_ID
, x_line_tbl(i).ORDER_SOURCE_ID -- aksingh
, x_line_tbl(i).UPGRADED_FLAG
, x_line_tbl(i).ORIGINAL_INVENTORY_ITEM_ID
, x_line_tbl(i).ORIGINAL_ITEM_IDENTIFIER_TYPE
, x_line_tbl(i).ORIGINAL_ORDERED_ITEM_ID
, x_line_tbl(i).ORIGINAL_ORDERED_ITEM
, x_line_tbl(i).ITEM_RELATIONSHIP_TYPE
, x_line_tbl(i).ITEM_SUBSTITUTION_TYPE_CODE
, x_line_tbl(i).LATE_DEMAND_PENALTY_FACTOR
, x_line_tbl(i).OVERRIDE_ATP_DATE_CODE
, x_line_tbl(i).FIRM_DEMAND_FLAG
, x_line_tbl(i).EARLIEST_SHIP_DATE
, x_line_tbl(i).USER_ITEM_DESCRIPTION
, x_line_tbl(i).BLANKET_NUMBER
, x_line_tbl(i).BLANKET_LINE_NUMBER
, x_line_tbl(i).BLANKET_VERSION_NUMBER
, x_line_tbl(i).UNIT_COST
, x_line_tbl(i).LOCK_CONTROL
, l_opn --OPN
, l_cpn --CPN
, l_svn --SVN
, x_line_tbl(i).CHANGE_SEQUENCE
, x_line_tbl(i).transaction_phase_code
, x_line_tbl(i).source_document_version_number
, x_line_tbl(i).MINISITE_ID
, x_line_tbl(i).Ib_Owner
, x_line_tbl(i).Ib_installed_at_location
, x_line_tbl(i).Ib_current_location
, x_line_tbl(i).End_customer_ID
, x_line_tbl(i).End_customer_contact_ID
, x_line_tbl(i).End_customer_site_use_ID
, x_line_tbl(i).RETROBILL_REQUEST_ID
, x_line_tbl(i).ORIGINAL_LIST_PRICE -- Override List Price
, x_line_tbl(i).order_firmed_date
, x_line_tbl(i).actual_fulfillment_date
, x_line_tbl(i).charge_periodicity_code
, x_line_tbl(i).cancelled_quantity2
, x_line_tbl(i).fulfilled_quantity2
, x_line_tbl(i).CONTINGENCY_ID
, x_line_tbl(i).REVREC_EVENT_CODE
, x_line_tbl(i).REVREC_EXPIRATION_DAYS
, x_line_tbl(i).ACCEPTED_QUANTITY
, x_line_tbl(i).REVREC_COMMENTS
, x_line_tbl(i).REVREC_SIGNATURE
, x_line_tbl(i).REVREC_SIGNATURE_DATE
, x_line_tbl(i).ACCEPTED_BY
, x_line_tbl(i).REVREC_REFERENCE_DOCUMENT
, x_line_tbl(i).REVREC_IMPLICIT_FLAG;
, x_line_tbl(i).AUTO_SELECTED_QUANTITY
, x_line_tbl(i).AUTHORIZED_TO_SHIP_FLAG
, x_line_tbl(i).BOOKED_FLAG
, x_line_tbl(i).CANCELLED_FLAG
, x_line_tbl(i).CANCELLED_QUANTITY
, x_line_tbl(i).COMPONENT_CODE
, x_line_tbl(i).COMPONENT_NUMBER
, x_line_tbl(i).COMPONENT_SEQUENCE_ID
, x_line_tbl(i).CONFIG_HEADER_ID
, x_line_tbl(i).CONFIG_REV_NBR
, x_line_tbl(i).CONFIG_DISPLAY_SEQUENCE
, x_line_tbl(i).CONFIGURATION_ID
, x_line_tbl(i).CONTEXT
, x_line_tbl(i).CREATED_BY
, x_line_tbl(i).CREATION_DATE
, x_line_tbl(i).CREDIT_INVOICE_LINE_ID
, x_line_tbl(i).CUSTOMER_DOCK_CODE
, x_line_tbl(i).CUSTOMER_JOB
, x_line_tbl(i).CUSTOMER_PRODUCTION_LINE
, x_line_tbl(i).CUST_PRODUCTION_SEQ_NUM
, x_line_tbl(i).CUSTOMER_TRX_LINE_ID
, x_line_tbl(i).CUST_MODEL_SERIAL_NUMBER
, x_line_tbl(i).CUST_PO_NUMBER
, x_line_tbl(i).CUSTOMER_LINE_NUMBER
, x_line_tbl(i).CUSTOMER_SHIPMENT_NUMBER
, x_line_tbl(i).CUSTOMER_ITEM_NET_PRICE
, x_line_tbl(i).DELIVERY_LEAD_TIME
, x_line_tbl(i).DELIVER_TO_CONTACT_ID
, x_line_tbl(i).DELIVER_TO_ORG_ID
, x_line_tbl(i).DEMAND_BUCKET_TYPE_CODE
, x_line_tbl(i).DEMAND_CLASS_CODE
, x_line_tbl(i).DEP_PLAN_REQUIRED_FLAG
, x_line_tbl(i).EARLIEST_ACCEPTABLE_DATE
, x_line_tbl(i).END_ITEM_UNIT_NUMBER
, x_line_tbl(i).EXPLOSION_DATE
, x_line_tbl(i).FIRST_ACK_CODE
, x_line_tbl(i).FIRST_ACK_DATE
, x_line_tbl(i).FOB_POINT_CODE
, x_line_tbl(i).FREIGHT_CARRIER_CODE
, x_line_tbl(i).FREIGHT_TERMS_CODE
, x_line_tbl(i).FULFILLED_QUANTITY
, x_line_tbl(i).FULFILLED_FLAG
, x_line_tbl(i).FULFILLMENT_METHOD_CODE
, x_line_tbl(i).FULFILLMENT_DATE
, x_line_tbl(i).GLOBAL_ATTRIBUTE1
, x_line_tbl(i).GLOBAL_ATTRIBUTE10
, x_line_tbl(i).GLOBAL_ATTRIBUTE11
, x_line_tbl(i).GLOBAL_ATTRIBUTE12
, x_line_tbl(i).GLOBAL_ATTRIBUTE13
, x_line_tbl(i).GLOBAL_ATTRIBUTE14
, x_line_tbl(i).GLOBAL_ATTRIBUTE15
, x_line_tbl(i).GLOBAL_ATTRIBUTE16
, x_line_tbl(i).GLOBAL_ATTRIBUTE17
, x_line_tbl(i).GLOBAL_ATTRIBUTE18
, x_line_tbl(i).GLOBAL_ATTRIBUTE19
, x_line_tbl(i).GLOBAL_ATTRIBUTE2
, x_line_tbl(i).GLOBAL_ATTRIBUTE20
, x_line_tbl(i).GLOBAL_ATTRIBUTE3
, x_line_tbl(i).GLOBAL_ATTRIBUTE4
, x_line_tbl(i).GLOBAL_ATTRIBUTE5
, x_line_tbl(i).GLOBAL_ATTRIBUTE6
, x_line_tbl(i).GLOBAL_ATTRIBUTE7
, x_line_tbl(i).GLOBAL_ATTRIBUTE8
, x_line_tbl(i).GLOBAL_ATTRIBUTE9
, x_line_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY
, x_line_tbl(i).HEADER_ID
, x_line_tbl(i).INDUSTRY_ATTRIBUTE1
, x_line_tbl(i).INDUSTRY_ATTRIBUTE10
, x_line_tbl(i).INDUSTRY_ATTRIBUTE11
, x_line_tbl(i).INDUSTRY_ATTRIBUTE12
, x_line_tbl(i).INDUSTRY_ATTRIBUTE13
, x_line_tbl(i).INDUSTRY_ATTRIBUTE14
, x_line_tbl(i).INDUSTRY_ATTRIBUTE15
, x_line_tbl(i).INDUSTRY_ATTRIBUTE16
, x_line_tbl(i).INDUSTRY_ATTRIBUTE17
, x_line_tbl(i).INDUSTRY_ATTRIBUTE18
, x_line_tbl(i).INDUSTRY_ATTRIBUTE19
, x_line_tbl(i).INDUSTRY_ATTRIBUTE20
, x_line_tbl(i).INDUSTRY_ATTRIBUTE21
, x_line_tbl(i).INDUSTRY_ATTRIBUTE22
, x_line_tbl(i).INDUSTRY_ATTRIBUTE23
, x_line_tbl(i).INDUSTRY_ATTRIBUTE24
, x_line_tbl(i).INDUSTRY_ATTRIBUTE25
, x_line_tbl(i).INDUSTRY_ATTRIBUTE26
, x_line_tbl(i).INDUSTRY_ATTRIBUTE27
, x_line_tbl(i).INDUSTRY_ATTRIBUTE28
, x_line_tbl(i).INDUSTRY_ATTRIBUTE29
, x_line_tbl(i).INDUSTRY_ATTRIBUTE30
, x_line_tbl(i).INDUSTRY_ATTRIBUTE2
, x_line_tbl(i).INDUSTRY_ATTRIBUTE3
, x_line_tbl(i).INDUSTRY_ATTRIBUTE4
, x_line_tbl(i).INDUSTRY_ATTRIBUTE5
, x_line_tbl(i).INDUSTRY_ATTRIBUTE6
, x_line_tbl(i).INDUSTRY_ATTRIBUTE7
, x_line_tbl(i).INDUSTRY_ATTRIBUTE8
, x_line_tbl(i).INDUSTRY_ATTRIBUTE9
, x_line_tbl(i).INDUSTRY_CONTEXT
, x_line_tbl(i).INTERMED_SHIP_TO_CONTACT_ID
, x_line_tbl(i).INTERMED_SHIP_TO_ORG_ID
, x_line_tbl(i).INVENTORY_ITEM_ID
, x_line_tbl(i).INVOICE_INTERFACE_STATUS_CODE
, x_line_tbl(i).INVOICE_TO_CONTACT_ID
, x_line_tbl(i).INVOICE_TO_ORG_ID
, x_line_tbl(i).INVOICED_QUANTITY
, x_line_tbl(i).INVOICING_RULE_ID
, x_line_tbl(i).ORDERED_ITEM_ID
, x_line_tbl(i).ITEM_IDENTIFIER_TYPE
, x_line_tbl(i).ORDERED_ITEM
, x_line_tbl(i).ITEM_REVISION
, x_line_tbl(i).ITEM_TYPE_CODE
, x_line_tbl(i).LAST_ACK_CODE
, x_line_tbl(i).LAST_ACK_DATE
, x_line_tbl(i).LAST_UPDATED_BY
, x_line_tbl(i).LAST_UPDATE_DATE
, x_line_tbl(i).LAST_UPDATE_LOGIN
, x_line_tbl(i).LATEST_ACCEPTABLE_DATE
, x_line_tbl(i).LINE_CATEGORY_CODE
, x_line_tbl(i).LINE_ID
, x_line_tbl(i).LINE_NUMBER
, x_line_tbl(i).LINE_TYPE_ID
, x_line_tbl(i).LINK_TO_LINE_ID
, x_line_tbl(i).MODEL_GROUP_NUMBER
-- , x_line_tbl(i).MFG_COMPONENT_SEQUENCE_ID
, x_line_tbl(i).MFG_LEAD_TIME
, x_line_tbl(i).OPEN_FLAG
, x_line_tbl(i).OPTION_FLAG
, x_line_tbl(i).OPTION_NUMBER
, x_line_tbl(i).ORDERED_QUANTITY
, x_line_tbl(i).ORDERED_QUANTITY2 --OPM 02/JUN/00
, x_line_tbl(i).ORDER_QUANTITY_UOM
, x_line_tbl(i).ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
, x_line_tbl(i).ORG_ID
, x_line_tbl(i).ORIG_SYS_DOCUMENT_REF
, x_line_tbl(i).ORIG_SYS_LINE_REF
, x_line_tbl(i).ORIG_SYS_SHIPMENT_REF
, x_line_tbl(i).OVER_SHIP_REASON_CODE
, x_line_tbl(i).OVER_SHIP_RESOLVED_FLAG
, x_line_tbl(i).PAYMENT_TERM_ID
, x_line_tbl(i).PLANNING_PRIORITY
, x_line_tbl(i).PREFERRED_GRADE --OPM 02/JUN/00
, x_line_tbl(i).PRICE_LIST_ID
, x_line_tbl(i).PRICE_REQUEST_CODE --PROMOTIONS MAY/01
, x_line_tbl(i).PRICING_ATTRIBUTE1
, x_line_tbl(i).PRICING_ATTRIBUTE10
, x_line_tbl(i).PRICING_ATTRIBUTE2
, x_line_tbl(i).PRICING_ATTRIBUTE3
, x_line_tbl(i).PRICING_ATTRIBUTE4
, x_line_tbl(i).PRICING_ATTRIBUTE5
, x_line_tbl(i).PRICING_ATTRIBUTE6
, x_line_tbl(i).PRICING_ATTRIBUTE7
, x_line_tbl(i).PRICING_ATTRIBUTE8
, x_line_tbl(i).PRICING_ATTRIBUTE9
, x_line_tbl(i).PRICING_CONTEXT
, x_line_tbl(i).PRICING_DATE
, x_line_tbl(i).PRICING_QUANTITY
, x_line_tbl(i).PRICING_QUANTITY_UOM
, x_line_tbl(i).PROGRAM_APPLICATION_ID
, x_line_tbl(i).PROGRAM_ID
, x_line_tbl(i).PROGRAM_UPDATE_DATE
, x_line_tbl(i).PROJECT_ID
, x_line_tbl(i).PROMISE_DATE
, x_line_tbl(i).RE_SOURCE_FLAG
, x_line_tbl(i).REFERENCE_CUSTOMER_TRX_LINE_ID
, x_line_tbl(i).REFERENCE_HEADER_ID
, x_line_tbl(i).REFERENCE_LINE_ID
, x_line_tbl(i).REFERENCE_TYPE
, x_line_tbl(i).REQUEST_DATE
, x_line_tbl(i).REQUEST_ID
, x_line_tbl(i).RETURN_ATTRIBUTE1
, x_line_tbl(i).RETURN_ATTRIBUTE10
, x_line_tbl(i).RETURN_ATTRIBUTE11
, x_line_tbl(i).RETURN_ATTRIBUTE12
, x_line_tbl(i).RETURN_ATTRIBUTE13
, x_line_tbl(i).RETURN_ATTRIBUTE14
, x_line_tbl(i).RETURN_ATTRIBUTE15
, x_line_tbl(i).RETURN_ATTRIBUTE2
, x_line_tbl(i).RETURN_ATTRIBUTE3
, x_line_tbl(i).RETURN_ATTRIBUTE4
, x_line_tbl(i).RETURN_ATTRIBUTE5
, x_line_tbl(i).RETURN_ATTRIBUTE6
, x_line_tbl(i).RETURN_ATTRIBUTE7
, x_line_tbl(i).RETURN_ATTRIBUTE8
, x_line_tbl(i).RETURN_ATTRIBUTE9
, x_line_tbl(i).RETURN_CONTEXT
, x_line_tbl(i).RETURN_REASON_CODE
, x_line_tbl(i).RLA_SCHEDULE_TYPE_CODE
, x_line_tbl(i).SALESREP_ID
, x_line_tbl(i).SCHEDULE_ARRIVAL_DATE
, x_line_tbl(i).SCHEDULE_SHIP_DATE
, x_line_tbl(i).SCHEDULE_STATUS_CODE
, x_line_tbl(i).SHIPMENT_NUMBER
, x_line_tbl(i).SHIPMENT_PRIORITY_CODE
, x_line_tbl(i).SHIPPED_QUANTITY
, x_line_tbl(i).SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
, x_line_tbl(i).SHIPPING_METHOD_CODE
, x_line_tbl(i).SHIPPING_QUANTITY
, x_line_tbl(i).SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
, x_line_tbl(i).SHIPPING_QUANTITY_UOM
, x_line_tbl(i).SHIPPING_QUANTITY_UOM2
, x_line_tbl(i).SHIP_FROM_ORG_ID
, x_line_tbl(i).SUBINVENTORY
, x_line_tbl(i).SHIP_SET_ID
, x_line_tbl(i).SHIP_TOLERANCE_ABOVE
, x_line_tbl(i).SHIP_TOLERANCE_BELOW
, x_line_tbl(i).SHIPPABLE_FLAG
, x_line_tbl(i).SHIPPING_INTERFACED_FLAG
, x_line_tbl(i).SHIP_TO_CONTACT_ID
, x_line_tbl(i).SHIP_TO_ORG_ID
, x_line_tbl(i).SHIP_MODEL_COMPLETE_FLAG
, x_line_tbl(i).SOLD_TO_ORG_ID
, x_line_tbl(i).SOLD_FROM_ORG_ID
, x_line_tbl(i).SORT_ORDER
, x_line_tbl(i).SOURCE_DOCUMENT_ID
, x_line_tbl(i).SOURCE_DOCUMENT_LINE_ID
, x_line_tbl(i).SOURCE_DOCUMENT_TYPE_ID
, x_line_tbl(i).SOURCE_TYPE_CODE
, x_line_tbl(i).SPLIT_FROM_LINE_ID
, x_line_tbl(i).LINE_SET_ID
, x_line_tbl(i).SPLIT_BY
, x_line_tbl(i).MODEL_REMNANT_FLAG
, x_line_tbl(i).TASK_ID
, x_line_tbl(i).TAX_CODE
, x_line_tbl(i).TAX_DATE
, x_line_tbl(i).TAX_EXEMPT_FLAG
, x_line_tbl(i).TAX_EXEMPT_NUMBER
, x_line_tbl(i).TAX_EXEMPT_REASON_CODE
, x_line_tbl(i).TAX_POINT_CODE
, x_line_tbl(i).TAX_RATE
, x_line_tbl(i).TAX_VALUE
, x_line_tbl(i).TOP_MODEL_LINE_ID
, x_line_tbl(i).UNIT_LIST_PRICE
, x_line_tbl(i).UNIT_LIST_PRICE_PER_PQTY
, x_line_tbl(i).UNIT_SELLING_PRICE
, x_line_tbl(i).UNIT_SELLING_PRICE_PER_PQTY
, x_line_tbl(i).VISIBLE_DEMAND_FLAG
, x_line_tbl(i).VEH_CUS_ITEM_CUM_KEY_ID
, x_line_tbl(i).SHIPPING_INSTRUCTIONS
, x_line_tbl(i).PACKING_INSTRUCTIONS
, x_line_tbl(i).SERVICE_TXN_REASON_CODE
, x_line_tbl(i).SERVICE_TXN_COMMENTS
, x_line_tbl(i).SERVICE_DURATION
, x_line_tbl(i).SERVICE_PERIOD
, x_line_tbl(i).SERVICE_START_DATE
, x_line_tbl(i).SERVICE_END_DATE
, x_line_tbl(i).SERVICE_COTERMINATE_FLAG
, x_line_tbl(i).UNIT_LIST_PERCENT
, x_line_tbl(i).UNIT_SELLING_PERCENT
, x_line_tbl(i).UNIT_PERCENT_BASE_PRICE
, x_line_tbl(i).SERVICE_NUMBER
, x_line_tbl(i).SERVICE_REFERENCE_TYPE_CODE
, x_line_tbl(i).SERVICE_REFERENCE_LINE_ID
, x_line_tbl(i).SERVICE_REFERENCE_SYSTEM_ID
, x_line_tbl(i).TP_CONTEXT
, x_line_tbl(i).TP_ATTRIBUTE1
, x_line_tbl(i).TP_ATTRIBUTE2
, x_line_tbl(i).TP_ATTRIBUTE3
, x_line_tbl(i).TP_ATTRIBUTE4
, x_line_tbl(i).TP_ATTRIBUTE5
, x_line_tbl(i).TP_ATTRIBUTE6
, x_line_tbl(i).TP_ATTRIBUTE7
, x_line_tbl(i).TP_ATTRIBUTE8
, x_line_tbl(i).TP_ATTRIBUTE9
, x_line_tbl(i).TP_ATTRIBUTE10
, x_line_tbl(i).TP_ATTRIBUTE11
, x_line_tbl(i).TP_ATTRIBUTE12
, x_line_tbl(i).TP_ATTRIBUTE13
, x_line_tbl(i).TP_ATTRIBUTE14
, x_line_tbl(i).TP_ATTRIBUTE15
, x_line_tbl(i).FLOW_STATUS_CODE
, x_line_tbl(i).MARKETING_SOURCE_CODE_ID
, x_line_tbl(i).CALCULATE_PRICE_FLAG
, x_line_tbl(i).COMMITMENT_ID
, x_line_tbl(i).ORDER_SOURCE_ID -- aksingh
, x_line_tbl(i).UPGRADED_FLAG
, x_line_tbl(i).ORIGINAL_INVENTORY_ITEM_ID
, x_line_tbl(i).ORIGINAL_ITEM_IDENTIFIER_TYPE
, x_line_tbl(i).ORIGINAL_ORDERED_ITEM_ID
, x_line_tbl(i).ORIGINAL_ORDERED_ITEM
, x_line_tbl(i).ITEM_RELATIONSHIP_TYPE
, x_line_tbl(i).ITEM_SUBSTITUTION_TYPE_CODE
, x_line_tbl(i).LATE_DEMAND_PENALTY_FACTOR
, x_line_tbl(i).OVERRIDE_ATP_DATE_CODE
, x_line_tbl(i).FIRM_DEMAND_FLAG
, x_line_tbl(i).EARLIEST_SHIP_DATE
, x_line_tbl(i).USER_ITEM_DESCRIPTION
, x_line_tbl(i).BLANKET_NUMBER
, x_line_tbl(i).BLANKET_LINE_NUMBER
, x_line_tbl(i).BLANKET_VERSION_NUMBER
, x_line_tbl(i).UNIT_COST
, x_line_tbl(i).LOCK_CONTROL
, l_opn --OPN
, l_cpn --CPN
, l_svn --SVN
, x_line_tbl(i).CHANGE_SEQUENCE
, x_line_tbl(i).transaction_phase_code
, x_line_tbl(i).source_document_version_number
, x_line_tbl(i).MINISITE_ID
, x_line_tbl(i).Ib_Owner
, x_line_tbl(i).Ib_installed_at_location
, x_line_tbl(i).Ib_current_location
, x_line_tbl(i).End_customer_ID
, x_line_tbl(i).End_customer_contact_ID
, x_line_tbl(i).End_customer_site_use_ID
, x_line_tbl(i).RETROBILL_REQUEST_ID
, x_line_tbl(i).ORIGINAL_LIST_PRICE -- Override List Price
, x_line_tbl(i).order_firmed_date
, x_line_tbl(i).actual_fulfillment_date
, x_line_tbl(i).charge_periodicity_code
, x_line_tbl(i).cancelled_quantity2
, x_line_tbl(i).fulfilled_quantity2
, x_line_tbl(i).CONTINGENCY_ID
, x_line_tbl(i).REVREC_EVENT_CODE
, x_line_tbl(i).REVREC_EXPIRATION_DAYS
, x_line_tbl(i).ACCEPTED_QUANTITY
, x_line_tbl(i).REVREC_COMMENTS
, x_line_tbl(i).REVREC_SIGNATURE
, x_line_tbl(i).REVREC_SIGNATURE_DATE
, x_line_tbl(i).ACCEPTED_BY
, x_line_tbl(i).REVREC_REFERENCE_DOCUMENT
, x_line_tbl(i).REVREC_IMPLICIT_FLAG;
SELECT line_id ,lock_control
FROM oe_order_lines_all
WHERE line_id IN (c_top_model_line_id, c_line_id)
FOR UPDATE NOWAIT ;
SELECT top_model_line_id
INTO l_top_model_line_id
FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
WHERE line_id = l_line_id;
SELECT top_model_line_id
INTO l_top_model_line_id
FROM OE_ORDER_LINES_ALL -- Fix for FP bug 3391622
WHERE line_id = l_line_id;
/* SELECT line_id
INTO l_dummy
FROM oe_order_lines_all
WHERE line_id = l_top_model_line_id
FOR UPDATE NOWAIT; */
SELECT line_id,lock_control
INTO l_line_id,l_db_lock_control
FROM oe_order_lines_all
WHERE line_id = l_line_id
FOR UPDATE NOWAIT;
/*SELECT line_id,lock_control
INTO l_line_id,l_db_lock_control
FROM oe_order_lines_all
WHERE line_id = l_line_id
FOR UPDATE NOWAIT; */
oe_debug_pub.add('selected for update', 1);
fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
SELECT line_id
FROM oe_order_lines_all
WHERE header_id = p_header_id
FOR UPDATE NOWAIT;
SELECT line_id
INTO l_line_id
FROM OE_ORDER_LINES_ALL
WHERE line_id = p_line_id
FOR UPDATE NOWAIT;
fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
SELECT SOLD_TO_ORG_ID
INTO l_sold_to_org_id
FROM OE_ORDER_LINES
WHERE LINE_ID = p_x_line_rec.line_id;
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND ( p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM
OR p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM
OR p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM )
AND p_x_line_rec.line_id <> FND_API.G_MISS_NUM
THEN
SELECT SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID
INTO l_sold_to_org_id, l_invoice_to_org_id, l_deliver_to_org_id
FROM OE_ORDER_LINES
WHERE LINE_ID = p_x_line_rec.line_id;
Select header_id into x_header_id
from oe_order_lines
where line_id = p_line_id;
Select order_quantity_uom, inventory_item_id
Into l_order_quantity_uom, l_inventory_item_id
From oe_order_lines_all
Where line_id = p_line_id;
Select order_quantity_uom, inventory_item_id
Into l_order_quantity_uom, l_inventory_item_id
From oe_order_lines_all
Where line_id = p_line_id;
Select order_quantity_uom, inventory_item_id
Into l_order_quantity_uom, l_inventory_item_id
From oe_order_lines_all
Where line_id = p_line_id;
SELECT line_id,line_set_id,from_serial_number,to_serial_number
FROM oe_lot_serial_numbers
WHERE from_serial_number = p_serial_num
OR to_serial_number = p_serial_num;
select nvl(upgraded_flag,'-') into l_upgraded_flag
from oe_order_lines
where line_id = p_line_rec.reference_line_id;
select distinct reference_line_id
into l_ref_line_id
from oe_line_sets a,
oe_order_lines b
where a.set_id = C2.line_set_id
and a.line_id = b.line_id
and b.booked_flag = 'Y'
and b.line_id <> p_line_rec.line_id
and b.cancelled_flag <> 'Y';
select reference_line_id
into l_ref_line_id
from oe_order_lines
where line_id = C2.line_id
and line_id <> p_line_rec.line_id
and booked_flag = 'Y'
and cancelled_flag <> 'Y';
SELECT sum(nvl(ordered_quantity, 0))
INTO l_total
FROM oe_order_lines
WHERE reference_line_id = p_line_rec.reference_line_id
AND ((booked_flag = 'Y' and header_id <> p_line_rec.header_id)
OR (header_id = p_line_rec.header_id))
AND cancelled_flag <> 'Y'
AND line_category_code = 'RETURN'
AND line_id <> p_line_rec.line_id;
SELECT nvl(ordered_quantity, 0)
INTO l_orig_quantity
FROM oe_order_lines
WHERE line_id = p_line_rec.reference_line_id;
SELECT nvl(shipped_quantity, ordered_quantity) --- get from ord_qty if original line not shipped/invoiced....
INTO l_orig_quantity
FROM oe_order_lines
WHERE line_id = p_line_rec.reference_line_id;
SELECT nvl(ordered_quantity, 0)
INTO l_orig_quantity
FROM oe_order_lines
WHERE line_id = p_line_rec.reference_line_id;
l_update_inventory_item VARCHAR2(1) := FND_API.G_FALSE;
/* Replaced with the following SELECT and IF statements
to fix bug 2163988
SELECT cust_acct_site_id
INTO l_address_id
FROM HZ_CUST_SITE_USES
WHERE site_use_id = p_x_line_rec.ship_to_org_id
AND site_use_code = 'SHIP_TO';
SELECT /*MOAC_SQL_CHANGES*/ u.cust_acct_site_id,
s.cust_account_id
INTO l_address_id,
l_cust_id
FROM HZ_CUST_SITE_USES_ALL u,
HZ_CUST_ACCT_SITES s
WHERE u.cust_acct_site_id = s.cust_acct_site_id
AND u.site_use_id = p_x_line_rec.ship_to_org_id
AND u.site_use_code = 'SHIP_TO';
l_update_inventory_item := FND_API.G_TRUE;
IF l_update_inventory_item = FND_API.G_TRUE THEN
-- Call Process Order
oe_debug_pub.add('Calling Process order to update inventory item', 1);
select source_document_type_id
into l_parent_document_type_id
from oe_order_lines_all
where line_id = p_x_line_rec.top_model_line_id;
IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR
p_x_line_rec.ordered_quantity = 0)
and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
IF Nvl(oe_globals.g_pricing_recursion,'N') = 'N' THEN
update_adjustment_flags(p_old_line_rec,p_x_line_rec);
SELECT payment_type_code
INTO l_line_payment_type_code
FROM oe_payments
WHERE header_id = p_x_line_rec.header_id
AND line_id = p_x_line_rec.split_from_line_id
AND payment_type_code IS NOT NULL
AND rownum = 1;
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
p_x_line_rec.ship_set_id IS NULL AND
p_old_line_rec.ship_set_id IS NOT NULL AND
p_x_line_rec.split_action_code = 'SPLIT'
)
)
THEN
-- code fix for 3554622
if l_debug_level > 0 then
oe_debug_pub.ADD('Update Shipping : '|| p_x_line_rec.line_id ,1);
p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,
p_request_unique_key1 => p_x_line_rec.operation,
p_param1 => FND_API.G_TRUE,
p_param2 => FND_API.G_FALSE,
x_return_status => l_return_status);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE AND
p_x_line_rec.order_quantity_uom IS NOT NULL AND
p_x_line_rec.order_quantity_uom <> FND_API.G_MISS_CHAR AND
NVL(p_x_line_rec.ordered_quantity,0) <> 0 AND
p_x_line_rec.Ordered_Quantity <> FND_API.G_MISS_NUM THEN
IF (OE_GLOBALS.G_UI_FLAG) and
OE_GLOBALS.G_DEFER_PRICING='N' and
(nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N') THEN
if l_debug_level > 0 then
oe_debug_pub.add('ui mode - delete');
oe_debug_pub.add('batch mode - delete');
oe_debug_pub.add('not logging price order - delete operation ');
oe_debug_pub.add('logging price order - delete operation');
oe_debug_pub.add('bokked - delete');
IF (p_x_line_rec.operation = oe_globals.g_opr_update) and
NOT (p_x_line_rec.split_action_code IS NOT NULL AND
p_x_line_rec.split_action_code <> FND_API.G_MISS_CHAR) AND
(p_x_line_rec.line_set_id IS NOT NULL AND
p_x_line_rec.line_set_id <> FND_API.G_MISS_NUM) THEN
-- Addded project and task to fix bug #1229811
if l_debug_level > 0 then
oe_debug_pub.ADD('Raj:Split-Inside Request' ,1);
IF (p_x_line_rec.operation = oe_globals.G_OPR_UPDATE AND
(p_old_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
p_old_line_rec.ordered_quantity IS NOT NULL)) then
OE_SALES_CAN_UTIL.Perform_Line_change(p_x_line_rec,
p_old_line_rec,
l_return_status);
SELECT count(*)
INTO l_count
FROM wsh_carrier_services wsh,
wsh_org_carrier_services wsh_org
WHERE wsh_org.organization_id = p_x_line_rec.ship_from_org_id
AND wsh.carrier_service_id = wsh_org.carrier_service_id
AND wsh.ship_method_code = p_x_line_rec.shipping_method_code
AND wsh_org.enabled_flag = 'Y';
SELECT count(*)
INTO l_count
FROM wsh_carrier_ship_methods
WHERE ship_method_code = p_x_line_rec.shipping_method_code
AND organization_id = p_x_line_rec.ship_from_org_id;
select count(*) into v_count from oe_price_adjustments
where line_id = p_x_line_rec.line_id
and substitution_attribute = 'QUALIFIER_ATTRIBUTE11'
and list_line_type_code = 'TSN'
and modified_to = p_x_line_rec.shipping_method_code;
DELETE FROM OE_PRICE_ADJUSTMENTS
WHERE LINE_ID = p_x_line_rec.line_id
AND LIST_LINE_TYPE_CODE = 'TSN'
AND SUBSTITUTION_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE11'
AND MODIFIED_TO = p_x_line_rec.shipping_method_code
RETURNING MODIFIED_FROM into l_modified_from;
select meaning into l_meaning from oe_ship_methods_v where lookup_type = 'SHIP_METHOD' and lookup_code=p_x_line_rec.shipping_method_code;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
G_APPLY_AUTOMATIC_ATCHMT = 'Y' THEN
if l_debug_level > 0 then
oe_debug_pub.add('log request to apply atchmt for UPDATE ',1);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
ONT_LINE_Def_Util.Clear_LINE_Cache;
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL THEN
if l_debug_level > 0 then
oe_debug_pub.add('clear the cached top model record', 1);
IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) AND
(p_x_line_rec.split_by = 'SYSTEM') AND
(p_x_line_rec.order_source_id = 10) THEN
FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
NOT (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
p_x_line_rec.split_by = 'SYSTEM' AND
NVL(p_x_line_rec.split_action_code,'X') = 'SPLIT') AND
(PO_CODE_RELEASE_GRP.Current_Release >=
PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J) AND
OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
Log_Dropship_CMS_Request
(p_x_line_rec => p_x_line_rec
,p_old_line_rec => p_old_line_rec
);
IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count > 0 THEN
FOR l_ind in 1..OE_GLOBALS.oe_audit_history_tbl.last LOOP
IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.exists(l_ind) THEN
IF OE_GLOBALS.oe_audit_history_tbl(l_ind).LINE_ID = p_x_line_rec.line_id AND
OE_GLOBALS.oe_audit_history_tbl(l_ind).HISTORY_TYPE = 'R' THEN -- flag 'R' denotes requires reason
if l_debug_level > 0 then
OE_DEBUG_PUB.add('OEXULINB- Audit Reason Required', 5);
IF (p_x_line_rec.operation=OE_GLOBALS.G_OPR_UPDATE) AND
(p_x_line_rec.split_action_code = 'SPLIT') THEN
--11.5.10 Versioning/Audit Trail updates
IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
p_entity_id => p_x_line_rec.line_id,
p_hist_type_code => 'SPLIT');
OE_DEBUG_PUB.add('Return status after inserting split history : '||l_return_status,5);
oe_debug_pub.add('Error while inserting Line split History ',1);
/* Start Audit Trail - Insert Lines history */
IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' THEN
IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count > 0 THEN
FOR l_ind in 1..OE_GLOBALS.oe_audit_history_tbl.last LOOP
IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.exists(l_ind) THEN
IF OE_GLOBALS.oe_audit_history_tbl(l_ind).line_id = p_x_line_rec.line_id THEN
if l_debug_level > 0 then
OE_DEBUG_PUB.add('OEXULINB:calling oe_order_chg_pvt.recordlinehist', 5);
p_hist_type_code => 'UPDATE');
p_hist_type_code => 'UPDATE',
p_reason_code => p_x_line_rec.change_reason,
p_comments => p_x_line_rec.change_comments,
p_wf_activity_code => null,
p_wf_result_code => null,
x_return_status => l_return_status);
oe_debug_pub.add('Inserting Line Audit History error',1);
OE_GLOBALS.oe_audit_history_tbl.delete(l_ind);
select /*MOAC_SQL_CHANGES*/ a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
from oe_order_lines a
where a.service_reference_line_id= p_line_id
UNION
select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
from oe_order_lines a
where a.line_set_id = p_line_set_id
UNION
select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
from oe_order_lines a
where exists
(select 'x'
from oe_order_lines_all b
where a.service_reference_line_id=b.line_id
and b.line_set_id = p_line_set_id)
and a.line_Id <> p_line_id;
SELECT /*MOAC_SQL_CHANGES*/ line_id, header_id,line_number,shipment_number,
option_number,service_number
FROM oe_order_lines
WHERE (top_model_line_id = p_line_id
OR line_set_id = p_line_set_id
OR top_model_line_id in (SELECT line_id
FROM oe_order_lines_all
WHERE header_id = p_header_id
AND line_set_id = p_line_set_id))
AND line_id <> p_line_id
AND header_id = p_header_id
FOR UPDATE OF line_number NOWAIT;
select /*MOAC_SQL_CHANGES*/ a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
from oe_order_lines a, oe_order_lines_all b
where a.service_reference_line_id=b.line_id
and b.line_set_id = p_line_set_id
UNION
select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
from oe_order_lines a, oe_order_lines_all b
Where a.service_reference_line_id=b.line_id
and b.top_model_line_id= p_line_id
UNION
select a.line_id, a.header_id, a.line_number, a.shipment_number, a.option_number, a.service_number
from oe_order_lines a, oe_order_lines_all b
Where a.service_reference_line_id=b.line_id
and EXISTS (select 'X'
from oe_order_lines_all c
where line_set_id = p_line_set_id
and c.line_id = b.top_model_line_id);
/*lchen rewrite the update statement to fix performance bug 1869179 */
oe_debug_pub.add('l_cursor_flag= ' ||l_cursor_flag );
SELECT line_id
INTO l_dummy
FROM oe_order_lines
WHERE line_id=l_line_id
FOR UPDATE OF line_number NOWAIT;
oe_debug_pub.add('In the loop of standard_line_number, update child service line numbers');
UPDATE oe_order_lines
Set line_number = p_line_number,
lock_control = lock_control + 1
WHERE line_id=l_line_id;
-- Update line number on the child option/service/class lines
UPDATE oe_order_lines
Set line_number = p_line_number,
lock_control = lock_control + 1
WHERE (top_model_line_id = p_line_id
OR line_set_id = p_line_set_id
OR top_model_line_id in (SELECT line_id
FROM oe_order_lines
WHERE header_id = p_header_id
AND line_set_id = p_line_set_id))
AND line_id <> p_line_id
AND header_id = p_header_id; -- 2508099
SELECT line_id
INTO l_dummy
FROM oe_order_lines
WHERE line_id=l_line_id
FOR UPDATE OF line_number NOWAIT;
oe_debug_pub.add('in service_line_number loop, update service line number');
UPDATE oe_order_lines
Set line_number = p_line_number,
lock_control = lock_control + 1
WHERE line_id=l_line_id;
SELECT 'Y' from
WF_ITEM_ACTIVITY_STATUSES WIAS
, WF_PROCESS_ACTIVITIES WPA
where WIAS.item_type = 'OEOL'
AND WIAS.item_key = to_char(p_x_line_rec.line_id)
AND WIAS.activity_status = 'NOTIFIED'
AND WPA.activity_name = 'AUTHORIZE_TO_SHIP_WAIT'
AND WPA.instance_id = WIAS.process_activity;
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
if l_debug_level > 0 then
oe_debug_pub.add('Calling DelayedReg for evaluate_holds in post_write for UPDATE');
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE(I);
OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE;
OE_Config_Pvt.OE_FREEZE_INC_ITEMS_TBL.DELETE;
IF OE_Schedule_GRP.G_ISO_Planning_Update AND
NOT OE_GLOBALS.EQUAL(p_x_line_rec.ordered_quantity, p_old_line_rec.ordered_quantity) THEN
-- nvl(p_x_line_rec.ordered_quantity,0) = 0 THEN -- Commented for bug 7611039
OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to TRUE',5);
AND p_x_line_rec.operation <> OE_GLOBALS.G_OPR_DELETE
THEN
if l_debug_level > 0 then
oe_debug_pub.add('PO: Calling new Schedule_line from post write',1);
IF OE_Schedule_GRP.G_ISO_Planning_Update THEN
OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
p_x_line_rec.operation = oe_globals.G_OPR_UPDATE )then
-- OE_GLOBALS.G_RECURSION_MODE := 'Y';
select count(*) into l_close_act_complete
from wf_item_activity_statuses s,
wf_process_activities p
where s.process_activity = p.instance_id
and s.item_type = 'OEOL'
and s.item_key = to_char(p_x_line_rec.line_id)
and p.activity_name = 'CLOSE_LINE'
and activity_result_code in ('NOT_ELIGIBLE','COMPLETE')
and s.activity_status = 'COMPLETE';
** started. If so, delete entry from G_START_LINE_FLOWS_TBL
*/
IF (OE_GLOBALS.G_START_LINE_FLOWS_TBL.COUNT > 0) THEN
l_ctr := OE_GLOBALS.G_START_LINE_FLOWS_TBL.FIRST;
OE_GLOBALS.G_START_LINE_FLOWS_TBL.DELETE(l_ctr);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
if l_debug_level > 0 then
oe_debug_pub.add('Authorization flag is: ' ||
p_x_line_rec.authorized_to_ship_flag);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.line_number ,
p_old_line_rec.line_number)
THEN
Cascade_Line_Number
( p_x_line_rec.header_id,
p_x_line_rec.line_id,
p_x_line_rec.line_set_id,
p_x_line_rec.item_type_code,
p_x_line_rec.line_number
);
END IF; -- G_OPR_UPDATE.
p_x_line_rec.operation = oe_globals.g_opr_update)
THEN
IF NOT( (nvl(p_x_line_rec.split_from_line_id,FND_API.G_MISS_NUM)
<> FND_API.G_MISS_NUM)
AND p_x_line_rec.operation = oe_globals.g_opr_create
)
THEN
if l_debug_level > 0 then
oe_debug_pub.add('Before Calling Create Credit');
(p_request_type =>OE_GLOBALS.G_INSERT_RMA
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
AND p_x_line_rec.operation = oe_globals.g_opr_update
AND nvl(p_x_line_rec.split_by,'USER') = 'SYSTEM'
)
OR (nvl(p_x_line_rec.split_from_line_id,FND_API.G_MISS_NUM)
<> FND_API.G_MISS_NUM
AND p_x_line_rec.operation = oe_globals.g_opr_create
AND nvl(p_x_line_rec.split_by,'USER') = 'SYSTEM'
)
THEN
NULL;
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.DELETE;
OE_SERVICE_UTIL.Update_Service_Lines
(p_x_line_tbl => p_x_line_tbl,
x_return_status => l_return_status);
IF (p_x_line_tbl(I).operation = 'DELETE' OR
(p_x_line_tbl(I).operation = 'UPDATE' AND
p_x_line_tbl(I).cancelled_flag = 'Y')) AND
p_x_line_tbl(I).top_model_line_id is not NULL AND
nvl(p_x_line_tbl(I).ship_model_complete_flag, 'N') = 'Y' AND
nvl(p_x_line_tbl(I).shipping_interfaced_flag, 'N') = 'N' AND
nvl(p_x_line_tbl(I).model_remnant_flag, 'N') = 'N'
THEN
oe_debug_pub.add('cancel or delete, call smc shipping', 1);
SELECT count(*)
INTO l_count
FROM oe_order_lines
WHERE top_model_line_id = p_x_line_tbl(I).top_model_line_id
AND shipping_interfaced_flag = 'Y';
SELECT 'N'
INTO l_valid_line_number
FROM oe_order_lines L
WHERE L.line_number = p_x_line_tbl(I).line_number
AND L.header_id = p_x_line_tbl(I).header_id
AND L.line_id <> p_x_line_tbl(I).line_id
AND ( L.item_type_code = 'STANDARD'
OR ( L.top_model_line_id = L.line_id
AND L.item_type_code = 'MODEL'));
SELECT item_type_code
INTO l_item_type_code
FROM oe_order_lines
WHERE line_id = p_line_rec.reference_line_id;
SELECT alot.prefqc_grade
FROM op_alot_prm alot, ic_item_mst item, op_cust_mst cust
WHERE item.item_id = l_item_rec.opm_item_id
and alot.cust_id = cust.cust_id
and item.alloc_class = alot.alloc_class
and alot.delete_mark = 0
and cust.of_ship_to_site_use_id = p_line_rec.ship_to_org_id;
SELECT alot.prefqc_grade
FROM op_alot_prm alot, ic_item_mst item
WHERE item.item_id = l_item_rec.opm_item_id
and alot.cust_id IS NULL
and item.alloc_class = alot.alloc_class
and alot.delete_mark = 0;
AND p_x_line_rec.operation = oe_globals.g_opr_update
)
OR (p_x_line_rec.split_from_line_id is not null
AND p_x_line_rec.split_from_line_id <> fnd_api.g_miss_num
AND p_x_line_rec.operation = oe_globals.g_opr_create
)
THEN
--Then you need to call the Quantity rounding API to round off the qty on the line
l_ordered_qty := p_x_line_rec.ordered_quantity; --nocopy impact changes
SELECT line_id
INTO l_num
FROM oe_order_lines
WHERE ato_line_id = p_x_line_rec.ato_line_id
AND top_model_line_id = p_x_line_rec.top_model_line_id
AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
if l_debug_level > 0 then
oe_debug_pub.add('ato item qty made to 0'|| p_x_line_rec.open_flag, 4);
END IF; -- update on model line logged
nvl(p_x_line_rec.split_action_code, 'X') <> 'SPLIT' AND -- split update
NOT (p_x_line_rec.split_from_line_id is NOT NULL AND
p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE) -- split create
THEN
if l_debug_level > 0 then
oe_debug_pub.add('part of ato', 3);
SELECT 1
INTO l_num
FROM oe_order_lines
WHERE line_id = p_x_line_rec.top_model_line_id
AND top_model_line_id = nvl(ato_line_id, -1);
p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR
(p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NOT OE_GLOBALS.Equal(p_x_line_rec.ordered_quantity,
p_old_line_rec.ordered_quantity))
THEN
if l_debug_level > 0 then
oe_debug_pub.add('cto_change logged for config change', 3);
IF p_x_line_rec.operation <> OE_GLOBALS.G_OPR_DELETE AND
OE_Code_Control.Code_Release_Level >= '110510' THEN
if l_debug_level > 0 then
oe_debug_pub.add('cto_change logged for decimal change', 3);
SELECT 1
INTO l_num
FROM oe_order_lines
WHERE line_id = p_x_line_rec.split_from_line_id
AND ato_line_id = line_id
AND item_type_code = 'CLASS';
SELECT line_id
INTO l_num
FROM oe_order_lines
WHERE top_model_line_id = p_x_line_rec.top_model_line_id
AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
if an option or class is deleted.
no need not consider split in case of deletes.
Log the delayed request to Validate the Configuration
if an option or class is updated or created or model
is created.
2) copy configuration.
Log a copy config request if model/kit is proportionally split.
Change Record:
bug 2075105: the delete_option request will be looged against
top model line with request_unique_key of line_id.
----------------------------------------------------------------------*/
PROCEDURE Log_Config_Requests
(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
OE_Order_PUB.G_MISS_LINE_REC
,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
IS
l_flag BOOLEAN;
SELECT config_header_id, config_rev_nbr, configuration_id
INTO l_config_header_id,l_config_rev_nbr, l_configuration_id
FROM oe_order_lines
WHERE line_id = p_x_line_rec.split_from_line_id;
SELECT open_flag, ordered_item, fulfilled_flag
INTO l_model_open_flag, l_model_item, l_fulfilled_flag
FROM oe_order_lines
WHERE line_id = p_x_line_rec.top_model_line_id;
p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE AND
OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN
IF l_model_open_flag = 'N' THEN
FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
oe_debug_pub.add('Logging a request to delete option from oe/spc', 1);
p_request_type => OE_GLOBALS.G_DELETE_OPTION,
p_param1 => p_x_line_rec.top_model_line_id,
p_param2 => p_x_line_rec.component_code,
p_param3 => p_x_line_rec.item_type_code,
p_param9 => p_x_line_rec.configuration_id,
p_param10 => p_x_line_rec.ordered_item, -- 3563690
x_return_status => x_return_status);
ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
nvl(p_x_line_rec.split_action_code, 'X') = 'SPLIT'
THEN
if l_debug_level > 0 then
oe_debug_pub.add('This is a parent split model', 1);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
l_config_rev_change = 'N' THEN
if l_debug_level > 0 then
oe_debug_pub.add('Logging a request to update configuration', 1);
p_request_type => OE_GLOBALS.G_UPDATE_OPTION,
p_param1 => p_x_line_rec.top_model_line_id,
p_param2 => p_x_line_rec.component_code,
p_param3 => p_x_line_rec.item_type_code,
p_param4 => p_old_line_rec.ordered_quantity,
p_param5 => p_x_line_rec.ordered_quantity,
p_param6 => p_x_line_rec.change_reason,
p_param7 => p_x_line_rec.change_comments,
p_param8 => l_cancellation,
p_param9 => p_x_line_rec.configuration_id,
x_return_status => x_return_status);
END IF; -- end of update.
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
nvl(p_x_line_rec.split_action_code, 'X') <> 'SPLIT'
THEN
-- 1. change in ordered qty of model/kit
-- at subconfig cascade qty is actually in validate_config
IF p_x_line_rec.top_model_line_id = p_x_line_rec.line_id
THEN
IF NOT OE_GLOBALS.Equal(p_x_line_rec.ordered_quantity,
p_old_line_rec.ordered_quantity) AND
OE_Config_Util.G_Config_UI_Used = 'N'
THEN
l_param1 := p_old_line_rec.ordered_quantity;
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND nvl(p_x_line_rec.split_action_code,'N') <> 'SPLIT' --6717302
AND nvl(p_x_line_rec.split_by,'N') <> 'SYSTEM' --6717302
THEN
IF p_x_line_rec.schedule_status_code is null THEN
-- 1.
IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_FROM_ORG_ID,
p_old_line_rec.SHIP_FROM_ORG_ID)
THEN
l_change_configuration := TRUE;
SELECT 1
INTO l_num
FROM oe_order_lines
WHERE top_model_line_id = p_x_line_rec.top_model_line_id
AND link_to_line_id = p_x_line_rec.line_id
AND item_type_code = OE_GLOBALS.G_ITEM_INCLUDED
AND rownum = 1;
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
l_modify_included_items := TRUE;
SELECT /*MOAC_SQL_CHANGES*/ cust.cust_account_id,
party.party_name,
cust.account_number,
site.location,
addr.address1,
addr.address2,
addr.address3,
addr.address4,
addr.city,
nvl(addr.state,addr.province), -- 3603600
addr.postal_code,
addr.country
INTO x_customer_id,
x_customer_name,
x_customer_number,
x_location,
x_address1,
x_address2,
x_address3,
x_address4,
x_city,
x_state,
x_zip,
x_country
FROM HZ_CUST_SITE_USES_ALL site,
HZ_CUST_ACCT_SITES cas,
hz_cust_accounts cust,
hz_parties party,
hz_party_sites ps,
hz_locations addr
WHERE site.cust_acct_site_id=cas.cust_acct_site_id
AND site.site_use_code=p_site_use_code
AND site.site_use_id=p_org_id
AND cust.cust_account_id = cas.cust_account_id
AND cas.party_site_id = ps.party_site_id
AND ps.location_id = addr.location_id
AND party.party_id = cust.party_id;
oe_debug_pub.ADD('Update Shipping : logging delayed request for '
|| to_char(p_x_line_rec.line_id) ,1);
p_request_type => OE_GLOBALS.G_UPDATE_SHIPPING,
p_request_unique_key1 => OE_GLOBALS.G_OPR_UPDATE,
p_param1 => FND_API.G_TRUE,
x_return_status => x_return_status);
IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE
THEN
OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
END IF; -- if operation is DELETE
PROCEDURE update_adjustment_flags
( p_old_line_rec IN OE_Order_PUB.line_rec_type,
p_x_line_rec IN OE_Order_PUB.line_rec_type)
IS
--cursor to return the current line association id and the
--parent line assocation id through the OE_PRICE_ADJ_ASSOCS table
CURSOR C1 IS
SELECT opa1.price_adjustment_id, opa2.price_adjustment_id, opa1.line_id
FROM
oe_price_adjustments opa1,
oe_price_adj_assocs opaa,
oe_price_adjustments opa2
WHERE
opa1.line_id = p_old_line_rec.line_id
AND opa1.price_adjustment_id = opaa.rltd_price_adj_id
AND opaa.price_adjustment_id = opa2.price_adjustment_id
AND opa2.list_line_type_code = 'PRG';
SELECT price_adjustment_id
FROM oe_price_adjustments
where line_id=p_old_line_rec.line_id AND list_line_type_code='IUE';
up_f oe_price_adjustments.updated_flag%TYPE;
oe_debug_pub.ADD('Entering OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);
oe_debug_pub.ADD('Exiting OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);
/* DELETE FROM oe_price_adjustments
where line_id=p_old_line_rec.line_id AND list_line_type_code='IUE';*/
oe_debug_pub.ADD('trying to delete IUE adjustments...',1);
oe_line_adj_util.delete_row(p_price_adjustment_id=>iue_adj_id);
oe_debug_pub.ADD('deleted IUE association:'||SQL%rowcount||' row(s)',1);
--delete the adjustment if this is the child line.
IF child_line_id=p_old_line_rec.line_id then
oe_debug_pub.ADD('trying to delete adjustments for line_id:'||p_old_line_rec.line_id,1);
oe_line_adj_util.delete_row(p_line_id=>p_old_line_rec.line_id);
OE_Line_Adj_Assocs_Util.delete_row(
p_price_adjustment_id=>child_adj_id);
--(other then this item, we already deleted its adjustment)
SELECT COUNT(*) INTO row_count
FROM oe_price_adj_assocs opaa,oe_price_adjustments opa
WHERE opaa.price_adjustment_id=parent_adj_id
AND opaa.rltd_price_adj_id=opa.price_adjustment_id;
--not the only free item, this adjustment is applied _and_ updated = 'Y'
UPDATE oe_price_adjustments
SET applied_flag='Y',updated_flag='Y'
WHERE price_adjustment_id=parent_adj_id;
oe_debug_pub.ADD('updated parent adjustment: applied_flag=Y,updated_flag=Y:'||SQL%rowcount||' row(s)',1);
UPDATE oe_price_adjustments
SET updated_flag = 'Y' where price_adjustment_id in
(select rltd_price_adj_id from oe_price_adj_assocs
where price_adjustment_id = parent_adj_id);
UPDATE oe_price_adjustments
SET applied_flag='N',updated_flag='Y'
WHERE price_adjustment_id=parent_adj_id;
oe_debug_pub.ADD('updated parent adjustment: applied_flag=N,updated_flag=Y:'||SQL%rowcount||' rows',1);
SELECT applied_flag,updated_flag INTO app_f,up_f
FROM oe_price_adjustments
WHERE price_adjustment_id=parent_adj_id;
oe_debug_pub.ADD('price_adjustment_id:'||parent_adj_id||' applied_flag='||app_f||' updated_flag='||up_f,1);
oe_debug_pub.ADD('Exiting OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);
END update_adjustment_flags;
SELECT count(*)
INTO l_count
FROM oe_drop_ship_sources
WHERE line_id = p_x_line_rec.line_id
AND header_id = p_x_line_rec.header_id;
SELECT Count(1)
INTO l_rcv_count
FROM rcv_transactions rcv,
oe_drop_ship_sources odss,
po_line_locations_all pol
WHERE rcv.PO_LINE_ID=odss.po_line_id
AND pol.line_location_id=odss.line_location_id
AND odss.line_id=p_x_line_rec.line_id
AND RCV.PO_LINE_LOCATION_ID=pol.LINE_LOCATION_ID
AND TRANSACTION_TYPE='DELIVER'
AND Nvl(rcv.quantity,0)>0
AND INTERFACE_SOURCE_CODE='RCV'
AND SOURCE_DOCUMENT_CODE='PO';
OR p_x_line_rec.operation ='DELETE'
THEN
IF (p_x_line_rec.ordered_quantity = 0 AND
OE_SALES_CAN_UTIL.G_REQUIRE_REASON) OR
p_x_line_rec.operation = 'DELETE' THEN
l_operation := 'CANCEL';
SELECT nvl(bic.required_for_revenue, 0)
INTO l_is_rfr
FROM oe_order_lines Line,
bom_inventory_components bic
WHERE Line.line_id = p_line_id
AND Line.open_flag = 'N'
AND bic.component_sequence_id = Line.component_sequence_id
AND bic.component_item_id = Line.inventory_item_id;
SELECT count(1)
INTO l_open_rfr_lines
FROM oe_order_lines Line,
bom_inventory_components bic
WHERE Line.line_id <> p_line_id
AND Line.top_model_line_id = p_top_model_line_id
AND Line.link_to_line_id = p_link_to_line_id
AND Line.open_flag = 'Y'
AND bic.component_sequence_id = Line.component_sequence_id
AND bic.component_item_id = Line.inventory_item_id
AND bic.required_for_revenue = 1;
SELECT ACTIVITY_STATUS
INTO l_activity_status_code
FROM wf_item_activity_statuses wias,
wf_process_activities wpa
WHERE wias.item_type = 'OEOL'
AND wias.item_key = to_char(p_link_to_line_id)
AND wias.process_activity = wpa.instance_id
AND wpa.activity_item_type = 'OEOL'
AND wpa.activity_name = 'INVOICING_WAIT_FOR_RFR'
AND wias.activity_status = 'NOTIFIED';
Update oe_order_lines
Set flow_status_code = 'INVOICED'
Where line_id = p_link_to_line_id;