APPS.PER_PRT_INS dependencies on PER_PRT_INS

Line 1: Package Body per_prt_ins as

1: Package Body per_prt_ins as
2: /* $Header: peprtrhi.pkb 120.2 2006/05/03 18:37:44 kandra noship $ */
3:
4: -- ---------------------------------------------------------------------------+
5: -- | Private Global Definitions |

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

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

Line 24: per_prt_ins.g_performance_rating_id_i := p_performance_rating_id;

20: --
21: Begin
22: hr_utility.set_location('Entering:'||l_proc, 10);
23: --
24: per_prt_ins.g_performance_rating_id_i := p_performance_rating_id;
25: --
26: hr_utility.set_location(' Leaving:'||l_proc, 20);
27: End set_base_key_value;
28: --

Line 213: per_prt_ins.g_performance_rating_id_i;

209: Cursor C_Sel2 is
210: Select null
211: from per_performance_ratings
212: where performance_rating_id =
213: per_prt_ins.g_performance_rating_id_i;
214: --
215:
216: Begin
217: hr_utility.set_location('Entering:'||l_proc, 5);

Line 221: IF (per_prt_ins.g_performance_rating_id_i is not null)

217: hr_utility.set_location('Entering:'||l_proc, 5);
218:
219:
220: -- Select the next sequence number
221: IF (per_prt_ins.g_performance_rating_id_i is not null)
222: then
223: --
224: -- Verify registered primary key values not already in use
225: --

Line 241: p_rec.performance_rating_id := per_prt_ins.g_performance_rating_id_i;

237: Close C_Sel2;
238: --
239: -- Use registered key values and clear globals
240: --
241: p_rec.performance_rating_id := per_prt_ins.g_performance_rating_id_i;
242: per_prt_ins.g_performance_rating_id_i := null;
243: Else
244:
245: Open C_Sel1;

Line 242: per_prt_ins.g_performance_rating_id_i := null;

238: --
239: -- Use registered key values and clear globals
240: --
241: p_rec.performance_rating_id := per_prt_ins.g_performance_rating_id_i;
242: per_prt_ins.g_performance_rating_id_i := null;
243: Else
244:
245: Open C_Sel1;
246: Fetch C_Sel1 Into p_rec.performance_rating_id;

Line 503: end per_prt_ins;

499:
500: hr_utility.set_location(' Leaving:'||l_proc, 10);
501: End ins;
502:
503: end per_prt_ins;