The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_api_name CONSTANT VARCHAR2(30) := 'Update_Line_Ack';
SELECT order_source_id
, orig_sys_document_ref
, change_sequence
, orig_sys_line_ref
, orig_sys_shipment_ref
, nvl(org_id, FND_API.G_MISS_NUM)
, nvl(line_number, FND_API.G_MISS_NUM)
, nvl(shipment_number, FND_API.G_MISS_NUM)
, nvl(line_id, FND_API.G_MISS_NUM)
, nvl(line_type_id, FND_API.G_MISS_NUM)
, nvl(item_type_code, FND_API.G_MISS_CHAR)
, nvl(inventory_item_id, FND_API.G_MISS_NUM)
, nvl(first_ack_code, FND_API.G_MISS_CHAR)
, nvl(first_ack_date, FND_API.G_MISS_DATE)
, nvl(last_ack_code, FND_API.G_MISS_CHAR)
, nvl(last_ack_date, FND_API.G_MISS_DATE)
FROM oe_order_lines
WHERE order_source_id = l_order_source_id
AND orig_sys_document_ref = l_orig_sys_document_ref
AND change_sequence = l_change_sequence
AND orig_sys_line_ref = l_orig_sys_line_ref
AND orig_sys_shipment_ref = l_orig_sys_shipment_ref
ORDER BY orig_sys_line_ref, orig_sys_shipment_ref
;
l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
oe_debug_pub.add( 'ACKNOWLEDGMENT CODE AND DATE UPDATED FOR LINE REF: '|| L_ORIG_SYS_LINE_REF ) ;
End of Update Line Ack
-----------------------------------------------------------
*/
IF l_debug_level > 0 THEN
oe_debug_pub.add( 'END OF UPDATE LINE ACK' ) ;
END Update_Line_Ack;