3: AS
4: --
5: -- Global variables
6: --
7: g_form_template_id hr_form_templates_b.form_template_id%TYPE;
8: g_template_windows t_template_windows := t_template_windows();
9: --
10: -- Global cursors
11: --
9: --
10: -- Global cursors
11: --
12: CURSOR csr_template_windows
13: (p_application_id IN hr_form_templates_b.application_id%TYPE
14: ,p_form_id IN hr_form_templates_b.form_id%TYPE
15: ,p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
16: )
17: IS
10: -- Global cursors
11: --
12: CURSOR csr_template_windows
13: (p_application_id IN hr_form_templates_b.application_id%TYPE
14: ,p_form_id IN hr_form_templates_b.form_id%TYPE
15: ,p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
16: )
17: IS
18: SELECT twn.template_window_id
11: --
12: CURSOR csr_template_windows
13: (p_application_id IN hr_form_templates_b.application_id%TYPE
14: ,p_form_id IN hr_form_templates_b.form_id%TYPE
15: ,p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
16: )
17: IS
18: SELECT twn.template_window_id
19: ,fwn.window_name
68: -- -----------------------------------------------------------------------------
69: -- |----------------------------< template_windows >---------------------------|
70: -- -----------------------------------------------------------------------------
71: FUNCTION template_windows
72: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
73: )
74: RETURN t_template_windows
75: IS
76: --
116: -- -----------------------------------------------------------------------------
117: -- |--------------------------< template_windows_pst >-------------------------|
118: -- -----------------------------------------------------------------------------
119: FUNCTION template_windows_pst
120: (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
121: )
122: RETURN t_template_windows_pst
123: IS
124: --