65: l_object_version_number ben_dpnt_cvrd_othr_pgm_rt_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);
70: --
71: -- Issue a savepoint if operating in validation only mode
72: --
73: savepoint create_DPNT_CVRD_OTHR_PGM_RT;
71: -- Issue a savepoint if operating in validation only mode
72: --
73: savepoint create_DPNT_CVRD_OTHR_PGM_RT;
74: --
75: hr_utility.set_location(l_proc, 20);
76: --
77: -- Process Logic
78: --
79: begin
250: p_base_table_reference_column => 'RT_DPNT_CVRD_PGM_FLAG',
251: p_reference_table => 'BEN_DPNT_CVRD_OTHR_PGM_RT_F',
252: p_reference_table_column => 'VRBL_RT_PRFL_ID');
253: --
254: hr_utility.set_location(l_proc, 60);
255: --
256: -- When in validation only mode raise the Validate_Enabled exception
257: --
258: if p_validate then
265: p_effective_start_date := l_effective_start_date;
266: p_effective_end_date := l_effective_end_date;
267: p_object_version_number := l_object_version_number;
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 70);
270: --
271: exception
272: --
273: when hr_api.validate_enabled then
284: p_dpnt_cvrd_othr_pgm_rt_id := null;
285: p_effective_start_date := null;
286: p_effective_end_date := null;
287: p_object_version_number := null;
288: hr_utility.set_location(' Leaving:'||l_proc, 80);
289: --
290: when others then
291: --
292: -- A validation or unexpected error has occured
362: l_effective_end_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_end_date%TYPE;
363: --
364: begin
365: --
366: hr_utility.set_location('Entering:'|| l_proc, 10);
367: --
368: -- Issue a savepoint if operating in validation only mode
369: --
370: savepoint update_DPNT_CVRD_OTHR_PGM_RT;
368: -- Issue a savepoint if operating in validation only mode
369: --
370: savepoint update_DPNT_CVRD_OTHR_PGM_RT;
371: --
372: hr_utility.set_location(l_proc, 20);
373: --
374: -- Process Logic
375: --
376: l_object_version_number := p_object_version_number;
544: -- End of API User Hook for the after hook of update_DPNT_CVRD_OTHR_PGM_RT
545: --
546: end;
547: --
548: hr_utility.set_location(l_proc, 60);
549: --
550: -- When in validation only mode raise the Validate_Enabled exception
551: --
552: if p_validate then
558: p_object_version_number := l_object_version_number;
559: p_effective_start_date := l_effective_start_date;
560: p_effective_end_date := l_effective_end_date;
561: --
562: hr_utility.set_location(' Leaving:'||l_proc, 70);
563: --
564: exception
565: --
566: when hr_api.validate_enabled then
578: -- Only set output warning arguments
579: -- (Any key or derived arguments must be set to null
580: -- when validation only mode is being used.)
581: --
582: hr_utility.set_location(' Leaving:'||l_proc, 80);
583: --
584: when others then
585: --
586: -- A validation or unexpected error has occured
616: l_effective_end_date ben_dpnt_cvrd_othr_pgm_rt_f.effective_end_date%TYPE;
617: --
618: begin
619: --
620: hr_utility.set_location('Entering:'|| l_proc, 10);
621: --
622: -- Issue a savepoint if operating in validation only mode
623: --
624: savepoint delete_DPNT_CVRD_OTHR_PGM_RT;
622: -- Issue a savepoint if operating in validation only mode
623: --
624: savepoint delete_DPNT_CVRD_OTHR_PGM_RT;
625: --
626: hr_utility.set_location(l_proc, 20);
627: --
628: -- Process Logic
629: --
630: l_object_version_number := p_object_version_number;
694: p_base_table_reference_column => 'RT_DPNT_CVRD_PGM_FLAG',
695: p_reference_table => 'BEN_DPNT_CVRD_OTHR_PGM_RT_F',
696: p_reference_table_column => 'VRBL_RT_PRFL_ID');
697: --
698: hr_utility.set_location(l_proc, 60);
699: --
700: -- When in validation only mode raise the Validate_Enabled exception
701: --
702: if p_validate then
702: if p_validate then
703: raise hr_api.validate_enabled;
704: end if;
705: --
706: hr_utility.set_location(' Leaving:'||l_proc, 70);
707: --
708: exception
709: --
710: when hr_api.validate_enabled then
757: l_validation_end_date date;
758: --
759: begin
760: --
761: hr_utility.set_location('Entering:'|| l_proc, 10);
762: --
763: ben_dop_shd.lck
764: (
765: p_dpnt_cvrd_othr_pgm_rt_id => p_dpnt_cvrd_othr_pgm_rt_id
769: ,p_effective_date => p_effective_date
770: ,p_datetrack_mode => p_datetrack_mode
771: );
772: --
773: hr_utility.set_location(' Leaving:'||l_proc, 70);
774: --
775: end lck;
776: --
777: end ben_DPNT_CVRD_OTHR_PGM_RT_api;