[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: hr_scl_shd.g_api_dml := true; -- Set the api dml status
62: --
150: );
151: --
152: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
216: --
217: Cursor C_Sel1 is select hr_soft_coding_keyflex_s.nextval from sys.dual;
218: --
219: Begin
220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: --
223: -- Select the next sequence number
224: --
272: p_segment28 => p_rec.segment28,
273: p_segment29 => p_rec.segment29,
274: p_segment30 => p_rec.segment30);
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: End pre_insert;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |-----------------------------< post_insert >------------------------------|
312: --
313: l_proc varchar2(72) := g_package||'post_insert';
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: End post_insert;
320: --
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: End post_insert;
320: --
321: -- ----------------------------------------------------------------------------
322: -- |---------------------------------< ins >----------------------------------|
327: --
328: l_proc varchar2(72) := g_package||'ins';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- Determine if the business process is to be validated.
334: --
335: If p_validate then
360: If p_validate then
361: Raise HR_Api.Validate_Enabled;
362: End If;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: Exception
366: When HR_Api.Validate_Enabled Then
367: --
368: -- As the Validate_Enabled exception has been raised
423: l_rec hr_scl_shd.g_rec_type;
424: l_proc varchar2(72) := g_package||'ins';
425: --
426: Begin
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: --
429: -- Call conversion function to turn arguments into the
430: -- p_rec structure.
431: --
485: --
486: p_soft_coding_keyflex_id := l_rec.soft_coding_keyflex_id;
487: p_concatenated_segments := l_rec.concatenated_segments;
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 10);
490: End ins;
491: --
492: --
493: -- ----------------------------------------------------------------------------
538: l_id_flex_num hr_soft_coding_keyflex.id_flex_num%type;
539: l_proc varchar2(72) := g_package||'ins_or_sel';
540: --
541: begin
542: hr_utility.set_location('Entering:'||l_proc, 5);
543: --
544: -- determine if a people group combination exists
545: --
546: hr_scl_shd.segment_combination_check
588: -- null The segment combination is null
589: -- id A segment combination has been found
590: --
591: if (l_soft_coding_keyflex_id = -1) then
592: hr_utility.set_location(l_proc, 10);
593: --
594: -- a new combination needs to be inserted
595: --
596: hr_scl_ins.ins
650: --
651: p_soft_coding_keyflex_id := null;
652: p_concatenated_segments := null;
653: end if;
654: hr_utility.set_location(' Leaving:'||l_proc, 10);
655: end ins_or_sel;
656: --
657: end hr_scl_ins;