APPS.IRC_APA_INS dependencies on IRC_APA_SHD

Line 76: (p_rec in out nocopy irc_apa_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy irc_apa_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 107: irc_apa_shd.constraint_error

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

Line 112: irc_apa_shd.constraint_error

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

Line 117: irc_apa_shd.constraint_error

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

Line 162: (p_rec in out nocopy irc_apa_shd.g_rec_type

158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_insert
162: (p_rec in out nocopy irc_apa_shd.g_rec_type
163: ) is
164: --
165: Cursor C_Sel1 is select irc_apl_profile_access_s.nextval from sys.dual;
166: --

Line 249: (p_rec in irc_apa_shd.g_rec_type

245: --
246: -- {End Of Comments}
247: -- ----------------------------------------------------------------------------
248: Procedure post_insert
249: (p_rec in irc_apa_shd.g_rec_type
250: ) is
251: --
252: l_proc varchar2(72) := g_package||'post_insert';
253: --

Line 284: (p_rec in out nocopy irc_apa_shd.g_rec_type

280: -- ----------------------------------------------------------------------------
281: -- |---------------------------------< ins >----------------------------------|
282: -- ----------------------------------------------------------------------------
283: Procedure ins
284: (p_rec in out nocopy irc_apa_shd.g_rec_type
285: ) is
286: --
287: l_proc varchar2(72) := g_package||'ins';
288: --

Line 330: l_rec irc_apa_shd.g_rec_type;

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

Line 340: irc_apa_shd.convert_args

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