APPS.PER_ASR_UPD dependencies on HR_API

Line 94: When hr_api.check_integrity_violated Then

90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: per_asr_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then

Line 97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: per_asr_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: per_asr_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 98: When hr_api.parent_integrity_violated Then

94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: per_asr_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: per_asr_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then

Line 101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: per_asr_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: per_asr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 102: When hr_api.unique_integrity_violated Then

98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: per_asr_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: per_asr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then

Line 105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: per_asr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: Raise;
108: End update_dml;
109: --

Line 249: when hr_api.cannot_find_prog_unit then

245: p_attribute18_o => per_asr_shd.g_old_rec.attribute18 ,
246: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
247: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
248: exception
249: when hr_api.cannot_find_prog_unit then
250: hr_api.cannot_find_prog_unit_error
251: ( p_module_name => 'PER_ASSESSMENT_GROUPS'
252: ,p_hook_type => 'AU'
253: );

Line 250: hr_api.cannot_find_prog_unit_error

246: p_attribute19_o => per_asr_shd.g_old_rec.attribute19 ,
247: p_attribute20_o => per_asr_shd.g_old_rec.attribute20 );
248: exception
249: when hr_api.cannot_find_prog_unit then
250: hr_api.cannot_find_prog_unit_error
251: ( p_module_name => 'PER_ASSESSMENT_GROUPS'
252: ,p_hook_type => 'AU'
253: );
254: end;

Line 317: If (p_rec.name = hr_api.g_varchar2) then

313: -- p_rec plsql record structure
314: -- to see if a system default is being used. If a system default
315: -- is being used then we must set to the 'current' argument value.
316: --
317: If (p_rec.name = hr_api.g_varchar2) then
318: p_rec.name :=
319: per_asr_shd.g_old_rec.name;
320: End If;
321: If (p_rec.business_group_id = hr_api.g_number) then

Line 321: If (p_rec.business_group_id = hr_api.g_number) then

317: If (p_rec.name = hr_api.g_varchar2) then
318: p_rec.name :=
319: per_asr_shd.g_old_rec.name;
320: End If;
321: If (p_rec.business_group_id = hr_api.g_number) then
322: p_rec.business_group_id :=
323: per_asr_shd.g_old_rec.business_group_id;
324: End If;
325: If (p_rec.membership_list = hr_api.g_varchar2) then

Line 325: If (p_rec.membership_list = hr_api.g_varchar2) then

321: If (p_rec.business_group_id = hr_api.g_number) then
322: p_rec.business_group_id :=
323: per_asr_shd.g_old_rec.business_group_id;
324: End If;
325: If (p_rec.membership_list = hr_api.g_varchar2) then
326: p_rec.membership_list :=
327: per_asr_shd.g_old_rec.membership_list;
328: End If;
329: If (p_rec.comments = hr_api.g_varchar2) then

Line 329: If (p_rec.comments = hr_api.g_varchar2) then

325: If (p_rec.membership_list = hr_api.g_varchar2) then
326: p_rec.membership_list :=
327: per_asr_shd.g_old_rec.membership_list;
328: End If;
329: If (p_rec.comments = hr_api.g_varchar2) then
330: p_rec.comments :=
331: per_asr_shd.g_old_rec.comments;
332: End If;
333: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 333: If (p_rec.attribute_category = hr_api.g_varchar2) then

329: If (p_rec.comments = hr_api.g_varchar2) then
330: p_rec.comments :=
331: per_asr_shd.g_old_rec.comments;
332: End If;
333: If (p_rec.attribute_category = hr_api.g_varchar2) then
334: p_rec.attribute_category :=
335: per_asr_shd.g_old_rec.attribute_category;
336: End If;
337: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 337: If (p_rec.attribute1 = hr_api.g_varchar2) then

333: If (p_rec.attribute_category = hr_api.g_varchar2) then
334: p_rec.attribute_category :=
335: per_asr_shd.g_old_rec.attribute_category;
336: End If;
337: If (p_rec.attribute1 = hr_api.g_varchar2) then
338: p_rec.attribute1 :=
339: per_asr_shd.g_old_rec.attribute1;
340: End If;
341: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 341: If (p_rec.attribute2 = hr_api.g_varchar2) then

