1 PACKAGE per_succession_plan_swi AUTHID CURRENT_USER AS
2 /* $Header: pesucswi.pkh 120.0.12010000.4 2010/02/13 19:35:43 schowdhu ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_succession_plan >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: per_succession_plan_api.create_succession_plan
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_succession_plan (
27 p_validate IN NUMBER DEFAULT hr_api.g_false_num,
28 p_person_id IN NUMBER,
29 p_position_id IN NUMBER DEFAULT NULL,
30 p_business_group_id IN NUMBER,
31 p_start_date IN DATE,
32 p_time_scale IN VARCHAR2,
33 p_end_date IN DATE DEFAULT NULL,
34 p_available_for_promotion IN VARCHAR2 DEFAULT NULL,
35 p_manager_comments IN VARCHAR2 DEFAULT NULL,
36 p_attribute_category IN VARCHAR2 DEFAULT NULL,
37 p_attribute1 IN VARCHAR2 DEFAULT NULL,
38 p_attribute2 IN VARCHAR2 DEFAULT NULL,
39 p_attribute3 IN VARCHAR2 DEFAULT NULL,
40 p_attribute4 IN VARCHAR2 DEFAULT NULL,
41 p_attribute5 IN VARCHAR2 DEFAULT NULL,
42 p_attribute6 IN VARCHAR2 DEFAULT NULL,
43 p_attribute7 IN VARCHAR2 DEFAULT NULL,
44 p_attribute8 IN VARCHAR2 DEFAULT NULL,
45 p_attribute9 IN VARCHAR2 DEFAULT NULL,
46 p_attribute10 IN VARCHAR2 DEFAULT NULL,
47 p_attribute11 IN VARCHAR2 DEFAULT NULL,
48 p_attribute12 IN VARCHAR2 DEFAULT NULL,
49 p_attribute13 IN VARCHAR2 DEFAULT NULL,
50 p_attribute14 IN VARCHAR2 DEFAULT NULL,
51 p_attribute15 IN VARCHAR2 DEFAULT NULL,
52 p_attribute16 IN VARCHAR2 DEFAULT NULL,
53 p_attribute17 IN VARCHAR2 DEFAULT NULL,
54 p_attribute18 IN VARCHAR2 DEFAULT NULL,
55 p_attribute19 IN VARCHAR2 DEFAULT NULL,
56 p_attribute20 IN VARCHAR2 DEFAULT NULL,
57 p_effective_date IN DATE,
58 p_job_id IN NUMBER DEFAULT NULL,
59 p_successee_person_id IN NUMBER DEFAULT NULL,
60 p_person_rank IN NUMBER,
61 p_performance IN VARCHAR2,
62 p_plan_status IN VARCHAR2 DEFAULT NULL,
63 p_readiness_percentage IN NUMBER DEFAULT NULL,
64 p_succession_plan_id IN NUMBER,
65 p_object_version_number OUT NOCOPY NUMBER,
66 p_return_status OUT NOCOPY VARCHAR2
67 );
68
69 -- ----------------------------------------------------------------------------
70 -- |------------------------< delete_succession_plan >------------------------|
71 -- ----------------------------------------------------------------------------
72 -- {Start of comments}
73 --
74 -- Description:
75 -- This procedure is the self-service wrapper procedure to the following
76 -- API: per_succession_plan_api.delete_succession_plan
77 --
78 -- Pre-requisites
79 -- All 'IN' parameters to this procedure have been appropriately derived.
80 --
81 -- Post Success:
82 -- p_return_status will return value indicating success.
83 --
84 -- Post Failure:
85 -- p_return_status will return value indication failure.
86 --
87 -- Access Status:
88 -- Internal Development use only.
89 --
90 -- {End of comments}
91 -- ----------------------------------------------------------------------------
92 PROCEDURE delete_succession_plan (
93 p_validate IN NUMBER DEFAULT hr_api.g_false_num,
94 p_succession_plan_id IN NUMBER,
95 p_object_version_number IN NUMBER,
96 p_return_status OUT NOCOPY VARCHAR2
97 );
98
99 -- ----------------------------------------------------------------------------
100 -- |------------------------< update_succession_plan >------------------------|
101 -- ----------------------------------------------------------------------------
102 -- {Start of comments}
103 --
104 -- Description:
105 -- This procedure is the self-service wrapper procedure to the following
106 -- API: per_succession_plan_api.update_succession_plan
107 --
108 -- Pre-requisites
109 -- All 'IN' parameters to this procedure have been appropriately derived.
110 --
111 -- Post Success:
112 -- p_return_status will return value indicating success.
113 --
114 -- Post Failure:
115 -- p_return_status will return value indication failure.
116 --
117 -- Access Status:
118 -- Internal Development use only.
119 --
120 -- {End of comments}
121 -- ----------------------------------------------------------------------------
122 PROCEDURE update_succession_plan (
123 p_validate IN NUMBER DEFAULT hr_api.g_false_num,
124 p_succession_plan_id IN NUMBER,
125 p_person_id IN NUMBER DEFAULT hr_api.g_number,
126 p_position_id IN NUMBER DEFAULT hr_api.g_number,
127 p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
128 p_start_date IN DATE DEFAULT hr_api.g_date,
129 p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
130 p_end_date IN DATE DEFAULT hr_api.g_date,
131 p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
132 p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
133 p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
134 p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
135 p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
136 p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
137 p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
138 p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
139 p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
140 p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
141 p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
142 p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
143 p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
144 p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
145 p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
146 p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
147 p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
148 p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
149 p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
150 p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
151 p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
152 p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
153 p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
154 p_effective_date IN DATE,
155 p_job_id IN NUMBER DEFAULT hr_api.g_number,
156 p_person_rank IN NUMBER DEFAULT hr_api.g_number,
157 p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
158 p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
159 p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number,
160 p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
161 p_object_version_number IN OUT NOCOPY NUMBER,
162 p_return_status OUT NOCOPY VARCHAR2
163 );
164 END per_succession_plan_swi;