APPS.IGI_ITR_CHARGE_CENTER_SS_PKG SQL Statements

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

Line: 14

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY 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_Description                     VARCHAR2,
                       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;

Line: 31

       INSERT INTO IGI_itr_charge_center(
                       Charge_Center_Id,
                       Name,
                       Set_Of_Books_Id,
		       Start_Date_Active,
		       End_Date_Active,
                       Description,
                       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_Description,
                       X_Creation_Date,
                       X_Created_By,
                       X_Last_Update_Login,
                       X_Last_Update_Date,
                       X_Last_Updated_By             );

Line: 64

  END Insert_Row;

Line: 76

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

Line: 87

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

Line: 122

  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_Description                    VARCHAR2,
                       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,
	          description        =          X_Description ,
	          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: 153

  END Update_Row;

Line: 156

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

Line: 163

  END Delete_Row;

Line: 172

      SELECT 'Duplicate'
      FROM   igi_itr_charge_center cc
      WHERE  cc.name = x_name
      AND    cc.set_of_books_id = x_set_of_books_id
      AND    (x_rowid IS NULL
              OR
              cc.rowid <> x_rowid);