APPS.FA_LEASES_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Lease_Id                       NUMBER,
                       X_Lease_Number                   VARCHAR2,
                       X_Lessor_Id                      NUMBER,
                       X_Description                    VARCHAR2,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Created_By                     NUMBER DEFAULT NULL,
                       X_Creation_Date                  DATE DEFAULT NULL,
                       X_Last_Update_Login              NUMBER DEFAULT NULL,
                       X_Attribute1                     VARCHAR2 DEFAULT NULL,
                       X_Attribute2                     VARCHAR2 DEFAULT NULL,
                       X_Attribute3                     VARCHAR2 DEFAULT NULL,
                       X_Attribute4                     VARCHAR2 DEFAULT NULL,
                       X_Attribute5                     VARCHAR2 DEFAULT NULL,
                       X_Attribute6                     VARCHAR2 DEFAULT NULL,
                       X_Attribute7                     VARCHAR2 DEFAULT NULL,
                       X_Attribute8                     VARCHAR2 DEFAULT NULL,
                       X_Attribute9                     VARCHAR2 DEFAULT NULL,
                       X_Attribute10                    VARCHAR2 DEFAULT NULL,
                       X_Attribute11                    VARCHAR2 DEFAULT NULL,
                       X_Attribute12                    VARCHAR2 DEFAULT NULL,
                       X_Attribute13                    VARCHAR2 DEFAULT NULL,
                       X_Attribute14                    VARCHAR2 DEFAULT NULL,
                       X_Attribute15                    VARCHAR2 DEFAULT NULL,
                       X_Attribute_Category_Code        VARCHAR2 DEFAULT NULL,
			X_Calling_Fn			VARCHAR2,
			p_log_level_rec    in      fa_api_types.log_level_rec_type default null) IS
    CURSOR C IS SELECT rowid FROM fa_leases
                 WHERE lease_id = X_Lease_Id;

Line: 38

       INSERT INTO fa_leases(

              lease_id,
              lease_number,
              lessor_id,
              description,
              last_update_date,
              last_updated_by,
              created_by,
              creation_date,
              last_update_login,
              attribute1,
              attribute2,
              attribute3,
              attribute4,
              attribute5,
              attribute6,
              attribute7,
              attribute8,
              attribute9,
              attribute10,
              attribute11,
              attribute12,
              attribute13,
              attribute14,
              attribute15,
              attribute_category_code
             ) VALUES (

              X_Lease_Id,
              X_Lease_Number,
              X_Lessor_Id,
              X_Description,
              X_Last_Update_Date,
              X_Last_Updated_By,
              X_Created_By,
              X_Creation_Date,
              X_Last_Update_Login,
              X_Attribute1,
              X_Attribute2,
              X_Attribute3,
              X_Attribute4,
              X_Attribute5,
              X_Attribute6,
              X_Attribute7,
              X_Attribute8,
              X_Attribute9,
              X_Attribute10,
              X_Attribute11,
              X_Attribute12,
              X_Attribute13,
              X_Attribute14,
              X_Attribute15,
              X_Attribute_Category_Code
             );

Line: 104

			(Called_Fn	=> 'FA_LEASES_PKG.Insert_Row',
			Calling_Fn	=> X_Calling_Fn
			,p_log_level_rec => p_log_level_rec);

Line: 107

  END Insert_Row;

Line: 134

        SELECT *
        FROM   fa_leases
        WHERE  rowid = X_Rowid
        FOR UPDATE of Lease_Id NOWAIT;

Line: 146

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

Line: 213

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Lease_Id                       NUMBER,
                       X_Lease_Number                   VARCHAR2,
                       X_Lessor_Id                      NUMBER,
                       X_Description                    VARCHAR2,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Attribute1                     VARCHAR2,
                       X_Attribute2                     VARCHAR2,
                       X_Attribute3                     VARCHAR2,
                       X_Attribute4                     VARCHAR2,
                       X_Attribute5                     VARCHAR2,
                       X_Attribute6                     VARCHAR2,
                       X_Attribute7                     VARCHAR2,
                       X_Attribute8                     VARCHAR2,
                       X_Attribute9                     VARCHAR2,
                       X_Attribute10                    VARCHAR2,
                       X_Attribute11                    VARCHAR2,
                       X_Attribute12                    VARCHAR2,
                       X_Attribute13                    VARCHAR2,
                       X_Attribute14                    VARCHAR2,
                       X_Attribute15                    VARCHAR2,
                       X_Attribute_Category_Code        VARCHAR2,
		       X_Return_Status		 OUT NOCOPY BOOLEAN,
		       X_Calling_Fn			VARCHAR2,
		       p_log_level_rec    in      fa_api_types.log_level_rec_type default null) IS
  BEGIN
    UPDATE fa_leases
    SET
       lease_id                        =     X_Lease_Id,
       lease_number                    =     X_Lease_Number,
       lessor_id                       =     X_Lessor_Id,
       description                     =     X_Description,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login,
       attribute1                      =     X_Attribute1,
       attribute2                      =     X_Attribute2,
       attribute3                      =     X_Attribute3,
       attribute4                      =     X_Attribute4,
       attribute5                      =     X_Attribute5,
       attribute6                      =     X_Attribute6,
       attribute7                      =     X_Attribute7,
       attribute8                      =     X_Attribute8,
       attribute9                      =     X_Attribute9,
       attribute10                     =     X_Attribute10,
       attribute11                     =     X_Attribute11,
       attribute12                     =     X_Attribute12,
       attribute13                     =     X_Attribute13,
       attribute14                     =     X_Attribute14,
       attribute15                     =     X_Attribute15,
       attribute_category_code         =     X_Attribute_Category_Code
    WHERE rowid = X_Rowid;

Line: 276

			CALLING_FN => 'FA_LEASES_PKG.Update_Row'
			,p_log_level_rec => p_log_level_rec);

Line: 282

  END Update_Row;

Line: 284

  PROCEDURE Delete_Row(X_Rowid 		VARCHAR2 DEFAULT NULL,
			X_Lease_Id	NUMBER DEFAULT NULL,
			X_Calling_Fn			VARCHAR2,
			p_log_level_rec    in      fa_api_types.log_level_rec_type default null) IS
  BEGIN
    if X_Rowid is not null then
    	DELETE FROM fa_leases
    	WHERE rowid = X_Rowid;

Line: 293

	DELETE FROM fa_leases
	WHERE lease_id = X_Lease_Id;

Line: 305

			(Called_Fn	=> 'FA_LEASES_PKG.Delete_Row',
			Calling_Fn	=> X_Calling_Fn
			,p_log_level_rec => p_log_level_rec);

Line: 308

  END Delete_Row;