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 FA_CATEGORIES

Line 86: l_old_cap_flag fa_categories.capitalize_flag%type;

82: RETURN boolean is
83: l_return_value boolean;
84: l_original_category_id number;
85: l_new_category_id number;
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;

Line 87: l_old_cat_type fa_categories.category_type%type;

83: l_return_value boolean;
84: l_original_category_id number;
85: l_new_category_id number;
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;

Line 88: l_new_cap_flag fa_categories.capitalize_flag%type;

84: l_original_category_id number;
85: l_new_category_id number;
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;

Line 89: l_new_cat_type fa_categories.category_type%type;

85: l_new_category_id number;
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;

Line 107: FROM fa_categories

103:
104: --cursor to get the category capitalized
105: Cursor get_cat_cap_flag(c_category_id Number) is
106: SELECT capitalize_flag,category_type
107: FROM fa_categories
108: WHERE category_id = c_category_id;
109:
110:
111: BEGIN