DBA Data[Home] [Help]

APPS.IRC_IVC_INS dependencies on IRC_IVC_SHD

Line 72: (p_rec in out nocopy irc_ivc_shd.g_rec_type

68: --
69: -- {End Of Comments}
70: -- ----------------------------------------------------------------------------
71: Procedure insert_dml
72: (p_rec in out nocopy irc_ivc_shd.g_rec_type
73: ) is
74: --
75: l_proc varchar2(72) := g_package||'insert_dml';
76: --

Line 109: irc_ivc_shd.constraint_error

105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
109: irc_ivc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --

Line 114: irc_ivc_shd.constraint_error

110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
114: irc_ivc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --

Line 119: irc_ivc_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: irc_ivc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;

Line 164: (p_rec in out nocopy irc_ivc_shd.g_rec_type

160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_insert
164: (p_rec in out nocopy irc_ivc_shd.g_rec_type
165: ) is
166: --
167: cursor c1 is select irc_vacancy_considerations_s.nextval from sys.dual;
168: cursor c2 is

Line 238: ,p_rec in irc_ivc_shd.g_rec_type

234: -- {End Of Comments}
235: -- ----------------------------------------------------------------------------
236: Procedure post_insert
237: (p_effective_date in date
238: ,p_rec in irc_ivc_shd.g_rec_type
239: ) is
240: --
241: l_proc varchar2(72) := g_package||'post_insert';
242: --

Line 279: ,p_rec in out nocopy irc_ivc_shd.g_rec_type

275: -- |---------------------------------< ins >----------------------------------|
276: -- ----------------------------------------------------------------------------
277: Procedure ins
278: (p_effective_date in date
279: ,p_rec in out nocopy irc_ivc_shd.g_rec_type
280: ) is
281: --
282: l_proc varchar2(72) := g_package||'ins';
283: --

Line 329: l_rec irc_ivc_shd.g_rec_type;

325: ,p_vacancy_consideration_id out nocopy number
326: ,p_object_version_number out nocopy number
327: ) is
328: --
329: l_rec irc_ivc_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);

Line 339: irc_ivc_shd.convert_args

335: -- Call conversion function to turn arguments into the
336: -- p_rec structure.
337: --
338: l_rec :=
339: irc_ivc_shd.convert_args
340: (null
341: ,p_person_id
342: ,null
343: ,p_vacancy_id