DBA Data[Home] [Help]

APPS.FARX_C_RP dependencies on FA_MASS_RECLASS

Line 129: FROM fa_mass_reclass

125: END IF;
126:
127: -- This argument must exist in the table.
128: SELECT count(1) INTO h_count
129: FROM fa_mass_reclass
130: WHERE mass_reclass_id = to_number(argument1) AND rownum < 2;
131:
132: IF (h_count = 0) THEN
133: fnd_message.set_name('OFA','FA_MRCL_PARAM_REQUIRED');

Line 162: UPDATE fa_mass_reclass

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