[Home] [Help]
PACKAGE BODY: APPS.HXT_AEI
Source
1 PACKAGE BODY HXT_AEI AS
2 /* $Header: hxtaei.pkb 120.0.12000000.2 2007/03/13 11:39:59 nissharm noship $ */
3
4 procedure insert_HXT_ADD_ELEM_INFO(
5 p_rowid IN OUT NOCOPY VARCHAR2,
6 p_id NUMBER,
7 p_effective_start_date DATE,
8 p_effective_end_date DATE,
9 p_element_type_id NUMBER,
10 p_earning_category VARCHAR2,
11 p_absence_type VARCHAR2,
12 p_absence_points NUMBER,
13 p_points_assigned NUMBER,
14 p_premium_type VARCHAR2,
15 p_premium_amount NUMBER,
16 p_processing_order NUMBER,
17 p_expenditure_type VARCHAR2,
18 p_created_by NUMBER,
19 p_creation_date DATE,
20 p_last_updated_by NUMBER,
21 p_last_update_date DATE,
22 p_last_update_login NUMBER,
23 p_attribute_category VARCHAR2,
24 p_attribute1 VARCHAR2,
25 p_attribute2 VARCHAR2,
26 p_attribute3 VARCHAR2,
27 p_attribute4 VARCHAR2,
28 p_attribute5 VARCHAR2,
29 p_attribute6 VARCHAR2,
30 p_attribute7 VARCHAR2,
31 p_attribute8 VARCHAR2,
32 p_attribute9 VARCHAR2,
33 p_attribute10 VARCHAR2,
34 p_attribute11 VARCHAR2,
35 p_attribute12 VARCHAR2,
36 p_attribute13 VARCHAR2,
37 p_attribute14 VARCHAR2,
38 p_attribute15 VARCHAR2,
39 p_attribute16 VARCHAR2,
40 p_attribute17 VARCHAR2,
41 p_attribute18 VARCHAR2,
42 p_attribute19 VARCHAR2,
43 p_attribute20 VARCHAR2,
44 p_attribute21 VARCHAR2,
45 p_attribute22 VARCHAR2,
46 p_attribute23 VARCHAR2,
47 p_attribute24 VARCHAR2,
48 p_attribute25 VARCHAR2,
49 p_attribute26 VARCHAR2,
50 p_attribute27 VARCHAR2,
51 p_attribute28 VARCHAR2,
52 p_attribute29 VARCHAR2,
53 p_attribute30 VARCHAR2,
54 p_exclude_from_explosion VARCHAR2 /* Bug: 4489952 */
55 ) is
56
57 cursor c2 is select rowid
58 from hxt_add_elem_info_f
59 where effective_start_date = p_effective_start_date
60 and effective_end_date = p_effective_end_date
61 and id = p_id;
62
63 begin
64
65 insert into HXT_ADD_ELEM_INFO_F(
66 id,
67 effective_start_date,
68 effective_end_date,
69 element_type_id,
70 earning_category,
71 absence_type,
72 absence_points,
73 points_assigned,
74 premium_type,
75 premium_amount,
76 processing_order,
77 expenditure_type,
78 created_by,
79 creation_date,
80 last_updated_by,
81 last_update_date,
82 last_update_login,
83 attribute_category,
84 attribute1,
85 attribute2,
86 attribute3,
87 attribute4,
88 attribute5,
89 attribute6,
90 attribute7,
91 attribute8,
92 attribute9,
93 attribute10,
94 attribute11,
95 attribute12,
96 attribute13,
97 attribute14,
98 attribute15,
99 attribute16,
100 attribute17,
101 attribute18,
102 attribute19,
103 attribute20,
104 attribute21,
105 attribute22,
106 attribute23,
107 attribute24,
108 attribute25,
109 attribute26,
110 attribute27,
111 attribute28,
112 attribute29,
113 attribute30,
114 exclude_from_explosion /* Bug: 4489952 */
115 )
116 VALUES(
117 p_id,
118 p_effective_start_date,
119 p_effective_end_date,
120 p_element_type_id,
121 p_earning_category,
122 p_absence_type,
123 p_absence_points,
124 p_points_assigned,
125 p_premium_type,
126 p_premium_amount,
127 p_processing_order,
128 p_expenditure_type,
129 p_created_by,
130 p_creation_date,
131 p_last_updated_by,
132 p_last_update_date,
133 p_last_update_login,
134 p_attribute_category,
135 p_attribute1,
136 p_attribute2,
137 p_attribute3,
138 p_attribute4,
139 p_attribute5,
140 p_attribute6,
141 p_attribute7,
142 p_attribute8,
143 p_attribute9,
144 p_attribute10,
145 p_attribute11,
146 p_attribute12,
147 p_attribute13,
148 p_attribute14,
149 p_attribute15,
150 p_attribute16,
151 p_attribute17,
152 p_attribute18,
153 p_attribute19,
154 p_attribute20,
155 p_attribute21,
156 p_attribute22,
157 p_attribute23,
158 p_attribute24,
159 p_attribute25,
160 p_attribute26,
161 p_attribute27,
162 p_attribute28,
163 p_attribute29,
164 p_attribute30,
165 p_exclude_from_explosion /* Bug: 4489952 */
166 );
167
168 open c2;
169 fetch c2 into p_rowid;
170 close c2;
171 null;
172
173 end insert_HXT_ADD_ELEM_INFO;
174
175
176 procedure update_HXT_ADD_ELEM_INFO(
177 p_rowid IN VARCHAR2,
178 p_id NUMBER,
179 p_effective_start_date DATE,
180 p_effective_end_date DATE,
181 p_element_type_id NUMBER,
182 p_earning_category VARCHAR2,
183 p_absence_type VARCHAR2,
184 p_absence_points NUMBER,
185 p_points_assigned NUMBER,
186 p_premium_type VARCHAR2,
187 p_premium_amount NUMBER,
188 p_processing_order NUMBER,
189 p_expenditure_type VARCHAR2,
190 p_created_by NUMBER,
191 p_creation_date DATE,
192 p_last_updated_by NUMBER,
193 p_last_update_date DATE,
194 p_last_update_login NUMBER,
195 p_attribute_category VARCHAR2,
196 p_attribute1 VARCHAR2,
197 p_attribute2 VARCHAR2,
198 p_attribute3 VARCHAR2,
199 p_attribute4 VARCHAR2,
200 p_attribute5 VARCHAR2,
201 p_attribute6 VARCHAR2,
202 p_attribute7 VARCHAR2,
203 p_attribute8 VARCHAR2,
204 p_attribute9 VARCHAR2,
205 p_attribute10 VARCHAR2,
206 p_attribute11 VARCHAR2,
207 p_attribute12 VARCHAR2,
208 p_attribute13 VARCHAR2,
209 p_attribute14 VARCHAR2,
210 p_attribute15 VARCHAR2,
211 p_attribute16 VARCHAR2,
212 p_attribute17 VARCHAR2,
213 p_attribute18 VARCHAR2,
214 p_attribute19 VARCHAR2,
215 p_attribute20 VARCHAR2,
216 p_attribute21 VARCHAR2,
217 p_attribute22 VARCHAR2,
218 p_attribute23 VARCHAR2,
219 p_attribute24 VARCHAR2,
220 p_attribute25 VARCHAR2,
221 p_attribute26 VARCHAR2,
222 p_attribute27 VARCHAR2,
223 p_attribute28 VARCHAR2,
224 p_attribute29 VARCHAR2,
225 p_attribute30 VARCHAR2,
226 p_exclude_from_explosion VARCHAR2 /* Bug: 4489952 */
227 ) is
228
229 begin
230
231 update HXT_ADD_ELEM_INFO_F
232 set
233 effective_start_date = p_effective_start_date,
234 effective_end_date = p_effective_end_date,
235 element_type_id = p_element_type_id,
236 earning_category = p_earning_category,
237 absence_type = p_absence_type,
238 absence_points = p_absence_points,
239 points_assigned = p_points_assigned,
240 premium_type = p_premium_type,
241 premium_amount = p_premium_amount,
242 processing_order = p_processing_order,
243 expenditure_type = p_expenditure_type,
244 created_by = p_created_by,
245 creation_date = p_creation_date,
246 last_updated_by = p_last_updated_by,
247 last_update_date = p_last_update_date,
248 last_update_login = p_last_update_login,
249 attribute_category = p_attribute_category,
250 attribute1 = p_attribute1,
251 attribute2 = p_attribute2,
252 attribute3 = p_attribute3,
253 attribute4 = p_attribute4,
254 attribute5 = p_attribute5,
255 attribute6 = p_attribute6,
256 attribute7 = p_attribute7,
257 attribute8 = p_attribute8,
258 attribute9 = p_attribute9,
259 attribute10 = p_attribute10,
260 attribute11 = p_attribute11,
261 attribute12 = p_attribute12,
262 attribute13 = p_attribute13,
263 attribute14 = p_attribute14,
264 attribute15 = p_attribute15,
265 attribute16 = p_attribute16,
266 attribute17 = p_attribute17,
267 attribute18 = p_attribute18,
268 attribute19 = p_attribute19,
269 attribute20 = p_attribute20,
270 attribute21 = p_attribute21,
271 attribute22 = p_attribute22,
272 attribute23 = p_attribute23,
273 attribute24 = p_attribute24,
274 attribute25 = p_attribute25,
275 attribute26 = p_attribute26,
276 attribute27 = p_attribute27,
277 attribute28 = p_attribute28,
278 attribute29 = p_attribute29,
279 attribute30 = p_attribute30,
280 exclude_from_explosion = p_exclude_from_explosion /* Bug: 4489952 */
281 where rowid = p_rowid;
282
283 end update_HXT_ADD_ELEM_INFO;
284
285
286 procedure delete_HXT_ADD_ELEM_INFO(p_rowid VARCHAR2) is
287 begin
288 delete from HXT_ADD_ELEM_INFO_F
289 where rowid = chartorowid(p_rowid);
290 end delete_HXT_ADD_ELEM_INFO;
291
292 procedure lock_HXT_ADD_ELEM_INFO(p_rowid VARCHAR2) is
293 vnull number;
294 begin
295 if p_rowid is not null then
296 select ELEMENT_TYPE_ID into vnull
297 from hxt_add_elem_info_f
298 where rowid = p_rowid
299 for update of hxt_add_elem_info_f.ELEMENT_TYPE_ID nowait;
300
301 end if;
302 end lock_HXT_ADD_ELEM_INFO;
303
304 end HXT_AEI;