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_QUA_BUS dependencies on PER_QUA_SHD

Line 184: l_api_updating := per_qua_shd.api_updating

180: Begin
181: --
182: hr_utility.set_location('Entering:'||l_proc,5);
183: --
184: l_api_updating := per_qua_shd.api_updating
185: (p_qualification_id => p_qualification_id,
186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating

Line 190: <> nvl(per_qua_shd.g_old_rec.qualification_id,hr_api.g_number)) then

186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating
189: and nvl(p_qualification_id,hr_api.g_number)
190: <> nvl(per_qua_shd.g_old_rec.qualification_id,hr_api.g_number)) then
191: --
192: -- raise error as PK has changed
193: --
194: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');

Line 194: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');

190: <> nvl(per_qua_shd.g_old_rec.qualification_id,hr_api.g_number)) then
191: --
192: -- raise error as PK has changed
193: --
194: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');
195: --
196: elsif not l_api_updating then
197: --
198: -- check if PK is null

Line 204: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');

200: if p_qualification_id is not null then
201: --
202: -- raise error as PK is not null
203: --
204: per_qua_shd.constraint_error('PER_QUALIFICATIONS_PK');
205: --
206: end if;
207: --
208: end if;

Line 257: l_api_updating := per_qua_shd.api_updating

253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc,5);
256: --
257: l_api_updating := per_qua_shd.api_updating
258: (p_qualification_id => p_qualification_id,
259: p_object_version_number => p_object_version_number);
260: --
261: if (l_api_updating

Line 263: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)

259: p_object_version_number => p_object_version_number);
260: --
261: if (l_api_updating
262: and nvl(p_qualification_type_id,hr_api.g_number)
263: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
264: or not l_api_updating) then
265: --
266: -- check if qualification type exist in per_qualification_types table
267: --

Line 278: per_qua_shd.constraint_error('PER_QUALIFICATIONS_FK2');

274: --
275: -- raise error as FK does not relate to PK in per_qualification_types
276: -- table.
277: --
278: per_qua_shd.constraint_error('PER_QUALIFICATIONS_FK2');
279: --
280: end if;
281: --
282: close c1;

Line 349: l_api_updating := per_qua_shd.api_updating

345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc,5);
348: --
349: l_api_updating := per_qua_shd.api_updating
350: (p_qualification_id => p_qualification_id,
351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating

Line 355: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and (nvl(p_person_id,hr_api.g_number)
355: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
356: or nvl(p_attendance_id,hr_api.g_number)
357: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number))
358: or not l_api_updating) then
359: --

Line 357: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number))

353: if (l_api_updating
354: and (nvl(p_person_id,hr_api.g_number)
355: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
356: or nvl(p_attendance_id,hr_api.g_number)
357: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number))
358: or not l_api_updating) then
359: --
360: -- check if attendance_id or person_id are populated and not both.
361: --

Line 411: per_qua_shd.constraint_error('PER_QUALIFICATIONS_FK1');

407: fetch c2 into l_dummy;
408: if c2%notfound then
409: --
410: close c2;
411: per_qua_shd.constraint_error('PER_QUALIFICATIONS_FK1');
412: --
413: end if;
414: --
415: close c2;

Line 424: and nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number

420: --
421: --UPDATE of person id not allowed unless currently null(U)
422: --
423: if (l_api_updating
424: and nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number
425: and per_qua_shd.g_old_rec.person_id <> p_person_id
426: ) then
427: --
428: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');

Line 425: and per_qua_shd.g_old_rec.person_id <> p_person_id

421: --UPDATE of person id not allowed unless currently null(U)
422: --
423: if (l_api_updating
424: and nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number
425: and per_qua_shd.g_old_rec.person_id <> p_person_id
426: ) then
427: --
428: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');
429: hr_utility.raise_error;

Line 468: p_rec in out nocopy per_qua_shd.g_rec_type

464: -- Internal Table Handler Use Only.
465: --
466: --
467: Procedure chk_party_id(
468: p_rec in out nocopy per_qua_shd.g_rec_type
469: ,p_effective_date in date
470: )is
471: --
472: l_proc varchar2(72) := g_package||'chk_party_id';

Line 626: l_api_updating := per_qua_shd.api_updating

