[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy irc_irf_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_referral_info t
91: where t.referral_info_id = p_rec.referral_info_id
92: and t.start_date =
93: irc_irf_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_irf_shd.get_object_version_number
122: (p_referral_info_id => p_rec.referral_info_id
123: );
124: --
125: -- Select the 'old' created values
251: Exception
252: When hr_api.check_integrity_violated Then
253: -- A check constraint has been violated
254: --
255: irc_irf_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated
259: --
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated
259: --
260: irc_irf_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: --
264: Raise;
267: -- ----------------------------------------------------------------------------
268: -- |------------------------------< insert_dml >------------------------------|
269: -- ----------------------------------------------------------------------------
270: Procedure insert_dml
271: (p_rec in out nocopy irc_irf_shd.g_rec_type
272: ,p_effective_date in date
273: ,p_datetrack_mode in varchar2
274: ,p_validation_start_date in date
275: ,p_validation_end_date in date
330: --
331: -- {End Of Comments}
332: -- ----------------------------------------------------------------------------
333: Procedure pre_insert
334: (p_rec in out nocopy irc_irf_shd.g_rec_type
335: ,p_effective_date in date
336: ,p_datetrack_mode in varchar2
337: ,p_validation_start_date in date
338: ,p_validation_end_date in date
424: --
425: -- {End Of Comments}
426: -- ----------------------------------------------------------------------------
427: Procedure post_insert
428: (p_rec in irc_irf_shd.g_rec_type
429: ,p_effective_date in date
430: ,p_datetrack_mode in varchar2
431: ,p_validation_start_date in date
432: ,p_validation_end_date in date
540: -- ----------------------------------------------------------------------------
541: Procedure ins_lck
542: (p_effective_date in date
543: ,p_datetrack_mode in varchar2
544: ,p_rec in irc_irf_shd.g_rec_type
545: ,p_validation_start_date out nocopy date
546: ,p_validation_end_date out nocopy date
547: ) is
548: --
572: -- |---------------------------------< ins >----------------------------------|
573: -- ----------------------------------------------------------------------------
574: Procedure ins
575: (p_effective_date in date
576: ,p_rec in out nocopy irc_irf_shd.g_rec_type
577: ) is
578: --
579: l_proc varchar2(72) := g_package||'ins';
580: l_datetrack_mode varchar2(30) := hr_api.g_insert;
693: ,p_start_date out nocopy date
694: ,p_end_date out nocopy date
695: ) is
696: --
697: l_rec irc_irf_shd.g_rec_type;
698: l_proc varchar2(72) := g_package||'ins';
699: --
700: Begin
701: hr_utility.set_location('Entering:'||l_proc, 5);
703: -- Call conversion function to turn arguments into the
704: -- p_rec structure.
705: --
706: l_rec :=
707: irc_irf_shd.convert_args
708: (null
709: ,p_object_id
710: ,p_object_type
711: ,p_start_date