APPS.BEN_CQB_UPD dependencies on HR_API

Line 121: When hr_api.check_integrity_violated Then

117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: --
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
124: ben_cqb_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
124: ben_cqb_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
129: ben_cqb_shd.constraint_error

Line 126: When hr_api.parent_integrity_violated Then

122: -- A check constraint has been violated
123: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
124: ben_cqb_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
129: ben_cqb_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
129: ben_cqb_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
134: ben_cqb_shd.constraint_error

Line 131: When hr_api.unique_integrity_violated Then

127: -- Parent integrity has been violated
128: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
129: ben_cqb_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
134: ben_cqb_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
134: ben_cqb_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: ben_cqb_shd.g_api_dml := false; -- Unset the api dml status
138: Raise;
139: End update_dml;

Line 320: when hr_api.cannot_find_prog_unit then

316: );
317: --
318: exception
319: --
320: when hr_api.cannot_find_prog_unit then
321: --
322: hr_api.cannot_find_prog_unit_error
323: (p_module_name => 'ben_cbr_quald_bnf'
324: ,p_hook_type => 'AU');

Line 322: hr_api.cannot_find_prog_unit_error

318: exception
319: --
320: when hr_api.cannot_find_prog_unit then
321: --
322: hr_api.cannot_find_prog_unit_error
323: (p_module_name => 'ben_cbr_quald_bnf'
324: ,p_hook_type => 'AU');
325: --
326: end;

Line 390: If (p_rec.quald_bnf_flag = hr_api.g_varchar2) then

386: -- p_rec plsql record structure
387: -- to see if a system default is being used. If a system default
388: -- is being used then we must set to the 'current' argument value.
389: --
390: If (p_rec.quald_bnf_flag = hr_api.g_varchar2) then
391: p_rec.quald_bnf_flag :=
392: ben_cqb_shd.g_old_rec.quald_bnf_flag;
393: End If;
394: If (p_rec.cbr_elig_perd_strt_dt = hr_api.g_date) then

Line 394: If (p_rec.cbr_elig_perd_strt_dt = hr_api.g_date) then

390: If (p_rec.quald_bnf_flag = hr_api.g_varchar2) then
391: p_rec.quald_bnf_flag :=
392: ben_cqb_shd.g_old_rec.quald_bnf_flag;
393: End If;
394: If (p_rec.cbr_elig_perd_strt_dt = hr_api.g_date) then
395: p_rec.cbr_elig_perd_strt_dt :=
396: ben_cqb_shd.g_old_rec.cbr_elig_perd_strt_dt;
397: End If;
398: If (p_rec.cbr_elig_perd_end_dt = hr_api.g_date) then

Line 398: If (p_rec.cbr_elig_perd_end_dt = hr_api.g_date) then

394: If (p_rec.cbr_elig_perd_strt_dt = hr_api.g_date) then
395: p_rec.cbr_elig_perd_strt_dt :=
396: ben_cqb_shd.g_old_rec.cbr_elig_perd_strt_dt;
397: End If;
398: If (p_rec.cbr_elig_perd_end_dt = hr_api.g_date) then
399: p_rec.cbr_elig_perd_end_dt :=
400: ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt;
401: End If;
402: If (p_rec.quald_bnf_person_id = hr_api.g_number) then

Line 402: If (p_rec.quald_bnf_person_id = hr_api.g_number) then

398: If (p_rec.cbr_elig_perd_end_dt = hr_api.g_date) then
399: p_rec.cbr_elig_perd_end_dt :=
400: ben_cqb_shd.g_old_rec.cbr_elig_perd_end_dt;
401: End If;
402: If (p_rec.quald_bnf_person_id = hr_api.g_number) then
403: p_rec.quald_bnf_person_id :=
404: ben_cqb_shd.g_old_rec.quald_bnf_person_id;
405: End If;
406: If (p_rec.pgm_id = hr_api.g_number) then

Line 406: If (p_rec.pgm_id = hr_api.g_number) then

402: If (p_rec.quald_bnf_person_id = hr_api.g_number) then
403: p_rec.quald_bnf_person_id :=
404: ben_cqb_shd.g_old_rec.quald_bnf_person_id;
405: End If;
406: If (p_rec.pgm_id = hr_api.g_number) then
407: p_rec.pgm_id :=
408: ben_cqb_shd.g_old_rec.pgm_id;
409: End If;
410: If (p_rec.ptip_id = hr_api.g_number) then

Line 410: If (p_rec.ptip_id = hr_api.g_number) then

406: If (p_rec.pgm_id = hr_api.g_number) then
407: p_rec.pgm_id :=
408: ben_cqb_shd.g_old_rec.pgm_id;
409: End If;
410: If (p_rec.ptip_id = hr_api.g_number) then
411: p_rec.ptip_id :=
412: ben_cqb_shd.g_old_rec.ptip_id;
413: End If;
414: If (p_rec.pl_typ_id = hr_api.g_number) then

