APPS.OTA_TPM_INS dependencies on OTA_TPM_INS

Line 1: PACKAGE BODY OTA_TPM_INS as

1: PACKAGE BODY OTA_TPM_INS as
2: /* $Header: ottpmrhi.pkb 120.1 2005/12/14 15:33:09 asud noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 23: ota_tpm_ins.g_training_plan_member_id_i := p_training_plan_member_id;

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

Line 256: ota_tpm_ins.g_training_plan_member_id_i;

252: Cursor C_Sel2 is
253: Select null
254: from ota_training_plan_members
255: where training_plan_member_id =
256: ota_tpm_ins.g_training_plan_member_id_i;
257: --
258: l_exists varchar2(1);
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);

Line 261: If (ota_tpm_ins.g_training_plan_member_id_i is not null) Then

257: --
258: l_exists varchar2(1);
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: If (ota_tpm_ins.g_training_plan_member_id_i is not null) Then
262: --
263: -- Verify registered primary key values not already in use
264: --
265: Open C_Sel2;

Line 281: ota_tpm_ins.g_training_plan_member_id_i;

277: --
278: -- Use registered key values and clear globals
279: --
280: p_rec.training_plan_member_id :=
281: ota_tpm_ins.g_training_plan_member_id_i;
282: ota_tpm_ins.g_training_plan_member_id_i := null;
283: Else
284: --
285: -- No registerd key values, so select the next sequence number

Line 282: ota_tpm_ins.g_training_plan_member_id_i := null;

278: -- Use registered key values and clear globals
279: --
280: p_rec.training_plan_member_id :=
281: ota_tpm_ins.g_training_plan_member_id_i;
282: ota_tpm_ins.g_training_plan_member_id_i := null;
283: Else
284: --
285: -- No registerd key values, so select the next sequence number
286: --

Line 465: ota_tpm_ins.pre_insert(p_rec);

461: --
462: hr_multi_message.end_validation_set;
463: -- Call the supporting pre-insert operation
464: --
465: ota_tpm_ins.pre_insert(p_rec);
466: --
467: -- Insert the row
468: --
469: ota_tpm_ins.insert_dml(p_rec);

Line 469: ota_tpm_ins.insert_dml(p_rec);

465: ota_tpm_ins.pre_insert(p_rec);
466: --
467: -- Insert the row
468: --
469: ota_tpm_ins.insert_dml(p_rec);
470: --
471: -- Call the supporting post-insert operation
472: --
473: ota_tpm_ins.post_insert

Line 473: ota_tpm_ins.post_insert

469: ota_tpm_ins.insert_dml(p_rec);
470: --
471: -- Call the supporting post-insert operation
472: --
473: ota_tpm_ins.post_insert
474: (p_effective_date
475: ,p_rec
476: );
477: --

Line 596: ota_tpm_ins.ins

592: --
593: -- Having converted the arguments into the ota_tpm_rec
594: -- plsql record structure we call the corresponding record business process.
595: --
596: ota_tpm_ins.ins
597: (p_effective_date
598: ,l_rec
599: );
600: --

Line 610: end ota_tpm_ins;

606: --
607: hr_utility.set_location(' Leaving:'||l_proc, 10);
608: End ins;
609: --
610: end ota_tpm_ins;