337: If (p_rec.attribute1 = hr_api.g_varchar2) then
338: p_rec.attribute1 :=
339: per_asr_shd.g_old_rec.attribute1;
340: End If;
341: If (p_rec.attribute2 = hr_api.g_varchar2) then
342: p_rec.attribute2 :=
343: per_asr_shd.g_old_rec.attribute2;
344: End If;
345: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 345: If (p_rec.attribute3 = hr_api.g_varchar2) then

341: If (p_rec.attribute2 = hr_api.g_varchar2) then
342: p_rec.attribute2 :=
343: per_asr_shd.g_old_rec.attribute2;
344: End If;
345: If (p_rec.attribute3 = hr_api.g_varchar2) then
346: p_rec.attribute3 :=
347: per_asr_shd.g_old_rec.attribute3;
348: End If;
349: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 349: If (p_rec.attribute4 = hr_api.g_varchar2) then

345: If (p_rec.attribute3 = hr_api.g_varchar2) then
346: p_rec.attribute3 :=
347: per_asr_shd.g_old_rec.attribute3;
348: End If;
349: If (p_rec.attribute4 = hr_api.g_varchar2) then
350: p_rec.attribute4 :=
351: per_asr_shd.g_old_rec.attribute4;
352: End If;
353: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 353: If (p_rec.attribute5 = hr_api.g_varchar2) then

349: If (p_rec.attribute4 = hr_api.g_varchar2) then
350: p_rec.attribute4 :=
351: per_asr_shd.g_old_rec.attribute4;
352: End If;
353: If (p_rec.attribute5 = hr_api.g_varchar2) then
354: p_rec.attribute5 :=
355: per_asr_shd.g_old_rec.attribute5;
356: End If;
357: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 357: If (p_rec.attribute6 = hr_api.g_varchar2) then

353: If (p_rec.attribute5 = hr_api.g_varchar2) then
354: p_rec.attribute5 :=
355: per_asr_shd.g_old_rec.attribute5;
356: End If;
357: If (p_rec.attribute6 = hr_api.g_varchar2) then
358: p_rec.attribute6 :=
359: per_asr_shd.g_old_rec.attribute6;
360: End If;
361: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 361: If (p_rec.attribute7 = hr_api.g_varchar2) then

357: If (p_rec.attribute6 = hr_api.g_varchar2) then
358: p_rec.attribute6 :=
359: per_asr_shd.g_old_rec.attribute6;
360: End If;
361: If (p_rec.attribute7 = hr_api.g_varchar2) then
362: p_rec.attribute7 :=
363: per_asr_shd.g_old_rec.attribute7;
364: End If;
365: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 365: If (p_rec.attribute8 = hr_api.g_varchar2) then

361: If (p_rec.attribute7 = hr_api.g_varchar2) then
362: p_rec.attribute7 :=
363: per_asr_shd.g_old_rec.attribute7;
364: End If;
365: If (p_rec.attribute8 = hr_api.g_varchar2) then
366: p_rec.attribute8 :=
367: per_asr_shd.g_old_rec.attribute8;
368: End If;
369: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 369: If (p_rec.attribute9 = hr_api.g_varchar2) then

365: If (p_rec.attribute8 = hr_api.g_varchar2) then
366: p_rec.attribute8 :=
367: per_asr_shd.g_old_rec.attribute8;
368: End If;
369: If (p_rec.attribute9 = hr_api.g_varchar2) then
370: p_rec.attribute9 :=
371: per_asr_shd.g_old_rec.attribute9;
372: End If;
373: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 373: If (p_rec.attribute10 = hr_api.g_varchar2) then

369: If (p_rec.attribute9 = hr_api.g_varchar2) then
370: p_rec.attribute9 :=
371: per_asr_shd.g_old_rec.attribute9;
372: End If;
373: If (p_rec.attribute10 = hr_api.g_varchar2) then
374: p_rec.attribute10 :=
375: per_asr_shd.g_old_rec.attribute10;
376: End If;
377: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 377: If (p_rec.attribute11 = hr_api.g_varchar2) then

