APPS.AS_INTEREST_CATEGORY_SETS_PKG SQL Statements

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

Line: 11

PROCEDURE Insert_Row(X_Rowid                        IN OUT VARCHAR2,
                     X_Category_Set_Id                     NUMBER,
                     X_Interest_Type_Id                    NUMBER,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER,
                     X_Creation_Date                       DATE,
                     X_Created_By                          NUMBER,
                     X_Last_Update_Login                   NUMBER,
                     X_Enabled_Flag                        VARCHAR2 DEFAULT NULL
 ) IS
   CURSOR C IS SELECT rowid FROM as_interest_category_sets
             WHERE category_set_id = X_Category_Set_Id
             AND   interest_type_id = X_Interest_Type_Id;

Line: 25

  INSERT INTO as_interest_category_sets(
          category_set_id,
          interest_type_id,
          last_update_date,
          last_updated_by,
          creation_date,
          created_by,
          last_update_login,
          enabled_flag
         ) VALUES (
          X_Category_Set_Id,
          X_Interest_Type_Id,
          X_Last_Update_Date,
          X_Last_Updated_By,
          X_Creation_Date,
          X_Created_By,
          X_Last_Update_Login,
          X_Enabled_Flag
  );

Line: 51

END Insert_Row;

Line: 60

      SELECT *
      FROM   as_interest_category_sets
      WHERE  rowid = X_Rowid
      FOR UPDATE of Category_Set_Id NOWAIT;

Line: 70

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

Line: 93

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Category_Set_Id                     NUMBER,
                     X_Interest_Type_Id                    NUMBER,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER,
                     X_Last_Update_Login                   NUMBER,
                     X_Enabled_Flag                        VARCHAR2 DEFAULT NULL
) IS
BEGIN
  UPDATE as_interest_category_sets
  SET
    category_set_id                           =    X_Category_Set_Id,
    interest_type_id                          =    X_Interest_Type_Id,
    last_update_date                          =    X_Last_Update_Date,
    last_updated_by                           =    X_Last_Updated_By,
    last_update_login                         =    X_Last_Update_Login,
    enabled_flag                              =    X_Enabled_Flag
  WHERE rowid = X_rowid;

Line: 116

END Update_Row;

Line: 119

PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
  DELETE FROM as_interest_category_sets
  WHERE  rowid = X_Rowid;

Line: 127

END Delete_Row;