[Home] [Help]
2716: AND POL.PO_HEADER_ID = OO.po_header_id
2717: -- Added by jaramana on January 9, 2008 to fix the Bug 5358438/5967633
2718: AND NVL(POL.CANCEL_FLAG, 'N') <> 'Y'
2719: --the line_id should not have already been associated to the same osp order
2720: AND NOT EXISTS (select 1 from ahl_osp_order_lines
2721: where osp_order_id = p_osp_order_id
2722: and po_line_id = p_po_line_id );
2723: -- jaramana End
2724: l_exist VARCHAR2(1);
2777:
2778: /*
2779: - Changed by jaramana on January 9, 2008 for the Requisition ER 6034236 (We are not using this procedure anymore):
2780: Commented the nullify_exchange_instance procedure and placed it at the end of package. Please note that instead of using this
2781: heavy weight procedure we are directly updating the AHL_OSP_ORDER_LINES table
2782: */
2783:
2784: --------------------------------------------------------------------------------------------------------------
2785: -- Jerry made minor changes to this procedure for ISO in May 27, 2005
2789: PROCEDURE process_order_status_change(
2790: p_x_osp_order_rec IN OUT NOCOPY osp_order_rec_type)
2791: IS
2792: CURSOR val_order_has_lines(p_osp_order_id IN NUMBER)IS
2793: SELECT 'x' FROM ahl_osp_order_lines
2794: WHERE osp_order_id = p_osp_order_id;
2795: l_exist VARCHAR2(1);
2796: CURSOR val_order_has_ship_lines(p_osp_order_id IN NUMBER)IS
2797: SELECT oe_ship_line_id, oe_return_line_id, osp_line_number FROM ahl_osp_order_lines
2793: SELECT 'x' FROM ahl_osp_order_lines
2794: WHERE osp_order_id = p_osp_order_id;
2795: l_exist VARCHAR2(1);
2796: CURSOR val_order_has_ship_lines(p_osp_order_id IN NUMBER)IS
2797: SELECT oe_ship_line_id, oe_return_line_id, osp_line_number FROM ahl_osp_order_lines
2798: WHERE osp_order_id = p_osp_order_id;
2799: l_oe_ship_line_id NUMBER;
2800: l_oe_return_line_id NUMBER;
2801: l_line_number NUMBER;
2809: l_shipment_IDs_Tbl AHL_OSP_SHIPMENT_PUB.Ship_ID_Tbl_Type;
2810: CURSOR val_all_wo_closed(p_osp_order_id IN NUMBER) IS
2811: --Modified by mpothuku on 27-Feb-06 to use ahl_workorders instead of ahl_workorders_osp_v
2812: --to fix the Perf Bug #4919164
2813: SELECT 'x' from ahl_osp_order_lines OL, ahl_workorders WO
2814: WHERE OL.osp_order_id = p_osp_order_id
2815: AND OL.workorder_id = WO.workorder_id
2816: AND OL.status_code IS NULL
2817: AND WO.status_code NOT IN(G_OSP_WO_CANCELLED,G_OSP_WO_CLOSED);
2816: AND OL.status_code IS NULL
2817: AND WO.status_code NOT IN(G_OSP_WO_CANCELLED,G_OSP_WO_CLOSED);
2818: CURSOR val_order_lines_csr(p_osp_order_id IN NUMBER) IS
2819: SELECT osp_line_number, service_item_id, service_item_description, service_item_uom_code, quantity, need_by_date, po_line_type_id
2820: FROM AHL_OSP_ORDER_LINES
2821: WHERE osp_order_id = p_osp_order_id
2822: ORDER BY osp_line_number;
2823: CURSOR get_old_status IS
2824: SELECT status_code, object_version_number
2825: FROM ahl_osp_orders_b
2826: WHERE osp_order_id = p_x_osp_order_rec.osp_order_id;
2827: --jrotich added for osp receiving
2828: CURSOR val_all_acc_closed(p_osp_order_id IN NUMBER) IS
2829: SELECT 'x' from ahl_osp_order_lines OL, ahl_osp_accomplishments AOA
2830: WHERE OL.osp_order_id = p_osp_order_id
2831: AND ol.osp_order_line_id = AOA.OSP_ORDER_LINE_ID
2832: AND AOA.STATUS_CODE = G_OSP_AOA_OPEN;
2833: --jrotich end
3160: l_return_status VARCHAR2(1);
3161: l_msg_count NUMBER;
3162: l_msg_data VARCHAR2(1000);
3163: CURSOR can_del_ship_line_csr(p_osp_order_id IN NUMBER, p_oe_ship_line_id IN NUMBER) IS
3164: SELECT 'x' FROM ahl_osp_order_lines
3165: WHERE osp_order_id = p_osp_order_id
3166: AND oe_ship_line_id = p_oe_ship_line_id
3167: AND status_code IS NULL;
3168: CURSOR can_del_return_line_csr(p_osp_order_id IN NUMBER, p_oe_return_line_id IN NUMBER) IS
3165: WHERE osp_order_id = p_osp_order_id
3166: AND oe_ship_line_id = p_oe_ship_line_id
3167: AND status_code IS NULL;
3168: CURSOR can_del_return_line_csr(p_osp_order_id IN NUMBER, p_oe_return_line_id IN NUMBER) IS
3169: SELECT 'x' FROM ahl_osp_order_lines
3170: WHERE osp_order_id = p_osp_order_id
3171: AND oe_return_line_id = p_oe_return_line_id
3172: AND status_code IS NULL;
3173: CURSOR line_already_shipped_csr(p_oe_line_id IN NUMBER) IS
3313: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,
3314: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type
3315: ) RETURN BOOLEAN IS
3316: CURSOR order_has_ship_return_csr(p_osp_order_id IN NUMBER) IS
3317: SELECT 'x' FROM ahl_osp_order_lines ol --, oe_order_lines_all oel
3318: WHERE ol.osp_order_id = p_osp_order_id
3319: AND ol.oe_return_line_id IS NOT NULL; --= oel.line_id;
3320: CURSOR order_header_status_csr(p_osp_order_id IN NUMBER) IS
3321: SELECT status_code FROM ahl_osp_orders_b
3471: --salogan added for supplier warranty ends
3472:
3473: CURSOR get_order_lines(c_osp_order_id NUMBER) IS
3474: SELECT osp_order_line_id
3475: FROM ahl_osp_order_lines
3476: WHERE osp_order_id = c_osp_order_id;
3477: BEGIN
3478: --Initialize API return status to success
3479: x_return_status := FND_API.G_RET_STS_SUCCESS;
3555: --Front end just passes osp_order_line_id and operation_flag
3556: BEGIN
3557: SELECT osp_order_id, oe_ship_line_id, oe_return_line_id
3558: INTO l_osp_order_id, l_oe_ship_line_id, l_oe_return_line_id
3559: FROM ahl_osp_order_lines
3560: WHERE osp_order_line_id = p_x_osp_order_lines_tbl(i).osp_order_line_id;
3561:
3562: SELECT status_code, oe_header_id INTO l_status_code, l_oe_header_id
3563: FROM ahl_osp_orders_b
3610: -- salogan added the following for supplier warranty ends
3611:
3612: --Delete OSP line record first (it makes more sense to delete shipment lines first, but
3613: --here just keep it the same as the old logic).
3614: AHL_OSP_ORDER_LINES_PKG.delete_row(p_x_osp_order_lines_tbl(i).osp_order_line_id);
3615:
3616: --Delete or cancel shipment lines
3617: delete_cancel_so(
3618: p_oe_header_id => NULL,
3809: FOR l_get_order_lines IN get_order_lines(p_x_osp_order_rec.osp_order_id) LOOP
3810: BEGIN
3811: SELECT oe_ship_line_id, oe_return_line_id
3812: INTO l_oe_ship_line_id, l_oe_return_line_id
3813: FROM ahl_osp_order_lines
3814: WHERE osp_order_line_id = l_get_order_lines.osp_order_line_id;
3815: EXCEPTION
3816: WHEN NO_DATA_FOUND THEN
3817: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_ORD_ID_LN_INV');
3870: -- salogan added the following for supplier warranty ends
3871:
3872: --Delete OSP order lines
3873: FOR l_get_order_lines IN get_order_lines(p_x_osp_order_rec.osp_order_id) LOOP
3874: AHL_OSP_ORDER_LINES_PKG.delete_row(l_get_order_lines.osp_order_line_id);
3875: END LOOP;
3876:
3877: --Delete OSP order header record
3878: AHL_OSP_ORDERS_PKG.delete_row(x_osp_order_id => p_x_osp_order_rec.osp_order_id);
3906: --Front end just passes osp_order_line_id and operation_flag
3907: BEGIN
3908: SELECT osp_order_id, oe_ship_line_id, oe_return_line_id
3909: INTO l_osp_order_id, l_oe_ship_line_id, l_oe_return_line_id
3910: FROM ahl_osp_order_lines
3911: WHERE osp_order_line_id = p_x_osp_order_lines_tbl(i).osp_order_line_id;
3912:
3913: SELECT status_code, oe_header_id INTO l_status_code, l_oe_header_id
3914: FROM ahl_osp_orders_b
3963: -- salogan added the following for supplier warranty ends
3964:
3965: --Delete line record first (it makes more sense to delete shipment lines first, but
3966: --here just keep it the same as the old logic.
3967: AHL_OSP_ORDER_LINES_PKG.delete_row(p_x_osp_order_lines_tbl(i).osp_order_line_id);
3968:
3969: --Delete or cancel Shipment lines
3970: delete_cancel_so(
3971: p_oe_header_id => NULL,
3974: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_ORD_INVOP');
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_ERROR;
3977: END IF;
3978: --AHL_OSP_ORDER_LINES_PKG.delete_row(p_x_osp_order_lines_tbl(i).osp_order_line_id);
3979: ELSIF (p_x_osp_order_lines_tbl(i).operation_flag = G_OP_UPDATE) THEN
3980: --update osp order line
3981: update_osp_order_line(p_x_osp_order_lines_tbl(i));
3982: -- salogan added for supplier warranty starts
4587: l_oe_header_id NUMBER;
4588: CURSOR get_all_lines(c_osp_order_id NUMBER) IS
4589: SELECT osp_order_line_id, inventory_item_id,
4590: inventory_org_id, service_item_id, workorder_id
4591: FROM ahl_osp_order_lines
4592: WHERE osp_order_id = c_osp_order_id;
4593: CURSOR get_old_vendor_attrs(c_osp_order_id NUMBER) IS
4594: SELECT vendor_id, vendor_site_id, oe_header_id
4595: FROM ahl_osp_orders_b
4808:
4809: --yazhou 22-Aug-2006 ends
4810:
4811: --Generate the primary key
4812: SELECT ahl_osp_order_lines_s.NEXTVAL
4813: INTO l_osp_line_id
4814: FROM sys.dual;
4815:
4816: --Generate the line number
4818: --index defined on osp_line_number if two concurrent users try to add osp order line
4819: --to the same OSP Order headet at the same time.
4820: SELECT NVL(MAX(osp_line_number), 0)+1
4821: INTO l_osp_line_number
4822: FROM ahl_osp_order_lines
4823: WHERE osp_order_id = p_x_osp_order_line_rec.osp_order_id;
4824:
4825: /*
4826: Changed by jaramana on January 10, 2008
4972: -- bug fix#5376907
4973: -- Service item qty should be the same as physical item qty at the time of creation
4974:
4975: --Call table handler to insert the line
4976: AHL_OSP_ORDER_LINES_PKG.insert_row(
4977: p_x_osp_order_line_id => l_osp_line_id,
4978: p_object_version_number => 1,
4979: p_created_by => fnd_global.user_id,
4980: p_creation_date => SYSDATE,
5039: p_x_osp_order_line_rec.ship_by_date := SYSDATE;
5040: END IF;
5041:
5042: --Call table handler to insert the line
5043: AHL_OSP_ORDER_LINES_PKG.insert_row(
5044: p_x_osp_order_line_id => l_osp_line_id,
5045: p_object_version_number => 1,
5046: p_created_by => fnd_global.user_id,
5047: p_creation_date => SYSDATE,
5124: c_inventory_org_id NUMBER,
5125: c_serial_number VARCHAR2,
5126: c_osp_order_id NUMBER) IS
5127: SELECT 'X'
5128: FROM ahl_osp_order_lines
5129: WHERE inventory_item_id = c_inventory_item_id
5130: AND inventory_org_id = c_inventory_org_id
5131: AND serial_number = c_serial_number
5132: AND osp_order_id = c_osp_order_id
5370: c_inv_org_id NUMBER,
5371: c_lot_number VARCHAR2,
5372: c_serial_number VARCHAR2) IS
5373: SELECT 'X'
5374: FROM ahl_osp_order_lines
5375: WHERE osp_order_id = c_osp_order_id
5376: AND ((service_item_id = c_service_item_id) OR
5377: (service_item_id IS NULL AND c_service_item_id IS NULL))
5378: AND inventory_item_id = c_inv_item_id
5380: AND ((lot_number IS NULL AND c_lot_number IS NULL) OR (lot_number = c_lot_number))
5381: AND ((serial_number IS NULL AND c_serial_number IS NULL) OR (serial_number = c_serial_number));
5382: CURSOR check_phy_item_unique(c_osp_order_id NUMBER, c_inv_item_id NUMBER) IS
5383: SELECT 'X'
5384: FROM ahl_osp_order_lines
5385: WHERE inventory_item_id = c_inv_item_id
5386: AND osp_order_id = c_osp_order_id;
5387:
5388: --yazhou 22-Aug-2006 starts
5391: /*
5392: CURSOR check_osp_order_unique(c_osp_order_id NUMBER, c_inventory_item_id NUMBER,
5393: c_inventory_org_id NUMBER, c_serial_number VARCHAR2) IS
5394: SELECT 'X'
5395: FROM ahl_osp_order_lines ospl, ahl_osp_orders_b osp
5396: WHERE ospl.osp_order_id = osp.osp_order_id
5397: AND osp.status_code <> 'CLOSED'
5398: AND ospl.status_code is null
5399: AND ospl.inventory_item_id = c_inventory_item_id
5404: -- Added by jaramana on January 10, 2008 for the Bug 5547870/5673279
5405: CURSOR check_osp_order_unique(c_osp_order_id NUMBER, c_inventory_item_id NUMBER,
5406: c_inventory_org_id NUMBER, c_serial_number VARCHAR2) IS
5407: SELECT 'X'
5408: FROM ahl_osp_order_lines ospl, ahl_osp_orders_b osp, oe_order_lines_all oelship
5409: WHERE ospl.osp_order_id = osp.osp_order_id
5410: AND osp.status_code <> 'CLOSED'
5411: AND oelship.LINE_ID = ospl.OE_SHIP_LINE_ID
5412: --The order line should not be closed and should not be cancelled to be considered in the uniqueness check
5505: --If we are creating an osp order line based on PO line that is created from the Purchasing forms, then
5506: --the work order selected for the order Line, should not be associated with any open order lines
5507: --Note that instead of status_code not in, we could have use status_code is null as well.
5508: AND not exists (select 1
5509: from ahl_osp_order_lines
5510: where workorder_id =p_x_osp_order_line_rec.workorder_id
5511: and nvl(status_code, 'X') not in (G_OL_PO_CANCELLED_STATUS, G_OL_PO_DELETED_STATUS, G_OL_REQ_CANCELLED_STATUS, G_OL_REQ_DELETED_STATUS));
5512: -- jaramana End
5513: ELSE
5871: --Modification by JROTICH for bug#13818139 BEGIN
5872: CURSOR get_exch_instance_id(c_osp_order_line_id NUMBER) is
5873: SELECT
5874: EXCHANGE_INSTANCE_ID
5875: FROM AHL_OSP_ORDER_LINES
5876: WHERE OSP_ORDER_LINE_ID=c_osp_order_line_id;
5877: l_exchange_instance_id NUMBER;
5878: l_msg_count NUMBER;
5879: l_msg_data VARCHAR2(2000);
5950: --Modification by JROTICH: END
5951:
5952:
5953: --call table handler to update the record
5954: AHL_OSP_ORDER_LINES_PKG.update_row(
5955: p_osp_order_line_id => p_x_osp_order_line_rec.osp_order_line_id,
5956: p_object_version_number => p_x_osp_order_line_rec.object_version_number +1,
5957: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
5958: p_osp_line_number => p_x_osp_order_line_rec.osp_line_number,
6016: l_item_description VARCHAR2(240);
6017: l_desc_update_flag VARCHAR2(1);
6018: CURSOR osp_order_line_csr IS
6019: SELECT *
6020: FROM ahl_osp_order_lines
6021: WHERE osp_order_line_id = p_x_osp_order_line_rec.osp_order_line_id
6022: AND object_version_number= p_x_osp_order_line_rec.object_version_number;
6023: l_osp_order_line_rec osp_order_line_csr%ROWTYPE;
6024: CURSOR check_phy_ser_item_unique(c_osp_order_id NUMBER,
6027: c_inv_org_id NUMBER,
6028: c_lot_number VARCHAR2,
6029: c_serial_number VARCHAR2) IS
6030: SELECT 'X'
6031: FROM ahl_osp_order_lines
6032: WHERE osp_order_id = c_osp_order_id
6033: AND ((service_item_id = c_service_item_id) OR
6034: (service_item_id IS NULL AND c_service_item_id IS NULL))
6035: AND inventory_item_id = c_inv_item_id
6037: AND ((lot_number IS NULL AND c_lot_number IS NULL) OR (lot_number = c_lot_number))
6038: AND ((serial_number IS NULL AND c_serial_number IS NULL) OR (serial_number = c_serial_number));
6039: CURSOR check_phy_item_unique(c_osp_order_id NUMBER, c_inv_item_id NUMBER) IS
6040: SELECT 'X'
6041: FROM ahl_osp_order_lines
6042: WHERE inventory_item_id = c_inv_item_id
6043: AND osp_order_id = c_osp_order_id;
6044: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_order_line_update';
6045: --Added by mpothuku on 24-Mar-06 for ER: 4544654
6385: --validate sercice_item_uom (just borrowed the old one)
6386: validate_service_item_uom(p_x_osp_order_line_rec.service_item_id, p_x_osp_order_line_rec.service_item_uom_code, p_x_osp_order_line_rec.inventory_org_id);
6387: --validate sercice_item_quantity(quantity)
6388: --Service item quantity could be from the quantity of PO lines and not necessary to be the same as
6389: --as the value in ahl_osp_order_lines when PO has ever been created
6390: --created
6391: -- Added by jaramana on January 10, 2008 for the Requisition ER 6034236
6392: --Moved the logic below, to above
6393: /*
6631: x_valid_vendors_tbl OUT NOCOPY Vendor_id_tbl_type,
6632: x_any_vendor_flag OUT NOCOPY VARCHAR2) IS
6633:
6634: CURSOR item_service_dtls_csr IS
6635: SELECT INVENTORY_ORG_ID, INVENTORY_ITEM_ID, SERVICE_ITEM_ID FROM ahl_osp_order_lines
6636: WHERE osp_order_id = p_osp_order_id AND
6637: service_item_id IS NOT NULL;
6638:
6639: CURSOR is_vendor_defined_csr (c_inventory_item_id IN NUMBER,
6880: attribute12,
6881: attribute13,
6882: attribute14,
6883: attribute15
6884: FROM ahl_osp_order_lines_v
6885: WHERE osp_order_line_id = p_x_osp_order_line_rec.osp_order_line_id
6886: AND object_version_number= p_x_osp_order_line_rec.object_version_number;
6887: */
6888: SELECT ospl.osp_order_id,
6945: ospl.attribute12,
6946: ospl.attribute13,
6947: ospl.attribute14,
6948: ospl.attribute15
6949: FROM ahl_osp_order_lines ospl,
6950: ahl_workorders wo,
6951: ahl_visits_b vst,
6952: ahl_visit_tasks_b vts,
6953: csi_item_instances csiwo,
7372: AND NVL(outside_operation_flag, G_NO_FLAG) = G_NO_FLAG;
7373: l_po_line_type_id NUMBER;
7374: CURSOR osp_order_line_on_csr(p_osp_order_id IN NUMBER, p_osp_line_number IN NUMBER) IS
7375: SELECT osp_order_line_id
7376: FROM ahl_osp_order_lines
7377: WHERE osp_order_id = p_osp_order_id
7378: and osp_line_number = p_osp_line_number;
7379: -- Added by jaramana on January 10, 2008 for the Requisition ER 6034236
7380: -- We are not planning to derive the OSP_ORDER_LINE_ID from PO_LINE_ID
7380: -- We are not planning to derive the OSP_ORDER_LINE_ID from PO_LINE_ID
7381: /*
7382: CURSOR osp_order_line_po_csr(p_po_line_id IN NUMBER) IS
7383: SELECT osp_order_line_id
7384: FROM ahl_osp_order_lines
7385: WHERE po_line_id = p_po_line_id;
7386: */
7387: -- jaramana End
7388: l_osp_order_line_id NUMBER;
7718: WHERE osp_order_id = p_osp_order_rec.osp_order_id;
7719: IF l_old_type_code <> p_osp_order_rec.order_type_code THEN
7720: IF(can_convert_order(p_osp_order_rec.osp_order_id, l_old_type_code, p_osp_order_rec.order_type_code)) THEN
7721: IF(p_osp_order_rec.order_type_code = G_OSP_ORDER_TYPE_SERVICE) THEN
7722: UPDATE ahl_osp_order_lines
7723: SET exchange_instance_id = NULL,
7724: last_update_date = SYSDATE,
7725: last_updated_by = fnd_global.user_id,
7726: last_update_login = fnd_global.login_id,
7773: SELECT 'X'
7774: FROM AHL_WARRANTY_ENTITLEMENTS AWSE,
7775: AHL_WARRANTY_CONTRACTS_B AWCB,
7776: AHL_OSP_ORDERS_B AOOB,
7777: AHL_OSP_ORDER_LINES AOOL
7778: WHERE AOOB.OSP_ORDER_ID = AOOL.OSP_ORDER_ID
7779: AND AOOL.OSP_ORDER_LINE_ID = AWSE.OSP_ORDER_LINE_ID
7780: AND AWCB.WARRANTY_CONTRACT_ID = AWSE.WARRANTY_CONTRACT_ID
7781: AND AOOB.STATUS_CODE = 'SUBMITTED'
8126:
8127: --Cursor to fetch osp lines for a given osp order
8128: CURSOR c_get_osp_lines (c_osp_order_id IN NUMBER) IS
8129: SELECT OSP_ORDER_LINE_ID
8130: FROM AHL_OSP_ORDER_LINES
8131: WHERE OSP_ORDER_ID = c_osp_order_id;
8132:
8133: BEGIN
8134: --------------------Start of API Body-----------------------------------
8230: osp_order_id, osp_line_number, status_code , po_line_type_id, service_item_id, service_item_description , service_item_uom_code,
8231: need_by_date, ship_by_date, po_line_id, oe_ship_line_id , oe_return_line_id , workorder_id, operation_id,
8232: quantity, exchange_instance_id, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6,
8233: attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15
8234: FROM ahl_osp_order_lines
8235: WHERE osp_order_id = p_osp_order_id;
8236: l_osp_order_lines_rec osp_order_line_rec_type;
8237: CURSOR l_order_line_obj_ver_csr(p_osp_order_line_id IN NUMBER) IS
8238: SELECT object_version_number FROM ahl_osp_order_lines
8234: FROM ahl_osp_order_lines
8235: WHERE osp_order_id = p_osp_order_id;
8236: l_osp_order_lines_rec osp_order_line_rec_type;
8237: CURSOR l_order_line_obj_ver_csr(p_osp_order_line_id IN NUMBER) IS
8238: SELECT object_version_number FROM ahl_osp_order_lines
8239: WHERE osp_order_line_id = p_osp_order_line_id;
8240: i NUMBER; --index for looping
8241: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.nullify_exchange_instance';
8242: BEGIN
8284: l_osp_order_lines_rec.attribute15 ;
8285: IF(l_order_lines_csr %NOTFOUND) THEN
8286: EXIT;
8287: END IF;
8288: AHL_OSP_ORDER_LINES_PKG.update_row(
8289: p_osp_order_line_id => l_osp_order_lines_rec.osp_order_line_id,
8290: p_object_version_number => l_osp_order_lines_rec.object_version_number + 1,
8291: p_last_update_date => l_osp_order_lines_rec.last_update_date,
8292: p_last_updated_by => l_osp_order_lines_rec.last_updated_by,