[Home] [Help]
PACKAGE: APPS.PER_SUCCESSION_PLAN_API
Source
1 Package PER_SUCCESSION_PLAN_API as
2 /* $Header: pesucapi.pkh 120.3 2008/02/07 13:07:57 schowdhu noship $ */
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_succession_plan_id
51 -- p_object_version_number
52 --
53 -- Post Failure:
54 -- The API does not create the plan and raises an error.
55 --
56 -- Post Success:
57 -- The API creates the plan.
58
59 --
60 -- Access Status:
61 -- Public.
62 --
63 -- {End Of Comments}
64 --
65 procedure create_succession_plan
66 (p_validate in boolean default false,
67 p_person_id in number,
68 p_position_id in number default null,
69 p_business_group_id in number,
70 p_start_date in date,
71 p_time_scale in varchar2,
72 p_end_date in date default null,
73 p_available_for_promotion in varchar2 default null,
74 p_manager_comments in varchar2 default null,
75 p_attribute_category in varchar2 default null,
76 p_attribute1 in varchar2 default null,
77 p_attribute2 in varchar2 default null,
78 p_attribute3 in varchar2 default null,
79 p_attribute4 in varchar2 default null,
80 p_attribute5 in varchar2 default null,
81 p_attribute6 in varchar2 default null,
82 p_attribute7 in varchar2 default null,
83 p_attribute8 in varchar2 default null,
84 p_attribute9 in varchar2 default null,
85 p_attribute10 in varchar2 default null,
86 p_attribute11 in varchar2 default null,
87 p_attribute12 in varchar2 default null,
88 p_attribute13 in varchar2 default null,
89 p_attribute14 in varchar2 default null,
90 p_attribute15 in varchar2 default null,
91 p_attribute16 in varchar2 default null,
92 p_attribute17 in varchar2 default null,
93 p_attribute18 in varchar2 default null,
94 p_attribute19 in varchar2 default null,
95 p_attribute20 in varchar2 default null,
96 p_effective_date in date,
97 p_job_id in number default null,
98 p_successee_person_id in number default null,
99 p_succession_plan_id out nocopy number,
100 p_object_version_number out nocopy number
101 );
102 --
103 -- ----------------------------------------------------------------------------
104 -- |--------------------------< UPDATE_SUCCESSION_PLAN> >--------------------------|
105 -- ----------------------------------------------------------------------------
106 -- {Start Of Comments}
107 --
108 -- Description:
109 -- It Updates an existing Succession Planning record.
110 --
111 -- Prerequisites:
112 --
113 --
114 -- In Parameters:
115 -- Name
116 -- p_validate
117 -- p_person_id
118 -- p_position_id
119 -- p_business_group_id
120 -- p_start_date
121 -- p_time_scale
122 -- p_end_date
123 -- p_available_for_promotion
124 -- p_manager_comments
125 -- p_attribute_category
126 -- p_attribute1
127 -- p_attribute2
128 -- p_attribute3
129 -- p_attribute4
130 -- p_attribute5
131 -- p_attribute6
132 -- p_attribute7
133 -- p_attribute8
134 -- p_attribute9
135 -- p_attribute10
136 -- p_attribute11
137 -- p_attribute12
138 -- p_attribute13
139 -- p_attribute14
140 -- p_attribute15
141 -- p_attribute16
142 -- p_attribute17
143 -- p_attribute18
144 -- p_attribute19
145 -- p_attribute20
146 -- p_effective_date
147 -- p_job_id
148 -- p_successee_person_id
149 -- p_succession_plan_id
150 -- p_object_version_number
151
152 --
153 --
154 -- Post Success:
155 --
156 --
157 -- Name Type Description
158 -- p_object_version_number NUMBER Object Version Number.
159
160 -- Post Failure:
161 --
162 --
163 -- Access Status:
164 -- Public.
165 --
166 -- {End Of Comments}
167 --
168 procedure update_succession_plan
169 (p_validate in boolean default false,
170 p_succession_plan_id in number,
171 p_person_id in number default hr_api.g_number,
172 p_position_id in number default hr_api.g_number,
173 p_business_group_id in number default hr_api.g_number,
174 p_start_date in date default hr_api.g_date,
175 p_time_scale in varchar2 default hr_api.g_varchar2,
176 p_end_date in date default hr_api.g_date,
177 p_available_for_promotion in varchar2 default hr_api.g_varchar2,
178 p_manager_comments in varchar2 default hr_api.g_varchar2,
179 p_attribute_category in varchar2 default hr_api.g_varchar2,
180 p_attribute1 in varchar2 default hr_api.g_varchar2,
181 p_attribute2 in varchar2 default hr_api.g_varchar2,
182 p_attribute3 in varchar2 default hr_api.g_varchar2,
183 p_attribute4 in varchar2 default hr_api.g_varchar2,
184 p_attribute5 in varchar2 default hr_api.g_varchar2,
185 p_attribute6 in varchar2 default hr_api.g_varchar2,
186 p_attribute7 in varchar2 default hr_api.g_varchar2,
187 p_attribute8 in varchar2 default hr_api.g_varchar2,
188 p_attribute9 in varchar2 default hr_api.g_varchar2,
189 p_attribute10 in varchar2 default hr_api.g_varchar2,
190 p_attribute11 in varchar2 default hr_api.g_varchar2,
191 p_attribute12 in varchar2 default hr_api.g_varchar2,
192 p_attribute13 in varchar2 default hr_api.g_varchar2,
193 p_attribute14 in varchar2 default hr_api.g_varchar2,
194 p_attribute15 in varchar2 default hr_api.g_varchar2,
195 p_attribute16 in varchar2 default hr_api.g_varchar2,
196 p_attribute17 in varchar2 default hr_api.g_varchar2,
197 p_attribute18 in varchar2 default hr_api.g_varchar2,
198 p_attribute19 in varchar2 default hr_api.g_varchar2,
199 p_attribute20 in varchar2 default hr_api.g_varchar2,
200 p_effective_date in date,
201 p_job_id in number default hr_api.g_number,
202 p_successee_person_id in number default hr_api.g_number,
203 p_object_version_number in out nocopy number
204 );
205 --
206 -- ----------------------------------------------------------------------------
207 -- |-----------------------------< delete_succession_plan >-------------------------|
208 -- ----------------------------------------------------------------------------
209 --
210 -- {Start Of Comments}
211 --
212 -- Description:
213 -- This API deletes an existing Succession Plan.
214 --
215 -- Pre Conditions:
216 -- A valid Succession Plan must already exist.
217 -- In Parameters:
218 -- p_validate
219 -- If true, then validation alone will be performed and the
220 -- database will remain unchanged. If false and all validation checks pass,
221 -- then the database will be modified.
222 --
223 -- p_succession_plan_id
224 -- Id of the plan to be deleted. If p_validate is false,
225 -- uniquely identifies the plan to be deleted. If p_validate is true, set
226 -- to null.
227 --
228 -- p_object_version_number
229 -- Current version number of the succession Plan to be
230 -- deleted.
231 --
232 -- Post Success:
233 -- The specified row will be validated and deleted for the specified
234 -- entity without being committed (or rollbacked depending on the
235 -- p_validate status).
236 --
237 -- Post Failure:
238 -- If an error has occurred, an error message will be supplied with the work
239 -- rolled back.
240 --
241 --
242 -- {End Of Comments}
243 --
244 procedure delete_succession_plan
245 (p_validate in boolean default false,
246 p_succession_plan_id in number,
247 p_object_version_number in number
248 );
249 --
250 --
251 end PER_SUCCESSION_PLAN_API;