Line 414: If (p_rec.pl_typ_id = hr_api.g_number) then

410: If (p_rec.ptip_id = hr_api.g_number) then
411: p_rec.ptip_id :=
412: ben_cqb_shd.g_old_rec.ptip_id;
413: End If;
414: If (p_rec.pl_typ_id = hr_api.g_number) then
415: p_rec.pl_typ_id :=
416: ben_cqb_shd.g_old_rec.pl_typ_id;
417: End If;
418: If (p_rec.cvrd_emp_person_id = hr_api.g_number) then

Line 418: If (p_rec.cvrd_emp_person_id = hr_api.g_number) then

414: If (p_rec.pl_typ_id = hr_api.g_number) then
415: p_rec.pl_typ_id :=
416: ben_cqb_shd.g_old_rec.pl_typ_id;
417: End If;
418: If (p_rec.cvrd_emp_person_id = hr_api.g_number) then
419: p_rec.cvrd_emp_person_id :=
420: ben_cqb_shd.g_old_rec.cvrd_emp_person_id;
421: End If;
422: If (p_rec.cbr_inelg_rsn_cd = hr_api.g_varchar2) then

Line 422: If (p_rec.cbr_inelg_rsn_cd = hr_api.g_varchar2) then

418: If (p_rec.cvrd_emp_person_id = hr_api.g_number) then
419: p_rec.cvrd_emp_person_id :=
420: ben_cqb_shd.g_old_rec.cvrd_emp_person_id;
421: End If;
422: If (p_rec.cbr_inelg_rsn_cd = hr_api.g_varchar2) then
423: p_rec.cbr_inelg_rsn_cd :=
424: ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd;
425: End If;
426: If (p_rec.business_group_id = hr_api.g_number) then

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

422: If (p_rec.cbr_inelg_rsn_cd = hr_api.g_varchar2) then
423: p_rec.cbr_inelg_rsn_cd :=
424: ben_cqb_shd.g_old_rec.cbr_inelg_rsn_cd;
425: End If;
426: If (p_rec.business_group_id = hr_api.g_number) then
427: p_rec.business_group_id :=
428: ben_cqb_shd.g_old_rec.business_group_id;
429: End If;
430: If (p_rec.cqb_attribute_category = hr_api.g_varchar2) then

Line 430: If (p_rec.cqb_attribute_category = hr_api.g_varchar2) then

426: If (p_rec.business_group_id = hr_api.g_number) then
427: p_rec.business_group_id :=
428: ben_cqb_shd.g_old_rec.business_group_id;
429: End If;
430: If (p_rec.cqb_attribute_category = hr_api.g_varchar2) then
431: p_rec.cqb_attribute_category :=
432: ben_cqb_shd.g_old_rec.cqb_attribute_category;
433: End If;
434: If (p_rec.cqb_attribute1 = hr_api.g_varchar2) then

Line 434: If (p_rec.cqb_attribute1 = hr_api.g_varchar2) then

430: If (p_rec.cqb_attribute_category = hr_api.g_varchar2) then
431: p_rec.cqb_attribute_category :=
432: ben_cqb_shd.g_old_rec.cqb_attribute_category;
433: End If;
434: If (p_rec.cqb_attribute1 = hr_api.g_varchar2) then
435: p_rec.cqb_attribute1 :=
436: ben_cqb_shd.g_old_rec.cqb_attribute1;
437: End If;
438: If (p_rec.cqb_attribute2 = hr_api.g_varchar2) then

Line 438: If (p_rec.cqb_attribute2 = hr_api.g_varchar2) then

434: If (p_rec.cqb_attribute1 = hr_api.g_varchar2) then
435: p_rec.cqb_attribute1 :=
436: ben_cqb_shd.g_old_rec.cqb_attribute1;
437: End If;
438: If (p_rec.cqb_attribute2 = hr_api.g_varchar2) then
439: p_rec.cqb_attribute2 :=
440: ben_cqb_shd.g_old_rec.cqb_attribute2;
441: End If;
442: If (p_rec.cqb_attribute3 = hr_api.g_varchar2) then

Line 442: If (p_rec.cqb_attribute3 = hr_api.g_varchar2) then

438: If (p_rec.cqb_attribute2 = hr_api.g_varchar2) then
439: p_rec.cqb_attribute2 :=
440: ben_cqb_shd.g_old_rec.cqb_attribute2;
441: End If;
442: If (p_rec.cqb_attribute3 = hr_api.g_varchar2) then
443: p_rec.cqb_attribute3 :=
444: ben_cqb_shd.g_old_rec.cqb_attribute3;
445: End If;
446: If (p_rec.cqb_attribute4 = hr_api.g_varchar2) then

Line 446: If (p_rec.cqb_attribute4 = hr_api.g_varchar2) then

