APPS.IGI_IAC_PROJ_PKG dependencies on FA_CALENDAR_TYPES

Line 287: l_calendar fa_calendar_types.calendar_type%type;

283: AND category_id= n_category_id));
284:
285: l_prd_rec igi_iac_types.prd_rec;
286: l_ret_flag BOOLEAN;
287: l_calendar fa_calendar_types.calendar_type%type;
288:
289:
290: BEGIN
291: -- Get Price index value

Line 419: CURSOR c_get_num_per_period(n_calendar fa_calendar_types.calendar_type%TYPE)

415: p_next_period_ctr OUT NOCOPY fa_deprn_periods.period_counter%TYPE)
416: IS
417:
418: -- get the number of periods per fiscal year
419: CURSOR c_get_num_per_period(n_calendar fa_calendar_types.calendar_type%TYPE)
420: IS
421: SELECT number_per_fiscal_year
422: FROM fa_calendar_types
423: WHERE calendar_type = n_calendar;

Line 422: FROM fa_calendar_types

418: -- get the number of periods per fiscal year
419: CURSOR c_get_num_per_period(n_calendar fa_calendar_types.calendar_type%TYPE)
420: IS
421: SELECT number_per_fiscal_year
422: FROM fa_calendar_types
423: WHERE calendar_type = n_calendar;
424:
425: -- Get deprn calendar
426: CURSOR c_get_calendar(n_book_code fa_books.book_type_code%TYPE)

Line 432: l_num_per_period fa_calendar_types.number_per_fiscal_year%TYPE;

428: SELECT deprn_calendar
429: FROM fa_book_controls
430: WHERE book_type_code = n_book_code;
431:
432: l_num_per_period fa_calendar_types.number_per_fiscal_year%TYPE;
433: l_mod_value NUMBER;
434: l_fiscal_yr fa_fiscal_year.fiscal_year%TYPE;
435: l_next_period_num fa_calendar_periods.period_num%TYPE;
436: l_calendar fa_calendar_types.calendar_type%TYPE;

Line 436: l_calendar fa_calendar_types.calendar_type%TYPE;

432: l_num_per_period fa_calendar_types.number_per_fiscal_year%TYPE;
433: l_mod_value NUMBER;
434: l_fiscal_yr fa_fiscal_year.fiscal_year%TYPE;
435: l_next_period_num fa_calendar_periods.period_num%TYPE;
436: l_calendar fa_calendar_types.calendar_type%TYPE;
437:
438:
439: BEGIN
440:

Line 493: FROM fa_calendar_types

489:
490: CURSOR c_get_periods_in_year(n_book_code fa_books.book_type_code%TYPE)
491: IS
492: SELECT number_per_fiscal_year
493: FROM fa_calendar_types
494: WHERE calendar_type = (SELECT deprn_calendar
495: FROM fa_book_controls
496: WHERE book_type_code = n_book_code);
497:

Line 506: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;

502: l_asset_rec c_get_asset_det%ROWTYPE;
503: l_ret_flag BOOLEAN;
504: l_mess varchar2(255);
505:
506: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
507: l_dpis_prd_rec igi_iac_types.prd_rec;
508: l_total_periods NUMBER;
509:
510: -- l_last_period_counter NUMBER;