APPS.PER_APR_BUS dependencies on HR_API

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

42: hr_utility.set_location('Entering:'|| l_proc, 10);
43:
44: -- Ensure that all the mandatory parameter are not null
45:
46: hr_api.mandatory_arg_error(p_api_name => l_proc,
47: p_argument => 'appraisal_id',
48: p_argument_value => p_appraisal_id);
49:
50: open csr_sec_grp;

Line 65: hr_api.set_security_group_id

61: close csr_sec_grp;
62: --
63: -- Set the security_group_id in CLIENT_INFO
64: --
65: hr_api.set_security_group_id
66: (p_security_group_id => l_security_group_id
67: );
68: end if;
69:

Line 186: hr_api.argument_changed_error

182:
183: hr_utility.set_location(l_proc, 6);
184:
185: if p_rec.business_group_id <> per_apr_shd.g_old_rec.business_group_id then
186: hr_api.argument_changed_error
187: (
188: p_api_name => l_proc
189: ,p_argument => 'BUSINESS_GROUP_ID'
190: ,p_base_table => per_per_shd.g_tab_nam

Line 194: hr_api.argument_changed_error

190: ,p_base_table => per_per_shd.g_tab_nam
191: );
192: elsif p_rec.appraisal_template_id <> per_apr_shd.g_old_rec.appraisal_template_id then
193: hr_utility.set_location(l_proc, 7);
194: hr_api.argument_changed_error
195: (
196: p_api_name => l_proc
197: ,p_argument => 'APPRAISAL_TEMPLATE_ID'
198: ,p_base_table => per_per_shd.g_tab_nam

Line 202: hr_api.argument_changed_error

198: ,p_base_table => per_per_shd.g_tab_nam
199: );
200: elsif p_rec.appraisee_person_id <> per_apr_shd.g_old_rec.appraisee_person_id then
201: hr_utility.set_location(l_proc, 8);
202: hr_api.argument_changed_error
203: (
204: p_api_name => l_proc
205: ,p_argument => 'APPRAISEE_ID'
206: ,p_base_table => per_per_shd.g_tab_nam

Line 210: hr_api.argument_changed_error

206: ,p_base_table => per_per_shd.g_tab_nam
207: );
208: elsif p_rec.assignment_id <> per_apr_shd.g_old_rec.assignment_id then
209: hr_utility.set_location(l_proc, 9);
210: hr_api.argument_changed_error
211: (
212: p_api_name => l_proc
213: ,p_argument => 'ASSIGNMENT_ID'
214: ,p_base_table => per_per_shd.g_tab_nam

Line 218: hr_api.argument_changed_error

214: ,p_base_table => per_per_shd.g_tab_nam
215: );
216: elsif p_rec.assignment_start_date <> per_apr_shd.g_old_rec.assignment_start_date then
217: hr_utility.set_location(l_proc, 10);
218: hr_api.argument_changed_error
219: (
220: p_api_name => l_proc
221: ,p_argument => 'ASSIGNMENT_START_DATE'
222: ,p_base_table => per_per_shd.g_tab_nam

Line 226: hr_api.argument_changed_error

222: ,p_base_table => per_per_shd.g_tab_nam
223: );
224: elsif p_rec.assignment_business_group_id <> per_apr_shd.g_old_rec.assignment_business_group_id then
225: hr_utility.set_location(l_proc, 11);
226: hr_api.argument_changed_error
227: (
228: p_api_name => l_proc
229: ,p_argument => 'ASSIGNMENT_BUSINESS_GROUP_ID'
230: ,p_base_table => per_per_shd.g_tab_nam

Line 234: hr_api.argument_changed_error

230: ,p_base_table => per_per_shd.g_tab_nam
231: );
232: elsif p_rec.assignment_organization_id <> per_apr_shd.g_old_rec.assignment_organization_id then
233: hr_utility.set_location(l_proc, 12);
234: hr_api.argument_changed_error
235: (
236: p_api_name => l_proc
237: ,p_argument => 'ASSIGNMENT_ORGANIZATION_ID'
238: ,p_base_table => per_per_shd.g_tab_nam

Line 242: hr_api.argument_changed_error

238: ,p_base_table => per_per_shd.g_tab_nam
239: );
240: elsif p_rec.assignment_job_id <> per_apr_shd.g_old_rec.assignment_job_id then
241: hr_utility.set_location(l_proc, 13);
242: hr_api.argument_changed_error
243: (
244: p_api_name => l_proc
245: ,p_argument => 'ASSIGNMENT_JOB_ID'
246: ,p_base_table => per_per_shd.g_tab_nam

Line 250: hr_api.argument_changed_error

246: ,p_base_table => per_per_shd.g_tab_nam
247: );
248: elsif p_rec.assignment_position_id <> per_apr_shd.g_old_rec.assignment_position_id then
249: hr_utility.set_location(l_proc, 14);
250: hr_api.argument_changed_error
251: (
252: p_api_name => l_proc
253: ,p_argument => 'ASSIGNMENT_POSITION_ID'
254: ,p_base_table => per_per_shd.g_tab_nam

Line 304: (hr_api.not_exists_in_hr_lookups

300:
301: hr_utility.set_location('Entering: '||l_proc,10);
302:
303: if (p_open <> null) and
304: (hr_api.not_exists_in_hr_lookups
305: (p_effective_date => p_effective_date
306: ,p_lookup_type => 'YES_NO'
307: ,p_lookup_code => p_open
308: )) then

Line 770: nvl(date_from,hr_api.g_sot) and nvl(date_to,hr_api.g_eot);

766: select 'Y'
767: from per_appraisal_templates
768: where appraisal_template_id = p_appraisal_template_id
769: and p_effective_date between
770: nvl(date_from,hr_api.g_sot) and nvl(date_to,hr_api.g_eot);
771:
772:
773: begin
774: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 778: hr_api.mandatory_arg_error

774: hr_utility.set_location('Entering:'|| l_proc, 1);
775:
776: -- Check mandatory parameters have been set
777:
778: hr_api.mandatory_arg_error
779: (p_api_name => l_proc
780: ,p_argument => 'business_group_id'
781: ,p_argument_value => p_business_group_id
782: );

Line 785: hr_api.mandatory_arg_error

781: ,p_argument_value => p_business_group_id
782: );
783:
784:
785: hr_api.mandatory_arg_error
786: (p_api_name => l_proc
787: ,p_argument => 'effective_date'
788: ,p_argument_value => p_effective_date
789: );

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

916: select 'Y'
917: from per_all_people_f
918: where person_id = p_person_id
919: and p_effective_date between
920: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
921:
922: -- bug 1980440 fix
923: -- WE NEED to use different cursors as Appraiser can be changed to
924: -- a person from a different BG

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

930: select 'Y'
931: from per_all_people_f
932: where person_id = p_person_id
933: and p_effective_date between
934: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
935:
936: begin
937: hr_utility.set_location('Entering:'|| l_proc, 1);
938:

Line 951: hr_api.mandatory_arg_error

947: end if;
948:
949: -- Check mandatory parameters have been set
950:
951: hr_api.mandatory_arg_error
952: (p_api_name => l_proc
953: ,p_argument => 'effective_date'
954: ,p_argument_value => p_effective_date
955: );

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

1072: from per_all_people_f ppf, wf_roles usr
1073: where person_id = p_main_appraiser_id
1074: and business_group_id = p_business_group_id
1075: and p_effective_date between
1076: effective_start_date and nvl(effective_end_date,hr_api.g_eot)
1077: AND ppf.person_id = usr.orig_system_id
1078: AND usr.orig_system = 'PER';
1079:
1080: -- Cursor to check if person is valid

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

1086: select 'Y'
1087: from per_all_people_f ppf, wf_roles usr
1088: where person_id = p_main_appraiser_id
1089: and p_effective_date between
1090: effective_start_date and nvl(effective_end_date,hr_api.g_eot)
1091: AND ppf.person_id = usr.orig_system_id
1092: AND usr.orig_system = 'PER';
1093:
1094:

Line 1107: hr_api.mandatory_arg_error

1103: END IF;
1104:
1105: -- Check mandatory parameters have been set
1106:
1107: hr_api.mandatory_arg_error
1108: (p_api_name => l_proc
1109: ,p_argument => 'effective_date'
1110: ,p_argument_value => p_effective_date
1111: );

Line 1196: hr_api.mandatory_arg_error

1192: hr_utility.set_location('Entering:'|| l_proc, 1);
1193:
1194: -- Check mandatory parameters have been set
1195:
1196: hr_api.mandatory_arg_error
1197: (p_api_name => l_proc
1198: ,p_argument => 'effective_date'
1199: ,p_argument_value => p_effective_date
1200: );

Line 1211: hr_api.g_varchar2)

