APPS.OTA_CRE_INS dependencies on OTA_CRE_SHD

Line 76: (p_rec in out nocopy ota_cre_shd.g_rec_type

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

Line 171: ota_cre_shd.constraint_error

167: Exception
168: When hr_api.check_integrity_violated Then
169: -- A check constraint has been violated
170: --
171: ota_cre_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: --

Line 176: ota_cre_shd.constraint_error

172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: --
176: ota_cre_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: --

Line 181: ota_cre_shd.constraint_error

177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: --
181: ota_cre_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When Others Then
184: --
185: Raise;

Line 226: (p_rec in out nocopy ota_cre_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure pre_insert
226: (p_rec in out nocopy ota_cre_shd.g_rec_type
227: ) is
228: --
229: Cursor C_Sel1 is select ota_cert_enrollments_s.nextval from sys.dual;
230: --

Line 314: ,p_rec in ota_cre_shd.g_rec_type

310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure post_insert
313: (p_effective_date in date
314: ,p_rec in ota_cre_shd.g_rec_type
315: ) is
316: --
317: l_proc varchar2(72) := g_package||'post_insert';
318: --

Line 413: ,p_rec in out nocopy ota_cre_shd.g_rec_type

409: -- |---------------------------------< ins >----------------------------------|
410: -- ----------------------------------------------------------------------------
411: Procedure ins
412: (p_effective_date in date
413: ,p_rec in out nocopy ota_cre_shd.g_rec_type
414: ) is
415: --
416: l_proc varchar2(72) := g_package||'ins';
417: --

Line 494: l_rec ota_cre_shd.g_rec_type;

490: ,p_object_version_number out nocopy number
491: ,p_is_automatic_subscription in varchar2 default 'N'
492: ) is
493: --
494: l_rec ota_cre_shd.g_rec_type;
495: l_proc varchar2(72) := g_package||'ins';
496: --
497: Begin
498: hr_utility.set_location('Entering:'||l_proc, 5);

Line 504: ota_cre_shd.convert_args

500: -- Call conversion function to turn arguments into the
501: -- p_rec structure.
502: --
503: l_rec :=
504: ota_cre_shd.convert_args
505: (null
506: ,p_certification_id
507: ,p_person_id
508: ,p_contact_id