eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_POS_BUS dependencies on HR_API

Line 39: if nvl(p_rec.business_group_id, hr_api.g_number) <>

35: hr_utility.set_message_token('STEP', '20');
36: END IF;
37: hr_utility.set_location(l_proc, 30);
38: --
39: if nvl(p_rec.business_group_id, hr_api.g_number) <>
40: nvl(per_pos_shd.g_old_rec.business_group_id
41: ,hr_api.g_number
42: ) then
43: l_argument := 'business_group_id';

Line 41: ,hr_api.g_number

37: hr_utility.set_location(l_proc, 30);
38: --
39: if nvl(p_rec.business_group_id, hr_api.g_number) <>
40: nvl(per_pos_shd.g_old_rec.business_group_id
41: ,hr_api.g_number
42: ) then
43: l_argument := 'business_group_id';
44: raise l_error;
45: end if;

Line 48: if nvl(p_rec.job_id, hr_api.g_number) <>

44: raise l_error;
45: end if;
46: --
47: --
48: if nvl(p_rec.job_id, hr_api.g_number) <>
49: nvl(per_pos_shd.g_old_rec.job_id
50: ,hr_api.g_number
51: ) then
52: l_argument := 'job_id';

Line 50: ,hr_api.g_number

46: --
47: --
48: if nvl(p_rec.job_id, hr_api.g_number) <>
49: nvl(per_pos_shd.g_old_rec.job_id
50: ,hr_api.g_number
51: ) then
52: l_argument := 'job_id';
53: raise l_error;
54: end if;

Line 57: if nvl(p_rec.organization_id, hr_api.g_number) <>

53: raise l_error;
54: end if;
55: --
56: --
57: if nvl(p_rec.organization_id, hr_api.g_number) <>
58: nvl(per_pos_shd.g_old_rec.organization_id
59: ,hr_api.g_number
60: ) then
61: l_argument := 'organization_id';

Line 59: ,hr_api.g_number

55: --
56: --
57: if nvl(p_rec.organization_id, hr_api.g_number) <>
58: nvl(per_pos_shd.g_old_rec.organization_id
59: ,hr_api.g_number
60: ) then
61: l_argument := 'organization_id';
62: raise l_error;
63: end if;

Line 68: hr_api.argument_changed_error

64: --
65: hr_utility.set_location(l_proc, 40);
66: exception
67: when l_error then
68: hr_api.argument_changed_error
69: (p_api_name => l_proc
70: ,p_argument => l_argument
71: );
72: when others then

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

104: hr_utility.set_location('Entering:'|| l_proc, 10);
105: --
106: -- Ensure that all the mandatory parameter are not null
107: --
108: hr_api.mandatory_arg_error(p_api_name => l_proc,
109: p_argument => 'position_id',
110: p_argument_value => p_position_id);
111: --
112: open csr_sec_grp;

Line 126: hr_api.set_security_group_id

122: close csr_sec_grp;
123: --
124: -- Set the security_group_id in CLIENT_INFO
125: --
126: hr_api.set_security_group_id
127: (p_security_group_id => l_security_group_id
128: );
129: --
130: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 190: and nvl(job.date_to,hr_api.g_eot);

186: select 'x'
187: from per_jobs job
188: where job.job_id = p_job_id
189: and p_date_effective between job.date_from
190: and nvl(job.date_to,hr_api.g_eot);
191: --
192: begin
193: hr_utility.set_location('Entering:'||l_proc, 1);
194: --

Line 197: hr_api.mandatory_arg_error

193: hr_utility.set_location('Entering:'||l_proc, 1);
194: --
195: -- Check mandatory parameters have been set
196: --
197: hr_api.mandatory_arg_error
198: (p_api_name => l_proc
199: ,p_argument => 'job_id'
200: ,p_argument_value => p_job_id
201: );

Line 291: and nvl(oru.date_to,hr_api.g_eot);

287: select 'x'
288: from hr_organization_units oru
289: where oru.organization_id = p_organization_id
290: and p_date_effective between oru.date_from
291: and nvl(oru.date_to,hr_api.g_eot);
292: --
293: begin
294: hr_utility.set_location('Entering:'||l_proc, 1);
295: --

Line 298: hr_api.mandatory_arg_error