1207: (p_appraisal_id => p_appraisal_id
1208: ,p_object_version_number => p_object_version_number);
1209:
1210: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,
1211: hr_api.g_varchar2)
1212: <> nvl(p_type,hr_api.g_varchar2)
1213: ) or
1214: (NOT l_api_updating)
1215: ) then

Line 1212: <> nvl(p_type,hr_api.g_varchar2)

1208: ,p_object_version_number => p_object_version_number);
1209:
1210: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,
1211: hr_api.g_varchar2)
1212: <> nvl(p_type,hr_api.g_varchar2)
1213: ) or
1214: (NOT l_api_updating)
1215: ) then
1216:

Line 1226: if hr_api.not_exists_in_hr_lookups

1222: -- where the lookup_type = 'APPRAISAL_TYPE'
1223:
1224:
1225: if p_type is not null then
1226: if hr_api.not_exists_in_hr_lookups
1227: (p_effective_date => p_effective_date
1228: ,p_lookup_type => 'APPRAISAL_TYPE'
1229: ,p_lookup_code => p_type
1230: ) then

Line 1295: hr_api.mandatory_arg_error

1291: hr_utility.set_location('Entering:'|| l_proc, 1);
1292:
1293: -- Check mandatory parameters have been set
1294:
1295: hr_api.mandatory_arg_error
1296: (p_api_name => l_proc
1297: ,p_argument => 'effective_date'
1298: ,p_argument_value => p_effective_date
1299: );

