APPS.OTA_TSP_INS dependencies on OTA_TSP_INS

Line 1: Package Body ota_tsp_ins as

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

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

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

Line 22: ota_tsp_ins.g_skill_provision_id_i := p_skill_provision_id;

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 10);
21: --
22: ota_tsp_ins.g_skill_provision_id_i := p_skill_provision_id;
23: --
24: hr_utility.set_location(' Leaving:'||l_proc, 20);
25: End set_base_key_value;
26: -- ----------------------------------------------------------------------------

Line 214: ota_tsp_ins.g_skill_provision_id_i;

210: Cursor C_Sel2 is
211: Select null
212: from ota_skill_provisions
213: where skill_provision_id =
214: ota_tsp_ins.g_skill_provision_id_i;
215: --
216: l_exists varchar2(1);
217:
218: Begin

Line 220: If (ota_tsp_ins.g_skill_provision_id_i is not null) Then

216: l_exists varchar2(1);
217:
218: Begin
219: hr_utility.set_location('Entering:'||l_proc, 5);
220: If (ota_tsp_ins.g_skill_provision_id_i is not null) Then
221: --
222: -- Verify registered primary key values not already in use
223: --
224: Open C_Sel2;

Line 240: ota_tsp_ins.g_skill_provision_id_i;

236: --
237: -- Use registered key values and clear globals
238: --
239: p_rec.skill_provision_id :=
240: ota_tsp_ins.g_skill_provision_id_i;
241: ota_tsp_ins.g_skill_provision_id_i := null;
242: Else
243: --
244: -- No registerd key values, so select the next sequence number

Line 241: ota_tsp_ins.g_skill_provision_id_i := null;

237: -- Use registered key values and clear globals
238: --
239: p_rec.skill_provision_id :=
240: ota_tsp_ins.g_skill_provision_id_i;
241: ota_tsp_ins.g_skill_provision_id_i := null;
242: Else
243: --
244: -- No registerd key values, so select the next sequence number
245: --

Line 443: end ota_tsp_ins;

439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: End ins;
442: --
443: end ota_tsp_ins;