294: hr_utility.set_location('Entering:'||l_proc, 1);
295: --
296: -- Check mandatory parameters have been set
297: --
298: hr_api.mandatory_arg_error
299: (p_api_name => l_proc
300: ,p_argument => 'organization_id'
301: ,p_argument_value => p_organization_id
302: );

Line 382: and nvl(pos.date_end,hr_api.g_eot) >= p_date_effective ;

378: select 'x'
379: from per_positions pos
380: where pos.position_id = p_successor_position_id
381: and pos.business_group_id + 0 = p_business_group_id
382: and nvl(pos.date_end,hr_api.g_eot) >= p_date_effective ;
383: --
384: begin
385: hr_utility.set_location('Entering:'||l_proc, 1);
386: --

Line 393: hr_api.mandatory_arg_error

389: -- b) The successor_position_id value has changed
390: --
391: if p_successor_position_id is not null then
392: --
393: hr_api.mandatory_arg_error
394: (p_api_name => l_proc
395: ,p_argument => 'date effective'
396: ,p_argument_value => p_date_effective);
397: --

Line 479: and nvl(pos.date_end,hr_api.g_eot) >= p_date_effective ;

475: select 'x'
476: from per_positions pos
477: where pos.position_id = p_relief_position_id
478: and pos.business_group_id + 0 = p_business_group_id
479: and nvl(pos.date_end,hr_api.g_eot) >= p_date_effective ;
480: --
481: begin
482: hr_utility.set_location('Entering:'||l_proc, 1);
483: --

Line 490: hr_api.mandatory_arg_error

486: -- b) The successor_position_id value has changed
487: --
488: if p_relief_position_id is not null then
489: --
490: hr_api.mandatory_arg_error
491: (p_api_name => l_proc
492: ,p_argument => 'date effective'
493: ,p_argument_value => p_date_effective);
494: --

Line 584: hr_api.g_eot);

580: select 'x'
581: from hr_locations loc
582: where loc.location_id = p_location_id
583: and p_date_effective < nvl(loc.inactive_date,
584: hr_api.g_eot);
585: --
586: begin
587: hr_utility.set_location('Entering:'||l_proc, 1);
588: --

Line 598: nvl(per_pos_shd.g_old_rec.location_id,hr_api.g_number) <>

594: (p_position_id => p_position_id
595: ,p_object_version_number => p_object_version_number);
596: --
597: if ((l_api_updating and
598: nvl(per_pos_shd.g_old_rec.location_id,hr_api.g_number) <>
599: nvl(p_location_id,hr_api.g_number)) or
600: (NOT l_api_updating)) then
601: --
602: -- Validate that location id is valid for p_date_effective

Line 599: nvl(p_location_id,hr_api.g_number)) or

595: ,p_object_version_number => p_object_version_number);
596: --
597: if ((l_api_updating and
598: nvl(per_pos_shd.g_old_rec.location_id,hr_api.g_number) <>
599: nvl(p_location_id,hr_api.g_number)) or
600: (NOT l_api_updating)) then
601: --
602: -- Validate that location id is valid for p_date_effective
603: --

Line 665: hr_api.mandatory_arg_error

661: hr_utility.set_location('Entering:'||l_proc, 1);
662: --
663: -- Check mandatory parameters have been set
664: --
665: hr_api.mandatory_arg_error
666: (p_api_name => l_proc
667: ,p_argument => 'position_definition_id'
668: ,p_argument_value => p_position_definition_id
669: );

Line 746: hr_api.mandatory_arg_error

742: hr_utility.set_location('Entering:'||l_proc, 1);
743: --
744: -- Check mandatory parameters have been set
745: --
746: hr_api.mandatory_arg_error
747: (p_api_name => l_proc
748: ,p_argument => 'date_effective'
749: ,p_argument_value => p_date_effective
750: );

Line 770: if p_date_effective > nvl(p_date_end,hr_api.g_eot) then

766: -- Check that date_effective <= date_end
767: --
768: hr_utility.set_location(l_proc, 3);
769: --
770: if p_date_effective > nvl(p_date_end,hr_api.g_eot) then
771: hr_utility.set_message(801,'HR_51362_POS_INVAL_EFF_DATE');
772: hr_utility.raise_error;
773: end if;
774: --

