[Home] [Help]
45: l_proc varchar2(80) := g_package||'check_dpnt_ctfn';
46: --
47: begin
48: --
49: hr_utility.set_location('Entering '||l_proc, 10);
50: --
51: open dpnt_c;
52: fetch dpnt_c into l_dpnt;
53: close dpnt_c;
77: ,p_rslt_object_version_number => l_dpnt.rslt_ovn);
78: --
79: end if;
80: --
81: hr_utility.set_location('Leaving '||l_proc, 10);
82: --
83: end check_dpnt_ctfn;
84: --
85: -- ----------------------------------------------------------------------------
155: pdp.effective_start_date and pdp.effective_end_date;
156: --
157: begin
158: --
159: hr_utility.set_location('Entering:'|| l_proc, 10);
160: --
161: -- Initialize environment
162: --
163: if fnd_global.conc_request_id = -1 then
176: -- Issue a savepoint if operating in validation only mode
177: --
178: savepoint create_CVRD_DPNT_CTFN_PRVDD;
179: --
180: hr_utility.set_location(l_proc, 20);
181: --
182: if p_prtt_enrt_actn_id is null then
183: --
184: open c_pdp;
377: -- End of API User Hook for the after hook of create_CVRD_DPNT_CTFN_PRVDD
378: --
379: end;
380: --
381: hr_utility.set_location(l_proc, 60);
382: --
383: -- When in validation only mode raise the Validate_Enabled exception
384: --
385: if p_validate then
392: p_effective_start_date := l_effective_start_date;
393: p_effective_end_date := l_effective_end_date;
394: p_object_version_number := l_object_version_number;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 70);
397: --
398: exception
399: --
400: when hr_api.validate_enabled then
411: p_cvrd_dpnt_ctfn_prvdd_id := null;
412: p_effective_start_date := null;
413: p_effective_end_date := null;
414: p_object_version_number := null;
415: hr_utility.set_location(' Leaving:'||l_proc, 80);
416: --
417: when others then
418: --
419: -- A validation or unexpected error has occured
485: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
486: --
487: begin
488: --
489: hr_utility.set_location('Entering:'|| l_proc, 10);
490: --
491: -- Initialize environment
492: --
493: if fnd_global.conc_request_id = -1 then
506: -- Issue a savepoint if operating in validation only mode
507: --
508: savepoint update_CVRD_DPNT_CTFN_PRVDD;
509: --
510: hr_utility.set_location(l_proc, 20);
511: --
512: -- Process Logic
513: --
514: l_object_version_number := p_object_version_number;
699: -- End of API User Hook for the after hook of update_CVRD_DPNT_CTFN_PRVDD
700: --
701: end;
702: --
703: hr_utility.set_location(l_proc, 60);
704: --
705: -- When in validation only mode raise the Validate_Enabled exception
706: --
707: if p_validate then
713: p_object_version_number := l_object_version_number;
714: p_effective_start_date := l_effective_start_date;
715: p_effective_end_date := l_effective_end_date;
716: --
717: hr_utility.set_location(' Leaving:'||l_proc, 70);
718: --
719: exception
720: --
721: when hr_api.validate_enabled then
728: -- Only set output warning arguments
729: -- (Any key or derived arguments must be set to null
730: -- when validation only mode is being used.)
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 80);
733: --
734: when others then
735: --
736: -- A validation or unexpected error has occured
805: pen.effective_start_date and pen.effective_end_date;
806: --
807: begin
808: --
809: hr_utility.set_location('Entering:'|| l_proc, 10);
810: --
811: -- Initialize environment
812: --
813: if fnd_global.conc_request_id = -1 then
826: -- Issue a savepoint if operating in validation only mode
827: --
828: savepoint delete_CVRD_DPNT_CTFN_PRVDD;
829: --
830: hr_utility.set_location(l_proc, 20);
831: --
832: -- Process Logic
833: --
834: l_object_version_number := p_object_version_number;
944: -- End of API User Hook for the after hook of delete_CVRD_DPNT_CTFN_PRVDD
945: --
946: end;
947: --
948: hr_utility.set_location(l_proc, 60);
949: --
950: -- When in validation only mode raise the Validate_Enabled exception
951: --
952: if p_validate then
952: if p_validate then
953: raise hr_api.validate_enabled;
954: end if;
955: --
956: hr_utility.set_location(' Leaving:'||l_proc, 70);
957: --
958: exception
959: --
960: when hr_api.validate_enabled then
1050: --
1051: l_unsuspend_enrt_flag varchar2(30) := 'Y' ;
1052: begin
1053: --
1054: hr_utility.set_location('Entering:'|| l_proc, 10);
1055: --
1056: -- Initialize environment
1057: --
1058: if fnd_global.conc_request_id = -1 then
1071: -- Issue a savepoint if operating in validation only mode
1072: --
1073: savepoint delete_CVRD_DPNT_CTFN_PRVDD;
1074: --
1075: hr_utility.set_location(l_proc, 20);
1076: --
1077: -- Process Logic
1078: --
1079: l_object_version_number := p_object_version_number;
1193: -- End of API User Hook for the after hook of delete_CVRD_DPNT_CTFN_PRVDD
1194: --
1195: end;
1196: --
1197: hr_utility.set_location(l_proc, 60);
1198: --
1199: -- When in validation only mode raise the Validate_Enabled exception
1200: --
1201: if p_validate then
1201: if p_validate then
1202: raise hr_api.validate_enabled;
1203: end if;
1204: --
1205: hr_utility.set_location(' Leaving:'||l_proc, 70);
1206: --
1207: exception
1208: --
1209: when hr_api.validate_enabled then
1254: l_validation_end_date date;
1255: --
1256: begin
1257: --
1258: hr_utility.set_location('Entering:'|| l_proc, 10);
1259: --
1260: ben_ccp_shd.lck
1261: (
1262: p_cvrd_dpnt_ctfn_prvdd_id => p_cvrd_dpnt_ctfn_prvdd_id
1266: ,p_effective_date => p_effective_date
1267: ,p_datetrack_mode => p_datetrack_mode
1268: );
1269: --
1270: hr_utility.set_location(' Leaving:'||l_proc, 70);
1271: --
1272: end lck;
1273: --
1274: end ben_CVRD_DPNT_CTFN_PRVDD_api;