[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy per_spp_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
68: t.creation_date
69: from per_spinal_point_placements_f t
70: where t.placement_id = p_rec.placement_id
71: and t.effective_start_date =
72: per_spp_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by per_spinal_point_placements_f.created_by%TYPE;
126: l_last_updated_by := fnd_global.user_id;
127: l_last_update_login := fnd_global.login_id;
128: End If;
129: --
130: per_spp_shd.g_api_dml := true; -- Set the api dml status
131: --
132: -- Insert the row into: per_spinal_point_placements_f
133: --
134: insert into per_spinal_point_placements_f
237: ,l_last_updated_by
238: ,l_last_update_login
239: );
240: --
241: per_spp_shd.g_api_dml := false; -- Unset the api dml status
242: hr_utility.set_location(' Leaving:'||l_proc, 15);
243: --
244: Exception
245: When hr_api.check_integrity_violated Then
243: --
244: Exception
245: When hr_api.check_integrity_violated Then
246: -- A check constraint has been violated
247: per_spp_shd.g_api_dml := false; -- Unset the api dml status
248: per_spp_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.unique_integrity_violated Then
251: -- Unique integrity has been violated
244: Exception
245: When hr_api.check_integrity_violated Then
246: -- A check constraint has been violated
247: per_spp_shd.g_api_dml := false; -- Unset the api dml status
248: per_spp_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.unique_integrity_violated Then
251: -- Unique integrity has been violated
252: per_spp_shd.g_api_dml := false; -- Unset the api dml status
248: per_spp_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.unique_integrity_violated Then
251: -- Unique integrity has been violated
252: per_spp_shd.g_api_dml := false; -- Unset the api dml status
253: per_spp_shd.constraint_error
254: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
255: When Others Then
256: per_spp_shd.g_api_dml := false; -- Unset the api dml status
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.unique_integrity_violated Then
251: -- Unique integrity has been violated
252: per_spp_shd.g_api_dml := false; -- Unset the api dml status
253: per_spp_shd.constraint_error
254: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
255: When Others Then
256: per_spp_shd.g_api_dml := false; -- Unset the api dml status
257: Raise;
252: per_spp_shd.g_api_dml := false; -- Unset the api dml status
253: per_spp_shd.constraint_error
254: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
255: When Others Then
256: per_spp_shd.g_api_dml := false; -- Unset the api dml status
257: Raise;
258: End dt_insert_dml;
259: --
260: -- ----------------------------------------------------------------------------
260: -- ----------------------------------------------------------------------------
261: -- |------------------------------< insert_dml >------------------------------|
262: -- ----------------------------------------------------------------------------
263: Procedure insert_dml
264: (p_rec in out nocopy per_spp_shd.g_rec_type
265: ,p_effective_date in date
266: ,p_datetrack_mode in varchar2
267: ,p_validation_start_date in date
268: ,p_validation_end_date in date
323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure pre_insert
327: (p_rec in out nocopy per_spp_shd.g_rec_type
328: ,p_effective_date in date
329: ,p_datetrack_mode in varchar2
330: ,p_validation_start_date in date
331: ,p_validation_end_date in date
769: --
770: -- {End Of Comments}
771: -- ----------------------------------------------------------------------------
772: Procedure post_insert
773: (p_rec in per_spp_shd.g_rec_type
774: ,p_effective_date in date
775: ,p_datetrack_mode in varchar2
776: ,p_validation_start_date in date
777: ,p_validation_end_date in date
900: -- ----------------------------------------------------------------------------
901: Procedure ins_lck
902: (p_effective_date in date
903: ,p_datetrack_mode in varchar2
904: ,p_rec in per_spp_shd.g_rec_type
905: ,p_validation_start_date out nocopy date
906: ,p_validation_end_date out nocopy date
907: ) is
908: --
1002: -- |---------------------------------< ins >----------------------------------|
1003: -- ----------------------------------------------------------------------------
1004: Procedure ins
1005: (p_effective_date in date
1006: ,p_rec in out nocopy per_spp_shd.g_rec_type
1007: ,p_replace_future_spp in boolean -- Added for bug 2977842.
1008: ) is
1009: --
1010: l_proc varchar2(72) := g_package||'ins';
1135: ,p_effective_end_date out nocopy date
1136: ,p_replace_future_spp in boolean -- Added bug 2977842.
1137: ) is
1138: --
1139: l_rec per_spp_shd.g_rec_type;
1140: l_proc varchar2(72) := g_package||'ins';
1141: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
1142: --
1143: cursor chk_step_valid_for_grade is
1174: -- Call conversion function to turn arguments into the
1175: -- p_rec structure.
1176: --
1177: l_rec :=
1178: per_spp_shd.convert_args
1179: (null
1180: ,null
1181: ,null
1182: ,p_business_group_id