622: Begin
623: --
624: hr_utility.set_location('Entering:'||l_proc,5);
625: --
626: l_api_updating := per_qua_shd.api_updating
627: (p_qualification_id => p_qualification_id,
628: p_object_version_number => p_object_version_number);
629: --
630: if p_status is not null then

Line 634: <> nvl(per_qua_shd.g_old_rec.status,hr_api.g_varchar2)

630: if p_status is not null then
631: --
632: if (l_api_updating
633: and nvl(p_status,hr_api.g_varchar2)
634: <> nvl(per_qua_shd.g_old_rec.status,hr_api.g_varchar2)
635: or not l_api_updating) then
636: --
637: -- check if status value exists in PER_SUBJECT_STATUSES lookup.
638: --

Line 749: l_old_awarded_date varchar2(30) := to_char(per_qua_shd.g_old_rec.awarded_date);

745: p_projected_completion_date in date,
746: p_object_version_number in number) is
747: --
748: l_proc varchar2(72) := g_package||'chk_awarded_date';
749: l_old_awarded_date varchar2(30) := to_char(per_qua_shd.g_old_rec.awarded_date);
750: l_old_start_date varchar2(30) := to_char(per_qua_shd.g_old_rec.start_date);
751: l_old_proj_comp_date varchar2(30) := to_char(per_qua_shd.g_old_rec.projected_completion_date);
752: l_old_end_date varchar2(30) := to_char(per_qua_shd.g_old_rec.end_date);
753: l_api_updating boolean;

Line 750: l_old_start_date varchar2(30) := to_char(per_qua_shd.g_old_rec.start_date);

746: p_object_version_number in number) is
747: --
748: l_proc varchar2(72) := g_package||'chk_awarded_date';
749: l_old_awarded_date varchar2(30) := to_char(per_qua_shd.g_old_rec.awarded_date);
750: l_old_start_date varchar2(30) := to_char(per_qua_shd.g_old_rec.start_date);
751: l_old_proj_comp_date varchar2(30) := to_char(per_qua_shd.g_old_rec.projected_completion_date);
752: l_old_end_date varchar2(30) := to_char(per_qua_shd.g_old_rec.end_date);
753: l_api_updating boolean;
754: --

Line 751: l_old_proj_comp_date varchar2(30) := to_char(per_qua_shd.g_old_rec.projected_completion_date);

747: --
748: l_proc varchar2(72) := g_package||'chk_awarded_date';
749: l_old_awarded_date varchar2(30) := to_char(per_qua_shd.g_old_rec.awarded_date);
750: l_old_start_date varchar2(30) := to_char(per_qua_shd.g_old_rec.start_date);
751: l_old_proj_comp_date varchar2(30) := to_char(per_qua_shd.g_old_rec.projected_completion_date);
752: l_old_end_date varchar2(30) := to_char(per_qua_shd.g_old_rec.end_date);
753: l_api_updating boolean;
754: --
755: Begin

Line 752: l_old_end_date varchar2(30) := to_char(per_qua_shd.g_old_rec.end_date);

748: l_proc varchar2(72) := g_package||'chk_awarded_date';
749: l_old_awarded_date varchar2(30) := to_char(per_qua_shd.g_old_rec.awarded_date);
750: l_old_start_date varchar2(30) := to_char(per_qua_shd.g_old_rec.start_date);
751: l_old_proj_comp_date varchar2(30) := to_char(per_qua_shd.g_old_rec.projected_completion_date);
752: l_old_end_date varchar2(30) := to_char(per_qua_shd.g_old_rec.end_date);
753: l_api_updating boolean;
754: --
755: Begin
756: --

Line 760: l_api_updating := per_qua_shd.api_updating

756: --
757: hr_utility.set_location('********BUG1956358********',99);
758: hr_utility.set_location('Entering:'||l_proc,5);
759: --
760: l_api_updating := per_qua_shd.api_updating
761: (p_qualification_id => p_qualification_id,
762: p_object_version_number => p_object_version_number);
763: --
764: if p_awarded_date is not null then

Line 778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)

774: hr_utility.set_location('Prev Proj Comp Date= '||l_old_proj_comp_date,90);
775: --
776: if (l_api_updating
777: and (nvl(p_awarded_date,hr_api.g_date)
778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)
779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)

Line 780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)

776: if (l_api_updating
777: and (nvl(p_awarded_date,hr_api.g_date)
778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)
779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)
783: or nvl(p_end_date,hr_api.g_date)
784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))

Line 782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)

