APPS.IGI_BUD_PROFILE_PERIODS_PKG SQL Statements

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

Line: 17

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Profile_Code                   VARCHAR2,
                       X_Set_Of_Books_Id                NUMBER,
                       X_Period_Number                  NUMBER,
                       X_Period_Ratio                   NUMBER,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER
  ) IS
    CURSOR C IS SELECT rowid FROM igi_bud_profile_periods
                 WHERE period_number = X_Period_Number;

Line: 33

       INSERT INTO igi_bud_profile_periods(
              profile_code,
              set_of_books_id,
              period_number,
              period_ratio,
              creation_date,
              created_by,
              last_update_date,
              last_updated_by,
              last_update_login
             ) VALUES (
              X_Profile_Code,
              X_Set_Of_Books_Id,
              X_Period_Number,
              X_Period_Ratio,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Last_Update_Login
             );

Line: 62

  END Insert_Row;

Line: 72

        SELECT *
        FROM   igi_bud_profile_periods
        WHERE  rowid = X_Rowid
        FOR UPDATE of Period_Number NOWAIT;

Line: 84

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

Line: 114

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Profile_Code                   VARCHAR2,
                       X_Set_Of_Books_Id                NUMBER,
                       X_Period_Number                  NUMBER,
                       X_Period_Ratio                   NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER

  ) IS
  BEGIN
    UPDATE igi_bud_profile_periods
    SET
       profile_code                    =     X_Profile_Code,
       set_of_books_id                 =     X_Set_Of_Books_Id,
       period_number                   =     X_Period_Number,
       period_ratio                    =     X_Period_Ratio,
       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: 139

  END Update_Row;

Line: 140

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

Line: 148

  END Delete_Row;