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_APR_BUS dependencies on PER_APR_SHD

Line 78: Procedure chk_non_updateable_args(p_rec in per_apr_shd.g_rec_type) is

74: -- -------------------------------------------------------------------------+
75: -- |----------------------< chk_non_updateable_args >-----------------------|
76: -- -------------------------------------------------------------------------+
77:
78: Procedure chk_non_updateable_args(p_rec in per_apr_shd.g_rec_type) is
79:
80: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
81:
82: Begin

Line 88: if not per_apr_shd.api_updating

84:
85: -- Only proceed with validation if a row exists for
86: -- the current record in the HR Schema
87:
88: if not per_apr_shd.api_updating
89: (p_appraisal_id => p_rec.appraisal_id
90: ,p_object_version_number => p_rec.object_version_number
91: ) then
92: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 99: if p_rec.business_group_id <> per_apr_shd.g_old_rec.business_group_id then

95: end if;
96:
97: hr_utility.set_location(l_proc, 6);
98:
99: if p_rec.business_group_id <> per_apr_shd.g_old_rec.business_group_id then
100: hr_api.argument_changed_error
101: (
102: p_api_name => l_proc
103: ,p_argument => 'BUSINESS_GROUP_ID'

Line 106: elsif p_rec.appraisal_template_id <> per_apr_shd.g_old_rec.appraisal_template_id then

102: p_api_name => l_proc
103: ,p_argument => 'BUSINESS_GROUP_ID'
104: ,p_base_table => per_per_shd.g_tab_nam
105: );
106: elsif p_rec.appraisal_template_id <> per_apr_shd.g_old_rec.appraisal_template_id then
107: hr_utility.set_location(l_proc, 7);
108: hr_api.argument_changed_error
109: (
110: p_api_name => l_proc

Line 114: elsif p_rec.appraisee_person_id <> per_apr_shd.g_old_rec.appraisee_person_id then

110: p_api_name => l_proc
111: ,p_argument => 'APPRAISAL_TEMPLATE_ID'
112: ,p_base_table => per_per_shd.g_tab_nam
113: );
114: elsif p_rec.appraisee_person_id <> per_apr_shd.g_old_rec.appraisee_person_id then
115: hr_utility.set_location(l_proc, 8);
116: hr_api.argument_changed_error
117: (
118: p_api_name => l_proc

Line 122: elsif p_rec.assignment_id <> per_apr_shd.g_old_rec.assignment_id then

118: p_api_name => l_proc
119: ,p_argument => 'APPRAISEE_ID'
120: ,p_base_table => per_per_shd.g_tab_nam
121: );
122: elsif p_rec.assignment_id <> per_apr_shd.g_old_rec.assignment_id then
123: hr_utility.set_location(l_proc, 9);
124: hr_api.argument_changed_error
125: (
126: p_api_name => l_proc

Line 130: elsif p_rec.assignment_start_date <> per_apr_shd.g_old_rec.assignment_start_date then

126: p_api_name => l_proc
127: ,p_argument => 'ASSIGNMENT_ID'
128: ,p_base_table => per_per_shd.g_tab_nam
129: );
130: elsif p_rec.assignment_start_date <> per_apr_shd.g_old_rec.assignment_start_date then
131: hr_utility.set_location(l_proc, 10);
132: hr_api.argument_changed_error
133: (
134: p_api_name => l_proc

Line 138: elsif p_rec.assignment_business_group_id <> per_apr_shd.g_old_rec.assignment_business_group_id then

134: p_api_name => l_proc
135: ,p_argument => 'ASSIGNMENT_START_DATE'
136: ,p_base_table => per_per_shd.g_tab_nam
137: );
138: elsif p_rec.assignment_business_group_id <> per_apr_shd.g_old_rec.assignment_business_group_id then
139: hr_utility.set_location(l_proc, 11);
140: hr_api.argument_changed_error
141: (
142: p_api_name => l_proc

Line 146: elsif p_rec.assignment_organization_id <> per_apr_shd.g_old_rec.assignment_organization_id then

142: p_api_name => l_proc
143: ,p_argument => 'ASSIGNMENT_BUSINESS_GROUP_ID'
144: ,p_base_table => per_per_shd.g_tab_nam
145: );
146: elsif p_rec.assignment_organization_id <> per_apr_shd.g_old_rec.assignment_organization_id then
147: hr_utility.set_location(l_proc, 12);
148: hr_api.argument_changed_error
149: (
150: p_api_name => l_proc

Line 154: elsif p_rec.assignment_job_id <> per_apr_shd.g_old_rec.assignment_job_id then

150: p_api_name => l_proc
151: ,p_argument => 'ASSIGNMENT_ORGANIZATION_ID'
152: ,p_base_table => per_per_shd.g_tab_nam
153: );
154: elsif p_rec.assignment_job_id <> per_apr_shd.g_old_rec.assignment_job_id then
155: hr_utility.set_location(l_proc, 13);
156: hr_api.argument_changed_error
157: (
158: p_api_name => l_proc

Line 162: elsif p_rec.assignment_position_id <> per_apr_shd.g_old_rec.assignment_position_id then

158: p_api_name => l_proc
159: ,p_argument => 'ASSIGNMENT_JOB_ID'
160: ,p_base_table => per_per_shd.g_tab_nam
161: );
162: elsif p_rec.assignment_position_id <> per_apr_shd.g_old_rec.assignment_position_id then
163: hr_utility.set_location(l_proc, 14);
164: hr_api.argument_changed_error
165: (
166: p_api_name => l_proc

Line 272: (p_rec in per_apr_shd.g_rec_type

268: -- Internal Row Handler Use Only
269:
270: -- ---------------------------------------------------------------------------+
271: procedure chk_update_allowed
272: (p_rec in per_apr_shd.g_rec_type
273: )
274: is
275:
276: l_proc varchar2(72) := g_package || 'chk_update_allowed';

Line 317: <> per_apr_shd.g_old_rec.appraiser_person_id then

313: if (p_rec.open = 'N') then
314: -- Check that columns arent being updated (except OPEN column)
315:
316: if p_rec.appraiser_person_id
317: <> per_apr_shd.g_old_rec.appraiser_person_id then
318: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
319: fnd_message.raise_error;
320: elsif p_rec.appraisal_date
321: <> per_apr_shd.g_old_rec.appraisal_date then

Line 321: <> per_apr_shd.g_old_rec.appraisal_date then

317: <> per_apr_shd.g_old_rec.appraiser_person_id then
318: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
319: fnd_message.raise_error;
320: elsif p_rec.appraisal_date
321: <> per_apr_shd.g_old_rec.appraisal_date then
322: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
323: fnd_message.raise_error;
324: elsif p_rec.appraisal_period_end_date
325: <> per_apr_shd.g_old_rec.appraisal_period_end_date then

Line 325: <> per_apr_shd.g_old_rec.appraisal_period_end_date then

321: <> per_apr_shd.g_old_rec.appraisal_date then
322: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
323: fnd_message.raise_error;
324: elsif p_rec.appraisal_period_end_date
325: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
326: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
327: fnd_message.raise_error;
328: elsif p_rec.appraisal_period_start_date
329: <> per_apr_shd.g_old_rec.appraisal_period_start_date then

Line 329: <> per_apr_shd.g_old_rec.appraisal_period_start_date then

325: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
326: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
327: fnd_message.raise_error;
328: elsif p_rec.appraisal_period_start_date
329: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
330: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
331: fnd_message.raise_error;
332: elsif p_rec.type
333: <> per_apr_shd.g_old_rec.type then

Line 333: <> per_apr_shd.g_old_rec.type then

329: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
330: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
331: fnd_message.raise_error;
332: elsif p_rec.type
333: <> per_apr_shd.g_old_rec.type then
334: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
335: fnd_message.raise_error;
336: elsif p_rec.next_appraisal_date
337: <> per_apr_shd.g_old_rec.next_appraisal_date then

Line 337: <> per_apr_shd.g_old_rec.next_appraisal_date then

333: <> per_apr_shd.g_old_rec.type then
334: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
335: fnd_message.raise_error;
336: elsif p_rec.next_appraisal_date
337: <> per_apr_shd.g_old_rec.next_appraisal_date then
338: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
339: fnd_message.raise_error;
340: elsif p_rec.status
341: <> per_apr_shd.g_old_rec.status then

Line 341: <> per_apr_shd.g_old_rec.status then

337: <> per_apr_shd.g_old_rec.next_appraisal_date then
338: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
339: fnd_message.raise_error;
340: elsif p_rec.status
341: <> per_apr_shd.g_old_rec.status then
342: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
343: fnd_message.raise_error;
344: elsif p_rec.comments
345: <> per_apr_shd.g_old_rec.comments then

Line 345: <> per_apr_shd.g_old_rec.comments then

341: <> per_apr_shd.g_old_rec.status then
342: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
343: fnd_message.raise_error;
344: elsif p_rec.comments
345: <> per_apr_shd.g_old_rec.comments then
346: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
347: fnd_message.raise_error;
348: elsif p_rec.overall_performance_level_id
349: <> per_apr_shd.g_old_rec.overall_performance_level_id then

Line 349: <> per_apr_shd.g_old_rec.overall_performance_level_id then

345: <> per_apr_shd.g_old_rec.comments then
346: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
347: fnd_message.raise_error;
348: elsif p_rec.overall_performance_level_id
349: <> per_apr_shd.g_old_rec.overall_performance_level_id then
350: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
351: fnd_message.raise_error;
352: elsif p_rec.attribute_category
353: <> per_apr_shd.g_old_rec.attribute_category then

Line 353: <> per_apr_shd.g_old_rec.attribute_category then

349: <> per_apr_shd.g_old_rec.overall_performance_level_id then
350: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
351: fnd_message.raise_error;
352: elsif p_rec.attribute_category
353: <> per_apr_shd.g_old_rec.attribute_category then
354: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
355: fnd_message.raise_error;
356: elsif p_rec.attribute1
357: <> per_apr_shd.g_old_rec.attribute1 then

Line 357: <> per_apr_shd.g_old_rec.attribute1 then

353: <> per_apr_shd.g_old_rec.attribute_category then
354: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
355: fnd_message.raise_error;
356: elsif p_rec.attribute1
357: <> per_apr_shd.g_old_rec.attribute1 then
358: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
359: fnd_message.raise_error;
360: elsif p_rec.attribute2
361: <> per_apr_shd.g_old_rec.attribute2 then

Line 361: <> per_apr_shd.g_old_rec.attribute2 then

357: <> per_apr_shd.g_old_rec.attribute1 then
358: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
359: fnd_message.raise_error;
360: elsif p_rec.attribute2
361: <> per_apr_shd.g_old_rec.attribute2 then
362: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
363: fnd_message.raise_error;
364: elsif p_rec.attribute3
365: <> per_apr_shd.g_old_rec.attribute3 then

Line 365: <> per_apr_shd.g_old_rec.attribute3 then

361: <> per_apr_shd.g_old_rec.attribute2 then
362: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
363: fnd_message.raise_error;
364: elsif p_rec.attribute3
365: <> per_apr_shd.g_old_rec.attribute3 then
366: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
367: fnd_message.raise_error;
368: elsif p_rec.attribute4
369: <> per_apr_shd.g_old_rec.attribute4 then

Line 369: <> per_apr_shd.g_old_rec.attribute4 then

365: <> per_apr_shd.g_old_rec.attribute3 then
366: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
367: fnd_message.raise_error;
368: elsif p_rec.attribute4
369: <> per_apr_shd.g_old_rec.attribute4 then
370: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
371: fnd_message.raise_error;
372: elsif p_rec.attribute5
373: <> per_apr_shd.g_old_rec.attribute5 then

Line 373: <> per_apr_shd.g_old_rec.attribute5 then

369: <> per_apr_shd.g_old_rec.attribute4 then
370: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
371: fnd_message.raise_error;
372: elsif p_rec.attribute5
373: <> per_apr_shd.g_old_rec.attribute5 then
374: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
375: fnd_message.raise_error;
376: elsif p_rec.attribute6
377: <> per_apr_shd.g_old_rec.attribute6 then

Line 377: <> per_apr_shd.g_old_rec.attribute6 then

373: <> per_apr_shd.g_old_rec.attribute5 then
374: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
375: fnd_message.raise_error;
376: elsif p_rec.attribute6
377: <> per_apr_shd.g_old_rec.attribute6 then
378: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
379: fnd_message.raise_error;
380: elsif p_rec.attribute7
381: <> per_apr_shd.g_old_rec.attribute7 then

Line 381: <> per_apr_shd.g_old_rec.attribute7 then

377: <> per_apr_shd.g_old_rec.attribute6 then
378: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
379: fnd_message.raise_error;
380: elsif p_rec.attribute7
381: <> per_apr_shd.g_old_rec.attribute7 then
382: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
383: fnd_message.raise_error;
384: elsif p_rec.attribute8
385: <> per_apr_shd.g_old_rec.attribute8 then

Line 385: <> per_apr_shd.g_old_rec.attribute8 then

381: <> per_apr_shd.g_old_rec.attribute7 then
382: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
383: fnd_message.raise_error;
384: elsif p_rec.attribute8
385: <> per_apr_shd.g_old_rec.attribute8 then
386: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
387: fnd_message.raise_error;
388: elsif p_rec.attribute9
389: <> per_apr_shd.g_old_rec.attribute9 then

Line 389: <> per_apr_shd.g_old_rec.attribute9 then

385: <> per_apr_shd.g_old_rec.attribute8 then
386: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
387: fnd_message.raise_error;
388: elsif p_rec.attribute9
389: <> per_apr_shd.g_old_rec.attribute9 then
390: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
391: fnd_message.raise_error;
392: elsif p_rec.attribute10
393: <> per_apr_shd.g_old_rec.attribute10 then

Line 393: <> per_apr_shd.g_old_rec.attribute10 then

389: <> per_apr_shd.g_old_rec.attribute9 then
390: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
391: fnd_message.raise_error;
392: elsif p_rec.attribute10
393: <> per_apr_shd.g_old_rec.attribute10 then
394: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
395: fnd_message.raise_error;
396: elsif p_rec.attribute11
397: <> per_apr_shd.g_old_rec.attribute11 then

Line 397: <> per_apr_shd.g_old_rec.attribute11 then

393: <> per_apr_shd.g_old_rec.attribute10 then
394: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
395: fnd_message.raise_error;
396: elsif p_rec.attribute11
397: <> per_apr_shd.g_old_rec.attribute11 then
398: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
399: fnd_message.raise_error;
400: elsif p_rec.attribute12
401: <> per_apr_shd.g_old_rec.attribute12 then

Line 401: <> per_apr_shd.g_old_rec.attribute12 then

397: <> per_apr_shd.g_old_rec.attribute11 then
398: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
399: fnd_message.raise_error;
400: elsif p_rec.attribute12
401: <> per_apr_shd.g_old_rec.attribute12 then
402: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
403: fnd_message.raise_error;
404: elsif p_rec.attribute13
405: <> per_apr_shd.g_old_rec.attribute13 then

Line 405: <> per_apr_shd.g_old_rec.attribute13 then

401: <> per_apr_shd.g_old_rec.attribute12 then
402: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
403: fnd_message.raise_error;
404: elsif p_rec.attribute13
405: <> per_apr_shd.g_old_rec.attribute13 then
406: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
407: fnd_message.raise_error;
408: elsif p_rec.attribute14
409: <> per_apr_shd.g_old_rec.attribute14 then

Line 409: <> per_apr_shd.g_old_rec.attribute14 then

405: <> per_apr_shd.g_old_rec.attribute13 then
406: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
407: fnd_message.raise_error;
408: elsif p_rec.attribute14
409: <> per_apr_shd.g_old_rec.attribute14 then
410: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
411: fnd_message.raise_error;
412: elsif p_rec.attribute15
413: <> per_apr_shd.g_old_rec.attribute15 then

Line 413: <> per_apr_shd.g_old_rec.attribute15 then

409: <> per_apr_shd.g_old_rec.attribute14 then
410: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
411: fnd_message.raise_error;
412: elsif p_rec.attribute15
413: <> per_apr_shd.g_old_rec.attribute15 then
414: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
415: fnd_message.raise_error;
416: elsif p_rec.attribute16
417: <> per_apr_shd.g_old_rec.attribute16 then

Line 417: <> per_apr_shd.g_old_rec.attribute16 then

413: <> per_apr_shd.g_old_rec.attribute15 then
414: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
415: fnd_message.raise_error;
416: elsif p_rec.attribute16
417: <> per_apr_shd.g_old_rec.attribute16 then
418: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
419: fnd_message.raise_error;
420: elsif p_rec.attribute17
421: <> per_apr_shd.g_old_rec.attribute17 then

Line 421: <> per_apr_shd.g_old_rec.attribute17 then

417: <> per_apr_shd.g_old_rec.attribute16 then
418: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
419: fnd_message.raise_error;
420: elsif p_rec.attribute17
421: <> per_apr_shd.g_old_rec.attribute17 then
422: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
423: fnd_message.raise_error;
424: elsif p_rec.attribute18
425: <> per_apr_shd.g_old_rec.attribute18 then

Line 425: <> per_apr_shd.g_old_rec.attribute18 then

421: <> per_apr_shd.g_old_rec.attribute17 then
422: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
423: fnd_message.raise_error;
424: elsif p_rec.attribute18
425: <> per_apr_shd.g_old_rec.attribute18 then
426: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
427: fnd_message.raise_error;
428: elsif p_rec.attribute19
429: <> per_apr_shd.g_old_rec.attribute19 then

Line 429: <> per_apr_shd.g_old_rec.attribute19 then

425: <> per_apr_shd.g_old_rec.attribute18 then
426: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
427: fnd_message.raise_error;
428: elsif p_rec.attribute19
429: <> per_apr_shd.g_old_rec.attribute19 then
430: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
431: fnd_message.raise_error;
432: elsif p_rec.attribute20
433: <> per_apr_shd.g_old_rec.attribute20 then

Line 433: <> per_apr_shd.g_old_rec.attribute20 then

429: <> per_apr_shd.g_old_rec.attribute19 then
430: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
431: fnd_message.raise_error;
432: elsif p_rec.attribute20
433: <> per_apr_shd.g_old_rec.attribute20 then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;
436: elsif p_rec.system_type
437: <> per_apr_shd.g_old_rec.system_type then

Line 437: <> per_apr_shd.g_old_rec.system_type then

433: <> per_apr_shd.g_old_rec.attribute20 then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;
436: elsif p_rec.system_type
437: <> per_apr_shd.g_old_rec.system_type then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;
440: elsif p_rec.system_params
441: <> per_apr_shd.g_old_rec.system_params then

Line 441: <> per_apr_shd.g_old_rec.system_params then

437: <> per_apr_shd.g_old_rec.system_type then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;
440: elsif p_rec.system_params
441: <> per_apr_shd.g_old_rec.system_params then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;
444: elsif p_rec.appraisee_access
445: <> per_apr_shd.g_old_rec.appraisee_access then

Line 445: <> per_apr_shd.g_old_rec.appraisee_access then

441: <> per_apr_shd.g_old_rec.system_params then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;
444: elsif p_rec.appraisee_access
445: <> per_apr_shd.g_old_rec.appraisee_access then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;
448: elsif p_rec.main_appraiser_id
449: <> per_apr_shd.g_old_rec.main_appraiser_id then

Line 449: <> per_apr_shd.g_old_rec.main_appraiser_id then

445: <> per_apr_shd.g_old_rec.appraisee_access then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;
448: elsif p_rec.main_appraiser_id
449: <> per_apr_shd.g_old_rec.main_appraiser_id then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;
452: elsif p_rec.assignment_id
453: <> per_apr_shd.g_old_rec.assignment_id then

Line 453: <> per_apr_shd.g_old_rec.assignment_id then

449: <> per_apr_shd.g_old_rec.main_appraiser_id then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;
452: elsif p_rec.assignment_id
453: <> per_apr_shd.g_old_rec.assignment_id then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;
456: elsif p_rec.assignment_start_date
457: <> per_apr_shd.g_old_rec.assignment_start_date then

Line 457: <> per_apr_shd.g_old_rec.assignment_start_date then

453: <> per_apr_shd.g_old_rec.assignment_id then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;
456: elsif p_rec.assignment_start_date
457: <> per_apr_shd.g_old_rec.assignment_start_date then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;
460: elsif p_rec.assignment_business_group_id
461: <> per_apr_shd.g_old_rec.assignment_business_group_id then

Line 461: <> per_apr_shd.g_old_rec.assignment_business_group_id then

457: <> per_apr_shd.g_old_rec.assignment_start_date then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;
460: elsif p_rec.assignment_business_group_id
461: <> per_apr_shd.g_old_rec.assignment_business_group_id then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;
464: elsif p_rec.assignment_organization_id
465: <> per_apr_shd.g_old_rec.assignment_organization_id then

Line 465: <> per_apr_shd.g_old_rec.assignment_organization_id then

461: <> per_apr_shd.g_old_rec.assignment_business_group_id then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;
464: elsif p_rec.assignment_organization_id
465: <> per_apr_shd.g_old_rec.assignment_organization_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;
468: elsif p_rec.assignment_job_id
469: <> per_apr_shd.g_old_rec.assignment_job_id then

Line 469: <> per_apr_shd.g_old_rec.assignment_job_id then

465: <> per_apr_shd.g_old_rec.assignment_organization_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;
468: elsif p_rec.assignment_job_id
469: <> per_apr_shd.g_old_rec.assignment_job_id then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;
472: elsif p_rec.assignment_position_id
473: <> per_apr_shd.g_old_rec.assignment_position_id then

Line 473: <> per_apr_shd.g_old_rec.assignment_position_id then

469: <> per_apr_shd.g_old_rec.assignment_job_id then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;
472: elsif p_rec.assignment_position_id
473: <> per_apr_shd.g_old_rec.assignment_position_id then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;
476: elsif p_rec.assignment_grade_id
477: <> per_apr_shd.g_old_rec.assignment_grade_id then

Line 477: <> per_apr_shd.g_old_rec.assignment_grade_id then

473: <> per_apr_shd.g_old_rec.assignment_position_id then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;
476: elsif p_rec.assignment_grade_id
477: <> per_apr_shd.g_old_rec.assignment_grade_id then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;
480: elsif p_rec.potential_readiness_level
481: <> per_apr_shd.g_old_rec.potential_readiness_level then

Line 481: <> per_apr_shd.g_old_rec.potential_readiness_level then

477: <> per_apr_shd.g_old_rec.assignment_grade_id then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;
480: elsif p_rec.potential_readiness_level
481: <> per_apr_shd.g_old_rec.potential_readiness_level then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;
484: elsif p_rec.potential_short_term_workopp
485: <> per_apr_shd.g_old_rec.potential_short_term_workopp then

Line 485: <> per_apr_shd.g_old_rec.potential_short_term_workopp then

481: <> per_apr_shd.g_old_rec.potential_readiness_level then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;
484: elsif p_rec.potential_short_term_workopp
485: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;
488: elsif p_rec.potential_long_term_workopp
489: <> per_apr_shd.g_old_rec.potential_long_term_workopp then

Line 489: <> per_apr_shd.g_old_rec.potential_long_term_workopp then

485: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;
488: elsif p_rec.potential_long_term_workopp
489: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;
492: elsif p_rec.potential_details
493: <> per_apr_shd.g_old_rec.potential_details then

Line 493: <> per_apr_shd.g_old_rec.potential_details then

489: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;
492: elsif p_rec.potential_details
493: <> per_apr_shd.g_old_rec.potential_details then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;
496: elsif p_rec.event_id
497: <> per_apr_shd.g_old_rec.event_id then

Line 497: <> per_apr_shd.g_old_rec.event_id then

493: <> per_apr_shd.g_old_rec.potential_details then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;
496: elsif p_rec.event_id
497: <> per_apr_shd.g_old_rec.event_id then
498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
499: fnd_message.raise_error;
500:
501: end if;

Line 564: if p_appraisal_id <> per_apr_shd.g_old_rec.appraisal_id then

560: hr_utility.set_location('Entering: '|| l_proc,10);
561:
562: -- flemonni added
563:
564: if p_appraisal_id <> per_apr_shd.g_old_rec.appraisal_id then
565: open csr_answer_set_exists;
566: fetch csr_answer_set_exists into l_exists;
567:
568: if csr_answer_set_exists%found then

Line 1084: l_api_updating := per_apr_shd.api_updating

1080: -- Only proceed with validation if :
1081: -- a) The current g_old_rec is current and
1082: -- b) The value for appraisal type flag has changed
1083:
1084: l_api_updating := per_apr_shd.api_updating
1085: (p_appraisal_id => p_appraisal_id
1086: ,p_object_version_number => p_object_version_number);
1087:
1088: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,

