eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERIES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13


  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Organization_Id                NUMBER,
                       X_Delivery_Id                    NUMBER,
                       X_Name                    IN OUT VARCHAR2,
                       X_Source_Code                    VARCHAR2,
                       X_Planned_Departure_Id           NUMBER,
                       X_Actual_Departure_Id            NUMBER,
                       X_Status_Code                    VARCHAR2,
                       X_Loading_Order_Flag             VARCHAR2,
                       X_Date_Closed                    DATE,
                       X_Report_Set_Id                  NUMBER,
                       X_Sequence_Number                NUMBER,
                       X_Customer_Id                    NUMBER,
                       X_Ultimate_Ship_To_Id            NUMBER,
                       X_Intermediate_Ship_To_Id        NUMBER,
                       X_Pooled_Ship_To_Id              NUMBER,
                       X_Waybill                        VARCHAR2,
                       X_Gross_Weight                   NUMBER,
                       X_Weight_Uom_Code                VARCHAR2,
                       X_Volume                         NUMBER,
                       X_Volume_Uom_Code                VARCHAR2,
                       X_Picked_By_Id                   NUMBER,
                       X_Packed_By_Id                   NUMBER,
                       X_Expected_Arrival_Date          DATE,
                       X_Asn_Date_Sent                  DATE,
                       X_Asn_Seq_Number                 NUMBER,
                       X_Freight_Carrier_Code           VARCHAR2,
                       X_Freight_Terms_Code             VARCHAR2,
                       X_Currency_Code                  VARCHAR2,
                       X_Fob_Code                       VARCHAR2,
                       X_Attribute_Category             VARCHAR2,
                       X_Attribute1                     VARCHAR2,
                       X_Attribute2                     VARCHAR2,
                       X_Attribute3                     VARCHAR2,
                       X_Attribute4                     VARCHAR2,
                       X_Attribute5                     VARCHAR2,
                       X_Attribute6                     VARCHAR2,
                       X_Attribute7                     VARCHAR2,
                       X_Attribute8                     VARCHAR2,
                       X_Attribute9                     VARCHAR2,
                       X_Attribute10                    VARCHAR2,
                       X_Attribute11                    VARCHAR2,
                       X_Attribute12                    VARCHAR2,
                       X_Attribute13                    VARCHAR2,
                       X_Attribute14                    VARCHAR2,
                       X_Attribute15                    VARCHAR2,
                       X_Global_Attribute_Category      VARCHAR2 default null,
                       X_Global_Attribute1              VARCHAR2 default null,
                       X_Global_Attribute2              VARCHAR2 default null,
                       X_Global_Attribute3              VARCHAR2 default null,
                       X_Global_Attribute4              VARCHAR2 default null,
                       X_Global_Attribute5              VARCHAR2 default null,
                       X_Global_Attribute6              VARCHAR2 default null,
                       X_Global_Attribute7              VARCHAR2 default null,
                       X_Global_Attribute8              VARCHAR2 default null,
                       X_Global_Attribute9              VARCHAR2 default null,
                       X_Global_Attribute10             VARCHAR2 default null,
                       X_Global_Attribute11             VARCHAR2 default null,
                       X_Global_Attribute12             VARCHAR2 default null,
                       X_Global_Attribute13             VARCHAR2 default null,
                       X_Global_Attribute14             VARCHAR2 default null,
                       X_Global_Attribute15             VARCHAR2 default null,
                       X_Global_Attribute16             VARCHAR2 default null,
                       X_Global_Attribute17             VARCHAR2 default null,
                       X_Global_Attribute18             VARCHAR2 default null,
                       X_Global_Attribute19             VARCHAR2 default null,
                       X_Global_Attribute20             VARCHAR2 default null,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER
  ) IS
    dname 		wsh_deliveries.name%TYPE;

Line: 85


    CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;

Line: 87


      SELECT COUNT(*) FROM wsh_deliveries
      WHERE name = del_name;

