[Home] [Help]
40: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
41:
42: begin
43: --
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Issue a savepoint if operating in validation only mode
47: --
48: savepoint create_perf_score_weight;
67: Close C_Sel1;
68: --
69: -- Insert the row into: ben_elig_per_f
70: --
71: hr_utility.set_location('Insert: '||l_proc, 5);
72: insert into ben_elig_scre_wtg_f
73: (elig_scre_wtg_id
74: ,elig_per_id
75: ,elig_per_opt_id
106: ,l_creation_date
107: ,l_last_update_date
108: ,l_last_updated_by
109: );
110: hr_utility.set_location('Dn Insert: '||l_proc, 5);
111: --
112: ben_esw_shd.g_api_dml := false; -- Unset the api dml status
113: --
114: -- When in validation only mode raise the Validate_Enabled exception
123: p_effective_start_date := l_effective_start_date;
124: p_effective_end_date := l_effective_end_date;
125: p_object_version_number := l_object_version_number;
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 70);
128: --
129: exception
130: --
131: when hr_api.validate_enabled then
142: p_elig_scre_wtg_id := null;
143: p_effective_start_date := null;
144: p_effective_end_date := null;
145: p_object_version_number := null;
146: hr_utility.set_location(' Leaving:'||l_proc, 80);
147: --
148: when others then
149: --
150: -- A validation or unexpected error has occured
154: p_elig_scre_wtg_id := null;
155: p_effective_start_date := null;
156: p_effective_end_date := null;
157: p_object_version_number := null;
158: hr_utility.set_location(' Leaving:'||l_proc, 80);
159: --
160: raise;
161: --
162: end create_perf_score_weight;
181: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
182: --
183: begin
184: --
185: hr_utility.set_location('Entering:'|| l_proc, 10);
186: --
187: -- Issue a savepoint if operating in validation only mode
188: --
189: savepoint update_score_weight;
187: -- Issue a savepoint if operating in validation only mode
188: --
189: savepoint update_score_weight;
190: --
191: hr_utility.set_location(l_proc, 20);
192: --
193: -- Process Logic
194: --
195: l_object_version_number := p_object_version_number;
205: ,p_effective_date => p_effective_date
206: ,p_datetrack_mode => p_datetrack_mode
207: );
208: --
209: hr_utility.set_location(l_proc, 60);
210: --
211: -- When in validation only mode raise the Validate_Enabled exception
212: --
213: if p_validate then
219: p_object_version_number := l_object_version_number;
220: p_effective_start_date := l_effective_start_date;
221: p_effective_end_date := l_effective_end_date;
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 70);
224: --
225: exception
226: --
227: when hr_api.validate_enabled then
234: -- Only set output warning arguments
235: -- (Any key or derived arguments must be set to null
236: -- when validation only mode is being used.)
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 80);
239: --
240: when others then
241: --
242: -- A validation or unexpected error has occured
266: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
267: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
268: --
269: begin
270: hr_utility.set_location('Entering:'|| l_proc, 10);
271: --
272: -- Issue a savepoint if operating in validation only mode
273: --
274: savepoint delete_score_weight;
284: ,p_effective_date => p_effective_date
285: ,p_datetrack_mode => p_datetrack_mode
286: );
287: --
288: hr_utility.set_location(l_proc, 60);
289: --
290: -- When in validation only mode raise the Validate_Enabled exception
291: --
292: if p_validate then
293: raise hr_api.validate_enabled;
294: end if;
295: --
296: p_object_version_number := l_object_version_number;
297: hr_utility.set_location(' Leaving:'||l_proc, 70);
298: --
299: exception
300: --
301: when hr_api.validate_enabled then
364: l_proc varchar2(80) := g_package||'.load_score_weight';
365:
366: begin
367:
368: hr_utility.set_location('Entering : ' || l_proc, 10);
369: --
370: -- Bug 4438430
371: -- P_ELIG_PER_ID will be null for BEN_ELIG_PER_F records at PLIP level.
372: -- In BEN_ELIGIBLE_PERSON_PERF_API we defer creation of BEN_ELIG_PER_F records
378: if p_elig_per_id is null
379: then
380: --
381: BEN_ELIGIBLE_PERSON_PERF_API.g_pepinsplip_score_tab := p_score_tab; /* Bug 4449745 */
382: hr_utility.set_location('Defer creation of ESW Record', 9898);
383: return;
384: end if;
385: --
386: if p_score_tab.count > 0 then
383: return;
384: end if;
385: --
386: if p_score_tab.count > 0 then
387: hr_utility.set_location('wsr',11);
388: for i in 1..p_score_tab.count
389: loop
390: l_sc_wg := null;
391: open c_sc_wg(p_score_tab(i).eligy_prfl_id,
396: p_effective_date);
397: fetch c_sc_wg into l_sc_wg;
398: close c_sc_wg;
399: l_elig_scre_wtg_id := l_sc_wg.elig_scre_wtg_id;
400: hr_utility.set_location('elig_scre_wtg_id '||l_elig_scre_wtg_id,5.7);
401:
402: if l_elig_scre_wtg_id is null then
403: ben_elig_scre_wtg_api.create_perf_score_weight
404: (p_validate => false
446: ,p_object_version_number => l_sc_wg.object_version_number);
447: end if;
448: end loop;
449: end if;
450: hr_utility.set_location('Leaving : ' || l_proc, 10);
451: end load_score_weight;
452:
453: end BEN_ELIG_SCRE_WTG_API;