442: If (p_rec.cqb_attribute3 = hr_api.g_varchar2) then
443: p_rec.cqb_attribute3 :=
444: ben_cqb_shd.g_old_rec.cqb_attribute3;
445: End If;
446: If (p_rec.cqb_attribute4 = hr_api.g_varchar2) then
447: p_rec.cqb_attribute4 :=
448: ben_cqb_shd.g_old_rec.cqb_attribute4;
449: End If;
450: If (p_rec.cqb_attribute5 = hr_api.g_varchar2) then

Line 450: If (p_rec.cqb_attribute5 = hr_api.g_varchar2) then

446: If (p_rec.cqb_attribute4 = hr_api.g_varchar2) then
447: p_rec.cqb_attribute4 :=
448: ben_cqb_shd.g_old_rec.cqb_attribute4;
449: End If;
450: If (p_rec.cqb_attribute5 = hr_api.g_varchar2) then
451: p_rec.cqb_attribute5 :=
452: ben_cqb_shd.g_old_rec.cqb_attribute5;
453: End If;
454: If (p_rec.cqb_attribute6 = hr_api.g_varchar2) then

Line 454: If (p_rec.cqb_attribute6 = hr_api.g_varchar2) then

450: If (p_rec.cqb_attribute5 = hr_api.g_varchar2) then
451: p_rec.cqb_attribute5 :=
452: ben_cqb_shd.g_old_rec.cqb_attribute5;
453: End If;
454: If (p_rec.cqb_attribute6 = hr_api.g_varchar2) then
455: p_rec.cqb_attribute6 :=
456: ben_cqb_shd.g_old_rec.cqb_attribute6;
457: End If;
458: If (p_rec.cqb_attribute7 = hr_api.g_varchar2) then

Line 458: If (p_rec.cqb_attribute7 = hr_api.g_varchar2) then

454: If (p_rec.cqb_attribute6 = hr_api.g_varchar2) then
455: p_rec.cqb_attribute6 :=
456: ben_cqb_shd.g_old_rec.cqb_attribute6;
457: End If;
458: If (p_rec.cqb_attribute7 = hr_api.g_varchar2) then
459: p_rec.cqb_attribute7 :=
460: ben_cqb_shd.g_old_rec.cqb_attribute7;
461: End If;
462: If (p_rec.cqb_attribute8 = hr_api.g_varchar2) then

Line 462: If (p_rec.cqb_attribute8 = hr_api.g_varchar2) then

458: If (p_rec.cqb_attribute7 = hr_api.g_varchar2) then
459: p_rec.cqb_attribute7 :=
460: ben_cqb_shd.g_old_rec.cqb_attribute7;
461: End If;
462: If (p_rec.cqb_attribute8 = hr_api.g_varchar2) then
463: p_rec.cqb_attribute8 :=
464: ben_cqb_shd.g_old_rec.cqb_attribute8;
465: End If;
466: If (p_rec.cqb_attribute9 = hr_api.g_varchar2) then

Line 466: If (p_rec.cqb_attribute9 = hr_api.g_varchar2) then

462: If (p_rec.cqb_attribute8 = hr_api.g_varchar2) then
463: p_rec.cqb_attribute8 :=
464: ben_cqb_shd.g_old_rec.cqb_attribute8;
465: End If;
466: If (p_rec.cqb_attribute9 = hr_api.g_varchar2) then
467: p_rec.cqb_attribute9 :=
468: ben_cqb_shd.g_old_rec.cqb_attribute9;
469: End If;
470: If (p_rec.cqb_attribute10 = hr_api.g_varchar2) then

Line 470: If (p_rec.cqb_attribute10 = hr_api.g_varchar2) then

466: If (p_rec.cqb_attribute9 = hr_api.g_varchar2) then
467: p_rec.cqb_attribute9 :=
468: ben_cqb_shd.g_old_rec.cqb_attribute9;
469: End If;
470: If (p_rec.cqb_attribute10 = hr_api.g_varchar2) then
471: p_rec.cqb_attribute10 :=
472: ben_cqb_shd.g_old_rec.cqb_attribute10;
473: End If;
474: If (p_rec.cqb_attribute11 = hr_api.g_varchar2) then

Line 474: If (p_rec.cqb_attribute11 = hr_api.g_varchar2) then

470: If (p_rec.cqb_attribute10 = hr_api.g_varchar2) then
471: p_rec.cqb_attribute10 :=
472: ben_cqb_shd.g_old_rec.cqb_attribute10;
473: End If;
474: If (p_rec.cqb_attribute11 = hr_api.g_varchar2) then
475: p_rec.cqb_attribute11 :=
476: ben_cqb_shd.g_old_rec.cqb_attribute11;
477: End If;
478: If (p_rec.cqb_attribute12 = hr_api.g_varchar2) then

