APPS.HR_TEMPLATE_ITEM_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_items t_template_items := t_template_items();
9: --
10: g_form_template_id_pst hr_form_templates_b.form_template_id%TYPE;
11: g_template_items_pst t_template_items_pst;

Line 10: g_form_template_id_pst hr_form_templates_b.form_template_id%TYPE;

6: --
7: g_form_template_id hr_form_templates_b.form_template_id%TYPE;
8: g_template_items t_template_items := t_template_items();
9: --
10: g_form_template_id_pst hr_form_templates_b.form_template_id%TYPE;
11: g_template_items_pst t_template_items_pst;
12: g_index_number_pst NUMBER;
13: g_null_template_items_pst t_template_items_pst;
14: --

Line 18: (p_application_id IN hr_form_templates_b.application_id%TYPE

14: --
15: -- Global cursors
16: --
17: CURSOR csr_template_items
18: (p_application_id IN hr_form_templates_b.application_id%TYPE
19: ,p_form_id IN hr_form_templates_b.form_id%TYPE
20: ,p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
21: )
22: IS

Line 19: ,p_form_id IN hr_form_templates_b.form_id%TYPE

15: -- Global cursors
16: --
17: CURSOR csr_template_items
18: (p_application_id IN hr_form_templates_b.application_id%TYPE
19: ,p_form_id IN hr_form_templates_b.form_id%TYPE
20: ,p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
21: )
22: IS
23: SELECT tim.template_item_id

Line 20: ,p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

16: --
17: CURSOR csr_template_items
18: (p_application_id IN hr_form_templates_b.application_id%TYPE
19: ,p_form_id IN hr_form_templates_b.form_id%TYPE
20: ,p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
21: )
22: IS
23: SELECT tim.template_item_id
24: ,fim.full_item_name

Line 124: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

120: -- -----------------------------------------------------------------------------
121: -- |-----------------------------< template_items >----------------------------|
122: -- -----------------------------------------------------------------------------
123: FUNCTION template_items
124: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
125: )
126: RETURN t_template_items
127: IS
128: --

Line 176: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

172: -- -----------------------------------------------------------------------------
173: -- |---------------------------< template_items_pst >--------------------------|
174: -- -----------------------------------------------------------------------------
175: FUNCTION template_items_pst
176: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
177: )
178: RETURN t_template_items_pst
179: IS
180: --