DBA Data[Home] [Help]

APPS.HR_TEMPLATE_WINDOWS_API dependencies on HR_TEMPLATE_WINDOWS

Line 1: Package Body hr_template_windows_api as

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: --

Line 6: g_package varchar2(33) := ' hr_template_windows_api.';

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: -- ----------------------------------------------------------------------------

Line 28: FROM hr_template_windows twn

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

Line 79: hr_template_windows_api_bk1.copy_template_window_b

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);

Line 152: hr_template_windows_api_bk1.copy_template_window_a

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

Line 265: -- ,hr_template_windows_b htw

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:

Line 311: hr_template_windows_api_bk2.create_template_window_b

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

Line 454: hr_template_windows_api_bk2.create_template_window_a

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

Line 582: ,hr_template_windows_b htw

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';

Line 597: hr_template_windows_api_bk3.delete_template_window_b

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

Line 672: hr_template_windows_api_bk3.delete_template_window_a

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

Line 770: FROM hr_template_windows twn

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'

Line 785: ,hr_template_windows_b htw

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);

Line 820: hr_template_windows_api_bk4.update_template_window_b

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

Line 956: hr_template_windows_api_bk4.update_template_window_a

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

Line 1038: end hr_template_windows_api;

1034: hr_utility.set_location(' Leaving:'||l_proc, 90);
1035: raise;
1036: end update_template_window;
1037: --
1038: end hr_template_windows_api;