APPS.OTA_OCL_INS dependencies on OTA_OCL_SHD

Line 54: (p_rec in out nocopy ota_ocl_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy ota_ocl_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 133: ota_ocl_shd.constraint_error

129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: ota_ocl_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --

Line 138: ota_ocl_shd.constraint_error

134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: ota_ocl_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --

Line 143: ota_ocl_shd.constraint_error

139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: ota_ocl_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: --
147: Raise;

Line 188: (p_rec in out nocopy ota_ocl_shd.g_rec_type

184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure pre_insert
188: (p_rec in out nocopy ota_ocl_shd.g_rec_type
189: ) is
190: --
191: l_proc varchar2(72) := g_package||'pre_insert';
192: --

Line 242: ,p_rec in ota_ocl_shd.g_rec_type

238: -- {End Of Comments}
239: -- ----------------------------------------------------------------------------
240: Procedure post_insert
241: (p_effective_date in date
242: ,p_rec in ota_ocl_shd.g_rec_type
243: ) is
244: --
245: l_proc varchar2(72) := g_package||'post_insert';
246: --

Line 327: ,p_rec in out nocopy ota_ocl_shd.g_rec_type

323: -- |---------------------------------< ins >----------------------------------|
324: -- ----------------------------------------------------------------------------
325: Procedure ins
326: (p_effective_date in date
327: ,p_rec in out nocopy ota_ocl_shd.g_rec_type
328: ) is
329: --
330: l_proc varchar2(72) := g_package||'ins';
331: --

Line 394: l_rec ota_ocl_shd.g_rec_type;

390: ,p_competence_language_id out nocopy number
391: ,p_object_version_number out nocopy number
392: ) is
393: --
394: l_rec ota_ocl_shd.g_rec_type;
395: l_proc varchar2(72) := g_package||'ins';
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);

Line 404: ota_ocl_shd.convert_args

400: -- Call conversion function to turn arguments into the
401: -- p_rec structure.
402: --
403: l_rec :=
404: ota_ocl_shd.convert_args
405: (null
406: ,p_competence_id
407: ,p_language_code
408: ,p_min_proficiency_level_id