APPS.OTA_CCI_INS dependencies on OTA_CCI_SHD

Line 79: (p_rec in out nocopy ota_cci_shd.g_rec_type

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

Line 158: ota_cci_shd.constraint_error

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

Line 163: ota_cci_shd.constraint_error

159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.parent_integrity_violated Then
161: -- Parent integrity has been violated
162: --
163: ota_cci_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: --

Line 168: ota_cci_shd.constraint_error

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

Line 213: (p_rec in out nocopy ota_cci_shd.g_rec_type

209: --
210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: Procedure pre_insert
213: (p_rec in out nocopy ota_cci_shd.g_rec_type
214: ) is
215: --
216: /*
217: Cursor C_Sel1 is select ota_cert_cat_inclusions_s.nextval from sys.dual;

Line 313: ,p_rec in ota_cci_shd.g_rec_type

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

Line 398: ,p_rec in out nocopy ota_cci_shd.g_rec_type

394: -- |---------------------------------< ins >----------------------------------|
395: -- ----------------------------------------------------------------------------
396: Procedure ins
397: (p_effective_date in date
398: ,p_rec in out nocopy ota_cci_shd.g_rec_type
399: ) is
400: --
401: l_proc varchar2(72) := g_package||'ins';
402: l_certification_id OTA_CERT_CAT_INCLUSIONS.certification_id%TYPE;

Line 484: l_rec ota_cci_shd.g_rec_type;

480: --,p_certification_id out nocopy number
481: ,p_object_version_number out nocopy number
482: ) is
483: --
484: l_rec ota_cci_shd.g_rec_type;
485: l_proc varchar2(72) := g_package||'ins';
486: --
487: Begin
488: hr_utility.set_location('Entering:'||l_proc, 5);

Line 494: ota_cci_shd.convert_args

490: -- Call conversion function to turn arguments into the
491: -- p_rec structure.
492: --
493: l_rec :=
494: ota_cci_shd.convert_args
495: (p_category_usage_id
496: ,p_certification_id
497: ,null
498: ,p_start_date_active