APPS.OTA_COI_INS dependencies on OTA_COI_SHD

Line 82: (p_rec in out nocopy ota_coi_shd.g_rec_type

78: --
79: -- {End Of Comments}
80: -- ----------------------------------------------------------------------------
81: Procedure insert_dml
82: (p_rec in out nocopy ota_coi_shd.g_rec_type
83: ) is
84: --
85: l_proc varchar2(72) := g_package||'insert_dml';
86: --

Line 121: ota_coi_shd.constraint_error

117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: ota_coi_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --

Line 126: ota_coi_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --
126: ota_coi_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --

Line 131: ota_coi_shd.constraint_error

127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --
131: ota_coi_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: --
135: Raise;

Line 176: (p_rec in out nocopy ota_coi_shd.g_rec_type

172: --
173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure pre_insert
176: (p_rec in out nocopy ota_coi_shd.g_rec_type
177: ) is
178: --
179: -- Cursor C_Sel1 is select ota_chat_obj_inclusions_s.nextval from sys.dual;
180: --

Line 233: ,p_rec in ota_coi_shd.g_rec_type

229: -- {End Of Comments}
230: -- ----------------------------------------------------------------------------
231: Procedure post_insert
232: (p_effective_date in date
233: ,p_rec in ota_coi_shd.g_rec_type
234: ) is
235: --
236: l_proc varchar2(72) := g_package||'post_insert';
237: --

Line 278: ,p_rec in out nocopy ota_coi_shd.g_rec_type

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

Line 346: l_rec ota_coi_shd.g_rec_type;

342: ,p_primary_flag in varchar2 default null
343: ,p_object_version_number out nocopy number
344: ) is
345: --
346: l_rec ota_coi_shd.g_rec_type;
347: l_proc varchar2(72) := g_package||'ins';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);

Line 356: ota_coi_shd.convert_args

352: -- Call conversion function to turn arguments into the
353: -- p_rec structure.
354: --
355: l_rec :=
356: ota_coi_shd.convert_args
357: (p_chat_id
358: ,p_object_id
359: ,p_object_type
360: ,p_start_date_active