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

Line 54: hr_api.argument_changed_error

50: hr_utility.set_location(l_proc, 11);
51: --
52: exception
53: when l_error then
54: hr_api.argument_changed_error
55: (p_api_name => l_proc
56: ,p_argument => l_argument
57: ,p_base_table => per_par_shd.g_tab_nam);
58: when others then

Line 117: hr_api.mandatory_arg_error

113: hr_utility.set_location('Entering:'|| l_proc, 1);
114: --
115: -- Check mandatory parameters have been set
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'business_group_id'
120: ,p_argument_value => p_business_group_id
121: );

Line 298: effective_start_date and nvl(effective_end_date,hr_api.g_eot);

294: select 'Y'
295: from per_all_people_f
296: where person_id = p_owning_person_id
297: and p_effective_date between
298: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
299: --
300: --
301: -- Cursor to check if the owning_person_id is equal to
302: -- the appraisee_id in per_appraisals

Line 321: hr_api.mandatory_arg_error

317: end if;
318: --
319: -- Check mandatory parameters have been set
320: --
321: hr_api.mandatory_arg_error
322: (p_api_name => l_proc
323: ,p_argument => 'effective_date'
324: ,p_argument_value => p_effective_date
325: );

Line 330: hr_api.mandatory_arg_error

326: --
327: --
328: -- Check mandatory parameters have been set
329: --
330: hr_api.mandatory_arg_error
331: (p_api_name => l_proc
332: ,p_argument => 'business_group_id'
333: ,p_argument_value => p_business_group_id
334: );

Line 685: hr_api.mandatory_arg_error

681: hr_utility.set_location('Entering:'|| l_proc, 1);
682: --
683: -- Check mandatory parameters have been set
684: --
685: hr_api.mandatory_arg_error
686: (p_api_name => l_proc
687: ,p_argument => 'objective_id'
688: ,p_argument_value => p_objective_id
689: );

Line 775: AND nvl(per_obj_shd.g_old_rec.group_code, hr_api.g_varchar2)

771: (p_objective_id => p_objective_id
772: ,p_object_version_number => p_object_version_number);
773: --
774: IF (l_api_updating
775: AND nvl(per_obj_shd.g_old_rec.group_code, hr_api.g_varchar2)
776: = nvl(p_group_code, hr_api.g_varchar2))
777: THEN
778: RETURN;
779: END IF;

Line 776: = nvl(p_group_code, hr_api.g_varchar2))

772: ,p_object_version_number => p_object_version_number);
773: --
774: IF (l_api_updating
775: AND nvl(per_obj_shd.g_old_rec.group_code, hr_api.g_varchar2)
776: = nvl(p_group_code, hr_api.g_varchar2))
777: THEN
778: RETURN;
779: END IF;
780:

Line 787: if hr_api.not_exists_in_hr_lookups

783: --
784: -- Checks that the group code is valid
785: --
786: if p_group_code is not null then
787: if hr_api.not_exists_in_hr_lookups
788: (p_effective_date => p_effective_date
789: ,p_lookup_type => 'HR_WPM_GROUP'
790: ,p_lookup_code => p_group_code
791: ) then

Line 863: AND nvl(per_obj_shd.g_old_rec.priority_code, hr_api.g_varchar2)

859: (p_objective_id => p_objective_id
860: ,p_object_version_number => p_object_version_number);
861: --
862: IF (l_api_updating
863: AND nvl(per_obj_shd.g_old_rec.priority_code, hr_api.g_varchar2)
864: = nvl(p_priority_code, hr_api.g_varchar2))
865: THEN
866: RETURN;
867: END IF;

Line 864: = nvl(p_priority_code, hr_api.g_varchar2))

860: ,p_object_version_number => p_object_version_number);
861: --
862: IF (l_api_updating
863: AND nvl(per_obj_shd.g_old_rec.priority_code, hr_api.g_varchar2)
864: = nvl(p_priority_code, hr_api.g_varchar2))
865: THEN
866: RETURN;
867: END IF;
868:

