eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_CATCHUP_PKG dependencies on FA_CALENDAR_TYPES

Line 126: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS

122: SELECT deprn_calendar
123: FROM fa_book_controls
124: WHERE book_type_code like p_book_type_code;
125:
126: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
127: SELECT number_per_fiscal_year
128: FROM fa_calendar_types
129: WHERE calendar_type = p_calendar_type;
130:

Line 128: FROM fa_calendar_types

124: WHERE book_type_code like p_book_type_code;
125:
126: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
127: SELECT number_per_fiscal_year
128: FROM fa_calendar_types
129: WHERE calendar_type = p_calendar_type;
130:
131: l_fa_deprn_acc fa_adjustments.adjustment_amount%TYPE;
132: l_dpis_period igi_iac_types.prd_rec;

Line 136: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;

132: l_dpis_period igi_iac_types.prd_rec;
133: l_current_period igi_iac_types.prd_rec;
134: l_last_period igi_iac_types.prd_rec;
135: l_booksrow_period_rec igi_iac_types.prd_rec;
136: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
137: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
138: l_booksrow_period NUMBER; -- added for bug 2961656
139: l_booksrow_reserve NUMBER; -- added for bug 2961656
140: l_deprn_reserve NUMBER;

Line 137: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;

133: l_current_period igi_iac_types.prd_rec;
134: l_last_period igi_iac_types.prd_rec;
135: l_booksrow_period_rec igi_iac_types.prd_rec;
136: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
137: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
138: l_booksrow_period NUMBER; -- added for bug 2961656
139: l_booksrow_reserve NUMBER; -- added for bug 2961656
140: l_deprn_reserve NUMBER;
141: l_reclass_period fa_deprn_periods.period_counter%TYPE;

Line 473: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;

469: l_fa_deprn_catchup_amount NUMBER;
470: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;
471: l_last_deprn_catchup_period NUMBER;
472: l_periods_in_year NUMBER;
473: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
474: /* Bug 2961656 vgadde 08-jul-2003 Start(3) */
475: l_iac_deprn_amount_py NUMBER;
476: l_iac_deprn_amount_cy NUMBER;
477: l_period_from igi_iac_types.prd_rec;

Line 561: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS

557: SELECT deprn_calendar
558: FROM fa_book_controls
559: WHERE book_type_code = p_asset_balance.book_type_code;
560:
561: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
562: SELECT number_per_fiscal_year
563: FROM fa_calendar_types
564: WHERE calendar_type = p_calendar_type;
565:

Line 563: FROM fa_calendar_types

559: WHERE book_type_code = p_asset_balance.book_type_code;
560:
561: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
562: SELECT number_per_fiscal_year
563: FROM fa_calendar_types
564: WHERE calendar_type = p_calendar_type;
565:
566: CURSOR c_get_user_deprn IS
567: SELECT period_counter,deprn_reserve,YTD_deprn

Line 1479: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;

1475: l_last_deprn_date DATE;
1476: /* Bug 2961656 vgadde 08-jul-2003 End(8) */
1477: l_path_name VARCHAR2(150);
1478: l_booksrow_period_rec igi_iac_types.prd_rec;
1479: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
1480: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
1481: l_booksrow_period NUMBER;
1482: l_booksrow_reserve NUMBER;
1483: l_booksrow_YTD NUMBER;

Line 1480: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;

1476: /* Bug 2961656 vgadde 08-jul-2003 End(8) */
1477: l_path_name VARCHAR2(150);
1478: l_booksrow_period_rec igi_iac_types.prd_rec;
1479: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
1480: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
1481: l_booksrow_period NUMBER;
1482: l_booksrow_reserve NUMBER;
1483: l_booksrow_YTD NUMBER;
1484: l_fa_deprn_expense_py NUMBER;