APPS.IRC_CMM_INS dependencies on IRC_CMM_SHD

Line 76: (p_rec in out nocopy irc_cmm_shd.g_rec_type

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

Line 125: irc_cmm_shd.constraint_error

121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: --
125: irc_cmm_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: --

Line 130: irc_cmm_shd.constraint_error

126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: --
130: irc_cmm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: --

Line 135: irc_cmm_shd.constraint_error

131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: --
135: irc_cmm_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: --
139: Raise;

Line 180: (p_rec in out nocopy irc_cmm_shd.g_rec_type

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure pre_insert
180: (p_rec in out nocopy irc_cmm_shd.g_rec_type
181: ) is
182: --
183: Cursor C_Sel1 is select irc_comm_messages_s.nextval from sys.dual;
184: --

Line 268: ,p_rec in irc_cmm_shd.g_rec_type

264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: Procedure post_insert
267: (p_effective_date in date
268: ,p_rec in irc_cmm_shd.g_rec_type
269: ) is
270: --
271: l_proc varchar2(72) := g_package||'post_insert';
272: --

Line 323: ,p_rec in out nocopy irc_cmm_shd.g_rec_type

319: -- |---------------------------------< ins >----------------------------------|
320: -- ----------------------------------------------------------------------------
321: Procedure ins
322: (p_effective_date in date
323: ,p_rec in out nocopy irc_cmm_shd.g_rec_type
324: ) is
325: --
326: l_proc varchar2(72) := g_package||'ins';
327: --

Line 381: l_rec irc_cmm_shd.g_rec_type;

377: ,p_communication_message_id out nocopy number
378: ,p_object_version_number out nocopy number
379: ) is
380: --
381: l_rec irc_cmm_shd.g_rec_type;
382: l_proc varchar2(72) := g_package||'ins';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);

Line 391: irc_cmm_shd.convert_args

387: -- Call conversion function to turn arguments into the
388: -- p_rec structure.
389: --
390: l_rec :=
391: irc_cmm_shd.convert_args
392: (null
393: ,p_parent_id
394: ,p_communication_topic_id
395: ,p_message_subject