Line 875: if hr_api.not_exists_in_hr_lookups

871: --
872: -- Checks that the priority code is valid
873: --
874: if p_priority_code is not null then
875: if hr_api.not_exists_in_hr_lookups
876: (p_effective_date => p_effective_date
877: ,p_lookup_type => 'HR_WPM_PRIORITY'
878: ,p_lookup_code => p_priority_code
879: ) then

Line 944: hr_api.mandatory_arg_error

940: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
941:
942: IF p_scorecard_id IS NOT null THEN
943: --
944: hr_api.mandatory_arg_error
945: (p_api_name => l_proc
946: ,p_argument => 'p_appraise_flag'
947: ,p_argument_value => p_appraise_flag
948: );

Line 960: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)

956: (p_objective_id => p_objective_id
957: ,p_object_version_number => p_object_version_number);
958: --
959: IF (l_api_updating
960: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
961: = nvl(p_appraise_flag, hr_api.g_varchar2))
962: THEN
963: RETURN;
964: END IF;

Line 961: = nvl(p_appraise_flag, hr_api.g_varchar2))

957: ,p_object_version_number => p_object_version_number);
958: --
959: IF (l_api_updating
960: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
961: = nvl(p_appraise_flag, hr_api.g_varchar2))
962: THEN
963: RETURN;
964: END IF;
965:

Line 971: if hr_api.not_exists_in_hr_lookups

967:
968: --
969: -- Checks that the appraise flag is valid
970: --
971: if hr_api.not_exists_in_hr_lookups
972: (p_effective_date => p_effective_date
973: ,p_lookup_type => 'YES_NO'
974: ,p_lookup_code => p_appraise_flag
975: ) then

Line 1045: AND nvl(per_obj_shd.g_old_rec.complete_percent, hr_api.g_number)

1041: (p_objective_id => p_objective_id
1042: ,p_object_version_number => p_object_version_number);
1043: --
1044: IF (l_api_updating
1045: AND nvl(per_obj_shd.g_old_rec.complete_percent, hr_api.g_number)
1046: = nvl(p_complete_percent, hr_api.g_number))
1047: THEN
1048: RETURN;
1049: END IF;

Line 1046: = nvl(p_complete_percent, hr_api.g_number))

1042: ,p_object_version_number => p_object_version_number);
1043: --
1044: IF (l_api_updating
1045: AND nvl(per_obj_shd.g_old_rec.complete_percent, hr_api.g_number)
1046: = nvl(p_complete_percent, hr_api.g_number))
1047: THEN
1048: RETURN;
1049: END IF;
1050:

Line 1141: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)

1137: (p_objective_id => p_objective_id
1138: ,p_object_version_number => p_object_version_number);
1139: --
1140: IF (l_api_updating
1141: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
1142: = nvl(p_appraise_flag, hr_api.g_varchar2)
1143: AND nvl(per_obj_shd.g_old_rec.weighting_percent, hr_api.g_number)
1144: = nvl(p_weighting_percent, hr_api.g_number))
1145: THEN

Line 1142: = nvl(p_appraise_flag, hr_api.g_varchar2)

1138: ,p_object_version_number => p_object_version_number);
1139: --
1140: IF (l_api_updating
1141: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
1142: = nvl(p_appraise_flag, hr_api.g_varchar2)
1143: AND nvl(per_obj_shd.g_old_rec.weighting_percent, hr_api.g_number)
1144: = nvl(p_weighting_percent, hr_api.g_number))
1145: THEN
1146: RETURN;

Line 1143: AND nvl(per_obj_shd.g_old_rec.weighting_percent, hr_api.g_number)

1139: --
1140: IF (l_api_updating
1141: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
1142: = nvl(p_appraise_flag, hr_api.g_varchar2)
1143: AND nvl(per_obj_shd.g_old_rec.weighting_percent, hr_api.g_number)
1144: = nvl(p_weighting_percent, hr_api.g_number))
1145: THEN
1146: RETURN;
1147: END IF;

