APPS.BEN_CWG_UPD dependencies on HR_API

Line 117: When hr_api.check_integrity_violated Then

113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ben_cwg_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ben_cwg_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ben_cwg_shd.constraint_error

Line 122: When hr_api.parent_integrity_violated Then

118: -- A check constraint has been violated
119: --
120: ben_cwg_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ben_cwg_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ben_cwg_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ben_cwg_shd.constraint_error

Line 127: When hr_api.unique_integrity_violated Then

123: -- Parent integrity has been violated
124: --
125: ben_cwg_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ben_cwg_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ben_cwg_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;
135: End update_dml;

Line 377: when hr_api.cannot_find_prog_unit then

373: );
374: --
375: exception
376: --
377: when hr_api.cannot_find_prog_unit then
378: --
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'BEN_CWB_WKSHT_GRP'
381: ,p_hook_type => 'AU');

Line 379: hr_api.cannot_find_prog_unit_error

375: exception
376: --
377: when hr_api.cannot_find_prog_unit then
378: --
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'BEN_CWB_WKSHT_GRP'
381: ,p_hook_type => 'AU');
382: --
383: end;

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

438: -- p_rec plsql record structure
439: -- to see if a system default is being used. If a system default
440: -- is being used then we must set to the 'current' argument value.
441: --
442: If (p_rec.business_group_id = hr_api.g_number) then
443: p_rec.business_group_id :=
444: ben_cwg_shd.g_old_rec.business_group_id;
445: End If;
446: If (p_rec.pl_id = hr_api.g_number) then

Line 446: If (p_rec.pl_id = hr_api.g_number) then

442: If (p_rec.business_group_id = hr_api.g_number) then
443: p_rec.business_group_id :=
444: ben_cwg_shd.g_old_rec.business_group_id;
445: End If;
446: If (p_rec.pl_id = hr_api.g_number) then
447: p_rec.pl_id :=
448: ben_cwg_shd.g_old_rec.pl_id;
449: End If;
450: If (p_rec.ordr_num = hr_api.g_number) then

Line 450: If (p_rec.ordr_num = hr_api.g_number) then

446: If (p_rec.pl_id = hr_api.g_number) then
447: p_rec.pl_id :=
448: ben_cwg_shd.g_old_rec.pl_id;
449: End If;
450: If (p_rec.ordr_num = hr_api.g_number) then
451: p_rec.ordr_num :=
452: ben_cwg_shd.g_old_rec.ordr_num;
453: End If;
454: If (p_rec.wksht_grp_cd = hr_api.g_varchar2) then

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

450: If (p_rec.ordr_num = hr_api.g_number) then
451: p_rec.ordr_num :=
452: ben_cwg_shd.g_old_rec.ordr_num;
453: End If;
454: If (p_rec.wksht_grp_cd = hr_api.g_varchar2) then
455: p_rec.wksht_grp_cd :=
456: ben_cwg_shd.g_old_rec.wksht_grp_cd;
457: End If;
458: If (p_rec.label = hr_api.g_varchar2) then

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

454: If (p_rec.wksht_grp_cd = hr_api.g_varchar2) then
455: p_rec.wksht_grp_cd :=
456: ben_cwg_shd.g_old_rec.wksht_grp_cd;
457: End If;
458: If (p_rec.label = hr_api.g_varchar2) then
459: p_rec.label :=
460: ben_cwg_shd.g_old_rec.label;
461: End If;
462: If (p_rec.cwg_attribute_category = hr_api.g_varchar2) then

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

458: If (p_rec.label = hr_api.g_varchar2) then
459: p_rec.label :=
460: ben_cwg_shd.g_old_rec.label;
461: End If;
462: If (p_rec.cwg_attribute_category = hr_api.g_varchar2) then
463: p_rec.cwg_attribute_category :=
464: ben_cwg_shd.g_old_rec.cwg_attribute_category;
465: End If;
466: If (p_rec.cwg_attribute1 = hr_api.g_varchar2) then

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

