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));
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
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));
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
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));
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;
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');
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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;
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';
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