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 170: ota_ctu_shd.constraint_error

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

Line 175: ota_ctu_shd.constraint_error

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

Line 180: ota_ctu_shd.constraint_error

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

Line 225: (p_rec in out nocopy ota_ctu_shd.g_rec_type

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

Line 313: ,p_rec in ota_ctu_shd.g_rec_type

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

Line 410: ,p_rec in out nocopy ota_ctu_shd.g_rec_type

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

Line 490: l_rec ota_ctu_shd.g_rec_type;

486: ,p_comments in varchar2 default null
487: ,p_user_group_id in number default null
488: ) is
489: --
490: l_rec ota_ctu_shd.g_rec_type;
491: l_proc varchar2(72) := g_package||'ins';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);

Line 500: ota_ctu_shd.convert_args

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