APPS.IGI_IAC_PROJ_PKG dependencies on FA_DEPRN_PERIODS

Line 252: p_period_ctr fa_deprn_periods.period_counter%TYPE,

248: -- category and period
249: -- ===================================================================
250: FUNCTION Get_Price_Index_Val(p_book_code fa_books.book_type_code%TYPE,
251: p_category_id fa_category_books.category_id%TYPE,
252: p_period_ctr fa_deprn_periods.period_counter%TYPE,
253: p_price_index_val OUT NOCOPY igi_iac_cal_idx_values.current_price_index_value%TYPE
254: )
255: RETURN BOOLEAN
256: IS

Line 415: p_next_period_ctr OUT NOCOPY fa_deprn_periods.period_counter%TYPE)

411: -- period counter
412: -- ===================================================================
413: PROCEDURE Get_Next_Period_Ctr(p_period_rec IN igi_iac_types.prd_rec,
414: p_book_code IN fa_books.book_type_code%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)

Line 472: p_period_counter fa_deprn_periods.period_counter%TYPE,

468: -- FUNCTION Chk_Asset_Life: Find if the life of asset is completed in
469: -- the given period
470: -- ===================================================================
471: FUNCTION Chk_Asset_Life( p_book_code fa_books.book_type_code%TYPE,
472: p_period_counter fa_deprn_periods.period_counter%TYPE,
473: p_asset_id fa_books.asset_id%TYPE,
474: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
475: )
476: RETURN BOOLEAN

Line 474: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE

470: -- ===================================================================
471: FUNCTION Chk_Asset_Life( p_book_code fa_books.book_type_code%TYPE,
472: p_period_counter fa_deprn_periods.period_counter%TYPE,
473: p_asset_id fa_books.asset_id%TYPE,
474: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
475: )
476: RETURN BOOLEAN
477: IS
478:

Line 659: FROM fa_deprn_periods

655: AND bk.depreciate_flag <> 'NO'
656: AND nvl(dh.date_ineffective,sysdate+1) > ah.date_effective
657: AND nvl(dh.date_ineffective,sysdate+1) <= nvl(ah.date_ineffective,sysdate+1)
658: AND dd.period_counter = (SELECT period_counter - 1
659: FROM fa_deprn_periods
660: WHERE book_type_code = n_book_type_code
661: AND period_close_date IS NULL)
662: AND bk.date_ineffective IS NULL
663: AND dh.distribution_id = id.distribution_id

Line 709: FROM fa_deprn_periods

705: AND dh.asset_id = ah.asset_id
706: AND nvl(dh.date_ineffective,sysdate+1) > ah.date_effective
707: AND nvl(dh.date_ineffective,sysdate+1) <= nvl(ah.date_ineffective,sysdate+1)
708: AND dd.period_counter = (SELECT period_counter -1
709: FROM fa_deprn_periods
710: WHERE book_type_code = n_book_type_code
711: AND period_close_date IS NULL)
712: AND bk.asset_id NOT IN
713: (SELECT asset_id

Line 958: l_last_prd_counter fa_deprn_periods.period_counter%TYPE;

954: l_cat_segs fa_rx_shared_pkg.Seg_Array;
955: l_cat_struct fa_system_controls.category_flex_structure%TYPE;
956:
957:
958: l_last_prd_counter fa_deprn_periods.period_counter%TYPE;
959: l_rec_count NUMBER;
960:
961: -- exceptions
962: NO_ASSETS_FOUND EXCEPTION;