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_RECLASS_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 67: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;

63: l_old_cap_flag fa_categories.capitalize_flag%type;
64: l_old_cat_type fa_categories.category_type%type;
65: l_new_cap_flag fa_categories.capitalize_flag%type;
66: l_new_cat_type fa_categories.category_type%type;
67: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
68: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
69: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
70: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
71: l_path_name VARCHAR2(150);

Line 68: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;

64: l_old_cat_type fa_categories.category_type%type;
65: l_new_cap_flag fa_categories.capitalize_flag%type;
66: l_new_cat_type fa_categories.category_type%type;
67: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
68: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
69: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
70: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
71: l_path_name VARCHAR2(150);
72:

Line 69: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;

65: l_new_cap_flag fa_categories.capitalize_flag%type;
66: l_new_cat_type fa_categories.category_type%type;
67: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
68: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
69: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
70: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
71: l_path_name VARCHAR2(150);
72:
73:

Line 70: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;

66: l_new_cat_type fa_categories.category_type%type;
67: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
68: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
69: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
70: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
71: l_path_name VARCHAR2(150);
72:
73:
74: -- cursor to validate category linked to iac book

Line 77: FROM igi_iac_category_books

73:
74: -- cursor to validate category linked to iac book
75: Cursor get_category_id(c_category_id Number)is
76: SELECT category_id,allow_indexed_reval_flag,allow_prof_reval_flag
77: FROM igi_iac_category_books
78: WHERE book_type_code = l_asset_hdr_rec.book_type_code
79: AND category_id = c_category_id;
80:
81: --cursor to get the category capitalized

Line 2948: FROM igi_iac_category_books

2944: ) return BOOLEAN IS
2945:
2946: CURSOR c_allow_indexed_reval_flag IS
2947: SELECT allow_indexed_reval_flag
2948: FROM igi_iac_category_books
2949: WHERE book_type_code = p_book_type_code
2950: AND category_id = p_category_id;
2951:
2952: CURSOR c_period_num_for_catchup IS

Line 2983: l_allow_indexed_reval_flag igi_iac_category_books.allow_indexed_reval_flag%TYPE;

2979:
2980: l_dpis_period_counter NUMBER;
2981: l_open_period igi_iac_types.prd_rec;
2982: l_period_info igi_iac_types.prd_rec;
2983: l_allow_indexed_reval_flag igi_iac_category_books.allow_indexed_reval_flag%TYPE;
2984: l_period_num_for_catchup igi_iac_book_controls.period_num_for_catchup%TYPE;
2985: l_idx1 BINARY_INTEGER;
2986: l_idx2 BINARY_INTEGER;
2987: l_reval_control igi_iac_types.iac_reval_control_tab;

Line 3822: l_old_price_index igi_iac_category_books.price_index_id%type;

3818: p_calling_function VARCHAR2,
3819: p_event_id number --R12 uptake
3820: ) return BOOLEAN is
3821:
3822: l_old_price_index igi_iac_category_books.price_index_id%type;
3823: l_new_price_index igi_iac_category_books.price_index_id%type;
3824:
3825: -- cursor to get the price index of the asset
3826: Cursor get_price_index(c_category_id number) is

Line 3823: l_new_price_index igi_iac_category_books.price_index_id%type;

3819: p_event_id number --R12 uptake
3820: ) return BOOLEAN is
3821:
3822: l_old_price_index igi_iac_category_books.price_index_id%type;
3823: l_new_price_index igi_iac_category_books.price_index_id%type;
3824:
3825: -- cursor to get the price index of the asset
3826: Cursor get_price_index(c_category_id number) is
3827: SELECT price_index_id

Line 3828: FROM igi_iac_category_books

3824:
3825: -- cursor to get the price index of the asset
3826: Cursor get_price_index(c_category_id number) is
3827: SELECT price_index_id
3828: FROM igi_iac_category_books
3829: WHERE book_type_code = l_asset_hdr_rec.book_type_code
3830: AND category_id = c_category_id;
3831:
3832: