[Home] [Help]
1: PACKAGE BODY FARX_MCR AS
2: /* $Header: FARXMCRB.pls 120.3.12010000.1 2008/07/28 13:13:57 appldev ship $ */
3:
4:
5: -- Mass change record from fa_mass_changes table.
6: mc_rec FA_MASS_CHG_UTILS_PKG.mass_change_rec_type;
7:
8: -- Table of asset records.
9: -- (Stores book_type_code as well, and thus one asset will appear multiple
102: mc.from_deprn_limit,
103: mc.to_deprn_limit,
104: mc.from_deprn_limit_amount,
105: mc.to_deprn_limit_amount -- Bug 6964615 end
106: FROM fa_mass_changes mc,
107: fa_additions_b gad1,
108: fa_additions_b gad2
109: WHERE mass_change_id = X_Mass_Change_Id
110: AND mc.from_group_asset_id = gad1.asset_id(+)
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;
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;
227:
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;
227:
228: -- Fetch mass changes record information.
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: /*===========================================================================
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.
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. */
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. */