462: If (p_rec.cwg_attribute_category = hr_api.g_varchar2) then
463: p_rec.cwg_attribute_category :=
464: ben_cwg_shd.g_old_rec.cwg_attribute_category;
465: End If;
466: If (p_rec.cwg_attribute1 = hr_api.g_varchar2) then
467: p_rec.cwg_attribute1 :=
468: ben_cwg_shd.g_old_rec.cwg_attribute1;
469: End If;
470: If (p_rec.cwg_attribute2 = hr_api.g_varchar2) then

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

466: If (p_rec.cwg_attribute1 = hr_api.g_varchar2) then
467: p_rec.cwg_attribute1 :=
468: ben_cwg_shd.g_old_rec.cwg_attribute1;
469: End If;
470: If (p_rec.cwg_attribute2 = hr_api.g_varchar2) then
471: p_rec.cwg_attribute2 :=
472: ben_cwg_shd.g_old_rec.cwg_attribute2;
473: End If;
474: If (p_rec.cwg_attribute3 = hr_api.g_varchar2) then

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

470: If (p_rec.cwg_attribute2 = hr_api.g_varchar2) then
471: p_rec.cwg_attribute2 :=
472: ben_cwg_shd.g_old_rec.cwg_attribute2;
473: End If;
474: If (p_rec.cwg_attribute3 = hr_api.g_varchar2) then
475: p_rec.cwg_attribute3 :=
476: ben_cwg_shd.g_old_rec.cwg_attribute3;
477: End If;
478: If (p_rec.cwg_attribute4 = hr_api.g_varchar2) then

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

474: If (p_rec.cwg_attribute3 = hr_api.g_varchar2) then
475: p_rec.cwg_attribute3 :=
476: ben_cwg_shd.g_old_rec.cwg_attribute3;
477: End If;
478: If (p_rec.cwg_attribute4 = hr_api.g_varchar2) then
479: p_rec.cwg_attribute4 :=
480: ben_cwg_shd.g_old_rec.cwg_attribute4;
481: End If;
482: If (p_rec.cwg_attribute5 = hr_api.g_varchar2) then

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

478: If (p_rec.cwg_attribute4 = hr_api.g_varchar2) then
479: p_rec.cwg_attribute4 :=
480: ben_cwg_shd.g_old_rec.cwg_attribute4;
481: End If;
482: If (p_rec.cwg_attribute5 = hr_api.g_varchar2) then
483: p_rec.cwg_attribute5 :=
484: ben_cwg_shd.g_old_rec.cwg_attribute5;
485: End If;
486: If (p_rec.cwg_attribute6 = hr_api.g_varchar2) then

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

482: If (p_rec.cwg_attribute5 = hr_api.g_varchar2) then
483: p_rec.cwg_attribute5 :=
484: ben_cwg_shd.g_old_rec.cwg_attribute5;
485: End If;
486: If (p_rec.cwg_attribute6 = hr_api.g_varchar2) then
487: p_rec.cwg_attribute6 :=
488: ben_cwg_shd.g_old_rec.cwg_attribute6;
489: End If;
490: If (p_rec.cwg_attribute7 = hr_api.g_varchar2) then

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

486: If (p_rec.cwg_attribute6 = hr_api.g_varchar2) then
487: p_rec.cwg_attribute6 :=
488: ben_cwg_shd.g_old_rec.cwg_attribute6;
489: End If;
490: If (p_rec.cwg_attribute7 = hr_api.g_varchar2) then
491: p_rec.cwg_attribute7 :=
492: ben_cwg_shd.g_old_rec.cwg_attribute7;
493: End If;
494: If (p_rec.cwg_attribute8 = hr_api.g_varchar2) then

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

490: If (p_rec.cwg_attribute7 = hr_api.g_varchar2) then
491: p_rec.cwg_attribute7 :=
492: ben_cwg_shd.g_old_rec.cwg_attribute7;
493: End If;
494: If (p_rec.cwg_attribute8 = hr_api.g_varchar2) then
495: p_rec.cwg_attribute8 :=
496: ben_cwg_shd.g_old_rec.cwg_attribute8;
497: End If;
498: If (p_rec.cwg_attribute9 = hr_api.g_varchar2) then

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

