[Home] [Help]
PACKAGE: APPS.PER_SUCCESSION_PLAN_API
Source
1 PACKAGE per_succession_plan_api AUTHID CURRENT_USER AS
2 /* $Header: pesucapi.pkh 120.5 2010/02/13 19:29:53 schowdhu ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< CREATE_SUCCESSION_PLAN> >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- It creates succession Plan.
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name
17 -- p_validate
18 -- p_person_id
19 -- p_position_id
20 -- p_business_group_id
21 -- p_start_date
22 -- p_time_scale
23 -- p_end_date
24 -- p_available_for_promotion
25 -- p_manager_comments
26 -- p_attribute_category
27 -- p_attribute1
28 -- p_attribute2
29 -- p_attribute3
30 -- p_attribute4
31 -- p_attribute5
32 -- p_attribute6
33 -- p_attribute7
34 -- p_attribute8
35 -- p_attribute9
36 -- p_attribute10
37 -- p_attribute11
38 -- p_attribute12
39 -- p_attribute13
40 -- p_attribute14
41 -- p_attribute15
42 -- p_attribute16
43 -- p_attribute17
44 -- p_attribute18
45 -- p_attribute19
46 -- p_attribute20
47 -- p_effective_date
48 -- p_job_id
49 -- p_successee_person_id
50 -- p_person_rank
51 -- p_performance
52 -- p_plan_status
53 -- p_readiness_percentage
54 -- p_succession_plan_id
55 -- p_object_version_number
56 --
57 -- Post Failure:
58 -- The API does not create the plan and raises an error.
59 --
60 -- Post Success:
61 -- The API creates the plan.
62
63 --
64 -- Access Status:
65 -- Public.
66 --
67 -- {End Of Comments}
68 --
69 PROCEDURE create_succession_plan (
70 p_validate IN BOOLEAN DEFAULT FALSE,
71 p_person_id IN NUMBER,
72 p_position_id IN NUMBER DEFAULT NULL,
73 p_business_group_id IN NUMBER,
74 p_start_date IN DATE,
75 p_time_scale IN VARCHAR2,
76 p_end_date IN DATE DEFAULT NULL,
77 p_available_for_promotion IN VARCHAR2 DEFAULT NULL,
78 p_manager_comments IN VARCHAR2 DEFAULT NULL,
79 p_attribute_category IN VARCHAR2 DEFAULT NULL,
80 p_attribute1 IN VARCHAR2 DEFAULT NULL,
81 p_attribute2 IN VARCHAR2 DEFAULT NULL,
82 p_attribute3 IN VARCHAR2 DEFAULT NULL,
83 p_attribute4 IN VARCHAR2 DEFAULT NULL,
84 p_attribute5 IN VARCHAR2 DEFAULT NULL,
85 p_attribute6 IN VARCHAR2 DEFAULT NULL,
86 p_attribute7 IN VARCHAR2 DEFAULT NULL,
87 p_attribute8 IN VARCHAR2 DEFAULT NULL,
88 p_attribute9 IN VARCHAR2 DEFAULT NULL,
89 p_attribute10 IN VARCHAR2 DEFAULT NULL,
90 p_attribute11 IN VARCHAR2 DEFAULT NULL,
91 p_attribute12 IN VARCHAR2 DEFAULT NULL,
92 p_attribute13 IN VARCHAR2 DEFAULT NULL,
93 p_attribute14 IN VARCHAR2 DEFAULT NULL,
94 p_attribute15 IN VARCHAR2 DEFAULT NULL,
95 p_attribute16 IN VARCHAR2 DEFAULT NULL,
96 p_attribute17 IN VARCHAR2 DEFAULT NULL,
97 p_attribute18 IN VARCHAR2 DEFAULT NULL,
98 p_attribute19 IN VARCHAR2 DEFAULT NULL,
99 p_attribute20 IN VARCHAR2 DEFAULT NULL,
100 p_effective_date IN DATE,
101 p_job_id IN NUMBER DEFAULT NULL,
102 p_successee_person_id IN NUMBER DEFAULT NULL,
103 p_person_rank IN NUMBER DEFAULT NULL,
104 p_performance IN VARCHAR2 DEFAULT NULL,
105 p_plan_status IN VARCHAR2 DEFAULT NULL,
106 p_readiness_percentage IN NUMBER DEFAULT NULL,
107 p_succession_plan_id OUT NOCOPY NUMBER,
108 p_object_version_number OUT NOCOPY NUMBER
109 );
110
111 --
112 -- ----------------------------------------------------------------------------
113 -- |--------------------------< UPDATE_SUCCESSION_PLAN> >--------------------------|
114 -- ----------------------------------------------------------------------------
115 -- {Start Of Comments}
116 --
117 -- Description:
118 -- It Updates an existing Succession Planning record.
119 --
120 -- Prerequisites:
121 --
122 --
123 -- In Parameters:
124 -- Name
125 -- p_validate
126 -- p_person_id
127 -- p_position_id
128 -- p_business_group_id
129 -- p_start_date
130 -- p_time_scale
131 -- p_end_date
132 -- p_available_for_promotion
133 -- p_manager_comments
134 -- p_attribute_category
135 -- p_attribute1
136 -- p_attribute2
137 -- p_attribute3
138 -- p_attribute4
139 -- p_attribute5
140 -- p_attribute6
141 -- p_attribute7
142 -- p_attribute8
143 -- p_attribute9
144 -- p_attribute10
145 -- p_attribute11
146 -- p_attribute12
147 -- p_attribute13
148 -- p_attribute14
149 -- p_attribute15
150 -- p_attribute16
151 -- p_attribute17
152 -- p_attribute18
153 -- p_attribute19
154 -- p_attribute20
155 -- p_effective_date
156 -- p_job_id
157 -- p_successee_person_id
158 -- p_person_rank
159 -- p_performance
160 -- p_plan_status
161 -- p_readiness_percentage
162 -- p_succession_plan_id
163 -- p_object_version_number
164
165 --
166 --
167 -- Post Success:
168 --
169 --
170 -- Name Type Description
171 -- p_object_version_number NUMBER Object Version Number.
172
173 -- Post Failure:
174 --
175 --
176 -- Access Status:
177 -- Public.
178 --
179 -- {End Of Comments}
180 --
181 PROCEDURE update_succession_plan (
182 p_validate IN BOOLEAN DEFAULT FALSE,
183 p_succession_plan_id IN NUMBER,
184 p_person_id IN NUMBER DEFAULT hr_api.g_number,
185 p_position_id IN NUMBER DEFAULT hr_api.g_number,
186 p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
187 p_start_date IN DATE DEFAULT hr_api.g_date,
188 p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
189 p_end_date IN DATE DEFAULT hr_api.g_date,
190 p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
191 p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
192 p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
193 p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
194 p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
195 p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
196 p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
197 p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
198 p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
199 p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
200 p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
201 p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
202 p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
203 p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
204 p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
205 p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
206 p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
207 p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
208 p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
209 p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
210 p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
211 p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
212 p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
213 p_effective_date IN DATE,
214 p_job_id IN NUMBER DEFAULT hr_api.g_number,
215 p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
216 p_person_rank IN NUMBER DEFAULT hr_api.g_number,
217 p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
218 p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
219 p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
220 p_object_version_number IN OUT NOCOPY NUMBER
221 );
222
223 --
224 -- ----------------------------------------------------------------------------
225 -- |-----------------------------< delete_succession_plan >-------------------------|
226 -- ----------------------------------------------------------------------------
227 --
228 -- {Start Of Comments}
229 --
230 -- Description:
231 -- This API deletes an existing Succession Plan.
232 --
233 -- Pre Conditions:
234 -- A valid Succession Plan must already exist.
235 -- In Parameters:
236 -- p_validate
237 -- If true, then validation alone will be performed and the
238 -- database will remain unchanged. If false and all validation checks pass,
239 -- then the database will be modified.
240 --
241 -- p_succession_plan_id
242 -- Id of the plan to be deleted. If p_validate is false,
243 -- uniquely identifies the plan to be deleted. If p_validate is true, set
244 -- to null.
245 --
246 -- p_object_version_number
247 -- Current version number of the succession Plan to be
248 -- deleted.
249 --
250 -- Post Success:
251 -- The specified row will be validated and deleted for the specified
252 -- entity without being committed (or rollbacked depending on the
253 -- p_validate status).
254 --
255 -- Post Failure:
256 -- If an error has occurred, an error message will be supplied with the work
257 -- rolled back.
258 --
259 --
260 -- {End Of Comments}
261 --
262 PROCEDURE delete_succession_plan (
263 p_validate IN BOOLEAN DEFAULT FALSE,
264 p_succession_plan_id IN NUMBER,
265 p_object_version_number IN NUMBER
266 );
267 --
268 END per_succession_plan_api;