[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pqh_gin_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 pqh_fr_global_indices_f t
92: where t.global_index_id = p_rec.global_index_id
93: and t.effective_start_date =
94: pqh_gin_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 pqh_fr_global_indices_f.created_by%TYPE;
196: Exception
197: When hr_api.check_integrity_violated Then
198: -- A check constraint has been violated
199: --
200: pqh_gin_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: --
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: --
205: pqh_gin_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: --
209: Raise;
212: -- ----------------------------------------------------------------------------
213: -- |------------------------------< insert_dml >------------------------------|
214: -- ----------------------------------------------------------------------------
215: Procedure insert_dml
216: (p_rec in out nocopy pqh_gin_shd.g_rec_type
217: ,p_effective_date in date
218: ,p_datetrack_mode in varchar2
219: ,p_validation_start_date in date
220: ,p_validation_end_date in date
275: --
276: -- {End Of Comments}
277: -- ----------------------------------------------------------------------------
278: Procedure pre_insert
279: (p_rec in out nocopy pqh_gin_shd.g_rec_type
280: ,p_effective_date in date
281: ,p_datetrack_mode in varchar2
282: ,p_validation_start_date in date
283: ,p_validation_end_date in date
367: --
368: -- {End Of Comments}
369: -- ----------------------------------------------------------------------------
370: Procedure post_insert
371: (p_rec in pqh_gin_shd.g_rec_type
372: ,p_effective_date in date
373: ,p_datetrack_mode in varchar2
374: ,p_validation_start_date in date
375: ,p_validation_end_date in date
461: -- ----------------------------------------------------------------------------
462: Procedure ins_lck
463: (p_effective_date in date
464: ,p_datetrack_mode in varchar2
465: ,p_rec in pqh_gin_shd.g_rec_type
466: ,p_validation_start_date out nocopy date
467: ,p_validation_end_date out nocopy date
468: ) is
469: --
501: -- |---------------------------------< ins >----------------------------------|
502: -- ----------------------------------------------------------------------------
503: Procedure ins
504: (p_effective_date in date
505: ,p_rec in out nocopy pqh_gin_shd.g_rec_type
506: ) is
507: --
508: l_proc varchar2(72) := g_package||'ins';
509: l_datetrack_mode varchar2(30) := hr_api.g_insert;
588: ,p_effective_start_date out nocopy date
589: ,p_effective_end_date out nocopy date
590: ) is
591: --
592: l_rec pqh_gin_shd.g_rec_type;
593: l_proc varchar2(72) := g_package||'ins';
594: --
595: Begin
596: hr_utility.set_location('Entering:'||l_proc, 5);
598: -- Call conversion function to turn arguments into the
599: -- p_rec structure.
600: --
601: l_rec :=
602: pqh_gin_shd.convert_args
603: (null
604: ,null
605: ,null
606: ,p_type_of_record