APPS.FARX_MCP dependencies on FA_MASS_CHANGES

Line 4: -- Mass change record from fa_mass_changes table.

1: PACKAGE BODY FARX_MCP AS
2: /* $Header: FARXMCPB.pls 120.3.12010000.1 2008/07/28 13:13:55 appldev ship $ */
3:
4: -- Mass change record from fa_mass_changes table.
5: mc_rec FA_MASS_CHG_UTILS_PKG.mass_change_rec_type;
6:
7: -- Table of asset records.
8: a_tbl FA_MASS_CHG_UTILS_PKG.asset_tbl_type;

Line 108: FROM fa_mass_changes mc,

104: mc.from_deprn_limit,
105: mc.to_deprn_limit,
106: mc.from_deprn_limit_amount,
107: mc.to_deprn_limit_amount -- Bug 6964615 start
108: FROM fa_mass_changes mc,
109: fa_additions_b gad1,
110: fa_additions_b gad2
111: WHERE mass_change_id = X_Mass_Change_Id
112: AND mc.from_group_asset_id = gad1.asset_id(+)

Line 142: fa_mass_changes mch

138: bk.allowed_deprn_limit_amount -- Bug 6964615 end
139: FROM fa_books bk,
140: fa_additions ad,
141: fa_additions_b gad,
142: fa_mass_changes mch
143: WHERE mch.mass_change_id = mc_rec.mass_change_id
144: AND ad.asset_type = nvl(mch.asset_type, ad.asset_type)
145: AND ad.asset_type <> 'CIP'
146: AND ad.asset_number >= nvl(mch.from_asset_number, ad.asset_number)

Line 337: -- Concurrent request id fetched from fa_mass_changes table is in no use

333: 'Starting Preview',
334: '');
335: end if;
336:
337: -- Concurrent request id fetched from fa_mass_changes table is in no use
338: -- in the preview module.
339: -- Assign h_request_id to the global mass change record field so that
340: -- it can be used in other procedures.
341:

Line 355: DELETE FROM fa_mass_changes_itf

351: 'before deleting rows from itf table',
352: '');
353: end if;
354:
355: DELETE FROM fa_mass_changes_itf
356: WHERE request_id = h_request_id;
357: COMMIT;
358:
359:

Line 556: UPDATE fa_mass_changes

552: after the RX report request.)
553: =========================================================================*/
554:
555: /*
556: UPDATE fa_mass_changes
557: SET status = 'PREVIEWED'
558: WHERE mass_change_id = X_Mass_Reclass_Id
559: AND status = 'PREVIEW';
560: COMMIT WORK;

Line 592: UPDATE fa_mass_changes

588: --g_total_assets := 0;
589:
590: /* A fatal error has occurred. Update status to 'FAILED_PRE'. */
591: ROLLBACK WORK;
592: UPDATE fa_mass_changes
593: SET status = 'FAILED_PRE'
594: WHERE mass_change_id = X_Mass_Change_Id;
595:
596: /* Delete rows inserted into the interface table. */

Line 597: DELETE FROM fa_mass_changes_itf

593: SET status = 'FAILED_PRE'
594: WHERE mass_change_id = X_Mass_Change_Id;
595:
596: /* Delete rows inserted into the interface table. */
597: DELETE FROM fa_mass_changes_itf
598: WHERE request_id = h_request_id;
599:
600: /* Commit changes. */
601: COMMIT WORK;

Line 636: UPDATE fa_mass_changes

632: --g_total_assets := 0;
633:
634: /* A fatal error has occurred. Update status to 'FAILED_PRE'. */
635: ROLLBACK WORK;
636: UPDATE fa_mass_changes
637: SET status = 'FAILED_PRE'
638: WHERE mass_change_id = X_Mass_Change_Id;
639:
640: /* Delete rows inserted into the interface table. */

Line 641: DELETE FROM fa_mass_changes_itf

637: SET status = 'FAILED_PRE'
638: WHERE mass_change_id = X_Mass_Change_Id;
639:
640: /* Delete rows inserted into the interface table. */
641: DELETE FROM fa_mass_changes_itf
642: WHERE request_id = h_request_id;
643:
644: /* Commit changes. */
645: COMMIT WORK;