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

Line 50: hr_api.argument_changed_error

46: hr_utility.set_location(l_proc, 11);
47:
48: exception
49: when l_error then
50: hr_api.argument_changed_error
51: (p_api_name => l_proc
52: ,p_argument => l_argument);
53: when others then
54: raise;

Line 129: <> nvl(p_name,hr_api.g_varchar2))

125: (p_appraisal_template_id => p_appraisal_template_id
126: ,p_object_version_number => p_object_version_number);
127:
128: if ( (l_api_updating and (per_apt_shd.g_old_rec.name
129: <> nvl(p_name,hr_api.g_varchar2))
130: ) or
131: (NOT l_api_updating)
132: ) then
133:

Line 214: where ( apr.appraisal_period_start_date < nvl(p_date_from,hr_api.g_sot)

210:
211: Cursor csr_check_dates_in_apr is
212: select 'Y'
213: from per_appraisals apr
214: where ( apr.appraisal_period_start_date < nvl(p_date_from,hr_api.g_sot)
215: or apr.appraisal_period_end_date > nvl(p_date_to,hr_api.g_eot)
216: )
217: and apr.appraisal_template_id = p_appraisal_template_id;
218:

Line 215: or apr.appraisal_period_end_date > nvl(p_date_to,hr_api.g_eot)

211: Cursor csr_check_dates_in_apr is
212: select 'Y'
213: from per_appraisals apr
214: where ( apr.appraisal_period_start_date < nvl(p_date_from,hr_api.g_sot)
215: or apr.appraisal_period_end_date > nvl(p_date_to,hr_api.g_eot)
216: )
217: and apr.appraisal_template_id = p_appraisal_template_id;
218:
219:

Line 230: if ( nvl(p_date_from,hr_api.g_sot) > nvl(p_date_to,hr_api.g_eot) )

226: hr_utility.set_message(800, 'HR_52247_APT_DATE_FROM_NULL');
227: hr_utility.raise_error;
228: end if;
229: -- Date From has to be <= date to, else error.
230: if ( nvl(p_date_from,hr_api.g_sot) > nvl(p_date_to,hr_api.g_eot) )
231: then
232: hr_utility.set_message(801, 'HR_51909_APT_DATE_FROM_BEFORE');
233: hr_utility.raise_error;
234: end if;

Line 236: if ( nvl(p_date_to,hr_api.g_eot) < nvl(p_date_from,hr_api.g_sot) )

232: hr_utility.set_message(801, 'HR_51909_APT_DATE_FROM_BEFORE');
233: hr_utility.raise_error;
234: end if;
235: -- Date To has to be >= date to, else error.
236: if ( nvl(p_date_to,hr_api.g_eot) < nvl(p_date_from,hr_api.g_sot) )
237: then
238: hr_utility.set_message(801, 'HR_51910_APT_DATE_TO_AFTER');
239: hr_utility.raise_error;
240: end if;

Line 250: if ( ((l_api_updating) and (per_apt_shd.g_old_rec.date_from <> nvl(p_date_from,hr_api.g_date)) )

246: -- Only continue if:
247: -- a) The current g_old_rec is current and
248: -- b) The value for dates have changed
249:
250: if ( ((l_api_updating) and (per_apt_shd.g_old_rec.date_from <> nvl(p_date_from,hr_api.g_date)) )
251: or ((l_api_updating) and (per_apt_shd.g_old_rec.date_to <> nvl(p_date_to,hr_api.g_date)) )
252: ) then
253:
254: -- only continue if we are updating and the dates have changed from the

Line 251: or ((l_api_updating) and (per_apt_shd.g_old_rec.date_to <> nvl(p_date_to,hr_api.g_date)) )

247: -- a) The current g_old_rec is current and
248: -- b) The value for dates have changed
249:
250: if ( ((l_api_updating) and (per_apt_shd.g_old_rec.date_from <> nvl(p_date_from,hr_api.g_date)) )
251: or ((l_api_updating) and (per_apt_shd.g_old_rec.date_to <> nvl(p_date_to,hr_api.g_date)) )
252: ) then
253:
254: -- only continue if we are updating and the dates have changed from the
255: -- previous values

