DBA Data[Home] [Help]

APPS.IGI_IAC_YTD_ENGINE dependencies on IGI_IAC_TYPES

Line 15: p_asset_info IN OUT NOCOPY igi_iac_types.fa_hist_asset_info,

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

Line 38: l_start_period igi_iac_types.prd_rec;

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;

Line 39: l_end_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;

Line 40: l_dpis_period igi_iac_types.prd_rec;

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);

Line 41: l_open_period igi_iac_types.prd_rec;

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;

Line 42: l_last_period igi_iac_types.prd_rec;

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;

Line 49: l_last_deprn_period igi_iac_types.prd_rec;

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