APPS.IGI_IAC_PROJ_PKG dependencies on FA_CATEGORY_BOOKS

Line 251: p_category_id fa_category_books.category_id%TYPE,

247: -- FUNCTION Get_Price_Index_Val: get the price index value for the book,
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

Line 267: n_category_id fa_category_books.category_id%TYPE,

263: WHERE book_type_code = n_book_type_code;
264:
265: -- To get the price index value for a given period
266: CURSOR c_get_price_index_value(n_book_code fa_books.book_type_code%TYPE,
267: n_category_id fa_category_books.category_id%TYPE,
268: n_start_date fa_calendar_periods.start_date%TYPE,
269: n_end_date fa_calendar_periods.end_date%TYPE,
270: n_calendar_type fa_calendar_periods.calendar_type%TYPE
271: )