DBA Data[Home] [Help]

APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on FA_API_TYPES

Line 12: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

8: p_batch_size IN number,
9: x_success_count OUT NOCOPY number,
10: x_failure_count OUT NOCOPY number,
11: x_return_status OUT NOCOPY number
12: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
13:
14: c_upgrade_bugno constant number(15) := -4107161;
15: c_fnd_user constant number(15) := 2;
16:

Line 98: l_trans_rec fa_api_types.trans_rec_type;

94: l_clearing_to_insert number := 0;
95: l_mrc_sob_type_code varchar2(1) := 'P';
96:
97: -- for api callouts
98: l_trans_rec fa_api_types.trans_rec_type;
99: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
100: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
101: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
102: l_asset_type_rec fa_api_types.asset_type_rec_type;

Line 99: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

95: l_mrc_sob_type_code varchar2(1) := 'P';
96:
97: -- for api callouts
98: l_trans_rec fa_api_types.trans_rec_type;
99: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
100: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
101: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
102: l_asset_type_rec fa_api_types.asset_type_rec_type;
103:

Line 100: l_asset_desc_rec fa_api_types.asset_desc_rec_type;

96:
97: -- for api callouts
98: l_trans_rec fa_api_types.trans_rec_type;
99: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
100: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
101: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
102: l_asset_type_rec fa_api_types.asset_type_rec_type;
103:
104: l_adj fa_adjust_type_pkg.fa_adj_row_struct;

Line 101: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

97: -- for api callouts
98: l_trans_rec fa_api_types.trans_rec_type;
99: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
100: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
101: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
102: l_asset_type_rec fa_api_types.asset_type_rec_type;
103:
104: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
105: l_calling_fn varchar2(35) := 'FACPUPGB.Upgrade_Addition';

Line 102: l_asset_type_rec fa_api_types.asset_type_rec_type;

98: l_trans_rec fa_api_types.trans_rec_type;
99: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
100: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
101: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
102: l_asset_type_rec fa_api_types.asset_type_rec_type;
103:
104: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
105: l_calling_fn varchar2(35) := 'FACPUPGB.Upgrade_Addition';
106: l_log_level_rec FA_API_TYPES.log_level_rec_type;

Line 106: l_log_level_rec FA_API_TYPES.log_level_rec_type;

102: l_asset_type_rec fa_api_types.asset_type_rec_type;
103:
104: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
105: l_calling_fn varchar2(35) := 'FACPUPGB.Upgrade_Addition';
106: l_log_level_rec FA_API_TYPES.log_level_rec_type;
107:
108: error_found exception;
109:
110: BEGIN

Line 328: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

324: p_batch_size IN number,
325: x_success_count OUT NOCOPY number,
326: x_failure_count OUT NOCOPY number,
327: x_return_status OUT NOCOPY number
328: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
329:
330: c_upgrade_bugno constant number(15) := -4107161;
331: c_fnd_user constant number(15) := 2;
332:

Line 425: l_trans_rec fa_api_types.trans_rec_type;

421: l_clearing_to_insert number := 0;
422: l_mrc_sob_type_code varchar2(1) := 'R';
423:
424: -- for api callouts
425: l_trans_rec fa_api_types.trans_rec_type;
426: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
427: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
428: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
429: l_asset_type_rec fa_api_types.asset_type_rec_type;

Line 426: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

422: l_mrc_sob_type_code varchar2(1) := 'R';
423:
424: -- for api callouts
425: l_trans_rec fa_api_types.trans_rec_type;
426: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
427: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
428: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
429: l_asset_type_rec fa_api_types.asset_type_rec_type;
430:

Line 427: l_asset_desc_rec fa_api_types.asset_desc_rec_type;

423:
424: -- for api callouts
425: l_trans_rec fa_api_types.trans_rec_type;
426: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
427: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
428: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
429: l_asset_type_rec fa_api_types.asset_type_rec_type;
430:
431: l_adj fa_adjust_type_pkg.fa_adj_row_struct;

Line 428: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

424: -- for api callouts
425: l_trans_rec fa_api_types.trans_rec_type;
426: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
427: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
428: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
429: l_asset_type_rec fa_api_types.asset_type_rec_type;
430:
431: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
432: l_calling_fn varchar2(35) := 'FACPUPGB.Upgrade_Addition_MRC';