494: If (p_rec.cwg_attribute8 = hr_api.g_varchar2) then
495: p_rec.cwg_attribute8 :=
496: ben_cwg_shd.g_old_rec.cwg_attribute8;
497: End If;
498: If (p_rec.cwg_attribute9 = hr_api.g_varchar2) then
499: p_rec.cwg_attribute9 :=
500: ben_cwg_shd.g_old_rec.cwg_attribute9;
501: End If;
502: If (p_rec.cwg_attribute10 = hr_api.g_varchar2) then

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

498: If (p_rec.cwg_attribute9 = hr_api.g_varchar2) then
499: p_rec.cwg_attribute9 :=
500: ben_cwg_shd.g_old_rec.cwg_attribute9;
501: End If;
502: If (p_rec.cwg_attribute10 = hr_api.g_varchar2) then
503: p_rec.cwg_attribute10 :=
504: ben_cwg_shd.g_old_rec.cwg_attribute10;
505: End If;
506: If (p_rec.cwg_attribute11 = hr_api.g_varchar2) then

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

502: If (p_rec.cwg_attribute10 = hr_api.g_varchar2) then
503: p_rec.cwg_attribute10 :=
504: ben_cwg_shd.g_old_rec.cwg_attribute10;
505: End If;
506: If (p_rec.cwg_attribute11 = hr_api.g_varchar2) then
507: p_rec.cwg_attribute11 :=
508: ben_cwg_shd.g_old_rec.cwg_attribute11;
509: End If;
510: If (p_rec.cwg_attribute12 = hr_api.g_varchar2) then

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

506: If (p_rec.cwg_attribute11 = hr_api.g_varchar2) then
507: p_rec.cwg_attribute11 :=
508: ben_cwg_shd.g_old_rec.cwg_attribute11;
509: End If;
510: If (p_rec.cwg_attribute12 = hr_api.g_varchar2) then
511: p_rec.cwg_attribute12 :=
512: ben_cwg_shd.g_old_rec.cwg_attribute12;
513: End If;
514: If (p_rec.cwg_attribute13 = hr_api.g_varchar2) then

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

510: If (p_rec.cwg_attribute12 = hr_api.g_varchar2) then
511: p_rec.cwg_attribute12 :=
512: ben_cwg_shd.g_old_rec.cwg_attribute12;
513: End If;
514: If (p_rec.cwg_attribute13 = hr_api.g_varchar2) then
515: p_rec.cwg_attribute13 :=
516: ben_cwg_shd.g_old_rec.cwg_attribute13;
517: End If;
518: If (p_rec.cwg_attribute14 = hr_api.g_varchar2) then

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

514: If (p_rec.cwg_attribute13 = hr_api.g_varchar2) then
515: p_rec.cwg_attribute13 :=
516: ben_cwg_shd.g_old_rec.cwg_attribute13;
517: End If;
518: If (p_rec.cwg_attribute14 = hr_api.g_varchar2) then
519: p_rec.cwg_attribute14 :=
520: ben_cwg_shd.g_old_rec.cwg_attribute14;
521: End If;
522: If (p_rec.cwg_attribute15 = hr_api.g_varchar2) then

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

518: If (p_rec.cwg_attribute14 = hr_api.g_varchar2) then
519: p_rec.cwg_attribute14 :=
520: ben_cwg_shd.g_old_rec.cwg_attribute14;
521: End If;
522: If (p_rec.cwg_attribute15 = hr_api.g_varchar2) then
523: p_rec.cwg_attribute15 :=
524: ben_cwg_shd.g_old_rec.cwg_attribute15;
525: End If;
526: If (p_rec.cwg_attribute16 = hr_api.g_varchar2) then

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

522: If (p_rec.cwg_attribute15 = hr_api.g_varchar2) then
523: p_rec.cwg_attribute15 :=
524: ben_cwg_shd.g_old_rec.cwg_attribute15;
525: End If;
526: If (p_rec.cwg_attribute16 = hr_api.g_varchar2) then
527: p_rec.cwg_attribute16 :=
528: ben_cwg_shd.g_old_rec.cwg_attribute16;
529: End If;
530: If (p_rec.cwg_attribute17 = hr_api.g_varchar2) then

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