373: If (p_rec.attribute10 = hr_api.g_varchar2) then
374: p_rec.attribute10 :=
375: per_asr_shd.g_old_rec.attribute10;
376: End If;
377: If (p_rec.attribute11 = hr_api.g_varchar2) then
378: p_rec.attribute11 :=
379: per_asr_shd.g_old_rec.attribute11;
380: End If;
381: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 381: If (p_rec.attribute12 = hr_api.g_varchar2) then

377: If (p_rec.attribute11 = hr_api.g_varchar2) then
378: p_rec.attribute11 :=
379: per_asr_shd.g_old_rec.attribute11;
380: End If;
381: If (p_rec.attribute12 = hr_api.g_varchar2) then
382: p_rec.attribute12 :=
383: per_asr_shd.g_old_rec.attribute12;
384: End If;
385: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 385: If (p_rec.attribute13 = hr_api.g_varchar2) then

381: If (p_rec.attribute12 = hr_api.g_varchar2) then
382: p_rec.attribute12 :=
383: per_asr_shd.g_old_rec.attribute12;
384: End If;
385: If (p_rec.attribute13 = hr_api.g_varchar2) then
386: p_rec.attribute13 :=
387: per_asr_shd.g_old_rec.attribute13;
388: End If;
389: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 389: If (p_rec.attribute14 = hr_api.g_varchar2) then

385: If (p_rec.attribute13 = hr_api.g_varchar2) then
386: p_rec.attribute13 :=
387: per_asr_shd.g_old_rec.attribute13;
388: End If;
389: If (p_rec.attribute14 = hr_api.g_varchar2) then
390: p_rec.attribute14 :=
391: per_asr_shd.g_old_rec.attribute14;
392: End If;
393: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 393: If (p_rec.attribute15 = hr_api.g_varchar2) then

389: If (p_rec.attribute14 = hr_api.g_varchar2) then
390: p_rec.attribute14 :=
391: per_asr_shd.g_old_rec.attribute14;
392: End If;
393: If (p_rec.attribute15 = hr_api.g_varchar2) then
394: p_rec.attribute15 :=
395: per_asr_shd.g_old_rec.attribute15;
396: End If;
397: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 397: If (p_rec.attribute16 = hr_api.g_varchar2) then

393: If (p_rec.attribute15 = hr_api.g_varchar2) then
394: p_rec.attribute15 :=
395: per_asr_shd.g_old_rec.attribute15;
396: End If;
397: If (p_rec.attribute16 = hr_api.g_varchar2) then
398: p_rec.attribute16 :=
399: per_asr_shd.g_old_rec.attribute16;
400: End If;
401: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 401: If (p_rec.attribute17 = hr_api.g_varchar2) then

397: If (p_rec.attribute16 = hr_api.g_varchar2) then
398: p_rec.attribute16 :=
399: per_asr_shd.g_old_rec.attribute16;
400: End If;
401: If (p_rec.attribute17 = hr_api.g_varchar2) then
402: p_rec.attribute17 :=
403: per_asr_shd.g_old_rec.attribute17;
404: End If;
405: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 405: If (p_rec.attribute18 = hr_api.g_varchar2) then

401: If (p_rec.attribute17 = hr_api.g_varchar2) then
402: p_rec.attribute17 :=
403: per_asr_shd.g_old_rec.attribute17;
404: End If;
405: If (p_rec.attribute18 = hr_api.g_varchar2) then
406: p_rec.attribute18 :=
407: per_asr_shd.g_old_rec.attribute18;
408: End If;
409: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 409: If (p_rec.attribute19 = hr_api.g_varchar2) then

405: If (p_rec.attribute18 = hr_api.g_varchar2) then
406: p_rec.attribute18 :=
407: per_asr_shd.g_old_rec.attribute18;
408: End If;
409: If (p_rec.attribute19 = hr_api.g_varchar2) then
410: p_rec.attribute19 :=
411: per_asr_shd.g_old_rec.attribute19;
412: End If;
413: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 413: If (p_rec.attribute20 = hr_api.g_varchar2) then

