APPS.PER_PAR_BUS dependencies on HR_API

Line 74: hr_api.argument_changed_error

70: hr_utility.set_location(l_proc, 11);
71: --
72: exception
73: when l_error then
74: hr_api.argument_changed_error
75: (p_api_name => l_proc
76: ,p_argument => l_argument
77: ,p_base_table => per_par_shd.g_tab_nam);
78: when others then

Line 303: (hr_api.not_exists_in_hr_lookups

299: hr_utility.set_message(801,'PER_52466_PAR_TYPE_VAL_EXISTS');
300: hr_utility.raise_error;
301: else
302: if (p_participation_type <> null) and
303: (hr_api.not_exists_in_hr_lookups
304: (p_effective_date => p_effective_date
305: ,p_lookup_type => 'PARTICIPATION_TYPE'
306: ,p_lookup_code => p_participation_type
307: )) then

Line 366: (hr_api.not_exists_in_hr_lookups

362: --
363: hr_utility.set_location('Entering: '||l_proc,10);
364: --
365: if (p_participation_status <> null) and
366: (hr_api.not_exists_in_hr_lookups
367: (p_effective_date => p_effective_date
368: ,p_lookup_type => 'PARTICIPANT_ACCESS'
369: ,p_lookup_code => p_participation_status
370: )) then

Line 609: hr_api.mandatory_arg_error

605: end if;
606: --
607: -- Check mandatory parameters have been set
608: --
609: hr_api.mandatory_arg_error
610: (p_api_name => l_proc
611: ,p_argument => 'participation_in_table'
612: ,p_argument_value => p_participation_in_table
613: );

Line 616: hr_api.mandatory_arg_error

612: ,p_argument_value => p_participation_in_table
613: );
614: --
615: --
616: hr_api.mandatory_arg_error
617: (p_api_name => l_proc
618: ,p_argument => 'participation_in_column'
619: ,p_argument_value => p_participation_in_column
620: );

Line 813: effective_start_date and nvl(effective_end_date,hr_api.g_eot);

809: select 'Y'
810: from per_all_people_f
811: where person_id = p_person_id
812: and p_effective_date between
813: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
814:
815: -- Bug 1980440 fix
816: -- Cursor to check if person is valid as of effective date
817: -- this cursor uses per_all_people_f to support Cross Business Group

Line 825: effective_start_date and nvl(effective_end_date,hr_api.g_eot);

821: select 'Y'
822: from per_all_people_f
823: where person_id = p_person_id
824: and p_effective_date between
825: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
826:
827: --
828: -- Cursor to check if person id is unique for the
829: -- combination of participation_in_table, participation_in_column

Line 855: hr_api.mandatory_arg_error

851: end if;
852: --
853: -- Check mandatory parameters have been set
854: --
855: hr_api.mandatory_arg_error
856: (p_api_name => l_proc
857: ,p_argument => 'effective_date'
858: ,p_argument_value => p_effective_date
859: );

Line 863: hr_api.mandatory_arg_error

859: );
860: --
861: -- Check mandatory parameters have been set
862: --
863: hr_api.mandatory_arg_error
864: (p_api_name => l_proc
865: ,p_argument => 'participation_in_table'
866: ,p_argument_value => p_participation_in_table
867: );

Line 872: hr_api.mandatory_arg_error

868: --
869: --
870: -- Check mandatory parameters have been set
871: --
872: hr_api.mandatory_arg_error
873: (p_api_name => l_proc
874: ,p_argument => 'participation_in_column'
875: ,p_argument_value => p_participation_in_column
876: );

Line 881: hr_api.mandatory_arg_error

877: --
878: --
879: -- Check mandatory parameters have been set
880: --
881: hr_api.mandatory_arg_error
882: (p_api_name => l_proc
883: ,p_argument => 'participation_in_id'
884: ,p_argument_value => p_participation_in_id
885: );

Line 903: hr_api.g_number)

899: (p_participant_id => p_participant_id
900: ,p_object_version_number => p_object_version_number);
901: --
902: if ( (l_api_updating and nvl(per_par_shd.g_old_rec.person_id,
903: hr_api.g_number)
904: <> nvl(p_person_id,hr_api.g_number)
905: ) or
906: (NOT l_api_updating)
907: ) then

Line 904: <> nvl(p_person_id,hr_api.g_number)

900: ,p_object_version_number => p_object_version_number);
901: --
902: if ( (l_api_updating and nvl(per_par_shd.g_old_rec.person_id,
903: hr_api.g_number)
904: <> nvl(p_person_id,hr_api.g_number)
905: ) or
906: (NOT l_api_updating)
907: ) then
908: --

