1 PACKAGE ghr_posn_copy AS
2 /* $Header: ghrposcp.pkh 120.0 2005/05/29 03:37:15 appldev noship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |--------------------------< get_seq_location >---------------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start of Comments}
8 --
9 -- Description:
10 -- Retrieve location of sequence number in Position Key Flex.
11 --
12 -- Prerequisites:
13 -- Organization Id.
14 --
15 -- In Parameters:
16 -- p_org_id.
17 --
18 -- Post Success:
19 -- Returns segment name of sequence number data item.
20 --
21 -- Post Failure:
22 -- An application error will be raised and processing is terminated.
23 --
24 -- Developer Implementation Notes:
25 --
26 -- Access Status:
27 --
28 --
29 -- {End of Comments}
30 -- ---------------------------------------------------------------------------
31 function get_seq_location
32 (p_business_group_id in NUMBER default NULL)
33 return VARCHAR2;
34 --
35 --
36 -- ---------------------------------------------------------------------------
37 -- |--------------------------< get_max_seq>--------------------------|
38 -- ---------------------------------------------------------------------------
39 -- {Start of Comments}
40 --
41 -- Description:
42 -- Retrieve the maximum existing sequence value from the Position Key Flexfield
43 -- where all other segments are the same as position being created.
44 --
45 -- Prerequisites:
46 --
47 --
48 -- In Parameters:
49 -- p_segment1 - p_segment30.
50 --
51 -- Post Success:
52 -- Returns max value of existing combination or returns 1.
53 --
54 -- Post Failure:
55 -- An application error will be raised and processing is terminated.
56 --
57 -- Developer Implementation Notes:
58 --
59 -- Access Status:
60 --
61 --
62 -- {End of Comments}
63 -- ---------------------------------------------------------------------------
64 function get_max_seq
65 (p_seq_location in VARCHAR2,
66 p_business_group_id in NUMBER default NULL,
67 p_segment1 in VARCHAR2 default NULL,
68 p_segment2 in VARCHAR2 default NULL,
69 p_segment3 in VARCHAR2 default NULL,
70 p_segment4 in VARCHAR2 default NULL,
71 p_segment5 in VARCHAR2 default NULL,
72 p_segment6 in VARCHAR2 default NULL,
73 p_segment7 in VARCHAR2 default NULL,
74 p_segment8 in VARCHAR2 default NULL,
75 p_segment9 in VARCHAR2 default NULL,
76 p_segment10 in VARCHAR2 default NULL,
77 p_segment11 in VARCHAR2 default NULL,
78 p_segment12 in VARCHAR2 default NULL,
79 p_segment13 in VARCHAR2 default NULL,
80 p_segment14 in VARCHAR2 default NULL,
81 p_segment15 in VARCHAR2 default NULL,
82 p_segment16 in VARCHAR2 default NULL,
83 p_segment17 in VARCHAR2 default NULL,
84 p_segment18 in VARCHAR2 default NULL,
85 p_segment19 in VARCHAR2 default NULL,
86 p_segment20 in VARCHAR2 default NULL,
87 p_segment21 in VARCHAR2 default NULL,
88 p_segment22 in VARCHAR2 default NULL,
89 p_segment23 in VARCHAR2 default NULL,
90 p_segment24 in VARCHAR2 default NULL,
91 p_segment25 in VARCHAR2 default NULL,
92 p_segment26 in VARCHAR2 default NULL,
93 p_segment27 in VARCHAR2 default NULL,
94 p_segment28 in VARCHAR2 default NULL,
95 p_segment29 in VARCHAR2 default NULL,
96 p_segment30 in VARCHAR2 default NULL)
97 return VARCHAR2;
98
99 /*
100 This procedure will be called directly from Position Copy Form and will
101 create both the position and the required children. Parameters are as per
102 the Position API with 1 additional for source position id (position being copied).
103 */
104
105 procedure create_position_copy
106 (p_position_id in out nocopy number
107 ,p_effective_start_date out nocopy date
108 ,p_effective_end_date out nocopy date
109 ,p_position_definition_id out nocopy number
110 ,p_name out nocopy varchar2
111 ,p_object_version_number out nocopy number
112 ,p_job_id in number
113 ,p_organization_id in number
114 ,p_effective_date in date
115 ,p_date_effective in date
116 ,p_validate in boolean default false
117 ,p_availability_status_id in number default null
118 ,p_business_group_id in number default null
119 ,p_entry_step_id in number default null
120 ,p_entry_grade_rule_id in number default null
121 ,p_location_id in number default null
122 ,p_pay_freq_payroll_id in number default null
123 ,p_position_transaction_id in number default null
124 ,p_prior_position_id in number default null
125 ,p_relief_position_id in number default null
126 ,p_entry_grade_id in number default null
127 ,p_successor_position_id in number default null
128 ,p_supervisor_position_id in number default null
129 ,p_amendment_date in date default null
130 ,p_amendment_recommendation in varchar2 default null
131 ,p_amendment_ref_number in varchar2 default null
132 ,p_bargaining_unit_cd in varchar2 default null
133 ,p_comments in long default null
134 ,p_current_job_prop_end_date in date default null
135 ,p_current_org_prop_end_date in date default null
136 ,p_avail_status_prop_end_date in date default null
137 ,p_date_end in date default null
138 ,p_earliest_hire_date in date default null
139 ,p_fill_by_date in date default null
140 ,p_frequency in varchar2 default null
141 ,p_fte in number default null
142 ,p_max_persons in number default null
143 ,p_overlap_period in number default null
144 ,p_overlap_unit_cd in varchar2 default null
145 ,p_pay_term_end_day_cd in varchar2 default null
146 ,p_pay_term_end_month_cd in varchar2 default null
147 ,p_permanent_temporary_flag in varchar2 default null
148 ,p_permit_recruitment_flag in varchar2 default null
149 ,p_position_type in varchar2 default 'NONE'
150 ,p_posting_description in varchar2 default null
151 ,p_probation_period in number default null
152 ,p_probation_period_unit_cd in varchar2 default null
153 ,p_replacement_required_flag in varchar2 default null
154 ,p_review_flag in varchar2 default null
155 ,p_seasonal_flag in varchar2 default null
156 ,p_security_requirements in varchar2 default null
157 ,p_status in varchar2 default null
158 ,p_term_start_day_cd in varchar2 default null
159 ,p_term_start_month_cd in varchar2 default null
160 ,p_time_normal_finish in varchar2 default null
161 ,p_time_normal_start in varchar2 default null
162 ,p_update_source_cd in varchar2 default null
163 ,p_working_hours in number default null
164 ,p_works_council_approval_flag in varchar2 default null
165 ,p_work_period_type_cd in varchar2 default null
166 ,p_work_term_end_day_cd in varchar2 default null
167 ,p_work_term_end_month_cd in varchar2 default null
168 ,p_proposed_fte_for_layoff in number default null
169 ,p_proposed_date_for_layoff in date default null
170 ,p_pay_basis_id in number default null
171 ,p_supervisor_id in number default null
172 ,p_information1 in varchar2 default null
173 ,p_information2 in varchar2 default null
174 ,p_information3 in varchar2 default null
175 ,p_information4 in varchar2 default null
176 ,p_information5 in varchar2 default null
177 ,p_information6 in varchar2 default null
178 ,p_information7 in varchar2 default null
179 ,p_information8 in varchar2 default null
180 ,p_information9 in varchar2 default null
181 ,p_information10 in varchar2 default null
182 ,p_information11 in varchar2 default null
183 ,p_information12 in varchar2 default null
184 ,p_information13 in varchar2 default null
185 ,p_information14 in varchar2 default null
186 ,p_information15 in varchar2 default null
187 ,p_information16 in varchar2 default null
188 ,p_information17 in varchar2 default null
189 ,p_information18 in varchar2 default null
190 ,p_information19 in varchar2 default null
191 ,p_information20 in varchar2 default null
192 ,p_information21 in varchar2 default null
193 ,p_information22 in varchar2 default null
194 ,p_information23 in varchar2 default null
195 ,p_information24 in varchar2 default null
196 ,p_information25 in varchar2 default null
197 ,p_information26 in varchar2 default null
198 ,p_information27 in varchar2 default null
199 ,p_information28 in varchar2 default null
200 ,p_information29 in varchar2 default null
201 ,p_information30 in varchar2 default null
202 ,p_information_category in varchar2 default null
203 ,p_attribute1 in varchar2 default null
204 ,p_attribute2 in varchar2 default null
205 ,p_attribute3 in varchar2 default null
206 ,p_attribute4 in varchar2 default null
207 ,p_attribute5 in varchar2 default null
208 ,p_attribute6 in varchar2 default null
209 ,p_attribute7 in varchar2 default null
210 ,p_attribute8 in varchar2 default null
211 ,p_attribute9 in varchar2 default null
212 ,p_attribute10 in varchar2 default null
213 ,p_attribute11 in varchar2 default null
214 ,p_attribute12 in varchar2 default null
215 ,p_attribute13 in varchar2 default null
216 ,p_attribute14 in varchar2 default null
217 ,p_attribute15 in varchar2 default null
218 ,p_attribute16 in varchar2 default null
219 ,p_attribute17 in varchar2 default null
220 ,p_attribute18 in varchar2 default null
221 ,p_attribute19 in varchar2 default null
222 ,p_attribute20 in varchar2 default null
223 ,p_attribute21 in varchar2 default null
224 ,p_attribute22 in varchar2 default null
225 ,p_attribute23 in varchar2 default null
226 ,p_attribute24 in varchar2 default null
227 ,p_attribute25 in varchar2 default null
228 ,p_attribute26 in varchar2 default null
229 ,p_attribute27 in varchar2 default null
230 ,p_attribute28 in varchar2 default null
231 ,p_attribute29 in varchar2 default null
232 ,p_attribute30 in varchar2 default null
233 ,p_attribute_category in varchar2 default null
234 ,p_segment1 in varchar2 default null
235 ,p_segment2 in varchar2 default null
236 ,p_segment3 in varchar2 default null
237 ,p_segment4 in varchar2 default null
238 ,p_segment5 in varchar2 default null
239 ,p_segment6 in varchar2 default null
240 ,p_segment7 in varchar2 default null
241 ,p_segment8 in varchar2 default null
242 ,p_segment9 in varchar2 default null
243 ,p_segment10 in varchar2 default null
244 ,p_segment11 in varchar2 default null
245 ,p_segment12 in varchar2 default null
246 ,p_segment13 in varchar2 default null
247 ,p_segment14 in varchar2 default null
248 ,p_segment15 in varchar2 default null
249 ,p_segment16 in varchar2 default null
250 ,p_segment17 in varchar2 default null
251 ,p_segment18 in varchar2 default null
252 ,p_segment19 in varchar2 default null
253 ,p_segment20 in varchar2 default null
254 ,p_segment21 in varchar2 default null
255 ,p_segment22 in varchar2 default null
256 ,p_segment23 in varchar2 default null
257 ,p_segment24 in varchar2 default null
258 ,p_segment25 in varchar2 default null
259 ,p_segment26 in varchar2 default null
260 ,p_segment27 in varchar2 default null
261 ,p_segment28 in varchar2 default null
262 ,p_segment29 in varchar2 default null
263 ,p_segment30 in varchar2 default null
264 ,p_concat_segments in varchar2 default null
265 ,p_request_id in number default null
266 ,p_program_application_id in number default null
267 ,p_program_id in number default null
268 ,p_program_update_date in date default null
269 );
270
271 --
272 -- Given a from position id this procedure will create ALL the extra info
273 -- details associated with the from position id onto the to position id
274 -- For position copy we will explicity exclude types:
275 -- GHR_US_POS_MASS_ACTIONS
276 -- GHR_US_POS_OBLIG
277
278 PROCEDURE create_all_posn_ei (p_source_posn_id IN NUMBER
279 ,p_effective_date IN DATE
280 ,p_position_id IN NUMBER
281 ,p_date_effective IN DATE);
282 --
283 -- Given a from position id and information type this procedure will create the extra info
284 -- details associated with the from position id onto the to position id
285 PROCEDURE create_posn_ei (p_source_posn_id IN NUMBER
286 ,p_effective_date IN DATE
290 --
287 ,p_position_id IN NUMBER
288 ,p_date_effective IN DATE
289 ,p_info_type IN VARCHAR2);
291 --
292 END ghr_posn_copy;
293