Line 347: and nvl(date_from,hr_api.g_sot) <= nvl(p_date_from,hr_api.g_eot)

343: is
344: select 'Y'
345: from per_assessment_types
346: where assessment_type_id = p_assessment_type_id
347: and nvl(date_from,hr_api.g_sot) <= nvl(p_date_from,hr_api.g_eot)
348: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;
349: -- Bug 3947233 Ends Here
350:
351: begin

Line 348: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;

344: select 'Y'
345: from per_assessment_types
346: where assessment_type_id = p_assessment_type_id
347: and nvl(date_from,hr_api.g_sot) <= nvl(p_date_from,hr_api.g_eot)
348: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;
349: -- Bug 3947233 Ends Here
350:
351: begin
352: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 368: and (nvl(per_apt_shd.g_old_rec.assessment_type_id,hr_api.g_number)

364: -- a) The current g_old_rec is current and
365: -- b) The value for assessment type has changed
366:
367: if ( (l_api_updating
368: and (nvl(per_apt_shd.g_old_rec.assessment_type_id,hr_api.g_number)
369: <> nvl(p_assessment_type_id,hr_api.g_number))
370: ) or
371: (NOT l_api_updating)
372: ) then

Line 369: <> nvl(p_assessment_type_id,hr_api.g_number))

365: -- b) The value for assessment type has changed
366:
367: if ( (l_api_updating
368: and (nvl(per_apt_shd.g_old_rec.assessment_type_id,hr_api.g_number)
369: <> nvl(p_assessment_type_id,hr_api.g_number))
370: ) or
371: (NOT l_api_updating)
372: ) then
373:

Line 480: and nvl(date_from,hr_api.g_sot) <= nvl(p_date_from,hr_api.g_eot)

476: is
477: select 'Y'
478: from per_assessment_types
479: where assessment_type_id = p_objective_asmnt_type_id
480: and nvl(date_from,hr_api.g_sot) <= nvl(p_date_from,hr_api.g_eot)
481: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;
482: -- Bug 3947233 Ends Here
483:
484: begin

Line 481: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;

477: select 'Y'
478: from per_assessment_types
479: where assessment_type_id = p_objective_asmnt_type_id
480: and nvl(date_from,hr_api.g_sot) <= nvl(p_date_from,hr_api.g_eot)
481: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;
482: -- Bug 3947233 Ends Here
483:
484: begin
485: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 498: and (nvl(per_apt_shd.g_old_rec.objective_asmnt_type_id,hr_api.g_number)

494: -- a) The current g_old_rec is current and
495: -- b) The value for assessment type has changed
496:
497: if ( (l_api_updating
498: and (nvl(per_apt_shd.g_old_rec.objective_asmnt_type_id,hr_api.g_number)
499: <> nvl(p_objective_asmnt_type_id,hr_api.g_number))
500: ) or
501: (NOT l_api_updating)
502: ) then

Line 499: <> nvl(p_objective_asmnt_type_id,hr_api.g_number))

495: -- b) The value for assessment type has changed
496:
497: if ( (l_api_updating
498: and (nvl(per_apt_shd.g_old_rec.objective_asmnt_type_id,hr_api.g_number)
499: <> nvl(p_objective_asmnt_type_id,hr_api.g_number))
500: ) or
501: (NOT l_api_updating)
502: ) then
503:

Line 676: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.questionnaire_template_id, hr_api.g_number)

672: -- Perform the following check only if updating and the value of
673: -- questionnaire_template_id has changed
674:
675: -- Added nvl around per_apt_shd.g_old_rec.questionnaire_template_id
676: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.questionnaire_template_id, hr_api.g_number)
677: <> nvl(p_questionnaire_template_id,hr_api.g_number)) )
678: )
679: then
680:

Line 677: <> nvl(p_questionnaire_template_id,hr_api.g_number)) )