Line 429: l_asset_type_rec fa_api_types.asset_type_rec_type;

425: l_trans_rec fa_api_types.trans_rec_type;
426: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
427: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
428: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
429: l_asset_type_rec fa_api_types.asset_type_rec_type;
430:
431: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
432: l_calling_fn varchar2(35) := 'FACPUPGB.Upgrade_Addition_MRC';
433: l_log_level_rec FA_API_TYPES.log_level_rec_type;

Line 433: l_log_level_rec FA_API_TYPES.log_level_rec_type;

429: l_asset_type_rec fa_api_types.asset_type_rec_type;
430:
431: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
432: l_calling_fn varchar2(35) := 'FACPUPGB.Upgrade_Addition_MRC';
433: l_log_level_rec FA_API_TYPES.log_level_rec_type;
434:
435: error_found exception;
436:
437: BEGIN

Line 642: p_log_level_rec IN FA_API_TYPES.log_level_rec_type

638: p_batch_size IN number,
639: x_success_count OUT NOCOPY number,
640: x_failure_count OUT NOCOPY number,
641: x_return_status OUT NOCOPY number,
642: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
643: default null
644: ) IS
645:
646: c_upgrade_bugno constant number(15) := -4107161;

Line 719: l_period_rec fa_api_types.period_rec_type;

715: l_production_tbl num_tbl_type;
716: l_ytd_production_tbl num_tbl_type;
717: l_ltd_production_tbl num_tbl_type;
718:
719: l_period_rec fa_api_types.period_rec_type;
720: l_trans_rec FA_API_TYPES.trans_rec_type;
721: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
722: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 720: l_trans_rec FA_API_TYPES.trans_rec_type;

716: l_ytd_production_tbl num_tbl_type;
717: l_ltd_production_tbl num_tbl_type;
718:
719: l_period_rec fa_api_types.period_rec_type;
720: l_trans_rec FA_API_TYPES.trans_rec_type;
721: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
722: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 721: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

717: l_ltd_production_tbl num_tbl_type;
718:
719: l_period_rec fa_api_types.period_rec_type;
720: l_trans_rec FA_API_TYPES.trans_rec_type;
721: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
722: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 722: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

718:
719: l_period_rec fa_api_types.period_rec_type;
720: l_trans_rec FA_API_TYPES.trans_rec_type;
721: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
722: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
726: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

719: l_period_rec fa_api_types.period_rec_type;
720: l_trans_rec FA_API_TYPES.trans_rec_type;
721: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
722: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
726: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
727: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

Line 724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

720: l_trans_rec FA_API_TYPES.trans_rec_type;
721: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
722: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
726: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
727: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
728: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

721: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
722: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
726: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
727: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
728: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
729: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type := null;

Line 726: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

722: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
726: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
727: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
728: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
729: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type := null;
730:

Line 727: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

723: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
726: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
727: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
728: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
729: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type := null;
730:
731: l_deprn_exp NUMBER;

Line 728: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

724: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
726: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
727: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
728: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
729: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type := null;
730:
731: l_deprn_exp NUMBER;
732: l_bonus_deprn_exp NUMBER;

Line 729: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type := null;

725: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
726: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
727: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
728: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
729: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type := null;
730:
731: l_deprn_exp NUMBER;
732: l_bonus_deprn_exp NUMBER;
733: l_impairment_exp NUMBER;

Line 745: l_log_level_rec FA_API_TYPES.log_level_rec_type;

741: l_dist NUMBER;
742: l_mrc_books NUMBER;
743:
744: l_calling_fn varchar2(35) := 'FACPUPGB.Upgrade_Backdated_Trxns';
745: l_log_level_rec FA_API_TYPES.log_level_rec_type;
746:
747: error_found exception;
748:
749: cursor c_trx is

Line 1713: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

1709: p_batch_size IN number,
1710: x_success_count OUT NOCOPY number,
1711: x_failure_count OUT NOCOPY number,
1712: x_return_status OUT NOCOPY number
1713: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1714:
1715: -- this value can be altered in order to process more of less per batch
1716: l_batch_size NUMBER;
1717: