30: p_amortization_start_date IN DATE,
31: p_mrc_sob_type_code IN VARCHAR2,
32: p_set_of_books_id IN NUMBER,
33: x_adj_cost_diff OUT NOCOPY NUMBER,
34: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
35:
36:
37: FUNCTION faxcdb(
38: rule_in IN fa_std_types.fa_deprn_rule_in_struct,
37: FUNCTION faxcdb(
38: rule_in IN fa_std_types.fa_deprn_rule_in_struct,
39: rule_out OUT NOCOPY fa_std_types.fa_deprn_rule_out_struct,
40: p_amortization_start_date IN date
41: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
42: return boolean is
43:
44: rule_id number(15) DEFAULT NULL;
45: l_rule_name varchar2(80) DEFAULT NULL;
1500: x_first_half_cost OUT NOCOPY NUMBER,
1501: x_first_half_cost_to_reduce OUT NOCOPY NUMBER,
1502: x_second_half_cost OUT NOCOPY NUMBER,
1503: x_second_half_cost_to_reduce OUT NOCOPY NUMBER
1504: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1505: return boolean is
1506:
1507: -- Query start date and end date of fiscal year and period
1508: cursor C_GET_DATE is
2681: p_mrc_sob_type_code IN VARCHAR2,
2682: p_set_of_books_id IN NUMBER,
2683: x_recoverable_cost OUT NOCOPY NUMBER,
2684: x_salvage_value OUT NOCOPY NUMBER
2685: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
2686: return boolean is
2687:
2688: l_period_close_date date;
2689:
3115: x_eofy_recoverable_cost OUT NOCOPY NUMBER,
3116: x_eofy_salvage_value OUT NOCOPY NUMBER,
3117: x_eop_recoverable_cost OUT NOCOPY NUMBER,
3118: x_eop_salvage_value OUT NOCOPY NUMBER
3119: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
3120: return boolean is
3121:
3122: cursor C_GET_NPFY
3123: is
3396: --------------------------------------------------------
3397:
3398: FUNCTION CALL_DEPRN_BASIS(
3399: p_event_type IN varchar2,
3400: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3401: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3402: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3403: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3404: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3397:
3398: FUNCTION CALL_DEPRN_BASIS(
3399: p_event_type IN varchar2,
3400: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3401: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3402: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3403: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3404: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3405: p_trans_rec IN fa_api_types.trans_rec_type,
3398: FUNCTION CALL_DEPRN_BASIS(
3399: p_event_type IN varchar2,
3400: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3401: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3402: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3403: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3404: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3405: p_trans_rec IN fa_api_types.trans_rec_type,
3406: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3399: p_event_type IN varchar2,
3400: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3401: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3402: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3403: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3404: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3405: p_trans_rec IN fa_api_types.trans_rec_type,
3406: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3407: p_period_rec IN fa_api_types.period_rec_type,
3400: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3401: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3402: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3403: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3404: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3405: p_trans_rec IN fa_api_types.trans_rec_type,
3406: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3407: p_period_rec IN fa_api_types.period_rec_type,
3408: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3401: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3402: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3403: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3404: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3405: p_trans_rec IN fa_api_types.trans_rec_type,
3406: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3407: p_period_rec IN fa_api_types.period_rec_type,
3408: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3409: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3402: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3403: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3404: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3405: p_trans_rec IN fa_api_types.trans_rec_type,
3406: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3407: p_period_rec IN fa_api_types.period_rec_type,
3408: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3409: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3410: p_dpr IN fa_std_types.dpr_struct,
3403: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3404: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3405: p_trans_rec IN fa_api_types.trans_rec_type,
3406: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3407: p_period_rec IN fa_api_types.period_rec_type,
3408: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3409: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3410: p_dpr IN fa_std_types.dpr_struct,
3411: p_fiscal_year IN number,
3404: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3405: p_trans_rec IN fa_api_types.trans_rec_type,
3406: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3407: p_period_rec IN fa_api_types.period_rec_type,
3408: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3409: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3410: p_dpr IN fa_std_types.dpr_struct,
3411: p_fiscal_year IN number,
3412: p_period_num IN number,
3405: p_trans_rec IN fa_api_types.trans_rec_type,
3406: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3407: p_period_rec IN fa_api_types.period_rec_type,
3408: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3409: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3410: p_dpr IN fa_std_types.dpr_struct,
3411: p_fiscal_year IN number,
3412: p_period_num IN number,
3413: p_period_counter IN number,
3438: px_new_adjusted_cost IN OUT NOCOPY number,
3439: px_new_raf IN OUT NOCOPY number,
3440: px_new_formula_factor IN OUT NOCOPY number,
3441: x_annual_deprn_rounding_flag IN OUT NOCOPY varchar2
3442: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
3443:
3444: h_rule_in fa_std_types.fa_deprn_rule_in_struct;
3445: h_rule_out fa_std_types.fa_deprn_rule_out_struct;
3446:
3977: --------------------------------------------------------
3978:
3979: FUNCTION CALL_DEPRN_BASIS(
3980: p_event_type IN varchar2,
3981: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3982: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3983: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3984: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3985: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3978:
3979: FUNCTION CALL_DEPRN_BASIS(
3980: p_event_type IN varchar2,
3981: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3982: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3983: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3984: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3985: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3986: p_trans_rec IN fa_api_types.trans_rec_type,
3979: FUNCTION CALL_DEPRN_BASIS(
3980: p_event_type IN varchar2,
3981: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3982: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3983: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3984: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3985: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3986: p_trans_rec IN fa_api_types.trans_rec_type,
3987: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3980: p_event_type IN varchar2,
3981: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3982: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3983: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3984: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3985: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3986: p_trans_rec IN fa_api_types.trans_rec_type,
3987: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3988: p_period_rec IN fa_api_types.period_rec_type,
3981: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3982: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3983: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3984: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3985: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3986: p_trans_rec IN fa_api_types.trans_rec_type,
3987: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3988: p_period_rec IN fa_api_types.period_rec_type,
3989: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3982: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3983: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3984: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3985: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3986: p_trans_rec IN fa_api_types.trans_rec_type,
3987: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3988: p_period_rec IN fa_api_types.period_rec_type,
3989: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3990: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3983: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3984: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3985: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3986: p_trans_rec IN fa_api_types.trans_rec_type,
3987: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3988: p_period_rec IN fa_api_types.period_rec_type,
3989: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3990: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3991: p_dpr IN fa_std_types.dpr_struct,
3984: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3985: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3986: p_trans_rec IN fa_api_types.trans_rec_type,
3987: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3988: p_period_rec IN fa_api_types.period_rec_type,
3989: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3990: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3991: p_dpr IN fa_std_types.dpr_struct,
3992: p_fiscal_year IN number,
3985: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3986: p_trans_rec IN fa_api_types.trans_rec_type,
3987: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3988: p_period_rec IN fa_api_types.period_rec_type,
3989: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3990: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3991: p_dpr IN fa_std_types.dpr_struct,
3992: p_fiscal_year IN number,
3993: p_period_num IN number,
3986: p_trans_rec IN fa_api_types.trans_rec_type,
3987: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3988: p_period_rec IN fa_api_types.period_rec_type,
3989: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3990: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3991: p_dpr IN fa_std_types.dpr_struct,
3992: p_fiscal_year IN number,
3993: p_period_num IN number,
3994: p_period_counter IN number,
4019: px_new_adjusted_cost IN OUT NOCOPY number,
4020: px_new_raf IN OUT NOCOPY number,
4021: px_new_formula_factor IN OUT NOCOPY number
4022:
4023: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
4024:
4025: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS';
4026: l_annual_deprn_rounding_flag varchar2(5);
4027: imp_next number;
4112: p_mrc_sob_type_code IN VARCHAR2,
4113: p_set_of_books_id IN NUMBER,
4114: x_ltd_proceeds OUT NOCOPY NUMBER,
4115: x_ytd_proceeds OUT NOCOPY NUMBER
4116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN is
4117:
4118: l_fy_start_date DATE; -- Start date of Fiscal Year
4119: l_period_end_date DATE; -- Close date at Transaction Period
4120:
4384: p_ltd_ytd_flag IN VARCHAR2,
4385: p_mrc_sob_type_code IN VARCHAR2,
4386: p_set_of_books_id IN NUMBER,
4387: x_retired_cost OUT NOCOPY NUMBER
4388: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN is
4389:
4390: l_fy_start_date date;
4391: l_period_end_date date;
4392:
4658: x_member_transaction_type_code OUT NOCOPY VARCHAR2,
4659: x_member_proceeds OUT NOCOPY NUMBER,
4660: x_member_reduction_rate OUT NOCOPY NUMBER,
4661: x_recognize_gain_loss OUT NOCOPY VARCHAR2
4662: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
4663: return boolean is
4664:
4665: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.get_mem_trans_info';
4666:
4769: --
4770: ---------------------------------------------------------------------
4771:
4772: Function SERVER_VALIDATION(
4773: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
4774:
4775: return boolean is
4776:
4777: svr_val_err exception;
4839: p_amortization_start_date IN DATE,
4840: p_mrc_sob_type_code IN VARCHAR2,
4841: p_set_of_books_id IN NUMBER,
4842: x_adj_cost_diff OUT NOCOPY NUMBER,
4843: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN is
4844:
4845: l_min_amrt_date date;
4846: l_max_adjcost_date date;
4847: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.calc_adj_cost_diff';