APPS.OTA_LPM_INS dependencies on OTA_LPM_SHD

Line 77: (p_rec in out nocopy ota_lpm_shd.g_rec_type

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

Line 164: ota_lpm_shd.constraint_error

160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: --
164: ota_lpm_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.parent_integrity_violated Then
167: -- Parent integrity has been violated
168: --

Line 169: ota_lpm_shd.constraint_error

165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.parent_integrity_violated Then
167: -- Parent integrity has been violated
168: --
169: ota_lpm_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.unique_integrity_violated Then
172: -- Unique integrity has been violated
173: --

Line 174: ota_lpm_shd.constraint_error

170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.unique_integrity_violated Then
172: -- Unique integrity has been violated
173: --
174: ota_lpm_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When Others Then
177: --
178: Raise;

Line 219: (p_rec in out nocopy ota_lpm_shd.g_rec_type

215: --
216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: Procedure pre_insert
219: (p_rec in out nocopy ota_lpm_shd.g_rec_type
220: ) is
221: --
222: Cursor C_Sel1 is select ota_learning_path_members_s.nextval from sys.dual;
223: --

Line 307: ,p_rec in ota_lpm_shd.g_rec_type

303: -- {End Of Comments}
304: -- ----------------------------------------------------------------------------
305: Procedure post_insert
306: (p_effective_date in date
307: ,p_rec in ota_lpm_shd.g_rec_type
308: ) is
309: --
310: l_proc varchar2(72) := g_package||'post_insert';
311: --

Line 400: ,p_rec in out nocopy ota_lpm_shd.g_rec_type

396: -- |---------------------------------< ins >----------------------------------|
397: -- ----------------------------------------------------------------------------
398: Procedure ins
399: (p_effective_date in date
400: ,p_rec in out nocopy ota_lpm_shd.g_rec_type
401: ) is
402: --
403: l_proc varchar2(72) := g_package||'ins';
404: --

Line 477: l_rec ota_lpm_shd.g_rec_type;

473: ,p_learning_path_member_id out nocopy number
474: ,p_object_version_number out nocopy number
475: ) is
476: --
477: l_rec ota_lpm_shd.g_rec_type;
478: l_proc varchar2(72) := g_package||'ins';
479: --
480: Begin
481: hr_utility.set_location('Entering:'||l_proc, 5);

Line 487: ota_lpm_shd.convert_args

483: -- Call conversion function to turn arguments into the
484: -- p_rec structure.
485: --
486: l_rec :=
487: ota_lpm_shd.convert_args
488: (null
489: ,p_learning_path_id
490: ,p_activity_version_id
491: ,p_course_sequence