Line 1144: = nvl(p_weighting_percent, hr_api.g_number))

1140: IF (l_api_updating
1141: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
1142: = nvl(p_appraise_flag, hr_api.g_varchar2)
1143: AND nvl(per_obj_shd.g_old_rec.weighting_percent, hr_api.g_number)
1144: = nvl(p_weighting_percent, hr_api.g_number))
1145: THEN
1146: RETURN;
1147: END IF;
1148:

Line 1168: if hr_api.not_exists_in_hr_lookups

1164: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1165: --
1166: -- Checks that the weighting_percent is a valid lookup value
1167: --
1168: if hr_api.not_exists_in_hr_lookups
1169: (p_effective_date => p_effective_date
1170: ,p_lookup_type => 'HR_WPM_WEIGHTING'
1171: ,p_lookup_code => p_weighting_percent
1172: ) then

Line 1244: hr_api.mandatory_arg_error

1240: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 1); END IF;
1241:
1242: IF p_scorecard_id IS NOT null THEN
1243: --
1244: hr_api.mandatory_arg_error
1245: (p_api_name => l_proc
1246: ,p_argument => 'p_measurement_style_code'
1247: ,p_argument_value => p_measurement_style_code
1248: );

Line 1260: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1256: (p_objective_id => p_objective_id
1257: ,p_object_version_number => p_object_version_number);
1258: --
1259: IF (l_api_updating
1260: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1261: = nvl(p_measurement_style_code, hr_api.g_varchar2))
1262: THEN
1263: RETURN;
1264: END IF;

Line 1261: = nvl(p_measurement_style_code, hr_api.g_varchar2))

1257: ,p_object_version_number => p_object_version_number);
1258: --
1259: IF (l_api_updating
1260: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1261: = nvl(p_measurement_style_code, hr_api.g_varchar2))
1262: THEN
1263: RETURN;
1264: END IF;
1265:

Line 1271: if hr_api.not_exists_in_hr_lookups

1267:
1268: --
1269: -- Checks that the measurement_style_code is valid
1270: --
1271: if hr_api.not_exists_in_hr_lookups
1272: (p_effective_date => p_effective_date
1273: ,p_lookup_type => 'HR_WPM_MEASURE'
1274: ,p_lookup_code => p_measurement_style_code
1275: ) then

Line 1350: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1346: (p_objective_id => p_objective_id
1347: ,p_object_version_number => p_object_version_number);
1348: --
1349: IF (l_api_updating
1350: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1351: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1352: AND nvl(per_obj_shd.g_old_rec.measure_name, hr_api.g_varchar2)
1353: = nvl(p_measure_name, hr_api.g_varchar2))
1354: THEN

Line 1351: = nvl(p_measurement_style_code, hr_api.g_varchar2)

1347: ,p_object_version_number => p_object_version_number);
1348: --
1349: IF (l_api_updating
1350: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1351: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1352: AND nvl(per_obj_shd.g_old_rec.measure_name, hr_api.g_varchar2)
1353: = nvl(p_measure_name, hr_api.g_varchar2))
1354: THEN
1355: RETURN;

Line 1352: AND nvl(per_obj_shd.g_old_rec.measure_name, hr_api.g_varchar2)

1348: --
1349: IF (l_api_updating
1350: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1351: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1352: AND nvl(per_obj_shd.g_old_rec.measure_name, hr_api.g_varchar2)
1353: = nvl(p_measure_name, hr_api.g_varchar2))
1354: THEN
1355: RETURN;
1356: END IF;

Line 1353: = nvl(p_measure_name, hr_api.g_varchar2))

1349: IF (l_api_updating
1350: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1351: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1352: AND nvl(per_obj_shd.g_old_rec.measure_name, hr_api.g_varchar2)
1353: = nvl(p_measure_name, hr_api.g_varchar2))
1354: THEN
1355: RETURN;
1356: END IF;
1357:

Line 1369: hr_api.mandatory_arg_error

