APPS.FA_MASS_REC_UTILS_PKG dependencies on FA_MASS_RECLASS

Line 153: INSERT INTO fa_mass_reclass_itf (

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

Line 183: INSERT INTO fa_mass_reclass_itf (

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

Line 219: VALUE1 => 'FA_MASS_RECLASS_ITF'

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

Line 285: FROM fa_mass_reclass mr

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