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 90: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;

86: l_old_cap_flag fa_categories.capitalize_flag%type;
87: l_old_cat_type fa_categories.category_type%type;
88: l_new_cap_flag fa_categories.capitalize_flag%type;
89: l_new_cat_type fa_categories.category_type%type;
90: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
91: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
92: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
93: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
94: l_path_name VARCHAR2(150);

Line 91: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;

87: l_old_cat_type fa_categories.category_type%type;
88: l_new_cap_flag fa_categories.capitalize_flag%type;
89: l_new_cat_type fa_categories.category_type%type;
90: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
91: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
92: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
93: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
94: l_path_name VARCHAR2(150);
95:

Line 92: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;

88: l_new_cap_flag fa_categories.capitalize_flag%type;
89: l_new_cat_type fa_categories.category_type%type;
90: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
91: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
92: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
93: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
94: l_path_name VARCHAR2(150);
95:
96:

Line 93: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;

89: l_new_cat_type fa_categories.category_type%type;
90: l_old_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
91: l_old_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
92: l_new_index_reval_flag igi_iac_category_books.allow_indexed_reval_flag%Type;
93: l_new_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%Type;
94: l_path_name VARCHAR2(150);
95:
96:
97: -- cursor to validate category linked to iac book

Line 100: FROM igi_iac_category_books

96:
97: -- cursor to validate category linked to iac book
98: Cursor get_category_id(c_category_id Number)is
99: SELECT category_id,allow_indexed_reval_flag,allow_prof_reval_flag
100: FROM igi_iac_category_books
101: WHERE book_type_code = l_asset_hdr_rec.book_type_code
102: AND category_id = c_category_id;
103:
104: --cursor to get the category capitalized

Line 2981: FROM igi_iac_category_books

2977: ) return BOOLEAN IS
2978:
2979: CURSOR c_allow_indexed_reval_flag IS
2980: SELECT allow_indexed_reval_flag
2981: FROM igi_iac_category_books
2982: WHERE book_type_code = p_book_type_code
2983: AND category_id = p_category_id;
2984:
2985: CURSOR c_period_num_for_catchup IS

Line 3016: l_allow_indexed_reval_flag igi_iac_category_books.allow_indexed_reval_flag%TYPE;

3012:
3013: l_dpis_period_counter NUMBER;
3014: l_open_period igi_iac_types.prd_rec;
3015: l_period_info igi_iac_types.prd_rec;
3016: l_allow_indexed_reval_flag igi_iac_category_books.allow_indexed_reval_flag%TYPE;
3017: l_period_num_for_catchup igi_iac_book_controls.period_num_for_catchup%TYPE;
3018: l_idx1 BINARY_INTEGER;
3019: l_idx2 BINARY_INTEGER;
3020: l_reval_control igi_iac_types.iac_reval_control_tab;

Line 3855: l_old_price_index igi_iac_category_books.price_index_id%type;

3851: p_calling_function VARCHAR2,
3852: p_event_id number --R12 uptake
3853: ) return BOOLEAN is
3854:
3855: l_old_price_index igi_iac_category_books.price_index_id%type;
3856: l_new_price_index igi_iac_category_books.price_index_id%type;
3857:
3858: -- cursor to get the price index of the asset
3859: Cursor get_price_index(c_category_id number) is

Line 3856: l_new_price_index igi_iac_category_books.price_index_id%type;

3852: p_event_id number --R12 uptake
3853: ) return BOOLEAN is
3854:
3855: l_old_price_index igi_iac_category_books.price_index_id%type;
3856: l_new_price_index igi_iac_category_books.price_index_id%type;
3857:
3858: -- cursor to get the price index of the asset
3859: Cursor get_price_index(c_category_id number) is
3860: SELECT price_index_id

Line 3861: FROM igi_iac_category_books

3857:
3858: -- cursor to get the price index of the asset
3859: Cursor get_price_index(c_category_id number) is
3860: SELECT price_index_id
3861: FROM igi_iac_category_books
3862: WHERE book_type_code = l_asset_hdr_rec.book_type_code
3863: AND category_id = c_category_id;
3864:
3865: