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;
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;
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;
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);
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;
124:
125: find_who_columns;
126:
127: ---------------------------------------------------------
128: -- get informaton from fa_book_controls --
129: ---------------------------------------------------------
130:
131: SELECT deprn_calendar,
132: initial_period_counter,
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);
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;