673: -- questionnaire_template_id has changed
674:
675: -- Added nvl around per_apt_shd.g_old_rec.questionnaire_template_id
676: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.questionnaire_template_id, hr_api.g_number)
677: <> nvl(p_questionnaire_template_id,hr_api.g_number)) )
678: )
679: then
680:
681: -- Check if the questionnaire template can be updated first.

Line 860: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.ma_quest_template_id, hr_api.g_number)

856: -- Perform the following check only if updating and the value of
857: -- ma_quest_template_id has changed
858:
859: -- Added nvl around per_apt_shd.g_old_rec.ma_quest_template_id
860: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.ma_quest_template_id, hr_api.g_number)
861: <> nvl(p_ma_quest_template_id,hr_api.g_number)) )
862: )
863: then
864:

Line 861: <> nvl(p_ma_quest_template_id,hr_api.g_number)) )

857: -- ma_quest_template_id has changed
858:
859: -- Added nvl around per_apt_shd.g_old_rec.ma_quest_template_id
860: if ( (l_api_updating and ( nvl(per_apt_shd.g_old_rec.ma_quest_template_id, hr_api.g_number)
861: <> nvl(p_ma_quest_template_id,hr_api.g_number)) )
862: )
863: then
864:
865: -- Check if the questionnaire template can be updated first.

