eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LPC_INS dependencies on OTA_LPC_INS

Line 1: Package Body ota_lpc_ins as

1: Package Body ota_lpc_ins as
2: /* $Header: otlpcrhi.pkb 120.0 2005/05/29 07:20 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_lpc_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_lpc_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 26: ota_lpc_ins.g_learning_path_section_id_i := p_learning_path_section_id;

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ota_lpc_ins.g_learning_path_section_id_i := p_learning_path_section_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --

Line 221: ota_lpc_ins.g_learning_path_section_id_i;

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';
224: l_exists varchar2(1);
225: --

Line 229: If (ota_lpc_ins.g_learning_path_section_id_i is not null) Then

225: --
226: Begin
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: If (ota_lpc_ins.g_learning_path_section_id_i is not null) Then
230: --
231: -- Verify registered primary key values not already in use
232: --
233: Open C_Sel2;

Line 249: ota_lpc_ins.g_learning_path_section_id_i;

245: --
246: -- Use registered key values and clear globals
247: --
248: p_rec.learning_path_section_id :=
249: ota_lpc_ins.g_learning_path_section_id_i;
250: ota_lpc_ins.g_learning_path_section_id_i := null;
251: Else
252: --
253: -- No registerd key values, so select the next sequence number

Line 250: ota_lpc_ins.g_learning_path_section_id_i := null;

246: -- Use registered key values and clear globals
247: --
248: p_rec.learning_path_section_id :=
249: ota_lpc_ins.g_learning_path_section_id_i;
250: ota_lpc_ins.g_learning_path_section_id_i := null;
251: Else
252: --
253: -- No registerd key values, so select the next sequence number
254: --

Line 407: ota_lpc_ins.pre_insert(p_rec);

403: hr_multi_message.end_validation_set;
404: --
405: -- Call the supporting pre-insert operation
406: --
407: ota_lpc_ins.pre_insert(p_rec);
408: --
409: -- Insert the row
410: --
411: ota_lpc_ins.insert_dml(p_rec);

Line 411: ota_lpc_ins.insert_dml(p_rec);

407: ota_lpc_ins.pre_insert(p_rec);
408: --
409: -- Insert the row
410: --
411: ota_lpc_ins.insert_dml(p_rec);
412: --
413: -- Call the supporting post-insert operation
414: --
415: ota_lpc_ins.post_insert

Line 415: ota_lpc_ins.post_insert

411: ota_lpc_ins.insert_dml(p_rec);
412: --
413: -- Call the supporting post-insert operation
414: --
415: ota_lpc_ins.post_insert
416: (p_effective_date
417: ,p_rec
418: );
419: --

Line 505: ota_lpc_ins.ins

501: --
502: -- Having converted the arguments into the ota_lpc_rec
503: -- plsql record structure we call the corresponding record business process.
504: --
505: ota_lpc_ins.ins
506: (p_effective_date
507: ,l_rec
508: );
509: --

Line 519: end ota_lpc_ins;

515: --
516: hr_utility.set_location(' Leaving:'||l_proc, 10);
517: End ins;
518: --
519: end ota_lpc_ins;