[Home] [Help]
PACKAGE: APPS.HR_TEMPLATE_CONFIGURATOR_INFO
Source
1 PACKAGE hr_template_configurator_info
2 /* $Header: hrtcrinf.pkh 120.0 2005/05/31 03:01:36 appldev noship $ */
3 AS
4 --
5 TYPE t_object IS RECORD
6 (object_type VARCHAR2(30)
7 ,object_name VARCHAR2(61)
8 ,radio_button_name VARCHAR2(30)
9 ,event VARCHAR2(30)
10 ,property_type NUMBER
11 ,property_value VARCHAR2(2000)
12 ,tab_page_name VARCHAR2(30)
13 ,context_type VARCHAR2(150)
14 ,segment1 VARCHAR2(150)
15 ,segment2 VARCHAR2(150)
16 ,segment3 VARCHAR2(150)
17 ,segment4 VARCHAR2(150)
18 ,segment5 VARCHAR2(150)
19 ,segment6 VARCHAR2(150)
20 ,segment7 VARCHAR2(150)
21 ,segment8 VARCHAR2(150)
22 ,segment9 VARCHAR2(150)
23 ,segment10 VARCHAR2(150)
24 ,segment11 VARCHAR2(150)
25 ,segment12 VARCHAR2(150)
26 ,segment13 VARCHAR2(150)
27 ,segment14 VARCHAR2(150)
28 ,segment15 VARCHAR2(150)
29 ,segment16 VARCHAR2(150)
30 ,segment17 VARCHAR2(150)
31 ,segment18 VARCHAR2(150)
32 ,segment19 VARCHAR2(150)
33 ,segment20 VARCHAR2(150)
34 ,segment21 VARCHAR2(150)
35 ,segment22 VARCHAR2(150)
36 ,segment23 VARCHAR2(150)
37 ,segment24 VARCHAR2(150)
38 ,segment25 VARCHAR2(150)
39 ,segment26 VARCHAR2(150)
40 ,segment27 VARCHAR2(150)
41 ,segment28 VARCHAR2(150)
42 ,segment29 VARCHAR2(150)
43 ,segment30 VARCHAR2(150)
44 ,processed BOOLEAN
45 );
46 TYPE t_objects IS TABLE OF t_object;
47 TYPE t_objects_pst IS TABLE OF t_object INDEX BY BINARY_INTEGER;
48 --
49 TYPE t_event IS RECORD
50 (event_name VARCHAR2(30)
51 ,object_type VARCHAR2(30)
52 ,object_name VARCHAR2(61)
53 ,full_item_name VARCHAR2(61)
54 ,context_type VARCHAR2(150)
55 ,segment1 VARCHAR2(150)
56 ,segment2 VARCHAR2(150)
57 ,segment3 VARCHAR2(150)
58 ,segment4 VARCHAR2(150)
59 ,segment5 VARCHAR2(150)
60 ,segment6 VARCHAR2(150)
61 ,segment7 VARCHAR2(150)
62 ,segment8 VARCHAR2(150)
63 ,segment9 VARCHAR2(150)
64 ,segment10 VARCHAR2(150)
65 ,segment11 VARCHAR2(150)
66 ,segment12 VARCHAR2(150)
67 ,segment13 VARCHAR2(150)
68 ,segment14 VARCHAR2(150)
69 ,segment15 VARCHAR2(150)
70 ,segment16 VARCHAR2(150)
71 ,segment17 VARCHAR2(150)
72 ,segment18 VARCHAR2(150)
73 ,segment19 VARCHAR2(150)
74 ,segment20 VARCHAR2(150)
75 ,segment21 VARCHAR2(150)
76 ,segment22 VARCHAR2(150)
77 ,segment23 VARCHAR2(150)
78 ,segment24 VARCHAR2(150)
79 ,segment25 VARCHAR2(150)
80 ,segment26 VARCHAR2(150)
81 ,segment27 VARCHAR2(150)
82 ,segment28 VARCHAR2(150)
83 ,segment29 VARCHAR2(150)
84 ,segment30 VARCHAR2(150)
85 ,processed BOOLEAN
86 );
87 TYPE t_events IS TABLE OF t_event;
88 TYPE t_events_pst IS TABLE OF t_event INDEX BY BINARY_INTEGER;
89 --
90 -- -----------------------------------------------------------------------------
91 -- |-----------------------------< configurating >-----------------------------|
92 -- -----------------------------------------------------------------------------
93 FUNCTION configurating
94 RETURN BOOLEAN;
95 --
96 -- -----------------------------------------------------------------------------
97 -- |---------------------------< set_configurating >---------------------------|
98 -- -----------------------------------------------------------------------------
99 PROCEDURE set_configurating
100 (p_configurating IN BOOLEAN
101 );
102 --
103 -- -----------------------------------------------------------------------------
104 -- |---------------------------< form_template_id >----------------------------|
105 -- -----------------------------------------------------------------------------
106 FUNCTION form_template_id
107 RETURN NUMBER;
108 --
109 -- -----------------------------------------------------------------------------
110 -- |-------------------------< set_form_template_id >--------------------------|
111 -- -----------------------------------------------------------------------------
112 PROCEDURE set_form_template_id
113 (p_form_template_id IN NUMBER
114 );
115 --
116 -- -----------------------------------------------------------------------------
117 -- |--------------------------------< objects >--------------------------------|
118 -- -----------------------------------------------------------------------------
119 FUNCTION objects
120 RETURN t_objects;
121 --
122 -- -----------------------------------------------------------------------------
123 -- |------------------------------< objects_pst >------------------------------|
124 -- -----------------------------------------------------------------------------
125 FUNCTION objects_pst
126 RETURN t_objects_pst;
127 --
128 -- -----------------------------------------------------------------------------
129 -- |-----------------------------< commit_objects >----------------------------|
130 -- -----------------------------------------------------------------------------
131 PROCEDURE commit_objects;
132 --
133 -- -----------------------------------------------------------------------------
134 -- |-----------------------------< create_object >-----------------------------|
135 -- -----------------------------------------------------------------------------
136 PROCEDURE create_object
137 (p_object_type IN VARCHAR2
138 ,p_object_name IN VARCHAR2
139 ,p_radio_button_name IN VARCHAR2 DEFAULT NULL
140 ,p_tab_page_name IN VARCHAR2 DEFAULT NULL
141 ,p_context_type IN VARCHAR2 DEFAULT NULL
142 ,p_segment1 IN VARCHAR2 DEFAULT NULL
143 ,p_segment2 IN VARCHAR2 DEFAULT NULL
144 ,p_segment3 IN VARCHAR2 DEFAULT NULL
145 ,p_segment4 IN VARCHAR2 DEFAULT NULL
146 ,p_segment5 IN VARCHAR2 DEFAULT NULL
147 ,p_segment6 IN VARCHAR2 DEFAULT NULL
148 ,p_segment7 IN VARCHAR2 DEFAULT NULL
149 ,p_segment8 IN VARCHAR2 DEFAULT NULL
150 ,p_segment9 IN VARCHAR2 DEFAULT NULL
151 ,p_segment10 IN VARCHAR2 DEFAULT NULL
152 ,p_segment11 IN VARCHAR2 DEFAULT NULL
153 ,p_segment12 IN VARCHAR2 DEFAULT NULL
154 ,p_segment13 IN VARCHAR2 DEFAULT NULL
155 ,p_segment14 IN VARCHAR2 DEFAULT NULL
156 ,p_segment15 IN VARCHAR2 DEFAULT NULL
157 ,p_segment16 IN VARCHAR2 DEFAULT NULL
158 ,p_segment17 IN VARCHAR2 DEFAULT NULL
159 ,p_segment18 IN VARCHAR2 DEFAULT NULL
160 ,p_segment19 IN VARCHAR2 DEFAULT NULL
161 ,p_segment20 IN VARCHAR2 DEFAULT NULL
162 ,p_segment21 IN VARCHAR2 DEFAULT NULL
163 ,p_segment22 IN VARCHAR2 DEFAULT NULL
164 ,p_segment23 IN VARCHAR2 DEFAULT NULL
165 ,p_segment24 IN VARCHAR2 DEFAULT NULL
166 ,p_segment25 IN VARCHAR2 DEFAULT NULL
167 ,p_segment26 IN VARCHAR2 DEFAULT NULL
168 ,p_segment27 IN VARCHAR2 DEFAULT NULL
169 ,p_segment28 IN VARCHAR2 DEFAULT NULL
170 ,p_segment29 IN VARCHAR2 DEFAULT NULL
171 ,p_segment30 IN VARCHAR2 DEFAULT NULL
172 );
173 --
174 -- -----------------------------------------------------------------------------
175 -- |-----------------------------< delete_object >-----------------------------|
176 -- -----------------------------------------------------------------------------
177 PROCEDURE delete_object
178 (p_object_type IN VARCHAR2
179 ,p_object_name IN VARCHAR2
180 ,p_radio_button_name IN VARCHAR2 DEFAULT NULL
181 ,p_tab_page_name IN VARCHAR2 DEFAULT NULL
182 ,p_context_type IN VARCHAR2 DEFAULT NULL
183 ,p_segment1 IN VARCHAR2 DEFAULT NULL
184 ,p_segment2 IN VARCHAR2 DEFAULT NULL
185 ,p_segment3 IN VARCHAR2 DEFAULT NULL
186 ,p_segment4 IN VARCHAR2 DEFAULT NULL
187 ,p_segment5 IN VARCHAR2 DEFAULT NULL
188 ,p_segment6 IN VARCHAR2 DEFAULT NULL
189 ,p_segment7 IN VARCHAR2 DEFAULT NULL
190 ,p_segment8 IN VARCHAR2 DEFAULT NULL
191 ,p_segment9 IN VARCHAR2 DEFAULT NULL
192 ,p_segment10 IN VARCHAR2 DEFAULT NULL
193 ,p_segment11 IN VARCHAR2 DEFAULT NULL
194 ,p_segment12 IN VARCHAR2 DEFAULT NULL
195 ,p_segment13 IN VARCHAR2 DEFAULT NULL
196 ,p_segment14 IN VARCHAR2 DEFAULT NULL
197 ,p_segment15 IN VARCHAR2 DEFAULT NULL
198 ,p_segment16 IN VARCHAR2 DEFAULT NULL
199 ,p_segment17 IN VARCHAR2 DEFAULT NULL
200 ,p_segment18 IN VARCHAR2 DEFAULT NULL
201 ,p_segment19 IN VARCHAR2 DEFAULT NULL
202 ,p_segment20 IN VARCHAR2 DEFAULT NULL
203 ,p_segment21 IN VARCHAR2 DEFAULT NULL
204 ,p_segment22 IN VARCHAR2 DEFAULT NULL
205 ,p_segment23 IN VARCHAR2 DEFAULT NULL
206 ,p_segment24 IN VARCHAR2 DEFAULT NULL
207 ,p_segment25 IN VARCHAR2 DEFAULT NULL
208 ,p_segment26 IN VARCHAR2 DEFAULT NULL
209 ,p_segment27 IN VARCHAR2 DEFAULT NULL
210 ,p_segment28 IN VARCHAR2 DEFAULT NULL
211 ,p_segment29 IN VARCHAR2 DEFAULT NULL
212 ,p_segment30 IN VARCHAR2 DEFAULT NULL
213 );
214 --
215 -- -----------------------------------------------------------------------------
216 -- |----------------------------< process_objects >----------------------------|
217 -- -----------------------------------------------------------------------------
218 PROCEDURE process_objects;
219 --
220 -- -----------------------------------------------------------------------------
221 -- |----------------------------< rollback_object >----------------------------|
222 -- -----------------------------------------------------------------------------
223 PROCEDURE rollback_object
224 (p_object_type IN VARCHAR2
225 ,p_object_name IN VARCHAR2
226 ,p_radio_button_name IN VARCHAR2 DEFAULT NULL
227 ,p_context_type IN VARCHAR2 DEFAULT NULL
228 ,p_segment1 IN VARCHAR2 DEFAULT NULL
229 ,p_segment2 IN VARCHAR2 DEFAULT NULL
230 ,p_segment3 IN VARCHAR2 DEFAULT NULL
231 ,p_segment4 IN VARCHAR2 DEFAULT NULL
232 ,p_segment5 IN VARCHAR2 DEFAULT NULL
233 ,p_segment6 IN VARCHAR2 DEFAULT NULL
234 ,p_segment7 IN VARCHAR2 DEFAULT NULL
235 ,p_segment8 IN VARCHAR2 DEFAULT NULL
236 ,p_segment9 IN VARCHAR2 DEFAULT NULL
237 ,p_segment10 IN VARCHAR2 DEFAULT NULL
238 ,p_segment11 IN VARCHAR2 DEFAULT NULL
239 ,p_segment12 IN VARCHAR2 DEFAULT NULL
240 ,p_segment13 IN VARCHAR2 DEFAULT NULL
241 ,p_segment14 IN VARCHAR2 DEFAULT NULL
242 ,p_segment15 IN VARCHAR2 DEFAULT NULL
243 ,p_segment16 IN VARCHAR2 DEFAULT NULL
244 ,p_segment17 IN VARCHAR2 DEFAULT NULL
245 ,p_segment18 IN VARCHAR2 DEFAULT NULL
246 ,p_segment19 IN VARCHAR2 DEFAULT NULL
247 ,p_segment20 IN VARCHAR2 DEFAULT NULL
248 ,p_segment21 IN VARCHAR2 DEFAULT NULL
249 ,p_segment22 IN VARCHAR2 DEFAULT NULL
250 ,p_segment23 IN VARCHAR2 DEFAULT NULL
251 ,p_segment24 IN VARCHAR2 DEFAULT NULL
252 ,p_segment25 IN VARCHAR2 DEFAULT NULL
253 ,p_segment26 IN VARCHAR2 DEFAULT NULL
254 ,p_segment27 IN VARCHAR2 DEFAULT NULL
255 ,p_segment28 IN VARCHAR2 DEFAULT NULL
256 ,p_segment29 IN VARCHAR2 DEFAULT NULL
257 ,p_segment30 IN VARCHAR2 DEFAULT NULL
258 );
259 --
260 -- -----------------------------------------------------------------------------
261 -- |-----------------------------< update_object >-----------------------------|
262 -- -----------------------------------------------------------------------------
263 PROCEDURE update_object
264 (p_object_type IN VARCHAR2
265 ,p_object_name IN VARCHAR2
266 ,p_radio_button_name IN VARCHAR2 DEFAULT NULL
267 ,p_property_type IN NUMBER DEFAULT NULL
268 ,p_property_value IN VARCHAR2 DEFAULT NULL
269 ,p_tab_page_name IN VARCHAR2 DEFAULT NULL
270 ,p_context_type IN VARCHAR2 DEFAULT NULL
271 ,p_segment1 IN VARCHAR2 DEFAULT NULL
272 ,p_segment2 IN VARCHAR2 DEFAULT NULL
273 ,p_segment3 IN VARCHAR2 DEFAULT NULL
274 ,p_segment4 IN VARCHAR2 DEFAULT NULL
275 ,p_segment5 IN VARCHAR2 DEFAULT NULL
276 ,p_segment6 IN VARCHAR2 DEFAULT NULL
277 ,p_segment7 IN VARCHAR2 DEFAULT NULL
278 ,p_segment8 IN VARCHAR2 DEFAULT NULL
279 ,p_segment9 IN VARCHAR2 DEFAULT NULL
280 ,p_segment10 IN VARCHAR2 DEFAULT NULL
281 ,p_segment11 IN VARCHAR2 DEFAULT NULL
282 ,p_segment12 IN VARCHAR2 DEFAULT NULL
283 ,p_segment13 IN VARCHAR2 DEFAULT NULL
284 ,p_segment14 IN VARCHAR2 DEFAULT NULL
285 ,p_segment15 IN VARCHAR2 DEFAULT NULL
286 ,p_segment16 IN VARCHAR2 DEFAULT NULL
287 ,p_segment17 IN VARCHAR2 DEFAULT NULL
288 ,p_segment18 IN VARCHAR2 DEFAULT NULL
289 ,p_segment19 IN VARCHAR2 DEFAULT NULL
290 ,p_segment20 IN VARCHAR2 DEFAULT NULL
291 ,p_segment21 IN VARCHAR2 DEFAULT NULL
292 ,p_segment22 IN VARCHAR2 DEFAULT NULL
293 ,p_segment23 IN VARCHAR2 DEFAULT NULL
294 ,p_segment24 IN VARCHAR2 DEFAULT NULL
295 ,p_segment25 IN VARCHAR2 DEFAULT NULL
296 ,p_segment26 IN VARCHAR2 DEFAULT NULL
297 ,p_segment27 IN VARCHAR2 DEFAULT NULL
298 ,p_segment28 IN VARCHAR2 DEFAULT NULL
299 ,p_segment29 IN VARCHAR2 DEFAULT NULL
300 ,p_segment30 IN VARCHAR2 DEFAULT NULL
301 );
302 --
306 FUNCTION events
303 -- -----------------------------------------------------------------------------
304 -- |--------------------------------< events >---------------------------------|
305 -- -----------------------------------------------------------------------------
307 RETURN t_events;
308 --
309 -- -----------------------------------------------------------------------------
310 -- |------------------------------< events_pst >-------------------------------|
311 -- -----------------------------------------------------------------------------
312 FUNCTION events_pst
313 RETURN t_events_pst;
314 --
315 -- -----------------------------------------------------------------------------
316 -- |------------------------------< set_context >------------------------------|
317 -- -----------------------------------------------------------------------------
318 PROCEDURE set_context
319 (p_full_item_name IN VARCHAR2
320 ,p_context_type IN VARCHAR2
321 ,p_segment1 IN VARCHAR2 DEFAULT NULL
322 ,p_segment2 IN VARCHAR2 DEFAULT NULL
323 ,p_segment3 IN VARCHAR2 DEFAULT NULL
324 ,p_segment4 IN VARCHAR2 DEFAULT NULL
325 ,p_segment5 IN VARCHAR2 DEFAULT NULL
326 ,p_segment6 IN VARCHAR2 DEFAULT NULL
327 ,p_segment7 IN VARCHAR2 DEFAULT NULL
328 ,p_segment8 IN VARCHAR2 DEFAULT NULL
329 ,p_segment9 IN VARCHAR2 DEFAULT NULL
330 ,p_segment10 IN VARCHAR2 DEFAULT NULL
331 ,p_segment11 IN VARCHAR2 DEFAULT NULL
332 ,p_segment12 IN VARCHAR2 DEFAULT NULL
333 ,p_segment13 IN VARCHAR2 DEFAULT NULL
334 ,p_segment14 IN VARCHAR2 DEFAULT NULL
335 ,p_segment15 IN VARCHAR2 DEFAULT NULL
336 ,p_segment16 IN VARCHAR2 DEFAULT NULL
337 ,p_segment17 IN VARCHAR2 DEFAULT NULL
338 ,p_segment18 IN VARCHAR2 DEFAULT NULL
339 ,p_segment19 IN VARCHAR2 DEFAULT NULL
340 ,p_segment20 IN VARCHAR2 DEFAULT NULL
341 ,p_segment21 IN VARCHAR2 DEFAULT NULL
342 ,p_segment22 IN VARCHAR2 DEFAULT NULL
343 ,p_segment23 IN VARCHAR2 DEFAULT NULL
344 ,p_segment24 IN VARCHAR2 DEFAULT NULL
345 ,p_segment25 IN VARCHAR2 DEFAULT NULL
346 ,p_segment26 IN VARCHAR2 DEFAULT NULL
347 ,p_segment27 IN VARCHAR2 DEFAULT NULL
348 ,p_segment28 IN VARCHAR2 DEFAULT NULL
349 ,p_segment29 IN VARCHAR2 DEFAULT NULL
350 ,p_segment30 IN VARCHAR2 DEFAULT NULL
351 );
352 --
353 -- -----------------------------------------------------------------------------
354 -- |-----------------------------< reset_contexts >----------------------------|
355 -- -----------------------------------------------------------------------------
356 PROCEDURE reset_contexts;
357 --
358 -- -----------------------------------------------------------------------------
359 -- |------------------------------< show_object >------------------------------|
360 -- -----------------------------------------------------------------------------
361 PROCEDURE show_object
362 (p_object_type IN VARCHAR2
363 ,p_object_name IN VARCHAR2
364 );
365 --
366 -- -----------------------------------------------------------------------------
367 -- |------------------------------< close_form >-------------------------------|
368 -- -----------------------------------------------------------------------------
369 PROCEDURE close_form;
370 --
371 -- -----------------------------------------------------------------------------
372 -- |-------------------------< reinit_item_contexts >--------------------------|
373 -- -----------------------------------------------------------------------------
374 PROCEDURE reinit_item_contexts;
375 --
376 END hr_template_configurator_info;