778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)
779: or nvl(p_start_date,hr_api.g_date)
780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)
783: or nvl(p_end_date,hr_api.g_date)
784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))
785: or not l_api_updating) then
786: --

Line 784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))

780: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
781: or nvl(p_projected_completion_date,hr_api.g_date)
782: <> nvl (per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date)
783: or nvl(p_end_date,hr_api.g_date)
784: <> nvl (per_qua_shd.g_old_rec.end_date,hr_api.g_date))
785: or not l_api_updating) then
786: --
787: -- check if awarded_date is after the start_date and greater than or
788: -- equal to the projected/actual completion date.

Line 903: l_api_updating := per_qua_shd.api_updating

899: Begin
900: --
901: hr_utility.set_location('Entering:'||l_proc,5);
902: --
903: l_api_updating := per_qua_shd.api_updating
904: (p_qualification_id => p_qualification_id,
905: p_object_version_number => p_object_version_number);
906: --
907: if (l_api_updating

Line 909: <> nvl(per_qua_shd.g_old_rec.fee,hr_api.g_number)

905: p_object_version_number => p_object_version_number);
906: --
907: if (l_api_updating
908: and (nvl(p_fee,hr_api.g_number)
909: <> nvl(per_qua_shd.g_old_rec.fee,hr_api.g_number)
910: or nvl(p_fee_currency,hr_api.g_varchar2)
911: <> nvl(per_qua_shd.g_old_rec.fee_currency,hr_api.g_varchar2))
912: or not l_api_updating) then
913: --

Line 911: <> nvl(per_qua_shd.g_old_rec.fee_currency,hr_api.g_varchar2))

907: if (l_api_updating
908: and (nvl(p_fee,hr_api.g_number)
909: <> nvl(per_qua_shd.g_old_rec.fee,hr_api.g_number)
910: or nvl(p_fee_currency,hr_api.g_varchar2)
911: <> nvl(per_qua_shd.g_old_rec.fee_currency,hr_api.g_varchar2))
912: or not l_api_updating) then
913: --
914: -- This if statement forces one of the following conditions
915: -- a) FEE is NOT NULL and FEE CURRENCY is NOT NULL

Line 1063: l_api_updating := per_qua_shd.api_updating

1059: Begin
1060: --
1061: hr_utility.set_location('Entering:'||l_proc,5);
1062: --
1063: l_api_updating := per_qua_shd.api_updating
1064: (p_qualification_id => p_qualification_id,
1065: p_object_version_number => p_object_version_number);
1066: --
1067: if (l_api_updating

Line 1100: per_qua_shd.constraint_error('PER_QUA_CHK_DATES');

1096: --
1097: -- raise error as the qualification start date is after the qualification
1098: -- end date.
1099: --
1100: per_qua_shd.constraint_error('PER_QUA_CHK_DATES');
1101: --
1102: end if;
1103: --
1104: -- Only carry out checks if the start and end date for the qualification

Line 1307: l_api_updating := per_qua_shd.api_updating

1303: --
1304: if hr_multi_message.no_all_inclusive_error
1305: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'
1306: ) then
1307: l_api_updating := per_qua_shd.api_updating
1308: (p_qualification_id => p_qualification_id,
1309: p_object_version_number => p_object_version_number);
1310: --
1311: if (l_api_updating

Line 1313: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)

1309: p_object_version_number => p_object_version_number);
1310: --
1311: if (l_api_updating
1312: and (nvl(p_start_date,hr_api.g_date)
1313: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
1314: or nvl(p_projected_completion_date,hr_api.g_date)
1315: <> nvl(per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date))
1316: or not l_api_updating) then
1317: --

Line 1315: <> nvl(per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date))

1311: if (l_api_updating
1312: and (nvl(p_start_date,hr_api.g_date)
1313: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
1314: or nvl(p_projected_completion_date,hr_api.g_date)
1315: <> nvl(per_qua_shd.g_old_rec.projected_completion_date,hr_api.g_date))
1316: or not l_api_updating) then
1317: --
1318: -- Check that if the projected completion date has been entered that it is
1319: -- later than the start date.

Line 1393: l_api_updating := per_qua_shd.api_updating

