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_TPS_INS dependencies on OTA_TPS_INS

Line 1: PACKAGE BODY OTA_TPS_INS as

1: PACKAGE BODY OTA_TPS_INS as
2: /* $Header: ottpsrhi.pkb 120.2 2005/12/14 15:17:58 asud noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_tps_ins.'; -- Global package name
9: --
10: g_training_plan_id_i number default null;
11: --
12: -- ----------------------------------------------------------------------------

Line 23: ota_tps_ins.g_training_plan_id_i := p_training_plan_id;

19: --
20: Begin
21: hr_utility.set_location('Entering:'||l_proc, 10);
22: --
23: ota_tps_ins.g_training_plan_id_i := p_training_plan_id;
24: --
25: hr_utility.set_location(' Leaving:'||l_proc, 20);
26: End set_base_key_value;
27: -- ----------------------------------------------------------------------------

Line 258: ota_tps_ins.g_training_plan_id_i;

254: Cursor C_Sel2 is
255: Select null
256: from ota_training_plans
257: where training_plan_id =
258: ota_tps_ins.g_training_plan_id_i;
259: --
260: l_exists varchar2(1);
261:
262: Begin

Line 264: If (ota_tps_ins.g_training_plan_id_i is not null) Then

260: l_exists varchar2(1);
261:
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: If (ota_tps_ins.g_training_plan_id_i is not null) Then
265: --
266: -- Verify registered primary key values not already in use
267: --
268: Open C_Sel2;

Line 284: ota_tps_ins.g_training_plan_id_i;

280: --
281: -- Use registered key values and clear globals
282: --
283: p_rec.training_plan_id :=
284: ota_tps_ins.g_training_plan_id_i;
285: ota_tps_ins.g_training_plan_id_i := null;
286: Else
287: --
288: -- No registerd key values, so select the next sequence number

Line 285: ota_tps_ins.g_training_plan_id_i := null;

281: -- Use registered key values and clear globals
282: --
283: p_rec.training_plan_id :=
284: ota_tps_ins.g_training_plan_id_i;
285: ota_tps_ins.g_training_plan_id_i := null;
286: Else
287: --
288: -- No registerd key values, so select the next sequence number
289: --

Line 475: ota_tps_ins.pre_insert(p_rec);

471: hr_multi_message.end_validation_set;
472:
473: -- Call the supporting pre-insert operation
474: --
475: ota_tps_ins.pre_insert(p_rec);
476: --
477: -- Insert the row
478: --
479: ota_tps_ins.insert_dml(p_rec);

Line 479: ota_tps_ins.insert_dml(p_rec);

475: ota_tps_ins.pre_insert(p_rec);
476: --
477: -- Insert the row
478: --
479: ota_tps_ins.insert_dml(p_rec);
480: --
481: -- Call the supporting post-insert operation
482: --
483: ota_tps_ins.post_insert

Line 483: ota_tps_ins.post_insert

479: ota_tps_ins.insert_dml(p_rec);
480: --
481: -- Call the supporting post-insert operation
482: --
483: ota_tps_ins.post_insert
484: (p_effective_date
485: ,p_rec
486: );
487: --

Line 613: ota_tps_ins.ins

609: --
610: -- Having converted the arguments into the ota_tps_rec
611: -- plsql record structure we call the corresponding record business process.
612: --
613: ota_tps_ins.ins
614: (p_effective_date
615: ,l_rec
616: );
617: --

Line 627: end ota_tps_ins;

623: --
624: hr_utility.set_location(' Leaving:'||l_proc, 10);
625: End ins;
626: --
627: end ota_tps_ins;