APPS.WSH_DELIVERY_LINES_DPW_V_PKG SQL Statements

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

Line: 20

                        X_Last_Update_Date               DATE,
                        X_Last_Updated_By		 NUMBER,
                        X_Last_Update_Login		 NUMBER
  ) IS
    CURSOR C IS
        SELECT *
        FROM   so_line_details
        WHERE  rowid = X_Rowid
        FOR UPDATE of Line_Detail_Id NOWAIT;

Line: 36

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

Line: 63

           AND (   (Recinfo.last_update_date =  X_Last_Update_Date)
                OR (    (Recinfo.last_update_date IS NULL)
                    AND (X_Last_Update_Date IS NULL)))
           AND (   (Recinfo.last_updated_by =  X_Last_Updated_By)
                OR (    (Recinfo.last_updated_by IS NULL)
                    AND (X_Last_Updated_By IS NULL)))
           AND (   (Recinfo.last_update_login =  X_Last_Update_Login)
                OR (    (Recinfo.last_update_login IS NULL)
                    AND (X_Last_Update_Login IS NULL)))
      ) then
      return;

Line: 80

  PROCEDURE Update_LD_Row(X_Rowid                          VARCHAR2,
                          X_Delivery_Id                    NUMBER,
                          X_Departure_Id                   NUMBER,
                          X_Load_Seq_Number                NUMBER,
                          X_Master_Container_Item_Id       NUMBER,
                          X_Detail_Container_Item_Id       NUMBER,
                          X_DPW_Assigned_Flag              VARCHAR2,
                          X_Last_Update_Date               DATE,
                          X_Last_Updated_By                NUMBER,
                          X_Last_Update_Login              NUMBER
  ) IS
  BEGIN
    UPDATE so_line_details
    SET
       delivery_id                     =     X_Delivery_Id,
       departure_id                    =     X_Departure_Id,
       load_seq_number                 =     X_Load_Seq_Number,
       master_container_item_id        =     X_Master_Container_Item_Id,
       detail_container_item_id        =     X_Detail_Container_Item_Id,
       dpw_assigned_flag               =     X_DPW_Assigned_Flag,
       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: 108

  END Update_LD_Row;

Line: 120

                         X_Last_Update_Date               DATE,
                         X_Last_Updated_By		  NUMBER,
                         X_Last_Update_Login		  NUMBER
  ) IS
    CURSOR C IS
        SELECT *
        FROM   so_picking_line_details
        WHERE  rowid = X_Rowid
        FOR UPDATE of Picking_Line_Detail_Id NOWAIT;

Line: 137

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

Line: 164

           AND (   (Recinfo.last_update_date =  X_Last_Update_Date)
                OR (    (Recinfo.last_update_date IS NULL)
                    AND (X_Last_Update_Date IS NULL)))
           AND (   (Recinfo.last_updated_by =  X_Last_Updated_By)
                OR (    (Recinfo.last_updated_by IS NULL)
                    AND (X_Last_Updated_By IS NULL)))
           AND (   (Recinfo.last_update_login =  X_Last_Update_Login)
                OR (    (Recinfo.last_update_login IS NULL)
                    AND (X_Last_Update_Login IS NULL)))
      ) then
      return;

Line: 181

  PROCEDURE Update_PLD_Row(X_Rowid                          VARCHAR2,
                           X_Delivery_Id                    NUMBER,
                           X_Departure_Id                   NUMBER,
                           X_Load_Seq_Number                NUMBER,
                           X_Master_Container_Item_Id       NUMBER,
                           X_Detail_Container_Item_Id       NUMBER,
                           X_DPW_Assigned_Flag              VARCHAR2,
                           X_Last_Update_Date               DATE,
                           X_Last_Updated_By                NUMBER,
                           X_Last_Update_Login              NUMBER
  ) IS
  BEGIN
    UPDATE so_picking_line_details
    SET
       delivery_id                     =     X_Delivery_Id,
       departure_id                    =     X_Departure_Id,
       load_seq_number                 =     X_Load_Seq_Number,
       master_container_item_id        =     X_Master_Container_Item_Id,
       detail_container_item_id        =     X_Detail_Container_Item_Id,
       dpw_assigned_flag               =     X_DPW_Assigned_Flag,
       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: 209

  END Update_PLD_Row;