APPS.PER_GRS_UPD dependencies on HR_API

Line 104: When hr_api.check_integrity_violated Then

100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error

Line 109: When hr_api.parent_integrity_violated Then

105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error

Line 114: When hr_api.unique_integrity_violated Then

110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: per_grs_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
122: End update_dml;

Line 270: when hr_api.cannot_find_prog_unit then

266: );
267: --
268: exception
269: --
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'per_cagr_grade_structures'
274: ,p_hook_type => 'AU');

Line 272: hr_api.cannot_find_prog_unit_error

268: exception
269: --
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'per_cagr_grade_structures'
274: ,p_hook_type => 'AU');
275: --
276: end;

Line 340: If (p_rec.collective_agreement_id = hr_api.g_number) then

336: -- p_rec plsql record structure
337: -- to see if a system default is being used. If a system default
338: -- is being used then we must set to the 'current' argument value.
339: --
340: If (p_rec.collective_agreement_id = hr_api.g_number) then
341: p_rec.collective_agreement_id :=
342: per_grs_shd.g_old_rec.collective_agreement_id;
343: End If;
344: If (p_rec.id_flex_num = hr_api.g_number) then

Line 344: If (p_rec.id_flex_num = hr_api.g_number) then

340: If (p_rec.collective_agreement_id = hr_api.g_number) then
341: p_rec.collective_agreement_id :=
342: per_grs_shd.g_old_rec.collective_agreement_id;
343: End If;
344: If (p_rec.id_flex_num = hr_api.g_number) then
345: p_rec.id_flex_num :=
346: per_grs_shd.g_old_rec.id_flex_num;
347: End If;
348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then

Line 348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then

344: If (p_rec.id_flex_num = hr_api.g_number) then
345: p_rec.id_flex_num :=
346: per_grs_shd.g_old_rec.id_flex_num;
347: End If;
348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then
349: p_rec.dynamic_insert_allowed :=
350: per_grs_shd.g_old_rec.dynamic_insert_allowed;
351: End If;
352: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then
349: p_rec.dynamic_insert_allowed :=
350: per_grs_shd.g_old_rec.dynamic_insert_allowed;
351: End If;
352: If (p_rec.attribute_category = hr_api.g_varchar2) then
353: p_rec.attribute_category :=
354: per_grs_shd.g_old_rec.attribute_category;
355: End If;
356: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

352: If (p_rec.attribute_category = hr_api.g_varchar2) then
353: p_rec.attribute_category :=
354: per_grs_shd.g_old_rec.attribute_category;
355: End If;
356: If (p_rec.attribute1 = hr_api.g_varchar2) then
357: p_rec.attribute1 :=
358: per_grs_shd.g_old_rec.attribute1;
359: End If;
360: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

356: If (p_rec.attribute1 = hr_api.g_varchar2) then
357: p_rec.attribute1 :=
358: per_grs_shd.g_old_rec.attribute1;
359: End If;
360: If (p_rec.attribute2 = hr_api.g_varchar2) then
361: p_rec.attribute2 :=
362: per_grs_shd.g_old_rec.attribute2;
363: End If;
364: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

360: If (p_rec.attribute2 = hr_api.g_varchar2) then
361: p_rec.attribute2 :=
362: per_grs_shd.g_old_rec.attribute2;
363: End If;
364: If (p_rec.attribute3 = hr_api.g_varchar2) then
365: p_rec.attribute3 :=
366: per_grs_shd.g_old_rec.attribute3;
367: End If;
368: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

364: If (p_rec.attribute3 = hr_api.g_varchar2) then
365: p_rec.attribute3 :=
366: per_grs_shd.g_old_rec.attribute3;
367: End If;
368: If (p_rec.attribute4 = hr_api.g_varchar2) then
369: p_rec.attribute4 :=
370: per_grs_shd.g_old_rec.attribute4;
371: End If;
372: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

368: If (p_rec.attribute4 = hr_api.g_varchar2) then
369: p_rec.attribute4 :=
370: per_grs_shd.g_old_rec.attribute4;
371: End If;
372: If (p_rec.attribute5 = hr_api.g_varchar2) then
373: p_rec.attribute5 :=
374: per_grs_shd.g_old_rec.attribute5;
375: End If;
376: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

