[Home] [Help]
PACKAGE BODY: APPS.HR_TEMPLATE_ITEM_CONTEXT_INFO
Source
1 PACKAGE BODY hr_template_item_context_info
2 /* $Header: hrticinf.pkb 120.0 2005/05/31 03:09:37 appldev noship $ */
3 AS
4 --
5 -- Global variables
6 --
7 g_form_template_id hr_form_templates_b.form_template_id%TYPE;
8 g_template_item_contexts t_template_item_contexts := t_template_item_contexts();
9 --
10 g_form_template_id_pst hr_form_templates_b.form_template_id%TYPE;
11 g_template_item_contexts_pst t_template_item_contexts_pst;
12 g_index_number_pst NUMBER;
13 g_null_template_item_contexts t_template_item_contexts_pst;
14 --
15 -- Global cursors
16 --
17 CURSOR csr_template_item_contexts
18 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
19 )
20 IS
21 SELECT tic.template_item_context_id
22 ,tic.template_item_id
23 ,fim.full_item_name
24 ,fim.item_type
25 ,fwn.window_name
26 ,fcn.canvas_name
27 ,ftp.tab_page_name
28 ,fim.radio_button_name
29 ,tic.context_type
30 ,icx.segment1
31 ,icx.segment2
32 ,icx.segment3
33 ,icx.segment4
34 ,icx.segment5
35 ,icx.segment6
36 ,icx.segment7
37 ,icx.segment8
38 ,icx.segment9
39 ,icx.segment10
40 ,icx.segment11
41 ,icx.segment12
42 ,icx.segment13
43 ,icx.segment14
44 ,icx.segment15
45 ,icx.segment16
46 ,icx.segment17
47 ,icx.segment18
48 ,icx.segment19
49 ,icx.segment20
50 ,icx.segment21
51 ,icx.segment22
52 ,icx.segment23
53 ,icx.segment24
54 ,icx.segment25
55 ,icx.segment26
56 ,icx.segment27
57 ,icx.segment28
58 ,icx.segment29
59 ,icx.segment30
60 ,itp.alignment
61 ,itp.bevel
62 ,itp.case_restriction
63 ,ipt.default_value
64 ,itp.enabled
65 ,itp.format_mask
66 ,itp.height
67 ,itp.information_formula_id
68 ,hr_form_item_info.full_item_name(itp.information_parameter_item_id1) information_parameter_item1
69 ,hr_form_item_info.full_item_name(itp.information_parameter_item_id2) information_parameter_item2
70 ,hr_form_item_info.full_item_name(itp.information_parameter_item_id3) information_parameter_item3
71 ,hr_form_item_info.full_item_name(itp.information_parameter_item_id4) information_parameter_item4
72 ,hr_form_item_info.full_item_name(itp.information_parameter_item_id5) information_parameter_item5
73 ,ipt.information_prompt
74 ,itp.insert_allowed
75 ,ipt.label
76 ,hr_form_item_info.full_item_name(itp.next_navigation_item_id) next_navigation_item
77 ,hr_form_item_info.full_item_name(itp.previous_navigation_item_id) previous_navigation_item
78 ,itp.prompt_alignment_offset
79 ,itp.prompt_display_style
80 ,itp.prompt_edge
81 ,itp.prompt_edge_alignment
82 ,itp.prompt_edge_offset
83 ,ipt.prompt_text
84 ,itp.prompt_text_alignment
85 ,itp.query_allowed
86 ,itp.required
87 ,ipt.tooltip_text
88 ,itp.update_allowed
89 ,itp.validation_formula_id
90 ,hr_form_item_info.full_item_name(itp.validation_parameter_item_id1) validation_parameter_item1
91 ,hr_form_item_info.full_item_name(itp.validation_parameter_item_id2) validation_parameter_item2
92 ,hr_form_item_info.full_item_name(itp.validation_parameter_item_id3) validation_parameter_item3
93 ,hr_form_item_info.full_item_name(itp.validation_parameter_item_id4) validation_parameter_item4
94 ,hr_form_item_info.full_item_name(itp.validation_parameter_item_id5) validation_parameter_item5
95 ,itp.visible
96 ,itp.width
97 ,itp.x_position
98 ,itp.y_position
99 ,itp.information_category
100 ,itp.information1
101 ,itp.information2
102 ,itp.information3
103 ,itp.information4
104 ,itp.information5
105 ,itp.information6
106 ,itp.information7
107 ,itp.information8
108 ,itp.information9
109 ,itp.information10
110 ,itp.information11
111 ,itp.information12
112 ,itp.information13
113 ,itp.information14
114 ,itp.information15
115 ,itp.information16
116 ,itp.information17
117 ,itp.information18
118 ,itp.information19
119 ,itp.information20
120 ,itp.information21
121 ,itp.information22
122 ,itp.information23
123 ,itp.information24
124 ,itp.information25
125 ,itp.information26
126 ,itp.information27
127 ,itp.information28
128 ,itp.information29
129 ,itp.information30
130 ,fim.full_item_name AS deleted -- 'N'
131 FROM hr_form_tab_pages_b ftp
132 ,hr_template_tab_pages_b ttp
133 ,hr_template_item_context_pages tcp
134 ,hr_form_windows_b fwn
135 ,hr_form_canvases_b fcn
136 ,hr_form_items_b fim
137 ,hr_item_contexts icx
138 ,hr_item_properties_tl ipt
139 ,hr_item_properties_b itp
140 ,hr_template_item_contexts_b tic
141 ,hr_template_items_b tim
142 WHERE ftp.form_tab_page_id (+) = ttp.form_tab_page_id
143 AND ttp.template_tab_page_id (+) = tcp.template_tab_page_id
144 AND tcp.template_item_context_id (+) = tic.template_item_context_id
145 AND fwn.form_window_id = fcn.form_window_id
146 AND fcn.form_canvas_id = fim.form_canvas_id
147 AND fim.form_item_id = tim.form_item_id
148 AND icx.item_context_id = tic.item_context_id
149 AND ipt.language = userenv('LANG')
150 AND ipt.item_property_id = itp.item_property_id
151 AND itp.template_item_context_id = tic.template_item_context_id
152 AND tic.template_item_id = tim.template_item_id
153 AND tim.form_template_id = p_form_template_id;
154 --
155 -- -----------------------------------------------------------------------------
156 -- |-------------------------< template_item_contexts >------------------------|
157 -- -----------------------------------------------------------------------------
158 FUNCTION template_item_contexts
159 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
160 )
161 RETURN t_template_item_contexts
162 IS
163 --
164 l_template_item_contexts t_template_item_contexts := t_template_item_contexts();
165 --
166 BEGIN
167 --
168 FOR l_template_item_context IN csr_template_item_contexts
169 (p_form_template_id => p_form_template_id
170 )
171 LOOP
172 IF (l_template_item_context.template_item_context_id IS NULL)
173 THEN
174 l_template_item_context.visible := 5;
175 END IF;
176 l_template_item_contexts.EXTEND;
177 l_template_item_contexts(l_template_item_contexts.LAST) := l_template_item_context;
178 END LOOP;
179 --
180 RETURN(l_template_item_contexts);
181 --
182 END template_item_contexts;
183 --
184 -- -----------------------------------------------------------------------------
185 -- |-----------------------< template_item_contexts_pst >----------------------|
186 -- -----------------------------------------------------------------------------
187 FUNCTION template_item_contexts_pst
188 (p_form_template_id IN hr_form_templates_b.form_template_id%TYPE
189 )
190 RETURN t_template_item_contexts_pst
191 IS
192 --
193 l_template_item_contexts_pst t_template_item_contexts_pst;
194 l_index_number NUMBER;
195 --
196 BEGIN
197 --
198 IF (p_form_template_id = g_form_template_id_pst)
199 THEN
200 --
201 NULL;
202 --
203 ELSE
204 --
205 g_template_item_contexts_pst := g_null_template_item_contexts;
206 l_index_number := 1;
207 FOR l_template_item_context IN csr_template_item_contexts
208 (p_form_template_id => p_form_template_id
209 )
210 LOOP
211 IF (l_template_item_context.template_item_context_id IS NULL)
212 THEN
213 l_template_item_context.visible := 5;
214 END IF;
215 g_template_item_contexts_pst(l_index_number) := l_template_item_context;
216 l_index_number := l_index_number + 1;
217 END LOOP;
218 --
219 g_form_template_id_pst := p_form_template_id;
220 g_index_number_pst := g_template_item_contexts_pst.FIRST;
221 --
222 END IF;
223 --
224 l_index_number := g_index_number_pst;
225 WHILE ( (l_index_number IS NOT NULL)
226 AND (l_index_number < g_index_number_pst + 50) )
227 LOOP
228 l_template_item_contexts_pst(l_index_number) := g_template_item_contexts_pst(l_index_number);
229 l_index_number := g_template_item_contexts_pst.NEXT(l_index_number);
230 END LOOP;
231 g_index_number_pst := l_index_number;
232 IF (l_template_item_contexts_pst.COUNT = 0)
233 THEN
234 g_form_template_id_pst := NULL;
235 END IF;
236 --
237 RETURN(l_template_item_contexts_pst);
238 --
239 END template_item_contexts_pst;
240 --
241 END hr_template_item_context_info;