DBA Data[Home] [Help]

APPS.IRC_CMP_INS dependencies on IRC_CMP_SHD

Line 76: (p_rec in out nocopy irc_cmp_shd.g_rec_type

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

Line 163: irc_cmp_shd.constraint_error

159: Exception
160: When hr_api.check_integrity_violated Then
161: -- A check constraint has been violated
162: --
163: irc_cmp_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.parent_integrity_violated Then
166: -- Parent integrity has been violated
167: --

Line 168: irc_cmp_shd.constraint_error

164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.parent_integrity_violated Then
166: -- Parent integrity has been violated
167: --
168: irc_cmp_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --

Line 173: irc_cmp_shd.constraint_error

169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --
173: irc_cmp_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When Others Then
176: --
177: Raise;

Line 218: (p_rec in out nocopy irc_cmp_shd.g_rec_type

214: --
215: -- {End Of Comments}
216: -- ----------------------------------------------------------------------------
217: Procedure pre_insert
218: (p_rec in out nocopy irc_cmp_shd.g_rec_type
219: ) is
220: --
221: Cursor C_Sel1 is select irc_comm_properties_s.nextval from sys.dual;
222: --

Line 306: ,p_rec in irc_cmp_shd.g_rec_type

302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure post_insert
305: (p_effective_date in date
306: ,p_rec in irc_cmp_shd.g_rec_type
307: ) is
308: --
309: l_proc varchar2(72) := g_package||'post_insert';
310: --

Line 399: ,p_rec in out nocopy irc_cmp_shd.g_rec_type

395: -- |---------------------------------< ins >----------------------------------|
396: -- ----------------------------------------------------------------------------
397: Procedure ins
398: (p_effective_date in date
399: ,p_rec in out nocopy irc_cmp_shd.g_rec_type
400: ) is
401: --
402: l_proc varchar2(72) := g_package||'ins';
403: --

Line 476: l_rec irc_cmp_shd.g_rec_type;

472: ,p_communication_property_id out nocopy number
473: ,p_object_version_number out nocopy number
474: ) is
475: --
476: l_rec irc_cmp_shd.g_rec_type;
477: l_proc varchar2(72) := g_package||'ins';
478: --
479: Begin
480: hr_utility.set_location('Entering:'||l_proc, 5);

Line 486: irc_cmp_shd.convert_args

482: -- Call conversion function to turn arguments into the
483: -- p_rec structure.
484: --
485: l_rec :=
486: irc_cmp_shd.convert_args
487: (null
488: ,p_object_type
489: ,p_object_id
490: ,p_default_comm_status