APPS.HR_TEMPLATE_ITEM_CONTEXT_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_item_contexts t_template_item_contexts := t_template_item_contexts();
9: --
10: g_form_template_id_pst hr_form_templates_b.form_template_id%TYPE;
11: g_template_item_contexts_pst t_template_item_contexts_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_item_contexts t_template_item_contexts := t_template_item_contexts();
9: --
10: g_form_template_id_pst hr_form_templates_b.form_template_id%TYPE;
11: g_template_item_contexts_pst t_template_item_contexts_pst;
12: g_index_number_pst NUMBER;
13: g_null_template_item_contexts t_template_item_contexts_pst;
14: --

Line 18: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

14: --
15: -- Global cursors
16: --
17: CURSOR csr_template_item_contexts
18: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
19: )
20: IS
21: SELECT tic.template_item_context_id
22: ,tic.template_item_id

Line 159: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

155: -- -----------------------------------------------------------------------------
156: -- |-------------------------< template_item_contexts >------------------------|
157: -- -----------------------------------------------------------------------------
158: FUNCTION template_item_contexts
159: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
160: )
161: RETURN t_template_item_contexts
162: IS
163: --

Line 188: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

184: -- -----------------------------------------------------------------------------
185: -- |-----------------------< template_item_contexts_pst >----------------------|
186: -- -----------------------------------------------------------------------------
187: FUNCTION template_item_contexts_pst
188: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
189: )
190: RETURN t_template_item_contexts_pst
191: IS
192: --