372: If (p_rec.attribute5 = hr_api.g_varchar2) then
373: p_rec.attribute5 :=
374: per_grs_shd.g_old_rec.attribute5;
375: End If;
376: If (p_rec.attribute6 = hr_api.g_varchar2) then
377: p_rec.attribute6 :=
378: per_grs_shd.g_old_rec.attribute6;
379: End If;
380: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

376: If (p_rec.attribute6 = hr_api.g_varchar2) then
377: p_rec.attribute6 :=
378: per_grs_shd.g_old_rec.attribute6;
379: End If;
380: If (p_rec.attribute7 = hr_api.g_varchar2) then
381: p_rec.attribute7 :=
382: per_grs_shd.g_old_rec.attribute7;
383: End If;
384: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

380: If (p_rec.attribute7 = hr_api.g_varchar2) then
381: p_rec.attribute7 :=
382: per_grs_shd.g_old_rec.attribute7;
383: End If;
384: If (p_rec.attribute8 = hr_api.g_varchar2) then
385: p_rec.attribute8 :=
386: per_grs_shd.g_old_rec.attribute8;
387: End If;
388: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

384: If (p_rec.attribute8 = hr_api.g_varchar2) then
385: p_rec.attribute8 :=
386: per_grs_shd.g_old_rec.attribute8;
387: End If;
388: If (p_rec.attribute9 = hr_api.g_varchar2) then
389: p_rec.attribute9 :=
390: per_grs_shd.g_old_rec.attribute9;
391: End If;
392: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

388: If (p_rec.attribute9 = hr_api.g_varchar2) then
389: p_rec.attribute9 :=
390: per_grs_shd.g_old_rec.attribute9;
391: End If;
392: If (p_rec.attribute10 = hr_api.g_varchar2) then
393: p_rec.attribute10 :=
394: per_grs_shd.g_old_rec.attribute10;
395: End If;
396: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

392: If (p_rec.attribute10 = hr_api.g_varchar2) then
393: p_rec.attribute10 :=
394: per_grs_shd.g_old_rec.attribute10;
395: End If;
396: If (p_rec.attribute11 = hr_api.g_varchar2) then
397: p_rec.attribute11 :=
398: per_grs_shd.g_old_rec.attribute11;
399: End If;
400: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

396: If (p_rec.attribute11 = hr_api.g_varchar2) then
397: p_rec.attribute11 :=
398: per_grs_shd.g_old_rec.attribute11;
399: End If;
400: If (p_rec.attribute12 = hr_api.g_varchar2) then
401: p_rec.attribute12 :=
402: per_grs_shd.g_old_rec.attribute12;
403: End If;
404: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

400: If (p_rec.attribute12 = hr_api.g_varchar2) then
401: p_rec.attribute12 :=
402: per_grs_shd.g_old_rec.attribute12;
403: End If;
404: If (p_rec.attribute13 = hr_api.g_varchar2) then
405: p_rec.attribute13 :=
406: per_grs_shd.g_old_rec.attribute13;
407: End If;
408: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

404: If (p_rec.attribute13 = hr_api.g_varchar2) then
405: p_rec.attribute13 :=
406: per_grs_shd.g_old_rec.attribute13;
407: End If;
408: If (p_rec.attribute14 = hr_api.g_varchar2) then
409: p_rec.attribute14 :=
410: per_grs_shd.g_old_rec.attribute14;
411: End If;
412: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

408: If (p_rec.attribute14 = hr_api.g_varchar2) then
409: p_rec.attribute14 :=
410: per_grs_shd.g_old_rec.attribute14;
411: End If;
412: If (p_rec.attribute15 = hr_api.g_varchar2) then
413: p_rec.attribute15 :=
414: per_grs_shd.g_old_rec.attribute15;
415: End If;
416: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

412: If (p_rec.attribute15 = hr_api.g_varchar2) then
413: p_rec.attribute15 :=
414: per_grs_shd.g_old_rec.attribute15;
415: End If;
416: If (p_rec.attribute16 = hr_api.g_varchar2) then
417: p_rec.attribute16 :=
418: per_grs_shd.g_old_rec.attribute16;
419: End If;
420: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

416: If (p_rec.attribute16 = hr_api.g_varchar2) then
417: p_rec.attribute16 :=
418: per_grs_shd.g_old_rec.attribute16;
419: End If;
420: If (p_rec.attribute17 = hr_api.g_varchar2) then
421: p_rec.attribute17 :=
422: per_grs_shd.g_old_rec.attribute17;
423: End If;
424: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