526: If (p_rec.cwg_attribute16 = hr_api.g_varchar2) then
527: p_rec.cwg_attribute16 :=
528: ben_cwg_shd.g_old_rec.cwg_attribute16;
529: End If;
530: If (p_rec.cwg_attribute17 = hr_api.g_varchar2) then
531: p_rec.cwg_attribute17 :=
532: ben_cwg_shd.g_old_rec.cwg_attribute17;
533: End If;
534: If (p_rec.cwg_attribute18 = hr_api.g_varchar2) then

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

530: If (p_rec.cwg_attribute17 = hr_api.g_varchar2) then
531: p_rec.cwg_attribute17 :=
532: ben_cwg_shd.g_old_rec.cwg_attribute17;
533: End If;
534: If (p_rec.cwg_attribute18 = hr_api.g_varchar2) then
535: p_rec.cwg_attribute18 :=
536: ben_cwg_shd.g_old_rec.cwg_attribute18;
537: End If;
538: If (p_rec.cwg_attribute19 = hr_api.g_varchar2) then

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

534: If (p_rec.cwg_attribute18 = hr_api.g_varchar2) then
535: p_rec.cwg_attribute18 :=
536: ben_cwg_shd.g_old_rec.cwg_attribute18;
537: End If;
538: If (p_rec.cwg_attribute19 = hr_api.g_varchar2) then
539: p_rec.cwg_attribute19 :=
540: ben_cwg_shd.g_old_rec.cwg_attribute19;
541: End If;
542: If (p_rec.cwg_attribute20 = hr_api.g_varchar2) then

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

538: If (p_rec.cwg_attribute19 = hr_api.g_varchar2) then
539: p_rec.cwg_attribute19 :=
540: ben_cwg_shd.g_old_rec.cwg_attribute19;
541: End If;
542: If (p_rec.cwg_attribute20 = hr_api.g_varchar2) then
543: p_rec.cwg_attribute20 :=
544: ben_cwg_shd.g_old_rec.cwg_attribute20;
545: End If;
546: If (p_rec.cwg_attribute21 = hr_api.g_varchar2) then

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

542: If (p_rec.cwg_attribute20 = hr_api.g_varchar2) then
543: p_rec.cwg_attribute20 :=
544: ben_cwg_shd.g_old_rec.cwg_attribute20;
545: End If;
546: If (p_rec.cwg_attribute21 = hr_api.g_varchar2) then
547: p_rec.cwg_attribute21 :=
548: ben_cwg_shd.g_old_rec.cwg_attribute21;
549: End If;
550: If (p_rec.cwg_attribute22 = hr_api.g_varchar2) then

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

546: If (p_rec.cwg_attribute21 = hr_api.g_varchar2) then
547: p_rec.cwg_attribute21 :=
548: ben_cwg_shd.g_old_rec.cwg_attribute21;
549: End If;
550: If (p_rec.cwg_attribute22 = hr_api.g_varchar2) then
551: p_rec.cwg_attribute22 :=
552: ben_cwg_shd.g_old_rec.cwg_attribute22;
553: End If;
554: If (p_rec.cwg_attribute23 = hr_api.g_varchar2) then

Line 554: If (p_rec.cwg_attribute23 = hr_api.g_varchar2) then

550: If (p_rec.cwg_attribute22 = hr_api.g_varchar2) then
551: p_rec.cwg_attribute22 :=
552: ben_cwg_shd.g_old_rec.cwg_attribute22;
553: End If;
554: If (p_rec.cwg_attribute23 = hr_api.g_varchar2) then
555: p_rec.cwg_attribute23 :=
556: ben_cwg_shd.g_old_rec.cwg_attribute23;
557: End If;
558: If (p_rec.cwg_attribute24 = hr_api.g_varchar2) then

Line 558: If (p_rec.cwg_attribute24 = hr_api.g_varchar2) then

554: If (p_rec.cwg_attribute23 = hr_api.g_varchar2) then
555: p_rec.cwg_attribute23 :=
556: ben_cwg_shd.g_old_rec.cwg_attribute23;
557: End If;
558: If (p_rec.cwg_attribute24 = hr_api.g_varchar2) then
559: p_rec.cwg_attribute24 :=
560: ben_cwg_shd.g_old_rec.cwg_attribute24;
561: End If;
562: If (p_rec.cwg_attribute25 = hr_api.g_varchar2) then