Line 478: If (p_rec.cqb_attribute12 = hr_api.g_varchar2) then

474: If (p_rec.cqb_attribute11 = hr_api.g_varchar2) then
475: p_rec.cqb_attribute11 :=
476: ben_cqb_shd.g_old_rec.cqb_attribute11;
477: End If;
478: If (p_rec.cqb_attribute12 = hr_api.g_varchar2) then
479: p_rec.cqb_attribute12 :=
480: ben_cqb_shd.g_old_rec.cqb_attribute12;
481: End If;
482: If (p_rec.cqb_attribute13 = hr_api.g_varchar2) then

Line 482: If (p_rec.cqb_attribute13 = hr_api.g_varchar2) then

478: If (p_rec.cqb_attribute12 = hr_api.g_varchar2) then
479: p_rec.cqb_attribute12 :=
480: ben_cqb_shd.g_old_rec.cqb_attribute12;
481: End If;
482: If (p_rec.cqb_attribute13 = hr_api.g_varchar2) then
483: p_rec.cqb_attribute13 :=
484: ben_cqb_shd.g_old_rec.cqb_attribute13;
485: End If;
486: If (p_rec.cqb_attribute14 = hr_api.g_varchar2) then

Line 486: If (p_rec.cqb_attribute14 = hr_api.g_varchar2) then

482: If (p_rec.cqb_attribute13 = hr_api.g_varchar2) then
483: p_rec.cqb_attribute13 :=
484: ben_cqb_shd.g_old_rec.cqb_attribute13;
485: End If;
486: If (p_rec.cqb_attribute14 = hr_api.g_varchar2) then
487: p_rec.cqb_attribute14 :=
488: ben_cqb_shd.g_old_rec.cqb_attribute14;
489: End If;
490: If (p_rec.cqb_attribute15 = hr_api.g_varchar2) then

Line 490: If (p_rec.cqb_attribute15 = hr_api.g_varchar2) then

486: If (p_rec.cqb_attribute14 = hr_api.g_varchar2) then
487: p_rec.cqb_attribute14 :=
488: ben_cqb_shd.g_old_rec.cqb_attribute14;
489: End If;
490: If (p_rec.cqb_attribute15 = hr_api.g_varchar2) then
491: p_rec.cqb_attribute15 :=
492: ben_cqb_shd.g_old_rec.cqb_attribute15;
493: End If;
494: If (p_rec.cqb_attribute16 = hr_api.g_varchar2) then

Line 494: If (p_rec.cqb_attribute16 = hr_api.g_varchar2) then

490: If (p_rec.cqb_attribute15 = hr_api.g_varchar2) then
491: p_rec.cqb_attribute15 :=
492: ben_cqb_shd.g_old_rec.cqb_attribute15;
493: End If;
494: If (p_rec.cqb_attribute16 = hr_api.g_varchar2) then
495: p_rec.cqb_attribute16 :=
496: ben_cqb_shd.g_old_rec.cqb_attribute16;
497: End If;
498: If (p_rec.cqb_attribute17 = hr_api.g_varchar2) then

Line 498: If (p_rec.cqb_attribute17 = hr_api.g_varchar2) then

494: If (p_rec.cqb_attribute16 = hr_api.g_varchar2) then
495: p_rec.cqb_attribute16 :=
496: ben_cqb_shd.g_old_rec.cqb_attribute16;
497: End If;
498: If (p_rec.cqb_attribute17 = hr_api.g_varchar2) then
499: p_rec.cqb_attribute17 :=
500: ben_cqb_shd.g_old_rec.cqb_attribute17;
501: End If;
502: If (p_rec.cqb_attribute18 = hr_api.g_varchar2) then

Line 502: If (p_rec.cqb_attribute18 = hr_api.g_varchar2) then

498: If (p_rec.cqb_attribute17 = hr_api.g_varchar2) then
499: p_rec.cqb_attribute17 :=
500: ben_cqb_shd.g_old_rec.cqb_attribute17;
501: End If;
502: If (p_rec.cqb_attribute18 = hr_api.g_varchar2) then
503: p_rec.cqb_attribute18 :=
504: ben_cqb_shd.g_old_rec.cqb_attribute18;
505: End If;
506: If (p_rec.cqb_attribute19 = hr_api.g_varchar2) then

Line 506: If (p_rec.cqb_attribute19 = hr_api.g_varchar2) then

502: If (p_rec.cqb_attribute18 = hr_api.g_varchar2) then
503: p_rec.cqb_attribute18 :=
504: ben_cqb_shd.g_old_rec.cqb_attribute18;
505: End If;
506: If (p_rec.cqb_attribute19 = hr_api.g_varchar2) then
507: p_rec.cqb_attribute19 :=
508: ben_cqb_shd.g_old_rec.cqb_attribute19;
509: End If;
510: If (p_rec.cqb_attribute20 = hr_api.g_varchar2) then

