APPS.RG_DSS_VAR_DIMENSIONS_PKG SQL Statements

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

Line: 13

  SELECT    1
  INTO      dummy
  FROM      rg_dss_var_dimensions
  WHERE     variable_id = X_Variable_Id
  AND       sequence = X_Sequence
  AND       ((X_Rowid IS NULL) OR (rowid <> X_Rowid));

Line: 38

  SELECT    1
  INTO      dummy
  FROM      rg_dss_var_dimensions
  WHERE     variable_id = X_Variable_Id
  AND       dimension_id = X_Dimension_Id
  AND       ((X_Rowid IS NULL) OR (rowid <> X_Rowid));

Line: 58

PROCEDURE insert_row(
            X_Master_Variable_Id            IN OUT NOCOPY NUMBER,
            X_Rowid                         IN OUT NOCOPY VARCHAR2,
            X_Variable_Id                   IN OUT NOCOPY NUMBER,
            X_Sequence                             NUMBER,
            X_Dimension_Id                         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
  NumRecs   NUMBER;

Line: 88

    SELECT    rowid
    FROM      rg_dss_var_dimensions
    WHERE     variable_id = X_Variable_Id
    AND       sequence = X_Sequence;

Line: 106

  SELECT    count(*)
  INTO      NumRecs
  FROM      rg_dss_var_dimensions
  WHERE     variable_id = X_Variable_Id;

Line: 121

  INSERT INTO rg_dss_var_dimensions(
          variable_id,
          sequence,
          dimension_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_Variable_Id,
          X_Sequence,
          X_Dimension_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: 184

END Insert_Row;

Line: 209

      SELECT *
      FROM   rg_dss_var_dimensions
      WHERE  rowid = X_Rowid
      FOR UPDATE of variable_id  NOWAIT;

Line: 219

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

Line: 291

PROCEDURE Update_Row(X_Rowid                                VARCHAR2,
                     X_Variable_Id                          NUMBER,
                     X_Sequence                             NUMBER,
                     X_Dimension_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

  IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
    -- can't modify a variable that is used in a frozen system
    FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');

Line: 323

  UPDATE rg_dss_var_dimensions
  SET
    variable_id                               =    X_Variable_Id,
    sequence                                  =    X_Sequence,
    dimension_id                              =    X_Dimension_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: 353

END Update_Row;

Line: 356

PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Variable_Id NUMBER) IS
BEGIN

  IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
    -- can't modify a variable that is used in a frozen system
    FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');

Line: 366

  DELETE FROM rg_dss_var_dimensions
  WHERE  rowid = X_Rowid;

Line: 374

     Allow summary dimension to be deleted                      */
  RG_DSS_VARIABLES_PKG.check_for_details(X_Variable_Id,'D');

Line: 376

END Delete_Row;