Line 110: x_create_shipment_flag VARCHAR2(1) := NVL(FND_PROFILE.VALUE('RCV_CREATE_SHIPMENT_FOR_RETURNS'),'N'); -- rtv project
106: from WMS_LICENSE_PLATE_NUMBERS
107: where LPN_ID = p_license_plate_id
108: AND ROWNUM<=1;
109: 110: x_create_shipment_flag VARCHAR2(1) := NVL(FND_PROFILE.VALUE('RCV_CREATE_SHIPMENT_FOR_RETURNS'),'N'); -- rtv project 111: BEGIN
112:
113: if (x_parent_transaction_type is not null) then
114: open get_po_lookup_code('RCV TRANSACTION TYPE',x_parent_transaction_type);