APPS.OTA_CTU_INS dependencies on OTA_CTU_SHD

Line 76: (p_rec in out nocopy ota_ctu_shd.g_rec_type

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

Line 168: ota_ctu_shd.constraint_error

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

Line 173: ota_ctu_shd.constraint_error

169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.parent_integrity_violated Then
171: -- Parent integrity has been violated
172: --
173: ota_ctu_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.unique_integrity_violated Then
176: -- Unique integrity has been violated
177: --

Line 178: ota_ctu_shd.constraint_error

174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.unique_integrity_violated Then
176: -- Unique integrity has been violated
177: --
178: ota_ctu_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When Others Then
181: --
182: Raise;

Line 223: (p_rec in out nocopy ota_ctu_shd.g_rec_type

219: --
220: -- {End Of Comments}
221: -- ----------------------------------------------------------------------------
222: Procedure pre_insert
223: (p_rec in out nocopy ota_ctu_shd.g_rec_type
224: ) is
225: --
226: Cursor C_Sel1 is select ota_category_usages_s.nextval from sys.dual;
227: --

Line 311: ,p_rec in ota_ctu_shd.g_rec_type

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

Line 408: ,p_rec in out nocopy ota_ctu_shd.g_rec_type

404: -- |---------------------------------< ins >----------------------------------|
405: -- ----------------------------------------------------------------------------
406: Procedure ins
407: (p_effective_date in date
408: ,p_rec in out nocopy ota_ctu_shd.g_rec_type
409: ) is
410: --
411: l_proc varchar2(72) := g_package||'ins';
412: --

Line 487: l_rec ota_ctu_shd.g_rec_type;

483: ,p_object_version_number out nocopy number
484: ,p_comments in varchar2 default null
485: ) is
486: --
487: l_rec ota_ctu_shd.g_rec_type;
488: l_proc varchar2(72) := g_package||'ins';
489: --
490: Begin
491: hr_utility.set_location('Entering:'||l_proc, 5);

Line 497: ota_ctu_shd.convert_args

493: -- Call conversion function to turn arguments into the
494: -- p_rec structure.
495: --
496: l_rec :=
497: ota_ctu_shd.convert_args
498: (null
499: ,p_business_group_id
500: ,p_category
501: ,null