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_CTC_BUS dependencies on HR_API

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

64: end if;
65: --
66: hr_utility.set_location(l_proc, 6);
67: --
68: if nvl(p_rec.business_group_id, hr_api.g_number) <>
69: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
70: l_argument := 'business_group_id';
71: raise l_error;
72: end if;

Line 69: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then

65: --
66: hr_utility.set_location(l_proc, 6);
67: --
68: if nvl(p_rec.business_group_id, hr_api.g_number) <>
69: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
70: l_argument := 'business_group_id';
71: raise l_error;
72: end if;
73: hr_utility.set_location(l_proc, 7);

Line 75: if nvl(p_rec.person_id,hr_api.g_number) <>

71: raise l_error;
72: end if;
73: hr_utility.set_location(l_proc, 7);
74: --
75: if nvl(p_rec.person_id,hr_api.g_number) <>
76: nvl(per_asg_shd.g_old_rec.person_id, hr_api.g_number) then
77: l_argument := 'person_id';
78: raise l_error;
79: end if;

Line 76: nvl(per_asg_shd.g_old_rec.person_id, hr_api.g_number) then

72: end if;
73: hr_utility.set_location(l_proc, 7);
74: --
75: if nvl(p_rec.person_id,hr_api.g_number) <>
76: nvl(per_asg_shd.g_old_rec.person_id, hr_api.g_number) then
77: l_argument := 'person_id';
78: raise l_error;
79: end if;
80: --

Line 84: hr_api.argument_changed_error

80: --
81: hr_utility.set_location(l_proc, 8);
82: exception
83: when l_error then
84: hr_api.argument_changed_error
85: (p_api_name => l_proc
86: ,p_argument => l_argument);
87: when others then
88: raise;

Line 141: hr_api.mandatory_arg_error

137: hr_utility.set_location('Entering:'|| l_proc, 1);
138: --
139: -- Check mandatory parameters have been set
140: --
141: hr_api.mandatory_arg_error
142: (p_api_name => l_proc
143: ,p_argument => 'person_id'
144: ,p_argument_value => p_person_id
145: );

Line 224: hr_api.mandatory_arg_error

220: hr_utility.set_location('Entering:'|| l_proc, 1);
221: --
222: -- Check mandatory parameters have been set
223: --
224: hr_api.mandatory_arg_error
225: (p_api_name => l_proc
226: ,p_argument => 'person_id'
227: ,p_argument_value => p_person_id
228: );

Line 230: hr_api.mandatory_arg_error

226: ,p_argument => 'person_id'
227: ,p_argument_value => p_person_id
228: );
229: --
230: hr_api.mandatory_arg_error
231: (p_api_name => l_proc
232: ,p_argument => 'p_datetrack_mode'
233: ,p_argument_value => p_datetrack_mode
234: );

Line 320: hr_api.mandatory_arg_error

316: hr_utility.set_location('Entering:'|| l_proc, 10);
317: --
318: -- Check mandatory parameters have been set
319: --
320: hr_api.mandatory_arg_error
321: (p_api_name => l_proc
322: ,p_argument => 'effective_date'
323: ,p_argument_value => p_effective_date
324: );

Line 326: hr_api.mandatory_arg_error

322: ,p_argument => 'effective_date'
323: ,p_argument_value => p_effective_date
324: );
325: --
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc
328: ,p_argument => 'validation_start_date'
329: ,p_argument_value => p_validation_start_date
330: );

Line 332: hr_api.mandatory_arg_error

328: ,p_argument => 'validation_start_date'
329: ,p_argument_value => p_validation_start_date
330: );
331: --
332: hr_api.mandatory_arg_error
333: (p_api_name => l_proc
334: ,p_argument => 'validation_end_date'
335: ,p_argument_value => p_validation_end_date
336: );

Line 347: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

