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.10 2010/06/14 15:49:18 klakshmi 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
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
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 238: fa_mass_changes mch

234: bk.allowed_deprn_limit_amount
235: FROM fa_books bk,
236: fa_additions ad,
237: fa_additions_b gad,
238: fa_mass_changes mch
239: WHERE mch.mass_change_id = mc_rec.mass_change_id
240: AND ad.asset_type = nvl(mch.asset_type, ad.asset_type)
241: AND ad.asset_type <> 'CIP'
242: AND ad.asset_number >= nvl(mch.from_asset_number, ad.asset_number)

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

439: 'Starting Preview',
440: '');
441: end if;
442:
443: -- Concurrent request id fetched from fa_mass_changes table is in no use
444: -- in the preview module.
445: -- Assign h_request_id to the global mass change record field so that
446: -- it can be used in other procedures.
447:

Line 461: DELETE FROM fa_mass_changes_itf

457: 'before deleting rows from itf table',
458: '');
459: end if;
460:
461: DELETE FROM fa_mass_changes_itf
462: WHERE request_id = h_request_id;
463: COMMIT;
464:
465:

Line 664: UPDATE fa_mass_changes

660: after the RX report request.)
661: =========================================================================*/
662:
663: /*
664: UPDATE fa_mass_changes
665: SET status = 'PREVIEWED'
666: WHERE mass_change_id = X_Mass_Reclass_Id
667: AND status = 'PREVIEW';
668: COMMIT WORK;

Line 700: UPDATE fa_mass_changes

696: --g_total_assets := 0;
697:
698: /* A fatal error has occurred. Update status to 'FAILED_PRE'. */
699: ROLLBACK WORK;
700: UPDATE fa_mass_changes
701: SET status = 'FAILED_PRE'
702: WHERE mass_change_id = X_Mass_Change_Id;
703:
704: /* Delete rows inserted into the interface table. */

Line 705: DELETE FROM fa_mass_changes_itf

701: SET status = 'FAILED_PRE'
702: WHERE mass_change_id = X_Mass_Change_Id;
703:
704: /* Delete rows inserted into the interface table. */
705: DELETE FROM fa_mass_changes_itf
706: WHERE request_id = h_request_id;
707:
708: /* Commit changes. */
709: COMMIT WORK;

Line 742: UPDATE fa_mass_changes

738: --g_total_assets := 0;
739:
740: /* A fatal error has occurred. Update status to 'FAILED_PRE'. */
741: ROLLBACK WORK;
742: UPDATE fa_mass_changes
743: SET status = 'FAILED_PRE'
744: WHERE mass_change_id = X_Mass_Change_Id;
745:
746: /* Delete rows inserted into the interface table. */

Line 747: DELETE FROM fa_mass_changes_itf

743: SET status = 'FAILED_PRE'
744: WHERE mass_change_id = X_Mass_Change_Id;
745:
746: /* Delete rows inserted into the interface table. */
747: DELETE FROM fa_mass_changes_itf
748: WHERE request_id = h_request_id;
749:
750: /* Commit changes. */
751: COMMIT WORK;