APPS.OTA_LPT_INS dependencies on OTA_LPT_SHD

Line 54: (p_rec in out nocopy ota_lpt_shd.g_rec_type

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

Line 95: ota_lpt_shd.constraint_error

91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
95: ota_lpt_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_lpt_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_lpt_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_lpt_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_lpt_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_lpt_shd.g_rec_type

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

Line 198: ,p_rec in ota_lpt_shd.g_rec_type

194: -- {End Of Comments}
195: -- ----------------------------------------------------------------------------
196: Procedure post_insert
197: (p_effective_date in date
198: ,p_rec in ota_lpt_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_lpt_shd.g_rec_type

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

Line 305: l_rec ota_lpt_shd.g_rec_type;

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

Line 315: ota_lpt_shd.convert_args

311: -- Call conversion function to turn arguments into the
312: -- p_rec structure.
313: --
314: l_rec :=
315: ota_lpt_shd.convert_args
316: (null
317: ,p_language
318: ,p_name
319: ,p_description