APPS.FA_MASS_REC_UTILS_PKG dependencies on FA_MASS_RECLASS

Line 152: INSERT INTO fa_mass_reclass_itf (

148: FETCH get_deprn_flag INTO h_deprn_flag_mean;
149: CLOSE get_deprn_flag;
150:
151: IF (X_Report_Type = 'PREVIEW') THEN
152: INSERT INTO fa_mass_reclass_itf (
153: request_id, mass_reclass_id,
154: asset_id, asset_number,
155: description, book,
156: old_category, new_category,

Line 182: INSERT INTO fa_mass_reclass_itf (

178: X_Last_Update_Date, X_Last_Updated_By, X_Created_By,
179: X_Creation_Date, X_Last_Update_Login
180: );
181: ELSIF (X_Report_Type = 'REVIEW') THEN
182: INSERT INTO fa_mass_reclass_itf (
183: request_id, mass_reclass_id,
184: asset_id, asset_number,
185: description, book,
186: old_category, new_category,

Line 218: VALUE1 => 'FA_MASS_RECLASS_ITF', p_log_level_rec => p_log_level_rec);

214: FA_SRVR_MSG.Add_Message(
215: CALLING_FN => 'FA_MASS_REC_UTILS_PKG.Insert_Itf',
216: NAME => 'FA_SHARED_INSERT_FAILED',
217: TOKEN1 => 'FAILED',
218: VALUE1 => 'FA_MASS_RECLASS_ITF', p_log_level_rec => p_log_level_rec);
219: FA_SRVR_MSG.Add_SQL_Error(
220: CALLING_FN => 'FA_MASS_REC_UTILS_PKG.Insert_Itf', p_log_level_rec => p_log_level_rec);
221: raise;
222: END Insert_Itf;

Line 282: FROM fa_mass_reclass mr

278: mr.segment19_high, mr.segment20_high, mr.segment21_high,
279: mr.segment22_high, mr.segment23_high, mr.segment24_high,
280: mr.segment25_high, mr.segment26_high, mr.segment27_high,
281: mr.segment28_high, mr.segment29_high, mr.segment30_high
282: FROM fa_mass_reclass mr
283: WHERE mr.mass_reclass_id = X_Mass_Reclass_Id;
284:
285: -- cursor to get precision.
286: CURSOR get_precision IS