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 143: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS

139: SELECT deprn_calendar
140: FROM fa_book_controls
141: WHERE book_type_code like p_book_type_code;
142:
143: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
144: SELECT number_per_fiscal_year
145: FROM fa_calendar_types
146: WHERE calendar_type = p_calendar_type;
147:

Line 145: FROM fa_calendar_types

141: WHERE book_type_code like p_book_type_code;
142:
143: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
144: SELECT number_per_fiscal_year
145: FROM fa_calendar_types
146: WHERE calendar_type = p_calendar_type;
147:
148: l_fa_deprn_acc fa_adjustments.adjustment_amount%TYPE;
149: l_dpis_period igi_iac_types.prd_rec;

Line 153: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;

149: l_dpis_period igi_iac_types.prd_rec;
150: l_current_period igi_iac_types.prd_rec;
151: l_last_period igi_iac_types.prd_rec;
152: l_booksrow_period_rec igi_iac_types.prd_rec;
153: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
154: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
155: l_booksrow_period NUMBER; -- added for bug 2961656
156: l_booksrow_reserve NUMBER; -- added for bug 2961656
157: l_deprn_reserve NUMBER;

Line 154: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;

150: l_current_period igi_iac_types.prd_rec;
151: l_last_period igi_iac_types.prd_rec;
152: l_booksrow_period_rec igi_iac_types.prd_rec;
153: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
154: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
155: l_booksrow_period NUMBER; -- added for bug 2961656
156: l_booksrow_reserve NUMBER; -- added for bug 2961656
157: l_deprn_reserve NUMBER;
158: l_reclass_period fa_deprn_periods.period_counter%TYPE;

Line 515: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;

511: l_fa_deprn_catchup_amount NUMBER;
512: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;
513: l_last_deprn_catchup_period NUMBER;
514: l_periods_in_year NUMBER;
515: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
516: /* Bug 2961656 vgadde 08-jul-2003 Start(3) */
517: l_iac_deprn_amount_py NUMBER;
518: l_iac_deprn_amount_cy NUMBER;
519: l_period_from igi_iac_types.prd_rec;

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

599: SELECT deprn_calendar
600: FROM fa_book_controls
601: WHERE book_type_code = p_asset_balance.book_type_code;
602:
603: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
604: SELECT number_per_fiscal_year
605: FROM fa_calendar_types
606: WHERE calendar_type = p_calendar_type;
607:

Line 605: FROM fa_calendar_types

601: WHERE book_type_code = p_asset_balance.book_type_code;
602:
603: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
604: SELECT number_per_fiscal_year
605: FROM fa_calendar_types
606: WHERE calendar_type = p_calendar_type;
607:
608: CURSOR c_get_user_deprn IS
609: SELECT period_counter,deprn_reserve,YTD_deprn

Line 1562: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;

1558: l_last_deprn_date DATE;
1559: /* Bug 2961656 vgadde 08-jul-2003 End(8) */
1560: l_path_name VARCHAR2(150);
1561: l_booksrow_period_rec igi_iac_types.prd_rec;
1562: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
1563: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
1564: l_booksrow_period NUMBER;
1565: l_booksrow_reserve NUMBER;
1566: l_booksrow_YTD NUMBER;

Line 1563: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;

1559: /* Bug 2961656 vgadde 08-jul-2003 End(8) */
1560: l_path_name VARCHAR2(150);
1561: l_booksrow_period_rec igi_iac_types.prd_rec;
1562: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
1563: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
1564: l_booksrow_period NUMBER;
1565: l_booksrow_reserve NUMBER;
1566: l_booksrow_YTD NUMBER;
1567: l_fa_deprn_expense_py NUMBER;