APPS.OTA_CMB_INS dependencies on OTA_CMB_SHD

Line 76: (p_rec in out nocopy ota_cmb_shd.g_rec_type

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

Line 161: ota_cmb_shd.constraint_error

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

Line 166: ota_cmb_shd.constraint_error

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

Line 171: ota_cmb_shd.constraint_error

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

Line 216: (p_rec in out nocopy ota_cmb_shd.g_rec_type

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

Line 304: ,p_rec in ota_cmb_shd.g_rec_type

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

Line 395: ,p_rec in out nocopy ota_cmb_shd.g_rec_type

391: -- |---------------------------------< ins >----------------------------------|
392: -- ----------------------------------------------------------------------------
393: Procedure ins
394: (p_effective_date in date
395: ,p_rec in out nocopy ota_cmb_shd.g_rec_type
396: ) is
397: --
398: l_proc varchar2(72) := g_package||'ins';
399: --

Line 471: l_rec ota_cmb_shd.g_rec_type;

467: ,p_certification_member_id out nocopy number
468: ,p_object_version_number out nocopy number
469: ) is
470: --
471: l_rec ota_cmb_shd.g_rec_type;
472: l_proc varchar2(72) := g_package||'ins';
473: --
474: Begin
475: hr_utility.set_location('Entering:'||l_proc, 5);

Line 481: ota_cmb_shd.convert_args

477: -- Call conversion function to turn arguments into the
478: -- p_rec structure.
479: --
480: l_rec :=
481: ota_cmb_shd.convert_args
482: (null
483: ,p_certification_id
484: ,p_object_id
485: ,p_object_type