APPS.FARX_C_MCP SQL Statements

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

Line: 130

    SELECT count(1) INTO h_count
      FROM fa_mass_changes
     WHERE mass_change_id = to_number(argument1)
       AND rownum < 2;

Line: 162

       /* A fatal error has occurred, rollback transaction and update status
          to 'FAILED_PRE' and commit the change. */
       ROLLBACK WORK;

Line: 165

       UPDATE fa_mass_changes
          SET status = 'FAILED_PRE'
        WHERE mass_change_id = to_number(argument1);