193:
194: end if;
195:
196: select count(*) into h_count
197: from fa_book_controls
198: where book_Type_code = argument1 and rownum < 2;
199:
200: if h_count = 0 then
201: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
238: end if;
239:
240: h_count := 0;
241: select count(*) into h_count
242: from fa_book_controls bc, fa_calendar_periods cp
243: where bc.book_type_code = argument1
244: and bc.deprn_calendar = cp.calendar_type
245: and cp.period_name = argument2 and rownum < 2;
246:
272:
273: -- Make sure calendar is defined for duration of projection.
274:
275: select count(*) into h_count
276: from fa_book_controls bc, fa_calendar_types ct,
277: fa_calendar_periods cp
278: where bc.book_type_code = argument1
279: and bc.deprn_calendar = ct.calendar_type
280: and ct.calendar_type = cp.calendar_type