Line: 129


    UPDATE wsh_deliveries
    SET
       organization_id                 =     X_Organization_Id,
       delivery_id                     =     X_Delivery_Id,
       name                            =     X_Name,
       source_code                     =     X_Source_Code,
       planned_departure_id            =     X_Planned_Departure_Id,
       actual_departure_id             =     X_Actual_Departure_Id,
       status_code                     =     X_Status_Code,
       loading_order_flag              =     X_Loading_Order_Flag,
       date_closed                     =     X_Date_Closed,
       report_set_id                   =     X_Report_Set_Id,
       sequence_number                 =     X_Sequence_Number,
       customer_id                     =     X_Customer_Id,
       ultimate_ship_to_id             =     X_Ultimate_Ship_To_Id,
       intermediate_ship_to_id         =     X_Intermediate_Ship_To_Id,
       pooled_ship_to_id               =     X_Pooled_Ship_To_Id,
       waybill                         =     X_Waybill,
       gross_weight                    =     X_Gross_Weight,
       weight_uom_code                 =     X_Weight_Uom_Code,
       volume                          =     X_Volume,
       volume_uom_code                 =     X_Volume_Uom_Code,
       picked_by_id                    =     X_Picked_By_Id,
       packed_by_id                    =     X_Packed_By_Id,
       expected_arrival_date           =     X_Expected_Arrival_Date,
       asn_date_sent                   =     X_Asn_Date_Sent,
       asn_seq_number                  =     X_Asn_Seq_Number,
       freight_carrier_code            =     X_Freight_Carrier_Code,
       freight_terms_code              =     X_Freight_Terms_Code,
       currency_code                   =     X_Currency_Code,
       fob_code                        =     X_Fob_Code,
       attribute_category              =     X_Attribute_Category,
       attribute1                      =     X_Attribute1,
       attribute2                      =     X_Attribute2,
       attribute3                      =     X_Attribute3,
       attribute4                      =     X_Attribute4,
       attribute5                      =     X_Attribute5,
       attribute6                      =     X_Attribute6,
       attribute7                      =     X_Attribute7,
       attribute8                      =     X_Attribute8,
       attribute9                      =     X_Attribute9,
       attribute10                     =     X_Attribute10,
       attribute11                     =     X_Attribute11,
       attribute12                     =     X_Attribute12,
       attribute13                     =     X_Attribute13,
       attribute14                     =     X_Attribute14,
       attribute15                     =     X_Attribute15,
       global_attribute_category       =     X_Global_Attribute_Category,
       global_attribute1               =     X_Global_Attribute1,
       global_attribute2               =     X_Global_Attribute2,
       global_attribute3               =     X_Global_Attribute3,
       global_attribute4               =     X_Global_Attribute4,
       global_attribute5               =     X_Global_Attribute5,
       global_attribute6               =     X_Global_Attribute6,
       global_attribute7               =     X_Global_Attribute7,
       global_attribute8               =     X_Global_Attribute8,
       global_attribute9               =     X_Global_Attribute9,
       global_attribute10              =     X_Global_Attribute10,
       global_attribute11              =     X_Global_Attribute11,
       global_attribute12              =     X_Global_Attribute12,
       global_attribute13              =     X_Global_Attribute13,
       global_attribute14              =     X_Global_Attribute14,
       global_attribute15              =     X_Global_Attribute15,
       global_attribute16              =     X_Global_Attribute16,
       global_attribute17              =     X_Global_Attribute17,
       global_attribute18              =     X_Global_Attribute18,
       global_attribute19              =     X_Global_Attribute19,
       global_attribute20              =     X_Global_Attribute20,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login
    WHERE rowid = X_Rowid;

Line: 205


  END Update_Row;

Line: 278


        SELECT *
        FROM   wsh_deliveries
        WHERE  rowid = X_Rowid
        FOR UPDATE of Delivery_Id NOWAIT;