1365: if p_measurement_style_code <> 'N_M'
1366: then
1367: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1368:
1369: hr_api.mandatory_arg_error
1370: (p_api_name => l_proc
1371: ,p_argument => 'p_measure_name'
1372: ,p_argument_value => p_measure_name
1373: );

Line 1445: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1441: (p_objective_id => p_objective_id
1442: ,p_object_version_number => p_object_version_number);
1443: --
1444: IF (l_api_updating
1445: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1446: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1447: AND nvl(per_obj_shd.g_old_rec.target_value, hr_api.g_number)
1448: = nvl(p_target_value, hr_api.g_number))
1449: THEN

Line 1446: = nvl(p_measurement_style_code, hr_api.g_varchar2)

1442: ,p_object_version_number => p_object_version_number);
1443: --
1444: IF (l_api_updating
1445: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1446: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1447: AND nvl(per_obj_shd.g_old_rec.target_value, hr_api.g_number)
1448: = nvl(p_target_value, hr_api.g_number))
1449: THEN
1450: RETURN;

Line 1447: AND nvl(per_obj_shd.g_old_rec.target_value, hr_api.g_number)

1443: --
1444: IF (l_api_updating
1445: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1446: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1447: AND nvl(per_obj_shd.g_old_rec.target_value, hr_api.g_number)
1448: = nvl(p_target_value, hr_api.g_number))
1449: THEN
1450: RETURN;
1451: END IF;

Line 1448: = nvl(p_target_value, hr_api.g_number))

1444: IF (l_api_updating
1445: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1446: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1447: AND nvl(per_obj_shd.g_old_rec.target_value, hr_api.g_number)
1448: = nvl(p_target_value, hr_api.g_number))
1449: THEN
1450: RETURN;
1451: END IF;
1452:

Line 1464: hr_api.mandatory_arg_error

1460: if p_measurement_style_code = 'QUANT_M'
1461: then
1462: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1463:
1464: hr_api.mandatory_arg_error
1465: (p_api_name => l_proc
1466: ,p_argument => 'p_target_value'
1467: ,p_argument_value => p_target_value
1468: );

