APPS.PER_APT_INS dependencies on PER_APT_INS

Line 1: Package Body per_apt_ins as

1: Package Body per_apt_ins as
2: /* $Header: peaptrhi.pkb 120.10.12020000.1 2012/06/29 00:43:57 appldev ship $ */
3:
4: -- ---------------------------------------------------------------------------+
5: -- | Private Global Definitions |

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

4: -- ---------------------------------------------------------------------------+
5: -- | Private Global Definitions |
6: -- ---------------------------------------------------------------------------+
7:
8: g_package varchar2(33) := ' per_apt_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 27: per_apt_ins.g_appraisal_template_id_i := p_appraisal_template_id;

23: --
24: Begin
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: per_apt_ins.g_appraisal_template_id_i := p_appraisal_template_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --

Line 273: where appraisal_template_id = per_apt_ins.g_appraisal_template_id_i;

269: Cursor C_Sel1 is select per_appraisal_templates_s.nextval from sys.dual;
270:
271: Cursor C_Sel2 is
272: select null from per_appraisal_templates
273: where appraisal_template_id = per_apt_ins.g_appraisal_template_id_i;
274:
275: Begin
276: hr_utility.set_location('Entering:'||l_proc, 5);
277:

Line 280: if (per_apt_ins.g_appraisal_template_id_i is not null ) then

276: hr_utility.set_location('Entering:'||l_proc, 5);
277:
278:
279: -- Select the next sequence number
280: if (per_apt_ins.g_appraisal_template_id_i is not null ) then
281: Open C_Sel2;
282: Fetch C_Sel2 Into l_exists;
283: if C_Sel2%Found then
284: Close C_Sel2;

Line 296: p_rec.appraisal_template_id := per_apt_ins.g_appraisal_template_id_i;

292: Close C_Sel2;
293: --
294: -- Use registered key values and clear globals
295: --
296: p_rec.appraisal_template_id := per_apt_ins.g_appraisal_template_id_i;
297: per_apt_ins.g_appraisal_template_id_i := null;
298:
299: Else
300: Open C_Sel1;

Line 297: per_apt_ins.g_appraisal_template_id_i := null;

293: --
294: -- Use registered key values and clear globals
295: --
296: p_rec.appraisal_template_id := per_apt_ins.g_appraisal_template_id_i;
297: per_apt_ins.g_appraisal_template_id_i := null;
298:
299: Else
300: Open C_Sel1;
301: Fetch C_Sel1 Into p_rec.appraisal_template_id;

Line 639: end per_apt_ins;

635:
636: hr_utility.set_location(' Leaving:'||l_proc, 10);
637: End ins;
638:
639: end per_apt_ins;