Line 1310: hr_api.g_varchar2)

1306: (p_appraisal_id => p_appraisal_id
1307: ,p_object_version_number => p_object_version_number);
1308:
1309: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,
1310: hr_api.g_varchar2)
1311: <> nvl(p_status,hr_api.g_varchar2)
1312: ) or
1313: (NOT l_api_updating)
1314: ) then

Line 1311: <> nvl(p_status,hr_api.g_varchar2)

1307: ,p_object_version_number => p_object_version_number);
1308:
1309: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,
1310: hr_api.g_varchar2)
1311: <> nvl(p_status,hr_api.g_varchar2)
1312: ) or
1313: (NOT l_api_updating)
1314: ) then
1315:

Line 1325: if hr_api.not_exists_in_hr_lookups

1321: -- where the lookup_type = 'APPRAISAL_ASSESSMENT_STATUS'
1322:
1323:
1324: if p_status is not null then
1325: if hr_api.not_exists_in_hr_lookups
1326: (p_effective_date => p_effective_date
1327: ,p_lookup_type => 'APPRAISAL_ASSESSMENT_STATUS'
1328: ,p_lookup_code => p_status
1329: ) then

Line 1826: if ( nvl(p_next_appraisal_date,hr_api.g_eot ) < p_appraisal_date) then

1822: hr_utility.set_location(l_proc,60);
1823:
1824: -- Fix 3061901
1825:
1826: if ( nvl(p_next_appraisal_date,hr_api.g_eot ) < p_appraisal_date) then
1827: hr_utility.set_message(800, 'HR_449014_INV_NEXT_APPR_DATE');
1828: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.NEXT_APPRAISAL_DATE'
1829: ,p_associated_column2 => 'PER_APPRAISALS.APPRAISAL_DATE'
1830: );

Line 1913: hr_api.mandatory_arg_error

1909: hr_utility.set_location('Entering:'|| l_proc, 1);
1910:
1911: -- Check mandatory parameters have been set
1912:
1913: hr_api.mandatory_arg_error
1914: (p_api_name => l_proc
1915: ,p_argument => 'appraisal_template_id'
1916: ,p_argument_value => p_appraisal_template_id
1917: );

Line 1928: hr_api.g_number)

1924: (p_appraisal_id => p_appraisal_id
1925: ,p_object_version_number => p_object_version_number);
1926:
1927: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,
1928: hr_api.g_number)
1929: <> nvl(p_overall_performance_level_id,hr_api.g_number)
1930: ) or
1931: (NOT l_api_updating)
1932: ) then

Line 1929: <> nvl(p_overall_performance_level_id,hr_api.g_number)

1925: ,p_object_version_number => p_object_version_number);
1926:
1927: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,
1928: hr_api.g_number)
1929: <> nvl(p_overall_performance_level_id,hr_api.g_number)
1930: ) or
1931: (NOT l_api_updating)
1932: ) then
1933: -- Do the check

Line 2082: hr_api.mandatory_arg_error

2078: hr_utility.set_location('Entering:'|| l_proc, 1);
2079:
2080: -- Check mandatory parameters have been set
2081:
2082: hr_api.mandatory_arg_error
2083: (p_api_name => l_proc
2084: ,p_argument => 'appraisal_id'
2085: ,p_argument_value => p_appraisal_id
2086: );

Line 2220: AND nvl(per_apr_shd.g_old_rec.plan_id, hr_api.g_number)

2216: (p_appraisal_id => p_appraisal_id
2217: ,p_object_version_number => p_object_version_number);
2218: --
2219: IF (l_api_updating
2220: AND nvl(per_apr_shd.g_old_rec.plan_id, hr_api.g_number)
2221: = nvl(p_plan_id, hr_api.g_number))
2222: THEN
2223: RETURN;
2224: END IF;

Line 2221: = nvl(p_plan_id, hr_api.g_number))

