DBA Data[Home] [Help]

APPS.FA_TRACK_MEMBER_PVT dependencies on FA_API_TYPES

Line 44: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

40: P_mode in varchar2, -- default NULL,
41: P_mrc_sob_type_code in varchar2, -- default 'N',
42: X_new_deprn_amount out nocopy number,
43: X_new_bonus_amount out nocopy number,
44: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
45: return number is
46:
47: -- variables for the input and output parameters
48: x_counter number;

Line 252: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

248: P_mrc_sob_type_code in varchar2, -- default 'N',
249: P_mode in varchar2, -- default NULL,
250: X_new_deprn_amount out nocopy number,
251: X_new_bonus_amount out nocopy number,
252: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
253: return boolean is
254:
255: -- variables for the input and output parameters
256: h_book_type_code varchar2(15);

Line 2921: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

2917: P_nbv_thresh_amount in number,
2918: P_rec_cost_abs_value in number,
2919: X_life_complete_flag out nocopy varchar2,
2920: X_fully_reserved_flag out nocopy varchar2,
2921: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
2922: return number is
2923:
2924: -- varibales for internal
2925: nbv_absval number;

Line 3025: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

3021: P_mrc_sob_type_code in varchar2, -- default 'N',
3022: P_mode in Varchar2,
3023: P_rec_cost_for_odda in number,
3024: P_sv_for_odda in number,
3025: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
3026: return boolean is
3027:
3028: -- variables
3029: x_calc_done varchar2(1);

Line 3672: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default NULL)

3668:
3669: FUNCTION update_deprn_basis(p_group_rule_in in fa_std_types.fa_deprn_rule_in_struct,
3670: p_apply_reduction_flag in varchar2, -- default NULL,
3671: p_mode in varchar2,
3672: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default NULL)
3673: return boolean is
3674:
3675: --* Structure to call Deprn Basis Rule
3676: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

Line 5372: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

5368: p_period_of_addition in varchar2, -- default NULL,
5369: p_transaction_date_entered in date, -- default NULL,
5370: p_mrc_sob_type_code in varchar2, -- default 'N',
5371: p_mode in varchar2,
5372: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
5373: return boolean is
5374:
5375: --* Internal structure
5376: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 5376: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

5372: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
5373: return boolean is
5374:
5375: --* Internal structure
5376: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5377: x_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5378: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
5379: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
5380:

Line 5377: x_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

5373: return boolean is
5374:
5375: --* Internal structure
5376: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5377: x_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5378: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
5379: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
5380:
5381: --* Internal Variable

Line 5378: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

5374:
5375: --* Internal structure
5376: p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5377: x_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5378: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
5379: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
5380:
5381: --* Internal Variable
5382: p_transaction_header_id number;

Line 5809: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default null

5805: p_allocate_to_fully_ret_flag in varchar2,
5806: p_allocate_to_fully_rsv_flag in varchar2,
5807: p_mrc_sob_type_code in varchar2, -- default 'N'
5808: p_calling_fn in varchar2,
5809: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default null
5810: return boolean is
5811:
5812: --* Structure to call Deprn Basis Rule
5813: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