343: );
344: hr_utility.set_location(l_proc, 30);
345: --
346: if ((l_api_updating and
347: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
348: nvl(p_type, hr_api.g_varchar2))
349: or (NOT l_api_updating))
350: then
351: hr_utility.set_location(l_proc, 40);

Line 348: nvl(p_type, hr_api.g_varchar2))

344: hr_utility.set_location(l_proc, 30);
345: --
346: if ((l_api_updating and
347: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
348: nvl(p_type, hr_api.g_varchar2))
349: or (NOT l_api_updating))
350: then
351: hr_utility.set_location(l_proc, 40);
352: --

Line 360: if hr_api.not_exists_in_dt_hr_lookups

356: -- lookup type 'TYPE' with an enabled flag set to 'Y' and that
357: -- the effective start date of the contract is between start date
358: -- active and end date active in hr_lookups.
359: --
360: if hr_api.not_exists_in_dt_hr_lookups
361: (p_effective_date => p_effective_date
362: ,p_validation_start_date => p_validation_start_date
363: ,p_validation_end_date => p_validation_end_date
364: ,p_lookup_type => 'CONTRACT_TYPE'

Line 434: hr_api.mandatory_arg_error

430: hr_utility.set_location('Entering:'|| l_proc, 10);
431: --
432: -- Check mandatory parameters have been set
433: --
434: hr_api.mandatory_arg_error
435: (p_api_name => l_proc
436: ,p_argument => 'effective_date'
437: ,p_argument_value => p_effective_date
438: );

Line 440: hr_api.mandatory_arg_error

436: ,p_argument => 'effective_date'
437: ,p_argument_value => p_effective_date
438: );
439: --
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc
442: ,p_argument => 'validation_start_date'
443: ,p_argument_value => p_validation_start_date
444: );

Line 446: hr_api.mandatory_arg_error

442: ,p_argument => 'validation_start_date'
443: ,p_argument_value => p_validation_start_date
444: );
445: --
446: hr_api.mandatory_arg_error
447: (p_api_name => l_proc
448: ,p_argument => 'validation_end_date'
449: ,p_argument_value => p_validation_end_date
450: );

Line 461: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

457: );
458: hr_utility.set_location(l_proc, 30);
459: --
460: if ((l_api_updating and
461: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
462: nvl(p_status, hr_api.g_varchar2))
463: or (NOT l_api_updating))
464: then
465: hr_utility.set_location(l_proc, 40);

Line 462: nvl(p_status, hr_api.g_varchar2))

458: hr_utility.set_location(l_proc, 30);
459: --
460: if ((l_api_updating and
461: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
462: nvl(p_status, hr_api.g_varchar2))
463: or (NOT l_api_updating))
464: then
465: hr_utility.set_location(l_proc, 40);
466: --

Line 474: if hr_api.not_exists_in_dt_hr_lookups

470: -- lookup type 'CONTRACT_STATUS' with an enabled flag set to 'Y' and that
471: -- the effective start date of the contract is between start date
472: -- active and end date active in hr_lookups.
473: --
474: if hr_api.not_exists_in_dt_hr_lookups
475: (p_effective_date => p_effective_date
476: ,p_validation_start_date => p_validation_start_date
477: ,p_validation_end_date => p_validation_end_date
478: ,p_lookup_type => 'CONTRACT_STATUS'

Line 548: hr_api.mandatory_arg_error

544: hr_utility.set_location('Entering:'|| l_proc, 10);
545: --
546: -- Check mandatory parameters have been set
547: --
548: hr_api.mandatory_arg_error
549: (p_api_name => l_proc
550: ,p_argument => 'effective_date'
551: ,p_argument_value => p_effective_date
552: );

Line 554: hr_api.mandatory_arg_error

550: ,p_argument => 'effective_date'
551: ,p_argument_value => p_effective_date
552: );
553: --
554: hr_api.mandatory_arg_error
555: (p_api_name => l_proc
556: ,p_argument => 'validation_start_date'
557: ,p_argument_value => p_validation_start_date
558: );