Line 1005: /* hr_api.mandatory_arg_error

1001:
1002: -- Check mandatory parameters have been set
1003:
1004: -- ngundura change done for pa requirements
1005: /* hr_api.mandatory_arg_error
1006: (p_api_name => l_proc
1007: ,p_argument => 'business_group_id'
1008: ,p_argument_value => p_business_group_id
1009: );

Line 1059: <> nvl(p_rating_scale_id,hr_api.g_number)) )

1055: -- Perform the below checks only if updating and the value of the
1056: -- rating_scale_id has changed
1057:
1058: if ( (l_api_updating and (per_apt_shd.g_old_rec.rating_scale_id
1059: <> nvl(p_rating_scale_id,hr_api.g_number)) )
1060: )
1061: then
1062:
1063: -- Check if the rating scale can be updated

Line 1174: hr_api.mandatory_arg_error

1170: hr_utility.set_location('Entering:'|| l_proc, 1);
1171:
1172: -- Check mandatory parameters have been set
1173:
1174: hr_api.mandatory_arg_error
1175: (p_api_name => l_proc
1176: ,p_argument => 'appraisal_template_id'
1177: ,p_argument_value => p_appraisal_template_id
1178: );

Line 1261: hr_api.mandatory_arg_error

1257: end if;
1258: --
1259: -- Check mandatory parameters have been set
1260: --
1261: hr_api.mandatory_arg_error
1262: (p_api_name => l_proc
1263: ,p_argument => 'effective_date'
1264: ,p_argument_value => p_effective_date
1265: );

Line 1278: hr_api.g_varchar2)

1274: (p_appraisal_template_id => p_appraisal_template_id
1275: ,p_object_version_number => p_object_version_number);
1276: --
1277: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.update_personal_comp_profile,
1278: hr_api.g_varchar2)
1279: <> nvl(p_update_personal_comp_profile, hr_api.g_varchar2))
1280: or
1281: (NOT l_api_updating)) then
1282: --

Line 1279: <> nvl(p_update_personal_comp_profile, hr_api.g_varchar2))

1275: ,p_object_version_number => p_object_version_number);
1276: --
1277: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.update_personal_comp_profile,
1278: hr_api.g_varchar2)
1279: <> nvl(p_update_personal_comp_profile, hr_api.g_varchar2))
1280: or
1281: (NOT l_api_updating)) then
1282: --
1283: hr_utility.set_location(l_proc, 5);

Line 1287: if hr_api.not_exists_in_hr_lookups

1283: hr_utility.set_location(l_proc, 5);
1284: --
1285: -- Check the value in p_display_assessment_comments exists in hr_lookups
1286: --
1287: if hr_api.not_exists_in_hr_lookups
1288: (p_effective_date => p_effective_date
1289: ,p_lookup_type => 'YES_NO'
1290: ,p_lookup_code => p_update_personal_comp_profile
1291: ) then

Line 1365: hr_api.mandatory_arg_error

1361: end if;
1362: --
1363: -- Check mandatory parameters have been set
1364: --
1365: hr_api.mandatory_arg_error
1366: (p_api_name => l_proc
1367: ,p_argument => 'effective_date'
1368: ,p_argument_value => p_effective_date
1369: );

Line 1382: hr_api.g_varchar2)

1378: (p_appraisal_template_id => p_appraisal_template_id
1379: ,p_object_version_number => p_object_version_number);
1380: --
1381: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.comp_profile_source_type,
1382: hr_api.g_varchar2)
1383: <> nvl(p_comp_profile_source_type, hr_api.g_varchar2))
1384: or
1385: (NOT l_api_updating)) then
1386: --

Line 1383: <> nvl(p_comp_profile_source_type, hr_api.g_varchar2))

1379: ,p_object_version_number => p_object_version_number);
1380: --
1381: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.comp_profile_source_type,
1382: hr_api.g_varchar2)
1383: <> nvl(p_comp_profile_source_type, hr_api.g_varchar2))
1384: or
1385: (NOT l_api_updating)) then
1386: --
1387: hr_utility.set_location(l_proc, 5);

Line 1391: if hr_api.not_exists_in_hr_lookups

1387: hr_utility.set_location(l_proc, 5);
1388: --
1389: -- Check the value in p_display_assessment_comments exists in hr_lookups
1390: --
1391: if hr_api.not_exists_in_hr_lookups
1392: (p_effective_date => p_effective_date
1393: ,p_lookup_type => 'PROFICIENCY_SOURCE'
1394: ,p_lookup_code => p_comp_profile_source_type
1395: ) then

Line 1460: hr_api.mandatory_arg_error

1456:
1457: --
1458: -- Check mandatory parameters have been set
1459: --
1460: hr_api.mandatory_arg_error
1461: (p_api_name => l_proc
1462: ,p_argument => 'effective_date'
1463: ,p_argument_value => p_effective_date
1464: );

Line 1477: hr_api.g_varchar2)

1473: (p_appraisal_template_id => p_appraisal_template_id
1474: ,p_object_version_number => p_object_version_number);
1475: --
1476: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.link_appr_to_learning_path,
1477: hr_api.g_varchar2)
1478: <> nvl(p_link_appr_to_learning_path, hr_api.g_varchar2))
1479: or
1480: (NOT l_api_updating)) then
1481: --

Line 1478: <> nvl(p_link_appr_to_learning_path, hr_api.g_varchar2))

1474: ,p_object_version_number => p_object_version_number);
1475: --
1476: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.link_appr_to_learning_path,
1477: hr_api.g_varchar2)
1478: <> nvl(p_link_appr_to_learning_path, hr_api.g_varchar2))
1479: or
1480: (NOT l_api_updating)) then
1481: --
1482: hr_utility.set_location(l_proc, 5);

Line 1486: if hr_api.not_exists_in_hr_lookups

1482: hr_utility.set_location(l_proc, 5);
1483: --
1484: -- Check the value in p_link_appr_to_learning_path exists in hr_lookups
1485: --
1486: if hr_api.not_exists_in_hr_lookups
1487: (p_effective_date => p_effective_date
1488: ,p_lookup_type => 'YES_NO'
1489: ,p_lookup_code => p_link_appr_to_learning_path
1490: ) then

Line 1555: hr_api.mandatory_arg_error

1551:
1552: --
1553: -- Check mandatory parameters have been set
1554: --
1555: hr_api.mandatory_arg_error
1556: (p_api_name => l_proc
1557: ,p_argument => 'effective_date'
1558: ,p_argument_value => p_effective_date
1559: );

Line 1572: hr_api.g_varchar2)

1568: (p_appraisal_template_id => p_appraisal_template_id
1569: ,p_object_version_number => p_object_version_number);
1570: --
1571: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.available_flag,
1572: hr_api.g_varchar2)
1573: <> nvl(p_available_flag, hr_api.g_varchar2))
1574: or
1575: (NOT l_api_updating)) then
1576: --

Line 1573: <> nvl(p_available_flag, hr_api.g_varchar2))

1569: ,p_object_version_number => p_object_version_number);
1570: --
1571: if ((l_api_updating and nvl(per_apt_shd.g_old_rec.available_flag,
1572: hr_api.g_varchar2)
1573: <> nvl(p_available_flag, hr_api.g_varchar2))
1574: or
1575: (NOT l_api_updating)) then
1576: --
1577: hr_utility.set_location(l_proc, 5);

Line 1581: if hr_api.not_exists_in_hr_lookups

1577: hr_utility.set_location(l_proc, 5);
1578: --
1579: -- Check the value in p_available_flag exists in hr_lookups
1580: --
1581: if hr_api.not_exists_in_hr_lookups
1582: (p_effective_date => p_effective_date
1583: ,p_lookup_type => 'TEMPLATE_AVAILABILITY_FLAG'
1584: ,p_lookup_code => p_available_flag
1585: ) then

Line 1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1626: begin
1627: hr_utility.set_location('Entering:'||l_proc, 10);
1628:
1629: if ((p_rec.appraisal_template_id is not null) and (
1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1627: hr_utility.set_location('Entering:'||l_proc, 10);
1628:
1629: if ((p_rec.appraisal_template_id is not null) and (
1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1628:
1629: if ((p_rec.appraisal_template_id is not null) and (
1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1629: if ((p_rec.appraisal_template_id is not null) and (
1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1632: nvl(per_apt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1633: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1634: nvl(per_apt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1635: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1636: nvl(per_apt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1637: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1638: nvl(per_apt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1639: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1640: nvl(per_apt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1641: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1642: nvl(per_apt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1643: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1644: nvl(per_apt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1645: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1646: nvl(per_apt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1647: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1648: nvl(per_apt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1649: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1650: nvl(per_apt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1651: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1652: nvl(per_apt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1653: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1654: nvl(per_apt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1655: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1656: nvl(per_apt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1657: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1658: nvl(per_apt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1659: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1660: nvl(per_apt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1661: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1662: nvl(per_apt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1663: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1671: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1664: nvl(per_apt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1671: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1672: or

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

1665: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1671: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1672: or
1673: (p_rec.appraisal_template_id is null) then

Line 1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1666: nvl(per_apt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1671: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1672: or
1673: (p_rec.appraisal_template_id is null) then
1674:

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

1667: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1668: nvl(per_apt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1669: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1670: nvl(per_apt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1671: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1672: or
1673: (p_rec.appraisal_template_id is null) then
1674:
1675: -- Only execute the validation if absolutely necessary:

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

1740: hr_utility.set_location('Entering:'||l_proc, 5);
1741:
1742: -- Call all supporting business operations
1743: if p_rec.business_group_id is not null then
1744: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1745: end if;
1746:
1747: -- Check name is unique
1748:

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

1877:
1878: -- Call all supporting business operations
1879:
1880: if p_rec.business_group_id is not null then
1881: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1882:
1883: end if;
1884:
1885: -- Rule Check non-updateable fields cannot be updated

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

2049: hr_utility.set_location('Entering:'||l_proc, 5);
2050:
2051: -- Ensure that all the mandatory parameters are not null
2052:
2053: hr_api.mandatory_arg_error (p_api_name => l_proc,
2054: p_argument => 'appraisal_template_id',
2055: p_argument_value => p_appraisal_template_id );
2056:
2057: if nvl(g_appraisal_template_id, hr_api.g_number) = p_appraisal_template_id then

Line 2057: if nvl(g_appraisal_template_id, hr_api.g_number) = p_appraisal_template_id then

2053: hr_api.mandatory_arg_error (p_api_name => l_proc,
2054: p_argument => 'appraisal_template_id',
2055: p_argument_value => p_appraisal_template_id );
2056:
2057: if nvl(g_appraisal_template_id, hr_api.g_number) = p_appraisal_template_id then
2058:
2059: -- The legislation has already been found with a previous
2060: -- call to this function. Just return the value in the global
2061: -- variable.