1: Package Body hr_template_windows_api as
2: /* $Header: hrtwuapi.pkb 115.5 2003/03/06 17:15:52 adhunter noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: hrtwuapi.pkb 115.5 2003/03/06 17:15:52 adhunter noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_template_windows_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< copy_template_window >--------------------------|
10: -- ----------------------------------------------------------------------------
24:
25: CURSOR cur_form_window
26: IS
27: SELECT twn.form_window_id
28: FROM hr_template_windows twn
29: WHERE twn.template_window_id = p_template_window_id_from;
30:
31: CURSOR cur_tmplt_canvas
32: IS
75: --
76: -- Call Before Process User Hook
77: --
78: begin
79: hr_template_windows_api_bk1.copy_template_window_b
80: (p_effective_date => TRUNC(p_effective_date)
81: ,p_language_code => l_language_code
82: ,p_template_window_id_from => p_template_window_id_from
83: ,p_form_template_id => p_form_template_id);
148: --
149: hr_utility.set_location('At:'|| l_proc, 40);
150:
151: begin
152: hr_template_windows_api_bk1.copy_template_window_a
153: (p_effective_date => TRUNC(p_effective_date)
154: ,p_language_code => l_language_code
155: ,p_template_window_id_from => p_template_window_id_from
156: ,p_form_template_id => p_form_template_id
261: IS
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:
307: --
308: -- Call Before Process User Hook
309: --
310: begin
311: hr_template_windows_api_bk2.create_template_window_b
312: (p_effective_date => TRUNC(p_effective_date)
313: ,p_language_code => l_language_code
314: ,p_form_template_id => p_form_template_id
315: ,p_form_window_id => p_form_window_id
450: --
451: hr_utility.set_location('At:'|| l_proc, 30);
452:
453: begin
454: hr_template_windows_api_bk2.create_template_window_a
455: (p_effective_date => TRUNC(p_effective_date)
456: ,p_language_code => l_language_code
457: ,p_form_template_id => p_form_template_id
458: ,p_form_window_id => p_form_window_id
578: IS
579: SELECT 1 from dual where exists( --added line for 2832106
580: SELECT source_form_template_id
581: FROM hr_source_form_templates hsf
582: ,hr_template_windows_b htw
583: WHERE hsf.form_template_id_to = htw.form_template_id
584: AND htw.template_window_id = p_template_window_id);
585:
586: l_proc varchar2(72) := g_package||'delete_template_window';
593: --
594: -- Call Before Process User Hook
595: --
596: begin
597: hr_template_windows_api_bk3.delete_template_window_b
598: (p_template_window_id => p_template_window_id
599: ,p_object_version_number => p_object_version_number
600: ,p_delete_children_flag => p_delete_children_flag);
601: exception
668: --
669: -- Call After Process User Hook
670: --
671: begin
672: hr_template_windows_api_bk3.delete_template_window_a
673: (p_template_window_id => p_template_window_id
674: ,p_object_version_number => p_object_version_number
675: ,p_delete_children_flag => p_delete_children_flag);
676: exception
766: SELECT tcn.template_canvas_id
767: ,tcn.object_version_number
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'
781: IS
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);
816: --
817: -- Call Before Process User Hook
818: --
819: begin
820: hr_template_windows_api_bk4.update_template_window_b
821: (p_effective_date => TRUNC(p_effective_date)
822: ,p_language_code => l_language_code
823: ,p_template_window_id => p_template_window_id
824: ,p_object_version_number => l_object_version_number
952: --
953: -- Call After Process User Hook
954: --
955: begin
956: hr_template_windows_api_bk4.update_template_window_a
957: (p_effective_date => TRUNC(p_effective_date)
958: ,p_language_code => l_language_code
959: ,p_template_window_id => p_template_window_id
960: ,p_object_version_number => l_object_version_number
1034: hr_utility.set_location(' Leaving:'||l_proc, 90);
1035: raise;
1036: end update_template_window;
1037: --
1038: end hr_template_windows_api;