1 PACKAGE hr_form_template_info
2 /* $Header: hrtmpinf.pkh 120.0 2005/05/31 03:21:30 appldev noship $ */
3 AUTHID CURRENT_USER AS
4 --
5 -- Global types
6 --
7 TYPE t_form_template IS RECORD
8 (form_template_id hr_form_templates_b.form_template_id%TYPE
9 ,application_id hr_form_templates_b.application_id%TYPE
10 ,form_id hr_form_templates_b.form_id%TYPE
11 ,template_name hr_form_templates_b.template_name%TYPE
12 ,legislation_code hr_form_templates_b.legislation_code%TYPE
13 ,enabled_flag hr_form_templates_b.enabled_flag%TYPE
14 ,help_target hr_form_properties.help_target%TYPE
15 ,information_category hr_form_properties.information_category%TYPE
16 ,information1 hr_form_properties.information1%TYPE
17 ,information2 hr_form_properties.information2%TYPE
18 ,information3 hr_form_properties.information3%TYPE
19 ,information4 hr_form_properties.information4%TYPE
20 ,information5 hr_form_properties.information5%TYPE
21 ,information6 hr_form_properties.information6%TYPE
22 ,information7 hr_form_properties.information7%TYPE
23 ,information8 hr_form_properties.information8%TYPE
24 ,information9 hr_form_properties.information9%TYPE
25 ,information10 hr_form_properties.information10%TYPE
26 ,information11 hr_form_properties.information11%TYPE
27 ,information12 hr_form_properties.information12%TYPE
28 ,information13 hr_form_properties.information13%TYPE
29 ,information14 hr_form_properties.information14%TYPE
30 ,information15 hr_form_properties.information15%TYPE
31 ,information16 hr_form_properties.information16%TYPE
32 ,information17 hr_form_properties.information17%TYPE
33 ,information18 hr_form_properties.information18%TYPE
34 ,information19 hr_form_properties.information19%TYPE
35 ,information20 hr_form_properties.information20%TYPE
36 ,information21 hr_form_properties.information21%TYPE
37 ,information22 hr_form_properties.information22%TYPE
38 ,information23 hr_form_properties.information23%TYPE
39 ,information24 hr_form_properties.information24%TYPE
40 ,information25 hr_form_properties.information25%TYPE
41 ,information26 hr_form_properties.information26%TYPE
42 ,information27 hr_form_properties.information27%TYPE
43 ,information28 hr_form_properties.information28%TYPE
44 ,information29 hr_form_properties.information29%TYPE
45 ,information30 hr_form_properties.information30%TYPE
46 );
47 --
48 -- -----------------------------------------------------------------------------
49 -- |-----------------------------< form_template >-----------------------------|
50 -- -----------------------------------------------------------------------------
51 -- {Start of Comments}
52 --
53 -- Description
54 -- This function returns a record containing the details of the form template.
55 --
56 -- Prerequisites
57 -- None.
58 --
59 -- In Parameters
60 -- p_form_template_id Y number Form template identifier
61 --
62 -- Post Success
63 -- A record containing the details of the form template is returned
64 --
65 -- Post Failure
66 -- An error is raised
67 --
68 -- Access Status
69 -- Internal Development Use Only
70 --
71 -- {End of Comments}
72 -- -----------------------------------------------------------------------------
73 FUNCTION form_template
74 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
75 )
76 RETURN t_form_template;
77 --
78 -- -----------------------------------------------------------------------------
79 -- |-----------------------------< form_template >-----------------------------|
80 -- -----------------------------------------------------------------------------
81 -- {Start of Comments}
82 --
83 -- Description
84 -- This function returns a record containing the details of the form template.
85 --
86 -- Prerequisites
87 -- None.
88 --
89 -- In Parameters
90 -- p_application_id Y number Application identifier
91 -- p_form_id Y number Form identifier
92 -- p_template_name Y varchar2 Template name
93 -- p_legislation_code Y varchar2 Legislation code
94 --
95 -- Post Success
96 -- A record containing the details of the form template is returned
97 --
98 -- Post Failure
99 -- An error is raised
100 --
101 -- Access Status
102 -- Internal Development Use Only
103 --
104 -- {End of Comments}
105 -- -----------------------------------------------------------------------------
106 FUNCTION form_template
107 (p_application_id IN fnd_application.application_id%TYPE
108 ,p_form_id IN fnd_form.form_id%TYPE
109 ,p_template_name IN hr_form_templates_b.template_name%TYPE
110 ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
111 )
112 RETURN t_form_template;
113 --
114 -- -----------------------------------------------------------------------------
115 -- |-----------------------------< form_template >-----------------------------|
116 -- -----------------------------------------------------------------------------
117 -- {Start of Comments}
118 --
119 -- Description
120 -- This function returns a record containing the details of the form template.
121 --
122 -- Prerequisites
123 -- None.
124 --
125 -- In Parameters
126 -- p_function_name Y varchar2 Form function name
127 -- p_template_name Y varchar2 Template name
128 -- p_legislation_code Y varchar2 Legislation code
129 --
130 -- Post Success
131 -- A record containing the details of the form template is returned
132 --
133 -- Post Failure
134 -- An error is raised
135 --
136 -- Access Status
137 -- Internal Development Use Only
138 --
139 -- {End of Comments}
140 -- -----------------------------------------------------------------------------
141 FUNCTION form_template
142 (p_function_name IN fnd_form_functions.function_name%TYPE
143 ,p_template_name IN hr_form_templates_b.template_name%TYPE
144 ,p_legislation_code IN hr_form_templates_b.legislation_code%TYPE
145 )
146 RETURN t_form_template;
147 --
148 -- -----------------------------------------------------------------------------
149 -- |-----------------------------< application_id >----------------------------|
150 -- -----------------------------------------------------------------------------
151 -- {Start of Comments}
152 --
153 -- Description
154 -- This function returns the application identifier for a form template.
155 --
156 -- Prerequisites
157 -- None.
158 --
159 -- In Parameters
160 -- p_form_template_id Y number Form template identifier
161 --
162 -- Post Success
163 -- The application identifier associated with the form template is returned.
164 --
165 -- Post Failure
166 -- An error is raised
167 --
168 -- Access Status
169 -- Internal Development Use Only
170 --
171 -- {End of Comments}
172 -- -----------------------------------------------------------------------------
173 FUNCTION application_id
174 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
175 )
176 RETURN hr_form_templates_b.application_id%TYPE;
177 --
178 -- -----------------------------------------------------------------------------
179 -- |--------------------------------< form_id >--------------------------------|
180 -- -----------------------------------------------------------------------------
181 -- {Start of Comments}
182 --
183 -- Description
184 -- This function returns the form identifier for a form template.
185 --
186 -- Prerequisites
187 -- None.
188 --
189 -- In Parameters
190 -- p_form_template_id Y number Form template identifier
191 --
192 -- Post Success
193 -- The form identifier associated with the form template is returned.
194 --
195 -- Post Failure
196 -- An error is raised
197 --
198 -- Access Status
199 -- Internal Development Use Only
200 --
201 -- {End of Comments}
202 -- -----------------------------------------------------------------------------
203 FUNCTION form_id
204 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
205 )
206 RETURN hr_form_templates_b.form_id%TYPE;
207 --
208 FUNCTION date_format_mask
209 RETURN VARCHAR2;
210 --
211 FUNCTION datetime_format_mask
212 RETURN VARCHAR2;
213 --
214 END hr_form_template_info;