Line 560: hr_api.mandatory_arg_error

556: ,p_argument => 'validation_start_date'
557: ,p_argument_value => p_validation_start_date
558: );
559: --
560: hr_api.mandatory_arg_error
561: (p_api_name => l_proc
562: ,p_argument => 'validation_end_date'
563: ,p_argument_value => p_validation_end_date
564: );

Line 575: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

571: );
572: hr_utility.set_location(l_proc, 30);
573: --
574: if ((l_api_updating and
575: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
576: nvl(p_status_reason, hr_api.g_varchar2))
577: or (NOT l_api_updating))
578: then
579: hr_utility.set_location(l_proc, 40);

Line 576: nvl(p_status_reason, hr_api.g_varchar2))

572: hr_utility.set_location(l_proc, 30);
573: --
574: if ((l_api_updating and
575: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
576: nvl(p_status_reason, hr_api.g_varchar2))
577: or (NOT l_api_updating))
578: then
579: hr_utility.set_location(l_proc, 40);
580: --

Line 588: if hr_api.not_exists_in_dt_hr_lookups

584: -- lookup type 'CONTRACT_STATUS_REASON' with an enabled flag set to 'Y' and that
585: -- the effective start date of the contract is between start date
586: -- active and end date active in hr_lookups.
587: --
588: if hr_api.not_exists_in_dt_hr_lookups
589: (p_effective_date => p_effective_date
590: ,p_validation_start_date => p_validation_start_date
591: ,p_validation_end_date => p_validation_end_date
592: ,p_lookup_type => 'CONTRACT_STATUS_REASON'

Line 664: hr_api.mandatory_arg_error

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

Line 670: hr_api.mandatory_arg_error

666: ,p_argument => 'effective_date'
667: ,p_argument_value => p_effective_date
668: );
669: --
670: hr_api.mandatory_arg_error
671: (p_api_name => l_proc
672: ,p_argument => 'validation_start_date'
673: ,p_argument_value => p_validation_start_date
674: );

Line 676: hr_api.mandatory_arg_error

672: ,p_argument => 'validation_start_date'
673: ,p_argument_value => p_validation_start_date
674: );
675: --
676: hr_api.mandatory_arg_error
677: (p_api_name => l_proc
678: ,p_argument => 'validation_end_date'
679: ,p_argument_value => p_validation_end_date
680: );

Line 691: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

687: );
688: hr_utility.set_location(l_proc, 30);
689: --
690: if ((l_api_updating and
691: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
692: nvl(p_duration_units, hr_api.g_varchar2))
693: or (NOT l_api_updating))
694: then
695: hr_utility.set_location(l_proc, 40);

Line 692: nvl(p_duration_units, hr_api.g_varchar2))

688: hr_utility.set_location(l_proc, 30);
689: --
690: if ((l_api_updating and
691: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
692: nvl(p_duration_units, hr_api.g_varchar2))
693: or (NOT l_api_updating))
694: then
695: hr_utility.set_location(l_proc, 40);
696: --

Line 704: if hr_api.not_exists_in_dt_hr_lookups

700: -- lookup type 'DURATION_UNITS' with an enabled flag set to 'Y' and that
701: -- the effective start date of the contract is between start date
702: -- active and end date active in hr_lookups.
703: --
704: if hr_api.not_exists_in_dt_hr_lookups
705: (p_effective_date => p_effective_date
706: ,p_validation_start_date => p_validation_start_date
707: ,p_validation_end_date => p_validation_end_date
708: ,p_lookup_type => 'QUALIFYING_UNITS'

Line 797: hr_api.mandatory_arg_error

793: hr_utility.set_location('Entering:'|| l_proc, 10);
794: --
795: -- Check mandatory parameters have been set
796: --
797: hr_api.mandatory_arg_error
798: (p_api_name => l_proc
799: ,p_argument => 'effective_date'
800: ,p_argument_value => p_effective_date
801: );

Line 803: hr_api.mandatory_arg_error

799: ,p_argument => 'effective_date'
800: ,p_argument_value => p_effective_date
801: );
802: --
803: hr_api.mandatory_arg_error
804: (p_api_name => l_proc
805: ,p_argument => 'validation_start_date'
806: ,p_argument_value => p_validation_start_date
807: );

