APPS.JL_CO_FA_PURGE_PKG dependencies on FA_BOOK_CONTROLS

Line 65: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;

61: p_book VARCHAR2,
62: p_fiscal_year number,
63: p_option varchar2) IS
64:
65: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
66: x_initial_period_counter fa_book_controls.initial_period_counter%TYPE;
67: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
68: x_deprn_status fa_book_controls.deprn_status%TYPE;
69: x_book_class fa_book_controls.book_class%TYPE;

Line 66: x_initial_period_counter fa_book_controls.initial_period_counter%TYPE;

62: p_fiscal_year number,
63: p_option varchar2) IS
64:
65: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
66: x_initial_period_counter fa_book_controls.initial_period_counter%TYPE;
67: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
68: x_deprn_status fa_book_controls.deprn_status%TYPE;
69: x_book_class fa_book_controls.book_class%TYPE;
70: x_initial_fiscal_year fa_deprn_periods.fiscal_year%TYPE;

Line 67: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;

63: p_option varchar2) IS
64:
65: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
66: x_initial_period_counter fa_book_controls.initial_period_counter%TYPE;
67: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
68: x_deprn_status fa_book_controls.deprn_status%TYPE;
69: x_book_class fa_book_controls.book_class%TYPE;
70: x_initial_fiscal_year fa_deprn_periods.fiscal_year%TYPE;
71: x_count NUMBER;

Line 68: x_deprn_status fa_book_controls.deprn_status%TYPE;

64:
65: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
66: x_initial_period_counter fa_book_controls.initial_period_counter%TYPE;
67: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
68: x_deprn_status fa_book_controls.deprn_status%TYPE;
69: x_book_class fa_book_controls.book_class%TYPE;
70: x_initial_fiscal_year fa_deprn_periods.fiscal_year%TYPE;
71: x_count NUMBER;
72: x_index NUMBER(7);

Line 69: x_book_class fa_book_controls.book_class%TYPE;

65: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
66: x_initial_period_counter fa_book_controls.initial_period_counter%TYPE;
67: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
68: x_deprn_status fa_book_controls.deprn_status%TYPE;
69: x_book_class fa_book_controls.book_class%TYPE;
70: x_initial_fiscal_year fa_deprn_periods.fiscal_year%TYPE;
71: x_count NUMBER;
72: x_index NUMBER(7);
73: x_period_number fa_calendar_types.number_per_fiscal_year%TYPE;

Line 128: -- get informaton from fa_book_controls --

124:
125: find_who_columns;
126:
127: ---------------------------------------------------------
128: -- get informaton from fa_book_controls --
129: ---------------------------------------------------------
130:
131: SELECT deprn_calendar,
132: initial_period_counter,

Line 141: FROM fa_book_controls

137: x_initial_period_counter,
138: x_current_fiscal_year,
139: x_deprn_status,
140: x_book_class
141: FROM fa_book_controls
142: WHERE book_type_code = p_book;
143:
144: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
145: fnd_file.put_line( 1, 'Deprn calendar :'||x_deprn_calendar);

Line 162: -- fa_book_controls --

158:
159: ---------------------------------------------------------
160: -- Stop the program if input parameter p_fiscal_year --
161: -- is greater than equal to current_fiscal_year in --
162: -- fa_book_controls --
163: ---------------------------------------------------------
164:
165: IF p_fiscal_year >= x_current_fiscal_year THEN
166: RAISE INVALID_FISCAL_YEAR;