[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
771: --
772: -- {End Of Comments}
773: -- ----------------------------------------------------------------------------
774: Procedure post_insert
775: (p_rec in per_spp_shd.g_rec_type
776: ,p_effective_date in date
777: ,p_datetrack_mode in varchar2
778: ,p_validation_start_date in date
779: ,p_validation_end_date in date
930: -- ----------------------------------------------------------------------------
931: Procedure ins_lck
932: (p_effective_date in date
933: ,p_datetrack_mode in varchar2
934: ,p_rec in per_spp_shd.g_rec_type
935: ,p_validation_start_date out nocopy date
936: ,p_validation_end_date out nocopy date
937: ) is
938: --
1032: -- |---------------------------------< ins >----------------------------------|
1033: -- ----------------------------------------------------------------------------
1034: Procedure ins
1035: (p_effective_date in date
1036: ,p_rec in out nocopy per_spp_shd.g_rec_type
1037: ,p_replace_future_spp in boolean -- Added for bug 2977842.
1038: ) is
1039: --
1040: l_proc varchar2(72) := g_package||'ins';
1165: ,p_effective_end_date out nocopy date
1166: ,p_replace_future_spp in boolean -- Added bug 2977842.
1167: ) is
1168: --
1169: l_rec per_spp_shd.g_rec_type;
1170: l_proc varchar2(72) := g_package||'ins';
1171: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
1172: --
1173: cursor chk_step_valid_for_grade is
1204: -- Call conversion function to turn arguments into the
1205: -- p_rec structure.
1206: --
1207: l_rec :=
1208: per_spp_shd.convert_args
1209: (null
1210: ,null
1211: ,null
1212: ,p_business_group_id