Line 809: hr_api.mandatory_arg_error

805: ,p_argument => 'validation_start_date'
806: ,p_argument_value => p_validation_start_date
807: );
808: --
809: hr_api.mandatory_arg_error
810: (p_api_name => l_proc
811: ,p_argument => 'validation_end_date'
812: ,p_argument_value => p_validation_end_date
813: );

Line 824: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

820: );
821: hr_utility.set_location(l_proc, 30);
822: --
823: if ((l_api_updating and
824: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
825: nvl(p_start_reason, hr_api.g_varchar2))
826: or (NOT l_api_updating))
827: then
828: hr_utility.set_location(l_proc, 40);

Line 825: nvl(p_start_reason, hr_api.g_varchar2))

821: hr_utility.set_location(l_proc, 30);
822: --
823: if ((l_api_updating and
824: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
825: nvl(p_start_reason, hr_api.g_varchar2))
826: or (NOT l_api_updating))
827: then
828: hr_utility.set_location(l_proc, 40);
829: --

Line 837: if hr_api.not_exists_in_dt_hr_lookups

833: -- lookup type 'START_REASON' with an enabled flag set to 'Y' and that
834: -- the effective start date of the contract is between start date
835: -- active and end date active in hr_lookups.
836: --
837: if hr_api.not_exists_in_dt_hr_lookups
838: (p_effective_date => p_effective_date
839: ,p_validation_start_date => p_validation_start_date
840: ,p_validation_end_date => p_validation_end_date
841: ,p_lookup_type => 'CONTRACT_START_REASON'

Line 911: hr_api.mandatory_arg_error

907: hr_utility.set_location('Entering:'|| l_proc, 10);
908: --
909: -- Check mandatory parameters have been set
910: --
911: hr_api.mandatory_arg_error
912: (p_api_name => l_proc
913: ,p_argument => 'effective_date'
914: ,p_argument_value => p_effective_date
915: );

Line 917: hr_api.mandatory_arg_error

913: ,p_argument => 'effective_date'
914: ,p_argument_value => p_effective_date
915: );
916: --
917: hr_api.mandatory_arg_error
918: (p_api_name => l_proc
919: ,p_argument => 'validation_start_date'
920: ,p_argument_value => p_validation_start_date
921: );

Line 923: hr_api.mandatory_arg_error

919: ,p_argument => 'validation_start_date'
920: ,p_argument_value => p_validation_start_date
921: );
922: --
923: hr_api.mandatory_arg_error
924: (p_api_name => l_proc
925: ,p_argument => 'validation_end_date'
926: ,p_argument_value => p_validation_end_date
927: );

Line 938: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

934: );
935: hr_utility.set_location(l_proc, 30);
936: --
937: if ((l_api_updating and
938: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
939: nvl(p_end_reason, hr_api.g_varchar2))
940: or (NOT l_api_updating))
941: then
942: hr_utility.set_location(l_proc, 40);

Line 939: nvl(p_end_reason, hr_api.g_varchar2))

935: hr_utility.set_location(l_proc, 30);
936: --
937: if ((l_api_updating and
938: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
939: nvl(p_end_reason, hr_api.g_varchar2))
940: or (NOT l_api_updating))
941: then
942: hr_utility.set_location(l_proc, 40);
943: --

Line 951: if hr_api.not_exists_in_dt_hr_lookups

