[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
delivery_table.delete;
SELECT NVL(CUSTOMER_ID,-1),
NVL(FOB_CODE, 'XX'),
NVL(FREIGHT_TERMS_CODE, 'XX'),
CURRENCY_CODE
FROM SO_HEADERS_ALL
WHERE HEADER_ID = x_header_id;
SELECT UOM_CODE
FROM MTL_UNITS_OF_MEASURE
WHERE BASE_UOM_FLAG = 'Y'
AND UOM_CLASS = x_uom_class ;
WSH_UTIL.Write_Log('Calling WSH_DELIVERIES_PKG.Insert_Row');
WSH_DELIVERIES_PKG1.Insert_Row(
X_Rowid => v_rowid,
X_Organization_Id => p_organization_id,
X_Delivery_Id => v_delivery_id,
X_Name => v_delivery_name,
X_Source_Code => 'S',
X_Planned_Departure_Id => '',
X_Actual_Departure_Id => '',
X_Status_Code => 'OP',
X_Loading_Order_Flag => NULL,
X_Date_Closed => NULL,
X_Report_Set_Id => v_delivery_report_set_id,
X_Sequence_Number => NULL,
X_Customer_Id => v_customer_id,
X_Ultimate_Ship_To_Id => p_ship_to_site_use_id,
X_Intermediate_Ship_To_Id => NULL,
X_Pooled_Ship_To_Id => NULL,
X_Waybill => NULL,
X_Gross_Weight => NULL,
X_Weight_Uom_Code => v_weight_uom_code,
X_Volume => NULL,
X_Volume_Uom_Code => v_volume_uom_code,
X_Picked_By_Id => NULL,
X_Packed_By_Id => NULL,
X_Expected_Arrival_Date => NULL,
X_Asn_Date_Sent => NULL,
X_Asn_Seq_Number => NULL,
X_Freight_Carrier_Code => p_ship_method_code,
X_Freight_Terms_Code => v_freight_terms_code,
X_Currency_Code => v_currency_code,
X_Fob_Code => v_fob_code,
X_Attribute_Category => NULL,
X_Attribute1 => NULL,
X_Attribute2 => NULL,
X_Attribute3 => NULL,
X_Attribute4 => NULL,
X_Attribute5 => NULL,
X_Attribute6 => NULL,
X_Attribute7 => NULL,
X_Attribute8 => NULL,
X_Attribute9 => NULL,
X_Attribute10 => NULL,
X_Attribute11 => NULL,
X_Attribute12 => NULL,
X_Attribute13 => NULL,
X_Attribute14 => NULL,
X_Attribute15 => NULL,
X_Creation_Date => SYSDATE,
X_Created_By => user_id,
X_Last_Update_Date => SYSDATE,
X_Last_Updated_By => user_id,
X_Last_Update_Login => login_id
);