[Home] [Help]
PACKAGE: APPS.HR_TEMPLATE_CANVAS_INFO
Source
1 PACKAGE hr_template_canvas_info
2 /* $Header: hrtcninf.pkh 120.0 2005/05/31 02:58:16 appldev noship $ */
3 AS
4 --
5 -- Global types
6 --
7 TYPE t_template_canvas IS RECORD
8 (template_canvas_id hr_template_canvases_b.template_canvas_id%TYPE
9 ,canvas_name hr_form_canvases_b.canvas_name%TYPE
10 ,canvas_type hr_form_canvases_b.canvas_type%TYPE
11 ,window_name hr_form_windows_b.window_name%TYPE
12 ,height hr_canvas_properties.height%TYPE
13 ,visible hr_canvas_properties.visible%TYPE
14 ,width hr_canvas_properties.width%TYPE
15 ,x_position hr_canvas_properties.x_position%TYPE
16 ,y_position hr_canvas_properties.y_position%TYPE
17 ,information_category hr_canvas_properties.information_category%TYPE
18 ,information1 hr_canvas_properties.information1%TYPE
19 ,information2 hr_canvas_properties.information2%TYPE
20 ,information3 hr_canvas_properties.information3%TYPE
21 ,information4 hr_canvas_properties.information4%TYPE
22 ,information5 hr_canvas_properties.information5%TYPE
23 ,information6 hr_canvas_properties.information6%TYPE
24 ,information7 hr_canvas_properties.information7%TYPE
25 ,information8 hr_canvas_properties.information8%TYPE
26 ,information9 hr_canvas_properties.information9%TYPE
27 ,information10 hr_canvas_properties.information10%TYPE
28 ,information11 hr_canvas_properties.information11%TYPE
29 ,information12 hr_canvas_properties.information12%TYPE
30 ,information13 hr_canvas_properties.information13%TYPE
31 ,information14 hr_canvas_properties.information14%TYPE
32 ,information15 hr_canvas_properties.information15%TYPE
33 ,information16 hr_canvas_properties.information16%TYPE
34 ,information17 hr_canvas_properties.information17%TYPE
35 ,information18 hr_canvas_properties.information18%TYPE
36 ,information19 hr_canvas_properties.information19%TYPE
37 ,information20 hr_canvas_properties.information20%TYPE
38 ,information21 hr_canvas_properties.information21%TYPE
39 ,information22 hr_canvas_properties.information22%TYPE
40 ,information23 hr_canvas_properties.information23%TYPE
41 ,information24 hr_canvas_properties.information24%TYPE
42 ,information25 hr_canvas_properties.information25%TYPE
43 ,information26 hr_canvas_properties.information26%TYPE
44 ,information27 hr_canvas_properties.information27%TYPE
45 ,information28 hr_canvas_properties.information28%TYPE
46 ,information29 hr_canvas_properties.information29%TYPE
47 ,information30 hr_canvas_properties.information30%TYPE
48 );
49 TYPE t_template_canvases IS TABLE OF t_template_canvas;
50 TYPE t_template_canvases_pst IS TABLE OF t_template_canvas INDEX BY BINARY_INTEGER;
51 --
52 -- -----------------------------------------------------------------------------
53 -- |---------------------------< template_canvases >---------------------------|
54 -- -----------------------------------------------------------------------------
55 -- {Start of Comments}
56 --
57 -- Description
58 -- This function returns a table containing the details of all canvases for a
59 -- template.
60 --
61 -- Prerequisites
62 -- None.
63 --
64 -- In Parameters
65 -- p_form_template_id Y number Form template identifier
66 --
67 -- Post Success
68 -- A table containing the details of the template canvases is returned
69 --
70 -- Post Failure
71 -- An error is raised
72 --
73 -- Access Status
74 -- Internal Development Use Only
75 --
76 -- {End of Comments}
77 -- -----------------------------------------------------------------------------
78 FUNCTION template_canvases
79 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
80 )
81 RETURN t_template_canvases;
82 --
83 -- -----------------------------------------------------------------------------
84 -- |-------------------------< template_canvases_pst >-------------------------|
85 -- -----------------------------------------------------------------------------
86 -- {Start of Comments}
87 --
88 -- Description
89 -- This function returns a table containing the details of all canvases for a
90 -- template. A PL/SQL table is returned so it may be correctly retrieved by
91 -- procedures within a Forms Application. Forms 6 cannot retrieve nested
92 -- tables from server-side packages.
93 --
94 -- Prerequisites
95 -- None.
96 --
97 -- In Parameters
98 -- p_form_template_id Y number Form template identifier
99 --
100 -- Post Success
101 -- A table containing the details of the template canvases is returned
102 --
103 -- Post Failure
104 -- An error is raised
105 --
106 -- Access Status
107 -- Internal Development Use Only
108 --
109 -- {End of Comments}
110 -- -----------------------------------------------------------------------------
111 FUNCTION template_canvases_pst
112 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
113 )
114 RETURN t_template_canvases_pst;
115 --
116 END hr_template_canvas_info;