1 Package Body hr_int_upd as
2 /* $Header: hrintrhi.pkb 115.0 2004/01/09 01:40 vkarandi noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' hr_int_upd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< update_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml update logic. The processing of
17 -- this procedure is:
18 -- 1) Increment the object_version_number by 1 if the object_version_number
19 -- is defined as an attribute for this entity.
20 -- 2) To set and unset the g_api_dml status as required (as we are about to
21 -- perform dml).
22 -- 3) To update the specified row in the schema using the primary key in
23 -- the predicates.
24 -- 4) To trap any constraint violations that may have occurred.
25 -- 5) To raise any other errors.
26 --
27 -- Prerequisites:
28 -- This is an internal private procedure which must be called from the upd
29 -- procedure.
30 --
31 -- In Parameters:
32 -- A Pl/Sql record structre.
33 --
34 -- Post Success:
35 -- The specified row will be updated in the schema.
36 --
37 -- Post Failure:
38 -- On the update dml failure it is important to note that we always reset the
39 -- g_api_dml status to false.
40 -- If a check, unique or parent integrity constraint violation is raised the
41 -- constraint_error procedure will be called.
42 -- If any other error is reported, the error will be raised after the
43 -- g_api_dml status is reset.
44 --
45 -- Developer Implementation Notes:
46 -- The update 'set' attribute list should be modified if any of your
47 -- attributes are not updateable.
48 --
49 -- Access Status:
50 -- Internal Row Handler Use Only.
51 --
52 -- {End Of Comments}
53 -- ----------------------------------------------------------------------------
54 Procedure update_dml
55 (p_rec in out nocopy hr_int_shd.g_rec_type
56 ) is
57 --
58 l_proc varchar2(72) := g_package||'update_dml';
59 --
60 Begin
61 hr_utility.set_location('Entering:'||l_proc, 5);
62 --
63 -- Increment the object version
64 p_rec.object_version_number := p_rec.object_version_number + 1;
65 --
66 --
67 --
68 -- Update the hr_ki_integrations Row
69 --
70 update hr_ki_integrations
71 set
72 integration_id = p_rec.integration_id
73 ,synched = p_rec.synched
74 ,party_type = p_rec.party_type
75 ,party_name = p_rec.party_name
76 ,party_site_name = p_rec.party_site_name
77 ,transaction_type = p_rec.transaction_type
78 ,transaction_subtype = p_rec.transaction_subtype
79 ,standard_code = p_rec.standard_code
80 ,ext_trans_type = p_rec.ext_trans_type
81 ,ext_trans_subtype = p_rec.ext_trans_subtype
82 ,trans_direction = p_rec.trans_direction
83 ,url = p_rec.url
84 ,ext_application_id = p_rec.ext_application_id
85 ,application_name = p_rec.application_name
86 ,application_type = p_rec.application_type
87 ,application_url = p_rec.application_url
88 ,logout_url = p_rec.logout_url
89 ,user_field = p_rec.user_field
90 ,password_field = p_rec.password_field
91 ,authentication_needed = p_rec.authentication_needed
92 ,field_name1 = p_rec.field_name1
93 ,field_value1 = p_rec.field_value1
94 ,field_name2 = p_rec.field_name2
95 ,field_value2 = p_rec.field_value2
96 ,field_name3 = p_rec.field_name3
97 ,field_value3 = p_rec.field_value3
98 ,field_name4 = p_rec.field_name4
99 ,field_value4 = p_rec.field_value4
100 ,field_name5 = p_rec.field_name5
101 ,field_value5 = p_rec.field_value5
102 ,field_name6 = p_rec.field_name6
103 ,field_value6 = p_rec.field_value6
104 ,field_name7 = p_rec.field_name7
105 ,field_value7 = p_rec.field_value7
106 ,field_name8 = p_rec.field_name8
107 ,field_value8 = p_rec.field_value8
108 ,field_name9 = p_rec.field_name9
109 ,field_value9 = p_rec.field_value9
110 ,object_version_number = p_rec.object_version_number
111 where integration_id = p_rec.integration_id;
112 --
113 --
114 --
115 hr_utility.set_location(' Leaving:'||l_proc, 10);
116 --
117 Exception
118 When hr_api.check_integrity_violated Then
119 -- A check constraint has been violated
120 --
121 hr_int_shd.constraint_error
122 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123 When hr_api.parent_integrity_violated Then
124 -- Parent integrity has been violated
125 --
126 hr_int_shd.constraint_error
127 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128 When hr_api.unique_integrity_violated Then
129 -- Unique integrity has been violated
130 --
131 hr_int_shd.constraint_error
132 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133 When Others Then
134 --
135 Raise;
136 End update_dml;
137 --
138 -- ----------------------------------------------------------------------------
139 -- |------------------------------< pre_update >------------------------------|
140 -- ----------------------------------------------------------------------------
141 -- {Start Of Comments}
142 --
143 -- Description:
144 -- This private procedure contains any processing which is required before
145 -- the update dml.
146 --
147 -- Prerequisites:
148 -- This is an internal procedure which is called from the upd procedure.
149 --
150 -- In Parameters:
151 -- A Pl/Sql record structure.
152 --
153 -- Post Success:
154 -- Processing continues.
155 --
156 -- Post Failure:
157 -- If an error has occurred, an error message and exception wil be raised
158 -- but not handled.
159 --
160 -- Developer Implementation Notes:
161 -- Any pre-processing required before the update dml is issued should be
162 -- coded within this procedure. It is important to note that any 3rd party
163 -- maintenance should be reviewed before placing in this procedure.
164 --
165 -- Access Status:
166 -- Internal Row Handler Use Only.
167 --
168 -- {End Of Comments}
169 -- ----------------------------------------------------------------------------
170 Procedure pre_update
171 (p_rec in hr_int_shd.g_rec_type
172 ) is
173 --
174 l_proc varchar2(72) := g_package||'pre_update';
175 --
176 Begin
177 hr_utility.set_location('Entering:'||l_proc, 5);
178 --
179 hr_utility.set_location(' Leaving:'||l_proc, 10);
180 End pre_update;
181 --
182 -- ----------------------------------------------------------------------------
183 -- |-----------------------------< post_update >------------------------------|
184 -- ----------------------------------------------------------------------------
185 -- {Start Of Comments}
186 --
187 -- Description:
188 -- This private procedure contains any processing which is required after
189 -- the update dml.
190 --
191 -- Prerequisites:
192 -- This is an internal procedure which is called from the upd procedure.
193 --
194 -- In Parameters:
195 -- A Pl/Sql record structure.
196 --
197 -- Post Success:
198 -- Processing continues.
199 --
200 -- Post Failure:
201 -- If an error has occurred, an error message and exception will be raised
202 -- but not handled.
203 --
204 -- Developer Implementation Notes:
205 -- Any post-processing required after the update dml is issued should be
206 -- coded within this procedure. It is important to note that any 3rd party
207 -- maintenance should be reviewed before placing in this procedure.
208 --
209 -- Access Status:
210 -- Internal Row Handler Use Only.
211 --
212 -- {End Of Comments}
213 -- ----------------------------------------------------------------------------
214 Procedure post_update
215 (p_rec in hr_int_shd.g_rec_type
216 ) is
217 --
218 l_proc varchar2(72) := g_package||'post_update';
219 --
220 Begin
221 hr_utility.set_location('Entering:'||l_proc, 5);
222 begin
223 --
224 hr_int_rku.after_update
225 (p_integration_id
226 => p_rec.integration_id
227 ,p_synched => p_rec.synched
228 ,p_party_type
229 => p_rec.party_type
230 ,p_party_name
231 => p_rec.party_name
232 ,p_party_site_name
233 => p_rec.party_site_name
234 ,p_transaction_type
235 => p_rec.transaction_type
236 ,p_transaction_subtype
237 => p_rec.transaction_subtype
238 ,p_standard_code
239 => p_rec.standard_code
240 ,p_ext_trans_type
241 => p_rec.ext_trans_type
242 ,p_ext_trans_subtype
243 => p_rec.ext_trans_subtype
244 ,p_trans_direction
245 => p_rec.trans_direction
246 ,p_url
247 => p_rec.url
248 ,p_ext_application_id
249 => p_rec.ext_application_id
250 ,p_application_name
251 => p_rec.application_name
252 ,p_application_type
253 => p_rec.application_type
254 ,p_application_url
255 => p_rec.application_url
256 ,p_logout_url
257 => p_rec.logout_url
258 ,p_user_field
259 => p_rec.user_field
260 ,p_password_field
261 => p_rec.password_field
262 ,p_authentication_needed
263 => p_rec.authentication_needed
264 ,p_field_name1
265 => p_rec.field_name1
266 ,p_field_value1
267 => p_rec.field_value1
268 ,p_field_name2
269 => p_rec.field_name2
270 ,p_field_value2
271 => p_rec.field_value2
272 ,p_field_name3
273 => p_rec.field_name3
274 ,p_field_value3
275 => p_rec.field_value3
276 ,p_field_name4
277 => p_rec.field_name4
278 ,p_field_value4
279 => p_rec.field_value4
280 ,p_field_name5
281 => p_rec.field_name5
282 ,p_field_value5
283 => p_rec.field_value5
284 ,p_field_name6
285 => p_rec.field_name6
286 ,p_field_value6
287 => p_rec.field_value6
288 ,p_field_name7
289 => p_rec.field_name7
290 ,p_field_value7
291 => p_rec.field_value7
292 ,p_field_name8
293 => p_rec.field_name8
294 ,p_field_value8
295 => p_rec.field_value8
296 ,p_field_name9
297 => p_rec.field_name9
298 ,p_field_value9
299 => p_rec.field_value9
300 ,p_object_version_number
301 => p_rec.object_version_number
302 ,p_integration_key_o
303 => hr_int_shd.g_old_rec.integration_key
304 ,p_party_type_o
305 => hr_int_shd.g_old_rec.party_type
306 ,p_party_name_o
307 => hr_int_shd.g_old_rec.party_name
308 ,p_party_site_name_o
309 => hr_int_shd.g_old_rec.party_site_name
310 ,p_transaction_type_o
311 => hr_int_shd.g_old_rec.transaction_type
312 ,p_transaction_subtype_o
313 => hr_int_shd.g_old_rec.transaction_subtype
314 ,p_standard_code_o
315 => hr_int_shd.g_old_rec.standard_code
316 ,p_ext_trans_type_o
317 => hr_int_shd.g_old_rec.ext_trans_type
318 ,p_ext_trans_subtype_o
319 => hr_int_shd.g_old_rec.ext_trans_subtype
320 ,p_trans_direction_o
321 => hr_int_shd.g_old_rec.trans_direction
322 ,p_url_o
323 => hr_int_shd.g_old_rec.url
324 ,p_synched_o
325 => hr_int_shd.g_old_rec.synched
326 ,p_ext_application_id_o
327 => hr_int_shd.g_old_rec.ext_application_id
328 ,p_application_name_o
329 => hr_int_shd.g_old_rec.application_name
330 ,p_application_type_o
331 => hr_int_shd.g_old_rec.application_type
332 ,p_application_url_o
333 => hr_int_shd.g_old_rec.application_url
334 ,p_logout_url_o
335 => hr_int_shd.g_old_rec.logout_url
336 ,p_user_field_o
337 => hr_int_shd.g_old_rec.user_field
338 ,p_password_field_o
339 => hr_int_shd.g_old_rec.password_field
340 ,p_authentication_needed_o
341 => hr_int_shd.g_old_rec.authentication_needed
342 ,p_field_name1_o
343 => hr_int_shd.g_old_rec.field_name1
344 ,p_field_value1_o
345 => hr_int_shd.g_old_rec.field_value1
346 ,p_field_name2_o
347 => hr_int_shd.g_old_rec.field_name2
348 ,p_field_value2_o
349 => hr_int_shd.g_old_rec.field_value2
350 ,p_field_name3_o
351 => hr_int_shd.g_old_rec.field_name3
352 ,p_field_value3_o
353 => hr_int_shd.g_old_rec.field_value3
354 ,p_field_name4_o
355 => hr_int_shd.g_old_rec.field_name4
356 ,p_field_value4_o
357 => hr_int_shd.g_old_rec.field_value4
358 ,p_field_name5_o
359 => hr_int_shd.g_old_rec.field_name5
360 ,p_field_value5_o
361 => hr_int_shd.g_old_rec.field_value5
362 ,p_field_name6_o
363 => hr_int_shd.g_old_rec.field_name6
364 ,p_field_value6_o
365 => hr_int_shd.g_old_rec.field_value6
366 ,p_field_name7_o
367 => hr_int_shd.g_old_rec.field_name7
368 ,p_field_value7_o
369 => hr_int_shd.g_old_rec.field_value7
370 ,p_field_name8_o
371 => hr_int_shd.g_old_rec.field_name8
372 ,p_field_value8_o
373 => hr_int_shd.g_old_rec.field_value8
374 ,p_field_name9_o
375 => hr_int_shd.g_old_rec.field_name9
376 ,p_field_value9_o
377 => hr_int_shd.g_old_rec.field_value9
378 ,p_object_version_number_o
379 => hr_int_shd.g_old_rec.object_version_number
380 );
381 --
382 exception
383 --
384 when hr_api.cannot_find_prog_unit then
385 --
386 hr_api.cannot_find_prog_unit_error
387 (p_module_name => 'HR_KI_INTEGRATIONS'
388 ,p_hook_type => 'AU');
389 --
390 end;
391 --
392 hr_utility.set_location(' Leaving:'||l_proc, 10);
393 End post_update;
394 --
395 -- ----------------------------------------------------------------------------
396 -- |-----------------------------< convert_defs >-----------------------------|
397 -- ----------------------------------------------------------------------------
398 -- {Start Of Comments}
399 --
400 -- Description:
401 -- The Convert_Defs procedure has one very important function:
402 -- It must return the record structure for the row with all system defaulted
403 -- values converted into its corresponding parameter value for update. When
404 -- we attempt to update a row through the Upd process , certain
405 -- parameters can be defaulted which enables flexibility in the calling of
406 -- the upd process (e.g. only attributes which need to be updated need to be
407 -- specified). For the upd process to determine which attributes
408 -- have NOT been specified we need to check if the parameter has a reserved
409 -- system default value. Therefore, for all parameters which have a
410 -- corresponding reserved system default mechanism specified we need to
411 -- check if a system default is being used. If a system default is being
412 -- used then we convert the defaulted value into its corresponding attribute
413 -- value held in the g_old_rec data structure.
414 --
415 -- Prerequisites:
416 -- This private function can only be called from the upd process.
417 --
418 -- In Parameters:
419 -- A Pl/Sql record structure.
420 --
421 -- Post Success:
422 -- The record structure will be returned with all system defaulted parameter
423 -- values converted into its current row attribute value.
424 --
425 -- Post Failure:
426 -- No direct error handling is required within this function. Any possible
427 -- errors within this procedure will be a PL/SQL value error due to
428 -- conversion of datatypes or data lengths.
429 --
430 -- Developer Implementation Notes:
431 -- None.
432 --
433 -- Access Status:
434 -- Internal Row Handler Use Only.
435 --
436 -- {End Of Comments}
437 -- ----------------------------------------------------------------------------
438 Procedure convert_defs
439 (p_rec in out nocopy hr_int_shd.g_rec_type
440 ) is
441 --
442 Begin
443 --
444 -- We must now examine each argument value in the
445 -- p_rec plsql record structure
446 -- to see if a system default is being used. If a system default
447 -- is being used then we must set to the 'current' argument value.
448 --
449 If (p_rec.integration_key = hr_api.g_varchar2) then
450 p_rec.integration_key :=
451 hr_int_shd.g_old_rec.integration_key;
452 End If;
453 If (p_rec.party_type = hr_api.g_varchar2) then
454 p_rec.party_type :=
455 hr_int_shd.g_old_rec.party_type;
456 End If;
457 If (p_rec.party_name = hr_api.g_varchar2) then
458 p_rec.party_name :=
459 hr_int_shd.g_old_rec.party_name;
460 End If;
461 If (p_rec.party_site_name = hr_api.g_varchar2) then
462 p_rec.party_site_name :=
463 hr_int_shd.g_old_rec.party_site_name;
464 End If;
465 If (p_rec.transaction_type = hr_api.g_varchar2) then
466 p_rec.transaction_type :=
467 hr_int_shd.g_old_rec.transaction_type;
468 End If;
469 If (p_rec.transaction_subtype = hr_api.g_varchar2) then
470 p_rec.transaction_subtype :=
471 hr_int_shd.g_old_rec.transaction_subtype;
472 End If;
473 If (p_rec.standard_code = hr_api.g_varchar2) then
474 p_rec.standard_code :=
475 hr_int_shd.g_old_rec.standard_code;
476 End If;
477 If (p_rec.ext_trans_type = hr_api.g_varchar2) then
478 p_rec.ext_trans_type :=
479 hr_int_shd.g_old_rec.ext_trans_type;
480 End If;
481 If (p_rec.ext_trans_subtype = hr_api.g_varchar2) then
482 p_rec.ext_trans_subtype :=
483 hr_int_shd.g_old_rec.ext_trans_subtype;
484 End If;
485 If (p_rec.trans_direction = hr_api.g_varchar2) then
486 p_rec.trans_direction :=
487 hr_int_shd.g_old_rec.trans_direction;
488 End If;
489 If (p_rec.url = hr_api.g_varchar2) then
490 p_rec.url :=
491 hr_int_shd.g_old_rec.url;
492 End If;
493 If (p_rec.synched = hr_api.g_varchar2) then
494 p_rec.synched :=
495 hr_int_shd.g_old_rec.synched;
496 End If;
497 If (p_rec.ext_application_id = hr_api.g_number) then
498 p_rec.ext_application_id :=
499 hr_int_shd.g_old_rec.ext_application_id;
500 End If;
501 If (p_rec.application_name = hr_api.g_varchar2) then
502 p_rec.application_name :=
503 hr_int_shd.g_old_rec.application_name;
504 End If;
505 If (p_rec.application_type = hr_api.g_varchar2) then
506 p_rec.application_type :=
507 hr_int_shd.g_old_rec.application_type;
508 End If;
509 If (p_rec.application_url = hr_api.g_varchar2) then
510 p_rec.application_url :=
511 hr_int_shd.g_old_rec.application_url;
512 End If;
513 If (p_rec.logout_url = hr_api.g_varchar2) then
514 p_rec.logout_url :=
515 hr_int_shd.g_old_rec.logout_url;
516 End If;
517 If (p_rec.user_field = hr_api.g_varchar2) then
518 p_rec.user_field :=
519 hr_int_shd.g_old_rec.user_field;
520 End If;
521 If (p_rec.password_field = hr_api.g_varchar2) then
522 p_rec.password_field :=
523 hr_int_shd.g_old_rec.password_field;
524 End If;
525 If (p_rec.authentication_needed = hr_api.g_varchar2) then
526 p_rec.authentication_needed :=
527 hr_int_shd.g_old_rec.authentication_needed;
528 End If;
529 If (p_rec.field_name1 = hr_api.g_varchar2) then
530 p_rec.field_name1 :=
531 hr_int_shd.g_old_rec.field_name1;
532 End If;
533 If (p_rec.field_value1 = hr_api.g_varchar2) then
534 p_rec.field_value1 :=
535 hr_int_shd.g_old_rec.field_value1;
536 End If;
537 If (p_rec.field_name2 = hr_api.g_varchar2) then
538 p_rec.field_name2 :=
539 hr_int_shd.g_old_rec.field_name2;
540 End If;
541 If (p_rec.field_value2 = hr_api.g_varchar2) then
542 p_rec.field_value2 :=
543 hr_int_shd.g_old_rec.field_value2;
544 End If;
545 If (p_rec.field_name3 = hr_api.g_varchar2) then
546 p_rec.field_name3 :=
547 hr_int_shd.g_old_rec.field_name3;
548 End If;
549 If (p_rec.field_value3 = hr_api.g_varchar2) then
550 p_rec.field_value3 :=
551 hr_int_shd.g_old_rec.field_value3;
552 End If;
553 If (p_rec.field_name4 = hr_api.g_varchar2) then
554 p_rec.field_name4 :=
555 hr_int_shd.g_old_rec.field_name4;
556 End If;
557 If (p_rec.field_value4 = hr_api.g_varchar2) then
558 p_rec.field_value4 :=
559 hr_int_shd.g_old_rec.field_value4;
560 End If;
561 If (p_rec.field_name5 = hr_api.g_varchar2) then
562 p_rec.field_name5 :=
563 hr_int_shd.g_old_rec.field_name5;
564 End If;
565 If (p_rec.field_value5 = hr_api.g_varchar2) then
566 p_rec.field_value5 :=
567 hr_int_shd.g_old_rec.field_value5;
568 End If;
569 If (p_rec.field_name6 = hr_api.g_varchar2) then
570 p_rec.field_name6 :=
571 hr_int_shd.g_old_rec.field_name6;
572 End If;
573 If (p_rec.field_value6 = hr_api.g_varchar2) then
574 p_rec.field_value6 :=
575 hr_int_shd.g_old_rec.field_value6;
576 End If;
577 If (p_rec.field_name7 = hr_api.g_varchar2) then
578 p_rec.field_name7 :=
579 hr_int_shd.g_old_rec.field_name7;
580 End If;
581 If (p_rec.field_value7 = hr_api.g_varchar2) then
582 p_rec.field_value7 :=
583 hr_int_shd.g_old_rec.field_value7;
584 End If;
585 If (p_rec.field_name8 = hr_api.g_varchar2) then
586 p_rec.field_name8 :=
587 hr_int_shd.g_old_rec.field_name8;
588 End If;
589 If (p_rec.field_value8 = hr_api.g_varchar2) then
590 p_rec.field_value8 :=
591 hr_int_shd.g_old_rec.field_value8;
592 End If;
593 If (p_rec.field_name9 = hr_api.g_varchar2) then
594 p_rec.field_name9 :=
595 hr_int_shd.g_old_rec.field_name9;
596 End If;
597 If (p_rec.field_value9 = hr_api.g_varchar2) then
598 p_rec.field_value9 :=
599 hr_int_shd.g_old_rec.field_value9;
600 End If;
601 --
602 End convert_defs;
603 --
604 -- ----------------------------------------------------------------------------
605 -- |---------------------------------< upd >----------------------------------|
606 -- ----------------------------------------------------------------------------
607 Procedure upd
608 (p_rec in out nocopy hr_int_shd.g_rec_type
609 ) is
610 --
611 l_proc varchar2(72) := g_package||'upd';
612 --
613 Begin
614 hr_utility.set_location('Entering:'||l_proc, 5);
615 --
616 -- We must lock the row which we need to update.
617 --
618 hr_int_shd.lck
619 (p_rec.integration_id
620 ,p_rec.object_version_number
621 );
622 --
623 -- 1. During an update system defaults are used to determine if
624 -- arguments have been defaulted or not. We must therefore
625 -- derive the full record structure values to be updated.
626 --
627 -- 2. Call the supporting update validate operations.
628 --
629 convert_defs(p_rec);
630 hr_int_bus.update_validate
631 (p_rec
632 );
633 --
634 -- Call to raise any errors on multi-message list
635 hr_multi_message.end_validation_set;
636 --
637 -- Call the supporting pre-update operation
638 --
639 hr_int_upd.pre_update(p_rec);
640 --
641 -- Update the row.
642 --
643 hr_int_upd.update_dml(p_rec);
644 --
645 -- Call the supporting post-update operation
646 --
647 hr_int_upd.post_update
648 (p_rec
649 );
650 --
651 -- Call to raise any errors on multi-message list
652 hr_multi_message.end_validation_set;
653 End upd;
654 --
655 -- ----------------------------------------------------------------------------
656 -- |---------------------------------< upd >----------------------------------|
657 -- ----------------------------------------------------------------------------
658 Procedure upd
659 (p_integration_id in number
660 ,p_object_version_number in out nocopy number
661 ,p_synched in varchar2 default hr_api.g_varchar2
662 ,p_party_type in varchar2 default hr_api.g_varchar2
663 ,p_party_name in varchar2 default hr_api.g_varchar2
664 ,p_party_site_name in varchar2 default hr_api.g_varchar2
665 ,p_transaction_type in varchar2 default hr_api.g_varchar2
666 ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
667 ,p_standard_code in varchar2 default hr_api.g_varchar2
668 ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
669 ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
670 ,p_trans_direction in varchar2 default hr_api.g_varchar2
671 ,p_url in varchar2 default hr_api.g_varchar2
672 ,p_ext_application_id in number default hr_api.g_number
673 ,p_application_name in varchar2 default hr_api.g_varchar2
674 ,p_application_type in varchar2 default hr_api.g_varchar2
675 ,p_application_url in varchar2 default hr_api.g_varchar2
676 ,p_logout_url in varchar2 default hr_api.g_varchar2
677 ,p_user_field in varchar2 default hr_api.g_varchar2
678 ,p_password_field in varchar2 default hr_api.g_varchar2
679 ,p_authentication_needed in varchar2 default hr_api.g_varchar2
680 ,p_field_name1 in varchar2 default hr_api.g_varchar2
681 ,p_field_value1 in varchar2 default hr_api.g_varchar2
682 ,p_field_name2 in varchar2 default hr_api.g_varchar2
683 ,p_field_value2 in varchar2 default hr_api.g_varchar2
684 ,p_field_name3 in varchar2 default hr_api.g_varchar2
685 ,p_field_value3 in varchar2 default hr_api.g_varchar2
686 ,p_field_name4 in varchar2 default hr_api.g_varchar2
687 ,p_field_value4 in varchar2 default hr_api.g_varchar2
688 ,p_field_name5 in varchar2 default hr_api.g_varchar2
689 ,p_field_value5 in varchar2 default hr_api.g_varchar2
690 ,p_field_name6 in varchar2 default hr_api.g_varchar2
691 ,p_field_value6 in varchar2 default hr_api.g_varchar2
692 ,p_field_name7 in varchar2 default hr_api.g_varchar2
693 ,p_field_value7 in varchar2 default hr_api.g_varchar2
694 ,p_field_name8 in varchar2 default hr_api.g_varchar2
695 ,p_field_value8 in varchar2 default hr_api.g_varchar2
696 ,p_field_name9 in varchar2 default hr_api.g_varchar2
697 ,p_field_value9 in varchar2 default hr_api.g_varchar2
698 ) is
699 --
700 l_rec hr_int_shd.g_rec_type;
701 l_proc varchar2(72) := g_package||'upd';
702 --
703 Begin
704 hr_utility.set_location('Entering:'||l_proc, 5);
705 --
706 -- Call conversion function to turn arguments into the
707 -- l_rec structure.
708 --
709 l_rec :=
710 hr_int_shd.convert_args
711 (p_integration_id
712 ,hr_api.g_varchar2
713 ,p_party_type
714 ,p_party_name
715 ,p_party_site_name
716 ,p_transaction_type
717 ,p_transaction_subtype
718 ,p_standard_code
719 ,p_ext_trans_type
720 ,p_ext_trans_subtype
721 ,p_trans_direction
722 ,p_url
723 ,p_synched
724 ,p_ext_application_id
725 ,p_application_name
726 ,p_application_type
727 ,p_application_url
728 ,p_logout_url
729 ,p_user_field
730 ,p_password_field
731 ,p_authentication_needed
732 ,p_field_name1
733 ,p_field_value1
734 ,p_field_name2
735 ,p_field_value2
736 ,p_field_name3
737 ,p_field_value3
738 ,p_field_name4
739 ,p_field_value4
740 ,p_field_name5
741 ,p_field_value5
742 ,p_field_name6
743 ,p_field_value6
744 ,p_field_name7
745 ,p_field_value7
746 ,p_field_name8
747 ,p_field_value8
748 ,p_field_name9
749 ,p_field_value9
750 ,p_object_version_number
751 );
752 --
753 -- Having converted the arguments into the
754 -- plsql record structure we call the corresponding record
755 -- business process.
756 --
757 hr_int_upd.upd
758 (l_rec
759 );
760 p_object_version_number := l_rec.object_version_number;
761 --
762 hr_utility.set_location(' Leaving:'||l_proc, 10);
763 End upd;
764 --
765 end hr_int_upd;