1 Package Body per_sp_plan_bk1 as
2 /* $Header: pesphapi.pkb 120.2 2011/03/30 06:07:46 vkodedal noship $ */
3 g_package varchar2(33) := ' per_sp_plan_bk1.';
4 --
5 -- ----------------------------------------------------------------------------
6 -- |-------------------------< create_sp_plan_b >-------------------------|
7 -- ----------------------------------------------------------------------------
8 --
9 procedure create_sp_plan_b
10 (p_effective_date in date
11 ,p_plan_type in varchar2
12 ,p_plan_name in varchar2
13 ,p_successee_id in number
14 ,p_business_group_id in number
15 ,p_status in varchar2
16 ,p_plan_owner in number
17 ,p_start_date in date
18 ,p_end_date in date
19 ,p_description in varchar2
20 ,p_filled_from_plan in varchar2
21 ,p_filled_by in number
22 ,p_filled_on in date
23 ,p_next_review_date in date
24 ,p_criteria_set_id in number
25 ,p_attribute_category in varchar2
26 ,p_attribute1 in varchar2
27 ,p_attribute2 in varchar2
28 ,p_attribute3 in varchar2
29 ,p_attribute4 in varchar2
30 ,p_attribute5 in varchar2
31 ,p_attribute6 in varchar2
32 ,p_attribute7 in varchar2
33 ,p_attribute8 in varchar2
34 ,p_attribute9 in varchar2
35 ,p_attribute10 in varchar2
36 ,p_attribute11 in varchar2
37 ,p_attribute12 in varchar2
38 ,p_attribute13 in varchar2
39 ,p_attribute14 in varchar2
40 ,p_attribute15 in varchar2
41 ,p_attribute16 in varchar2
42 ,p_attribute17 in varchar2
43 ,p_attribute18 in varchar2
44 ,p_attribute19 in varchar2
45 ,p_attribute20 in varchar2) is
46 l_proc varchar(80) := g_package||'create_sp_plan_b';
47 begin
48 hr_utility.set_location('Entering: '||l_proc,10);
49 hr_utility.set_location('Leaving: '||l_proc,10);
50 end create_sp_plan_b;
51 --
52 -- ----------------------------------------------------------------------------
53 -- |-------------------------< create_sp_plan_a >-------------------------|
54 -- ----------------------------------------------------------------------------
55 --
56 procedure create_sp_plan_a
57 (p_effective_date in date
58 ,p_plan_type in varchar2
59 ,p_plan_name in varchar2
60 ,p_successee_id in number
61 ,p_business_group_id in number
62 ,p_status in varchar2
63 ,p_plan_owner in number
64 ,p_start_date in date
65 ,p_end_date in date
66 ,p_description in varchar2
67 ,p_filled_from_plan in varchar2
68 ,p_filled_by in number
69 ,p_filled_on in date
70 ,p_next_review_date in date
71 ,p_criteria_set_id in number
72 ,p_attribute_category in varchar2
73 ,p_attribute1 in varchar2
74 ,p_attribute2 in varchar2
75 ,p_attribute3 in varchar2
76 ,p_attribute4 in varchar2
77 ,p_attribute5 in varchar2
78 ,p_attribute6 in varchar2
79 ,p_attribute7 in varchar2
80 ,p_attribute8 in varchar2
81 ,p_attribute9 in varchar2
82 ,p_attribute10 in varchar2
83 ,p_attribute11 in varchar2
84 ,p_attribute12 in varchar2
85 ,p_attribute13 in varchar2
86 ,p_attribute14 in varchar2
87 ,p_attribute15 in varchar2
88 ,p_attribute16 in varchar2
89 ,p_attribute17 in varchar2
90 ,p_attribute18 in varchar2
91 ,p_attribute19 in varchar2
92 ,p_attribute20 in varchar2
93 ,p_plan_id in number) is
94 l_proc varchar(80) := g_package||'create_sp_plan_a';
95 begin
96 hr_utility.set_location('Entering: '||l_proc,10);
97 hr_utility.set_location('Leaving: '||l_proc,10);
98 end create_sp_plan_a;
99
100 end per_sp_plan_bk1;
[Home] [Help]