APPS.IGI_MPP_EXPENSE_RULES_PKG SQL Statements

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

Line: 22

          SELECT *
         FROM   igi_mpp_expense_rules
         WHERE  rowid = X_Rowid
         FOR UPDATE of Expense_Ccid NOWAIT;

Line: 34

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

Line: 68

    PROCEDURE Update_Row(X_Rowid               VARCHAR2,
         X_Expense_Ccid                        NUMBER,
         X_Default_Accounting_Rule_Id          NUMBER,
         X_Enabled_Flag                        VARCHAR2,
         X_Last_Updated_By                     NUMBER,
         X_Last_Update_Date                    DATE,
         X_Last_Update_Login                   NUMBER

     ) IS
     BEGIN
       UPDATE igi_mpp_expense_rules
       SET
         expense_ccid                       =  X_Expense_Ccid,
         default_accounting_rule_id         =  X_Default_Accounting_Rule_Id,
         enabled_flag                       =  X_Enabled_Flag,
         last_updated_by                    =  X_Last_Updated_By,
         last_update_date                   =  X_Last_Update_Date,
         last_update_login                  =  X_Last_Update_Login
       WHERE rowid = X_Rowid;

Line: 91

     END Update_Row;

Line: 94

     PROCEDURE Insert_Row(X_Rowid          IN OUT NOCOPY     VARCHAR2,
         X_Expense_Ccid                         NUMBER,
         X_Default_Accounting_Rule_Id           NUMBER,
         X_Enabled_Flag                         VARCHAR2,
         X_Org_Id                               NUMBER,
         X_Set_Of_Books_Id                      NUMBER,
         X_Created_By                           NUMBER,
         X_Creation_Date                        DATE,
         X_Last_Updated_By                      NUMBER,
         X_Last_Update_Date                     DATE,
         X_Last_Update_Login                    NUMBER
      ) IS
        CURSOR C IS SELECT rowid FROM igi_mpp_expense_rules
           WHERE expense_ccid = X_Expense_Ccid;

Line: 111

            INSERT INTO igi_mpp_expense_rules(
                           expense_ccid,
                           default_accounting_rule_id,
                           enabled_flag,
                           org_id,
                           set_of_books_id,
                           created_by,
                           creation_date,
			   last_updated_by,
                           last_update_date,
			   last_update_login
                         )
                  VALUES ( X_Expense_Ccid,
                           X_Default_Accounting_Rule_Id,
                           X_Enabled_Flag,
                           X_Org_Id,
                           X_Set_Of_Books_Id,
                           X_Created_By,
                           X_Creation_Date,
			   X_Last_Updated_By,
			   X_Last_Update_Date,
			   X_Last_Update_Login
                         );

Line: 142

     END Insert_Row;

Line: 145

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

Line: 152

     END Delete_Row;