Line: 290


      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 489


  PROCEDURE Update_Row_new(X_Rowid                          VARCHAR2,
                       X_Organization_Id                NUMBER,
                       X_Delivery_Id                    NUMBER,
                       X_Name                    IN OUT VARCHAR2,
                       X_Source_Code                    VARCHAR2,
                       X_Planned_Departure_Id           NUMBER,
                       X_Actual_Departure_Id            NUMBER,
                       X_Status_Code                    VARCHAR2,
                       X_Loading_Order_Flag             VARCHAR2,
                       X_Date_Closed                    DATE,
                       X_Report_Set_Id                  NUMBER,
                       X_Sequence_Number                NUMBER,
                       X_Customer_Id                    NUMBER,
                       X_Ultimate_Ship_To_Id            NUMBER,
                       X_Intermediate_Ship_To_Id        NUMBER,
                       X_Pooled_Ship_To_Id              NUMBER,
                       X_Waybill                        VARCHAR2,
                       X_Gross_Weight                   NUMBER,
				   X_Net_Weight                     NUMBER,
                       X_Weight_Uom_Code                VARCHAR2,
                       X_Volume                         NUMBER,
                       X_Volume_Uom_Code                VARCHAR2,
                       X_Picked_By_Id                   NUMBER,
                       X_Packed_By_Id                   NUMBER,
                       X_Expected_Arrival_Date          DATE,
                       X_Asn_Date_Sent                  DATE,
                       X_Asn_Seq_Number                 NUMBER,
                       X_Freight_Carrier_Code           VARCHAR2,
                       X_Freight_Terms_Code             VARCHAR2,
                       X_Currency_Code                  VARCHAR2,
                       X_Fob_Code                       VARCHAR2,
                       X_Attribute_Category             VARCHAR2,
                       X_Attribute1                     VARCHAR2,
                       X_Attribute2                     VARCHAR2,
                       X_Attribute3                     VARCHAR2,
                       X_Attribute4                     VARCHAR2,
                       X_Attribute5                     VARCHAR2,
                       X_Attribute6                     VARCHAR2,
                       X_Attribute7                     VARCHAR2,
                       X_Attribute8                     VARCHAR2,
                       X_Attribute9                     VARCHAR2,
                       X_Attribute10                    VARCHAR2,
                       X_Attribute11                    VARCHAR2,
                       X_Attribute12                    VARCHAR2,
                       X_Attribute13                    VARCHAR2,
                       X_Attribute14                    VARCHAR2,
                       X_Attribute15                    VARCHAR2,
                       X_Global_Attribute_Category      VARCHAR2 default null,
                       X_Global_Attribute1              VARCHAR2 default null,
                       X_Global_Attribute2              VARCHAR2 default null,
                       X_Global_Attribute3              VARCHAR2 default null,
                       X_Global_Attribute4              VARCHAR2 default null,
                       X_Global_Attribute5              VARCHAR2 default null,
                       X_Global_Attribute6              VARCHAR2 default null,
                       X_Global_Attribute7              VARCHAR2 default null,
                       X_Global_Attribute8              VARCHAR2 default null,
                       X_Global_Attribute9              VARCHAR2 default null,
                       X_Global_Attribute10             VARCHAR2 default null,
                       X_Global_Attribute11             VARCHAR2 default null,
                       X_Global_Attribute12             VARCHAR2 default null,
                       X_Global_Attribute13             VARCHAR2 default null,
                       X_Global_Attribute14             VARCHAR2 default null,
                       X_Global_Attribute15             VARCHAR2 default null,
                       X_Global_Attribute16             VARCHAR2 default null,
                       X_Global_Attribute17             VARCHAR2 default null,
                       X_Global_Attribute18             VARCHAR2 default null,
                       X_Global_Attribute19             VARCHAR2 default null,
                       X_Global_Attribute20             VARCHAR2 default null,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER
  ) IS
    dname 		wsh_deliveries.name%TYPE;

Line: 562


    CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;

Line: 564


      SELECT COUNT(*) FROM wsh_deliveries
      WHERE name = del_name;

