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 63: l_old_cap_flag fa_categories.capitalize_flag%type;

59: RETURN boolean is
60: l_return_value boolean;
61: l_original_category_id number;
62: l_new_category_id number;
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;

Line 64: l_old_cat_type fa_categories.category_type%type;

60: l_return_value boolean;
61: l_original_category_id number;
62: l_new_category_id number;
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;

Line 65: l_new_cap_flag fa_categories.capitalize_flag%type;

61: l_original_category_id number;
62: l_new_category_id number;
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;

Line 66: l_new_cat_type fa_categories.category_type%type;

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

Line 84: FROM fa_categories

80:
81: --cursor to get the category capitalized
82: Cursor get_cat_cap_flag(c_category_id Number) is
83: SELECT capitalize_flag,category_type
84: FROM fa_categories
85: WHERE category_id = c_category_id;
86:
87:
88: BEGIN