APPS.RG_DSS_SYSTEM_VARIABLES_PKG SQL Statements

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

Line: 13

  SELECT    1
  INTO      dummy
  FROM      rg_dss_system_variables
  WHERE     system_id = X_System_Id
  AND       variable_id = X_Variable_Id
  AND       ((X_Rowid IS NULL) OR (rowid <> X_Rowid));

Line: 33

PROCEDURE insert_row(X_Rowid                         IN OUT NOCOPY VARCHAR2,
                     X_System_Id                            NUMBER,
                     X_Variable_Id                          NUMBER,
                     X_System_Variable_Id            IN OUT NOCOPY NUMBER,
                     X_Last_Update_Date                     DATE,
                     X_Last_Updated_By                      NUMBER,
                     X_Last_Update_Login                    NUMBER,
                     X_Creation_Date                        DATE,
                     X_Created_By                           NUMBER,
                     X_Context                              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) IS
  CURSOR C IS
    SELECT    rowid
    FROM      rg_dss_system_variables
    WHERE     system_variable_id = X_System_Variable_Id;

Line: 64

    SELECT    rg_dss_system_variables_s.nextval
    FROM      dual;

Line: 77

  INSERT INTO rg_dss_system_variables(
          system_id,
          variable_id,
          system_variable_id,
          last_update_date,
          last_updated_by,
          last_update_login,
          creation_date,
          created_by,
          context,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15
         ) VALUES (
          X_System_Id,
          X_Variable_Id,
          X_System_Variable_Id,
          X_Last_Update_Date,
          X_Last_Updated_By,
          X_Last_Update_Login,
          X_Creation_Date,
          X_Created_By,
          X_Context,
          X_Attribute1,
          X_Attribute2,
          X_Attribute3,
          X_Attribute4,
          X_Attribute5,
          X_Attribute6,
          X_Attribute7,
          X_Attribute8,
          X_Attribute9,
          X_Attribute10,
          X_Attribute11,
          X_Attribute12,
          X_Attribute13,
          X_Attribute14,
          X_Attribute15
  );

Line: 140

END insert_row;

Line: 165

      SELECT *
      FROM   rg_dss_system_variables
      WHERE  rowid = X_Rowid
      FOR UPDATE of system_variable_id  NOWAIT;

Line: 175

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

Line: 247

PROCEDURE update_row(X_Rowid                                VARCHAR2,
                     X_System_Id                            NUMBER,
                     X_Variable_Id                          NUMBER,
                     X_System_Variable_Id                   NUMBER,
                     X_Last_Update_Date                     DATE,
                     X_Last_Updated_By                      NUMBER,
                     X_Last_Update_Login                    NUMBER,
                     X_Context                              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) IS
BEGIN

  UPDATE rg_dss_system_variables
  SET
    system_id                                 =    X_System_Id,
    variable_id                               =    X_Variable_Id,
    system_variable_id                        =    X_System_Variable_Id,
    last_update_date                          =    X_Last_Update_Date,
    last_updated_by                           =    X_Last_Updated_By,
    last_update_login                         =    X_Last_Update_Login,
    context                                   =    X_Context,
    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
    WHERE rowid = X_rowid;

Line: 302

END update_row;

Line: 304

PROCEDURE delete_row(X_Rowid VARCHAR2) IS
BEGIN

  DELETE FROM rg_dss_system_variables
  WHERE  rowid = X_Rowid;

Line: 314

END delete_row;