947: -- lookup type 'CONTRACT_END_REASON' with an enabled flag set to 'Y' and that
948: -- the effective start date of the contract is between start date
949: -- active and end date active in hr_lookups.
950: --
951: if hr_api.not_exists_in_dt_hr_lookups
952: (p_effective_date => p_effective_date
953: ,p_validation_start_date => p_validation_start_date
954: ,p_validation_end_date => p_validation_end_date
955: ,p_lookup_type => 'CONTRACT_END_REASON'

Line 1027: hr_api.mandatory_arg_error

1023: hr_utility.set_location('Entering:'|| l_proc, 10);
1024: --
1025: -- Check mandatory parameters have been set
1026: --
1027: hr_api.mandatory_arg_error
1028: (p_api_name => l_proc
1029: ,p_argument => 'effective_date'
1030: ,p_argument_value => p_effective_date
1031: );

Line 1033: hr_api.mandatory_arg_error

1029: ,p_argument => 'effective_date'
1030: ,p_argument_value => p_effective_date
1031: );
1032: --
1033: hr_api.mandatory_arg_error
1034: (p_api_name => l_proc
1035: ,p_argument => 'validation_start_date'
1036: ,p_argument_value => p_validation_start_date
1037: );

Line 1039: hr_api.mandatory_arg_error

1035: ,p_argument => 'validation_start_date'
1036: ,p_argument_value => p_validation_start_date
1037: );
1038: --
1039: hr_api.mandatory_arg_error
1040: (p_api_name => l_proc
1041: ,p_argument => 'validation_end_date'
1042: ,p_argument_value => p_validation_end_date
1043: );

Line 1054: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>

1050: );
1051: hr_utility.set_location(l_proc, 30);
1052: --
1053: if ((l_api_updating and
1054: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
1055: nvl(p_extension_period_units, hr_api.g_varchar2))
1056: or (NOT l_api_updating))
1057: then
1058: hr_utility.set_location(l_proc, 40);

Line 1055: nvl(p_extension_period_units, hr_api.g_varchar2))

1051: hr_utility.set_location(l_proc, 30);
1052: --
1053: if ((l_api_updating and
1054: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
1055: nvl(p_extension_period_units, hr_api.g_varchar2))
1056: or (NOT l_api_updating))
1057: then
1058: hr_utility.set_location(l_proc, 40);
1059: --

Line 1062: if hr_api.not_exists_in_dt_hr_lookups

