DBA Data[Home] [Help]

APPS.HR_INT_UPD dependencies on HR_API

Line 118: When hr_api.check_integrity_violated Then

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

Line 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

Line 123: When hr_api.parent_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));

Line 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

Line 128: When hr_api.unique_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));

Line 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;

Line 384: when hr_api.cannot_find_prog_unit then

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

Line 386: hr_api.cannot_find_prog_unit_error

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;

Line 449: If (p_rec.integration_key = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 661: ,p_synched in varchar2 default hr_api.g_varchar2

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

Line 662: ,p_party_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

Line 663: ,p_party_name 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

Line 664: ,p_party_site_name 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

Line 665: ,p_transaction_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

Line 666: ,p_transaction_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

Line 667: ,p_standard_code 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

Line 668: ,p_ext_trans_type 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

Line 669: ,p_ext_trans_subtype 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

Line 670: ,p_trans_direction 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

Line 671: ,p_url 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

Line 672: ,p_ext_application_id in number default hr_api.g_number

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

Line 673: ,p_application_name 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

Line 674: ,p_application_type 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

Line 675: ,p_application_url 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

Line 676: ,p_logout_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

Line 677: ,p_user_field 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

Line 678: ,p_password_field 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

Line 679: ,p_authentication_needed 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

Line 680: ,p_field_name1 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

Line 681: ,p_field_value1 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

Line 682: ,p_field_name2 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

Line 683: ,p_field_value2 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

Line 684: ,p_field_name3 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

Line 685: ,p_field_value3 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

Line 686: ,p_field_name4 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

Line 687: ,p_field_value4 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

Line 688: ,p_field_name5 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

Line 689: ,p_field_value5 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

Line 690: ,p_field_name6 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

Line 691: ,p_field_value6 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

Line 692: ,p_field_name7 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

Line 693: ,p_field_value7 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

Line 694: ,p_field_name8 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

Line 695: ,p_field_value8 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: --

Line 696: ,p_field_name9 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;

Line 697: ,p_field_value9 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';

Line 712: ,hr_api.g_varchar2

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