DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEM_TAB_PAGES_API dependencies on HR_TEMPLATE_ITEM_TAB_PAGES

Line 1: Package Body hr_template_item_tab_pages_api as

1: Package Body hr_template_item_tab_pages_api as
2: /* $Header: hrtfpapi.pkb 115.4 2002/12/18 06:15:25 raranjan noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: hrtfpapi.pkb 115.4 2002/12/18 06:15:25 raranjan noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_template_item_tab_pages_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_template_item_tab_page >------------------|
10: -- ----------------------------------------------------------------------------

Line 69: hr_template_item_tab_pages_bk1.create_tip_b

65: --
66: -- Call Before Process User Hook
67: --
68: begin
69: hr_template_item_tab_pages_bk1.create_tip_b
70: (p_effective_date => TRUNC(p_effective_date)
71: ,p_template_item_id => p_template_item_id
72: ,p_template_tab_page_id => p_template_tab_page_id
73: ,p_upd_template_item_contexts => p_upd_template_item_contexts

Line 132: hr_template_item_tab_pages_bk1.create_tip_a

128: --
129: hr_utility.set_location('At:'|| l_proc, 25);
130:
131: begin
132: hr_template_item_tab_pages_bk1.create_tip_a
133: (p_effective_date => TRUNC(p_effective_date)
134: ,p_template_item_id => p_template_item_id
135: ,p_template_tab_page_id => p_template_tab_page_id
136: ,p_upd_template_item_contexts => p_upd_template_item_contexts

Line 207: ,hr_template_item_tab_pages htit

203: IS
204: SELECT source_form_template_id
205: FROM hr_source_form_templates hsf
206: ,hr_template_items_b hti
207: ,hr_template_item_tab_pages htit
208: WHERE hsf.form_template_id_to = hti.form_template_id
209: AND hti.template_item_id = htit.template_item_id
210: AND htit.template_item_tab_page_id = p_template_item_tab_page_id;
211:

Line 220: ,hr_template_item_tab_pages tip

216: SELECT tcp.template_item_context_page_id
217: ,tcp.object_version_number
218: FROM hr_template_item_context_pages tcp
219: ,hr_template_item_contexts_b tic
220: ,hr_template_item_tab_pages tip
221: WHERE tcp.template_tab_page_id = tip.template_tab_page_id
222: AND tcp.template_item_context_id = tic.template_item_context_id
223: AND tic.template_item_id = tip.template_item_id
224: AND tip.template_item_tab_page_id = p_template_item_tab_page_id;

Line 239: hr_template_item_tab_pages_bk2.delete_tip_b

235: --
236: -- Call Before Process User Hook
237: --
238: begin
239: hr_template_item_tab_pages_bk2.delete_tip_b
240: (p_template_item_tab_page_id => p_template_item_tab_page_id
241: ,p_object_version_number => p_object_version_number
242: ,p_upd_template_item_contexts => p_upd_template_item_contexts
243: );

Line 296: hr_template_item_tab_pages_bk2.delete_tip_a

292: --
293: -- Call After Process User Hook
294: --
295: begin
296: hr_template_item_tab_pages_bk2.delete_tip_a
297: (p_template_item_tab_page_id => p_template_item_tab_page_id
298: ,p_object_version_number => p_object_version_number
299: ,p_upd_template_item_contexts => p_upd_template_item_contexts
300: );

Line 338: end hr_template_item_tab_pages_api;

334: hr_utility.set_location(' Leaving:'||l_proc, 90);
335: raise;
336: end delete_template_item_tab_page;
337: --
338: end hr_template_item_tab_pages_api;