APPS.BEN_CPG_UPD dependencies on HR_API

Line 119: When hr_api.check_integrity_violated Then

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

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

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

Line 124: When hr_api.parent_integrity_violated Then

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

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

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

Line 129: When hr_api.unique_integrity_violated Then

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

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

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

Line 374: when hr_api.cannot_find_prog_unit then

370: );
371: --
372: exception
373: --
374: when hr_api.cannot_find_prog_unit then
375: --
376: hr_api.cannot_find_prog_unit_error
377: (p_module_name => 'BEN_CWB_PERSON_GROUPS'
378: ,p_hook_type => 'AU');

Line 376: hr_api.cannot_find_prog_unit_error

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

Line 441: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then

437: -- p_rec plsql record structure
438: -- to see if a system default is being used. If a system default
439: -- is being used then we must set to the 'current' argument value.
440: --
441: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
442: p_rec.lf_evt_ocrd_dt :=
443: ben_cpg_shd.g_old_rec.lf_evt_ocrd_dt;
444: End If;
445: If (p_rec.bdgt_pop_cd = hr_api.g_varchar2) then

Line 445: If (p_rec.bdgt_pop_cd = hr_api.g_varchar2) then

441: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
442: p_rec.lf_evt_ocrd_dt :=
443: ben_cpg_shd.g_old_rec.lf_evt_ocrd_dt;
444: End If;
445: If (p_rec.bdgt_pop_cd = hr_api.g_varchar2) then
446: p_rec.bdgt_pop_cd :=
447: ben_cpg_shd.g_old_rec.bdgt_pop_cd;
448: End If;
449: If (p_rec.due_dt = hr_api.g_date) then

Line 449: If (p_rec.due_dt = hr_api.g_date) then

445: If (p_rec.bdgt_pop_cd = hr_api.g_varchar2) then
446: p_rec.bdgt_pop_cd :=
447: ben_cpg_shd.g_old_rec.bdgt_pop_cd;
448: End If;
449: If (p_rec.due_dt = hr_api.g_date) then
450: p_rec.due_dt :=
451: ben_cpg_shd.g_old_rec.due_dt;
452: End If;
453: If (p_rec.access_cd = hr_api.g_varchar2) then

Line 453: If (p_rec.access_cd = hr_api.g_varchar2) then

449: If (p_rec.due_dt = hr_api.g_date) then
450: p_rec.due_dt :=
451: ben_cpg_shd.g_old_rec.due_dt;
452: End If;
453: If (p_rec.access_cd = hr_api.g_varchar2) then
454: p_rec.access_cd :=
455: ben_cpg_shd.g_old_rec.access_cd;
456: End If;
457: If (p_rec.approval_cd = hr_api.g_varchar2) then

Line 457: If (p_rec.approval_cd = hr_api.g_varchar2) then

453: If (p_rec.access_cd = hr_api.g_varchar2) then
454: p_rec.access_cd :=
455: ben_cpg_shd.g_old_rec.access_cd;
456: End If;
457: If (p_rec.approval_cd = hr_api.g_varchar2) then
458: p_rec.approval_cd :=
459: ben_cpg_shd.g_old_rec.approval_cd;
460: End If;
461: If (p_rec.approval_date = hr_api.g_date) then

Line 461: If (p_rec.approval_date = hr_api.g_date) then

457: If (p_rec.approval_cd = hr_api.g_varchar2) then
458: p_rec.approval_cd :=
459: ben_cpg_shd.g_old_rec.approval_cd;
460: End If;
461: If (p_rec.approval_date = hr_api.g_date) then
462: p_rec.approval_date :=
463: ben_cpg_shd.g_old_rec.approval_date;
464: End If;
465: If (p_rec.approval_comments = hr_api.g_varchar2) then

Line 465: If (p_rec.approval_comments = hr_api.g_varchar2) then

461: If (p_rec.approval_date = hr_api.g_date) then
462: p_rec.approval_date :=
463: ben_cpg_shd.g_old_rec.approval_date;
464: End If;
465: If (p_rec.approval_comments = hr_api.g_varchar2) then
466: p_rec.approval_comments :=
467: ben_cpg_shd.g_old_rec.approval_comments;
468: End If;
469: If (p_rec.submit_cd = hr_api.g_varchar2) then

Line 469: If (p_rec.submit_cd = hr_api.g_varchar2) then

465: If (p_rec.approval_comments = hr_api.g_varchar2) then
466: p_rec.approval_comments :=
467: ben_cpg_shd.g_old_rec.approval_comments;
468: End If;
469: If (p_rec.submit_cd = hr_api.g_varchar2) then
470: p_rec.submit_cd :=
471: ben_cpg_shd.g_old_rec.submit_cd;
472: End If;
473: If (p_rec.submit_date = hr_api.g_date) then