Line 562: If (p_rec.cwg_attribute25 = hr_api.g_varchar2) then

558: If (p_rec.cwg_attribute24 = hr_api.g_varchar2) then
559: p_rec.cwg_attribute24 :=
560: ben_cwg_shd.g_old_rec.cwg_attribute24;
561: End If;
562: If (p_rec.cwg_attribute25 = hr_api.g_varchar2) then
563: p_rec.cwg_attribute25 :=
564: ben_cwg_shd.g_old_rec.cwg_attribute25;
565: End If;
566: If (p_rec.cwg_attribute26 = hr_api.g_varchar2) then

Line 566: If (p_rec.cwg_attribute26 = hr_api.g_varchar2) then

562: If (p_rec.cwg_attribute25 = hr_api.g_varchar2) then
563: p_rec.cwg_attribute25 :=
564: ben_cwg_shd.g_old_rec.cwg_attribute25;
565: End If;
566: If (p_rec.cwg_attribute26 = hr_api.g_varchar2) then
567: p_rec.cwg_attribute26 :=
568: ben_cwg_shd.g_old_rec.cwg_attribute26;
569: End If;
570: If (p_rec.cwg_attribute27 = hr_api.g_varchar2) then

Line 570: If (p_rec.cwg_attribute27 = hr_api.g_varchar2) then

566: If (p_rec.cwg_attribute26 = hr_api.g_varchar2) then
567: p_rec.cwg_attribute26 :=
568: ben_cwg_shd.g_old_rec.cwg_attribute26;
569: End If;
570: If (p_rec.cwg_attribute27 = hr_api.g_varchar2) then
571: p_rec.cwg_attribute27 :=
572: ben_cwg_shd.g_old_rec.cwg_attribute27;
573: End If;
574: If (p_rec.cwg_attribute28 = hr_api.g_varchar2) then

Line 574: If (p_rec.cwg_attribute28 = hr_api.g_varchar2) then

570: If (p_rec.cwg_attribute27 = hr_api.g_varchar2) then
571: p_rec.cwg_attribute27 :=
572: ben_cwg_shd.g_old_rec.cwg_attribute27;
573: End If;
574: If (p_rec.cwg_attribute28 = hr_api.g_varchar2) then
575: p_rec.cwg_attribute28 :=
576: ben_cwg_shd.g_old_rec.cwg_attribute28;
577: End If;
578: If (p_rec.cwg_attribute29 = hr_api.g_varchar2) then

Line 578: If (p_rec.cwg_attribute29 = hr_api.g_varchar2) then

574: If (p_rec.cwg_attribute28 = hr_api.g_varchar2) then
575: p_rec.cwg_attribute28 :=
576: ben_cwg_shd.g_old_rec.cwg_attribute28;
577: End If;
578: If (p_rec.cwg_attribute29 = hr_api.g_varchar2) then
579: p_rec.cwg_attribute29 :=
580: ben_cwg_shd.g_old_rec.cwg_attribute29;
581: End If;
582: If (p_rec.cwg_attribute30 = hr_api.g_varchar2) then

Line 582: If (p_rec.cwg_attribute30 = hr_api.g_varchar2) then

578: If (p_rec.cwg_attribute29 = hr_api.g_varchar2) then
579: p_rec.cwg_attribute29 :=
580: ben_cwg_shd.g_old_rec.cwg_attribute29;
581: End If;
582: If (p_rec.cwg_attribute30 = hr_api.g_varchar2) then
583: p_rec.cwg_attribute30 :=
584: ben_cwg_shd.g_old_rec.cwg_attribute30;
585: End If;
586:

Line 588: If (p_rec.status_cd = hr_api.g_varchar2) then

584: ben_cwg_shd.g_old_rec.cwg_attribute30;
585: End If;
586:
587: --
588: If (p_rec.status_cd = hr_api.g_varchar2) then
589: p_rec.status_cd := ben_cwg_shd.g_old_rec.status_cd;
590: End If;
591:
592: If (p_rec.hidden_cd = hr_api.g_varchar2) then

