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.8 2011/04/13 10:20:19 rmandali 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 389: -- table, fa_mass_reclass_itf.

385: g_asset_count := 0;
386:
387: -- Get concurrent request id for the mass reclass review request.
388: -- h_request_id is used when request_id is inserted into the interface
389: -- table, fa_mass_reclass_itf.
390: -- Need to fetch request id from fnd_global package instead of fa_mass_reclass
391: -- table, since fa_mass_reclass table stores the latest request id for
392: -- the Preview or Run requests only.
393: h_request_id := fnd_global.conc_request_id;

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

386:
387: -- Get concurrent request id for the mass reclass review request.
388: -- h_request_id is used when request_id is inserted into the interface
389: -- table, fa_mass_reclass_itf.
390: -- Need to fetch request id from fnd_global package instead of fa_mass_reclass
391: -- table, since fa_mass_reclass table stores the latest request id for
392: -- the Preview or Run requests only.
393: h_request_id := fnd_global.conc_request_id;
394:

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

387: -- Get concurrent request id for the mass reclass review request.
388: -- h_request_id is used when request_id is inserted into the interface
389: -- table, fa_mass_reclass_itf.
390: -- Need to fetch request id from fnd_global package instead of fa_mass_reclass
391: -- table, since fa_mass_reclass table stores the latest request id for
392: -- the Preview or Run requests only.
393: h_request_id := fnd_global.conc_request_id;
394:
395: -- Fetch mass reclass record information.

Line 404: DELETE FROM fa_mass_reclass_itf

400: /*===========================================================================
401: Delete rows previously inserted into the interface table with the same
402: request id, if there is any.
403: ===========================================================================*/
404: DELETE FROM fa_mass_reclass_itf
405: WHERE request_id = h_request_id;
406: COMMIT;
407:
408: /*===========================================================================

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

434: FETCH get_cat_flex_struct INTO h_cat_flex_struct;
435: CLOSE get_cat_flex_struct;
436:
437: /* Fetch asset-book pairs from mass_reclass_assets cursor and insert them
438: into the interface table, fa_mass_reclass_itf. */
439: IF (mr_rec.redefault_flag = 'NO') THEN
440: OPEN mass_reclass_assets1;
441:
442: LOOP

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

503: h_last_asset := a_tbl(a_index).asset_id;
504: g_asset_count := g_asset_count + 1;
505: END IF;
506:
507: /* Insert asset records into the interface table, FA_MASS_RECLASS_ITF,
508: at every 200 assets and re-initialize the counter and the asset table. */
509: -- If the 200th asset belongs to more than one book, only the information
510: -- for the first book of this asset will be inserted into the table.
511: -- The rest will be taken care of in the next insertion.

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

664: h_last_asset := a_tbl(a_index).asset_id;
665: g_asset_count := g_asset_count + 1;
666: END IF;
667:
668: /* Insert asset records into the interface table, FA_MASS_RECLASS_ITF,
669: at every 200 assets and re-initialize the counter and the asset table. */
670: -- If the 200th asset belongs to more than one book, only the information
671: -- for the first book of this asset will be inserted into the table.
672: -- The rest will be taken care of in the next insertion.

Line 749: DELETE FROM fa_mass_reclass_itf

745: g_asset_count := 0;
746: /* A fatal error has occurred. Rollback transaction. */
747: ROLLBACK WORK;
748: /* Delete rows inserted into the interface table. */
749: DELETE FROM fa_mass_reclass_itf
750: WHERE request_id = h_request_id;
751: /* Commit changes. */
752: COMMIT WORK;
753: /* Retrieve message log and write result to log and output. */

Line 780: DELETE FROM fa_mass_reclass_itf

776: --g_total_assets := 0;
777: /* A fatal error has occurred. Rollback transaction. */
778: ROLLBACK WORK;
779: /* Delete rows inserted into the interface table. */
780: DELETE FROM fa_mass_reclass_itf
781: WHERE request_id = h_request_id;
782: /* Commit changes. */
783: COMMIT WORK;
784: /* Retrieve message log and write result to log and output. */