APPS.IGI_ITR_CHARGE_SERVICES_SS_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               NUMBER,
                       X_Service_Id                     NUMBER,
                       X_Charge_Service_Id	        NUMBER,
		       X_Creation_Ccid                  NUMBER,
         	       X_Receiving_Ccid                 NUMBER,
		       X_Start_Date                     DATE,
		       X_End_Date                       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_service
                 WHERE charge_service_id = X_Charge_Service_Id;

Line: 33

       INSERT INTO IGI_itr_charge_service(
                       charge_center_Id,
                       charge_service_id,
                       service_id,
	               creation_ccid,
		       receiving_ccid,
		       start_date,
		       end_date,
                       creation_date,
                       created_by,
                       last_update_login,
                       last_update_date,
                       last_updated_by)
		VALUES (
			        X_Charge_Center_Id,
                                X_Charge_Service_Id,
			        X_Service_Id,
			        X_Creation_Ccid,
			        X_Receiving_Ccid,
			        X_Start_Date,
			        X_End_Date,
			        X_Creation_Date,
			        X_Created_By,
			        X_Last_Update_Login,
			        X_Last_Update_Date,
                                X_Last_Updated_By
             );

Line: 68

  END Insert_Row;

Line: 82

        SELECT *
        FROM   IGI_itr_charge_service
        WHERE  rowid = X_Rowid
        FOR UPDATE of Charge_Service_Id NOWAIT;

Line: 97

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

Line: 136

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Charge_Center_Id               NUMBER,
                       X_Charge_Service_Id              NUMBER,
                       X_Service_Id                     NUMBER,
               	       X_Creation_Ccid                  NUMBER,
		       X_Receiving_Ccid                 NUMBER,
		       X_Start_Date                     DATE,
		       X_End_Date                       DATE,
                       X_Last_Update_Login              NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER
  ) IS

  BEGIN
    UPDATE IGI_itr_charge_service
    SET
       charge_center_id                =     X_Charge_Center_Id,
       service_id                      =     X_Service_Id,
       creation_ccid                   =     X_Creation_Ccid,
       receiving_ccid                  =     X_Receiving_Ccid,
       start_date                      =     X_Start_Date,
       end_date                        =     X_End_Date,
       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: 167

  END Update_Row;

Line: 170

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

Line: 177

  END Delete_Row;