APPS.OTA_AVT_INS dependencies on OTA_AVT_SHD

Line 54: (p_rec in out nocopy ota_avt_shd.g_rec_type

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

Line 95: ota_avt_shd.constraint_error

91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
95: ota_avt_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --

Line 100: ota_avt_shd.constraint_error

96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --
100: ota_avt_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --

Line 105: ota_avt_shd.constraint_error

101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
105: ota_avt_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: --
109: Raise;

Line 150: (p_rec in out nocopy ota_avt_shd.g_rec_type

146: --
147: -- {End Of Comments}
148: -- ----------------------------------------------------------------------------
149: Procedure pre_insert
150: (p_rec in out nocopy ota_avt_shd.g_rec_type
151: ,p_activity_version_id in number
152: ) is
153: --
154: l_proc varchar2(72) := g_package||'pre_insert';

Line 198: ,p_rec in ota_avt_shd.g_rec_type

194: -- {End Of Comments}
195: -- ----------------------------------------------------------------------------
196: Procedure post_insert
197: (p_effective_date in date
198: ,p_rec in ota_avt_shd.g_rec_type
199: ) is
200: --
201: l_proc varchar2(72) := g_package||'post_insert';
202: --

Line 245: ,p_rec in out nocopy ota_avt_shd.g_rec_type

241: -- |---------------------------------< ins >----------------------------------|
242: -- ----------------------------------------------------------------------------
243: Procedure ins
244: (p_effective_date in date
245: ,p_rec in out nocopy ota_avt_shd.g_rec_type
246: ,p_activity_version_id in number
247: ) is
248: --
249: l_proc varchar2(72) := g_package||'ins';

Line 304: l_rec ota_avt_shd.g_rec_type;

300: ,p_objectives in varchar2
301: ,p_keywords in varchar2
302: ) is
303: --
304: l_rec ota_avt_shd.g_rec_type;
305: l_proc varchar2(72) := g_package||'ins';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);

Line 314: ota_avt_shd.convert_args

310: -- Call conversion function to turn arguments into the
311: -- p_rec structure.
312: --
313: l_rec :=
314: ota_avt_shd.convert_args
315: (null
316: ,p_language
317: ,p_source_lang
318: ,p_version_name