195: ) is
196: --
197: cursor csr_form_tab_page is
198: select fcn.form_window_id
199: from hr_form_canvases_b fcn
200: ,hr_form_tab_pages_b ftp
201: where fcn.form_canvas_id = ftp.form_canvas_id
202: and ftp.form_tab_page_id = p_form_tab_page_id;
203: --
203: --
204: cursor csr_form_canvas is
205: select fcn.form_window_id
206: ,fcn.canvas_type
207: from hr_form_canvases_b fcn
208: where fcn.form_canvas_id = p_form_canvas_id;
209: --
210: l_proc varchar2(72) := g_package || 'chk_tab_page_and_canvas';
211: l_api_updating boolean;