[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy per_sps_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date
90: t.creation_date
91: from per_spinal_point_steps_f t
92: where t.step_id = p_rec.step_id
93: and t.effective_start_date =
94: per_sps_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by per_spinal_point_steps_f.created_by%TYPE;
150: Else
151: p_rec.object_version_number := 1; -- Initialise the object version
152: End If;
153: --
154: per_sps_shd.g_api_dml := true; -- Set the api dml status
155: --
156: -- Insert the row into: per_spinal_point_steps_f
157: --
158: insert into per_spinal_point_steps_f
255: ,l_last_updated_by
256: ,l_last_update_login
257: );
258: --
259: per_sps_shd.g_api_dml := false; -- Unset the api dml status
260: hr_utility.set_location(' Leaving:'||l_proc, 15);
261: --
262: Exception
263: When hr_api.check_integrity_violated Then
261: --
262: Exception
263: When hr_api.check_integrity_violated Then
264: -- A check constraint has been violated
265: per_sps_shd.g_api_dml := false; -- Unset the api dml status
266: per_sps_shd.constraint_error
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
268: When hr_api.unique_integrity_violated Then
269: -- Unique integrity has been violated
262: Exception
263: When hr_api.check_integrity_violated Then
264: -- A check constraint has been violated
265: per_sps_shd.g_api_dml := false; -- Unset the api dml status
266: per_sps_shd.constraint_error
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
268: When hr_api.unique_integrity_violated Then
269: -- Unique integrity has been violated
270: per_sps_shd.g_api_dml := false; -- Unset the api dml status
266: per_sps_shd.constraint_error
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
268: When hr_api.unique_integrity_violated Then
269: -- Unique integrity has been violated
270: per_sps_shd.g_api_dml := false; -- Unset the api dml status
271: per_sps_shd.constraint_error
272: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
273: When Others Then
274: per_sps_shd.g_api_dml := false; -- Unset the api dml status
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
268: When hr_api.unique_integrity_violated Then
269: -- Unique integrity has been violated
270: per_sps_shd.g_api_dml := false; -- Unset the api dml status
271: per_sps_shd.constraint_error
272: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
273: When Others Then
274: per_sps_shd.g_api_dml := false; -- Unset the api dml status
275: Raise;
270: per_sps_shd.g_api_dml := false; -- Unset the api dml status
271: per_sps_shd.constraint_error
272: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
273: When Others Then
274: per_sps_shd.g_api_dml := false; -- Unset the api dml status
275: Raise;
276: End dt_insert_dml;
277: --
278: -- ----------------------------------------------------------------------------
278: -- ----------------------------------------------------------------------------
279: -- |------------------------------< insert_dml >------------------------------|
280: -- ----------------------------------------------------------------------------
281: Procedure insert_dml
282: (p_rec in out nocopy per_sps_shd.g_rec_type
283: ,p_effective_date in date
284: ,p_datetrack_mode in varchar2
285: ,p_validation_start_date in date
286: ,p_validation_end_date in date
341: --
342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure pre_insert
345: (p_rec in out nocopy per_sps_shd.g_rec_type
346: ,p_effective_date in date
347: ,p_datetrack_mode in varchar2
348: ,p_validation_start_date in date
349: ,p_validation_end_date in date
433: --
434: -- {End Of Comments}
435: -- ----------------------------------------------------------------------------
436: Procedure post_insert
437: (p_rec in per_sps_shd.g_rec_type
438: ,p_effective_date in date
439: ,p_datetrack_mode in varchar2
440: ,p_validation_start_date in date
441: ,p_validation_end_date in date
675: -- ----------------------------------------------------------------------------
676: Procedure ins_lck
677: (p_effective_date in date
678: ,p_datetrack_mode in varchar2
679: ,p_rec in per_sps_shd.g_rec_type
680: ,p_validation_start_date out nocopy date
681: ,p_validation_end_date out nocopy date
682: ) is
683: --
718: -- |---------------------------------< ins >----------------------------------|
719: -- ----------------------------------------------------------------------------
720: Procedure ins
721: (p_effective_date in date
722: ,p_rec in out nocopy per_sps_shd.g_rec_type
723: ) is
724: --
725: l_proc varchar2(72) := g_package||'ins';
726: l_datetrack_mode varchar2(30) := hr_api.g_insert;
838: ,p_effective_start_date out nocopy date
839: ,p_effective_end_date out nocopy date
840: ) is
841: --
842: l_rec per_sps_shd.g_rec_type;
843: l_proc varchar2(72) := g_package||'ins';
844: --
845: Begin
846: hr_utility.set_location('Entering:'||l_proc, 5);
848: -- Call conversion function to turn arguments into the
849: -- p_rec structure.
850: --
851: l_rec :=
852: per_sps_shd.convert_args
853: (p_step_id
854: ,null
855: ,null
856: ,p_business_group_id