111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: --
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
118: ben_pcg_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
118: ben_pcg_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pcg_shd.constraint_error
116: -- A check constraint has been violated
117: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
118: ben_pcg_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pcg_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pcg_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
128: ben_pcg_shd.constraint_error
121: -- Parent integrity has been violated
122: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
123: ben_pcg_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
128: ben_pcg_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
128: ben_pcg_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
132: Raise;
133: End update_dml;
296: );
297: --
298: exception
299: --
300: when hr_api.cannot_find_prog_unit then
301: --
302: hr_api.cannot_find_prog_unit_error
303: (p_module_name => 'ben_prtt_clm_gd_or_svc_typ'
304: ,p_hook_type => 'AU');
298: exception
299: --
300: when hr_api.cannot_find_prog_unit then
301: --
302: hr_api.cannot_find_prog_unit_error
303: (p_module_name => 'ben_prtt_clm_gd_or_svc_typ'
304: ,p_hook_type => 'AU');
305: --
306: end;
366: -- p_rec plsql record structure
367: -- to see if a system default is being used. If a system default
368: -- is being used then we must set to the 'current' argument value.
369: --
370: If (p_rec.prtt_reimbmt_rqst_id = hr_api.g_number) then
371: p_rec.prtt_reimbmt_rqst_id :=
372: ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id;
373: End If;
374: If (p_rec.gd_or_svc_typ_id = hr_api.g_number) then
370: If (p_rec.prtt_reimbmt_rqst_id = hr_api.g_number) then
371: p_rec.prtt_reimbmt_rqst_id :=
372: ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id;
373: End If;
374: If (p_rec.gd_or_svc_typ_id = hr_api.g_number) then
375: p_rec.gd_or_svc_typ_id :=
376: ben_pcg_shd.g_old_rec.gd_or_svc_typ_id;
377: End If;
378: If (p_rec.business_group_id = hr_api.g_number) then
374: If (p_rec.gd_or_svc_typ_id = hr_api.g_number) then
375: p_rec.gd_or_svc_typ_id :=
376: ben_pcg_shd.g_old_rec.gd_or_svc_typ_id;
377: End If;
378: If (p_rec.business_group_id = hr_api.g_number) then
379: p_rec.business_group_id :=
380: ben_pcg_shd.g_old_rec.business_group_id;
381: End If;
382: If (p_rec.pcg_attribute_category = hr_api.g_varchar2) then
378: If (p_rec.business_group_id = hr_api.g_number) then
379: p_rec.business_group_id :=
380: ben_pcg_shd.g_old_rec.business_group_id;
381: End If;
382: If (p_rec.pcg_attribute_category = hr_api.g_varchar2) then
383: p_rec.pcg_attribute_category :=
384: ben_pcg_shd.g_old_rec.pcg_attribute_category;
385: End If;
386: If (p_rec.pcg_attribute1 = hr_api.g_varchar2) then
382: If (p_rec.pcg_attribute_category = hr_api.g_varchar2) then
383: p_rec.pcg_attribute_category :=
384: ben_pcg_shd.g_old_rec.pcg_attribute_category;
385: End If;
386: If (p_rec.pcg_attribute1 = hr_api.g_varchar2) then
387: p_rec.pcg_attribute1 :=
388: ben_pcg_shd.g_old_rec.pcg_attribute1;
389: End If;
390: If (p_rec.pcg_attribute2 = hr_api.g_varchar2) then
386: If (p_rec.pcg_attribute1 = hr_api.g_varchar2) then
387: p_rec.pcg_attribute1 :=
388: ben_pcg_shd.g_old_rec.pcg_attribute1;
389: End If;
390: If (p_rec.pcg_attribute2 = hr_api.g_varchar2) then
391: p_rec.pcg_attribute2 :=
392: ben_pcg_shd.g_old_rec.pcg_attribute2;
393: End If;
394: If (p_rec.pcg_attribute3 = hr_api.g_varchar2) then
390: If (p_rec.pcg_attribute2 = hr_api.g_varchar2) then
391: p_rec.pcg_attribute2 :=
392: ben_pcg_shd.g_old_rec.pcg_attribute2;
393: End If;
394: If (p_rec.pcg_attribute3 = hr_api.g_varchar2) then
395: p_rec.pcg_attribute3 :=
396: ben_pcg_shd.g_old_rec.pcg_attribute3;
397: End If;
398: If (p_rec.pcg_attribute4 = hr_api.g_varchar2) then
394: If (p_rec.pcg_attribute3 = hr_api.g_varchar2) then
395: p_rec.pcg_attribute3 :=
396: ben_pcg_shd.g_old_rec.pcg_attribute3;
397: End If;
398: If (p_rec.pcg_attribute4 = hr_api.g_varchar2) then
399: p_rec.pcg_attribute4 :=
400: ben_pcg_shd.g_old_rec.pcg_attribute4;
401: End If;
402: If (p_rec.pcg_attribute5 = hr_api.g_varchar2) then
398: If (p_rec.pcg_attribute4 = hr_api.g_varchar2) then
399: p_rec.pcg_attribute4 :=
400: ben_pcg_shd.g_old_rec.pcg_attribute4;
401: End If;
402: If (p_rec.pcg_attribute5 = hr_api.g_varchar2) then
403: p_rec.pcg_attribute5 :=
404: ben_pcg_shd.g_old_rec.pcg_attribute5;
405: End If;
406: If (p_rec.pcg_attribute6 = hr_api.g_varchar2) then
402: If (p_rec.pcg_attribute5 = hr_api.g_varchar2) then
403: p_rec.pcg_attribute5 :=
404: ben_pcg_shd.g_old_rec.pcg_attribute5;
405: End If;
406: If (p_rec.pcg_attribute6 = hr_api.g_varchar2) then
407: p_rec.pcg_attribute6 :=
408: ben_pcg_shd.g_old_rec.pcg_attribute6;
409: End If;
410: If (p_rec.pcg_attribute7 = hr_api.g_varchar2) then
406: If (p_rec.pcg_attribute6 = hr_api.g_varchar2) then
407: p_rec.pcg_attribute6 :=
408: ben_pcg_shd.g_old_rec.pcg_attribute6;
409: End If;
410: If (p_rec.pcg_attribute7 = hr_api.g_varchar2) then
411: p_rec.pcg_attribute7 :=
412: ben_pcg_shd.g_old_rec.pcg_attribute7;
413: End If;
414: If (p_rec.pcg_attribute8 = hr_api.g_varchar2) then
410: If (p_rec.pcg_attribute7 = hr_api.g_varchar2) then
411: p_rec.pcg_attribute7 :=
412: ben_pcg_shd.g_old_rec.pcg_attribute7;
413: End If;
414: If (p_rec.pcg_attribute8 = hr_api.g_varchar2) then
415: p_rec.pcg_attribute8 :=
416: ben_pcg_shd.g_old_rec.pcg_attribute8;
417: End If;
418: If (p_rec.pcg_attribute9 = hr_api.g_varchar2) then
414: If (p_rec.pcg_attribute8 = hr_api.g_varchar2) then
415: p_rec.pcg_attribute8 :=
416: ben_pcg_shd.g_old_rec.pcg_attribute8;
417: End If;
418: If (p_rec.pcg_attribute9 = hr_api.g_varchar2) then
419: p_rec.pcg_attribute9 :=
420: ben_pcg_shd.g_old_rec.pcg_attribute9;
421: End If;
422: If (p_rec.pcg_attribute10 = hr_api.g_varchar2) then
418: If (p_rec.pcg_attribute9 = hr_api.g_varchar2) then
419: p_rec.pcg_attribute9 :=
420: ben_pcg_shd.g_old_rec.pcg_attribute9;
421: End If;
422: If (p_rec.pcg_attribute10 = hr_api.g_varchar2) then
423: p_rec.pcg_attribute10 :=
424: ben_pcg_shd.g_old_rec.pcg_attribute10;
425: End If;
426: If (p_rec.pcg_attribute11 = hr_api.g_varchar2) then
422: If (p_rec.pcg_attribute10 = hr_api.g_varchar2) then
423: p_rec.pcg_attribute10 :=
424: ben_pcg_shd.g_old_rec.pcg_attribute10;
425: End If;
426: If (p_rec.pcg_attribute11 = hr_api.g_varchar2) then
427: p_rec.pcg_attribute11 :=
428: ben_pcg_shd.g_old_rec.pcg_attribute11;
429: End If;
430: If (p_rec.pcg_attribute12 = hr_api.g_varchar2) then
426: If (p_rec.pcg_attribute11 = hr_api.g_varchar2) then
427: p_rec.pcg_attribute11 :=
428: ben_pcg_shd.g_old_rec.pcg_attribute11;
429: End If;
430: If (p_rec.pcg_attribute12 = hr_api.g_varchar2) then
431: p_rec.pcg_attribute12 :=
432: ben_pcg_shd.g_old_rec.pcg_attribute12;
433: End If;
434: If (p_rec.pcg_attribute13 = hr_api.g_varchar2) then
430: If (p_rec.pcg_attribute12 = hr_api.g_varchar2) then
431: p_rec.pcg_attribute12 :=
432: ben_pcg_shd.g_old_rec.pcg_attribute12;
433: End If;
434: If (p_rec.pcg_attribute13 = hr_api.g_varchar2) then
435: p_rec.pcg_attribute13 :=
436: ben_pcg_shd.g_old_rec.pcg_attribute13;
437: End If;
438: If (p_rec.pcg_attribute14 = hr_api.g_varchar2) then
434: If (p_rec.pcg_attribute13 = hr_api.g_varchar2) then
435: p_rec.pcg_attribute13 :=
436: ben_pcg_shd.g_old_rec.pcg_attribute13;
437: End If;
438: If (p_rec.pcg_attribute14 = hr_api.g_varchar2) then
439: p_rec.pcg_attribute14 :=
440: ben_pcg_shd.g_old_rec.pcg_attribute14;
441: End If;
442: If (p_rec.pcg_attribute15 = hr_api.g_varchar2) then
438: If (p_rec.pcg_attribute14 = hr_api.g_varchar2) then
439: p_rec.pcg_attribute14 :=
440: ben_pcg_shd.g_old_rec.pcg_attribute14;
441: End If;
442: If (p_rec.pcg_attribute15 = hr_api.g_varchar2) then
443: p_rec.pcg_attribute15 :=
444: ben_pcg_shd.g_old_rec.pcg_attribute15;
445: End If;
446: If (p_rec.pcg_attribute16 = hr_api.g_varchar2) then
442: If (p_rec.pcg_attribute15 = hr_api.g_varchar2) then
443: p_rec.pcg_attribute15 :=
444: ben_pcg_shd.g_old_rec.pcg_attribute15;
445: End If;
446: If (p_rec.pcg_attribute16 = hr_api.g_varchar2) then
447: p_rec.pcg_attribute16 :=
448: ben_pcg_shd.g_old_rec.pcg_attribute16;
449: End If;
450: If (p_rec.pcg_attribute17 = hr_api.g_varchar2) then
446: If (p_rec.pcg_attribute16 = hr_api.g_varchar2) then
447: p_rec.pcg_attribute16 :=
448: ben_pcg_shd.g_old_rec.pcg_attribute16;
449: End If;
450: If (p_rec.pcg_attribute17 = hr_api.g_varchar2) then
451: p_rec.pcg_attribute17 :=
452: ben_pcg_shd.g_old_rec.pcg_attribute17;
453: End If;
454: If (p_rec.pcg_attribute18 = hr_api.g_varchar2) then
450: If (p_rec.pcg_attribute17 = hr_api.g_varchar2) then
451: p_rec.pcg_attribute17 :=
452: ben_pcg_shd.g_old_rec.pcg_attribute17;
453: End If;
454: If (p_rec.pcg_attribute18 = hr_api.g_varchar2) then
455: p_rec.pcg_attribute18 :=
456: ben_pcg_shd.g_old_rec.pcg_attribute18;
457: End If;
458: If (p_rec.pcg_attribute19 = hr_api.g_varchar2) then
454: If (p_rec.pcg_attribute18 = hr_api.g_varchar2) then
455: p_rec.pcg_attribute18 :=
456: ben_pcg_shd.g_old_rec.pcg_attribute18;
457: End If;
458: If (p_rec.pcg_attribute19 = hr_api.g_varchar2) then
459: p_rec.pcg_attribute19 :=
460: ben_pcg_shd.g_old_rec.pcg_attribute19;
461: End If;
462: If (p_rec.pcg_attribute20 = hr_api.g_varchar2) then
458: If (p_rec.pcg_attribute19 = hr_api.g_varchar2) then
459: p_rec.pcg_attribute19 :=
460: ben_pcg_shd.g_old_rec.pcg_attribute19;
461: End If;
462: If (p_rec.pcg_attribute20 = hr_api.g_varchar2) then
463: p_rec.pcg_attribute20 :=
464: ben_pcg_shd.g_old_rec.pcg_attribute20;
465: End If;
466: If (p_rec.pcg_attribute21 = hr_api.g_varchar2) then
462: If (p_rec.pcg_attribute20 = hr_api.g_varchar2) then
463: p_rec.pcg_attribute20 :=
464: ben_pcg_shd.g_old_rec.pcg_attribute20;
465: End If;
466: If (p_rec.pcg_attribute21 = hr_api.g_varchar2) then
467: p_rec.pcg_attribute21 :=
468: ben_pcg_shd.g_old_rec.pcg_attribute21;
469: End If;
470: If (p_rec.pcg_attribute22 = hr_api.g_varchar2) then
466: If (p_rec.pcg_attribute21 = hr_api.g_varchar2) then
467: p_rec.pcg_attribute21 :=
468: ben_pcg_shd.g_old_rec.pcg_attribute21;
469: End If;
470: If (p_rec.pcg_attribute22 = hr_api.g_varchar2) then
471: p_rec.pcg_attribute22 :=
472: ben_pcg_shd.g_old_rec.pcg_attribute22;
473: End If;
474: If (p_rec.pcg_attribute23 = hr_api.g_varchar2) then
470: If (p_rec.pcg_attribute22 = hr_api.g_varchar2) then
471: p_rec.pcg_attribute22 :=
472: ben_pcg_shd.g_old_rec.pcg_attribute22;
473: End If;
474: If (p_rec.pcg_attribute23 = hr_api.g_varchar2) then
475: p_rec.pcg_attribute23 :=
476: ben_pcg_shd.g_old_rec.pcg_attribute23;
477: End If;
478: If (p_rec.pcg_attribute24 = hr_api.g_varchar2) then
474: If (p_rec.pcg_attribute23 = hr_api.g_varchar2) then
475: p_rec.pcg_attribute23 :=
476: ben_pcg_shd.g_old_rec.pcg_attribute23;
477: End If;
478: If (p_rec.pcg_attribute24 = hr_api.g_varchar2) then
479: p_rec.pcg_attribute24 :=
480: ben_pcg_shd.g_old_rec.pcg_attribute24;
481: End If;
482: If (p_rec.pcg_attribute25 = hr_api.g_varchar2) then
478: If (p_rec.pcg_attribute24 = hr_api.g_varchar2) then
479: p_rec.pcg_attribute24 :=
480: ben_pcg_shd.g_old_rec.pcg_attribute24;
481: End If;
482: If (p_rec.pcg_attribute25 = hr_api.g_varchar2) then
483: p_rec.pcg_attribute25 :=
484: ben_pcg_shd.g_old_rec.pcg_attribute25;
485: End If;
486: If (p_rec.pcg_attribute26 = hr_api.g_varchar2) then
482: If (p_rec.pcg_attribute25 = hr_api.g_varchar2) then
483: p_rec.pcg_attribute25 :=
484: ben_pcg_shd.g_old_rec.pcg_attribute25;
485: End If;
486: If (p_rec.pcg_attribute26 = hr_api.g_varchar2) then
487: p_rec.pcg_attribute26 :=
488: ben_pcg_shd.g_old_rec.pcg_attribute26;
489: End If;
490: If (p_rec.pcg_attribute27 = hr_api.g_varchar2) then
486: If (p_rec.pcg_attribute26 = hr_api.g_varchar2) then
487: p_rec.pcg_attribute26 :=
488: ben_pcg_shd.g_old_rec.pcg_attribute26;
489: End If;
490: If (p_rec.pcg_attribute27 = hr_api.g_varchar2) then
491: p_rec.pcg_attribute27 :=
492: ben_pcg_shd.g_old_rec.pcg_attribute27;
493: End If;
494: If (p_rec.pcg_attribute28 = hr_api.g_varchar2) then
490: If (p_rec.pcg_attribute27 = hr_api.g_varchar2) then
491: p_rec.pcg_attribute27 :=
492: ben_pcg_shd.g_old_rec.pcg_attribute27;
493: End If;
494: If (p_rec.pcg_attribute28 = hr_api.g_varchar2) then
495: p_rec.pcg_attribute28 :=
496: ben_pcg_shd.g_old_rec.pcg_attribute28;
497: End If;
498: If (p_rec.pcg_attribute29 = hr_api.g_varchar2) then
494: If (p_rec.pcg_attribute28 = hr_api.g_varchar2) then
495: p_rec.pcg_attribute28 :=
496: ben_pcg_shd.g_old_rec.pcg_attribute28;
497: End If;
498: If (p_rec.pcg_attribute29 = hr_api.g_varchar2) then
499: p_rec.pcg_attribute29 :=
500: ben_pcg_shd.g_old_rec.pcg_attribute29;
501: End If;
502: If (p_rec.pcg_attribute30 = hr_api.g_varchar2) then
498: If (p_rec.pcg_attribute29 = hr_api.g_varchar2) then
499: p_rec.pcg_attribute29 :=
500: ben_pcg_shd.g_old_rec.pcg_attribute29;
501: End If;
502: If (p_rec.pcg_attribute30 = hr_api.g_varchar2) then
503: p_rec.pcg_attribute30 :=
504: ben_pcg_shd.g_old_rec.pcg_attribute30;
505: End If;
506: if (p_rec.pl_gd_or_svc_id = hr_api.g_number) then
502: If (p_rec.pcg_attribute30 = hr_api.g_varchar2) then
503: p_rec.pcg_attribute30 :=
504: ben_pcg_shd.g_old_rec.pcg_attribute30;
505: End If;
506: if (p_rec.pl_gd_or_svc_id = hr_api.g_number) then
507: p_rec.pl_gd_or_svc_id := ben_pcg_shd.g_old_rec.pl_gd_or_svc_id ;
508: end if ;
509: --
510: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: -- ----------------------------------------------------------------------------
560: Procedure upd
561: (
562: p_prtt_clm_gd_or_svc_typ_id in number,
563: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
564: p_gd_or_svc_typ_id in number default hr_api.g_number,
565: p_business_group_id in number default hr_api.g_number,
566: p_pcg_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_pcg_attribute1 in varchar2 default hr_api.g_varchar2,
560: Procedure upd
561: (
562: p_prtt_clm_gd_or_svc_typ_id in number,
563: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
564: p_gd_or_svc_typ_id in number default hr_api.g_number,
565: p_business_group_id in number default hr_api.g_number,
566: p_pcg_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_pcg_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_pcg_attribute2 in varchar2 default hr_api.g_varchar2,
561: (
562: p_prtt_clm_gd_or_svc_typ_id in number,
563: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
564: p_gd_or_svc_typ_id in number default hr_api.g_number,
565: p_business_group_id in number default hr_api.g_number,
566: p_pcg_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_pcg_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_pcg_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_pcg_attribute3 in varchar2 default hr_api.g_varchar2,
562: p_prtt_clm_gd_or_svc_typ_id in number,
563: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
564: p_gd_or_svc_typ_id in number default hr_api.g_number,
565: p_business_group_id in number default hr_api.g_number,
566: p_pcg_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_pcg_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_pcg_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_pcg_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_pcg_attribute4 in varchar2 default hr_api.g_varchar2,
563: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
564: p_gd_or_svc_typ_id in number default hr_api.g_number,
565: p_business_group_id in number default hr_api.g_number,
566: p_pcg_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_pcg_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_pcg_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_pcg_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_pcg_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_pcg_attribute5 in varchar2 default hr_api.g_varchar2,
564: p_gd_or_svc_typ_id in number default hr_api.g_number,
565: p_business_group_id in number default hr_api.g_number,
566: p_pcg_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_pcg_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_pcg_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_pcg_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_pcg_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_pcg_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_pcg_attribute6 in varchar2 default hr_api.g_varchar2,
565: p_business_group_id in number default hr_api.g_number,
566: p_pcg_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_pcg_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_pcg_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_pcg_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_pcg_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_pcg_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_pcg_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_pcg_attribute7 in varchar2 default hr_api.g_varchar2,
566: p_pcg_attribute_category in varchar2 default hr_api.g_varchar2,
567: p_pcg_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_pcg_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_pcg_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_pcg_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_pcg_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_pcg_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_pcg_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_pcg_attribute8 in varchar2 default hr_api.g_varchar2,
567: p_pcg_attribute1 in varchar2 default hr_api.g_varchar2,
568: p_pcg_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_pcg_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_pcg_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_pcg_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_pcg_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_pcg_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_pcg_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_pcg_attribute9 in varchar2 default hr_api.g_varchar2,
568: p_pcg_attribute2 in varchar2 default hr_api.g_varchar2,
569: p_pcg_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_pcg_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_pcg_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_pcg_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_pcg_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_pcg_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_pcg_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_pcg_attribute10 in varchar2 default hr_api.g_varchar2,
569: p_pcg_attribute3 in varchar2 default hr_api.g_varchar2,
570: p_pcg_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_pcg_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_pcg_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_pcg_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_pcg_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_pcg_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_pcg_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_pcg_attribute11 in varchar2 default hr_api.g_varchar2,
570: p_pcg_attribute4 in varchar2 default hr_api.g_varchar2,
571: p_pcg_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_pcg_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_pcg_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_pcg_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_pcg_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_pcg_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_pcg_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_pcg_attribute12 in varchar2 default hr_api.g_varchar2,
571: p_pcg_attribute5 in varchar2 default hr_api.g_varchar2,
572: p_pcg_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_pcg_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_pcg_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_pcg_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_pcg_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_pcg_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_pcg_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_pcg_attribute13 in varchar2 default hr_api.g_varchar2,
572: p_pcg_attribute6 in varchar2 default hr_api.g_varchar2,
573: p_pcg_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_pcg_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_pcg_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_pcg_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_pcg_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_pcg_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_pcg_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_pcg_attribute14 in varchar2 default hr_api.g_varchar2,
573: p_pcg_attribute7 in varchar2 default hr_api.g_varchar2,
574: p_pcg_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_pcg_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_pcg_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_pcg_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_pcg_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_pcg_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_pcg_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_pcg_attribute15 in varchar2 default hr_api.g_varchar2,
574: p_pcg_attribute8 in varchar2 default hr_api.g_varchar2,
575: p_pcg_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_pcg_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_pcg_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_pcg_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_pcg_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_pcg_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_pcg_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_pcg_attribute16 in varchar2 default hr_api.g_varchar2,
575: p_pcg_attribute9 in varchar2 default hr_api.g_varchar2,
576: p_pcg_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_pcg_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_pcg_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_pcg_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_pcg_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_pcg_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_pcg_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_pcg_attribute17 in varchar2 default hr_api.g_varchar2,
576: p_pcg_attribute10 in varchar2 default hr_api.g_varchar2,
577: p_pcg_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_pcg_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_pcg_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_pcg_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_pcg_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_pcg_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_pcg_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_pcg_attribute18 in varchar2 default hr_api.g_varchar2,
577: p_pcg_attribute11 in varchar2 default hr_api.g_varchar2,
578: p_pcg_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_pcg_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_pcg_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_pcg_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_pcg_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_pcg_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_pcg_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_pcg_attribute19 in varchar2 default hr_api.g_varchar2,
578: p_pcg_attribute12 in varchar2 default hr_api.g_varchar2,
579: p_pcg_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_pcg_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_pcg_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_pcg_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_pcg_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_pcg_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_pcg_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_pcg_attribute20 in varchar2 default hr_api.g_varchar2,
579: p_pcg_attribute13 in varchar2 default hr_api.g_varchar2,
580: p_pcg_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_pcg_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_pcg_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_pcg_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_pcg_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_pcg_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_pcg_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_pcg_attribute21 in varchar2 default hr_api.g_varchar2,
580: p_pcg_attribute14 in varchar2 default hr_api.g_varchar2,
581: p_pcg_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_pcg_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_pcg_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_pcg_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_pcg_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_pcg_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_pcg_attribute21 in varchar2 default hr_api.g_varchar2,
588: p_pcg_attribute22 in varchar2 default hr_api.g_varchar2,
581: p_pcg_attribute15 in varchar2 default hr_api.g_varchar2,
582: p_pcg_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_pcg_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_pcg_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_pcg_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_pcg_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_pcg_attribute21 in varchar2 default hr_api.g_varchar2,
588: p_pcg_attribute22 in varchar2 default hr_api.g_varchar2,
589: p_pcg_attribute23 in varchar2 default hr_api.g_varchar2,
582: p_pcg_attribute16 in varchar2 default hr_api.g_varchar2,
583: p_pcg_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_pcg_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_pcg_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_pcg_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_pcg_attribute21 in varchar2 default hr_api.g_varchar2,
588: p_pcg_attribute22 in varchar2 default hr_api.g_varchar2,
589: p_pcg_attribute23 in varchar2 default hr_api.g_varchar2,
590: p_pcg_attribute24 in varchar2 default hr_api.g_varchar2,
583: p_pcg_attribute17 in varchar2 default hr_api.g_varchar2,
584: p_pcg_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_pcg_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_pcg_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_pcg_attribute21 in varchar2 default hr_api.g_varchar2,
588: p_pcg_attribute22 in varchar2 default hr_api.g_varchar2,
589: p_pcg_attribute23 in varchar2 default hr_api.g_varchar2,
590: p_pcg_attribute24 in varchar2 default hr_api.g_varchar2,
591: p_pcg_attribute25 in varchar2 default hr_api.g_varchar2,
584: p_pcg_attribute18 in varchar2 default hr_api.g_varchar2,
585: p_pcg_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_pcg_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_pcg_attribute21 in varchar2 default hr_api.g_varchar2,
588: p_pcg_attribute22 in varchar2 default hr_api.g_varchar2,
589: p_pcg_attribute23 in varchar2 default hr_api.g_varchar2,
590: p_pcg_attribute24 in varchar2 default hr_api.g_varchar2,
591: p_pcg_attribute25 in varchar2 default hr_api.g_varchar2,
592: p_pcg_attribute26 in varchar2 default hr_api.g_varchar2,
585: p_pcg_attribute19 in varchar2 default hr_api.g_varchar2,
586: p_pcg_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_pcg_attribute21 in varchar2 default hr_api.g_varchar2,
588: p_pcg_attribute22 in varchar2 default hr_api.g_varchar2,
589: p_pcg_attribute23 in varchar2 default hr_api.g_varchar2,
590: p_pcg_attribute24 in varchar2 default hr_api.g_varchar2,
591: p_pcg_attribute25 in varchar2 default hr_api.g_varchar2,
592: p_pcg_attribute26 in varchar2 default hr_api.g_varchar2,
593: p_pcg_attribute27 in varchar2 default hr_api.g_varchar2,
586: p_pcg_attribute20 in varchar2 default hr_api.g_varchar2,
587: p_pcg_attribute21 in varchar2 default hr_api.g_varchar2,
588: p_pcg_attribute22 in varchar2 default hr_api.g_varchar2,
589: p_pcg_attribute23 in varchar2 default hr_api.g_varchar2,
590: p_pcg_attribute24 in varchar2 default hr_api.g_varchar2,
591: p_pcg_attribute25 in varchar2 default hr_api.g_varchar2,
592: p_pcg_attribute26 in varchar2 default hr_api.g_varchar2,
593: p_pcg_attribute27 in varchar2 default hr_api.g_varchar2,
594: p_pcg_attribute28 in varchar2 default hr_api.g_varchar2,
587: p_pcg_attribute21 in varchar2 default hr_api.g_varchar2,
588: p_pcg_attribute22 in varchar2 default hr_api.g_varchar2,
589: p_pcg_attribute23 in varchar2 default hr_api.g_varchar2,
590: p_pcg_attribute24 in varchar2 default hr_api.g_varchar2,
591: p_pcg_attribute25 in varchar2 default hr_api.g_varchar2,
592: p_pcg_attribute26 in varchar2 default hr_api.g_varchar2,
593: p_pcg_attribute27 in varchar2 default hr_api.g_varchar2,
594: p_pcg_attribute28 in varchar2 default hr_api.g_varchar2,
595: p_pcg_attribute29 in varchar2 default hr_api.g_varchar2,
588: p_pcg_attribute22 in varchar2 default hr_api.g_varchar2,
589: p_pcg_attribute23 in varchar2 default hr_api.g_varchar2,
590: p_pcg_attribute24 in varchar2 default hr_api.g_varchar2,
591: p_pcg_attribute25 in varchar2 default hr_api.g_varchar2,
592: p_pcg_attribute26 in varchar2 default hr_api.g_varchar2,
593: p_pcg_attribute27 in varchar2 default hr_api.g_varchar2,
594: p_pcg_attribute28 in varchar2 default hr_api.g_varchar2,
595: p_pcg_attribute29 in varchar2 default hr_api.g_varchar2,
596: p_pcg_attribute30 in varchar2 default hr_api.g_varchar2,
589: p_pcg_attribute23 in varchar2 default hr_api.g_varchar2,
590: p_pcg_attribute24 in varchar2 default hr_api.g_varchar2,
591: p_pcg_attribute25 in varchar2 default hr_api.g_varchar2,
592: p_pcg_attribute26 in varchar2 default hr_api.g_varchar2,
593: p_pcg_attribute27 in varchar2 default hr_api.g_varchar2,
594: p_pcg_attribute28 in varchar2 default hr_api.g_varchar2,
595: p_pcg_attribute29 in varchar2 default hr_api.g_varchar2,
596: p_pcg_attribute30 in varchar2 default hr_api.g_varchar2,
597: p_object_version_number in out nocopy number ,
590: p_pcg_attribute24 in varchar2 default hr_api.g_varchar2,
591: p_pcg_attribute25 in varchar2 default hr_api.g_varchar2,
592: p_pcg_attribute26 in varchar2 default hr_api.g_varchar2,
593: p_pcg_attribute27 in varchar2 default hr_api.g_varchar2,
594: p_pcg_attribute28 in varchar2 default hr_api.g_varchar2,
595: p_pcg_attribute29 in varchar2 default hr_api.g_varchar2,
596: p_pcg_attribute30 in varchar2 default hr_api.g_varchar2,
597: p_object_version_number in out nocopy number ,
598: p_pl_gd_or_svc_id in number default hr_api.g_number
591: p_pcg_attribute25 in varchar2 default hr_api.g_varchar2,
592: p_pcg_attribute26 in varchar2 default hr_api.g_varchar2,
593: p_pcg_attribute27 in varchar2 default hr_api.g_varchar2,
594: p_pcg_attribute28 in varchar2 default hr_api.g_varchar2,
595: p_pcg_attribute29 in varchar2 default hr_api.g_varchar2,
596: p_pcg_attribute30 in varchar2 default hr_api.g_varchar2,
597: p_object_version_number in out nocopy number ,
598: p_pl_gd_or_svc_id in number default hr_api.g_number
599: ) is
592: p_pcg_attribute26 in varchar2 default hr_api.g_varchar2,
593: p_pcg_attribute27 in varchar2 default hr_api.g_varchar2,
594: p_pcg_attribute28 in varchar2 default hr_api.g_varchar2,
595: p_pcg_attribute29 in varchar2 default hr_api.g_varchar2,
596: p_pcg_attribute30 in varchar2 default hr_api.g_varchar2,
597: p_object_version_number in out nocopy number ,
598: p_pl_gd_or_svc_id in number default hr_api.g_number
599: ) is
600: --
594: p_pcg_attribute28 in varchar2 default hr_api.g_varchar2,
595: p_pcg_attribute29 in varchar2 default hr_api.g_varchar2,
596: p_pcg_attribute30 in varchar2 default hr_api.g_varchar2,
597: p_object_version_number in out nocopy number ,
598: p_pl_gd_or_svc_id in number default hr_api.g_number
599: ) is
600: --
601: l_rec ben_pcg_shd.g_rec_type;
602: l_proc varchar2(72) := g_package||'upd';