APPS.OTA_LPS_INS dependencies on OTA_LPS_SHD

Line 76: (p_rec in out nocopy ota_lps_shd.g_rec_type

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

Line 177: ota_lps_shd.constraint_error

173: Exception
174: When hr_api.check_integrity_violated Then
175: -- A check constraint has been violated
176: --
177: ota_lps_shd.constraint_error
178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When hr_api.parent_integrity_violated Then
180: -- Parent integrity has been violated
181: --

Line 182: ota_lps_shd.constraint_error

178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When hr_api.parent_integrity_violated Then
180: -- Parent integrity has been violated
181: --
182: ota_lps_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: -- Unique integrity has been violated
186: --

Line 187: ota_lps_shd.constraint_error

183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: -- Unique integrity has been violated
186: --
187: ota_lps_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When Others Then
190: --
191: Raise;

Line 232: (p_rec in out nocopy ota_lps_shd.g_rec_type

228: --
229: -- {End Of Comments}
230: -- ----------------------------------------------------------------------------
231: Procedure pre_insert
232: (p_rec in out nocopy ota_lps_shd.g_rec_type
233: ) is
234: --
235: Cursor C_Sel1 is select ota_learning_paths_s.nextval from sys.dual;
236: --

Line 320: ,p_rec in ota_lps_shd.g_rec_type

316: -- {End Of Comments}
317: -- ----------------------------------------------------------------------------
318: Procedure post_insert
319: (p_effective_date in date
320: ,p_rec in ota_lps_shd.g_rec_type
321: ) is
322: --
323: l_proc varchar2(72) := g_package||'post_insert';
324: --

Line 430: ,p_rec in out nocopy ota_lps_shd.g_rec_type

426: -- |---------------------------------< ins >----------------------------------|
427: -- ----------------------------------------------------------------------------
428: Procedure ins
429: (p_effective_date in date
430: ,p_rec in out nocopy ota_lps_shd.g_rec_type
431: ) is
432: --
433: l_proc varchar2(72) := g_package||'ins';
434: --

Line 514: l_rec ota_lps_shd.g_rec_type;

510: ,p_learning_path_id out nocopy number
511: ,p_object_version_number out nocopy number
512: ) is
513: --
514: l_rec ota_lps_shd.g_rec_type;
515: l_proc varchar2(72) := g_package||'ins';
516: --
517: Begin
518: hr_utility.set_location('Entering:'||l_proc, 5);

Line 524: ota_lps_shd.convert_args

520: -- Call conversion function to turn arguments into the
521: -- p_rec structure.
522: --
523: l_rec :=
524: ota_lps_shd.convert_args
525: (null
526: ,p_business_group_id
527: ,p_duration
528: ,p_duration_units