[Home] [Help]
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: per_anc_shd.g_api_dml := true; -- Set the api dml status
62: --
148: );
149: --
150: per_anc_shd.g_api_dml := false; -- Unset the api dml status
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: per_anc_shd.g_api_dml := false; -- Unset the api dml status
214: --
215: Cursor C_Sel1 is select per_analysis_criteria_s.nextval from sys.dual;
216: --
217: Begin
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: -- Select the next sequence number
221: --
222: Open C_Sel1;
229: p_rec.enabled_flag := 'Y';
230: p_rec.start_date_active := null;
231: p_rec.end_date_active := null;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: End pre_insert;
235: --
236: -- ----------------------------------------------------------------------------
237: -- |-----------------------------< post_insert >------------------------------|
269: --
270: l_proc varchar2(72) := g_package||'post_insert';
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 10);
276: End post_insert;
277: --
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 10);
276: End post_insert;
277: --
278: -- ----------------------------------------------------------------------------
279: -- |---------------------------------< ins >----------------------------------|
286: --
287: l_proc varchar2(72) := g_package||'ins';
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- Determine if the business process is to be validated.
293: --
294: If p_validate then
319: If p_validate then
320: Raise HR_Api.Validate_Enabled;
321: End If;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: Exception
325: When HR_Api.Validate_Enabled Then
326: --
327: -- As the Validate_Enabled exception has been raised
381: l_rec per_anc_shd.g_rec_type;
382: l_proc varchar2(72) := g_package||'ins';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- Call conversion function to turn arguments into the
388: -- p_rec structure.
389: --
443: --
444: p_analysis_criteria_id := l_rec.analysis_criteria_id;
445: --
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 10);
448: End ins;
449: --
450: -- ----------------------------------------------------------------------------
451: -- |-------------------------------< ins_or_sel >-----------------------------|
489: l_analysis_criteria_id number;
490: l_proc varchar2(72) := g_package||'ins_or_sel';
491: --
492: begin
493: hr_utility.set_location('Entering:'||l_proc, 5);
494: --
495: -- determine if a people group combination exists
496: --
497: per_anc_shd.segment_combination_check
538: -- null The segment combination is null
539: -- id A segment combination has been found
540: --
541: if (l_analysis_criteria_id = -1) then
542: hr_utility.set_location(l_proc, 10);
543: --
544: -- a new combination needs to be inserted
545: --
546: per_anc_ins.ins
597: -- we return the primary key as nulls
598: --
599: p_analysis_criteria_id := null;
600: end if;
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: end ins_or_sel;
603: --
604: end per_anc_ins;