APPS.FA_INVENTORY_PKG SQL Statements

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

Line: 9

 SELECT *
 FROM FA_INV_INTERFACE
 WHERE ROWID = X_ROWID
 FOR UPDATE OF STATUS NOWAIT;

Line: 20

   fnd_message.set_name('FND','FORM_RECORD_DELETED');

Line: 36

  PROCEDURE Update_Row(X_Rowid           VARCHAR2,
		       X_inventory_id			     number,
		       X_unit_rec_mth_lookup_code  VARCHAR2,
		       X_loc_rec_mth_lookup_code	  VARCHAR2,
		       X_status_lookup_code		  VARCHAR2,
             X_Last_Update_Date          DATE,
             X_Last_Updated_By           NUMBER,
             X_Last_Update_Login         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
     UPDATE fa_inv_interface
     SET
	unit_reconcile_mth    = X_unit_rec_mth_lookup_code,
	loc_reconcile_mth     = X_loc_rec_mth_lookup_code,
	status		      = X_status_lookup_code,
	Last_Update_Date      = X_Last_Update_Date ,
        Last_Updated_By	      = X_Last_Updated_By,
	Last_Update_Login     = X_Last_Update_Login
     WHERE rowid = X_Rowid;

Line: 58

     UPDATE fa_inv_interface
     SET
	unit_reconcile_mth    = X_unit_rec_mth_lookup_code,
	loc_reconcile_mth     = X_loc_rec_mth_lookup_code,
	status		      = X_status_lookup_code,
	Last_Update_Date      = X_Last_Update_Date ,
        Last_Updated_By	      = X_Last_Updated_By,
	Last_Update_Login     = X_Last_Update_Login
       where inventory_id = x_inventory_id;

Line: 74

			(Called_Fn	=> 'FA_INVENTORY_PKG.Update_Row',
			Calling_Fn	=> X_Calling_Fn
			,p_log_level_rec => p_log_level_rec);

Line: 77

  END Update_Row;