APPS.HR_TEMPLATE_TAB_PAGE_INFO dependencies on HR_FORM_TEMPLATES_B

Line 7: g_form_template_id hr_form_templates_b.form_template_id%TYPE;

3: AS
4: --
5: -- Global variables
6: --
7: g_form_template_id hr_form_templates_b.form_template_id%TYPE;
8: g_template_tab_pages t_template_tab_pages := t_template_tab_pages();
9: --
10: -- Global cursors
11: --

Line 13: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

9: --
10: -- Global cursors
11: --
12: CURSOR csr_template_tab_pages
13: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
14: ,p_form_tab_page_id IN hr_form_tab_pages_b.form_tab_page_id%TYPE
15: )
16: IS
17: SELECT ttp.template_tab_page_id

Line 77: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

73: -- -----------------------------------------------------------------------------
74: -- |---------------------------< template_tab_pages >--------------------------|
75: -- -----------------------------------------------------------------------------
76: FUNCTION template_tab_pages
77: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
78: )
79: RETURN t_template_tab_pages
80: IS
81: --

Line 147: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

143: -- -----------------------------------------------------------------------------
144: -- |-------------------------< template_tab_pages_pst >------------------------|
145: -- -----------------------------------------------------------------------------
146: FUNCTION template_tab_pages_pst
147: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
148: )
149: RETURN t_template_tab_pages_pst
150: IS
151: --