1 Package per_successor_in_plan_api AUTHID CURRENT_USER as
2 /* $Header: pesipapi.pkh 120.2 2011/03/26 18:42:08 schowdhu noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_successor_in_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_successor_in_plan
33 (p_validate in boolean default false
34 ,p_effective_date in date
35 ,p_plan_id in number
36 ,p_successor_id in number
37 ,p_business_group_id in number
38 ,p_status in varchar2
39 ,p_rank in number
40 ,p_potential in varchar2 default null
41 ,p_performance_rating in varchar2 default null
42 ,p_risk_of_loss in varchar2 default null
43 ,p_impact_of_loss in varchar2 default null
44 ,p_readiness_pct in number default null
45 ,p_eligible_for_promotion in varchar2 default null
46 ,p_earliest_succession_date in date default null
47 ,p_latest_succession_date in date default null
48 ,p_comments in varchar2 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_planned_date in date default null
71 ,p_assignment_id in number default null
72 ,p_supervisor_id in number default null
73 ,p_grade_id in number default null
74 ,p_grade_ladder_id in number default null
75 ,p_grade_step_id in number default null
76 ,p_grade_point_id in number default null
77 ,p_position_id in number default null
78 ,p_job_id in number default null
79 ,p_assignment_status_type_id in number default null
80 ,p_organization_id in number default null
81 ,p_people_group_id in number default null
82 ,p_pay_basis_id in number default null
83 ,p_employee_category in varchar2 default null
84 ,p_bargaining_unit_code in varchar2 default null
85 ,p_labour_union_member_flag in varchar2 default null
86 ,p_collective_agreement_id in number default null
87 ,p_assignment_category in varchar2 default null
88 ,p_location_id in number default null
89 ,p_contract_id in number default null
90 ,p_successor_in_plan_id out nocopy number
91 ,p_object_version_number out nocopy number
92 );
93 --
94 --
95 -- ----------------------------------------------------------------------------
96 -- |--------------------------< update_successor_in_plan >--------------------------|
97 -- ----------------------------------------------------------------------------
98 -- {Start Of Comments}
99 --
100 -- Description:
101 --
102 --
103 -- Prerequisites:
104 --
105 --
106 -- In Parameters:
107 -- Name Reqd Type Description
108 --
109 --
110 -- Post Success:
111 --
112 --
113 -- Name Type Description
114 --
115 -- Post Failure:
116 --
117 --
118 -- Access Status:
119 -- Public.
120 --
121 -- {End Of Comments}
122 --
123 procedure update_successor_in_plan
124 (p_validate in boolean default false
125 ,p_effective_date in date
126 ,p_successor_in_plan_id in number
127 ,p_object_version_number in out nocopy number
128 ,p_plan_id in number default hr_api.g_number
129 ,p_successor_id in number default hr_api.g_number
130 ,p_business_group_id in number default hr_api.g_number
131 ,p_status in varchar2 default hr_api.g_varchar2
132 ,p_rank in number default hr_api.g_number
133 ,p_potential in varchar2 default hr_api.g_varchar2
134 ,p_performance_rating in varchar2 default hr_api.g_varchar2
135 ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
136 ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
137 ,p_readiness_pct in number default hr_api.g_number
138 ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2
139 ,p_earliest_succession_date in date default hr_api.g_date
140 ,p_latest_succession_date in date default hr_api.g_date
141 ,p_comments in varchar2 default hr_api.g_varchar2
142 ,p_attribute_category in varchar2 default hr_api.g_varchar2
143 ,p_attribute1 in varchar2 default hr_api.g_varchar2
144 ,p_attribute2 in varchar2 default hr_api.g_varchar2
145 ,p_attribute3 in varchar2 default hr_api.g_varchar2
146 ,p_attribute4 in varchar2 default hr_api.g_varchar2
147 ,p_attribute5 in varchar2 default hr_api.g_varchar2
148 ,p_attribute6 in varchar2 default hr_api.g_varchar2
149 ,p_attribute7 in varchar2 default hr_api.g_varchar2
150 ,p_attribute8 in varchar2 default hr_api.g_varchar2
151 ,p_attribute9 in varchar2 default hr_api.g_varchar2
152 ,p_attribute10 in varchar2 default hr_api.g_varchar2
153 ,p_attribute11 in varchar2 default hr_api.g_varchar2
154 ,p_attribute12 in varchar2 default hr_api.g_varchar2
155 ,p_attribute13 in varchar2 default hr_api.g_varchar2
156 ,p_attribute14 in varchar2 default hr_api.g_varchar2
157 ,p_attribute15 in varchar2 default hr_api.g_varchar2
158 ,p_attribute16 in varchar2 default hr_api.g_varchar2
159 ,p_attribute17 in varchar2 default hr_api.g_varchar2
160 ,p_attribute18 in varchar2 default hr_api.g_varchar2
161 ,p_attribute19 in varchar2 default hr_api.g_varchar2
162 ,p_attribute20 in varchar2 default hr_api.g_varchar2
163 ,p_planned_date in date default hr_api.g_date
164 ,p_assignment_id in number default hr_api.g_number
165 ,p_supervisor_id in number default hr_api.g_number
166 ,p_grade_id in number default hr_api.g_number
167 ,p_grade_ladder_id in number default hr_api.g_number
168 ,p_grade_step_id in number default hr_api.g_number
169 ,p_grade_point_id in number default hr_api.g_number
170 ,p_position_id in number default hr_api.g_number
171 ,p_job_id in number default hr_api.g_number
172 ,p_assignment_status_type_id in number default hr_api.g_number
173 ,p_organization_id in number default hr_api.g_number
174 ,p_people_group_id in number default hr_api.g_number
175 ,p_pay_basis_id in number default hr_api.g_number
176 ,p_employee_category in varchar2 default hr_api.g_varchar2
177 ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
178 ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
179 ,p_collective_agreement_id in number default hr_api.g_number
180 ,p_assignment_category in varchar2 default hr_api.g_varchar2
181 ,p_location_id in number default hr_api.g_number
182 ,p_contract_id in number default hr_api.g_number);
183 --
184 --
185 -- ----------------------------------------------------------------------------
186 -- |--------------------------< delete_successor_in_plan >--------------------------|
187 -- ----------------------------------------------------------------------------
188 -- {Start Of Comments}
189 --
190 -- Description:
191 --
192 --
193 -- Prerequisites:
194 --
195 --
196 -- In Parameters:
197 -- Name Reqd Type Description
198 --
199 --
200 -- Post Success:
201 --
202 --
203 -- Name Type Description
204 --
205 -- Post Failure:
206 --
207 --
208 -- Access Status:
209 -- Public.
210 --
211 -- {End Of Comments}
212 --
213 procedure delete_successor_in_plan
214 (p_validate in boolean default false
215 ,p_successor_in_plan_id in number
216 ,p_object_version_number in number
217 );
218 end per_successor_in_plan_api;