1389: Begin
1390: --
1391: hr_utility.set_location('Entering:'||l_proc,5);
1392: --
1393: l_api_updating := per_qua_shd.api_updating
1394: (p_qualification_id => p_qualification_id,
1395: p_object_version_number => p_object_version_number);
1396: --
1397: if (l_api_updating

Line 1399: <> nvl(per_qua_shd.g_old_rec.tuition_method,hr_api.g_varchar2))

1395: p_object_version_number => p_object_version_number);
1396: --
1397: if (l_api_updating
1398: and (nvl(p_tuition_method,hr_api.g_varchar2)
1399: <> nvl(per_qua_shd.g_old_rec.tuition_method,hr_api.g_varchar2))
1400: or not l_api_updating) then
1401: --
1402: if p_tuition_method is not null then
1403: --

Line 1487: l_api_updating := per_qua_shd.api_updating

1483: if hr_multi_message.no_all_inclusive_error
1484: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1485: ) then
1486: --
1487: l_api_updating := per_qua_shd.api_updating
1488: (p_qualification_id => p_qualification_id,
1489: p_object_version_number => p_object_version_number);
1490: --
1491: if (l_api_updating

Line 1493: <> per_qua_shd.g_old_rec.attendance_id

1489: p_object_version_number => p_object_version_number);
1490: --
1491: if (l_api_updating
1492: and (nvl(p_attendance_id,hr_api.g_number)
1493: <> per_qua_shd.g_old_rec.attendance_id
1494: or nvl(p_business_group_id,hr_api.g_number)
1495: <> per_qua_shd.g_old_rec.business_group_id)
1496: or not l_api_updating) then
1497: --

Line 1495: <> per_qua_shd.g_old_rec.business_group_id)

1491: if (l_api_updating
1492: and (nvl(p_attendance_id,hr_api.g_number)
1493: <> per_qua_shd.g_old_rec.attendance_id
1494: or nvl(p_business_group_id,hr_api.g_number)
1495: <> per_qua_shd.g_old_rec.business_group_id)
1496: or not l_api_updating) then
1497: --
1498: if p_attendance_id is not null then
1499: --

Line 1598: l_api_updating := per_qua_shd.api_updating

1594: if hr_multi_message.no_all_inclusive_error
1595: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
1596: ) then
1597: --
1598: l_api_updating := per_qua_shd.api_updating
1599: (p_qualification_id => p_qualification_id,
1600: p_object_version_number => p_object_version_number);
1601: --
1602: if (l_api_updating

Line 1604: <> per_qua_shd.g_old_rec.person_id

1600: p_object_version_number => p_object_version_number);
1601: --
1602: if (l_api_updating
1603: and (nvl(p_person_id,hr_api.g_number)
1604: <> per_qua_shd.g_old_rec.person_id
1605: or nvl(p_business_group_id,hr_api.g_number)
1606: <> per_qua_shd.g_old_rec.business_group_id)
1607: or not l_api_updating) then
1608: --

Line 1606: <> per_qua_shd.g_old_rec.business_group_id)

1602: if (l_api_updating
1603: and (nvl(p_person_id,hr_api.g_number)
1604: <> per_qua_shd.g_old_rec.person_id
1605: or nvl(p_business_group_id,hr_api.g_number)
1606: <> per_qua_shd.g_old_rec.business_group_id)
1607: or not l_api_updating) then
1608: --
1609: if p_person_id is not null then
1610: --

Line 1639: and nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number) <> hr_api.g_number

1635: --
1636: --UPDATE of BG_ID not allowed unless currently null(U)
1637: --
1638: if (l_api_updating
1639: and nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number) <> hr_api.g_number
1640: and per_qua_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1641: --
1642: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1643: hr_utility.raise_error;

Line 1640: and per_qua_shd.g_old_rec.business_group_id <> p_business_group_id ) then

1636: --UPDATE of BG_ID not allowed unless currently null(U)
1637: --
1638: if (l_api_updating
1639: and nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number) <> hr_api.g_number
1640: and per_qua_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1641: --
1642: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1643: hr_utility.raise_error;
1644: --

Line 1841: (p_rec in per_qua_shd.g_rec_type) is

1837: -- {End Of Comments}
1838: -- ----------------------------------------------------------------------------
1839: --
1840: procedure chk_df
1841: (p_rec in per_qua_shd.g_rec_type) is
1842: --
1843: l_proc varchar2(72) := g_package||'chk_df';
1844: --
1845: begin

