APPS.HR_TEMPLATE_WINDOWS_API dependencies on HR_TEMPLATE_CANVASES

Line 34: FROM hr_template_canvases tcn

30:
31: CURSOR cur_tmplt_canvas
32: IS
33: SELECT tcn.template_canvas_id
34: FROM hr_template_canvases tcn
35: WHERE tcn.template_window_id = p_template_window_id_from;
36:
37: l_temp number;
38:

Line 138: hr_template_canvases_api.copy_template_canvas(

134: hr_utility.set_location('At:'|| l_proc, 35);
135:
136: FOR cur_rec in cur_tmplt_canvas LOOP
137:
138: hr_template_canvases_api.copy_template_canvas(
139: p_effective_date => TRUNC(p_effective_date)
140: ,p_language_code => l_language_code
141: ,p_template_canvas_id_from => cur_rec.template_canvas_id
142: ,p_template_window_id => l_template_window_id_to

Line 266: -- ,hr_template_canvases_b htc

262: SELECT 1 from dual where exists( --added line for 2832106, removed unnecessary joins
263: SELECT source_form_template_id
264: FROM hr_source_form_templates hsf
265: -- ,hr_template_windows_b htw
266: -- ,hr_template_canvases_b htc
267: -- ,hr_template_tab_pages_b http
268: WHERE hsf.form_template_id_to = p_form_template_id);
269:
270: CURSOR csr_form_canvases

Line 438: hr_template_canvases_api.create_template_canvas

434: -- Create content canvases
435: --
436: FOR l_form_canvas IN csr_form_canvases(p_form_window_id)
437: LOOP
438: hr_template_canvases_api.create_template_canvas
439: (p_effective_date => TRUNC(p_effective_date)
440: ,p_template_window_id => l_template_window_id
441: ,p_form_canvas_id => l_form_canvas.form_canvas_id
442: ,p_height => p_height

Line 562: FROM hr_template_canvases_b tcn

558: CURSOR csr_template_canvases
559: IS
560: SELECT tcn.template_canvas_id
561: ,tcn.object_version_number
562: FROM hr_template_canvases_b tcn
563: ,hr_form_canvases_b fcn
564: WHERE tcn.template_window_id = p_template_window_id
565: AND tcn.form_canvas_id = fcn.form_canvas_id
566: AND fcn.canvas_type = 'CONTENT';

Line 572: FROM hr_template_canvases

568: CURSOR cur_tmplt_canvas
569: IS
570: SELECT template_canvas_id
571: ,object_version_number
572: FROM hr_template_canvases
573: WHERE template_window_id = p_template_window_id;
574:
575: l_temp number;
576:

Line 641: hr_template_canvases_api.delete_template_canvas

637: -- Delete content canvases
638: --
639: FOR l_template_canvas IN csr_template_canvases
640: LOOP
641: hr_template_canvases_api.delete_template_canvas
642: (p_template_canvas_id => l_template_canvas.template_canvas_id
643: ,p_object_version_number => l_template_canvas.object_version_number
644: ,p_delete_children_flag => p_delete_children_flag
645: );

Line 650: hr_template_canvases_api.delete_template_canvas(

646: END LOOP;
647: --
648: IF p_delete_children_flag = 'Y' THEN
649: FOR cur_rec IN cur_tmplt_canvas LOOP
650: hr_template_canvases_api.delete_template_canvas(
651: p_template_canvas_id => cur_rec.template_canvas_id
652: ,p_object_version_number => cur_rec.object_version_number
653: ,p_delete_children_flag => p_delete_children_flag);
654: END LOOP;

Line 772: ,hr_template_canvases tcn

768: ,twn.height
769: ,twn.width
770: FROM hr_template_windows twn
771: ,hr_form_canvases fcn
772: ,hr_template_canvases tcn
773: WHERE twn.template_window_id = p_template_window_id
774: AND fcn.canvas_type = 'CONTENT'
775: AND fcn.form_canvas_id = tcn.form_canvas_id
776: AND tcn.template_window_id = p_template_window_id;

Line 786: -- ,hr_template_canvases_b htc

782: SELECT 1 from dual where exists( --added line for 2832106, removed unnecessary joins
783: SELECT source_form_template_id
784: FROM hr_source_form_templates hsf
785: ,hr_template_windows_b htw
786: -- ,hr_template_canvases_b htc
787: -- ,hr_template_tab_pages_b http
788: WHERE hsf.form_template_id_to = htw.form_template_id
789: AND htw.template_window_id = p_template_window_id);
790:

Line 941: hr_template_canvases_api.update_template_canvas(

937: hr_utility.set_location('At:'|| l_proc, 30);
938:
939: FOR cur_rec IN cur_tmplt_canvas LOOP
940:
941: hr_template_canvases_api.update_template_canvas(
942: p_effective_date => TRUNC(p_effective_date)
943: ,p_template_canvas_id => cur_rec.template_canvas_id
944: ,p_height => cur_rec.height
945: ,p_width => cur_rec.width