Line 1539: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1535: (p_objective_id => p_objective_id
1536: ,p_object_version_number => p_object_version_number);
1537: --
1538: IF (l_api_updating
1539: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1540: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1541: AND nvl(per_obj_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1542: = nvl(p_uom_code, hr_api.g_varchar2))
1543: THEN

Line 1540: = nvl(p_measurement_style_code, hr_api.g_varchar2)

1536: ,p_object_version_number => p_object_version_number);
1537: --
1538: IF (l_api_updating
1539: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1540: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1541: AND nvl(per_obj_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1542: = nvl(p_uom_code, hr_api.g_varchar2))
1543: THEN
1544: RETURN;

Line 1541: AND nvl(per_obj_shd.g_old_rec.uom_code, hr_api.g_varchar2)

1537: --
1538: IF (l_api_updating
1539: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1540: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1541: AND nvl(per_obj_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1542: = nvl(p_uom_code, hr_api.g_varchar2))
1543: THEN
1544: RETURN;
1545: END IF;

Line 1542: = nvl(p_uom_code, hr_api.g_varchar2))

1538: IF (l_api_updating
1539: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1540: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1541: AND nvl(per_obj_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1542: = nvl(p_uom_code, hr_api.g_varchar2))
1543: THEN
1544: RETURN;
1545: END IF;
1546:

Line 1558: hr_api.mandatory_arg_error

1554: if p_measurement_style_code = 'QUANT_M'
1555: then
1556: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1557:
1558: hr_api.mandatory_arg_error
1559: (p_api_name => l_proc
1560: ,p_argument => 'p_uom_code'
1561: ,p_argument_value => p_uom_code
1562: );

Line 1573: if hr_api.not_exists_in_hr_lookups

1569: --
1570: -- Checks that the UOM code is valid
1571: --
1572: if p_uom_code is not null then
1573: if hr_api.not_exists_in_hr_lookups
1574: (p_effective_date => p_effective_date
1575: ,p_lookup_type => 'HR_WPM_MEASURE_UOM'
1576: ,p_lookup_code => p_uom_code
1577: ) then

Line 1650: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1646: (p_objective_id => p_objective_id
1647: ,p_object_version_number => p_object_version_number);
1648: --
1649: IF (l_api_updating
1650: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1651: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1652: AND nvl(per_obj_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1653: = nvl(p_measure_type_code, hr_api.g_varchar2))
1654: THEN

Line 1651: = nvl(p_measurement_style_code, hr_api.g_varchar2)

1647: ,p_object_version_number => p_object_version_number);
1648: --
1649: IF (l_api_updating
1650: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1651: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1652: AND nvl(per_obj_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1653: = nvl(p_measure_type_code, hr_api.g_varchar2))
1654: THEN
1655: RETURN;

Line 1652: AND nvl(per_obj_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)

1648: --
1649: IF (l_api_updating
1650: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1651: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1652: AND nvl(per_obj_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1653: = nvl(p_measure_type_code, hr_api.g_varchar2))
1654: THEN
1655: RETURN;
1656: END IF;

Line 1653: = nvl(p_measure_type_code, hr_api.g_varchar2))

1649: IF (l_api_updating
1650: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1651: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1652: AND nvl(per_obj_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1653: = nvl(p_measure_type_code, hr_api.g_varchar2))
1654: THEN
1655: RETURN;
1656: END IF;
1657:

Line 1669: hr_api.mandatory_arg_error

1665: if p_measurement_style_code = 'QUANT_M'
1666: then
1667: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
1668:
1669: hr_api.mandatory_arg_error
1670: (p_api_name => l_proc
1671: ,p_argument => 'p_measure_type_code'
1672: ,p_argument_value => p_measure_type_code
1673: );

Line 1684: if hr_api.not_exists_in_hr_lookups

1680: --
1681: -- Checks that the measure type code is valid
1682: --
1683: if p_measure_type_code is not null then
1684: if hr_api.not_exists_in_hr_lookups
1685: (p_effective_date => p_effective_date
1686: ,p_lookup_type => 'HR_WPM_MEASURE_TYPE'
1687: ,p_lookup_code => p_measure_type_code
1688: ) then

Line 1760: AND nvl(per_obj_shd.g_old_rec.scorecard_id, hr_api.g_number)

1756: (p_objective_id => p_objective_id
1757: ,p_object_version_number => p_object_version_number);
1758: --
1759: IF (l_api_updating
1760: AND nvl(per_obj_shd.g_old_rec.scorecard_id, hr_api.g_number)
1761: = nvl(p_scorecard_id, hr_api.g_number))
1762: THEN
1763: RETURN;
1764: END IF;

Line 1761: = nvl(p_scorecard_id, hr_api.g_number))

1757: ,p_object_version_number => p_object_version_number);
1758: --
1759: IF (l_api_updating
1760: AND nvl(per_obj_shd.g_old_rec.scorecard_id, hr_api.g_number)
1761: = nvl(p_scorecard_id, hr_api.g_number))
1762: THEN
1763: RETURN;
1764: END IF;
1765: --

Line 1768: IF nvl(p_scorecard_id,hr_api.g_number) <> hr_api.g_number THEN

1764: END IF;
1765: --
1766: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 11); END IF;
1767: --
1768: IF nvl(p_scorecard_id,hr_api.g_number) <> hr_api.g_number THEN
1769: --
1770: -- Check that scorecard exists.
1771: --
1772: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;

Line 1859: AND nvl(per_obj_shd.g_old_rec.copied_from_library_id, hr_api.g_number)

1855: (p_objective_id => p_objective_id
1856: ,p_object_version_number => p_object_version_number);
1857: --
1858: IF (l_api_updating
1859: AND nvl(per_obj_shd.g_old_rec.copied_from_library_id, hr_api.g_number)
1860: = nvl(p_copied_from_lib_id, hr_api.g_number))
1861: THEN
1862: RETURN;
1863: END IF;

Line 1860: = nvl(p_copied_from_lib_id, hr_api.g_number))