Line 510: If (p_rec.cqb_attribute20 = hr_api.g_varchar2) then

506: If (p_rec.cqb_attribute19 = hr_api.g_varchar2) then
507: p_rec.cqb_attribute19 :=
508: ben_cqb_shd.g_old_rec.cqb_attribute19;
509: End If;
510: If (p_rec.cqb_attribute20 = hr_api.g_varchar2) then
511: p_rec.cqb_attribute20 :=
512: ben_cqb_shd.g_old_rec.cqb_attribute20;
513: End If;
514: If (p_rec.cqb_attribute21 = hr_api.g_varchar2) then

Line 514: If (p_rec.cqb_attribute21 = hr_api.g_varchar2) then

510: If (p_rec.cqb_attribute20 = hr_api.g_varchar2) then
511: p_rec.cqb_attribute20 :=
512: ben_cqb_shd.g_old_rec.cqb_attribute20;
513: End If;
514: If (p_rec.cqb_attribute21 = hr_api.g_varchar2) then
515: p_rec.cqb_attribute21 :=
516: ben_cqb_shd.g_old_rec.cqb_attribute21;
517: End If;
518: If (p_rec.cqb_attribute22 = hr_api.g_varchar2) then

Line 518: If (p_rec.cqb_attribute22 = hr_api.g_varchar2) then

514: If (p_rec.cqb_attribute21 = hr_api.g_varchar2) then
515: p_rec.cqb_attribute21 :=
516: ben_cqb_shd.g_old_rec.cqb_attribute21;
517: End If;
518: If (p_rec.cqb_attribute22 = hr_api.g_varchar2) then
519: p_rec.cqb_attribute22 :=
520: ben_cqb_shd.g_old_rec.cqb_attribute22;
521: End If;
522: If (p_rec.cqb_attribute23 = hr_api.g_varchar2) then

Line 522: If (p_rec.cqb_attribute23 = hr_api.g_varchar2) then

518: If (p_rec.cqb_attribute22 = hr_api.g_varchar2) then
519: p_rec.cqb_attribute22 :=
520: ben_cqb_shd.g_old_rec.cqb_attribute22;
521: End If;
522: If (p_rec.cqb_attribute23 = hr_api.g_varchar2) then
523: p_rec.cqb_attribute23 :=
524: ben_cqb_shd.g_old_rec.cqb_attribute23;
525: End If;
526: If (p_rec.cqb_attribute24 = hr_api.g_varchar2) then

Line 526: If (p_rec.cqb_attribute24 = hr_api.g_varchar2) then

522: If (p_rec.cqb_attribute23 = hr_api.g_varchar2) then
523: p_rec.cqb_attribute23 :=
524: ben_cqb_shd.g_old_rec.cqb_attribute23;
525: End If;
526: If (p_rec.cqb_attribute24 = hr_api.g_varchar2) then
527: p_rec.cqb_attribute24 :=
528: ben_cqb_shd.g_old_rec.cqb_attribute24;
529: End If;
530: If (p_rec.cqb_attribute25 = hr_api.g_varchar2) then

Line 530: If (p_rec.cqb_attribute25 = hr_api.g_varchar2) then

526: If (p_rec.cqb_attribute24 = hr_api.g_varchar2) then
527: p_rec.cqb_attribute24 :=
528: ben_cqb_shd.g_old_rec.cqb_attribute24;
529: End If;
530: If (p_rec.cqb_attribute25 = hr_api.g_varchar2) then
531: p_rec.cqb_attribute25 :=
532: ben_cqb_shd.g_old_rec.cqb_attribute25;
533: End If;
534: If (p_rec.cqb_attribute26 = hr_api.g_varchar2) then

Line 534: If (p_rec.cqb_attribute26 = hr_api.g_varchar2) then

530: If (p_rec.cqb_attribute25 = hr_api.g_varchar2) then
531: p_rec.cqb_attribute25 :=
532: ben_cqb_shd.g_old_rec.cqb_attribute25;
533: End If;
534: If (p_rec.cqb_attribute26 = hr_api.g_varchar2) then
535: p_rec.cqb_attribute26 :=
536: ben_cqb_shd.g_old_rec.cqb_attribute26;
537: End If;
538: If (p_rec.cqb_attribute27 = hr_api.g_varchar2) then

Line 538: If (p_rec.cqb_attribute27 = hr_api.g_varchar2) then

534: If (p_rec.cqb_attribute26 = hr_api.g_varchar2) then
535: p_rec.cqb_attribute26 :=
536: ben_cqb_shd.g_old_rec.cqb_attribute26;
537: End If;
538: If (p_rec.cqb_attribute27 = hr_api.g_varchar2) then
539: p_rec.cqb_attribute27 :=
540: ben_cqb_shd.g_old_rec.cqb_attribute27;
541: End If;
542: If (p_rec.cqb_attribute28 = hr_api.g_varchar2) then

