APPS.FARX_C_RP SQL Statements

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

Line: 128

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

Line: 159

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

Line: 162

        UPDATE fa_mass_reclass
        SET status = 'FAILED_PRE'
        WHERE mass_reclass_id = to_number(argument1);