Line 1033: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1029: begin
1030: hr_utility.set_location('Entering:'||l_proc, 10);
1031: --
1032: if ((p_rec.participant_id is not null) and (
1033: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1034: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

1030: hr_utility.set_location('Entering:'||l_proc, 10);
1031: --
1032: if ((p_rec.participant_id is not null) and (
1033: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1035: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1031: --
1032: if ((p_rec.participant_id is not null) and (
1033: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1036: nvl(p_rec.attribute1, hr_api.g_varchar2) or

1032: if ((p_rec.participant_id is not null) and (
1033: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1033: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or

1034: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1035: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or

1036: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1037: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or

1038: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1039: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or

1040: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1041: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or

1042: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1043: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or

1044: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1045: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or

1046: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1047: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or

1048: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1049: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or

1050: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1051: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or

1052: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1053: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or

1054: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1055: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or

1056: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1057: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or

1058: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1059: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or

1060: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1061: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or

1062: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1063: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1071: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or

1064: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1071: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1065: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1071: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1073: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or

1066: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1071: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1073: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1071: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1067: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1071: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1073: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1075: or

Line 1072: nvl(p_rec.attribute19, hr_api.g_varchar2) or

1068: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1071: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1073: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1075: or
1076: (p_rec.participant_id is null) then

Line 1073: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1069: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1071: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1073: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1075: or
1076: (p_rec.participant_id is null) then
1077: --

Line 1074: nvl(p_rec.attribute20, hr_api.g_varchar2)))

1070: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1071: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1072: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1073: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1074: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1075: or
1076: (p_rec.participant_id is null) then
1077: --
1078: -- Only execute the validation if absolutely necessary:

Line 1189: AND nvl(per_par_shd.g_old_rec.participant_usage_status, hr_api.g_varchar2)

1185: (p_participant_id => p_participant_id
1186: ,p_object_version_number => p_object_version_number);
1187: --
1188: IF (l_api_updating
1189: AND nvl(per_par_shd.g_old_rec.participant_usage_status, hr_api.g_varchar2)
1190: = nvl(p_participant_usage_status, hr_api.g_varchar2))
1191: THEN
1192: RETURN;
1193: END IF;

Line 1190: = nvl(p_participant_usage_status, hr_api.g_varchar2))

1186: ,p_object_version_number => p_object_version_number);
1187: --
1188: IF (l_api_updating
1189: AND nvl(per_par_shd.g_old_rec.participant_usage_status, hr_api.g_varchar2)
1190: = nvl(p_participant_usage_status, hr_api.g_varchar2))
1191: THEN
1192: RETURN;
1193: END IF;
1194:

Line 1200: IF hr_api.not_exists_in_hr_lookups

1196: --
1197: -- Check that oparticipant_usage_status is valid.
1198: --
1199: hr_utility.set_location(l_proc, 20);
1200: IF hr_api.not_exists_in_hr_lookups
1201: (p_effective_date => p_effective_date
1202: ,p_lookup_type => 'APPRAISAL_OFFLINE_STATUS'
1203: ,p_lookup_code => upper(p_participant_usage_status)
1204: ) THEN

Line 1244: hr_api.validate_bus_grp_id(p_rec.business_group_id

1240: hr_utility.set_location('Entering:'||l_proc, 5);
1241: --
1242: -- Call all supporting business operations
1243: --
1244: hr_api.validate_bus_grp_id(p_rec.business_group_id
1245: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1246: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1247: hr_multi_message.end_validation_set;
1248: --

Line 1329: hr_api.validate_bus_grp_id(p_rec.business_group_id

1325: --
1326: -- Call all supporting business operations
1327: --
1328: --
1329: hr_api.validate_bus_grp_id(p_rec.business_group_id
1330: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1331: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1332:
1333: hr_multi_message.end_validation_set;

Line 1373: hr_api.validate_bus_grp_id(p_rec.business_group_id

1369: );
1370: --
1371: hr_utility.set_location(l_proc, 5);
1372: --
1373: hr_api.validate_bus_grp_id(p_rec.business_group_id
1374: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1375: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1376:
1377: hr_multi_message.end_validation_set;

Line 1433: hr_api.mandatory_arg_error (p_api_name => l_proc,

1429: hr_utility.set_location('Entering:'||l_proc, 5);
1430: --
1431: -- Ensure that all the mandatory parameters are not null
1432: --
1433: hr_api.mandatory_arg_error (p_api_name => l_proc,
1434: p_argument => 'participant_id',
1435: p_argument_value => p_participant_id );
1436: --
1437: if nvl(g_participant_id, hr_api.g_number) = p_participant_id then

Line 1437: if nvl(g_participant_id, hr_api.g_number) = p_participant_id then

1433: hr_api.mandatory_arg_error (p_api_name => l_proc,
1434: p_argument => 'participant_id',
1435: p_argument_value => p_participant_id );
1436: --
1437: if nvl(g_participant_id, hr_api.g_number) = p_participant_id then
1438: --
1439: -- The legislation code has already been found with a previous
1440: -- call to this function. Just return the value in the global
1441: -- variable.