Line 592: If (p_rec.hidden_cd = hr_api.g_varchar2) then

588: If (p_rec.status_cd = hr_api.g_varchar2) then
589: p_rec.status_cd := ben_cwg_shd.g_old_rec.status_cd;
590: End If;
591:
592: If (p_rec.hidden_cd = hr_api.g_varchar2) then
593: p_rec.hidden_cd := ben_cwg_shd.g_old_rec.hidden_cd;
594: End If;
595:
596: End convert_defs;

Line 659: ,p_ordr_num in number default hr_api.g_number

655: Procedure upd
656: (p_effective_date in date
657: ,p_cwb_wksht_grp_id in number
658: ,p_object_version_number in out nocopy number
659: ,p_ordr_num in number default hr_api.g_number
660: ,p_wksht_grp_cd in varchar2 default hr_api.g_varchar2
661: ,p_label in varchar2 default hr_api.g_varchar2
662: ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2

Line 660: ,p_wksht_grp_cd in varchar2 default hr_api.g_varchar2

656: (p_effective_date in date
657: ,p_cwb_wksht_grp_id in number
658: ,p_object_version_number in out nocopy number
659: ,p_ordr_num in number default hr_api.g_number
660: ,p_wksht_grp_cd in varchar2 default hr_api.g_varchar2
661: ,p_label in varchar2 default hr_api.g_varchar2
662: ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2

Line 661: ,p_label in varchar2 default hr_api.g_varchar2

657: ,p_cwb_wksht_grp_id in number
658: ,p_object_version_number in out nocopy number
659: ,p_ordr_num in number default hr_api.g_number
660: ,p_wksht_grp_cd in varchar2 default hr_api.g_varchar2
661: ,p_label in varchar2 default hr_api.g_varchar2
662: ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2

Line 662: ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2

658: ,p_object_version_number in out nocopy number
659: ,p_ordr_num in number default hr_api.g_number
660: ,p_wksht_grp_cd in varchar2 default hr_api.g_varchar2
661: ,p_label in varchar2 default hr_api.g_varchar2
662: ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2

Line 663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2

659: ,p_ordr_num in number default hr_api.g_number
660: ,p_wksht_grp_cd in varchar2 default hr_api.g_varchar2
661: ,p_label in varchar2 default hr_api.g_varchar2
662: ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2

Line 664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2

660: ,p_wksht_grp_cd in varchar2 default hr_api.g_varchar2
661: ,p_label in varchar2 default hr_api.g_varchar2
662: ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2

Line 665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2

661: ,p_label in varchar2 default hr_api.g_varchar2
662: ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2

Line 666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2

662: ,p_cwg_attribute_category in varchar2 default hr_api.g_varchar2
663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2

Line 667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2

663: ,p_cwg_attribute1 in varchar2 default hr_api.g_varchar2
664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2

Line 668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2

664: ,p_cwg_attribute2 in varchar2 default hr_api.g_varchar2
665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2

Line 669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2

665: ,p_cwg_attribute3 in varchar2 default hr_api.g_varchar2
666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2

Line 670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2

666: ,p_cwg_attribute4 in varchar2 default hr_api.g_varchar2
667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2

Line 671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2

667: ,p_cwg_attribute5 in varchar2 default hr_api.g_varchar2
668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2

Line 672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2

668: ,p_cwg_attribute6 in varchar2 default hr_api.g_varchar2
669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2

Line 673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2

669: ,p_cwg_attribute7 in varchar2 default hr_api.g_varchar2
670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2

Line 674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2

670: ,p_cwg_attribute8 in varchar2 default hr_api.g_varchar2
671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2

Line 675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2

671: ,p_cwg_attribute9 in varchar2 default hr_api.g_varchar2
672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2

Line 676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2

672: ,p_cwg_attribute10 in varchar2 default hr_api.g_varchar2
673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2

Line 677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2

673: ,p_cwg_attribute11 in varchar2 default hr_api.g_varchar2
674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2

Line 678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2

674: ,p_cwg_attribute12 in varchar2 default hr_api.g_varchar2
675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2

Line 679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2

675: ,p_cwg_attribute13 in varchar2 default hr_api.g_varchar2
676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2

Line 680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2

676: ,p_cwg_attribute14 in varchar2 default hr_api.g_varchar2
677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2

Line 681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2

677: ,p_cwg_attribute15 in varchar2 default hr_api.g_varchar2
678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2

Line 682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2

678: ,p_cwg_attribute16 in varchar2 default hr_api.g_varchar2
679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2

Line 683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2

679: ,p_cwg_attribute17 in varchar2 default hr_api.g_varchar2
680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2

Line 684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2

680: ,p_cwg_attribute18 in varchar2 default hr_api.g_varchar2
681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2

Line 685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2

681: ,p_cwg_attribute19 in varchar2 default hr_api.g_varchar2
682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2

Line 686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2

682: ,p_cwg_attribute20 in varchar2 default hr_api.g_varchar2
683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2

Line 687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2

683: ,p_cwg_attribute21 in varchar2 default hr_api.g_varchar2
684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
691: ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2

Line 688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2

684: ,p_cwg_attribute22 in varchar2 default hr_api.g_varchar2
685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
691: ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2
692: ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2

Line 689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2

685: ,p_cwg_attribute23 in varchar2 default hr_api.g_varchar2
686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
691: ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2
692: ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2
693: ,p_status_cd in varchar2 default hr_api.g_varchar2

Line 690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2

686: ,p_cwg_attribute24 in varchar2 default hr_api.g_varchar2
687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
691: ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2
692: ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2
693: ,p_status_cd in varchar2 default hr_api.g_varchar2
694: ,p_hidden_cd in varchar2 default hr_api.g_varchar2

Line 691: ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2

687: ,p_cwg_attribute25 in varchar2 default hr_api.g_varchar2
688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
691: ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2
692: ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2
693: ,p_status_cd in varchar2 default hr_api.g_varchar2
694: ,p_hidden_cd in varchar2 default hr_api.g_varchar2
695: ) is

Line 692: ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2

688: ,p_cwg_attribute26 in varchar2 default hr_api.g_varchar2
689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
691: ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2
692: ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2
693: ,p_status_cd in varchar2 default hr_api.g_varchar2
694: ,p_hidden_cd in varchar2 default hr_api.g_varchar2
695: ) is
696: --

