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 601: hr_api.mandatory_arg_error

597: end if;
598: --
599: -- Check mandatory parameters have been set
600: --
601: hr_api.mandatory_arg_error
602: (p_api_name => l_proc
603: ,p_argument => 'participation_in_table'
604: ,p_argument_value => p_participation_in_table
605: );

Line 608: hr_api.mandatory_arg_error

604: ,p_argument_value => p_participation_in_table
605: );
606: --
607: --
608: hr_api.mandatory_arg_error
609: (p_api_name => l_proc
610: ,p_argument => 'participation_in_column'
611: ,p_argument_value => p_participation_in_column
612: );

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

801: select 'Y'
802: from per_all_people_f
803: where person_id = p_person_id
804: and p_effective_date between
805: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
806:
807: -- Bug 1980440 fix
808: -- Cursor to check if person is valid as of effective date
809: -- this cursor uses per_all_people_f to support Cross Business Group

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

813: select 'Y'
814: from per_all_people_f
815: where person_id = p_person_id
816: and p_effective_date between
817: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
818:
819: --
820: -- Cursor to check if person id is unique for the
821: -- combination of participation_in_table, participation_in_column

Line 847: hr_api.mandatory_arg_error

843: end if;
844: --
845: -- Check mandatory parameters have been set
846: --
847: hr_api.mandatory_arg_error
848: (p_api_name => l_proc
849: ,p_argument => 'effective_date'
850: ,p_argument_value => p_effective_date
851: );

Line 855: hr_api.mandatory_arg_error

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

Line 864: hr_api.mandatory_arg_error

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

Line 873: hr_api.mandatory_arg_error

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

Line 895: hr_api.g_number)

891: (p_participant_id => p_participant_id
892: ,p_object_version_number => p_object_version_number);
893: --
894: if ( (l_api_updating and nvl(per_par_shd.g_old_rec.person_id,
895: hr_api.g_number)
896: <> nvl(p_person_id,hr_api.g_number)
897: ) or
898: (NOT l_api_updating)
899: ) then

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

892: ,p_object_version_number => p_object_version_number);
893: --
894: if ( (l_api_updating and nvl(per_par_shd.g_old_rec.person_id,
895: hr_api.g_number)
896: <> nvl(p_person_id,hr_api.g_number)
897: ) or
898: (NOT l_api_updating)
899: ) then
900: --

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

1021: begin
1022: hr_utility.set_location('Entering:'||l_proc, 10);
1023: --
1024: if ((p_rec.participant_id is not null) and (
1025: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1022: hr_utility.set_location('Entering:'||l_proc, 10);
1023: --
1024: if ((p_rec.participant_id is not null) and (
1025: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

1023: --
1024: if ((p_rec.participant_id is not null) and (
1025: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1024: if ((p_rec.participant_id is not null) and (
1025: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

1025: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1026: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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

1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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

1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute20, hr_api.g_varchar2)))

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

1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1067: or

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

1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1067: or
1068: (p_rec.participant_id is null) then

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

1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1067: or
1068: (p_rec.participant_id is null) then
1069: --

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

1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1067: or
1068: (p_rec.participant_id is null) then
1069: --
1070: -- Only execute the validation if absolutely necessary:

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

1177: (p_participant_id => p_participant_id
1178: ,p_object_version_number => p_object_version_number);
1179: --
1180: IF (l_api_updating
1181: AND nvl(per_par_shd.g_old_rec.participant_usage_status, hr_api.g_varchar2)
1182: = nvl(p_participant_usage_status, hr_api.g_varchar2))
1183: THEN
1184: RETURN;
1185: END IF;

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

1178: ,p_object_version_number => p_object_version_number);
1179: --
1180: IF (l_api_updating
1181: AND nvl(per_par_shd.g_old_rec.participant_usage_status, hr_api.g_varchar2)
1182: = nvl(p_participant_usage_status, hr_api.g_varchar2))
1183: THEN
1184: RETURN;
1185: END IF;
1186:

Line 1192: IF hr_api.not_exists_in_hr_lookups

1188: --
1189: -- Check that oparticipant_usage_status is valid.
1190: --
1191: hr_utility.set_location(l_proc, 20);
1192: IF hr_api.not_exists_in_hr_lookups
1193: (p_effective_date => p_effective_date
1194: ,p_lookup_type => 'APPRAISAL_OFFLINE_STATUS'
1195: ,p_lookup_code => upper(p_participant_usage_status)
1196: ) THEN

Line 1236: hr_api.validate_bus_grp_id(p_rec.business_group_id

1232: hr_utility.set_location('Entering:'||l_proc, 5);
1233: --
1234: -- Call all supporting business operations
1235: --
1236: hr_api.validate_bus_grp_id(p_rec.business_group_id
1237: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1238: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1239: hr_multi_message.end_validation_set;
1240: --

Line 1321: hr_api.validate_bus_grp_id(p_rec.business_group_id

1317: --
1318: -- Call all supporting business operations
1319: --
1320: --
1321: hr_api.validate_bus_grp_id(p_rec.business_group_id
1322: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1323: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1324:
1325: hr_multi_message.end_validation_set;

Line 1365: hr_api.validate_bus_grp_id(p_rec.business_group_id

1361: );
1362: --
1363: hr_utility.set_location(l_proc, 5);
1364: --
1365: hr_api.validate_bus_grp_id(p_rec.business_group_id
1366: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1367: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1368:
1369: hr_multi_message.end_validation_set;

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

1421: hr_utility.set_location('Entering:'||l_proc, 5);
1422: --
1423: -- Ensure that all the mandatory parameters are not null
1424: --
1425: hr_api.mandatory_arg_error (p_api_name => l_proc,
1426: p_argument => 'participant_id',
1427: p_argument_value => p_participant_id );
1428: --
1429: if nvl(g_participant_id, hr_api.g_number) = p_participant_id then

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

1425: hr_api.mandatory_arg_error (p_api_name => l_proc,
1426: p_argument => 'participant_id',
1427: p_argument_value => p_participant_id );
1428: --
1429: if nvl(g_participant_id, hr_api.g_number) = p_participant_id then
1430: --
1431: -- The legislation code has already been found with a previous
1432: -- call to this function. Just return the value in the global
1433: -- variable.