APPS.IGI_DUN_LETTER_SETS_PKG SQL Statements

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

Line: 13

    PROCEDURE Insert_Row(X_Rowid                IN OUT NOCOPY VARCHAR2,
        X_Dunning_Letter_Set_Id              NUMBER,
        X_Use_Dunning_Flag                   VARCHAR2,
        X_Charge_Per_Invoice_Flag            VARCHAR2,
        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_dun_letter_sets
              WHERE dunning_letter_set_id = X_Dunning_Letter_Set_Id;

Line: 32

       INSERT INTO igi_dun_letter_sets(
        dunning_letter_set_id,
        use_dunning_flag,
        charge_per_invoice_flag,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
              ) VALUES (
        X_Dunning_Letter_Set_Id,
        X_Use_Dunning_Flag,
        X_Charge_Per_Invoice_Flag,
        X_Created_By,
        X_Creation_Date,
        X_Last_Updated_By,
        X_Last_Update_Date,
        X_Last_Update_Login

             );

Line: 59

   END Insert_Row;

Line: 70

          SELECT *
         FROM   igi_dun_letter_sets
         WHERE  rowid = X_Rowid
         FOR UPDATE of Dunning_Letter_Set_Id NOWAIT;

Line: 82

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

Line: 110

      PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
         X_Dunning_Letter_Set_Id               NUMBER,
         X_Use_Dunning_Flag                    VARCHAR2,
         X_Charge_Per_Invoice_Flag             VARCHAR2,
         X_Last_Updated_By                     NUMBER,
         X_Last_Update_Date                    DATE,
         X_Last_Update_Login                   NUMBER

     ) IS
     BEGIN
       UPDATE igi_dun_letter_sets
       SET
         dunning_letter_set_id              =  X_Dunning_Letter_Set_Id,
         use_dunning_flag                   =  X_Use_Dunning_Flag,
         charge_per_invoice_flag            =  X_Charge_Per_Invoice_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: 133

     END Update_Row;

Line: 135

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

Line: 143

     END Delete_Row;