DBA Data[Home] [Help]

APPS.IGI_BUD_CODE_COMBINATIONS_PKG SQL Statements

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

Line: 23

        SELECT *
        FROM   GL_CODE_COMBINATIONS
        WHERE  rowid = X_Rowid
        FOR UPDATE of igi_balanced_budget_flag NOWAIT;
Line: 34

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
Line: 61

  PROCEDURE Update_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Code_Combination_Id             NUMBER,
                       X_Igi_Balanced_Budget_Flag       VARCHAR2,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER
  ) IS
  BEGIN
    UPDATE GL_CODE_COMBINATIONS
    SET
       igi_balanced_budget_flag        =     X_igi_balanced_budget_flag,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By
    WHERE rowid = X_Rowid;
Line: 78

  END Update_Row;