APPS.PER_SP_PLAN_API dependencies on PER_SP_PLAN

Line 1: Package Body per_sp_plan_api as

1: Package Body per_sp_plan_api as
2: /* $Header: pesphapi.pkb 120.2 2011/03/30 06:07:46 vkodedal noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' per_sp_plan_api.';

2: /* $Header: pesphapi.pkb 120.2 2011/03/30 06:07:46 vkodedal noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' per_sp_plan_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_sp_plan >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 57: l_plan_id per_sp_plan.plan_id%TYPE;

53: -- Declare cursors and local variables
54: --
55: l_effective_date date;
56: l_proc varchar2(72) := g_package||'create_sp_plan';
57: l_plan_id per_sp_plan.plan_id%TYPE;
58: l_object_version_number per_sp_plan.object_version_number%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61: --

Line 58: l_object_version_number per_sp_plan.object_version_number%TYPE;

54: --
55: l_effective_date date;
56: l_proc varchar2(72) := g_package||'create_sp_plan';
57: l_plan_id per_sp_plan.plan_id%TYPE;
58: l_object_version_number per_sp_plan.object_version_number%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61: --
62: -- Issue a savepoint

Line 76: per_sp_plan_bk1.create_sp_plan_b

72: --
73: -- Call Before Process User Hook
74: --
75: begin
76: per_sp_plan_bk1.create_sp_plan_b
77: (p_effective_date => l_effective_date
78: ,p_plan_type => p_plan_type
79: ,p_plan_name => p_plan_name
80: ,p_successee_id => p_successee_id

Line 175: per_sp_plan_bk1.create_sp_plan_a

171: --
172: -- Call After Process User Hook
173: --
174: begin
175: per_sp_plan_bk1.create_sp_plan_a
176: (p_effective_date => l_effective_date
177: ,p_plan_id => l_plan_id
178: ,p_plan_type => p_plan_type
179: ,p_plan_name => p_plan_name

Line 315: l_object_version_number per_sp_plan.object_version_number%TYPE;

311: -- Declare cursors and local variables
312: --
313: l_effective_date date;
314: l_proc varchar2(72) := g_package||'update_sp_plan';
315: l_object_version_number per_sp_plan.object_version_number%TYPE;
316: begin
317: hr_utility.set_location('Entering:'|| l_proc, 10);
318: --
319: -- Issue a savepoint

Line 335: per_sp_plan_bk2.update_sp_plan_b

331: --
332: -- Call Before Process User Hook
333: --
334: begin
335: per_sp_plan_bk2.update_sp_plan_b
336: (p_effective_date => l_effective_date
337: ,p_plan_id => p_plan_id
338: ,p_plan_type => p_plan_type
339: ,p_plan_name => p_plan_name

Line 435: per_sp_plan_bk2.update_sp_plan_a

431: --
432: -- Call After Process User Hook
433: --
434: begin
435: per_sp_plan_bk2.update_sp_plan_a
436: (p_effective_date => l_effective_date
437: ,p_plan_id => p_plan_id
438: ,p_plan_type => p_plan_type
439: ,p_plan_name => p_plan_name

Line 538: per_sp_plan_bk3.delete_sp_plan_b(p_plan_id => p_plan_id);

534: -- Issue a savepoint.
535: --
536: savepoint delete_sp_plan;
537: hr_utility.set_location(l_proc, 10);
538: per_sp_plan_bk3.delete_sp_plan_b(p_plan_id => p_plan_id);
539: hr_utility.set_location(l_proc, 20);
540: per_sph_del.del(p_plan_id => p_plan_id
541: ,p_object_version_number => p_object_version_number);
542: hr_utility.set_location(l_proc, 30);

Line 543: per_sp_plan_bk3.delete_sp_plan_a(p_plan_id => p_plan_id);

539: hr_utility.set_location(l_proc, 20);
540: per_sph_del.del(p_plan_id => p_plan_id
541: ,p_object_version_number => p_object_version_number);
542: hr_utility.set_location(l_proc, 30);
543: per_sp_plan_bk3.delete_sp_plan_a(p_plan_id => p_plan_id);
544: hr_utility.set_location(l_proc, 50);
545: --
546: -- When in validation only mode raise the Validate_Enabled exception
547: --

Line 583: end per_sp_plan_api;

579: raise;
580:
581: end delete_sp_plan;
582: --
583: end per_sp_plan_api;