49: -- Internal Table Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out nocopy hr_scl_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
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: --
63: -- Insert the row into: hr_soft_coding_keyflex
64: --
65: insert into hr_soft_coding_keyflex
148: p_rec.segment29,
149: p_rec.segment30
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
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
159: hr_scl_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
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
159: hr_scl_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
159: hr_scl_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
164: hr_scl_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
164: hr_scl_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
164: hr_scl_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
169: hr_scl_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
169: hr_scl_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
168: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
169: hr_scl_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
174: End insert_dml;
175: --
176: -- ----------------------------------------------------------------------------
209: -- Internal Table Handler Use Only.
210: --
211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure pre_insert(p_rec in out nocopy hr_scl_shd.g_rec_type) is
214: --
215: l_proc varchar2(72) := g_package||'pre_insert';
216: --
217: Cursor C_Sel1 is select hr_soft_coding_keyflex_s.nextval from sys.dual;
307: -- Internal Table Handler Use Only.
308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure post_insert(p_rec in hr_scl_shd.g_rec_type) is
312: --
313: l_proc varchar2(72) := g_package||'post_insert';
314: --
315: Begin
321: -- ----------------------------------------------------------------------------
322: -- |---------------------------------< ins >----------------------------------|
323: -- ----------------------------------------------------------------------------
324: Procedure ins
325: (p_rec in out nocopy hr_scl_shd.g_rec_type,
326: p_validate in boolean default false) is
327: --
328: l_proc varchar2(72) := g_package||'ins';
329: --
419: p_segment30 in varchar2 default null,
420: p_validate in boolean default false
421: ) is
422: --
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);
429: -- Call conversion function to turn arguments into the
430: -- p_rec structure.
431: --
432: l_rec :=
433: hr_scl_shd.convert_args
434: (
435: null,
436: null,
437: p_request_id,
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
547: (p_segment1 => p_segment1,
548: p_segment2 => p_segment2,
549: p_segment3 => p_segment3,
550: p_segment4 => p_segment4,