2217: ,p_object_version_number => p_object_version_number);
2218: --
2219: IF (l_api_updating
2220: AND nvl(per_apr_shd.g_old_rec.plan_id, hr_api.g_number)
2221: = nvl(p_plan_id, hr_api.g_number))
2222: THEN
2223: RETURN;
2224: END IF;
2225:

Line 2311: AND nvl(per_apr_shd.g_old_rec.offline_status, hr_api.g_varchar2)

2307: (p_appraisal_id => p_appraisal_id
2308: ,p_object_version_number => p_object_version_number);
2309: --
2310: IF (l_api_updating
2311: AND nvl(per_apr_shd.g_old_rec.offline_status, hr_api.g_varchar2)
2312: = nvl(p_offline_status, hr_api.g_varchar2))
2313: THEN
2314: RETURN;
2315: END IF;

Line 2312: = nvl(p_offline_status, hr_api.g_varchar2))

2308: ,p_object_version_number => p_object_version_number);
2309: --
2310: IF (l_api_updating
2311: AND nvl(per_apr_shd.g_old_rec.offline_status, hr_api.g_varchar2)
2312: = nvl(p_offline_status, hr_api.g_varchar2))
2313: THEN
2314: RETURN;
2315: END IF;
2316:

Line 2322: IF hr_api.not_exists_in_hr_lookups(

2318: --
2319: -- Check that offline status is valid.
2320: --
2321: hr_utility.set_location(l_proc, 20);
2322: IF hr_api.not_exists_in_hr_lookups(
2323: p_effective_date => p_effective_date
2324: ,p_lookup_type => 'APPRAISAL_OFFLINE_STATUS'
2325: ,p_lookup_code => upper(p_offline_status)
2326: ) THEN

Line 2383: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

2379: begin
2380: hr_utility.set_location('Entering:'||l_proc, 10);
2381:
2382: if ((p_rec.appraisal_id is not null) and (
2383: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

2380: hr_utility.set_location('Entering:'||l_proc, 10);
2381:
2382: if ((p_rec.appraisal_id is not null) and (
2383: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

2381:
2382: if ((p_rec.appraisal_id is not null) and (
2383: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

2382: if ((p_rec.appraisal_id is not null) and (
2383: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2390: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

2384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2385: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2392: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

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

2386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2387: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2394: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

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

2388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2389: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2396: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

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

2390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2391: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2398: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

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

2392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2393: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2400: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

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

2394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2395: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2402: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

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

2396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2397: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2404: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

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

2398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2399: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2406: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

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

2400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2401: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2408: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

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

2402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2403: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2410: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

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

2404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2405: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2412: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

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

2406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2407: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2414: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

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

2408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2409: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2416: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

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

2410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2411: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

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

2412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2413: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

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

2414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2415: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

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

2416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

2417: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2425: or

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

2418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2425: or
2426: (p_rec.appraisal_id is null) then

Line 2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

2419: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2425: or
2426: (p_rec.appraisal_id is null) then
2427:

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

2420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2421: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2423: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2425: or
2426: (p_rec.appraisal_id is null) then
2427:
2428: -- Only execute the validation if absolutely necessary:

Line 2498: hr_api.validate_bus_grp_id

2494: hr_utility.set_location('Entering:'||l_proc, 5);
2495:
2496: -- Call all supporting business operations
2497:
2498: hr_api.validate_bus_grp_id
2499: (p_business_group_id => p_rec.business_group_id
2500: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
2501: ); -- VALIDATE BUSINESS GROUP
2502:

Line 2651: hr_api.validate_bus_grp_id

2647: -- Call all supporting business operations
2648:
2649: -- Rule Check non-updateable fields cannot be updated
2650:
2651: hr_api.validate_bus_grp_id
2652: (p_business_group_id => p_rec.business_group_id
2653: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
2654: ); -- VALIDATE BUSINESS GROUP
2655:

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

2823: hr_utility.set_location('Entering:'||l_proc, 5);
2824:
2825: -- Ensure that all the mandatory parameters are not null
2826:
2827: hr_api.mandatory_arg_error (p_api_name => l_proc,
2828: p_argument => 'appraisal_id',
2829: p_argument_value => p_appraisal_id );
2830:
2831: if nvl(g_appraisal_id, hr_api.g_number) = p_appraisal_id then

Line 2831: if nvl(g_appraisal_id, hr_api.g_number) = p_appraisal_id then

2827: hr_api.mandatory_arg_error (p_api_name => l_proc,
2828: p_argument => 'appraisal_id',
2829: p_argument_value => p_appraisal_id );
2830:
2831: if nvl(g_appraisal_id, hr_api.g_number) = p_appraisal_id then
2832:
2833: -- The legislation has already been found with a previous
2834: -- call to this function. Just return the value in the global
2835: -- variable.