APPS.IGI_IGI_ITR_CHARGE_CENTER_PKG SQL Statements

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

Line: 15

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Charge_Center_Id               IN OUT NOCOPY NUMBER,
                       X_Name                           VARCHAR2,
                       X_Set_Of_Books_Id                NUMBER,
                       X_Start_Date_Active              DATE,
                       X_End_Date_Active                DATE,
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER
  ) IS
    CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_CENTER
                 WHERE charge_center_id = X_Charge_Center_Id
                 AND   set_of_books_id = X_Set_Of_Books_Id;

Line: 30

      CURSOR C2 IS SELECT IGI_IGI_itr_charge_center_s.nextval FROM sys.dual;

Line: 38

       INSERT INTO IGI_ITR_CHARGE_CENTER(
              charge_center_id,
              name,
              set_of_books_id,
              start_date_active,
              end_date_active,
              creation_date,
              created_by,
              last_update_login,
              last_update_date,
              last_updated_by
             ) VALUES (
              X_Charge_Center_Id,
              X_Name,
              X_Set_Of_Books_Id,
              X_Start_Date_Active,
              X_End_Date_Active,
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login,
              X_Last_Update_Date,
              X_Last_Updated_By
             );

Line: 69

  END Insert_Row;

Line: 81

        SELECT *
        FROM   IGI_ITR_CHARGE_CENTER
        WHERE  rowid = X_Rowid
        FOR UPDATE of Charge_Center_Id NOWAIT;

Line: 92

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

Line: 125

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Charge_Center_Id               NUMBER,
                       X_Name                           VARCHAR2,
                       X_Set_Of_Books_Id                NUMBER,
                       X_Start_Date_Active              DATE,
                       X_End_Date_Active                DATE,
                       X_Last_Update_Login              NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER
  ) IS
  BEGIN
    UPDATE IGI_ITR_CHARGE_CENTER
    SET
       charge_center_id                =     X_Charge_Center_Id,
       name                            =     X_Name,
       set_of_books_id                 =     X_Set_Of_Books_Id,
       start_date_active               =     X_Start_Date_Active,
       end_date_active                 =     X_End_Date_Active,
       last_update_login               =     X_Last_Update_Login,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By
    WHERE rowid = X_Rowid;

Line: 150

  END Update_Row;

Line: 151

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

Line: 158

  END Delete_Row;