Line 473: If (p_rec.submit_date = hr_api.g_date) then

469: If (p_rec.submit_cd = hr_api.g_varchar2) then
470: p_rec.submit_cd :=
471: ben_cpg_shd.g_old_rec.submit_cd;
472: End If;
473: If (p_rec.submit_date = hr_api.g_date) then
474: p_rec.submit_date :=
475: ben_cpg_shd.g_old_rec.submit_date;
476: End If;
477: If (p_rec.submit_comments = hr_api.g_varchar2) then

Line 477: If (p_rec.submit_comments = hr_api.g_varchar2) then

473: If (p_rec.submit_date = hr_api.g_date) then
474: p_rec.submit_date :=
475: ben_cpg_shd.g_old_rec.submit_date;
476: End If;
477: If (p_rec.submit_comments = hr_api.g_varchar2) then
478: p_rec.submit_comments :=
479: ben_cpg_shd.g_old_rec.submit_comments;
480: End If;
481: If (p_rec.dist_bdgt_val = hr_api.g_number) then

Line 481: If (p_rec.dist_bdgt_val = hr_api.g_number) then

477: If (p_rec.submit_comments = hr_api.g_varchar2) then
478: p_rec.submit_comments :=
479: ben_cpg_shd.g_old_rec.submit_comments;
480: End If;
481: If (p_rec.dist_bdgt_val = hr_api.g_number) then
482: p_rec.dist_bdgt_val :=
483: ben_cpg_shd.g_old_rec.dist_bdgt_val;
484: End If;
485: If (p_rec.ws_bdgt_val = hr_api.g_number) then

Line 485: If (p_rec.ws_bdgt_val = hr_api.g_number) then

481: If (p_rec.dist_bdgt_val = hr_api.g_number) then
482: p_rec.dist_bdgt_val :=
483: ben_cpg_shd.g_old_rec.dist_bdgt_val;
484: End If;
485: If (p_rec.ws_bdgt_val = hr_api.g_number) then
486: p_rec.ws_bdgt_val :=
487: ben_cpg_shd.g_old_rec.ws_bdgt_val;
488: End If;
489: If (p_rec.rsrv_val = hr_api.g_number) then

Line 489: If (p_rec.rsrv_val = hr_api.g_number) then

485: If (p_rec.ws_bdgt_val = hr_api.g_number) then
486: p_rec.ws_bdgt_val :=
487: ben_cpg_shd.g_old_rec.ws_bdgt_val;
488: End If;
489: If (p_rec.rsrv_val = hr_api.g_number) then
490: p_rec.rsrv_val :=
491: ben_cpg_shd.g_old_rec.rsrv_val;
492: End If;
493: If (p_rec.dist_bdgt_mn_val = hr_api.g_number) then

Line 493: If (p_rec.dist_bdgt_mn_val = hr_api.g_number) then

489: If (p_rec.rsrv_val = hr_api.g_number) then
490: p_rec.rsrv_val :=
491: ben_cpg_shd.g_old_rec.rsrv_val;
492: End If;
493: If (p_rec.dist_bdgt_mn_val = hr_api.g_number) then
494: p_rec.dist_bdgt_mn_val :=
495: ben_cpg_shd.g_old_rec.dist_bdgt_mn_val;
496: End If;
497: If (p_rec.dist_bdgt_mx_val = hr_api.g_number) then

Line 497: If (p_rec.dist_bdgt_mx_val = hr_api.g_number) then

493: If (p_rec.dist_bdgt_mn_val = hr_api.g_number) then
494: p_rec.dist_bdgt_mn_val :=
495: ben_cpg_shd.g_old_rec.dist_bdgt_mn_val;
496: End If;
497: If (p_rec.dist_bdgt_mx_val = hr_api.g_number) then
498: p_rec.dist_bdgt_mx_val :=
499: ben_cpg_shd.g_old_rec.dist_bdgt_mx_val;
500: End If;
501: If (p_rec.dist_bdgt_incr_val = hr_api.g_number) then

Line 501: If (p_rec.dist_bdgt_incr_val = hr_api.g_number) then

497: If (p_rec.dist_bdgt_mx_val = hr_api.g_number) then
498: p_rec.dist_bdgt_mx_val :=
499: ben_cpg_shd.g_old_rec.dist_bdgt_mx_val;
500: End If;
501: If (p_rec.dist_bdgt_incr_val = hr_api.g_number) then
502: p_rec.dist_bdgt_incr_val :=
503: ben_cpg_shd.g_old_rec.dist_bdgt_incr_val;
504: End If;
505: If (p_rec.ws_bdgt_mn_val = hr_api.g_number) then

Line 505: If (p_rec.ws_bdgt_mn_val = hr_api.g_number) then