Line 1088: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,

1084: l_api_updating := per_apr_shd.api_updating
1085: (p_appraisal_id => p_appraisal_id
1086: ,p_object_version_number => p_object_version_number);
1087:
1088: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.type,
1089: hr_api.g_varchar2)
1090: <> nvl(p_type,hr_api.g_varchar2)
1091: ) or
1092: (NOT l_api_updating)

Line 1183: l_api_updating := per_apr_shd.api_updating

1179: -- Only proceed with validation if :
1180: -- a) The current g_old_rec is current and
1181: -- b) The value for appraisal status flag has changed
1182:
1183: l_api_updating := per_apr_shd.api_updating
1184: (p_appraisal_id => p_appraisal_id
1185: ,p_object_version_number => p_object_version_number);
1186:
1187: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,

Line 1187: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,

1183: l_api_updating := per_apr_shd.api_updating
1184: (p_appraisal_id => p_appraisal_id
1185: ,p_object_version_number => p_object_version_number);
1186:
1187: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.status,
1188: hr_api.g_varchar2)
1189: <> nvl(p_status,hr_api.g_varchar2)
1190: ) or
1191: (NOT l_api_updating)

Line 1463: l_api_updating := per_apr_shd.api_updating

1459:
1460: -- Only proceed with validation if :
1461: -- a) The current g_old_rec is current and
1462:
1463: l_api_updating := per_apr_shd.api_updating
1464: (p_appraisal_id => p_appraisal_id
1465: ,p_object_version_number => p_object_version_number);
1466:
1467: -- Do the check

