DBA Data[Home] [Help]

APPS.IRC_IAD_INS dependencies on IRC_IAD_SHD

Line 80: (p_rec in out nocopy irc_iad_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy irc_iad_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

Line 94: irc_iad_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from irc_assignment_details_f t
92: where t.assignment_id = p_rec.assignment_id
93: and t.effective_start_date =
94: irc_iad_shd.g_old_rec.effective_start_date
95: and (t.effective_end_date = (p_validation_start_date - 1)
96: or t.effective_end_date = irc_iad_shd.g_old_rec.effective_end_date);
97: --
98: -- Cursor to get the new Details Version number

Line 96: or t.effective_end_date = irc_iad_shd.g_old_rec.effective_end_date);

92: where t.assignment_id = p_rec.assignment_id
93: and t.effective_start_date =
94: irc_iad_shd.g_old_rec.effective_start_date
95: and (t.effective_end_date = (p_validation_start_date - 1)
96: or t.effective_end_date = irc_iad_shd.g_old_rec.effective_end_date);
97: --
98: -- Cursor to get the new Details Version number
99: Cursor c_details_version is
100: select nvl(max(details_version), 0)+1

Line 218: irc_iad_shd.constraint_error

214: Exception
215: When hr_api.check_integrity_violated Then
216: -- A check constraint has been violated
217: --
218: irc_iad_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: --

Line 223: irc_iad_shd.constraint_error

219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: --
223: irc_iad_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When Others Then
226: --
227: Raise;

Line 234: (p_rec in out nocopy irc_iad_shd.g_rec_type

230: -- ----------------------------------------------------------------------------
231: -- |------------------------------< insert_dml >------------------------------|
232: -- ----------------------------------------------------------------------------
233: Procedure insert_dml
234: (p_rec in out nocopy irc_iad_shd.g_rec_type
235: ,p_effective_date in date
236: ,p_datetrack_mode in varchar2
237: ,p_validation_start_date in date
238: ,p_validation_end_date in date

Line 297: (p_rec in out nocopy irc_iad_shd.g_rec_type

293: --
294: -- {End Of Comments}
295: -- ----------------------------------------------------------------------------
296: Procedure pre_insert
297: (p_rec in out nocopy irc_iad_shd.g_rec_type
298: ,p_effective_date in date
299: ,p_datetrack_mode in varchar2
300: ,p_validation_start_date in date
301: ,p_validation_end_date in date

Line 389: (p_rec in irc_iad_shd.g_rec_type

385: --
386: -- {End Of Comments}
387: -- ----------------------------------------------------------------------------
388: Procedure post_insert
389: (p_rec in irc_iad_shd.g_rec_type
390: ,p_effective_date in date
391: ,p_datetrack_mode in varchar2
392: ,p_validation_start_date in date
393: ,p_validation_end_date in date

Line 483: ,p_rec in irc_iad_shd.g_rec_type

479: -- ----------------------------------------------------------------------------
480: Procedure ins_lck
481: (p_effective_date in date
482: ,p_datetrack_mode in varchar2
483: ,p_rec in irc_iad_shd.g_rec_type
484: ,p_validation_start_date out nocopy date
485: ,p_validation_end_date out nocopy date
486: ) is
487: --

Line 526: ,p_rec in out nocopy irc_iad_shd.g_rec_type

522: -- |---------------------------------< ins >----------------------------------|
523: -- ----------------------------------------------------------------------------
524: Procedure ins
525: (p_effective_date in date
526: ,p_rec in out nocopy irc_iad_shd.g_rec_type
527: ) is
528: --
529: l_proc varchar2(72) := g_package||'ins';
530: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 613: l_rec irc_iad_shd.g_rec_type;

609: ,p_effective_end_date out nocopy date
610: ,p_object_version_number out nocopy number
611: ) is
612: --
613: l_rec irc_iad_shd.g_rec_type;
614: l_proc varchar2(72) := g_package||'ins';
615: --
616: Begin
617: hr_utility.set_location('Entering:'||l_proc, 5);

Line 623: irc_iad_shd.convert_args

619: -- Call conversion function to turn arguments into the
620: -- p_rec structure.
621: --
622: l_rec :=
623: irc_iad_shd.convert_args
624: (null
625: ,p_assignment_id
626: ,null
627: ,null