[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy irc_iid_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
89: select t.creation_date
90: from irc_interview_details t
91: where t.interview_details_id = p_rec.interview_details_id
92: and t.start_date =
93: irc_iid_shd.g_old_rec.start_date
94: and t.end_date = p_validation_start_date;
95: --
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
117: --
118: -- Get the object version number for the insert
119: --
120: p_rec.object_version_number :=
121: irc_iid_shd.get_object_version_number
122: (p_interview_details_id => p_rec.interview_details_id
123: );
124: --
125: -- Select the 'old' created values
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: --
229: irc_iid_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.unique_integrity_violated Then
232: -- Unique integrity has been violated
233: --
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.unique_integrity_violated Then
232: -- Unique integrity has been violated
233: --
234: irc_iid_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When Others Then
237: --
238: Raise;
241: -- ----------------------------------------------------------------------------
242: -- |------------------------------< insert_dml >------------------------------|
243: -- ----------------------------------------------------------------------------
244: Procedure insert_dml
245: (p_rec in out nocopy irc_iid_shd.g_rec_type
246: ,p_effective_date in date
247: ,p_datetrack_mode in varchar2
248: ,p_validation_start_date in date
249: ,p_validation_end_date in date
304: --
305: -- {End Of Comments}
306: -- ----------------------------------------------------------------------------
307: Procedure pre_insert
308: (p_rec in out nocopy irc_iid_shd.g_rec_type
309: ,p_effective_date in date
310: ,p_datetrack_mode in varchar2
311: ,p_validation_start_date in date
312: ,p_validation_end_date in date
398: --
399: -- {End Of Comments}
400: -- ----------------------------------------------------------------------------
401: Procedure post_insert
402: (p_rec in irc_iid_shd.g_rec_type
403: ,p_effective_date in date
404: ,p_datetrack_mode in varchar2
405: ,p_validation_start_date in date
406: ,p_validation_end_date in date
501: -- ----------------------------------------------------------------------------
502: Procedure ins_lck
503: (p_effective_date in date
504: ,p_datetrack_mode in varchar2
505: ,p_rec in irc_iid_shd.g_rec_type
506: ,p_validation_start_date out nocopy date
507: ,p_validation_end_date out nocopy date
508: ) is
509: --
534: -- |---------------------------------< ins >----------------------------------|
535: -- ----------------------------------------------------------------------------
536: Procedure ins
537: (p_effective_date in date
538: ,p_rec in out nocopy irc_iid_shd.g_rec_type
539: ) is
540: --
541: l_proc varchar2(72) := g_package||'ins';
542: l_datetrack_mode varchar2(30) := hr_api.g_insert;
643: ,p_start_date out nocopy date
644: ,p_end_date out nocopy date
645: ) is
646: --
647: l_rec irc_iid_shd.g_rec_type;
648: l_proc varchar2(72) := g_package||'ins';
649: --
650: Begin
651: hr_utility.set_location('Entering:'||l_proc, 5);
653: -- Call conversion function to turn arguments into the
654: -- p_rec structure.
655: --
656: l_rec :=
657: irc_iid_shd.convert_args
658: (null
659: ,p_status
660: ,p_feedback
661: ,p_notes