APPS.FARX_RP dependencies on FA_MASS_RECLASS_ITF

Line 310: -- table, fa_mass_reclass_itf.

306: --g_total_assets := 0;
307:
308: -- Get concurrent request id for the mass reclass preview request.
309: -- h_request_id is used when request_id is inserted into the interface
310: -- table, fa_mass_reclass_itf.
311: -- Need to fetch request id from fnd_global package instead of fa_mass_reclass
312: -- table, since fa_mass_reclass table stores the latest request id for
313: -- the SRS Preview report requests(run after this module) or
314: -- Run requests only.

Line 332: DELETE FROM fa_mass_reclass_itf

328: /*=========================================================================
329: Delete rows previously inserted into the interface table with the same
330: request id, if there is any.
331: =========================================================================*/
332: DELETE FROM fa_mass_reclass_itf
333: WHERE request_id = h_request_id;
334: COMMIT;
335:
336: /*=========================================================================

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

400: concat_string => h_new_concat_cat,
401: segarray => h_cat_segs);
402:
403: /* Loop all the qualified assets, and insert all the validated assets
404: into the interface table, fa_mass_reclass_itf. */
405: OPEN mass_reclass_assets;
406:
407: LOOP
408: a_index := a_index + 1;

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

479: -- to avoid records with duplicate asset id's in a_tbl.
480: a_index := a_index - 1;
481: END IF; /* IF (a_tbl(a_index).asset_id <> */
482:
483: /* Insert asset records into the interface table, FA_MASS_RECLASS_ITF,
484: at every 200 assets. */
485: -- If g_asset_count(number of valid assets) = 200, insert all the 200
486: -- asset records in a_tbl(1..a_index) into the interface table,
487: -- re-initialize the pl/sql table, a_tbl, and reset g_asset_count

Line 592: DELETE FROM fa_mass_reclass_itf

588: UPDATE fa_mass_reclass
589: SET status = 'FAILED_PRE'
590: WHERE mass_reclass_id = X_Mass_Reclass_Id;
591: /* Delete rows inserted into the interface table. */
592: DELETE FROM fa_mass_reclass_itf
593: WHERE request_id = h_request_id;
594: /* Commit changes. */
595: COMMIT WORK;
596: /* Retrieve message log and write result to log and output. */

Line 627: DELETE FROM fa_mass_reclass_itf

623: UPDATE fa_mass_reclass
624: SET status = 'FAILED_PRE'
625: WHERE mass_reclass_id = X_Mass_Reclass_Id;
626: /* Delete rows inserted into the interface table. */
627: DELETE FROM fa_mass_reclass_itf
628: WHERE request_id = h_request_id;
629: /* Commit changes. */
630: COMMIT WORK;
631: /* Retrieve message log and write result to log and output. */