Line 1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1845: begin
1846: hr_utility.set_location('Entering:'||l_proc, 10);
1847: --
1848: if ((p_rec.qualification_id is not null) and (
1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1847: --
1848: if ((p_rec.qualification_id is not null) and (
1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1851: nvl(per_qua_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1852: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1853: nvl(per_qua_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1854: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1855: nvl(per_qua_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1856: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1857: nvl(per_qua_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1858: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1859: nvl(per_qua_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1860: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1861: nvl(per_qua_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1862: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1863: nvl(per_qua_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1864: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1865: nvl(per_qua_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1866: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1867: nvl(per_qua_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1868: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1869: nvl(per_qua_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1870: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1871: nvl(per_qua_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1872: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1873: nvl(per_qua_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1874: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1875: nvl(per_qua_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1876: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1877: nvl(per_qua_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1878: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1879: nvl(per_qua_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1880: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1881: nvl(per_qua_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1882: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1883: nvl(per_qua_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1884: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1891: or

Line 1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1885: nvl(per_qua_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1886: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1887: nvl(per_qua_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1888: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1889: nvl(per_qua_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1890: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1891: or
1892: (p_rec.qualification_id is null) then
1893: --

Line 1976: (p_rec in per_qua_shd.g_rec_type

1972: -- Internal Row Handler Use Only.
1973: --
1974: -- ----------------------------------------------------------------------------
1975: procedure chk_ddf
1976: (p_rec in per_qua_shd.g_rec_type
1977: ) is
1978: --
1979: l_proc varchar2(72) := g_package || 'chk_ddf';
1980: --

Line 1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>

1981: begin
1982: hr_utility.set_location('Entering:'||l_proc,10);
1983: --
1984: if ((p_rec.qualification_id is not null) and (
1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>
1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or
1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>

Line 1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>

1983: --
1984: if ((p_rec.qualification_id is not null) and (
1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>
1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or
1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>

Line 1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>

1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>
1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or
1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>

Line 1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>

1987: nvl(per_qua_shd.g_old_rec.qua_information1, hr_api.g_varchar2) <>
1988: nvl(p_rec.qua_information1, hr_api.g_varchar2) or
1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>

Line 1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>

1989: nvl(per_qua_shd.g_old_rec.qua_information2, hr_api.g_varchar2) <>
1990: nvl(p_rec.qua_information2, hr_api.g_varchar2) or
1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>

Line 1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>

1991: nvl(per_qua_shd.g_old_rec.qua_information3, hr_api.g_varchar2) <>
1992: nvl(p_rec.qua_information3, hr_api.g_varchar2) or
1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>

Line 1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>

1993: nvl(per_qua_shd.g_old_rec.qua_information4, hr_api.g_varchar2) <>
1994: nvl(p_rec.qua_information4, hr_api.g_varchar2) or
1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>

Line 1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>

1995: nvl(per_qua_shd.g_old_rec.qua_information5, hr_api.g_varchar2) <>
1996: nvl(p_rec.qua_information5, hr_api.g_varchar2) or
1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>

Line 2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>

1997: nvl(per_qua_shd.g_old_rec.qua_information6, hr_api.g_varchar2) <>
1998: nvl(p_rec.qua_information6, hr_api.g_varchar2) or
1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>

Line 2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>

1999: nvl(per_qua_shd.g_old_rec.qua_information7, hr_api.g_varchar2) <>
2000: nvl(p_rec.qua_information7, hr_api.g_varchar2) or
2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>

Line 2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>

2001: nvl(per_qua_shd.g_old_rec.qua_information8, hr_api.g_varchar2) <>
2002: nvl(p_rec.qua_information8, hr_api.g_varchar2) or
2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>

Line 2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>

2003: nvl(per_qua_shd.g_old_rec.qua_information9, hr_api.g_varchar2) <>
2004: nvl(p_rec.qua_information9, hr_api.g_varchar2) or
2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>

Line 2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>

2005: nvl(per_qua_shd.g_old_rec.qua_information10, hr_api.g_varchar2) <>
2006: nvl(p_rec.qua_information10, hr_api.g_varchar2) or
2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>

Line 2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>

2007: nvl(per_qua_shd.g_old_rec.qua_information11, hr_api.g_varchar2) <>
2008: nvl(p_rec.qua_information11, hr_api.g_varchar2) or
2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>

Line 2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>

2009: nvl(per_qua_shd.g_old_rec.qua_information12, hr_api.g_varchar2) <>
2010: nvl(p_rec.qua_information12, hr_api.g_varchar2) or
2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>

Line 2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>

2011: nvl(per_qua_shd.g_old_rec.qua_information13, hr_api.g_varchar2) <>
2012: nvl(p_rec.qua_information13, hr_api.g_varchar2) or
2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>

Line 2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>

2013: nvl(per_qua_shd.g_old_rec.qua_information14, hr_api.g_varchar2) <>
2014: nvl(p_rec.qua_information14, hr_api.g_varchar2) or
2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>

Line 2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>

2015: nvl(per_qua_shd.g_old_rec.qua_information15, hr_api.g_varchar2) <>
2016: nvl(p_rec.qua_information15, hr_api.g_varchar2) or
2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>

Line 2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>

2017: nvl(per_qua_shd.g_old_rec.qua_information16, hr_api.g_varchar2) <>
2018: nvl(p_rec.qua_information16, hr_api.g_varchar2) or
2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or
2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>

Line 2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>

2019: nvl(per_qua_shd.g_old_rec.qua_information17, hr_api.g_varchar2) <>
2020: nvl(p_rec.qua_information17, hr_api.g_varchar2) or
2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or
2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>
2026: nvl(p_rec.qua_information20, hr_api.g_varchar2) ))
2027: or (p_rec.qualification_id is null) then

Line 2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>

2021: nvl(per_qua_shd.g_old_rec.qua_information18, hr_api.g_varchar2) <>
2022: nvl(p_rec.qua_information18, hr_api.g_varchar2) or
2023: nvl(per_qua_shd.g_old_rec.qua_information19, hr_api.g_varchar2) <>
2024: nvl(p_rec.qua_information19, hr_api.g_varchar2) or
2025: nvl(per_qua_shd.g_old_rec.qua_information20, hr_api.g_varchar2) <>
2026: nvl(p_rec.qua_information20, hr_api.g_varchar2) ))
2027: or (p_rec.qualification_id is null) then
2028: --
2029: -- Only execute the validation if absolutely necessary:

Line 2087: Procedure insert_validate(p_rec in out nocopy per_qua_shd.g_rec_type,

2083: --
2084: -- ----------------------------------------------------------------------------
2085: -- |---------------------------< insert_validate >----------------------------|
2086: -- ----------------------------------------------------------------------------
2087: Procedure insert_validate(p_rec in out nocopy per_qua_shd.g_rec_type,
2088: p_effective_date in date) is
2089: --
2090: l_proc varchar2(72) := g_package||'insert_validate';
2091: --

Line 2106: ,p_associated_column1 => per_qua_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

2102: --
2103: if p_rec.party_id is null and p_rec.business_group_id is not null then
2104: hr_api.validate_bus_grp_id
2105: (p_business_group_id => p_rec.business_group_id
2106: ,p_associated_column1 => per_qua_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
2107: ); -- Validate Bus Grp
2108: end if;
2109: --
2110: -- After validating the set of important attributes,

Line 2267: Procedure update_validate(p_rec in out nocopy per_qua_shd.g_rec_type,

2263: --
2264: -- ----------------------------------------------------------------------------
2265: -- |---------------------------< update_validate >----------------------------|
2266: -- ----------------------------------------------------------------------------
2267: Procedure update_validate(p_rec in out nocopy per_qua_shd.g_rec_type,
2268: p_effective_date in date) is
2269: --
2270: l_proc varchar2(72) := g_package||'update_validate';
2271: --

Line 2284: ,p_associated_column1 => per_qua_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

2280: --
2281: if p_rec.party_id is null and p_rec.business_group_id is not null then
2282: hr_api.validate_bus_grp_id
2283: (p_business_group_id => p_rec.business_group_id
2284: ,p_associated_column1 => per_qua_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
2285: ); -- Validate Bus Grp
2286: end if;
2287: --
2288: -- After validating the set of important attributes,

Line 2446: Procedure delete_validate(p_rec in per_qua_shd.g_rec_type) is

2442: --
2443: -- ----------------------------------------------------------------------------
2444: -- |---------------------------< delete_validate >----------------------------|
2445: -- ----------------------------------------------------------------------------
2446: Procedure delete_validate(p_rec in per_qua_shd.g_rec_type) is
2447: --
2448: l_proc varchar2(72) := g_package||'delete_validate';
2449: --
2450: Begin