Line 6897: FUNCTION get_member_at_start(p_period_rec in FA_API_TYPES.period_rec_type,

6893: -- And populate the necessary info into FA_TRACK_MEMBER table.
6894: --
6895: --+=====================================================================
6896:
6897: FUNCTION get_member_at_start(p_period_rec in FA_API_TYPES.period_rec_type,
6898: p_trans_rec in FA_API_TYPES.trans_rec_type,
6899: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
6900: p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type,
6901: p_dpr_in in FA_STD_TYPES.dpr_struct,

Line 6898: p_trans_rec in FA_API_TYPES.trans_rec_type,

6894: --
6895: --+=====================================================================
6896:
6897: FUNCTION get_member_at_start(p_period_rec in FA_API_TYPES.period_rec_type,
6898: p_trans_rec in FA_API_TYPES.trans_rec_type,
6899: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
6900: p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type,
6901: p_dpr_in in FA_STD_TYPES.dpr_struct,
6902: p_mrc_sob_type_code in varchar2 default 'N',

Line 6899: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,

6895: --+=====================================================================
6896:
6897: FUNCTION get_member_at_start(p_period_rec in FA_API_TYPES.period_rec_type,
6898: p_trans_rec in FA_API_TYPES.trans_rec_type,
6899: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
6900: p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type,
6901: p_dpr_in in FA_STD_TYPES.dpr_struct,
6902: p_mrc_sob_type_code in varchar2 default 'N',
6903: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

Line 6900: p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type,

6896:
6897: FUNCTION get_member_at_start(p_period_rec in FA_API_TYPES.period_rec_type,
6898: p_trans_rec in FA_API_TYPES.trans_rec_type,
6899: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
6900: p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type,
6901: p_dpr_in in FA_STD_TYPES.dpr_struct,
6902: p_mrc_sob_type_code in varchar2 default 'N',
6903: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
6904: return boolean is

Line 6903: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

6899: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
6900: p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type,
6901: p_dpr_in in FA_STD_TYPES.dpr_struct,
6902: p_mrc_sob_type_code in varchar2 default 'N',
6903: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
6904: return boolean is
6905:
6906: --* Host related variables
6907: h_book_type_code varchar2(15);

Line 7732: FUNCTION update_member_books(p_trans_rec in FA_API_TYPES.trans_rec_type,

7728: -- FA_BOOKS will be updated.
7729: --
7730: --+=====================================================================
7731:
7732: FUNCTION update_member_books(p_trans_rec in FA_API_TYPES.trans_rec_type,
7733: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
7734: p_dpr_in in FA_STD_TYPES.dpr_struct,
7735: p_mrc_sob_type_code in varchar2,
7736: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default 'N'

Line 7733: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,

7729: --
7730: --+=====================================================================
7731:
7732: FUNCTION update_member_books(p_trans_rec in FA_API_TYPES.trans_rec_type,
7733: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
7734: p_dpr_in in FA_STD_TYPES.dpr_struct,
7735: p_mrc_sob_type_code in varchar2,
7736: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default 'N'
7737: return boolean is

Line 7736: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default 'N'

7732: FUNCTION update_member_books(p_trans_rec in FA_API_TYPES.trans_rec_type,
7733: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
7734: p_dpr_in in FA_STD_TYPES.dpr_struct,
7735: p_mrc_sob_type_code in varchar2,
7736: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default 'N'
7737: return boolean is
7738:
7739: --* Host related variables
7740: h_book_type_code varchar2(15);

Line 7993: FUNCTION member_eofy_rsv(p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,

7989: -- calculated eofy_reserve will be kept in PL\SQL table
7990: --
7991: --+=====================================================================
7992:
7993: FUNCTION member_eofy_rsv(p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
7994: p_dpr_in in FA_STD_TYPES.dpr_struct,
7995: p_mrc_sob_type_code in varchar2,
7996: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default 'N'
7997: return boolean is

Line 7996: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default 'N'

7992:
7993: FUNCTION member_eofy_rsv(p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
7994: p_dpr_in in FA_STD_TYPES.dpr_struct,
7995: p_mrc_sob_type_code in varchar2,
7996: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) -- default 'N'
7997: return boolean is
7998:
7999: --* Host related variables
8000: h_book_type_code varchar2(15);

Line 8140: FUNCTION populate_member_assets_table(p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,

8136: -- made from group DPIS to one period before when recalculation will start
8137: --
8138: --+=====================================================================
8139:
8140: FUNCTION populate_member_assets_table(p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
8141: p_asset_fin_rec_new in FA_API_TYPES.asset_fin_rec_type,
8142: p_populate_for_recalc_period in varchar2,
8143: p_amort_start_date in date,
8144: p_recalc_start_fy in number,

Line 8141: p_asset_fin_rec_new in FA_API_TYPES.asset_fin_rec_type,

8137: --
8138: --+=====================================================================
8139:
8140: FUNCTION populate_member_assets_table(p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
8141: p_asset_fin_rec_new in FA_API_TYPES.asset_fin_rec_type,
8142: p_populate_for_recalc_period in varchar2,
8143: p_amort_start_date in date,
8144: p_recalc_start_fy in number,
8145: p_recalc_start_period_num in number,

Line 8148: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

8144: p_recalc_start_fy in number,
8145: p_recalc_start_period_num in number,
8146: p_no_allocation_for_last in varchar2,
8147: p_mrc_sob_type_code in varchar2,
8148: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
8149: return boolean is
8150:
8151: --* Local variables used in this process
8152: h_book_type_code varchar2(15);

Line 10291: FUNCTION populate_member_reserve(p_trans_rec in FA_API_TYPES.trans_rec_type,

10287: -- date populating member level reserve amount tracked.
10288: --
10289: --+=====================================================================
10290:
10291: FUNCTION populate_member_reserve(p_trans_rec in FA_API_TYPES.trans_rec_type,
10292: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
10293: p_asset_fin_rec_new in FA_API_TYPES.asset_fin_rec_type,
10294: p_mrc_sob_type_code in varchar2,
10295: x_deprn_reserve out nocopy number,

Line 10292: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,

10288: --
10289: --+=====================================================================
10290:
10291: FUNCTION populate_member_reserve(p_trans_rec in FA_API_TYPES.trans_rec_type,
10292: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
10293: p_asset_fin_rec_new in FA_API_TYPES.asset_fin_rec_type,
10294: p_mrc_sob_type_code in varchar2,
10295: x_deprn_reserve out nocopy number,
10296: x_eofy_reserve out nocopy number,

Line 10293: p_asset_fin_rec_new in FA_API_TYPES.asset_fin_rec_type,

10289: --+=====================================================================
10290:
10291: FUNCTION populate_member_reserve(p_trans_rec in FA_API_TYPES.trans_rec_type,
10292: p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type,
10293: p_asset_fin_rec_new in FA_API_TYPES.asset_fin_rec_type,
10294: p_mrc_sob_type_code in varchar2,
10295: x_deprn_reserve out nocopy number,
10296: x_eofy_reserve out nocopy number,
10297: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

Line 10297: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

10293: p_asset_fin_rec_new in FA_API_TYPES.asset_fin_rec_type,
10294: p_mrc_sob_type_code in varchar2,
10295: x_deprn_reserve out nocopy number,
10296: x_eofy_reserve out nocopy number,
10297: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10298: return boolean is
10299:
10300: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
10301:

Line 10300: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

10296: x_eofy_reserve out nocopy number,
10297: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10298: return boolean is
10299:
10300: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
10301:
10302: h_book_type_code varchar2(15);
10303: h_member_asset_id number(15);
10304: h_group_asset_id number(15);

Line 10625: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

10621: p_group_eofy_salvage_value in number,
10622: p_group_eofy_reserve in number,
10623: p_mrc_sob_type_code in varchar2,
10624: x_apply_reduction_flag out nocopy varchar2,
10625: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10626: return boolean is
10627:
10628: --* Local variables
10629: h_half_year_rule_flag varchar2(1);

Line 10760: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

10756: --+=====================================================================
10757:
10758: FUNCTION display_debug_message(fa_rule_in in fa_std_types.fa_deprn_rule_in_struct,
10759: p_calling_fn in varchar2,
10760: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10761:
10762: return boolean is
10763:
10764: --* local variables

Line 10805: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

10801: --+=====================================================================
10802:
10803: FUNCTION display_debug_message2(i in number,
10804: p_calling_fn in varchar2,
10805: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10806:
10807: return boolean is
10808:
10809: --* local variables

Line 10852: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

10848:
10849: FUNCTION copy_member_table(p_backup_restore in varchar2,
10850: p_current_fiscal_year in number,
10851: p_current_period_num in number,
10852: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10853:
10854: return boolean is
10855:
10856: --* local variables

Line 10979: FUNCTION create_update_bs_table(p_trans_rec in FA_API_TYPES.trans_rec_type,

10975: -- update fa_books_summary row if exists
10976: --
10977: --+=====================================================================
10978:
10979: FUNCTION create_update_bs_table(p_trans_rec in FA_API_TYPES.trans_rec_type,
10980: p_book_type_code in varchar2,
10981: p_group_asset_id in varchar2,
10982: p_mrc_sob_type_code in varchar2,
10983: p_calling_fn in varchar2,

Line 10984: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

10980: p_book_type_code in varchar2,
10981: p_group_asset_id in varchar2,
10982: p_mrc_sob_type_code in varchar2,
10983: p_calling_fn in varchar2,
10984: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10985: return boolean is
10986:
10987: --* Local variables
10988: h_book_type_code varchar2(15);

Line 11253: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

11249: p_calling_fn in varchar2,
11250: p_mrc_sob_type_code in varchar2,
11251: p_recoverable_cost in number,
11252: p_salvage_value in number,
11253: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
11254: return boolean is
11255:
11256: --* Local variables
11257: h_period_name varchar2(15);