Line 1755: l_api_updating := per_apr_shd.api_updating

1751: -- Only proceed with validation if :
1752: -- a) The current g_old_rec is current and
1753: -- b) The value for overall_performance_level_id has changed
1754:
1755: l_api_updating := per_apr_shd.api_updating
1756: (p_appraisal_id => p_appraisal_id
1757: ,p_object_version_number => p_object_version_number);
1758:
1759: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,

Line 1759: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,

1755: l_api_updating := per_apr_shd.api_updating
1756: (p_appraisal_id => p_appraisal_id
1757: ,p_object_version_number => p_object_version_number);
1758:
1759: if ( (l_api_updating and nvl(per_apr_shd.g_old_rec.overall_performance_level_id,
1760: hr_api.g_number)
1761: <> nvl(p_overall_performance_level_id,hr_api.g_number)
1762: ) or
1763: (NOT l_api_updating)

Line 2047: l_api_updating := per_apr_shd.api_updating

2043: -- Only proceed with validation if :
2044: -- a) The current g_old_rec is current and
2045: -- b) The date values have changed
2046: --
2047: l_api_updating := per_apr_shd.api_updating
2048: (p_appraisal_id => p_appraisal_id
2049: ,p_object_version_number => p_object_version_number);
2050: --
2051: IF (l_api_updating

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

2048: (p_appraisal_id => p_appraisal_id
2049: ,p_object_version_number => p_object_version_number);
2050: --
2051: IF (l_api_updating
2052: AND nvl(per_apr_shd.g_old_rec.plan_id, hr_api.g_number)
2053: = nvl(p_plan_id, hr_api.g_number))
2054: THEN
2055: RETURN;
2056: END IF;

Line 2136: l_api_updating := per_apr_shd.api_updating

2132: -- Only proceed with validation if :
2133: -- a) The current g_old_rec is current and
2134: -- b) The offline status value has changed
2135: --
2136: l_api_updating := per_apr_shd.api_updating
2137: (p_appraisal_id => p_appraisal_id
2138: ,p_object_version_number => p_object_version_number);
2139: --
2140: IF (l_api_updating

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

2137: (p_appraisal_id => p_appraisal_id
2138: ,p_object_version_number => p_object_version_number);
2139: --
2140: IF (l_api_updating
2141: AND nvl(per_apr_shd.g_old_rec.offline_status, hr_api.g_varchar2)
2142: = nvl(p_offline_status, hr_api.g_varchar2))
2143: THEN
2144: RETURN;
2145: END IF;

Line 2205: (p_rec in per_apr_shd.g_rec_type) is

2201: -- Access Status:
2202: -- Internal Row Handler Use Only.
2203:
2204: procedure chk_df
2205: (p_rec in per_apr_shd.g_rec_type) is
2206:
2207: l_proc varchar2(72) := g_package||'chk_df';
2208:
2209: begin

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

2209: begin
2210: hr_utility.set_location('Entering:'||l_proc, 10);
2211:
2212: if ((p_rec.appraisal_id is not null) and (
2213: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2214: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

2211:
2212: if ((p_rec.appraisal_id is not null) and (
2213: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2214: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

2213: nvl(per_apr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2214: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

2215: nvl(per_apr_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2216: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

2217: nvl(per_apr_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2218: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

2219: nvl(per_apr_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2220: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

2221: nvl(per_apr_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2222: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

2223: nvl(per_apr_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2224: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

2225: nvl(per_apr_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2226: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

2227: nvl(per_apr_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2228: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

2229: nvl(per_apr_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2230: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

2231: nvl(per_apr_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2232: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

2233: nvl(per_apr_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2234: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

2235: nvl(per_apr_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2236: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

2237: nvl(per_apr_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2238: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

2239: nvl(per_apr_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2240: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

2241: nvl(per_apr_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2242: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

2243: nvl(per_apr_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2244: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

2245: nvl(per_apr_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2246: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

2247: nvl(per_apr_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2248: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2254: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2255: or

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

2249: nvl(per_apr_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2250: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2251: nvl(per_apr_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2252: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2253: nvl(per_apr_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2254: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2255: or
2256: (p_rec.appraisal_id is null) then
2257:

Line 2317: Procedure insert_validate(p_rec in per_apr_shd.g_rec_type

2313:
2314: -- ---------------------------------------------------------------------------+
2315: -- |---------------------------< insert_validate >----------------------------|
2316: -- ---------------------------------------------------------------------------+
2317: Procedure insert_validate(p_rec in per_apr_shd.g_rec_type
2318: ,p_effective_date in date)
2319: is
2320:
2321: l_proc varchar2(72) := g_package||'insert_validate';

Line 2460: Procedure update_validate(p_rec in per_apr_shd.g_rec_type

2456:
2457: -- ---------------------------------------------------------------------------+
2458: -- |---------------------------< update_validate >----------------------------|
2459: -- ---------------------------------------------------------------------------+
2460: Procedure update_validate(p_rec in per_apr_shd.g_rec_type
2461: ,p_effective_date in date) is
2462:
2463: l_proc varchar2(72) := g_package||'update_validate';
2464:

Line 2606: Procedure delete_validate(p_rec in per_apr_shd.g_rec_type) is

2602:
2603: -- ---------------------------------------------------------------------------+
2604: -- |---------------------------< delete_validate >----------------------------|
2605: -- ---------------------------------------------------------------------------+
2606: Procedure delete_validate(p_rec in per_apr_shd.g_rec_type) is
2607:
2608: l_proc varchar2(72) := g_package||'delete_validate';
2609:
2610: Begin