Line 860: (nvl(per_pos_shd.g_old_rec.working_hours,hr_api.g_number) <>

856: (p_position_id => p_position_id
857: ,p_object_version_number => p_object_version_number);
858: --
859: if ((l_api_updating and
860: (nvl(per_pos_shd.g_old_rec.working_hours,hr_api.g_number) <>
861: nvl(p_working_hours,hr_api.g_number) or
862: (nvl(per_pos_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
863: nvl(p_frequency,hr_api.g_varchar2)))) or
864: (NOT l_api_updating)) then

Line 861: nvl(p_working_hours,hr_api.g_number) or

857: ,p_object_version_number => p_object_version_number);
858: --
859: if ((l_api_updating and
860: (nvl(per_pos_shd.g_old_rec.working_hours,hr_api.g_number) <>
861: nvl(p_working_hours,hr_api.g_number) or
862: (nvl(per_pos_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
863: nvl(p_frequency,hr_api.g_varchar2)))) or
864: (NOT l_api_updating)) then
865: --

Line 862: (nvl(per_pos_shd.g_old_rec.frequency,hr_api.g_varchar2) <>

858: --
859: if ((l_api_updating and
860: (nvl(per_pos_shd.g_old_rec.working_hours,hr_api.g_number) <>
861: nvl(p_working_hours,hr_api.g_number) or
862: (nvl(per_pos_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
863: nvl(p_frequency,hr_api.g_varchar2)))) or
864: (NOT l_api_updating)) then
865: --
866: -- Check for values consistency

Line 863: nvl(p_frequency,hr_api.g_varchar2)))) or

859: if ((l_api_updating and
860: (nvl(per_pos_shd.g_old_rec.working_hours,hr_api.g_number) <>
861: nvl(p_working_hours,hr_api.g_number) or
862: (nvl(per_pos_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
863: nvl(p_frequency,hr_api.g_varchar2)))) or
864: (NOT l_api_updating)) then
865: --
866: -- Check for values consistency
867: --

Line 974: (nvl(per_pos_shd.g_old_rec.probation_period,hr_api.g_number) <>

970: (p_position_id => p_position_id
971: ,p_object_version_number => p_object_version_number);
972: --
973: if ((l_api_updating and
974: (nvl(per_pos_shd.g_old_rec.probation_period,hr_api.g_number) <>
975: nvl(p_probation_period,hr_api.g_number)) or
976: (nvl(per_pos_shd.g_old_rec.probation_period_units,hr_api.g_varchar2) <>
977: nvl(p_probation_period_units,hr_api.g_varchar2))) or
978: (NOT l_api_updating)) then

Line 975: nvl(p_probation_period,hr_api.g_number)) or

971: ,p_object_version_number => p_object_version_number);
972: --
973: if ((l_api_updating and
974: (nvl(per_pos_shd.g_old_rec.probation_period,hr_api.g_number) <>
975: nvl(p_probation_period,hr_api.g_number)) or
976: (nvl(per_pos_shd.g_old_rec.probation_period_units,hr_api.g_varchar2) <>
977: nvl(p_probation_period_units,hr_api.g_varchar2))) or
978: (NOT l_api_updating)) then
979: --

Line 976: (nvl(per_pos_shd.g_old_rec.probation_period_units,hr_api.g_varchar2) <>

972: --
973: if ((l_api_updating and
974: (nvl(per_pos_shd.g_old_rec.probation_period,hr_api.g_number) <>
975: nvl(p_probation_period,hr_api.g_number)) or
976: (nvl(per_pos_shd.g_old_rec.probation_period_units,hr_api.g_varchar2) <>
977: nvl(p_probation_period_units,hr_api.g_varchar2))) or
978: (NOT l_api_updating)) then
979: --
980: -- Check for values consistency

Line 977: nvl(p_probation_period_units,hr_api.g_varchar2))) or

973: if ((l_api_updating and
974: (nvl(per_pos_shd.g_old_rec.probation_period,hr_api.g_number) <>
975: nvl(p_probation_period,hr_api.g_number)) or
976: (nvl(per_pos_shd.g_old_rec.probation_period_units,hr_api.g_varchar2) <>
977: nvl(p_probation_period_units,hr_api.g_varchar2))) or
978: (NOT l_api_updating)) then
979: --
980: -- Check for values consistency
981: --

Line 1071: (nvl(per_pos_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2) <>

1067: (p_position_id => p_position_id
1068: ,p_object_version_number => p_object_version_number);
1069: --
1070: if ((l_api_updating and
1071: (nvl(per_pos_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2) <>
1072: nvl(p_replacement_required_flag,hr_api.g_varchar2))) or
1073: (NOT l_api_updating)) then
1074: --
1075: -- Validate flag replacement_required_flag against fnd_common_lookups

Line 1072: nvl(p_replacement_required_flag,hr_api.g_varchar2))) or

