DBA Data[Home] [Help]

APPS.HR_TEMPLATE_CANVASES_API dependencies on HR_TEMPLATE_WINDOWS

Line 42: ,hr_template_windows_b htw

38: CURSOR cur_api_val
39: IS
40: SELECT source_form_template_id
41: FROM hr_source_form_templates hsf
42: ,hr_template_windows_b htw
43: WHERE hsf.form_template_id_to = htw.form_template_id
44: AND htw.template_window_id = p_template_window_id;
45:
46: l_template_tab_page_id_to number;

Line 273: FROM hr_template_windows twn

269: CURSOR cur_tmplt_window
270: IS
271: SELECT DECODE(p_height,hr_api.g_number,twn.height,p_height)
272: ,DECODE(p_width,hr_api.g_number,twn.width,p_width)
273: FROM hr_template_windows twn
274: WHERE twn.template_window_id = p_template_window_id;
275:
276: l_temp number;
277:

Line 282: ,hr_template_windows_b htw

278: CURSOR cur_api_val
279: IS
280: SELECT source_form_template_id
281: FROM hr_source_form_templates hsf
282: ,hr_template_windows_b htw
283: WHERE hsf.form_template_id_to = htw.form_template_id
284: AND htw.template_window_id = p_template_window_id;
285:
286: l_canvas_property_id number;

Line 287: l_height hr_template_windows.height%TYPE;

283: WHERE hsf.form_template_id_to = htw.form_template_id
284: AND htw.template_window_id = p_template_window_id;
285:
286: l_canvas_property_id number;
287: l_height hr_template_windows.height%TYPE;
288: l_width hr_template_windows.width%TYPE;
289: l_canvas_type hr_form_canvases.canvas_type%TYPE;
290: l_proc varchar2(72) := g_package||'create_template_canvas';
291: l_template_canvas_id number;

Line 288: l_width hr_template_windows.width%TYPE;

284: AND htw.template_window_id = p_template_window_id;
285:
286: l_canvas_property_id number;
287: l_height hr_template_windows.height%TYPE;
288: l_width hr_template_windows.width%TYPE;
289: l_canvas_type hr_form_canvases.canvas_type%TYPE;
290: l_proc varchar2(72) := g_package||'create_template_canvas';
291: l_template_canvas_id number;
292: l_object_version_number number;

Line 569: ,hr_template_windows_b htw

565: IS
566: SELECT source_form_template_id
567: FROM hr_source_form_templates hsf
568: ,hr_template_canvases_b htc
569: ,hr_template_windows_b htw
570: WHERE hsf.form_template_id_to = htw.form_template_id
571: AND htw.template_window_id = htc.template_window_id
572: AND htc.template_canvas_id = p_template_canvas_id;
573:

Line 754: ,hr_template_windows_b htw

750: IS
751: SELECT source_form_template_id
752: FROM hr_source_form_templates hsf
753: ,hr_template_canvases_b htc
754: ,hr_template_windows_b htw
755: WHERE hsf.form_template_id_to = htw.form_template_id
756: AND htw.template_window_id = htc.template_window_id
757: AND htc.template_canvas_id = p_template_canvas_id;
758: