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