APPS.OTA_LPC_INS dependencies on OTA_LPC_SHD

Line 76: (p_rec in out nocopy ota_lpc_shd.g_rec_type

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

Line 157: ota_lpc_shd.constraint_error

153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: --
157: ota_lpc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: --

Line 162: ota_lpc_shd.constraint_error

158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: --
162: ota_lpc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --

Line 167: ota_lpc_shd.constraint_error

163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --
167: ota_lpc_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: --
171: Raise;

Line 212: (p_rec in out nocopy ota_lpc_shd.g_rec_type

208: --
209: -- {End Of Comments}
210: -- ----------------------------------------------------------------------------
211: Procedure pre_insert
212: (p_rec in out nocopy ota_lpc_shd.g_rec_type
213: ) is
214: --
215: Cursor C_Sel1 is select ota_lp_sections_s.nextval from sys.dual;
216: --

Line 300: ,p_rec in ota_lpc_shd.g_rec_type

296: -- {End Of Comments}
297: -- ----------------------------------------------------------------------------
298: Procedure post_insert
299: (p_effective_date in date
300: ,p_rec in ota_lpc_shd.g_rec_type
301: ) is
302: --
303: l_proc varchar2(72) := g_package||'post_insert';
304: --

Line 387: ,p_rec in out nocopy ota_lpc_shd.g_rec_type

383: -- |---------------------------------< ins >----------------------------------|
384: -- ----------------------------------------------------------------------------
385: Procedure ins
386: (p_effective_date in date
387: ,p_rec in out nocopy ota_lpc_shd.g_rec_type
388: ) is
389: --
390: l_proc varchar2(72) := g_package||'ins';
391: --

Line 461: l_rec ota_lpc_shd.g_rec_type;

457: ,p_learning_path_section_id out nocopy number
458: ,p_object_version_number out nocopy number
459: ) is
460: --
461: l_rec ota_lpc_shd.g_rec_type;
462: l_proc varchar2(72) := g_package||'ins';
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);

Line 471: ota_lpc_shd.convert_args

467: -- Call conversion function to turn arguments into the
468: -- p_rec structure.
469: --
470: l_rec :=
471: ota_lpc_shd.convert_args
472: (null
473: ,p_learning_path_id
474: ,p_section_sequence
475: ,p_completion_type_code