1 PACKAGE hr_template_stack_canvas_info
2 /* $Header: hrtscinf.pkh 120.0 2005/05/31 03:31:34 appldev noship $ */
3 AS
4 --
5 -- Global types
6 --
7 TYPE t_template_stack_canvas IS RECORD
8 (template_stack_canvas_id hr_form_tab_stacked_canvases.form_tab_stacked_canvas_id%TYPE
9 ,canvas_name hr_form_canvases_b.canvas_name%TYPE
10 ,tab_page_name hr_form_tab_pages_b.tab_page_name%TYPE
11 ,stack_canvas_name hr_form_canvases_b.canvas_name%TYPE
12 );
13 TYPE t_template_stack_canvases IS TABLE OF t_template_stack_canvas;
14 TYPE t_template_stack_canvases_pst IS TABLE OF t_template_stack_canvas INDEX BY BINARY_INTEGER;
15 --
16 -- -----------------------------------------------------------------------------
17 -- |------------------------< template_stack_canvases >------------------------|
18 -- -----------------------------------------------------------------------------
19 -- {Start of Comments}
20 --
21 -- Description
22 -- This function returns a table containing the details of all stacked
23 -- canvases for a template.
24 --
25 -- Prerequisites
26 -- None.
27 --
28 -- In Parameters
29 -- p_form_template_id Y number Form template identifier
30 --
31 -- Post Success
32 -- A table containing the details of the template stacked canvases is
33 -- returned
34 --
35 -- Post Failure
36 -- An error is raised
37 --
38 -- Access Status
39 -- Internal Development Use Only
40 --
41 -- {End of Comments}
42 -- -----------------------------------------------------------------------------
43 FUNCTION template_stack_canvases
44 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
45 )
46 RETURN t_template_stack_canvases;
47 --
48 -- -----------------------------------------------------------------------------
49 -- |----------------------< template_stack_canvases_pst >----------------------|
50 -- -----------------------------------------------------------------------------
51 -- {Start of Comments}
52 --
53 -- Description
54 -- This function returns a table containing the details of all stacked
55 -- canvases for a template. A PL/SQL table is returned so it may be correctly
56 -- retrieved by procedures within a Forms Application. Forms 6 cannot retrieve
57 -- nested tables from server-side packages.
58 --
59 -- Prerequisites
60 -- None.
61 --
62 -- In Parameters
63 -- p_form_template_id Y number Form template identifier
64 --
65 -- Post Success
66 -- A table containing the details of the template stacked canvases is
67 -- returned
68 --
69 -- Post Failure
70 -- An error is raised
71 --
72 -- Access Status
73 -- Internal Development Use Only
74 --
75 -- {End of Comments}
76 -- -----------------------------------------------------------------------------
77 FUNCTION template_stack_canvases_pst
78 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
79 )
80 RETURN t_template_stack_canvases_pst;
81 --
82 END hr_template_stack_canvas_info;