1856: ,p_object_version_number => p_object_version_number);
1857: --
1858: IF (l_api_updating
1859: AND nvl(per_obj_shd.g_old_rec.copied_from_library_id, hr_api.g_number)
1860: = nvl(p_copied_from_lib_id, hr_api.g_number))
1861: THEN
1862: RETURN;
1863: END IF;
1864: --

Line 1867: if nvl(p_copied_from_lib_id,hr_api.g_number) <> hr_api.g_number then

1863: END IF;
1864: --
1865: IF g_debug THEN hr_utility.set_location(l_proc, 11); END IF;
1866: --
1867: if nvl(p_copied_from_lib_id,hr_api.g_number) <> hr_api.g_number then
1868: open csr_objlib_exists;
1869: fetch csr_objlib_exists into l_exists;
1870: if csr_objlib_exists%notfound then
1871: close csr_objlib_exists;

Line 1949: AND nvl(per_obj_shd.g_old_rec.copied_from_objective_id, hr_api.g_number)

1945: (p_objective_id => p_objective_id
1946: ,p_object_version_number => p_object_version_number);
1947: --
1948: IF (l_api_updating
1949: AND nvl(per_obj_shd.g_old_rec.copied_from_objective_id, hr_api.g_number)
1950: = nvl(p_copied_from_obj_id, hr_api.g_number))
1951: THEN
1952: RETURN;
1953: END IF;

Line 1950: = nvl(p_copied_from_obj_id, hr_api.g_number))

1946: ,p_object_version_number => p_object_version_number);
1947: --
1948: IF (l_api_updating
1949: AND nvl(per_obj_shd.g_old_rec.copied_from_objective_id, hr_api.g_number)
1950: = nvl(p_copied_from_obj_id, hr_api.g_number))
1951: THEN
1952: RETURN;
1953: END IF;
1954: --

Line 1957: if nvl(p_copied_from_obj_id,hr_api.g_number) <> hr_api.g_number then

1953: END IF;
1954: --
1955: IF g_debug THEN hr_utility.set_location(l_proc, 11); END IF;
1956: --
1957: if nvl(p_copied_from_obj_id,hr_api.g_number) <> hr_api.g_number then
1958: open csr_obj_exists;
1959: fetch csr_obj_exists into l_exists;
1960: if csr_obj_exists%notfound then
1961: close csr_obj_exists;

Line 2117: AND nvl(per_obj_shd.g_old_rec.aligned_with_objective_id, hr_api.g_number)

2113: (p_objective_id => p_objective_id
2114: ,p_object_version_number => p_object_version_number);
2115: --
2116: IF (l_api_updating
2117: AND nvl(per_obj_shd.g_old_rec.aligned_with_objective_id, hr_api.g_number)
2118: = nvl(p_aligned_with_obj_id, hr_api.g_number))
2119: THEN
2120: RETURN;
2121: END IF;

Line 2118: = nvl(p_aligned_with_obj_id, hr_api.g_number))

2114: ,p_object_version_number => p_object_version_number);
2115: --
2116: IF (l_api_updating
2117: AND nvl(per_obj_shd.g_old_rec.aligned_with_objective_id, hr_api.g_number)
2118: = nvl(p_aligned_with_obj_id, hr_api.g_number))
2119: THEN
2120: RETURN;
2121: END IF;
2122: --

Line 2308: AND nvl(per_obj_shd.g_old_rec.sharing_access_code, hr_api.g_varchar2)

2304: (p_objective_id => p_objective_id
2305: ,p_object_version_number => p_object_version_number);
2306: --
2307: IF (l_api_updating
2308: AND nvl(per_obj_shd.g_old_rec.sharing_access_code, hr_api.g_varchar2)
2309: = nvl(p_sharing_access_code, hr_api.g_varchar2))
2310: THEN
2311: RETURN;
2312: END IF;

Line 2309: = nvl(p_sharing_access_code, hr_api.g_varchar2))