Line 542: If (p_rec.cqb_attribute28 = hr_api.g_varchar2) then

538: If (p_rec.cqb_attribute27 = hr_api.g_varchar2) then
539: p_rec.cqb_attribute27 :=
540: ben_cqb_shd.g_old_rec.cqb_attribute27;
541: End If;
542: If (p_rec.cqb_attribute28 = hr_api.g_varchar2) then
543: p_rec.cqb_attribute28 :=
544: ben_cqb_shd.g_old_rec.cqb_attribute28;
545: End If;
546: If (p_rec.cqb_attribute29 = hr_api.g_varchar2) then

Line 546: If (p_rec.cqb_attribute29 = hr_api.g_varchar2) then

542: If (p_rec.cqb_attribute28 = hr_api.g_varchar2) then
543: p_rec.cqb_attribute28 :=
544: ben_cqb_shd.g_old_rec.cqb_attribute28;
545: End If;
546: If (p_rec.cqb_attribute29 = hr_api.g_varchar2) then
547: p_rec.cqb_attribute29 :=
548: ben_cqb_shd.g_old_rec.cqb_attribute29;
549: End If;
550: If (p_rec.cqb_attribute30 = hr_api.g_varchar2) then

Line 550: If (p_rec.cqb_attribute30 = hr_api.g_varchar2) then

546: If (p_rec.cqb_attribute29 = hr_api.g_varchar2) then
547: p_rec.cqb_attribute29 :=
548: ben_cqb_shd.g_old_rec.cqb_attribute29;
549: End If;
550: If (p_rec.cqb_attribute30 = hr_api.g_varchar2) then
551: p_rec.cqb_attribute30 :=
552: ben_cqb_shd.g_old_rec.cqb_attribute30;
553: End If;
554:

Line 613: p_quald_bnf_flag in varchar2 default hr_api.g_varchar2,

