APPS.FARX_RR dependencies on FA_MASS_RECLASS_ITF

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