APPS.FARX_C_MCP dependencies on FA_MASS_CHANGES

Line 131: FROM fa_mass_changes

127: END IF;
128:
129: -- This argument must exist in the table.
130: SELECT count(1) INTO h_count
131: FROM fa_mass_changes
132: WHERE mass_change_id = to_number(argument1)
133: AND rownum < 2;
134:
135: IF (h_count = 0) THEN

Line 165: UPDATE fa_mass_changes

161: retcode := 2; -- Completed with error.
162: /* A fatal error has occurred, rollback transaction and update status
163: to 'FAILED_PRE' and commit the change. */
164: ROLLBACK WORK;
165: UPDATE fa_mass_changes
166: SET status = 'FAILED_PRE'
167: WHERE mass_change_id = to_number(argument1);
168: COMMIT WORK;
169: IF SQLCODE <> 0 THEN