2305: ,p_object_version_number => p_object_version_number);
2306: --
2307: IF (l_api_updating
2308: AND nvl(per_obj_shd.g_old_rec.sharing_access_code, hr_api.g_varchar2)
2309: = nvl(p_sharing_access_code, hr_api.g_varchar2))
2310: THEN
2311: RETURN;
2312: END IF;
2313:

Line 2320: if hr_api.not_exists_in_hr_lookups

2316: --
2317: -- Checks that the group code is valid
2318: --
2319: if p_sharing_access_code is not null then
2320: if hr_api.not_exists_in_hr_lookups
2321: (p_effective_date => p_effective_date
2322: ,p_lookup_type => 'HR_WPM_OBJECTIVE_SHARING'
2323: ,p_lookup_code => p_sharing_access_code
2324: ) then

Line 2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

2374: begin
2375: hr_utility.set_location('Entering:'||l_proc, 10);
2376: --
2377: if ((p_rec.objective_id is not null) and (
2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2379: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

2375: hr_utility.set_location('Entering:'||l_proc, 10);
2376: --
2377: if ((p_rec.objective_id is not null) and (
2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2379: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

2376: --
2377: if ((p_rec.objective_id is not null) and (
2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2379: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

2377: if ((p_rec.objective_id is not null) and (
2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2379: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2379: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

2379: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or

Line 2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:

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

2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or

Line 2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or

2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or

2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or

Line 2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or

2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or

Line 2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or

2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or

Line 2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or

2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or

Line 2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or

2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or

Line 2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or

2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or

Line 2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or

2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or

Line 2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or

2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
2440: nvl(p_rec.attribute30, hr_api.g_varchar2)))

Line 2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
2440: nvl(p_rec.attribute30, hr_api.g_varchar2)))
2441:

Line 2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or

2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
2440: nvl(p_rec.attribute30, hr_api.g_varchar2)))
2441:
2442:

Line 2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
2440: nvl(p_rec.attribute30, hr_api.g_varchar2)))
2441:
2442:
2443: or

Line 2440: nvl(p_rec.attribute30, hr_api.g_varchar2)))

2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
2440: nvl(p_rec.attribute30, hr_api.g_varchar2)))
2441:
2442:
2443: or
2444: (p_rec.objective_id is null) then

Line 2538: hr_api.validate_bus_grp_id(p_rec.business_group_id

2534: hr_utility.set_location('Entering:'||l_proc, 5);
2535: --
2536: -- Call all supporting business operations
2537: --
2538: hr_api.validate_bus_grp_id(p_rec.business_group_id
2539: ,p_associated_column1 => per_obj_shd.g_tab_nam ||
2540: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
2541:
2542: hr_multi_message.end_validation_set;

Line 2808: hr_api.validate_bus_grp_id(p_rec.business_group_id

2804: --
2805: --
2806: -- Validate business_group_id
2807: --
2808: hr_api.validate_bus_grp_id(p_rec.business_group_id
2809: ,p_associated_column1 => per_obj_shd.g_tab_nam ||
2810: '.BUSINESS_GROUP_ID'
2811: );
2812:

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

3098: hr_utility.set_location('Entering:'||l_proc, 10);
3099: --
3100: -- Ensure that all the mandatory parameters are not null
3101: --
3102: hr_api.mandatory_arg_error (p_api_name => l_proc,
3103: p_argument => 'objective_id',
3104: p_argument_value => p_objective_id );
3105: if nvl(g_objective_id, hr_api.g_number) = p_objective_id then
3106: --

Line 3105: if nvl(g_objective_id, hr_api.g_number) = p_objective_id then

3101: --
3102: hr_api.mandatory_arg_error (p_api_name => l_proc,
3103: p_argument => 'objective_id',
3104: p_argument_value => p_objective_id );
3105: if nvl(g_objective_id, hr_api.g_number) = p_objective_id then
3106: --
3107: -- The legislation code has already been found with a previous
3108: -- call to this function. Just return the value in the global
3109: -- variable.