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_ASN_BUS dependencies on PER_ASN_SHD

Line 24: Procedure chk_non_updateable_args(p_rec in per_asn_shd.g_rec_type) is

20: -- business_group_id
21: -- person_id
22: -- assessor_person_id
23: --
24: Procedure chk_non_updateable_args(p_rec in per_asn_shd.g_rec_type) is
25: --
26: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
27: l_error exception;
28: l_argument varchar2(30);

Line 36: if not per_asn_shd.api_updating

32: hr_utility.set_location('Entering:'|| l_proc,5);
33: --
34: -- Only proceed with validation if a row exists for
35: -- the current record in the HR Schema.
36: if not per_asn_shd.api_updating
37: --
38: (p_assessment_id => p_rec.assessment_id
39: ,p_object_version_number => p_rec.object_version_number
40: ) then

Line 48: if p_rec.business_group_id <> per_asn_shd.g_old_rec.business_group_id then

44: end if;
45: --
46: hr_utility.set_location (l_proc, 6);
47: --
48: if p_rec.business_group_id <> per_asn_shd.g_old_rec.business_group_id then
49: l_argument := 'business_group_id';
50: raise l_error;
51: end if;
52: --

Line 53: if p_rec.person_id <> per_asn_shd.g_old_rec.person_id then

49: l_argument := 'business_group_id';
50: raise l_error;
51: end if;
52: --
53: if p_rec.person_id <> per_asn_shd.g_old_rec.person_id then
54: l_argument := 'person_id';
55: raise l_error;
56: end if;
57: --

Line 58: if p_rec.assessor_person_id <> per_asn_shd.g_old_rec.assessor_person_id then

54: l_argument := 'person_id';
55: raise l_error;
56: end if;
57: --
58: if p_rec.assessor_person_id <> per_asn_shd.g_old_rec.assessor_person_id then
59: l_argument := 'assessor_person_id';
60: raise l_error;
61: end if;
62: --

Line 68: ,p_base_table => per_asn_shd.g_tab_nam);

64: when l_error then
65: hr_api.argument_changed_error
66: (p_api_name => l_proc
67: ,p_argument => l_argument
68: ,p_base_table => per_asn_shd.g_tab_nam);
69: when others then
70: raise;
71: --
72: hr_utility.set_location(' Leaving : '|| l_proc, 10);

Line 145: l_api_updating := per_asn_shd.api_updating

141: -- a) The row is being inserted.
142: -- b) The row is being updated and
143: -- 1: The new value is different then the old value
144: --
145: l_api_updating := per_asn_shd.api_updating
146: (p_assessment_id => p_assessment_id
147: ,p_object_version_number => p_object_version_number
148: );
149: --

Line 150: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_type_id,

146: (p_assessment_id => p_assessment_id
147: ,p_object_version_number => p_object_version_number
148: );
149: --
150: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_type_id,
151: hr_api.g_number)
152: <> nvl(p_assessment_type_id, hr_api.g_number))
153: or (not l_api_updating)) then
154: --

Line 184: per_asn_shd.constraint_error

180: if csr_ast_date_from_date_to%notfound then
181: --
182: close csr_ast_date_from_date_to;
183: --
184: per_asn_shd.constraint_error
185: (p_constraint_name => 'PER_ASSESSMENTS_FK1');
186: --
187: end if;
188: --

Line 249: l_api_updating := per_asn_shd.api_updating

245: l_proc varchar2(72):=g_package||'chk_assessment_date';
246: --
247: begin
248: hr_utility.set_location('Entering:'|| l_proc, 1);
249: l_api_updating := per_asn_shd.api_updating
250: (p_assessment_id => p_assessment_id
251: ,p_object_version_number => p_object_version_number
252: );
253:

Line 255: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_date,

251: ,p_object_version_number => p_object_version_number
252: );
253:
254: --
255: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_date,
256: hr_api.g_date)
257: <> nvl(p_assessment_date, hr_api.g_date))
258: or (not l_api_updating)) then
259:

Line 528: l_api_updating := per_asn_shd.api_updating

524: --
525: -- Tests are carried out on insert only.
526: --
527: --
528: l_api_updating := per_asn_shd.api_updating
529: (p_assessment_id => p_assessment_id
530: ,p_object_version_number => p_object_version_number
531: );
532:

Line 533: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.group_initiator_id,

529: (p_assessment_id => p_assessment_id
530: ,p_object_version_number => p_object_version_number
531: );
532:
533: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.group_initiator_id,
534: hr_api.g_number)
535: <> nvl(p_group_initiator_id, hr_api.g_number))
536: or (not l_api_updating)) then
537:

Line 612: l_api_updating := per_asn_shd.api_updating

608: --
609: begin
610: hr_utility.set_location('Entering:'|| l_proc, 1);
611: --
612: l_api_updating := per_asn_shd.api_updating
613: (p_assessment_id => p_assessment_id
614: ,p_object_version_number => p_object_version_number
615: );
616:

Line 620: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.group_initiator_id,

616:
617: --
618: -- Tests are carried out on insert only.
619: --
620: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.group_initiator_id,
621: hr_api.g_number)
622: <> nvl(p_group_initiator_id, hr_api.g_number))
623: or (not l_api_updating)) then
624:

Line 714: l_api_updating := per_asn_shd.api_updating

710: l_proc varchar2(72):=g_package||'chk_status';
711: --
712: begin
713: hr_utility.set_location('Entering:'|| l_proc, 1);
714: l_api_updating := per_asn_shd.api_updating
715: (p_assessment_id => p_assessment_id
716: ,p_object_version_number => p_object_version_number
717: );
718: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.status,

Line 718: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.status,

714: l_api_updating := per_asn_shd.api_updating
715: (p_assessment_id => p_assessment_id
716: ,p_object_version_number => p_object_version_number
717: );
718: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.status,
719: hr_api.g_varchar2)
720: <> nvl(p_status, hr_api.g_varchar2))
721: or (not l_api_updating)) then
722:

Line 790: l_api_updating := per_asn_shd.api_updating

786: l_proc varchar2(72):=g_package||'chk_assessment_period';
787: --
788: begin
789: hr_utility.set_location('Entering:'|| l_proc, 1);
790: l_api_updating := per_asn_shd.api_updating
791: (p_assessment_id => p_assessment_id
792: ,p_object_version_number => p_object_version_number
793: );
794:

