11:
12: FUNCTION Calculate_YTD
13: ( p_book_type_code IN VARCHAR2,
14: p_asset_id IN NUMBER,
15: p_asset_info IN OUT NOCOPY igi_iac_types.fa_hist_asset_info,
16: p_start_period IN OUT NOCOPY NUMBER,
17: p_end_period IN OUT NOCOPY NUMBER,
18: p_calling_program IN VARCHAR2
19: ) RETURN BOOLEAN
34: SELECT number_per_fiscal_year
35: FROM fa_calendar_types
36: WHERE calendar_type = p_calendar_type;
37:
38: l_start_period igi_iac_types.prd_rec;
39: l_end_period igi_iac_types.prd_rec;
40: l_dpis_period igi_iac_types.prd_rec;
41: l_open_period igi_iac_types.prd_rec;
42: l_last_period igi_iac_types.prd_rec;
35: FROM fa_calendar_types
36: WHERE calendar_type = p_calendar_type;
37:
38: l_start_period igi_iac_types.prd_rec;
39: l_end_period igi_iac_types.prd_rec;
40: l_dpis_period igi_iac_types.prd_rec;
41: l_open_period igi_iac_types.prd_rec;
42: l_last_period igi_iac_types.prd_rec;
43: l_deprn_reserve NUMBER;
36: WHERE calendar_type = p_calendar_type;
37:
38: l_start_period igi_iac_types.prd_rec;
39: l_end_period igi_iac_types.prd_rec;
40: l_dpis_period igi_iac_types.prd_rec;
41: l_open_period igi_iac_types.prd_rec;
42: l_last_period igi_iac_types.prd_rec;
43: l_deprn_reserve NUMBER;
44: l_max_deprn_period NUMBER(15);
37:
38: l_start_period igi_iac_types.prd_rec;
39: l_end_period igi_iac_types.prd_rec;
40: l_dpis_period igi_iac_types.prd_rec;
41: l_open_period igi_iac_types.prd_rec;
42: l_last_period igi_iac_types.prd_rec;
43: l_deprn_reserve NUMBER;
44: l_max_deprn_period NUMBER(15);
45: l_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
38: l_start_period igi_iac_types.prd_rec;
39: l_end_period igi_iac_types.prd_rec;
40: l_dpis_period igi_iac_types.prd_rec;
41: l_open_period igi_iac_types.prd_rec;
42: l_last_period igi_iac_types.prd_rec;
43: l_deprn_reserve NUMBER;
44: l_max_deprn_period NUMBER(15);
45: l_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
46: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
45: l_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
46: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
47: l_total_periods NUMBER;
48: l_last_period_counter NUMBER;
49: l_last_deprn_period igi_iac_types.prd_rec;
50: l_deprn_periods_elapsed NUMBER;
51: l_deprn_periods_current_year NUMBER;
52:
53: BEGIN