Line: 606


    UPDATE wsh_deliveries
    SET
       organization_id                 =     X_Organization_Id,
       delivery_id                     =     X_Delivery_Id,
       name                            =     X_Name,
       source_code                     =     X_Source_Code,
       planned_departure_id            =     X_Planned_Departure_Id,
       actual_departure_id             =     X_Actual_Departure_Id,
       status_code                     =     X_Status_Code,
       loading_order_flag              =     X_Loading_Order_Flag,
       date_closed                     =     X_Date_Closed,
       report_set_id                   =     X_Report_Set_Id,
       sequence_number                 =     X_Sequence_Number,
       customer_id                     =     X_Customer_Id,
       ultimate_ship_to_id             =     X_Ultimate_Ship_To_Id,
       intermediate_ship_to_id         =     X_Intermediate_Ship_To_Id,
       pooled_ship_to_id               =     X_Pooled_Ship_To_Id,
       waybill                         =     X_Waybill,
       gross_weight                    =     X_Gross_Weight,
	  net_weight                      =     X_Net_Weight,
       weight_uom_code                 =     X_Weight_Uom_Code,
       volume                          =     X_Volume,
       volume_uom_code                 =     X_Volume_Uom_Code,
       picked_by_id                    =     X_Picked_By_Id,
       packed_by_id                    =     X_Packed_By_Id,
       expected_arrival_date           =     X_Expected_Arrival_Date,
       asn_date_sent                   =     X_Asn_Date_Sent,
       asn_seq_number                  =     X_Asn_Seq_Number,
       freight_carrier_code            =     X_Freight_Carrier_Code,
       freight_terms_code              =     X_Freight_Terms_Code,
       currency_code                   =     X_Currency_Code,
       fob_code                        =     X_Fob_Code,
       attribute_category              =     X_Attribute_Category,
       attribute1                      =     X_Attribute1,
       attribute2                      =     X_Attribute2,
       attribute3                      =     X_Attribute3,
       attribute4                      =     X_Attribute4,
       attribute5                      =     X_Attribute5,
       attribute6                      =     X_Attribute6,
       attribute7                      =     X_Attribute7,
       attribute8                      =     X_Attribute8,
       attribute9                      =     X_Attribute9,
       attribute10                     =     X_Attribute10,
       attribute11                     =     X_Attribute11,
       attribute12                     =     X_Attribute12,
       attribute13                     =     X_Attribute13,
       attribute14                     =     X_Attribute14,
       attribute15                     =     X_Attribute15,
       global_attribute_category       =     X_Global_Attribute_Category,
       global_attribute1               =     X_Global_Attribute1,
       global_attribute2               =     X_Global_Attribute2,
       global_attribute3               =     X_Global_Attribute3,
       global_attribute4               =     X_Global_Attribute4,
       global_attribute5               =     X_Global_Attribute5,
       global_attribute6               =     X_Global_Attribute6,
       global_attribute7               =     X_Global_Attribute7,
       global_attribute8               =     X_Global_Attribute8,
       global_attribute9               =     X_Global_Attribute9,
       global_attribute10              =     X_Global_Attribute10,
       global_attribute11              =     X_Global_Attribute11,
       global_attribute12              =     X_Global_Attribute12,
       global_attribute13              =     X_Global_Attribute13,
       global_attribute14              =     X_Global_Attribute14,
       global_attribute15              =     X_Global_Attribute15,
       global_attribute16              =     X_Global_Attribute16,
       global_attribute17              =     X_Global_Attribute17,
       global_attribute18              =     X_Global_Attribute18,
       global_attribute19              =     X_Global_Attribute19,
       global_attribute20              =     X_Global_Attribute20,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login
    WHERE rowid = X_Rowid;

Line: 683


  END Update_Row_new;

Line: 757


        SELECT *
        FROM   wsh_deliveries
        WHERE  rowid = X_Rowid
        FOR UPDATE of Delivery_Id NOWAIT;

Line: 769


      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');