501: If (p_rec.dist_bdgt_incr_val = hr_api.g_number) then
502: p_rec.dist_bdgt_incr_val :=
503: ben_cpg_shd.g_old_rec.dist_bdgt_incr_val;
504: End If;
505: If (p_rec.ws_bdgt_mn_val = hr_api.g_number) then
506: p_rec.ws_bdgt_mn_val :=
507: ben_cpg_shd.g_old_rec.ws_bdgt_mn_val;
508: End If;
509: If (p_rec.ws_bdgt_mx_val = hr_api.g_number) then

Line 509: If (p_rec.ws_bdgt_mx_val = hr_api.g_number) then

505: If (p_rec.ws_bdgt_mn_val = hr_api.g_number) then
506: p_rec.ws_bdgt_mn_val :=
507: ben_cpg_shd.g_old_rec.ws_bdgt_mn_val;
508: End If;
509: If (p_rec.ws_bdgt_mx_val = hr_api.g_number) then
510: p_rec.ws_bdgt_mx_val :=
511: ben_cpg_shd.g_old_rec.ws_bdgt_mx_val;
512: End If;
513: If (p_rec.ws_bdgt_incr_val = hr_api.g_number) then

Line 513: If (p_rec.ws_bdgt_incr_val = hr_api.g_number) then

509: If (p_rec.ws_bdgt_mx_val = hr_api.g_number) then
510: p_rec.ws_bdgt_mx_val :=
511: ben_cpg_shd.g_old_rec.ws_bdgt_mx_val;
512: End If;
513: If (p_rec.ws_bdgt_incr_val = hr_api.g_number) then
514: p_rec.ws_bdgt_incr_val :=
515: ben_cpg_shd.g_old_rec.ws_bdgt_incr_val;
516: End If;
517: If (p_rec.rsrv_mn_val = hr_api.g_number) then

Line 517: If (p_rec.rsrv_mn_val = hr_api.g_number) then

513: If (p_rec.ws_bdgt_incr_val = hr_api.g_number) then
514: p_rec.ws_bdgt_incr_val :=
515: ben_cpg_shd.g_old_rec.ws_bdgt_incr_val;
516: End If;
517: If (p_rec.rsrv_mn_val = hr_api.g_number) then
518: p_rec.rsrv_mn_val :=
519: ben_cpg_shd.g_old_rec.rsrv_mn_val;
520: End If;
521: If (p_rec.rsrv_mx_val = hr_api.g_number) then

Line 521: If (p_rec.rsrv_mx_val = hr_api.g_number) then

517: If (p_rec.rsrv_mn_val = hr_api.g_number) then
518: p_rec.rsrv_mn_val :=
519: ben_cpg_shd.g_old_rec.rsrv_mn_val;
520: End If;
521: If (p_rec.rsrv_mx_val = hr_api.g_number) then
522: p_rec.rsrv_mx_val :=
523: ben_cpg_shd.g_old_rec.rsrv_mx_val;
524: End If;
525: If (p_rec.rsrv_incr_val = hr_api.g_number) then

Line 525: If (p_rec.rsrv_incr_val = hr_api.g_number) then

521: If (p_rec.rsrv_mx_val = hr_api.g_number) then
522: p_rec.rsrv_mx_val :=
523: ben_cpg_shd.g_old_rec.rsrv_mx_val;
524: End If;
525: If (p_rec.rsrv_incr_val = hr_api.g_number) then
526: p_rec.rsrv_incr_val :=
527: ben_cpg_shd.g_old_rec.rsrv_incr_val;
528: End If;
529: If (p_rec.dist_bdgt_iss_val = hr_api.g_number) then

Line 529: If (p_rec.dist_bdgt_iss_val = hr_api.g_number) then

525: If (p_rec.rsrv_incr_val = hr_api.g_number) then
526: p_rec.rsrv_incr_val :=
527: ben_cpg_shd.g_old_rec.rsrv_incr_val;
528: End If;
529: If (p_rec.dist_bdgt_iss_val = hr_api.g_number) then
530: p_rec.dist_bdgt_iss_val :=
531: ben_cpg_shd.g_old_rec.dist_bdgt_iss_val;
532: End If;
533: If (p_rec.ws_bdgt_iss_val = hr_api.g_number) then

Line 533: If (p_rec.ws_bdgt_iss_val = hr_api.g_number) then

529: If (p_rec.dist_bdgt_iss_val = hr_api.g_number) then
530: p_rec.dist_bdgt_iss_val :=
531: ben_cpg_shd.g_old_rec.dist_bdgt_iss_val;
532: End If;
533: If (p_rec.ws_bdgt_iss_val = hr_api.g_number) then
534: p_rec.ws_bdgt_iss_val :=
535: ben_cpg_shd.g_old_rec.ws_bdgt_iss_val;
536: End If;
537: If (p_rec.dist_bdgt_iss_date = hr_api.g_date) then

