1 Package pqh_fr_assignment_swi As
2 /* $Header: pqastswi.pkh 120.0 2005/05/29 01:26 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< create_affectation >--------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_fr_assignment_api.create_affectation
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_affectation
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_organization_id in number
30 ,p_position_id in number
31 ,p_person_id in number
32 ,p_job_id in number
33 ,p_supervisor_id in number default null
34 ,p_assignment_number in out nocopy varchar2
35 ,p_assignment_status_type_id in number
36 ,p_identifier in varchar2
37 ,p_affectation_type in varchar2
38 ,p_percent_effected in varchar2
39 ,p_primary_affectation in varchar2 default null
40 ,p_group_name out nocopy varchar2
41 ,p_scl_concat_segments in varchar2 default null
42 ,p_assignment_id out nocopy number
43 ,p_soft_coding_keyflex_id in out nocopy number
44 ,p_object_version_number out nocopy number
45 ,p_effective_start_date out nocopy date
46 ,p_effective_end_date out nocopy date
47 ,p_assignment_sequence out nocopy number
48 ,p_return_status out nocopy varchar2
49 );
50
51 -- ----------------------------------------------------------------------------
52 -- |--------------------------< terminate_affectation >--------------------------|
53 -- ----------------------------------------------------------------------------
54 PROCEDURE terminate_affectation
55 (p_validate in number default hr_api.g_false_num
56 ,p_assignment_id in number
57 ,p_effective_date in date
58 ,p_assignment_status_type_id in number
59 ,p_primary_affectation in varchar2 default null
60 ,p_group_name out nocopy varchar2
61 ,p_object_version_number in out nocopy number
62 ,p_effective_start_date out nocopy date
63 ,p_effective_end_date out nocopy date
64 ,p_return_status out nocopy varchar2
65 );
66
67 -- ----------------------------------------------------------------------------
68 -- |--------------------------< update_affectation >--------------------------|
69 -- ----------------------------------------------------------------------------
70 -- {Start of comments}
71 --
72 -- Description:
73 -- This procedure is the self-service wrapper procedure to the following
74 -- API: pqh_fr_assignment_api.update_affectation
75 --
76 -- Pre-requisites
77 -- All 'IN' parameters to this procedure have been appropriately derived.
78 --
79 -- Post Success:
80 -- p_return_status will return value indicating success.
81 --
82 -- Post Failure:
83 -- p_return_status will return value indication failure.
84 --
85 -- Access Status:
86 -- Internal Development use only.
87 --
88 -- {End of comments}
89 -- ----------------------------------------------------------------------------
90 PROCEDURE update_affectation
91 (p_validate in number default hr_api.g_false_num
92 ,p_datetrack_update_mode in varchar2
93 ,p_effective_date in date
94 ,p_organization_id in number default hr_api.g_number
95 ,p_position_id in number default hr_api.g_number
96 ,p_person_id in number
97 ,p_job_id in number default hr_api.g_number
98 ,p_supervisor_id in number default hr_api.g_number
99 ,p_assignment_number in varchar2 default hr_api.g_varchar2
100 ,p_assignment_status_type_id in number default hr_api.g_number
101 ,p_identifier in varchar2 default hr_api.g_varchar2
102 ,p_affectation_type in varchar2 default hr_api.g_varchar2
103 ,p_percent_effected in varchar2 default hr_api.g_varchar2
104 ,p_primary_affectation in varchar2 default hr_api.g_varchar2
105 ,p_group_name out nocopy varchar2
106 ,p_scl_concat_segments in varchar2 default hr_api.g_varchar2
107 ,p_assignment_id in number
108 ,p_soft_coding_keyflex_id out nocopy number
109 ,p_object_version_number in out nocopy number
110 ,p_effective_start_date out nocopy date
111 ,p_effective_end_date out nocopy date
112 ,p_assignment_sequence out nocopy number
113 ,p_return_status out nocopy varchar2
114 );
115 -- ----------------------------------------------------------------------------
116 -- |------------------------< update_employment_terms >-----------------------|
117 -- ----------------------------------------------------------------------------
118 -- {Start of comments}
119 --
120 -- Description:
121 -- This procedure is the self-service wrapper procedure to the following
122 -- API: pqh_fr_assignment_api.update_employment_terms
123 --
124 -- Pre-requisites
125 -- All 'IN' parameters to this procedure have been appropriately derived.
126 --
127 -- Post Success:
128 -- p_return_status will return value indicating success.
129 --
130 -- Post Failure:
131 -- p_return_status will return value indication failure.
132 --
133 -- Access Status:
134 -- Internal Development use only.
135 --
136 -- {End of comments}
137 -- ----------------------------------------------------------------------------
138 PROCEDURE update_employment_terms
139 (p_validate in number default hr_api.g_false_num
140 ,p_datetrack_update_mode in varchar2
141 ,p_effective_date in date
142 ,p_assignment_id in number
143 ,p_establishment_id in number
144 ,p_comments in varchar2 default hr_api.g_varchar2
145 ,p_assignment_category in varchar2
146 ,p_reason_for_parttime in varchar2 default hr_api.g_varchar2
147 ,p_working_hours_share in varchar2 default hr_api.g_varchar2
148 ,p_contract_id in number default hr_api.g_number
149 ,p_change_reason in varchar2 default hr_api.g_varchar2
150 ,p_normal_hours in number default hr_api.g_number
151 ,p_frequency in varchar2 default hr_api.g_varchar2
152 ,p_soft_coding_keyflex_id out nocopy number
153 ,p_object_version_number in out nocopy number
154 ,p_effective_start_date out nocopy date
155 ,p_effective_end_date out nocopy date
156 ,p_assignment_sequence out nocopy number
157 ,p_return_status out nocopy varchar2
158 );
159 -- ----------------------------------------------------------------------------
160 -- |---------------------< update_administrative_career >---------------------|
161 -- ----------------------------------------------------------------------------
162 -- {Start of comments}
163 --
164 -- Description:
165 -- This procedure is the self-service wrapper procedure to the following
166 -- API: pqh_fr_assignment_api.update_administrative_career
167 --
168 -- Pre-requisites
169 -- All 'IN' parameters to this procedure have been appropriately derived.
170 --
171 -- Post Success:
172 -- p_return_status will return value indicating success.
173 --
174 -- Post Failure:
175 -- p_return_status will return value indication failure.
176 --
177 -- Access Status:
178 -- Internal Development use only.
179 --
180 -- {End of comments}
181 -- ----------------------------------------------------------------------------
182 PROCEDURE update_administrative_career
183 (p_validate in number default hr_api.g_false_num
184 ,p_datetrack_update_mode in varchar2
185 ,p_effective_date in date
186 ,p_assignment_id in number
187 ,p_corps_id in number default hr_api.g_number
188 ,p_grade_id in number default hr_api.g_number
189 ,p_step_id in number default hr_api.g_number
190 ,p_progression_speed in varchar2
191 ,p_personal_gross_index in varchar2
192 ,p_employee_category in varchar2
193 ,p_soft_coding_keyflex_id out nocopy number
194 ,p_object_version_number in out nocopy number
195 ,p_effective_start_date out nocopy date
196 ,p_effective_end_date out nocopy date
197 ,p_assignment_sequence out nocopy number
198 ,p_return_status out nocopy varchar2
199 );
200
201 PROCEDURE suspend_affectation
202 (p_validate in number default hr_api.g_false_num
203 ,p_assignment_id in number
204 ,p_effective_date in date
205 ,p_assignment_status_type_id in number
206 ,p_object_version_number in out nocopy number
207 ,p_effective_start_date out nocopy date
208 ,p_effective_end_date out nocopy date
209 ,p_return_status out nocopy varchar2
210 );
211
212 PROCEDURE activate_affectation
213 (p_validate in number default hr_api.g_false_num
214 ,p_assignment_id in number
215 ,p_effective_date in date
216 ,p_assignment_status_type_id in number
217 ,p_object_version_number in out nocopy number
218 ,p_effective_start_date out nocopy date
219 ,p_effective_end_date out nocopy date
220 ,p_return_status out nocopy varchar2
221 );
222
223 end pqh_fr_assignment_swi;