APPS.IGI_DUN_CUST_LET_SET_CUR_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_Customer_Profile_Id                NUMBER,
        X_Currency_Code                      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_cust_letter_set_cur
              WHERE customer_profile_id = X_Customer_Profile_Id
         	AND   currency_code = X_Currency_Code;

Line: 29

       INSERT INTO igi_dun_cust_letter_set_cur(
        customer_profile_id,
        currency_code,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
              ) VALUES (
        X_Customer_Profile_Id,
        X_Currency_Code,
        X_Created_By,
        X_Creation_Date,
        X_Last_Updated_By,
        X_Last_Update_Date,
        X_Last_Update_Login
             );

Line: 53

   END Insert_Row;

Line: 61

          SELECT *
         FROM   igi_dun_cust_letter_set_cur
         WHERE  rowid = X_Rowid
         FOR UPDATE of Customer_Profile_Id NOWAIT;

Line: 72

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

Line: 98

      PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
         X_Customer_Profile_Id                 NUMBER,
         X_Currency_Code                       VARCHAR2,
         X_Last_Updated_By                     NUMBER,
         X_Last_Update_Date                    DATE,
         X_Last_Update_Login                   NUMBER

     ) IS
     BEGIN
       UPDATE igi_dun_cust_letter_set_cur
       SET
         customer_profile_id                =  X_Customer_Profile_Id,
         currency_code                      =  X_Currency_Code,
         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: 119

     END Update_Row;

Line: 121

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

Line: 129

     END Delete_Row;