APPS.FARX_RR dependencies on FA_MASS_RECLASS_ITF

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 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. */