[Home] [Help]
PACKAGE: APPS.PER_SP_PLAN_API
Source
1 Package per_sp_plan_api AUTHID CURRENT_USER as
2 /* $Header: pesphapi.pkh 120.3 2011/03/30 06:08:28 vkodedal noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< CREATE_SP_PLAN >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32 procedure create_sp_plan
33 (p_validate in boolean default false
34 ,p_effective_date in date
35 ,p_plan_type in varchar2
36 ,p_plan_name in varchar2
37 ,p_successee_id in number
38 ,p_business_group_id in number
39 ,p_status in varchar2
40 ,p_plan_owner in number
41 ,p_start_date in date
42 ,p_end_date in date default null
43 ,p_description in varchar2 default null
44 ,p_filled_from_plan in varchar2 default null
45 ,p_filled_by in number default null
46 ,p_filled_on in date default null
47 ,p_next_review_date in date default null
48 ,p_criteria_set_id in number default null
49 ,p_attribute_category in varchar2 default null
50 ,p_attribute1 in varchar2 default null
51 ,p_attribute2 in varchar2 default null
52 ,p_attribute3 in varchar2 default null
53 ,p_attribute4 in varchar2 default null
54 ,p_attribute5 in varchar2 default null
55 ,p_attribute6 in varchar2 default null
56 ,p_attribute7 in varchar2 default null
57 ,p_attribute8 in varchar2 default null
58 ,p_attribute9 in varchar2 default null
59 ,p_attribute10 in varchar2 default null
60 ,p_attribute11 in varchar2 default null
61 ,p_attribute12 in varchar2 default null
62 ,p_attribute13 in varchar2 default null
63 ,p_attribute14 in varchar2 default null
64 ,p_attribute15 in varchar2 default null
65 ,p_attribute16 in varchar2 default null
66 ,p_attribute17 in varchar2 default null
67 ,p_attribute18 in varchar2 default null
68 ,p_attribute19 in varchar2 default null
69 ,p_attribute20 in varchar2 default null
70 ,p_plan_id out nocopy number
71 ,p_object_version_number out nocopy number );
72 --
73 --
74 -- ----------------------------------------------------------------------------
75 -- |--------------------------< update_sp_plan >--------------------------|
76 -- ----------------------------------------------------------------------------
77 -- {Start Of Comments}
78 --
79 -- Description:
80 --
81 --
82 -- Prerequisites:
83 --
84 --
85 -- In Parameters:
86 -- Name Reqd Type Description
87 --
88 --
89 -- Post Success:
90 --
91 --
92 -- Name Type Description
93 --
94 -- Post Failure:
95 --
96 --
97 -- Access Status:
98 -- Public.
99 --
100 -- {End Of Comments}
101 --
102 procedure update_sp_plan
103 (p_validate in boolean default false
104 ,p_effective_date in date
105 ,p_plan_id in number
106 ,p_object_version_number in out nocopy number
107 ,p_plan_type in varchar2 default hr_api.g_varchar2
108 ,p_plan_name in varchar2 default hr_api.g_varchar2
109 ,p_successee_id in number default hr_api.g_number
110 ,p_business_group_id in number default hr_api.g_number
111 ,p_status in varchar2 default hr_api.g_varchar2
112 ,p_plan_owner in number default hr_api.g_number
113 ,p_start_date in date default hr_api.g_date
114 ,p_end_date in date default hr_api.g_date
115 ,p_description in varchar2 default hr_api.g_varchar2
116 ,p_filled_from_plan in varchar2 default hr_api.g_varchar2
117 ,p_filled_by in number default hr_api.g_number
118 ,p_filled_on in date default hr_api.g_date
119 ,p_next_review_date in date default hr_api.g_date
120 ,p_criteria_set_id in number default hr_api.g_number
121 ,p_attribute_category in varchar2 default hr_api.g_varchar2
122 ,p_attribute1 in varchar2 default hr_api.g_varchar2
123 ,p_attribute2 in varchar2 default hr_api.g_varchar2
124 ,p_attribute3 in varchar2 default hr_api.g_varchar2
125 ,p_attribute4 in varchar2 default hr_api.g_varchar2
126 ,p_attribute5 in varchar2 default hr_api.g_varchar2
127 ,p_attribute6 in varchar2 default hr_api.g_varchar2
128 ,p_attribute7 in varchar2 default hr_api.g_varchar2
129 ,p_attribute8 in varchar2 default hr_api.g_varchar2
130 ,p_attribute9 in varchar2 default hr_api.g_varchar2
131 ,p_attribute10 in varchar2 default hr_api.g_varchar2
132 ,p_attribute11 in varchar2 default hr_api.g_varchar2
133 ,p_attribute12 in varchar2 default hr_api.g_varchar2
134 ,p_attribute13 in varchar2 default hr_api.g_varchar2
135 ,p_attribute14 in varchar2 default hr_api.g_varchar2
136 ,p_attribute15 in varchar2 default hr_api.g_varchar2
137 ,p_attribute16 in varchar2 default hr_api.g_varchar2
138 ,p_attribute17 in varchar2 default hr_api.g_varchar2
139 ,p_attribute18 in varchar2 default hr_api.g_varchar2
140 ,p_attribute19 in varchar2 default hr_api.g_varchar2
141 ,p_attribute20 in varchar2 default hr_api.g_varchar2);
142 --
143 --
144 -- ----------------------------------------------------------------------------
145 -- |--------------------------< delete_sp_plan >--------------------------|
146 -- ----------------------------------------------------------------------------
147 -- {Start Of Comments}
148 --
149 -- Description:
150 --
151 --
152 -- Prerequisites:
153 --
154 --
155 -- In Parameters:
156 -- Name Reqd Type Description
157 --
158 --
159 -- Post Success:
160 --
161 --
162 -- Name Type Description
163 --
164 -- Post Failure:
165 --
166 --
167 -- Access Status:
168 -- Public.
169 --
170 -- {End Of Comments}
171 --
172 procedure delete_sp_plan
173 (p_validate in boolean default false
174 ,p_plan_id in number
175 ,p_object_version_number in number);
176 end per_sp_plan_api;