409: If (p_rec.attribute19 = hr_api.g_varchar2) then
410: p_rec.attribute19 :=
411: per_asr_shd.g_old_rec.attribute19;
412: End If;
413: If (p_rec.attribute20 = hr_api.g_varchar2) then
414: p_rec.attribute20 :=
415: per_asr_shd.g_old_rec.attribute20;
416: End If;
417:

Line 480: Raise HR_Api.Validate_Enabled;

476: --
477: -- If we are validating then raise the Validate_Enabled exception
478: --
479: If p_validate then
480: Raise HR_Api.Validate_Enabled;
481: End If;
482: --
483: hr_utility.set_location(' Leaving:'||l_proc, 10);
484: Exception

Line 485: When HR_Api.Validate_Enabled Then

481: End If;
482: --
483: hr_utility.set_location(' Leaving:'||l_proc, 10);
484: Exception
485: When HR_Api.Validate_Enabled Then
486: --
487: -- As the Validate_Enabled exception has been raised
488: -- we must rollback to the savepoint
489: --

Line 499: p_name in varchar2 default hr_api.g_varchar2,

495: -- ----------------------------------------------------------------------------
496: Procedure upd
497: (
498: p_assessment_group_id in number,
499: p_name in varchar2 default hr_api.g_varchar2,
500: p_membership_list in varchar2 default hr_api.g_varchar2,
501: p_comments in varchar2 default hr_api.g_varchar2,
502: p_attribute_category in varchar2 default hr_api.g_varchar2,
503: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 500: p_membership_list in varchar2 default hr_api.g_varchar2,

496: Procedure upd
497: (
498: p_assessment_group_id in number,
499: p_name in varchar2 default hr_api.g_varchar2,
500: p_membership_list in varchar2 default hr_api.g_varchar2,
501: p_comments in varchar2 default hr_api.g_varchar2,
502: p_attribute_category in varchar2 default hr_api.g_varchar2,
503: p_attribute1 in varchar2 default hr_api.g_varchar2,
504: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 501: p_comments in varchar2 default hr_api.g_varchar2,

497: (
498: p_assessment_group_id in number,
499: p_name in varchar2 default hr_api.g_varchar2,
500: p_membership_list in varchar2 default hr_api.g_varchar2,
501: p_comments in varchar2 default hr_api.g_varchar2,
502: p_attribute_category in varchar2 default hr_api.g_varchar2,
503: p_attribute1 in varchar2 default hr_api.g_varchar2,
504: p_attribute2 in varchar2 default hr_api.g_varchar2,
505: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 502: p_attribute_category in varchar2 default hr_api.g_varchar2,

498: p_assessment_group_id in number,
499: p_name in varchar2 default hr_api.g_varchar2,
500: p_membership_list in varchar2 default hr_api.g_varchar2,
501: p_comments in varchar2 default hr_api.g_varchar2,
502: p_attribute_category in varchar2 default hr_api.g_varchar2,
503: p_attribute1 in varchar2 default hr_api.g_varchar2,
504: p_attribute2 in varchar2 default hr_api.g_varchar2,
505: p_attribute3 in varchar2 default hr_api.g_varchar2,
506: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 503: p_attribute1 in varchar2 default hr_api.g_varchar2,

499: p_name in varchar2 default hr_api.g_varchar2,
500: p_membership_list in varchar2 default hr_api.g_varchar2,
501: p_comments in varchar2 default hr_api.g_varchar2,
502: p_attribute_category in varchar2 default hr_api.g_varchar2,
503: p_attribute1 in varchar2 default hr_api.g_varchar2,
504: p_attribute2 in varchar2 default hr_api.g_varchar2,
505: p_attribute3 in varchar2 default hr_api.g_varchar2,
506: p_attribute4 in varchar2 default hr_api.g_varchar2,
507: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 504: p_attribute2 in varchar2 default hr_api.g_varchar2,

500: p_membership_list in varchar2 default hr_api.g_varchar2,
501: p_comments in varchar2 default hr_api.g_varchar2,
502: p_attribute_category in varchar2 default hr_api.g_varchar2,
503: p_attribute1 in varchar2 default hr_api.g_varchar2,
504: p_attribute2 in varchar2 default hr_api.g_varchar2,
505: p_attribute3 in varchar2 default hr_api.g_varchar2,
506: p_attribute4 in varchar2 default hr_api.g_varchar2,
507: p_attribute5 in varchar2 default hr_api.g_varchar2,
508: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 505: p_attribute3 in varchar2 default hr_api.g_varchar2,

501: p_comments in varchar2 default hr_api.g_varchar2,
502: p_attribute_category in varchar2 default hr_api.g_varchar2,
503: p_attribute1 in varchar2 default hr_api.g_varchar2,
504: p_attribute2 in varchar2 default hr_api.g_varchar2,
505: p_attribute3 in varchar2 default hr_api.g_varchar2,
506: p_attribute4 in varchar2 default hr_api.g_varchar2,
507: p_attribute5 in varchar2 default hr_api.g_varchar2,
508: p_attribute6 in varchar2 default hr_api.g_varchar2,
509: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 506: p_attribute4 in varchar2 default hr_api.g_varchar2,

502: p_attribute_category in varchar2 default hr_api.g_varchar2,
503: p_attribute1 in varchar2 default hr_api.g_varchar2,
504: p_attribute2 in varchar2 default hr_api.g_varchar2,
505: p_attribute3 in varchar2 default hr_api.g_varchar2,
506: p_attribute4 in varchar2 default hr_api.g_varchar2,
507: p_attribute5 in varchar2 default hr_api.g_varchar2,
508: p_attribute6 in varchar2 default hr_api.g_varchar2,
509: p_attribute7 in varchar2 default hr_api.g_varchar2,
510: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 507: p_attribute5 in varchar2 default hr_api.g_varchar2,

503: p_attribute1 in varchar2 default hr_api.g_varchar2,
504: p_attribute2 in varchar2 default hr_api.g_varchar2,
505: p_attribute3 in varchar2 default hr_api.g_varchar2,
506: p_attribute4 in varchar2 default hr_api.g_varchar2,
507: p_attribute5 in varchar2 default hr_api.g_varchar2,
508: p_attribute6 in varchar2 default hr_api.g_varchar2,
509: p_attribute7 in varchar2 default hr_api.g_varchar2,
510: p_attribute8 in varchar2 default hr_api.g_varchar2,
511: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 508: p_attribute6 in varchar2 default hr_api.g_varchar2,

504: p_attribute2 in varchar2 default hr_api.g_varchar2,
505: p_attribute3 in varchar2 default hr_api.g_varchar2,
506: p_attribute4 in varchar2 default hr_api.g_varchar2,
507: p_attribute5 in varchar2 default hr_api.g_varchar2,
508: p_attribute6 in varchar2 default hr_api.g_varchar2,
509: p_attribute7 in varchar2 default hr_api.g_varchar2,
510: p_attribute8 in varchar2 default hr_api.g_varchar2,
511: p_attribute9 in varchar2 default hr_api.g_varchar2,
512: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 509: p_attribute7 in varchar2 default hr_api.g_varchar2,

505: p_attribute3 in varchar2 default hr_api.g_varchar2,
506: p_attribute4 in varchar2 default hr_api.g_varchar2,
507: p_attribute5 in varchar2 default hr_api.g_varchar2,
508: p_attribute6 in varchar2 default hr_api.g_varchar2,
509: p_attribute7 in varchar2 default hr_api.g_varchar2,
510: p_attribute8 in varchar2 default hr_api.g_varchar2,
511: p_attribute9 in varchar2 default hr_api.g_varchar2,
512: p_attribute10 in varchar2 default hr_api.g_varchar2,
513: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 510: p_attribute8 in varchar2 default hr_api.g_varchar2,

506: p_attribute4 in varchar2 default hr_api.g_varchar2,
507: p_attribute5 in varchar2 default hr_api.g_varchar2,
508: p_attribute6 in varchar2 default hr_api.g_varchar2,
509: p_attribute7 in varchar2 default hr_api.g_varchar2,
510: p_attribute8 in varchar2 default hr_api.g_varchar2,
511: p_attribute9 in varchar2 default hr_api.g_varchar2,
512: p_attribute10 in varchar2 default hr_api.g_varchar2,
513: p_attribute11 in varchar2 default hr_api.g_varchar2,
514: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 511: p_attribute9 in varchar2 default hr_api.g_varchar2,

507: p_attribute5 in varchar2 default hr_api.g_varchar2,
508: p_attribute6 in varchar2 default hr_api.g_varchar2,
509: p_attribute7 in varchar2 default hr_api.g_varchar2,
510: p_attribute8 in varchar2 default hr_api.g_varchar2,
511: p_attribute9 in varchar2 default hr_api.g_varchar2,
512: p_attribute10 in varchar2 default hr_api.g_varchar2,
513: p_attribute11 in varchar2 default hr_api.g_varchar2,
514: p_attribute12 in varchar2 default hr_api.g_varchar2,
515: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 512: p_attribute10 in varchar2 default hr_api.g_varchar2,

508: p_attribute6 in varchar2 default hr_api.g_varchar2,
509: p_attribute7 in varchar2 default hr_api.g_varchar2,
510: p_attribute8 in varchar2 default hr_api.g_varchar2,
511: p_attribute9 in varchar2 default hr_api.g_varchar2,
512: p_attribute10 in varchar2 default hr_api.g_varchar2,
513: p_attribute11 in varchar2 default hr_api.g_varchar2,
514: p_attribute12 in varchar2 default hr_api.g_varchar2,
515: p_attribute13 in varchar2 default hr_api.g_varchar2,
516: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 513: p_attribute11 in varchar2 default hr_api.g_varchar2,

509: p_attribute7 in varchar2 default hr_api.g_varchar2,
510: p_attribute8 in varchar2 default hr_api.g_varchar2,
511: p_attribute9 in varchar2 default hr_api.g_varchar2,
512: p_attribute10 in varchar2 default hr_api.g_varchar2,
513: p_attribute11 in varchar2 default hr_api.g_varchar2,
514: p_attribute12 in varchar2 default hr_api.g_varchar2,
515: p_attribute13 in varchar2 default hr_api.g_varchar2,
516: p_attribute14 in varchar2 default hr_api.g_varchar2,
517: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 514: p_attribute12 in varchar2 default hr_api.g_varchar2,

510: p_attribute8 in varchar2 default hr_api.g_varchar2,
511: p_attribute9 in varchar2 default hr_api.g_varchar2,
512: p_attribute10 in varchar2 default hr_api.g_varchar2,
513: p_attribute11 in varchar2 default hr_api.g_varchar2,
514: p_attribute12 in varchar2 default hr_api.g_varchar2,
515: p_attribute13 in varchar2 default hr_api.g_varchar2,
516: p_attribute14 in varchar2 default hr_api.g_varchar2,
517: p_attribute15 in varchar2 default hr_api.g_varchar2,
518: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 515: p_attribute13 in varchar2 default hr_api.g_varchar2,

511: p_attribute9 in varchar2 default hr_api.g_varchar2,
512: p_attribute10 in varchar2 default hr_api.g_varchar2,
513: p_attribute11 in varchar2 default hr_api.g_varchar2,
514: p_attribute12 in varchar2 default hr_api.g_varchar2,
515: p_attribute13 in varchar2 default hr_api.g_varchar2,
516: p_attribute14 in varchar2 default hr_api.g_varchar2,
517: p_attribute15 in varchar2 default hr_api.g_varchar2,
518: p_attribute16 in varchar2 default hr_api.g_varchar2,
519: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 516: p_attribute14 in varchar2 default hr_api.g_varchar2,

512: p_attribute10 in varchar2 default hr_api.g_varchar2,
513: p_attribute11 in varchar2 default hr_api.g_varchar2,
514: p_attribute12 in varchar2 default hr_api.g_varchar2,
515: p_attribute13 in varchar2 default hr_api.g_varchar2,
516: p_attribute14 in varchar2 default hr_api.g_varchar2,
517: p_attribute15 in varchar2 default hr_api.g_varchar2,
518: p_attribute16 in varchar2 default hr_api.g_varchar2,
519: p_attribute17 in varchar2 default hr_api.g_varchar2,
520: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 517: p_attribute15 in varchar2 default hr_api.g_varchar2,

513: p_attribute11 in varchar2 default hr_api.g_varchar2,
514: p_attribute12 in varchar2 default hr_api.g_varchar2,
515: p_attribute13 in varchar2 default hr_api.g_varchar2,
516: p_attribute14 in varchar2 default hr_api.g_varchar2,
517: p_attribute15 in varchar2 default hr_api.g_varchar2,
518: p_attribute16 in varchar2 default hr_api.g_varchar2,
519: p_attribute17 in varchar2 default hr_api.g_varchar2,
520: p_attribute18 in varchar2 default hr_api.g_varchar2,
521: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 518: p_attribute16 in varchar2 default hr_api.g_varchar2,

514: p_attribute12 in varchar2 default hr_api.g_varchar2,
515: p_attribute13 in varchar2 default hr_api.g_varchar2,
516: p_attribute14 in varchar2 default hr_api.g_varchar2,
517: p_attribute15 in varchar2 default hr_api.g_varchar2,
518: p_attribute16 in varchar2 default hr_api.g_varchar2,
519: p_attribute17 in varchar2 default hr_api.g_varchar2,
520: p_attribute18 in varchar2 default hr_api.g_varchar2,
521: p_attribute19 in varchar2 default hr_api.g_varchar2,
522: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 519: p_attribute17 in varchar2 default hr_api.g_varchar2,

515: p_attribute13 in varchar2 default hr_api.g_varchar2,
516: p_attribute14 in varchar2 default hr_api.g_varchar2,
517: p_attribute15 in varchar2 default hr_api.g_varchar2,
518: p_attribute16 in varchar2 default hr_api.g_varchar2,
519: p_attribute17 in varchar2 default hr_api.g_varchar2,
520: p_attribute18 in varchar2 default hr_api.g_varchar2,
521: p_attribute19 in varchar2 default hr_api.g_varchar2,
522: p_attribute20 in varchar2 default hr_api.g_varchar2,
523: p_object_version_number in out number,

Line 520: p_attribute18 in varchar2 default hr_api.g_varchar2,

516: p_attribute14 in varchar2 default hr_api.g_varchar2,
517: p_attribute15 in varchar2 default hr_api.g_varchar2,
518: p_attribute16 in varchar2 default hr_api.g_varchar2,
519: p_attribute17 in varchar2 default hr_api.g_varchar2,
520: p_attribute18 in varchar2 default hr_api.g_varchar2,
521: p_attribute19 in varchar2 default hr_api.g_varchar2,
522: p_attribute20 in varchar2 default hr_api.g_varchar2,
523: p_object_version_number in out number,
524: p_validate in boolean default false,

Line 521: p_attribute19 in varchar2 default hr_api.g_varchar2,

517: p_attribute15 in varchar2 default hr_api.g_varchar2,
518: p_attribute16 in varchar2 default hr_api.g_varchar2,
519: p_attribute17 in varchar2 default hr_api.g_varchar2,
520: p_attribute18 in varchar2 default hr_api.g_varchar2,
521: p_attribute19 in varchar2 default hr_api.g_varchar2,
522: p_attribute20 in varchar2 default hr_api.g_varchar2,
523: p_object_version_number in out number,
524: p_validate in boolean default false,
525: p_effective_date in date

Line 522: p_attribute20 in varchar2 default hr_api.g_varchar2,

518: p_attribute16 in varchar2 default hr_api.g_varchar2,
519: p_attribute17 in varchar2 default hr_api.g_varchar2,
520: p_attribute18 in varchar2 default hr_api.g_varchar2,
521: p_attribute19 in varchar2 default hr_api.g_varchar2,
522: p_attribute20 in varchar2 default hr_api.g_varchar2,
523: p_object_version_number in out number,
524: p_validate in boolean default false,
525: p_effective_date in date
526: ) is

Line 542: hr_api.g_number,

538: per_asr_shd.convert_args
539: (
540: p_assessment_group_id,
541: p_name,
542: hr_api.g_number,
543: p_membership_list,
544: p_comments,
545: p_attribute_category,
546: p_attribute1,