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_MCR dependencies on FA_MASS_CHANGES_ITF

Line 222: -- table, fa_mass_changes_itf.

218: g_asset_count := 0;
219:
220: -- Get concurrent request id for the mass change review request.
221: -- h_request_id is used when request_id is inserted into the interface
222: -- table, fa_mass_changes_itf.
223: -- Need to fetch request id from fnd_global package instead of fa_mass_changes
224: -- table, since fa_mass_changes table stores the latest request id for
225: -- the Preview or Run requests only.
226: h_request_id := fnd_global.conc_request_id;

Line 302: DELETE FROM fa_mass_changes_itf

298: /*===========================================================================
299: Delete rows previously inserted into the interface table with the same
300: request id, if there is any.
301: ===========================================================================*/
302: DELETE FROM fa_mass_changes_itf
303: WHERE request_id = h_request_id;
304: COMMIT;
305:
306: /*===========================================================================

Line 476: /* Insert asset records into the interface table, FA_MASS_CHANGES_ITF,

472: h_last_asset := a_tbl(a_index).asset_id;
473: g_asset_count := g_asset_count + 1;
474: END IF;
475:
476: /* Insert asset records into the interface table, FA_MASS_CHANGES_ITF,
477: at every 200 assets and re-initialize the counter and the asset table. */
478: -- If the 200th asset belongs to more than one book, only the information
479: -- for the first book of this asset will be inserted into the table.
480: -- The rest will be taken care of in the next insertion.

Line 566: DELETE FROM fa_mass_changes_itf

562: g_asset_count := 0;
563: /* A fatal error has occurred. Rollback transaction. */
564: ROLLBACK WORK;
565: /* Delete rows inserted into the interface table. */
566: DELETE FROM fa_mass_changes_itf
567: WHERE request_id = h_request_id;
568: /* Commit changes. */
569: COMMIT WORK;
570: /* Retrieve message log and write result to log and output. */

Line 597: DELETE FROM fa_mass_changes_itf

593: --g_total_assets := 0;
594: /* A fatal error has occurred. Rollback transaction. */
595: ROLLBACK WORK;
596: /* Delete rows inserted into the interface table. */
597: DELETE FROM fa_mass_changes_itf
598: WHERE request_id = h_request_id;
599: /* Commit changes. */
600: COMMIT WORK;
601: /* Retrieve message log and write result to log and output. */