APPS.HR_TEMPLATE_CANVAS_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_canvases t_template_canvases := t_template_canvases();
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_canvases
13: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
14: ,p_form_canvas_id IN hr_form_canvases_b.form_canvas_id%TYPE
15: )
16: IS
17: SELECT tcn.template_canvas_id

Line 74: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

70: -- -----------------------------------------------------------------------------
71: -- |---------------------------< template_canvases >---------------------------|
72: -- -----------------------------------------------------------------------------
73: FUNCTION template_canvases
74: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
75: )
76: RETURN t_template_canvases
77: IS
78: --

Line 144: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE

140: -- -----------------------------------------------------------------------------
141: -- |-------------------------< template_canvases_pst >-------------------------|
142: -- -----------------------------------------------------------------------------
143: FUNCTION template_canvases_pst
144: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
145: )
146: RETURN t_template_canvases_pst
147: IS
148: --