Line 693: ,p_status_cd in varchar2 default hr_api.g_varchar2

689: ,p_cwg_attribute27 in varchar2 default hr_api.g_varchar2
690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
691: ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2
692: ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2
693: ,p_status_cd in varchar2 default hr_api.g_varchar2
694: ,p_hidden_cd in varchar2 default hr_api.g_varchar2
695: ) is
696: --
697: l_rec ben_cwg_shd.g_rec_type;

Line 694: ,p_hidden_cd in varchar2 default hr_api.g_varchar2

690: ,p_cwg_attribute28 in varchar2 default hr_api.g_varchar2
691: ,p_cwg_attribute29 in varchar2 default hr_api.g_varchar2
692: ,p_cwg_attribute30 in varchar2 default hr_api.g_varchar2
693: ,p_status_cd in varchar2 default hr_api.g_varchar2
694: ,p_hidden_cd in varchar2 default hr_api.g_varchar2
695: ) is
696: --
697: l_rec ben_cwg_shd.g_rec_type;
698: l_proc varchar2(72) := g_package||'upd';

Line 709: ,hr_api.g_number

705: --
706: l_rec :=
707: ben_cwg_shd.convert_args
708: (p_cwb_wksht_grp_id
709: ,hr_api.g_number
710: ,hr_api.g_number
711: ,p_ordr_num
712: ,p_wksht_grp_cd
713: ,p_label

Line 710: ,hr_api.g_number

706: l_rec :=
707: ben_cwg_shd.convert_args
708: (p_cwb_wksht_grp_id
709: ,hr_api.g_number
710: ,hr_api.g_number
711: ,p_ordr_num
712: ,p_wksht_grp_cd
713: ,p_label
714: ,p_cwg_attribute_category