APPS.FA_CUA_EXT_TRANSFERS_PKG SQL Statements

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

Line: 27

  SELECT BATCH_NAME,
         MASS_EXTERNAL_TRANSFER_ID,
         EXTERNAL_REFERENCE_NUM,
         TRANSACTION_TYPE,
         FROM_ASSET_ID,
         TO_ASSET_ID,
         BOOK_TYPE_CODE,
         TRANSACTION_STATUS,
         TRANSACTION_DATE_ENTERED,
         FROM_DISTRIBUTION_ID,
         TO_LOCATION_ID,
         TO_GL_CCID,
         TO_EMPLOYEE_ID,
         DESCRIPTION,
         TRANSFER_UNITS,
         TRANSFER_AMOUNT,
         SOURCE_LINE_ID,
         CREATED_BY,
         CREATION_DATE,
         LAST_UPDATED_BY,
         LAST_UPDATE_DATE,
         LAST_UPDATE_LOGIN
  FROM fa_mass_external_transfers
  WHERE rowid = X_Rowid
  FOR UPDATE OF mass_external_transfer_id NOWAIT;

Line: 61

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

Line: 135

PROCEDURE Update_Row(
        X_Rowid                         VARCHAR2,
        X_Mass_External_Transfer_Id     NUMBER   DEFAULT NULL,
        X_From_Asset_Id                 NUMBER   DEFAULT NULL,
        X_Transaction_Status            VARCHAR2 DEFAULT NULL,
        X_Book_Type_Code                VARCHAR2 DEFAULT NULL,
        X_Transaction_Type              VARCHAR2 DEFAULT NULL,
        X_Batch_Name                    VARCHAR2 DEFAULT NULL,
        X_Description                   VARCHAR2 DEFAULT NULL,
        X_Transaction_Date_Entered      DATE     DEFAULT NULL,
        X_External_Reference_Num        VARCHAR2 DEFAULT NULL,
        X_To_Asset_Id                   NUMBER   DEFAULT NULL,
        X_To_Location_Id                NUMBER   DEFAULT NULL,
        X_To_GL_CCID                    NUMBER   DEFAULT NULL,
        X_To_Employee_Id                NUMBER   DEFAULT NULL,
        X_Transfer_Units                NUMBER   DEFAULT NULL,
        X_Source_Line_Id                NUMBER   DEFAULT NULL,
        X_Transfer_Amount               NUMBER   DEFAULT NULL,
        X_From_Distribution_Id          NUMBER   DEFAULT NULL
) IS

BEGIN
    UPDATE fa_mass_external_transfers
    SET
        mass_external_transfer_id =     X_Mass_External_Transfer_Id,
        from_asset_id =                 X_From_Asset_Id,
        transaction_status =            X_Transaction_Status,
        book_type_code  =               X_Book_Type_Code,
        transaction_type =              X_Transaction_Type,
        batch_name =                    X_Batch_Name,
        description =                   X_Description,
        transaction_date_entered =      X_Transaction_Date_Entered,
        external_reference_num =        X_External_Reference_Num,
        to_asset_id =                   X_To_Asset_Id,
        to_location_id =                X_To_Location_Id,
        to_gl_ccid =                    X_To_GL_CCID,
        to_employee_id =                X_To_Employee_Id,
        transfer_units =                X_Transfer_Units,
        source_line_id =                X_Source_Line_Id,
        transfer_amount =               X_Transfer_Amount,
        from_distribution_id =          X_From_Distribution_Id
    WHERE rowid = X_Rowid;

Line: 181

END Update_Row;