609: Procedure upd
610: (
611: p_effective_date in date,
612: p_cbr_quald_bnf_id in number,
613: p_quald_bnf_flag in varchar2 default hr_api.g_varchar2,
614: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
615: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
616: p_quald_bnf_person_id in number default hr_api.g_number,
617: p_pgm_id in number default hr_api.g_number,

Line 614: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,

610: (
611: p_effective_date in date,
612: p_cbr_quald_bnf_id in number,
613: p_quald_bnf_flag in varchar2 default hr_api.g_varchar2,
614: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
615: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
616: p_quald_bnf_person_id in number default hr_api.g_number,
617: p_pgm_id in number default hr_api.g_number,
618: p_ptip_id in number default hr_api.g_number,

Line 615: p_cbr_elig_perd_end_dt in date default hr_api.g_date,

611: p_effective_date in date,
612: p_cbr_quald_bnf_id in number,
613: p_quald_bnf_flag in varchar2 default hr_api.g_varchar2,
614: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
615: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
616: p_quald_bnf_person_id in number default hr_api.g_number,
617: p_pgm_id in number default hr_api.g_number,
618: p_ptip_id in number default hr_api.g_number,
619: p_pl_typ_id in number default hr_api.g_number,

Line 616: p_quald_bnf_person_id in number default hr_api.g_number,

612: p_cbr_quald_bnf_id in number,
613: p_quald_bnf_flag in varchar2 default hr_api.g_varchar2,
614: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
615: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
616: p_quald_bnf_person_id in number default hr_api.g_number,
617: p_pgm_id in number default hr_api.g_number,
618: p_ptip_id in number default hr_api.g_number,
619: p_pl_typ_id in number default hr_api.g_number,
620: p_cvrd_emp_person_id in number default hr_api.g_number,

Line 617: p_pgm_id in number default hr_api.g_number,

613: p_quald_bnf_flag in varchar2 default hr_api.g_varchar2,
614: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
615: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
616: p_quald_bnf_person_id in number default hr_api.g_number,
617: p_pgm_id in number default hr_api.g_number,
618: p_ptip_id in number default hr_api.g_number,
619: p_pl_typ_id in number default hr_api.g_number,
620: p_cvrd_emp_person_id in number default hr_api.g_number,
621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,

Line 618: p_ptip_id in number default hr_api.g_number,

614: p_cbr_elig_perd_strt_dt in date default hr_api.g_date,
615: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
616: p_quald_bnf_person_id in number default hr_api.g_number,
617: p_pgm_id in number default hr_api.g_number,
618: p_ptip_id in number default hr_api.g_number,
619: p_pl_typ_id in number default hr_api.g_number,
620: p_cvrd_emp_person_id in number default hr_api.g_number,
621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
622: p_business_group_id in number default hr_api.g_number,

Line 619: p_pl_typ_id in number default hr_api.g_number,

615: p_cbr_elig_perd_end_dt in date default hr_api.g_date,
616: p_quald_bnf_person_id in number default hr_api.g_number,
617: p_pgm_id in number default hr_api.g_number,
618: p_ptip_id in number default hr_api.g_number,
619: p_pl_typ_id in number default hr_api.g_number,
620: p_cvrd_emp_person_id in number default hr_api.g_number,
621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
622: p_business_group_id in number default hr_api.g_number,
623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,

Line 620: p_cvrd_emp_person_id in number default hr_api.g_number,

616: p_quald_bnf_person_id in number default hr_api.g_number,
617: p_pgm_id in number default hr_api.g_number,
618: p_ptip_id in number default hr_api.g_number,
619: p_pl_typ_id in number default hr_api.g_number,
620: p_cvrd_emp_person_id in number default hr_api.g_number,
621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
622: p_business_group_id in number default hr_api.g_number,
623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,
624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,

Line 621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,

617: p_pgm_id in number default hr_api.g_number,
618: p_ptip_id in number default hr_api.g_number,
619: p_pl_typ_id in number default hr_api.g_number,
620: p_cvrd_emp_person_id in number default hr_api.g_number,
621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
622: p_business_group_id in number default hr_api.g_number,
623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,
624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,
625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,

Line 622: p_business_group_id in number default hr_api.g_number,

618: p_ptip_id in number default hr_api.g_number,
619: p_pl_typ_id in number default hr_api.g_number,
620: p_cvrd_emp_person_id in number default hr_api.g_number,
621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
622: p_business_group_id in number default hr_api.g_number,
623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,
624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,
625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,
626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,

Line 623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,

619: p_pl_typ_id in number default hr_api.g_number,
620: p_cvrd_emp_person_id in number default hr_api.g_number,
621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
622: p_business_group_id in number default hr_api.g_number,
623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,
624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,
625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,
626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,
627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,

Line 624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,

620: p_cvrd_emp_person_id in number default hr_api.g_number,
621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
622: p_business_group_id in number default hr_api.g_number,
623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,
624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,
625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,
626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,
627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,
628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,

Line 625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,

621: p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
622: p_business_group_id in number default hr_api.g_number,
623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,
624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,
625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,
626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,
627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,
628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,
629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,

Line 626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,

622: p_business_group_id in number default hr_api.g_number,
623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,
624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,
625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,
626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,
627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,
628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,
629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,
630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,

Line 627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,

623: p_cqb_attribute_category in varchar2 default hr_api.g_varchar2,
624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,
625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,
626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,
627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,
628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,
629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,
630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,
631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,

Line 628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,

624: p_cqb_attribute1 in varchar2 default hr_api.g_varchar2,
625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,
626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,
627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,
628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,
629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,
630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,
631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,
632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,

Line 629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,

625: p_cqb_attribute2 in varchar2 default hr_api.g_varchar2,
626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,
627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,
628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,
629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,
630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,
631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,
632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,
633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,

Line 630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,

626: p_cqb_attribute3 in varchar2 default hr_api.g_varchar2,
627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,
628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,
629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,
630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,
631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,
632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,
633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,
634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,

Line 631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,

627: p_cqb_attribute4 in varchar2 default hr_api.g_varchar2,
628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,
629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,
630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,
631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,
632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,
633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,
634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,
635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,

Line 632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,

628: p_cqb_attribute5 in varchar2 default hr_api.g_varchar2,
629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,
630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,
631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,
632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,
633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,
634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,
635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,
636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,

Line 633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,

629: p_cqb_attribute6 in varchar2 default hr_api.g_varchar2,
630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,
631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,
632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,
633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,
634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,
635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,
636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,
637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,

Line 634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,

630: p_cqb_attribute7 in varchar2 default hr_api.g_varchar2,
631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,
632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,
633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,
634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,
635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,
636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,
637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,
638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,

Line 635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,

631: p_cqb_attribute8 in varchar2 default hr_api.g_varchar2,
632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,
633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,
634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,
635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,
636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,
637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,
638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,
639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,

Line 636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,

632: p_cqb_attribute9 in varchar2 default hr_api.g_varchar2,
633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,
634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,
635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,
636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,
637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,
638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,
639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,
640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,

Line 637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,

633: p_cqb_attribute10 in varchar2 default hr_api.g_varchar2,
634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,
635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,
636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,
637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,
638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,
639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,
640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,
641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,

Line 638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,

634: p_cqb_attribute11 in varchar2 default hr_api.g_varchar2,
635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,
636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,
637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,
638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,
639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,
640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,
641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,
642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,

Line 639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,

635: p_cqb_attribute12 in varchar2 default hr_api.g_varchar2,
636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,
637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,
638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,
639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,
640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,
641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,
642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,
643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,

Line 640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,

636: p_cqb_attribute13 in varchar2 default hr_api.g_varchar2,
637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,
638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,
639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,
640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,
641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,
642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,
643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,
644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,

Line 641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,

637: p_cqb_attribute14 in varchar2 default hr_api.g_varchar2,
638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,
639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,
640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,
641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,
642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,
643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,
644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,
645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,

Line 642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,

638: p_cqb_attribute15 in varchar2 default hr_api.g_varchar2,
639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,
640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,
641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,
642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,
643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,
644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,
645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,
646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,

Line 643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,

639: p_cqb_attribute16 in varchar2 default hr_api.g_varchar2,
640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,
641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,
642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,
643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,
644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,
645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,
646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,
647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,

Line 644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,

640: p_cqb_attribute17 in varchar2 default hr_api.g_varchar2,
641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,
642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,
643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,
644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,
645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,
646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,
647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,
648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,

Line 645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,

641: p_cqb_attribute18 in varchar2 default hr_api.g_varchar2,
642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,
643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,
644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,
645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,
646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,
647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,
648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,
649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,

Line 646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,

642: p_cqb_attribute19 in varchar2 default hr_api.g_varchar2,
643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,
644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,
645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,
646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,
647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,
648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,
649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,
650: p_cqb_attribute27 in varchar2 default hr_api.g_varchar2,

Line 647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,

643: p_cqb_attribute20 in varchar2 default hr_api.g_varchar2,
644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,
645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,
646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,
647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,
648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,
649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,
650: p_cqb_attribute27 in varchar2 default hr_api.g_varchar2,
651: p_cqb_attribute28 in varchar2 default hr_api.g_varchar2,

Line 648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,

644: p_cqb_attribute21 in varchar2 default hr_api.g_varchar2,
645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,
646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,
647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,
648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,
649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,
650: p_cqb_attribute27 in varchar2 default hr_api.g_varchar2,
651: p_cqb_attribute28 in varchar2 default hr_api.g_varchar2,
652: p_cqb_attribute29 in varchar2 default hr_api.g_varchar2,

Line 649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,

645: p_cqb_attribute22 in varchar2 default hr_api.g_varchar2,
646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,
647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,
648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,
649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,
650: p_cqb_attribute27 in varchar2 default hr_api.g_varchar2,
651: p_cqb_attribute28 in varchar2 default hr_api.g_varchar2,
652: p_cqb_attribute29 in varchar2 default hr_api.g_varchar2,
653: p_cqb_attribute30 in varchar2 default hr_api.g_varchar2,

Line 650: p_cqb_attribute27 in varchar2 default hr_api.g_varchar2,

646: p_cqb_attribute23 in varchar2 default hr_api.g_varchar2,
647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,
648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,
649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,
650: p_cqb_attribute27 in varchar2 default hr_api.g_varchar2,
651: p_cqb_attribute28 in varchar2 default hr_api.g_varchar2,
652: p_cqb_attribute29 in varchar2 default hr_api.g_varchar2,
653: p_cqb_attribute30 in varchar2 default hr_api.g_varchar2,
654: p_object_version_number in out nocopy number

Line 651: p_cqb_attribute28 in varchar2 default hr_api.g_varchar2,

647: p_cqb_attribute24 in varchar2 default hr_api.g_varchar2,
648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,
649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,
650: p_cqb_attribute27 in varchar2 default hr_api.g_varchar2,
651: p_cqb_attribute28 in varchar2 default hr_api.g_varchar2,
652: p_cqb_attribute29 in varchar2 default hr_api.g_varchar2,
653: p_cqb_attribute30 in varchar2 default hr_api.g_varchar2,
654: p_object_version_number in out nocopy number
655: ) is

Line 652: p_cqb_attribute29 in varchar2 default hr_api.g_varchar2,

648: p_cqb_attribute25 in varchar2 default hr_api.g_varchar2,
649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,
650: p_cqb_attribute27 in varchar2 default hr_api.g_varchar2,
651: p_cqb_attribute28 in varchar2 default hr_api.g_varchar2,
652: p_cqb_attribute29 in varchar2 default hr_api.g_varchar2,
653: p_cqb_attribute30 in varchar2 default hr_api.g_varchar2,
654: p_object_version_number in out nocopy number
655: ) is
656: --

Line 653: p_cqb_attribute30 in varchar2 default hr_api.g_varchar2,

649: p_cqb_attribute26 in varchar2 default hr_api.g_varchar2,
650: p_cqb_attribute27 in varchar2 default hr_api.g_varchar2,
651: p_cqb_attribute28 in varchar2 default hr_api.g_varchar2,
652: p_cqb_attribute29 in varchar2 default hr_api.g_varchar2,
653: p_cqb_attribute30 in varchar2 default hr_api.g_varchar2,
654: p_object_version_number in out nocopy number
655: ) is
656: --
657: l_rec ben_cqb_shd.g_rec_type;