eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FARX_RR dependencies on FA_MASS_RECLASS

Line 5: -- Mass reclass record from fa_mass_reclass table.

1: PACKAGE BODY FARX_RR AS
2: /* $Header: FARXRRB.pls 120.5 2006/03/21 20:26:17 dfred ship $ */
3:
4:
5: -- Mass reclass record from fa_mass_reclass table.
6: mr_rec FA_MASS_REC_UTILS_PKG.mass_reclass_rec;
7:
8: -- Table of asset records.
9: -- (Stores book_type_code as well, and thus one asset will appear multiple

Line 50: -- cursor to fetch mass reclass record from fa_mass_reclass

46: CURSOR get_cat_flex_struct IS
47: SELECT category_flex_structure
48: FROM fa_system_controls;
49:
50: -- cursor to fetch mass reclass record from fa_mass_reclass
51: CURSOR mass_reclass IS
52: SELECT mr.mass_reclass_id,
53: mr.book_type_code,
54: mr.transaction_date_entered,

Line 94: FROM fa_mass_reclass mr

90: mr.creation_date,
91: mr.last_updated_by,
92: mr.last_update_login,
93: mr.last_update_date
94: FROM fa_mass_reclass mr
95: WHERE mass_reclass_id = X_Mass_Reclass_Id;
96:
97: -- asset-book pairs that were reclassified by mass reclass program.
98: -- use cursor 1 if inherit_deprn_rules_flag = 'NO'

Line 374: -- table, fa_mass_reclass_itf.

370: g_asset_count := 0;
371:
372: -- Get concurrent request id for the mass reclass review request.
373: -- h_request_id is used when request_id is inserted into the interface
374: -- table, fa_mass_reclass_itf.
375: -- Need to fetch request id from fnd_global package instead of fa_mass_reclass
376: -- table, since fa_mass_reclass table stores the latest request id for
377: -- the Preview or Run requests only.
378: h_request_id := fnd_global.conc_request_id;

Line 375: -- Need to fetch request id from fnd_global package instead of fa_mass_reclass

371:
372: -- Get concurrent request id for the mass reclass review request.
373: -- h_request_id is used when request_id is inserted into the interface
374: -- table, fa_mass_reclass_itf.
375: -- Need to fetch request id from fnd_global package instead of fa_mass_reclass
376: -- table, since fa_mass_reclass table stores the latest request id for
377: -- the Preview or Run requests only.
378: h_request_id := fnd_global.conc_request_id;
379:

Line 376: -- table, since fa_mass_reclass table stores the latest request id for

372: -- Get concurrent request id for the mass reclass review request.
373: -- h_request_id is used when request_id is inserted into the interface
374: -- table, fa_mass_reclass_itf.
375: -- Need to fetch request id from fnd_global package instead of fa_mass_reclass
376: -- table, since fa_mass_reclass table stores the latest request id for
377: -- the Preview or Run requests only.
378: h_request_id := fnd_global.conc_request_id;
379:
380: -- Fetch mass reclass record information.

Line 389: DELETE FROM fa_mass_reclass_itf

385: /*===========================================================================
386: Delete rows previously inserted into the interface table with the same
387: request id, if there is any.
388: ===========================================================================*/
389: DELETE FROM fa_mass_reclass_itf
390: WHERE request_id = h_request_id;
391: COMMIT;
392:
393: /*===========================================================================

Line 423: into the interface table, fa_mass_reclass_itf. */

419: FETCH get_cat_flex_struct INTO h_cat_flex_struct;
420: CLOSE get_cat_flex_struct;
421:
422: /* Fetch asset-book pairs from mass_reclass_assets cursor and insert them
423: into the interface table, fa_mass_reclass_itf. */
424: IF (mr_rec.redefault_flag = 'NO') THEN
425: OPEN mass_reclass_assets1;
426:
427: LOOP

Line 491: /* Insert asset records into the interface table, FA_MASS_RECLASS_ITF,

487: h_last_asset := a_tbl(a_index).asset_id;
488: g_asset_count := g_asset_count + 1;
489: END IF;
490:
491: /* Insert asset records into the interface table, FA_MASS_RECLASS_ITF,
492: at every 200 assets and re-initialize the counter and the asset table. */
493: -- If the 200th asset belongs to more than one book, only the information
494: -- for the first book of this asset will be inserted into the table.
495: -- The rest will be taken care of in the next insertion.

Line 650: /* Insert asset records into the interface table, FA_MASS_RECLASS_ITF,

646: h_last_asset := a_tbl(a_index).asset_id;
647: g_asset_count := g_asset_count + 1;
648: END IF;
649:
650: /* Insert asset records into the interface table, FA_MASS_RECLASS_ITF,
651: at every 200 assets and re-initialize the counter and the asset table. */
652: -- If the 200th asset belongs to more than one book, only the information
653: -- for the first book of this asset will be inserted into the table.
654: -- The rest will be taken care of in the next insertion.

Line 729: DELETE FROM fa_mass_reclass_itf

725: g_asset_count := 0;
726: /* A fatal error has occurred. Rollback transaction. */
727: ROLLBACK WORK;
728: /* Delete rows inserted into the interface table. */
729: DELETE FROM fa_mass_reclass_itf
730: WHERE request_id = h_request_id;
731: /* Commit changes. */
732: COMMIT WORK;
733: /* Retrieve message log and write result to log and output. */

Line 760: DELETE FROM fa_mass_reclass_itf

756: --g_total_assets := 0;
757: /* A fatal error has occurred. Rollback transaction. */
758: ROLLBACK WORK;
759: /* Delete rows inserted into the interface table. */
760: DELETE FROM fa_mass_reclass_itf
761: WHERE request_id = h_request_id;
762: /* Commit changes. */
763: COMMIT WORK;
764: /* Retrieve message log and write result to log and output. */