1068: ,p_object_version_number => p_object_version_number);
1069: --
1070: if ((l_api_updating and
1071: (nvl(per_pos_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2) <>
1072: nvl(p_replacement_required_flag,hr_api.g_varchar2))) or
1073: (NOT l_api_updating)) then
1074: --
1075: -- Validate flag replacement_required_flag against fnd_common_lookups
1076: --

Line 1155: (nvl(per_pos_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>

1151: (p_position_id => p_position_id
1152: ,p_object_version_number => p_object_version_number);
1153: --
1154: if ((l_api_updating and
1155: (nvl(per_pos_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
1156: nvl(p_time_normal_start,hr_api.g_varchar2) or
1157: (nvl(per_pos_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
1158: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
1159: (NOT l_api_updating)) then

Line 1156: nvl(p_time_normal_start,hr_api.g_varchar2) or

1152: ,p_object_version_number => p_object_version_number);
1153: --
1154: if ((l_api_updating and
1155: (nvl(per_pos_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
1156: nvl(p_time_normal_start,hr_api.g_varchar2) or
1157: (nvl(per_pos_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
1158: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
1159: (NOT l_api_updating)) then
1160: --

Line 1157: (nvl(per_pos_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>

1153: --
1154: if ((l_api_updating and
1155: (nvl(per_pos_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
1156: nvl(p_time_normal_start,hr_api.g_varchar2) or
1157: (nvl(per_pos_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
1158: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
1159: (NOT l_api_updating)) then
1160: --
1161: -- Check for values consistency

Line 1158: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or

1154: if ((l_api_updating and
1155: (nvl(per_pos_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
1156: nvl(p_time_normal_start,hr_api.g_varchar2) or
1157: (nvl(per_pos_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
1158: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
1159: (NOT l_api_updating)) then
1160: --
1161: -- Check for values consistency
1162: --

Line 1256: (nvl(per_pos_shd.g_old_rec.status,hr_api.g_varchar2) <>

1252: (p_position_id => p_position_id
1253: ,p_object_version_number => p_object_version_number);
1254: --
1255: if ((l_api_updating and
1256: (nvl(per_pos_shd.g_old_rec.status,hr_api.g_varchar2) <>
1257: nvl(p_status,hr_api.g_varchar2))) or
1258: (NOT l_api_updating)) then
1259: --
1260: -- Check for valid status against fnd_common_lookups

Line 1257: nvl(p_status,hr_api.g_varchar2))) or

1253: ,p_object_version_number => p_object_version_number);
1254: --
1255: if ((l_api_updating and
1256: (nvl(per_pos_shd.g_old_rec.status,hr_api.g_varchar2) <>
1257: nvl(p_status,hr_api.g_varchar2))) or
1258: (NOT l_api_updating)) then
1259: --
1260: -- Check for valid status against fnd_common_lookups
1261: --

Line 1265: hr_api.not_exists_in_hr_lookups

1261: --
1262: hr_utility.set_location(l_proc, 2);
1263: --
1264: if p_status is not null and
1265: hr_api.not_exists_in_hr_lookups
1266: (p_effective_date => p_date_effective
1267: ,p_lookup_type => 'POSITION_STATUS'
1268: ,p_lookup_code => p_status
1269: )

Line 1315: nvl(per_pos_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1311: begin
1312: hr_utility.set_location('Entering:'||l_proc, 10);
1313: --
1314: if ((p_rec.position_id is not null) and (
1315: nvl(per_pos_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1316: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1312: hr_utility.set_location('Entering:'||l_proc, 10);
1313: --
1314: if ((p_rec.position_id is not null) and (
1315: nvl(per_pos_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1316: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1313: --
1314: if ((p_rec.position_id is not null) and (
1315: nvl(per_pos_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1316: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1314: if ((p_rec.position_id is not null) and (
1315: nvl(per_pos_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1316: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1315: nvl(per_pos_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1316: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1316: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1356: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1356: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1357: or

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

1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1356: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1357: or
1358: (p_rec.position_id is null) then

Line 1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1356: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1357: or
1358: (p_rec.position_id is null) then
1359: --

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

1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1356: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1357: or
1358: (p_rec.position_id is null) then
1359: --
1360: -- Only execute the validation if absolutely necessary:

Line 1484: hr_api.mandatory_arg_error

1480: --end if;
1481: --
1482: -- Check mandatory parameters have been set
1483: --
1484: hr_api.mandatory_arg_error
1485: (p_api_name => l_proc
1486: ,p_argument => 'business_group_id'
1487: ,p_argument_value => p_business_group_id
1488: );

Line 1493: hr_api.mandatory_arg_error

1489: --if g_debug then
1490: hr_utility.set_location(l_proc, 20);
1491: --end if;
1492: --
1493: hr_api.mandatory_arg_error
1494: (p_api_name => l_proc
1495: ,p_argument => 'position_definition_id'
1496: ,p_argument_value => p_position_definition_id
1497: );

Line 1511: (nvl(per_pos_shd.g_old_rec.position_definition_id, hr_api.g_number)

1507: hr_utility.set_location(l_proc, 70);
1508: --end if;
1509: --
1510: if (l_api_updating and
1511: (nvl(per_pos_shd.g_old_rec.position_definition_id, hr_api.g_number)
1512: <> nvl(p_position_definition_id, hr_api.g_number))
1513: )
1514: or NOT l_api_updating
1515: then

Line 1512: <> nvl(p_position_definition_id, hr_api.g_number))

1508: --end if;
1509: --
1510: if (l_api_updating and
1511: (nvl(per_pos_shd.g_old_rec.position_definition_id, hr_api.g_number)
1512: <> nvl(p_position_definition_id, hr_api.g_number))
1513: )
1514: or NOT l_api_updating
1515: then
1516: --if g_debug then

Line 1596: hr_api.mandatory_arg_error

1592: hr_utility.set_location('Entering:'||l_proc, 1);
1593: --
1594: -- Check mandatory parameters have been set
1595: --
1596: hr_api.mandatory_arg_error
1597: (p_api_name => l_proc
1598: ,p_argument => 'business_group_id'
1599: ,p_argument_value => p_business_group_id
1600: );

Line 1603: hr_api.mandatory_arg_error

1599: ,p_argument_value => p_business_group_id
1600: );
1601: hr_utility.set_location(l_proc, 2);
1602: --
1603: hr_api.mandatory_arg_error
1604: (p_api_name => l_proc
1605: ,p_argument => 'name'
1606: ,p_argument_value => p_name
1607: );

Line 1617: NVL(per_pos_shd.g_old_rec.name,hr_api.g_varchar2)

1613: -- Bug 892165
1614: -- Amended changed this to p_name
1615:
1616: IF ((( p_name IS NOT NULL ) and
1617: NVL(per_pos_shd.g_old_rec.name,hr_api.g_varchar2)
1618: <> NVL(p_name,hr_api.g_varchar2))
1619: OR ( p_name IS NULL)) THEN
1620:
1621: open csr_name_unique;

Line 1618: <> NVL(p_name,hr_api.g_varchar2))

1614: -- Amended changed this to p_name
1615:
1616: IF ((( p_name IS NOT NULL ) and
1617: NVL(per_pos_shd.g_old_rec.name,hr_api.g_varchar2)
1618: <> NVL(p_name,hr_api.g_varchar2))
1619: OR ( p_name IS NULL)) THEN
1620:
1621: open csr_name_unique;
1622: fetch csr_name_unique into l_exists;

Line 1650: hr_api.validate_bus_grp_id(p_rec.business_group_id);

1646: -- Call all supporting business operations
1647: --
1648: -- Validate Business Group
1649: --
1650: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1651: --
1652: hr_utility.set_location(l_proc, 6);
1653: --
1654: --

Line 1802: hr_api.validate_bus_grp_id(p_rec.business_group_id);

1798: hr_utility.set_location('Entering:'||l_proc, 5);
1799: -- Bug 892165
1800: -- Validate Business Group
1801: --
1802: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1803: --
1804: -- Call to chk_non_updateable_args - Bug 892165
1805: --
1806: hr_utility.set_location(l_proc, 6);

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

1975: hr_utility.set_location('Entering:'|| l_proc, 10);
1976: --
1977: -- Ensure that all the mandatory parameter are not null
1978: --
1979: hr_api.mandatory_arg_error(p_api_name => l_proc,
1980: p_argument => 'position_id',
1981: p_argument_value => p_position_id);
1982: --
1983: open csr_leg_code;