DBA Data[Home] [Help]

APPS.HR_TEMPLATE_TAB_PAGES_API dependencies on HR_TEMPLATE_TAB_PAGES

Line 1: Package Body hr_template_tab_pages_api as

1: Package Body hr_template_tab_pages_api as
2: /* $Header: hrttpapi.pkb 115.6 2003/10/31 06:54:48 bsubrama noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: hrttpapi.pkb 115.6 2003/10/31 06:54:48 bsubrama noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_template_tab_pages_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< copy_template_tab_page >----------------------|
10: -- ----------------------------------------------------------------------------

Line 29: FROM hr_template_tab_pages ttp

25:
26: CURSOR cur_form_tab
27: IS
28: SELECT ttp.form_tab_page_id
29: FROM hr_template_tab_pages ttp
30: WHERE ttp.template_tab_page_id = p_template_tab_page_id_from;
31:
32: l_temp number;
33:

Line 76: hr_template_tab_pages_api_bk1.copy_template_tab_page_b

72: --
73: -- Call Before Process User Hook
74: --
75: begin
76: hr_template_tab_pages_api_bk1.copy_template_tab_page_b
77: (p_effective_date => TRUNC(p_effective_date)
78: ,p_language_code => l_language_code
79: ,p_template_tab_page_id_from => p_template_tab_page_id_from
80: ,p_template_canvas_id => p_template_canvas_id

Line 140: hr_template_tab_pages_api_bk1.copy_template_tab_page_a

136: --
137: hr_utility.set_location('At:'|| l_proc, 35);
138:
139: begin
140: hr_template_tab_pages_api_bk1.copy_template_tab_page_a
141: (p_effective_date => TRUNC(p_effective_date)
142: ,p_language_code => l_language_code
143: ,p_template_tab_page_id_from => p_template_tab_page_id_from
144: ,p_template_canvas_id => p_template_canvas_id

Line 303: hr_template_tab_pages_api_bk2.create_template_tab_page_b

299: --
300: -- Call Before Process User Hook
301: --
302: begin
303: hr_template_tab_pages_api_bk2.create_template_tab_page_b
304: (p_effective_date => TRUNC(p_effective_date)
305: ,p_language_code => l_language_code
306: ,p_template_canvas_id => p_template_canvas_id
307: ,p_form_tab_page_id => p_form_tab_page_id

Line 441: hr_template_tab_pages_api_bk2.create_template_tab_page_a

437: --
438: -- Call After Process User Hook
439: --
440: begin
441: hr_template_tab_pages_api_bk2.create_template_tab_page_a
442: (p_effective_date => TRUNC(p_effective_date)
443: ,p_language_code => l_language_code
444: ,p_template_canvas_id => p_template_canvas_id
445: ,p_form_tab_page_id => p_form_tab_page_id

Line 570: ,hr_template_tab_pages_b http

566: SELECT source_form_template_id
567: FROM hr_source_form_templates hsf
568: ,hr_template_windows_b htw
569: ,hr_template_canvases_b htc
570: ,hr_template_tab_pages_b http
571: WHERE hsf.form_template_id_to = htw.form_template_id
572: AND htw.template_window_id = htc.template_window_id
573: AND htc.template_canvas_id = http.template_canvas_id
574: AND http.template_tab_page_id = p_template_tab_page_id;

Line 587: hr_template_tab_pages_api_bk3.delete_template_tab_page_b

583: --
584: -- Call Before Process User Hook
585: --
586: begin
587: hr_template_tab_pages_api_bk3.delete_template_tab_page_b
588: (p_template_tab_page_id => p_template_tab_page_id
589: ,p_object_version_number => p_object_version_number
590: ,p_delete_children_flag => p_delete_children_flag
591: );

Line 658: hr_template_tab_pages_api_bk3.delete_template_tab_page_a

654: --
655: hr_utility.set_location('At:'|| l_proc, 50);
656:
657: begin
658: hr_template_tab_pages_api_bk3.delete_template_tab_page_a
659: (p_template_tab_page_id => p_template_tab_page_id
660: ,p_object_version_number => p_object_version_number
661: ,p_delete_children_flag => p_delete_children_flag
662: );

Line 754: , hr_template_tab_pages_b ttp

750: CURSOR cur_override
751: IS
752: SELECT visible_override
753: FROM hr_form_tab_pages_b ftp
754: , hr_template_tab_pages_b ttp
755: WHERE ftp.form_tab_page_id = ttp.form_tab_page_id
756: AND ttp.template_tab_page_id = p_template_tab_page_id;
757:
758: l_visible_override number;

Line 768: ,hr_template_tab_pages_b http

764: SELECT source_form_template_id
765: FROM hr_source_form_templates hsf
766: ,hr_template_windows_b htw
767: ,hr_template_canvases_b htc
768: ,hr_template_tab_pages_b http
769: WHERE hsf.form_template_id_to = htw.form_template_id
770: AND htw.template_window_id = htc.template_window_id
771: AND htc.template_canvas_id = http.template_canvas_id
772: AND http.template_tab_page_id = p_template_tab_page_id;

Line 805: hr_template_tab_pages_api_bk4.update_template_tab_page_b

801: --
802: -- Call Before Process User Hook
803: --
804: begin
805: hr_template_tab_pages_api_bk4.update_template_tab_page_b
806: (p_effective_date => TRUNC(p_effective_date)
807: ,p_language_code => l_language_code
808: ,p_template_tab_page_id => p_template_tab_page_id
809: ,p_object_version_number => l_object_version_number

Line 934: hr_template_tab_pages_api_bk4.update_template_tab_page_a

930: --
931: -- Call After Process User Hook
932: --
933: begin
934: hr_template_tab_pages_api_bk4.update_template_tab_page_a
935: (p_effective_date => TRUNC(p_effective_date)
936: ,p_language_code => l_language_code
937: ,p_template_tab_page_id => p_template_tab_page_id
938: ,p_object_version_number => l_object_version_number

Line 1018: end hr_template_tab_pages_api;

1014: hr_utility.set_location(' Leaving:'||l_proc, 90);
1015: raise;
1016: end update_template_tab_page;
1017: --
1018: end hr_template_tab_pages_api;