DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS1_PKG dependencies on FA_API_TYPES

Line 4: g_log_level_rec fa_api_types.log_level_rec_type;

1: PACKAGE BODY FA_CALC_DEPRN_BASIS1_PKG as
2: /* $Header: faxcdb1b.pls 120.67.12010000.4 2009/02/04 14:22:51 souroy ship $ */
3: -- global variables
4: g_log_level_rec fa_api_types.log_level_rec_type;
5: g_book_type_code fa_deprn_periods.book_type_code%TYPE;
6: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;
7: g_fiscal_year2 fa_fiscal_year.fiscal_year%TYPE;
8: g_period_num1 fa_calendar_periods.period_num%TYPE;

Line 18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

14: FUNCTION faxcdb(
15: rule_in IN fa_std_types.fa_deprn_rule_in_struct,
16: rule_out OUT NOCOPY fa_std_types.fa_deprn_rule_out_struct,
17: p_amortization_start_date IN date default null,
18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
19: return boolean is
20:
21: rule_id number(15) DEFAULT NULL;
22: l_rule_name varchar2(80) DEFAULT NULL;

Line 1379: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1375: x_first_half_cost OUT NOCOPY NUMBER,
1376: x_first_half_cost_to_reduce OUT NOCOPY NUMBER,
1377: x_second_half_cost OUT NOCOPY NUMBER,
1378: x_second_half_cost_to_reduce OUT NOCOPY NUMBER,
1379: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1380: return boolean is
1381:
1382: -- Query start date and end date of fiscal year and period
1383: cursor C_GET_DATE is

Line 2439: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

2435: p_transaction_date_entered IN DATE,
2436: p_mrc_sob_type_code IN VARCHAR2,
2437: x_recoverable_cost OUT NOCOPY NUMBER,
2438: x_salvage_value OUT NOCOPY NUMBER,
2439: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
2440: return boolean is
2441:
2442: l_period_close_date date;
2443: l_fy_start_date date;

Line 2891: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

2887: x_eofy_recoverable_cost OUT NOCOPY NUMBER,
2888: x_eofy_salvage_value OUT NOCOPY NUMBER,
2889: x_eop_recoverable_cost OUT NOCOPY NUMBER,
2890: x_eop_salvage_value OUT NOCOPY NUMBER,
2891: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
2892: return boolean is
2893:
2894: cursor C_GET_NPFY
2895: is

Line 3171: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,

3167: --------------------------------------------------------
3168:
3169: FUNCTION CALL_DEPRN_BASIS(
3170: p_event_type IN varchar2,
3171: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3172: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3173: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3174: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,

Line 3172: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

3168:
3169: FUNCTION CALL_DEPRN_BASIS(
3170: p_event_type IN varchar2,
3171: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3172: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3173: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3174: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3176: p_trans_rec IN fa_api_types.trans_rec_type,

Line 3173: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,

3169: FUNCTION CALL_DEPRN_BASIS(
3170: p_event_type IN varchar2,
3171: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3172: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3173: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3174: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3176: p_trans_rec IN fa_api_types.trans_rec_type,
3177: p_trans_rec_adj IN fa_api_types.trans_rec_type,

Line 3174: p_asset_type_rec IN fa_api_types.asset_type_rec_type,

3170: p_event_type IN varchar2,
3171: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3172: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3173: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3174: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3176: p_trans_rec IN fa_api_types.trans_rec_type,
3177: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3178: p_period_rec IN fa_api_types.period_rec_type,

Line 3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,

3171: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3172: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3173: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3174: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3176: p_trans_rec IN fa_api_types.trans_rec_type,
3177: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3178: p_period_rec IN fa_api_types.period_rec_type,
3179: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,

Line 3176: p_trans_rec IN fa_api_types.trans_rec_type,

3172: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3173: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3174: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3176: p_trans_rec IN fa_api_types.trans_rec_type,
3177: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3178: p_period_rec IN fa_api_types.period_rec_type,
3179: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3180: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,

Line 3177: p_trans_rec_adj IN fa_api_types.trans_rec_type,

3173: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3174: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3176: p_trans_rec IN fa_api_types.trans_rec_type,
3177: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3178: p_period_rec IN fa_api_types.period_rec_type,
3179: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3180: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3181: p_dpr IN fa_std_types.dpr_struct,

Line 3178: p_period_rec IN fa_api_types.period_rec_type,

3174: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3176: p_trans_rec IN fa_api_types.trans_rec_type,
3177: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3178: p_period_rec IN fa_api_types.period_rec_type,
3179: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3180: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3181: p_dpr IN fa_std_types.dpr_struct,
3182: p_fiscal_year IN number,

Line 3179: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,

3175: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3176: p_trans_rec IN fa_api_types.trans_rec_type,
3177: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3178: p_period_rec IN fa_api_types.period_rec_type,
3179: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3180: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3181: p_dpr IN fa_std_types.dpr_struct,
3182: p_fiscal_year IN number,
3183: p_period_num IN number,

Line 3180: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,

3176: p_trans_rec IN fa_api_types.trans_rec_type,
3177: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3178: p_period_rec IN fa_api_types.period_rec_type,
3179: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3180: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3181: p_dpr IN fa_std_types.dpr_struct,
3182: p_fiscal_year IN number,
3183: p_period_num IN number,
3184: p_period_counter IN number,

Line 3212: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS

3208: px_new_adjusted_cost IN OUT NOCOPY number,
3209: px_new_raf IN OUT NOCOPY number,
3210: px_new_formula_factor IN OUT NOCOPY number,
3211: x_annual_deprn_rounding_flag IN OUT NOCOPY varchar2,
3212: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
3213:
3214: h_rule_in fa_std_types.fa_deprn_rule_in_struct;
3215: h_rule_out fa_std_types.fa_deprn_rule_out_struct;
3216:

Line 3558: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,

3554: --------------------------------------------------------
3555:
3556: FUNCTION CALL_DEPRN_BASIS(
3557: p_event_type IN varchar2,
3558: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3559: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3560: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3561: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,

Line 3559: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

3555:
3556: FUNCTION CALL_DEPRN_BASIS(
3557: p_event_type IN varchar2,
3558: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3559: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3560: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3561: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3563: p_trans_rec IN fa_api_types.trans_rec_type,

Line 3560: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,

3556: FUNCTION CALL_DEPRN_BASIS(
3557: p_event_type IN varchar2,
3558: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3559: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3560: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3561: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3563: p_trans_rec IN fa_api_types.trans_rec_type,
3564: p_trans_rec_adj IN fa_api_types.trans_rec_type,

Line 3561: p_asset_type_rec IN fa_api_types.asset_type_rec_type,

3557: p_event_type IN varchar2,
3558: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3559: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3560: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3561: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3563: p_trans_rec IN fa_api_types.trans_rec_type,
3564: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3565: p_period_rec IN fa_api_types.period_rec_type,

Line 3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,

3558: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
3559: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3560: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3561: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3563: p_trans_rec IN fa_api_types.trans_rec_type,
3564: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3565: p_period_rec IN fa_api_types.period_rec_type,
3566: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,

Line 3563: p_trans_rec IN fa_api_types.trans_rec_type,

3559: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3560: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3561: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3563: p_trans_rec IN fa_api_types.trans_rec_type,
3564: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3565: p_period_rec IN fa_api_types.period_rec_type,
3566: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3567: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,

Line 3564: p_trans_rec_adj IN fa_api_types.trans_rec_type,

3560: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3561: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3563: p_trans_rec IN fa_api_types.trans_rec_type,
3564: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3565: p_period_rec IN fa_api_types.period_rec_type,
3566: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3567: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3568: p_dpr IN fa_std_types.dpr_struct,

Line 3565: p_period_rec IN fa_api_types.period_rec_type,

3561: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3563: p_trans_rec IN fa_api_types.trans_rec_type,
3564: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3565: p_period_rec IN fa_api_types.period_rec_type,
3566: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3567: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3568: p_dpr IN fa_std_types.dpr_struct,
3569: p_fiscal_year IN number,

Line 3566: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,

3562: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
3563: p_trans_rec IN fa_api_types.trans_rec_type,
3564: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3565: p_period_rec IN fa_api_types.period_rec_type,
3566: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3567: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3568: p_dpr IN fa_std_types.dpr_struct,
3569: p_fiscal_year IN number,
3570: p_period_num IN number,

Line 3567: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,

3563: p_trans_rec IN fa_api_types.trans_rec_type,
3564: p_trans_rec_adj IN fa_api_types.trans_rec_type,
3565: p_period_rec IN fa_api_types.period_rec_type,
3566: p_asset_retire_rec IN fa_api_types.asset_retire_rec_type,
3567: p_unplanned_deprn_rec IN fa_api_types.unplanned_deprn_rec_type,
3568: p_dpr IN fa_std_types.dpr_struct,
3569: p_fiscal_year IN number,
3570: p_period_num IN number,
3571: p_period_counter IN number,

Line 3598: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS

3594: p_mrc_sob_type_code IN varchar2,
3595: px_new_adjusted_cost IN OUT NOCOPY number,
3596: px_new_raf IN OUT NOCOPY number,
3597: px_new_formula_factor IN OUT NOCOPY number,
3598: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN IS
3599:
3600: l_calling_fn varchar2(50) := 'fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS';
3601: l_annual_deprn_rounding_flag varchar2(5);
3602:

Line 3692: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN is

3688: p_period_counter IN NUMBER,
3689: p_mrc_sob_type_code IN VARCHAR2,
3690: x_ltd_proceeds OUT NOCOPY NUMBER,
3691: x_ytd_proceeds OUT NOCOPY NUMBER,
3692: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN is
3693:
3694: l_fy_start_date DATE; -- Start date of Fiscal Year
3695: l_period_end_date DATE; -- Close date at Transaction Period
3696:

Line 3958: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN is

3954: p_adjustment_amount IN NUMBER,
3955: p_ltd_ytd_flag IN VARCHAR2,
3956: p_mrc_sob_type_code IN VARCHAR2,
3957: x_retired_cost OUT NOCOPY NUMBER,
3958: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN is
3959:
3960: l_fy_start_date date;
3961: l_period_end_date date;
3962:

Line 4225: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

4221: p_mrc_sob_type_code IN VARCHAR2,
4222: x_member_transaction_type_code OUT NOCOPY VARCHAR2,
4223: x_member_proceeds OUT NOCOPY NUMBER,
4224: x_member_reduction_rate OUT NOCOPY NUMBER,
4225: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
4226: return boolean is
4227:
4228: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.get_mem_trans_info';
4229:

Line 4333: Function SERVER_VALIDATION (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

4329: -- This function is to validate unexpected values
4330: --
4331: ---------------------------------------------------------------------
4332:
4333: Function SERVER_VALIDATION (p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
4334: return boolean is
4335:
4336: svr_val_err exception;
4337: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis1_pkg.server_validation';