Line 537: If (p_rec.dist_bdgt_iss_date = hr_api.g_date) then

533: If (p_rec.ws_bdgt_iss_val = hr_api.g_number) then
534: p_rec.ws_bdgt_iss_val :=
535: ben_cpg_shd.g_old_rec.ws_bdgt_iss_val;
536: End If;
537: If (p_rec.dist_bdgt_iss_date = hr_api.g_date) then
538: p_rec.dist_bdgt_iss_date :=
539: ben_cpg_shd.g_old_rec.dist_bdgt_iss_date;
540: End If;
541: If (p_rec.ws_bdgt_iss_date = hr_api.g_date) then

Line 541: If (p_rec.ws_bdgt_iss_date = hr_api.g_date) then

537: If (p_rec.dist_bdgt_iss_date = hr_api.g_date) then
538: p_rec.dist_bdgt_iss_date :=
539: ben_cpg_shd.g_old_rec.dist_bdgt_iss_date;
540: End If;
541: If (p_rec.ws_bdgt_iss_date = hr_api.g_date) then
542: p_rec.ws_bdgt_iss_date :=
543: ben_cpg_shd.g_old_rec.ws_bdgt_iss_date;
544: End If;
545: If (p_rec.ws_bdgt_val_last_upd_date = hr_api.g_date) then

Line 545: If (p_rec.ws_bdgt_val_last_upd_date = hr_api.g_date) then

541: If (p_rec.ws_bdgt_iss_date = hr_api.g_date) then
542: p_rec.ws_bdgt_iss_date :=
543: ben_cpg_shd.g_old_rec.ws_bdgt_iss_date;
544: End If;
545: If (p_rec.ws_bdgt_val_last_upd_date = hr_api.g_date) then
546: p_rec.ws_bdgt_val_last_upd_date :=
547: ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_date;
548: End If;
549: If (p_rec.dist_bdgt_val_last_upd_date = hr_api.g_date) then

Line 549: If (p_rec.dist_bdgt_val_last_upd_date = hr_api.g_date) then

545: If (p_rec.ws_bdgt_val_last_upd_date = hr_api.g_date) then
546: p_rec.ws_bdgt_val_last_upd_date :=
547: ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_date;
548: End If;
549: If (p_rec.dist_bdgt_val_last_upd_date = hr_api.g_date) then
550: p_rec.dist_bdgt_val_last_upd_date :=
551: ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_date;
552: End If;
553: If (p_rec.rsrv_val_last_upd_date = hr_api.g_date) then

Line 553: If (p_rec.rsrv_val_last_upd_date = hr_api.g_date) then

549: If (p_rec.dist_bdgt_val_last_upd_date = hr_api.g_date) then
550: p_rec.dist_bdgt_val_last_upd_date :=
551: ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_date;
552: End If;
553: If (p_rec.rsrv_val_last_upd_date = hr_api.g_date) then
554: p_rec.rsrv_val_last_upd_date :=
555: ben_cpg_shd.g_old_rec.rsrv_val_last_upd_date;
556: End If;
557: If (p_rec.ws_bdgt_val_last_upd_by = hr_api.g_number) then

Line 557: If (p_rec.ws_bdgt_val_last_upd_by = hr_api.g_number) then

553: If (p_rec.rsrv_val_last_upd_date = hr_api.g_date) then
554: p_rec.rsrv_val_last_upd_date :=
555: ben_cpg_shd.g_old_rec.rsrv_val_last_upd_date;
556: End If;
557: If (p_rec.ws_bdgt_val_last_upd_by = hr_api.g_number) then
558: p_rec.ws_bdgt_val_last_upd_by :=
559: ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_by;
560: End If;
561: If (p_rec.dist_bdgt_val_last_upd_by = hr_api.g_number) then

Line 561: If (p_rec.dist_bdgt_val_last_upd_by = hr_api.g_number) then

557: If (p_rec.ws_bdgt_val_last_upd_by = hr_api.g_number) then
558: p_rec.ws_bdgt_val_last_upd_by :=
559: ben_cpg_shd.g_old_rec.ws_bdgt_val_last_upd_by;
560: End If;
561: If (p_rec.dist_bdgt_val_last_upd_by = hr_api.g_number) then
562: p_rec.dist_bdgt_val_last_upd_by :=
563: ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_by;
564: End If;
565: If (p_rec.rsrv_val_last_upd_by = hr_api.g_number) then

Line 565: If (p_rec.rsrv_val_last_upd_by = hr_api.g_number) then

561: If (p_rec.dist_bdgt_val_last_upd_by = hr_api.g_number) then
562: p_rec.dist_bdgt_val_last_upd_by :=
563: ben_cpg_shd.g_old_rec.dist_bdgt_val_last_upd_by;
564: End If;
565: If (p_rec.rsrv_val_last_upd_by = hr_api.g_number) then
566: p_rec.rsrv_val_last_upd_by :=
567: ben_cpg_shd.g_old_rec.rsrv_val_last_upd_by;
568: End If;
569: --