420: If (p_rec.attribute17 = hr_api.g_varchar2) then
421: p_rec.attribute17 :=
422: per_grs_shd.g_old_rec.attribute17;
423: End If;
424: If (p_rec.attribute18 = hr_api.g_varchar2) then
425: p_rec.attribute18 :=
426: per_grs_shd.g_old_rec.attribute18;
427: End If;
428: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

424: If (p_rec.attribute18 = hr_api.g_varchar2) then
425: p_rec.attribute18 :=
426: per_grs_shd.g_old_rec.attribute18;
427: End If;
428: If (p_rec.attribute19 = hr_api.g_varchar2) then
429: p_rec.attribute19 :=
430: per_grs_shd.g_old_rec.attribute19;
431: End If;
432: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

428: If (p_rec.attribute19 = hr_api.g_varchar2) then
429: p_rec.attribute19 :=
430: per_grs_shd.g_old_rec.attribute19;
431: End If;
432: If (p_rec.attribute20 = hr_api.g_varchar2) then
433: p_rec.attribute20 :=
434: per_grs_shd.g_old_rec.attribute20;
435: End If;
436: --

Line 496: p_collective_agreement_id in number default hr_api.g_number,

492: -- ----------------------------------------------------------------------------
493: Procedure upd
494: (
495: p_cagr_grade_structure_id in number,
496: p_collective_agreement_id in number default hr_api.g_number,
497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 498: p_id_flex_num in number default hr_api.g_number,

494: (
495: p_cagr_grade_structure_id in number,
496: p_collective_agreement_id in number default hr_api.g_number,
497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,

495: p_cagr_grade_structure_id in number,
496: p_collective_agreement_id in number default hr_api.g_number,
497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 500: p_attribute_category in varchar2 default hr_api.g_varchar2,

496: p_collective_agreement_id in number default hr_api.g_number,
497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 501: p_attribute1 in varchar2 default hr_api.g_varchar2,

497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 502: p_attribute2 in varchar2 default hr_api.g_varchar2,

498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 503: p_attribute3 in varchar2 default hr_api.g_varchar2,

499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 504: p_attribute4 in varchar2 default hr_api.g_varchar2,

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

Line 505: p_attribute5 in varchar2 default hr_api.g_varchar2,

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

Line 506: p_attribute6 in varchar2 default hr_api.g_varchar2,

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

Line 507: p_attribute7 in varchar2 default hr_api.g_varchar2,

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

Line 508: p_attribute8 in varchar2 default hr_api.g_varchar2,

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

Line 509: p_attribute9 in varchar2 default hr_api.g_varchar2,

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

Line 510: p_attribute10 in varchar2 default hr_api.g_varchar2,

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

Line 511: p_attribute11 in varchar2 default hr_api.g_varchar2,

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

Line 512: p_attribute12 in varchar2 default hr_api.g_varchar2,

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

Line 513: p_attribute13 in varchar2 default hr_api.g_varchar2,

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

Line 514: p_attribute14 in varchar2 default hr_api.g_varchar2,

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

Line 515: p_attribute15 in varchar2 default hr_api.g_varchar2,

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

Line 516: p_attribute16 in varchar2 default hr_api.g_varchar2,

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

Line 517: p_attribute17 in varchar2 default hr_api.g_varchar2,

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

Line 518: p_attribute18 in varchar2 default hr_api.g_varchar2,

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

Line 519: p_attribute19 in varchar2 default hr_api.g_varchar2,

515: p_attribute15 in varchar2 default hr_api.g_varchar2,
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
518: p_attribute18 in varchar2 default hr_api.g_varchar2,
519: p_attribute19 in varchar2 default hr_api.g_varchar2,
520: p_attribute20 in varchar2 default hr_api.g_varchar2,
521: p_effective_date in date
522: ) is
523: --

Line 520: p_attribute20 in varchar2 default hr_api.g_varchar2,

516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
518: p_attribute18 in varchar2 default hr_api.g_varchar2,
519: p_attribute19 in varchar2 default hr_api.g_varchar2,
520: p_attribute20 in varchar2 default hr_api.g_varchar2,
521: p_effective_date in date
522: ) is
523: --
524: l_rec per_grs_shd.g_rec_type;