APPS.OTA_LST_INS dependencies on OTA_LST_SHD

Line 54: (p_rec in out nocopy ota_lst_shd.g_rec_type

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

Line 89: ota_lst_shd.constraint_error

85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: ota_lst_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --

Line 94: ota_lst_shd.constraint_error

90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: ota_lst_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --

Line 99: ota_lst_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: ota_lst_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: --
103: Raise;

Line 144: (p_rec in out nocopy ota_lst_shd.g_rec_type

140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure pre_insert
144: (p_rec in out nocopy ota_lst_shd.g_rec_type
145: ,p_learning_path_section_id in number
146: ) is
147: --
148: l_proc varchar2(72) := g_package||'pre_insert';

Line 192: ,p_rec in ota_lst_shd.g_rec_type

188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure post_insert
191: (p_effective_date in date
192: ,p_rec in ota_lst_shd.g_rec_type
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'post_insert';
196: --

Line 233: ,p_rec in out nocopy ota_lst_shd.g_rec_type

229: -- |---------------------------------< ins >----------------------------------|
230: -- ----------------------------------------------------------------------------
231: Procedure ins
232: (p_effective_date in date
233: ,p_rec in out nocopy ota_lst_shd.g_rec_type
234: ,p_learning_path_section_id in number
235: ) is
236: --
237: l_proc varchar2(72) := g_package||'ins';

Line 290: l_rec ota_lst_shd.g_rec_type;

286: ,p_source_lang in varchar2
287: ,p_description in varchar2
288: ) is
289: --
290: l_rec ota_lst_shd.g_rec_type;
291: l_proc varchar2(72) := g_package||'ins';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);

Line 300: ota_lst_shd.convert_args

296: -- Call conversion function to turn arguments into the
297: -- p_rec structure.
298: --
299: l_rec :=
300: ota_lst_shd.convert_args
301: (null
302: ,p_language
303: ,p_name
304: ,p_description