Line 635: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

631: (p_group_per_in_ler_id in number
632: ,p_group_pl_id in number
633: ,p_group_oipl_id in number
634: ,p_object_version_number in out nocopy number
635: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
636: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
637: ,p_due_dt in date default hr_api.g_date
638: ,p_access_cd in varchar2 default hr_api.g_varchar2
639: ,p_approval_cd in varchar2 default hr_api.g_varchar2

Line 636: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2

632: ,p_group_pl_id in number
633: ,p_group_oipl_id in number
634: ,p_object_version_number in out nocopy number
635: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
636: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
637: ,p_due_dt in date default hr_api.g_date
638: ,p_access_cd in varchar2 default hr_api.g_varchar2
639: ,p_approval_cd in varchar2 default hr_api.g_varchar2
640: ,p_approval_date in date default hr_api.g_date

Line 637: ,p_due_dt in date default hr_api.g_date

633: ,p_group_oipl_id in number
634: ,p_object_version_number in out nocopy number
635: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
636: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
637: ,p_due_dt in date default hr_api.g_date
638: ,p_access_cd in varchar2 default hr_api.g_varchar2
639: ,p_approval_cd in varchar2 default hr_api.g_varchar2
640: ,p_approval_date in date default hr_api.g_date
641: ,p_approval_comments in varchar2 default hr_api.g_varchar2

Line 638: ,p_access_cd in varchar2 default hr_api.g_varchar2

634: ,p_object_version_number in out nocopy number
635: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
636: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
637: ,p_due_dt in date default hr_api.g_date
638: ,p_access_cd in varchar2 default hr_api.g_varchar2
639: ,p_approval_cd in varchar2 default hr_api.g_varchar2
640: ,p_approval_date in date default hr_api.g_date
641: ,p_approval_comments in varchar2 default hr_api.g_varchar2
642: ,p_submit_cd in varchar2 default hr_api.g_varchar2

Line 639: ,p_approval_cd in varchar2 default hr_api.g_varchar2

635: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
636: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
637: ,p_due_dt in date default hr_api.g_date
638: ,p_access_cd in varchar2 default hr_api.g_varchar2
639: ,p_approval_cd in varchar2 default hr_api.g_varchar2
640: ,p_approval_date in date default hr_api.g_date
641: ,p_approval_comments in varchar2 default hr_api.g_varchar2
642: ,p_submit_cd in varchar2 default hr_api.g_varchar2
643: ,p_submit_date in date default hr_api.g_date

Line 640: ,p_approval_date in date default hr_api.g_date

636: ,p_bdgt_pop_cd in varchar2 default hr_api.g_varchar2
637: ,p_due_dt in date default hr_api.g_date
638: ,p_access_cd in varchar2 default hr_api.g_varchar2
639: ,p_approval_cd in varchar2 default hr_api.g_varchar2
640: ,p_approval_date in date default hr_api.g_date
641: ,p_approval_comments in varchar2 default hr_api.g_varchar2
642: ,p_submit_cd in varchar2 default hr_api.g_varchar2
643: ,p_submit_date in date default hr_api.g_date
644: ,p_submit_comments in varchar2 default hr_api.g_varchar2

Line 641: ,p_approval_comments in varchar2 default hr_api.g_varchar2

637: ,p_due_dt in date default hr_api.g_date
638: ,p_access_cd in varchar2 default hr_api.g_varchar2
639: ,p_approval_cd in varchar2 default hr_api.g_varchar2
640: ,p_approval_date in date default hr_api.g_date
641: ,p_approval_comments in varchar2 default hr_api.g_varchar2
642: ,p_submit_cd in varchar2 default hr_api.g_varchar2
643: ,p_submit_date in date default hr_api.g_date
644: ,p_submit_comments in varchar2 default hr_api.g_varchar2
645: ,p_dist_bdgt_val in number default hr_api.g_number

Line 642: ,p_submit_cd in varchar2 default hr_api.g_varchar2

638: ,p_access_cd in varchar2 default hr_api.g_varchar2
639: ,p_approval_cd in varchar2 default hr_api.g_varchar2
640: ,p_approval_date in date default hr_api.g_date
641: ,p_approval_comments in varchar2 default hr_api.g_varchar2
642: ,p_submit_cd in varchar2 default hr_api.g_varchar2
643: ,p_submit_date in date default hr_api.g_date
644: ,p_submit_comments in varchar2 default hr_api.g_varchar2
645: ,p_dist_bdgt_val in number default hr_api.g_number
646: ,p_ws_bdgt_val in number default hr_api.g_number

Line 643: ,p_submit_date in date default hr_api.g_date

639: ,p_approval_cd in varchar2 default hr_api.g_varchar2
640: ,p_approval_date in date default hr_api.g_date
641: ,p_approval_comments in varchar2 default hr_api.g_varchar2
642: ,p_submit_cd in varchar2 default hr_api.g_varchar2
643: ,p_submit_date in date default hr_api.g_date
644: ,p_submit_comments in varchar2 default hr_api.g_varchar2
645: ,p_dist_bdgt_val in number default hr_api.g_number
646: ,p_ws_bdgt_val in number default hr_api.g_number
647: ,p_rsrv_val in number default hr_api.g_number

Line 644: ,p_submit_comments in varchar2 default hr_api.g_varchar2

640: ,p_approval_date in date default hr_api.g_date
641: ,p_approval_comments in varchar2 default hr_api.g_varchar2
642: ,p_submit_cd in varchar2 default hr_api.g_varchar2
643: ,p_submit_date in date default hr_api.g_date
644: ,p_submit_comments in varchar2 default hr_api.g_varchar2
645: ,p_dist_bdgt_val in number default hr_api.g_number
646: ,p_ws_bdgt_val in number default hr_api.g_number
647: ,p_rsrv_val in number default hr_api.g_number
648: ,p_dist_bdgt_mn_val in number default hr_api.g_number

Line 645: ,p_dist_bdgt_val in number default hr_api.g_number

641: ,p_approval_comments in varchar2 default hr_api.g_varchar2
642: ,p_submit_cd in varchar2 default hr_api.g_varchar2
643: ,p_submit_date in date default hr_api.g_date
644: ,p_submit_comments in varchar2 default hr_api.g_varchar2
645: ,p_dist_bdgt_val in number default hr_api.g_number
646: ,p_ws_bdgt_val in number default hr_api.g_number
647: ,p_rsrv_val in number default hr_api.g_number
648: ,p_dist_bdgt_mn_val in number default hr_api.g_number
649: ,p_dist_bdgt_mx_val in number default hr_api.g_number

Line 646: ,p_ws_bdgt_val in number default hr_api.g_number

642: ,p_submit_cd in varchar2 default hr_api.g_varchar2
643: ,p_submit_date in date default hr_api.g_date
644: ,p_submit_comments in varchar2 default hr_api.g_varchar2
645: ,p_dist_bdgt_val in number default hr_api.g_number
646: ,p_ws_bdgt_val in number default hr_api.g_number
647: ,p_rsrv_val in number default hr_api.g_number
648: ,p_dist_bdgt_mn_val in number default hr_api.g_number
649: ,p_dist_bdgt_mx_val in number default hr_api.g_number
650: ,p_dist_bdgt_incr_val in number default hr_api.g_number

Line 647: ,p_rsrv_val in number default hr_api.g_number

643: ,p_submit_date in date default hr_api.g_date
644: ,p_submit_comments in varchar2 default hr_api.g_varchar2
645: ,p_dist_bdgt_val in number default hr_api.g_number
646: ,p_ws_bdgt_val in number default hr_api.g_number
647: ,p_rsrv_val in number default hr_api.g_number
648: ,p_dist_bdgt_mn_val in number default hr_api.g_number
649: ,p_dist_bdgt_mx_val in number default hr_api.g_number
650: ,p_dist_bdgt_incr_val in number default hr_api.g_number
651: ,p_ws_bdgt_mn_val in number default hr_api.g_number

Line 648: ,p_dist_bdgt_mn_val in number default hr_api.g_number

644: ,p_submit_comments in varchar2 default hr_api.g_varchar2
645: ,p_dist_bdgt_val in number default hr_api.g_number
646: ,p_ws_bdgt_val in number default hr_api.g_number
647: ,p_rsrv_val in number default hr_api.g_number
648: ,p_dist_bdgt_mn_val in number default hr_api.g_number
649: ,p_dist_bdgt_mx_val in number default hr_api.g_number
650: ,p_dist_bdgt_incr_val in number default hr_api.g_number
651: ,p_ws_bdgt_mn_val in number default hr_api.g_number
652: ,p_ws_bdgt_mx_val in number default hr_api.g_number

Line 649: ,p_dist_bdgt_mx_val in number default hr_api.g_number

645: ,p_dist_bdgt_val in number default hr_api.g_number
646: ,p_ws_bdgt_val in number default hr_api.g_number
647: ,p_rsrv_val in number default hr_api.g_number
648: ,p_dist_bdgt_mn_val in number default hr_api.g_number
649: ,p_dist_bdgt_mx_val in number default hr_api.g_number
650: ,p_dist_bdgt_incr_val in number default hr_api.g_number
651: ,p_ws_bdgt_mn_val in number default hr_api.g_number
652: ,p_ws_bdgt_mx_val in number default hr_api.g_number
653: ,p_ws_bdgt_incr_val in number default hr_api.g_number

Line 650: ,p_dist_bdgt_incr_val in number default hr_api.g_number

646: ,p_ws_bdgt_val in number default hr_api.g_number
647: ,p_rsrv_val in number default hr_api.g_number
648: ,p_dist_bdgt_mn_val in number default hr_api.g_number
649: ,p_dist_bdgt_mx_val in number default hr_api.g_number
650: ,p_dist_bdgt_incr_val in number default hr_api.g_number
651: ,p_ws_bdgt_mn_val in number default hr_api.g_number
652: ,p_ws_bdgt_mx_val in number default hr_api.g_number
653: ,p_ws_bdgt_incr_val in number default hr_api.g_number
654: ,p_rsrv_mn_val in number default hr_api.g_number

Line 651: ,p_ws_bdgt_mn_val in number default hr_api.g_number

647: ,p_rsrv_val in number default hr_api.g_number
648: ,p_dist_bdgt_mn_val in number default hr_api.g_number
649: ,p_dist_bdgt_mx_val in number default hr_api.g_number
650: ,p_dist_bdgt_incr_val in number default hr_api.g_number
651: ,p_ws_bdgt_mn_val in number default hr_api.g_number
652: ,p_ws_bdgt_mx_val in number default hr_api.g_number
653: ,p_ws_bdgt_incr_val in number default hr_api.g_number
654: ,p_rsrv_mn_val in number default hr_api.g_number
655: ,p_rsrv_mx_val in number default hr_api.g_number

Line 652: ,p_ws_bdgt_mx_val in number default hr_api.g_number

648: ,p_dist_bdgt_mn_val in number default hr_api.g_number
649: ,p_dist_bdgt_mx_val in number default hr_api.g_number
650: ,p_dist_bdgt_incr_val in number default hr_api.g_number
651: ,p_ws_bdgt_mn_val in number default hr_api.g_number
652: ,p_ws_bdgt_mx_val in number default hr_api.g_number
653: ,p_ws_bdgt_incr_val in number default hr_api.g_number
654: ,p_rsrv_mn_val in number default hr_api.g_number
655: ,p_rsrv_mx_val in number default hr_api.g_number
656: ,p_rsrv_incr_val in number default hr_api.g_number

Line 653: ,p_ws_bdgt_incr_val in number default hr_api.g_number

649: ,p_dist_bdgt_mx_val in number default hr_api.g_number
650: ,p_dist_bdgt_incr_val in number default hr_api.g_number
651: ,p_ws_bdgt_mn_val in number default hr_api.g_number
652: ,p_ws_bdgt_mx_val in number default hr_api.g_number
653: ,p_ws_bdgt_incr_val in number default hr_api.g_number
654: ,p_rsrv_mn_val in number default hr_api.g_number
655: ,p_rsrv_mx_val in number default hr_api.g_number
656: ,p_rsrv_incr_val in number default hr_api.g_number
657: ,p_dist_bdgt_iss_val in number default hr_api.g_number

Line 654: ,p_rsrv_mn_val in number default hr_api.g_number

650: ,p_dist_bdgt_incr_val in number default hr_api.g_number
651: ,p_ws_bdgt_mn_val in number default hr_api.g_number
652: ,p_ws_bdgt_mx_val in number default hr_api.g_number
653: ,p_ws_bdgt_incr_val in number default hr_api.g_number
654: ,p_rsrv_mn_val in number default hr_api.g_number
655: ,p_rsrv_mx_val in number default hr_api.g_number
656: ,p_rsrv_incr_val in number default hr_api.g_number
657: ,p_dist_bdgt_iss_val in number default hr_api.g_number
658: ,p_ws_bdgt_iss_val in number default hr_api.g_number

Line 655: ,p_rsrv_mx_val in number default hr_api.g_number

651: ,p_ws_bdgt_mn_val in number default hr_api.g_number
652: ,p_ws_bdgt_mx_val in number default hr_api.g_number
653: ,p_ws_bdgt_incr_val in number default hr_api.g_number
654: ,p_rsrv_mn_val in number default hr_api.g_number
655: ,p_rsrv_mx_val in number default hr_api.g_number
656: ,p_rsrv_incr_val in number default hr_api.g_number
657: ,p_dist_bdgt_iss_val in number default hr_api.g_number
658: ,p_ws_bdgt_iss_val in number default hr_api.g_number
659: ,p_dist_bdgt_iss_date in date default hr_api.g_date

Line 656: ,p_rsrv_incr_val in number default hr_api.g_number

652: ,p_ws_bdgt_mx_val in number default hr_api.g_number
653: ,p_ws_bdgt_incr_val in number default hr_api.g_number
654: ,p_rsrv_mn_val in number default hr_api.g_number
655: ,p_rsrv_mx_val in number default hr_api.g_number
656: ,p_rsrv_incr_val in number default hr_api.g_number
657: ,p_dist_bdgt_iss_val in number default hr_api.g_number
658: ,p_ws_bdgt_iss_val in number default hr_api.g_number
659: ,p_dist_bdgt_iss_date in date default hr_api.g_date
660: ,p_ws_bdgt_iss_date in date default hr_api.g_date

Line 657: ,p_dist_bdgt_iss_val in number default hr_api.g_number

653: ,p_ws_bdgt_incr_val in number default hr_api.g_number
654: ,p_rsrv_mn_val in number default hr_api.g_number
655: ,p_rsrv_mx_val in number default hr_api.g_number
656: ,p_rsrv_incr_val in number default hr_api.g_number
657: ,p_dist_bdgt_iss_val in number default hr_api.g_number
658: ,p_ws_bdgt_iss_val in number default hr_api.g_number
659: ,p_dist_bdgt_iss_date in date default hr_api.g_date
660: ,p_ws_bdgt_iss_date in date default hr_api.g_date
661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date

Line 658: ,p_ws_bdgt_iss_val in number default hr_api.g_number

654: ,p_rsrv_mn_val in number default hr_api.g_number
655: ,p_rsrv_mx_val in number default hr_api.g_number
656: ,p_rsrv_incr_val in number default hr_api.g_number
657: ,p_dist_bdgt_iss_val in number default hr_api.g_number
658: ,p_ws_bdgt_iss_val in number default hr_api.g_number
659: ,p_dist_bdgt_iss_date in date default hr_api.g_date
660: ,p_ws_bdgt_iss_date in date default hr_api.g_date
661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date

Line 659: ,p_dist_bdgt_iss_date in date default hr_api.g_date

655: ,p_rsrv_mx_val in number default hr_api.g_number
656: ,p_rsrv_incr_val in number default hr_api.g_number
657: ,p_dist_bdgt_iss_val in number default hr_api.g_number
658: ,p_ws_bdgt_iss_val in number default hr_api.g_number
659: ,p_dist_bdgt_iss_date in date default hr_api.g_date
660: ,p_ws_bdgt_iss_date in date default hr_api.g_date
661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
663: ,p_rsrv_val_last_upd_date in date default hr_api.g_date

Line 660: ,p_ws_bdgt_iss_date in date default hr_api.g_date

656: ,p_rsrv_incr_val in number default hr_api.g_number
657: ,p_dist_bdgt_iss_val in number default hr_api.g_number
658: ,p_ws_bdgt_iss_val in number default hr_api.g_number
659: ,p_dist_bdgt_iss_date in date default hr_api.g_date
660: ,p_ws_bdgt_iss_date in date default hr_api.g_date
661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
663: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
664: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number

Line 661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date

657: ,p_dist_bdgt_iss_val in number default hr_api.g_number
658: ,p_ws_bdgt_iss_val in number default hr_api.g_number
659: ,p_dist_bdgt_iss_date in date default hr_api.g_date
660: ,p_ws_bdgt_iss_date in date default hr_api.g_date
661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
663: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
664: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
665: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number

Line 662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date

658: ,p_ws_bdgt_iss_val in number default hr_api.g_number
659: ,p_dist_bdgt_iss_date in date default hr_api.g_date
660: ,p_ws_bdgt_iss_date in date default hr_api.g_date
661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
663: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
664: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
665: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
666: ,p_rsrv_val_last_upd_by in number default hr_api.g_number

Line 663: ,p_rsrv_val_last_upd_date in date default hr_api.g_date

659: ,p_dist_bdgt_iss_date in date default hr_api.g_date
660: ,p_ws_bdgt_iss_date in date default hr_api.g_date
661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
663: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
664: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
665: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
666: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
667: ) is

Line 664: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number

660: ,p_ws_bdgt_iss_date in date default hr_api.g_date
661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
663: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
664: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
665: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
666: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
667: ) is
668: --

Line 665: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number

661: ,p_ws_bdgt_val_last_upd_date in date default hr_api.g_date
662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
663: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
664: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
665: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
666: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
667: ) is
668: --
669: l_rec ben_cpg_shd.g_rec_type;

Line 666: ,p_rsrv_val_last_upd_by in number default hr_api.g_number

662: ,p_dist_bdgt_val_last_upd_date in date default hr_api.g_date
663: ,p_rsrv_val_last_upd_date in date default hr_api.g_date
664: ,p_ws_bdgt_val_last_upd_by in number default hr_api.g_number
665: ,p_dist_bdgt_val_last_upd_by in number default hr_api.g_number
666: ,p_rsrv_val_last_upd_by in number default hr_api.g_number
667: ) is
668: --
669: l_rec ben_cpg_shd.g_rec_type;
670: l_proc varchar2(72) := g_package||'upd';