1058: hr_utility.set_location(l_proc, 40);
1059: --
1060: if p_extension_period_units is not null then
1061: --
1062: if hr_api.not_exists_in_dt_hr_lookups
1063: (p_effective_date => p_effective_date
1064: ,p_validation_start_date => p_validation_start_date
1065: ,p_validation_end_date => p_validation_end_date
1066: ,p_lookup_type => 'QUALIFYING_UNITS'

Line 1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1185: begin
1186: hr_utility.set_location('Entering:'||l_proc, 10);
1187: --
1188: if ((p_rec.contract_id is NULL) and (
1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1186: hr_utility.set_location('Entering:'||l_proc, 10);
1187: --
1188: if ((p_rec.contract_id is NULL) and (
1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1187: --
1188: if ((p_rec.contract_id is NULL) and (
1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1188: if ((p_rec.contract_id is NULL) and (
1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1191: nvl(per_ctc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1193: nvl(per_ctc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1195: nvl(per_ctc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1197: nvl(per_ctc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1199: nvl(per_ctc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1201: nvl(per_ctc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1203: nvl(per_ctc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1205: nvl(per_ctc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1207: nvl(per_ctc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1209: nvl(per_ctc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1211: nvl(per_ctc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1213: nvl(per_ctc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1215: nvl(per_ctc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1217: nvl(per_ctc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1219: nvl(per_ctc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1221: nvl(per_ctc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1223: nvl(per_ctc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1231: or (p_rec.contract_id is null) then

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

1224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1231: or (p_rec.contract_id is null) then
1232: --

Line 1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1225: nvl(per_ctc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1231: or (p_rec.contract_id is null) then
1232: --
1233: -- Only execute the validation if absolutely necessary:

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

1226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1227: nvl(per_ctc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1229: nvl(per_ctc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1230: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1231: or (p_rec.contract_id is null) then
1232: --
1233: -- Only execute the validation if absolutely necessary:
1234: -- a) During update, the structure column value or any

Line 1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>

1331: --
1332: if (p_rec.contract_id is null)
1333: or ((p_rec.contract_id is not null)
1334: and
1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>
1336: nvl(p_rec.ctr_information_category, hr_api.g_varchar2) or
1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>

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

1332: if (p_rec.contract_id is null)
1333: or ((p_rec.contract_id is not null)
1334: and
1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>
1336: nvl(p_rec.ctr_information_category, hr_api.g_varchar2) or
1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or

Line 1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>

1333: or ((p_rec.contract_id is not null)
1334: and
1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>
1336: nvl(p_rec.ctr_information_category, hr_api.g_varchar2) or
1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>

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

1334: and
1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>
1336: nvl(p_rec.ctr_information_category, hr_api.g_varchar2) or
1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or

Line 1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>

1335: nvl(per_ctc_shd.g_old_rec.ctr_information_category, hr_api.g_varchar2) <>
1336: nvl(p_rec.ctr_information_category, hr_api.g_varchar2) or
1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>

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

1336: nvl(p_rec.ctr_information_category, hr_api.g_varchar2) or
1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or

Line 1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>

1337: nvl(per_ctc_shd.g_old_rec.ctr_information1, hr_api.g_varchar2) <>
1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>

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

1338: nvl(p_rec.ctr_information1, hr_api.g_varchar2) or
1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or

Line 1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>

1339: nvl(per_ctc_shd.g_old_rec.ctr_information2, hr_api.g_varchar2) <>
1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>

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

1340: nvl(p_rec.ctr_information2, hr_api.g_varchar2) or
1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or

Line 1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>

1341: nvl(per_ctc_shd.g_old_rec.ctr_information3, hr_api.g_varchar2) <>
1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>

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

1342: nvl(p_rec.ctr_information3, hr_api.g_varchar2) or
1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or

Line 1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>

1343: nvl(per_ctc_shd.g_old_rec.ctr_information4, hr_api.g_varchar2) <>
1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>

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

1344: nvl(p_rec.ctr_information4, hr_api.g_varchar2) or
1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or

Line 1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>

1345: nvl(per_ctc_shd.g_old_rec.ctr_information5, hr_api.g_varchar2) <>
1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>

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

1346: nvl(p_rec.ctr_information5, hr_api.g_varchar2) or
1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or

Line 1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>

1347: nvl(per_ctc_shd.g_old_rec.ctr_information6, hr_api.g_varchar2) <>
1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>

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

1348: nvl(p_rec.ctr_information6, hr_api.g_varchar2) or
1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or

Line 1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>

1349: nvl(per_ctc_shd.g_old_rec.ctr_information7, hr_api.g_varchar2) <>
1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>

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

1350: nvl(p_rec.ctr_information7, hr_api.g_varchar2) or
1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or

Line 1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>

1351: nvl(per_ctc_shd.g_old_rec.ctr_information8, hr_api.g_varchar2) <>
1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>

Line 1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or

1352: nvl(p_rec.ctr_information8, hr_api.g_varchar2) or
1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or

Line 1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>

1353: nvl(per_ctc_shd.g_old_rec.ctr_information9, hr_api.g_varchar2) <>
1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>

Line 1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or

1354: nvl(p_rec.ctr_information9, hr_api.g_varchar2) or
1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or

Line 1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>

1355: nvl(per_ctc_shd.g_old_rec.ctr_information10, hr_api.g_varchar2) <>
1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>

Line 1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or

1356: nvl(p_rec.ctr_information10, hr_api.g_varchar2) or
1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or

Line 1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>

1357: nvl(per_ctc_shd.g_old_rec.ctr_information11, hr_api.g_varchar2) <>
1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>

Line 1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or

1358: nvl(p_rec.ctr_information11, hr_api.g_varchar2) or
1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or

Line 1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>

1359: nvl(per_ctc_shd.g_old_rec.ctr_information12, hr_api.g_varchar2) <>
1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>

Line 1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or

1360: nvl(p_rec.ctr_information12, hr_api.g_varchar2) or
1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or

Line 1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>

1361: nvl(per_ctc_shd.g_old_rec.ctr_information13, hr_api.g_varchar2) <>
1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>

Line 1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or

1362: nvl(p_rec.ctr_information13, hr_api.g_varchar2) or
1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or

Line 1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>

1363: nvl(per_ctc_shd.g_old_rec.ctr_information14, hr_api.g_varchar2) <>
1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>

Line 1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or

1364: nvl(p_rec.ctr_information14, hr_api.g_varchar2) or
1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or

Line 1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>

1365: nvl(per_ctc_shd.g_old_rec.ctr_information15, hr_api.g_varchar2) <>
1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>

Line 1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or

1366: nvl(p_rec.ctr_information15, hr_api.g_varchar2) or
1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or

Line 1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>

1367: nvl(per_ctc_shd.g_old_rec.ctr_information16, hr_api.g_varchar2) <>
1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or
1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>

Line 1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or

1368: nvl(p_rec.ctr_information16, hr_api.g_varchar2) or
1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or
1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>
1376: nvl(p_rec.ctr_information20, hr_api.g_varchar2))

Line 1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>

1369: nvl(per_ctc_shd.g_old_rec.ctr_information17, hr_api.g_varchar2) <>
1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or
1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>
1376: nvl(p_rec.ctr_information20, hr_api.g_varchar2))
1377: then

Line 1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or

1370: nvl(p_rec.ctr_information17, hr_api.g_varchar2) or
1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or
1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>
1376: nvl(p_rec.ctr_information20, hr_api.g_varchar2))
1377: then
1378: --

Line 1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>

1371: nvl(per_ctc_shd.g_old_rec.ctr_information18, hr_api.g_varchar2) <>
1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or
1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>
1376: nvl(p_rec.ctr_information20, hr_api.g_varchar2))
1377: then
1378: --
1379: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 1376: nvl(p_rec.ctr_information20, hr_api.g_varchar2))

1372: nvl(p_rec.ctr_information18, hr_api.g_varchar2) or
1373: nvl(per_ctc_shd.g_old_rec.ctr_information19, hr_api.g_varchar2) <>
1374: nvl(p_rec.ctr_information19, hr_api.g_varchar2) or
1375: nvl(per_ctc_shd.g_old_rec.ctr_information20, hr_api.g_varchar2) <>
1376: nvl(p_rec.ctr_information20, hr_api.g_varchar2))
1377: then
1378: --
1379: hr_dflex_utility.ins_or_upd_descflex_attribs
1380: (p_appl_short_name => 'PER'

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

1479: hr_utility.set_location('Entering:'|| l_proc, 10);
1480: --
1481: -- Ensure that all the mandatory parameter are not null
1482: --
1483: hr_api.mandatory_arg_error(p_api_name => l_proc,
1484: p_argument => 'contract_id',
1485: p_argument_value => p_contract_id);
1486: --
1487: if nvl(g_contract_id, hr_api.g_number) = p_contract_id then

Line 1487: if nvl(g_contract_id, hr_api.g_number) = p_contract_id then

1483: hr_api.mandatory_arg_error(p_api_name => l_proc,
1484: p_argument => 'contract_id',
1485: p_argument_value => p_contract_id);
1486: --
1487: if nvl(g_contract_id, hr_api.g_number) = p_contract_id then
1488: --
1489: -- The legislation code has already been found with a previous
1490: -- call to this function. Just return the value in the global
1491: -- variable.

Line 1553: p_person_id in number default hr_api.g_number,

1549: -- {End Of Comments}
1550: -- ----------------------------------------------------------------------------
1551: Procedure dt_update_validate
1552: (
1553: p_person_id in number default hr_api.g_number,
1554: p_datetrack_mode in varchar2,
1555: p_validation_start_date in date,
1556: p_validation_end_date in date) Is
1557: --

Line 1567: hr_api.mandatory_arg_error

1563: hr_utility.set_location('Entering:'||l_proc, 5);
1564: --
1565: -- Ensure that the p_datetrack_mode argument is not null
1566: --
1567: hr_api.mandatory_arg_error
1568: (p_api_name => l_proc,
1569: p_argument => 'datetrack_mode',
1570: p_argument_value => p_datetrack_mode);
1571: --

Line 1579: hr_api.mandatory_arg_error

1575: --
1576: --
1577: -- Ensure the arguments are not null
1578: --
1579: hr_api.mandatory_arg_error
1580: (p_api_name => l_proc,
1581: p_argument => 'validation_start_date',
1582: p_argument_value => p_validation_start_date);
1583: --

Line 1584: hr_api.mandatory_arg_error

1580: (p_api_name => l_proc,
1581: p_argument => 'validation_start_date',
1582: p_argument_value => p_validation_start_date);
1583: --
1584: hr_api.mandatory_arg_error
1585: (p_api_name => l_proc,
1586: p_argument => 'validation_end_date',
1587: p_argument_value => p_validation_end_date);
1588: --

Line 1589: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and

1585: (p_api_name => l_proc,
1586: p_argument => 'validation_end_date',
1587: p_argument_value => p_validation_end_date);
1588: --
1589: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
1590: NOT (dt_api.check_min_max_dates
1591: (p_base_table_name => 'per_people_f',
1592: p_base_key_column => 'person_id',
1593: p_base_key_value => p_person_id,

Line 1674: hr_api.mandatory_arg_error

1670: hr_utility.set_location('Entering:'||l_proc, 5);
1671: --
1672: -- Ensure that the p_datetrack_mode argument is not null
1673: --
1674: hr_api.mandatory_arg_error
1675: (p_api_name => l_proc,
1676: p_argument => 'datetrack_mode',
1677: p_argument_value => p_datetrack_mode);
1678: --

Line 1688: hr_api.mandatory_arg_error

1684: --
1685: --
1686: -- Ensure the arguments are not null
1687: --
1688: hr_api.mandatory_arg_error
1689: (p_api_name => l_proc,
1690: p_argument => 'validation_start_date',
1691: p_argument_value => p_validation_start_date);
1692: --

Line 1693: hr_api.mandatory_arg_error

1689: (p_api_name => l_proc,
1690: p_argument => 'validation_start_date',
1691: p_argument_value => p_validation_start_date);
1692: --
1693: hr_api.mandatory_arg_error
1694: (p_api_name => l_proc,
1695: p_argument => 'validation_end_date',
1696: p_argument_value => p_validation_end_date);
1697: --

Line 1698: hr_api.mandatory_arg_error

1694: (p_api_name => l_proc,
1695: p_argument => 'validation_end_date',
1696: p_argument_value => p_validation_end_date);
1697: --
1698: hr_api.mandatory_arg_error
1699: (p_api_name => l_proc,
1700: p_argument => 'contract_id',
1701: p_argument_value => p_contract_id);
1702: --

Line 1747: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1743: hr_utility.set_location('Entering:'||l_proc, 5);
1744: --
1745: -- Call all supporting business operations
1746: --
1747: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1748: --
1749: hr_utility.set_location(l_proc, 7);
1750: --
1751: -- Set the business group profile as this is used by the flexfield validation.

Line 1896: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1892: hr_utility.set_location('Entering:'||l_proc, 5);
1893: --
1894: -- Call all supporting business operations
1895: --
1896: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1897: --
1898: hr_utility.set_location(l_proc, 7);
1899: --
1900: -- Set the business group profile as this is used by the flexfield validation.