Line 797: and (nvl(per_asn_shd.g_old_rec.assessment_period_start_date,

793: );
794:
795: --
796: if ((l_api_updating
797: and (nvl(per_asn_shd.g_old_rec.assessment_period_start_date,
798: hr_api.g_date)
799: <> nvl(p_assessment_period_start_date, hr_api.g_date)
800: or nvl(per_asn_shd.g_old_rec.assessment_period_end_date,
801: hr_api.g_date)

Line 800: or nvl(per_asn_shd.g_old_rec.assessment_period_end_date,

796: if ((l_api_updating
797: and (nvl(per_asn_shd.g_old_rec.assessment_period_start_date,
798: hr_api.g_date)
799: <> nvl(p_assessment_period_start_date, hr_api.g_date)
800: or nvl(per_asn_shd.g_old_rec.assessment_period_end_date,
801: hr_api.g_date)
802: <> nvl(p_assessment_period_end_date, hr_api.g_date)))
803: or (not l_api_updating)) then
804:

Line 811: per_asn_shd.constraint_error

807: -- As end_date <> NULL, start_date becomes mandatory
808: --
809: if (p_assessment_period_start_date is NULL) then
810: --
811: per_asn_shd.constraint_error
812: (p_constraint_name => 'PER_ASSESSMENTS_DATE_END_CHK');
813: --
814: end if;
815: --

Line 820: per_asn_shd.constraint_error

816: -- The end date has to be >= the start date, else error.
817: --
818: if (p_assessment_period_start_date > p_assessment_period_end_date) then
819: --
820: per_asn_shd.constraint_error
821: (p_constraint_name => 'PER_ASSESSMENTS_DATE_CHK');
822: --
823: end if;
824: --

Line 915: per_asn_shd.constraint_error

911: if csr_duplicate_rows%found then
912: hr_utility.set_location('Dup.found:'|| l_proc, 3);
913: close csr_duplicate_rows;
914: --
915: per_asn_shd.constraint_error
916: (p_constraint_name => 'PER_ASSESSMENTS_UK1');
917: --
918: end if;
919: close csr_duplicate_rows;

Line 981: l_api_updating := per_asn_shd.api_updating

977: l_exists varchar2(1);
978:
979: begin
980: hr_utility.set_location('Entering:'|| l_proc, 1);
981: l_api_updating := per_asn_shd.api_updating
982: (p_assessment_id => p_assessment_id
983: ,p_object_version_number => p_object_version_number
984: );
985: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_group_id,

Line 985: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_group_id,

981: l_api_updating := per_asn_shd.api_updating
982: (p_assessment_id => p_assessment_id
983: ,p_object_version_number => p_object_version_number
984: );
985: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.assessment_group_id,
986: hr_api.g_number)
987: <> nvl(p_assessment_group_id, hr_api.g_number))
988: or (not l_api_updating)) then
989:

Line 1003: per_asn_shd.constraint_error

999: hr_utility.set_location('assessment_group_id :'|| p_assessment_group_id, 1);
1000: if (csr_chk_ass_group_id%notfound) then
1001: close csr_chk_ass_group_id;
1002: --
1003: per_asn_shd.constraint_error
1004: (p_constraint_name => 'PER_ASSESSMENTS_FK3');
1005: --
1006: end if;
1007: close csr_chk_ass_group_id;

Line 1067: l_api_updating := per_asn_shd.api_updating

1063: l_exists varchar2(1);
1064:
1065: begin
1066: hr_utility.set_location('Entering:'|| l_proc, 1);
1067: l_api_updating := per_asn_shd.api_updating
1068: (p_assessment_id => p_assessment_id
1069: ,p_object_version_number => p_object_version_number
1070: );
1071: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.appraisal_id,

Line 1071: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.appraisal_id,

1067: l_api_updating := per_asn_shd.api_updating
1068: (p_assessment_id => p_assessment_id
1069: ,p_object_version_number => p_object_version_number
1070: );
1071: if ((l_api_updating and nvl(per_asn_shd.g_old_rec.appraisal_id,
1072: hr_api.g_number)
1073: <> nvl(p_appraisal_id, hr_api.g_number))
1074: or (not l_api_updating)) then
1075:

Line 1087: per_asn_shd.constraint_error

1083: --
1084: if (csr_chk_appraisal_id%notfound) then
1085: close csr_chk_appraisal_id;
1086: --
1087: per_asn_shd.constraint_error
1088: (p_constraint_name => 'PER_ASSESSMENTS_FK4');
1089: --
1090: end if;
1091: close csr_chk_appraisal_id;

Line 1192: (p_rec in per_asn_shd.g_rec_type) is

1188: -- Access Status:
1189: -- Internal Row Handler Use Only.
1190: --
1191: procedure chk_df
1192: (p_rec in per_asn_shd.g_rec_type) is
1193: --
1194: l_proc varchar2(72) := g_package||'chk_df';
1195: --
1196: begin

Line 1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1196: begin
1197: hr_utility.set_location('Entering:'||l_proc, 10);
1198: --
1199: if ((p_rec.assessment_id is not null) and (
1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1201: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1198: --
1199: if ((p_rec.assessment_id is not null) and (
1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1201: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1200: nvl(per_asn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1201: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1202: nvl(per_asn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1203: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1204: nvl(per_asn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1205: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1206: nvl(per_asn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1207: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1208: nvl(per_asn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1209: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1210: nvl(per_asn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1211: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1212: nvl(per_asn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1213: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1214: nvl(per_asn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1215: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1216: nvl(per_asn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1218: nvl(per_asn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1220: nvl(per_asn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1222: nvl(per_asn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1224: nvl(per_asn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1226: nvl(per_asn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1228: nvl(per_asn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1230: nvl(per_asn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1232: nvl(per_asn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1234: nvl(per_asn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1242: or

Line 1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1236: nvl(per_asn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1238: nvl(per_asn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1240: nvl(per_asn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1242: or
1243: (p_rec.assessment_id is null) then
1244: --

Line 1305: (p_rec in per_asn_shd.g_rec_type

1301: -- ----------------------------------------------------------------------------
1302: -- |---------------------------< insert_validate >----------------------------|
1303: -- ----------------------------------------------------------------------------
1304: Procedure insert_validate
1305: (p_rec in per_asn_shd.g_rec_type
1306: ,p_effective_date in date) is
1307: --
1308: l_proc varchar2(72) := g_package||'insert_validate';
1309: --

Line 1322: ,p_associated_column1 => per_asn_shd.g_tab_nam ||

1318: -- =====================
1319: -- Rule CHK_BUSINESS_GROUP_ID a
1320: --
1321: hr_api.validate_bus_grp_id(p_rec.business_group_id
1322: ,p_associated_column1 => per_asn_shd.g_tab_nam ||
1323: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1324:
1325:
1326: hr_multi_message.end_validation_set;

Line 1470: (p_rec in per_asn_shd.g_rec_type

1466: -- ----------------------------------------------------------------------------
1467: -- |---------------------------< update_validate >----------------------------|
1468: -- ----------------------------------------------------------------------------
1469: Procedure update_validate
1470: (p_rec in per_asn_shd.g_rec_type
1471: ,p_effective_date in date) is
1472: --
1473: l_proc varchar2(72) := g_package||'update_validate';
1474: --

Line 1483: ,p_associated_column1 => per_asn_shd.g_tab_nam ||

1479: -- business rules provided.
1480: --
1481: --
1482: hr_api.validate_bus_grp_id(p_rec.business_group_id
1483: ,p_associated_column1 => per_asn_shd.g_tab_nam ||
1484: '.BUSINESS_GROUP_ID'); -- Validate Business Group
1485: hr_multi_message.end_validation_set;
1486: --
1487: -- VALIDATE CHK_NON_UPDATABLE_ARGS

Line 1584: Procedure delete_validate(p_rec in per_asn_shd.g_rec_type) is

1580: --
1581: -- ----------------------------------------------------------------------------
1582: -- |---------------------------< delete_validate >----------------------------|
1583: -- ----------------------------------------------------------------------------
1584: Procedure delete_validate(p_rec in per_asn_shd.g_rec_type) is
1585: --
1586: l_proc varchar2(72) := g_package||'delete_validate';
1587: --
1588: Begin