APPS.OTA_LPC_INS dependencies on OTA_LP_SECTIONS

Line 87: -- Insert the row into: ota_lp_sections

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: ota_lp_sections
88: --
89: insert into ota_lp_sections
90: (learning_path_section_id
91: ,learning_path_id

Line 89: insert into ota_lp_sections

85: --
86: --
87: -- Insert the row into: ota_lp_sections
88: --
89: insert into ota_lp_sections
90: (learning_path_section_id
91: ,learning_path_id
92: ,section_sequence
93: ,completion_type_code

Line 215: Cursor C_Sel1 is select ota_lp_sections_s.nextval from sys.dual;

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: --
217: Cursor C_Sel2 is
218: Select null
219: from ota_lp_sections

Line 219: from ota_lp_sections

215: Cursor C_Sel1 is select ota_lp_sections_s.nextval from sys.dual;
216: --
217: Cursor C_Sel2 is
218: Select null
219: from ota_lp_sections
220: where learning_path_section_id =
221: ota_lpc_ins.g_learning_path_section_id_i;
222: --
223: l_proc varchar2(72) := g_package||'pre_insert';

Line 241: fnd_message.set_token('TABLE_NAME','ota_lp_sections');

237: --
238: -- The primary key values are already in use.
239: --
240: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
241: fnd_message.set_token('TABLE_NAME','ota_lp_sections');
242: fnd_message.raise_error;
243: End If;
244: Close C_Sel2;
245: --

Line 374: (p_module_name => 'OTA_LP_SECTIONS'

370: --
371: when hr_api.cannot_find_prog_unit then
372: --
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'OTA_LP_SECTIONS'
375: ,p_hook_type => 'AI');
376: --
377: end;
378: --