[Home] [Help]
PACKAGE: APPS.IRC_APPROVALS
Source
1 Package IRC_APPROVALS AUTHID CURRENT_USER as
2 /* $Header: ircame.pkh 120.12.12010000.2 2010/03/18 08:12:31 prasashe ship $ */
3
4 --
5 -- -------------------------------------------------------------------------
6 -- |------------------------< get_transaction_data >-----------------------|
7 -- -------------------------------------------------------------------------
8 --
9 function get_transaction_data
10 (p_transaction_id in varchar2
11 ,p_path in varchar2)
12 return varchar2;
13 --
14 -- -------------------------------------------------------------------------
15 -- |---------------------< get_transaction_number_data >-------------------|
16 -- -------------------------------------------------------------------------
17 --
18 function get_transaction_number_data
19 (transaction_id in varchar2
20 ,p_path in varchar2)
21 return number;
22 --
23 -- -------------------------------------------------------------------------
24 --
25 function get_posting_data_number
26 (transaction_id in varchar2, data_name in varchar2)
27 return number;
28 --
29 -- -------------------------------------------------------------------------
30 --
31 function get_posting_data_varchar
32 (transaction_id in varchar2, data_name in varchar2)
33 return varchar2;
34 --
35 -- -------------------------------------------------------------------------
36 --
37 function get_vacancy_data_number
38 (transaction_id in varchar2, data_name in varchar2)
39 return number;
40 --
41 -- -------------------------------------------------------------------------
42 --
43 function get_vacancy_data_varchar
44 (transaction_id in varchar2, data_name in varchar2)
45 return varchar2;
46 --
47 -- -------------------------------------------------------------------------
48 --
49 function get_search_data_number
50 (transaction_id in varchar2, data_name in varchar2)
51 return number;
52 --
53 -- -------------------------------------------------------------------------
54 --
55 function get_search_data_varchar
56 (transaction_id in varchar2, data_name in varchar2)
57 return varchar2;
58 --
59 -- -------------------------------------------------------------------------
60 -- |------------------------< get_transaction_mode >-----------------------|
61 -- -------------------------------------------------------------------------
62 --
63 function get_transaction_mode
64 (transaction_id in varchar2)
65 return varchar2;
66 --
67 -- -------------------------------------------------------------------------
68 -- |-----------------------< get_vac_business_group_id >-------------------|
69 -- -------------------------------------------------------------------------
70 --
71 function get_vac_business_group_id
72 (transaction_id in varchar2)
73 return number;
74 --
75 -- -------------------------------------------------------------------------
76 -- |-------------------------< get_vac_organization_id >-------------------|
77 -- -------------------------------------------------------------------------
78 --
79 function get_vac_organization_id
80 (transaction_id in varchar2)
81 return number;
82 --
83 -- -------------------------------------------------------------------------
84 -- |----------------------------< get_vac_grade_id >-----------------------|
85 -- -------------------------------------------------------------------------
86 --
87 function get_vac_grade_id
88 (transaction_id in varchar2)
89 return number;
90 --
91 -- -------------------------------------------------------------------------
92 -- |----------------------------< get_vac_job_id >-------------------------|
93 -- -------------------------------------------------------------------------
94 --
95 function get_vac_job_id
96 (transaction_id in varchar2)
97 return number;
98 --
99 -- -------------------------------------------------------------------------
100 -- |--------------------------< get_vac_location_id >----------------------|
101 -- -------------------------------------------------------------------------
102 --
103 function get_vac_location_id
104 (transaction_id in varchar2)
105 return number;
106 --
107 -- -------------------------------------------------------------------------
108 -- |--------------------------< get_vac_budget_value >----------------------|
109 -- -------------------------------------------------------------------------
110 --
111 function get_vac_budget_value
112 (transaction_id in varchar2)
113 return number;
114 --
115 -- -------------------------------------------------------------------------
116 -- |--------------------------< get_vac_budget_type >----------------------|
117 -- -------------------------------------------------------------------------
118 --
119 function get_vac_budget_type
120 (transaction_id in varchar2)
121 return varchar2;
122 --
123 -- -------------------------------------------------------------------------
124 -- |----------------------------< get_vac_status >-------------------------|
125 -- -------------------------------------------------------------------------
126 --
127 function get_vac_status
128 (transaction_id in varchar2)
129 return varchar2;
130 --
131 -- -------------------------------------------------------------------------
132 -- |-------------------------< get_vac_professional_area >-----------------|
133 -- -------------------------------------------------------------------------
134 --
135 function get_vac_professional_area
136 (transaction_id in varchar2)
137 return varchar2;
138 --
139 -- -------------------------------------------------------------------------
140 -- |-------------------------< get_vac_for_emp >---------------------------|
141 -- -------------------------------------------------------------------------
142 --
143 function get_vac_for_emp
144 (transaction_id in varchar2)
145 return varchar2;
146 --
147 -- -------------------------------------------------------------------------
148 -- |-------------------------< get_vac_for_con >---------------------------|
149 -- -------------------------------------------------------------------------
150 --
151 function get_vac_for_con
152 (transaction_id in varchar2)
153 return varchar2;
154 --
155 -- -------------------------------------------------------------------------
156 -- |--------------------< get_vac_employment_category >--------------------|
157 -- -------------------------------------------------------------------------
158 --
159 function get_vac_employment_category
160 (transaction_id in varchar2)
161 return varchar2;
162 --
163 -- -------------------------------------------------------------------------
164 -- |--------------------------< get_vac_min_salary >-----------------------|
165 -- -------------------------------------------------------------------------
166 --
167 function get_vac_min_salary
168 (transaction_id in varchar2)
169 return number;
170 --
171 -- -------------------------------------------------------------------------
172 -- |--------------------------< get_vac_max_salary >-----------------------|
173 -- -------------------------------------------------------------------------
174 --
175 function get_vac_max_salary
176 (transaction_id in varchar2)
177 return number;
178 --
179 -- -------------------------------------------------------------------------
180 -- |------------------------< get_salary_currency >------------------------|
181 -- -------------------------------------------------------------------------
182 --
183 function get_salary_currency
184 (transaction_id in varchar2)
185 return varchar2;
186 --
187 -- -------------------------------------------------------------------------
188 -- |--------------------------< get_work_at_home >-------------------------|
189 -- -------------------------------------------------------------------------
190 --
191 function get_work_at_home
192 (transaction_id in varchar2)
193 return varchar2;
194 --
195 -- -------------------------------------------------------------------------
196 -- |----------------------< get_vac_organization_changed >-----------------|
197 -- -------------------------------------------------------------------------
198 --
199 function get_vac_organization_changed
200 (transaction_id in varchar2)
201 return varchar2;
202 --
203 -- -------------------------------------------------------------------------
204 -- |----------------------< get_vac_job_changed >--------------------------|
205 -- -------------------------------------------------------------------------
206 --
207 function get_vac_job_changed
208 (transaction_id in varchar2)
209 return varchar2;
210 --
211 -- -------------------------------------------------------------------------
212 -- |----------------------< get_vac_grade_changed >------------------------|
213 -- -------------------------------------------------------------------------
214 --
215 function get_vac_grade_changed
216 (transaction_id in varchar2)
217 return varchar2;
218 --
219 -- -------------------------------------------------------------------------
220 -- |----------------------< get_vac_position_changed >---------------------|
221 -- -------------------------------------------------------------------------
222 --
223 function get_vac_position_changed
224 (transaction_id in varchar2)
225 return varchar2;
226 --
227 -- -------------------------------------------------------------------------
228 -- |--------------------< get_vac_budget_value_changed >-------------------|
229 -- -------------------------------------------------------------------------
230 --
231 function get_vac_budget_value_changed
232 (transaction_id in varchar2)
233 return varchar2;
234 --
235 -- -------------------------------------------------------------------------
236 -- |--------------------< get_vac_budget_type_changed >-------------------|
237 -- -------------------------------------------------------------------------
238 --
239 function get_vac_budget_type_changed
240 (transaction_id in varchar2)
241 return varchar2;
242 --
243 -- -------------------------------------------------------------------------
244 -- |------------------------< get_vac_status_changed >---------------------|
245 -- -------------------------------------------------------------------------
246 --
247 function get_vac_status_changed
248 (transaction_id in varchar2)
249 return varchar2;
250 --
251 -- -------------------------------------------------------------------------
252 -- |-----------------------< get_posting_title_changed >-------------------|
253 -- -------------------------------------------------------------------------
254 --
255 function get_posting_title_changed
256 (transaction_id in varchar2)
257 return varchar2;
258 --
259 -- -------------------------------------------------------------------------
260 -- |---------------------< get_posting_job_title_changed >-----------------|
261 -- -------------------------------------------------------------------------
262 --
263 function get_posting_job_title_changed
264 (transaction_id in varchar2)
265 return varchar2;
266 --
267 -- -------------------------------------------------------------------------
268 -- |---------------------< get_posting_department_changed >-----------------|
269 -- -------------------------------------------------------------------------
270 --
271 function get_posting_department_changed
272 (transaction_id in varchar2)
273 return varchar2;
274 --
275 -- -------------------------------------------------------------------------
276 -- |------------------< get_posting_dept_desc_changed >--------------------|
277 -- -------------------------------------------------------------------------
278 --
279 function get_posting_dept_desc_changed
280 (transaction_id in varchar2)
281 return varchar2;
282 --
283 -- -------------------------------------------------------------------------
284 -- |-------------------< get_brief_description_changed >-------------------|
285 -- -------------------------------------------------------------------------
286 --
287 function get_brief_description_changed
288 (transaction_id in varchar2)
289 return varchar2;
290 --
291 -- -------------------------------------------------------------------------
292 -- |----------------------< get_detailed_desc_changed >--------------------|
293 -- -------------------------------------------------------------------------
294 --
295 function get_detailed_desc_changed
296 (transaction_id in varchar2)
297 return varchar2;
298 --
299 -- -------------------------------------------------------------------------
300 -- |----------------------< get_job_requirements_changed >----------------|
301 -- -------------------------------------------------------------------------
302 --
303 function get_job_requirements_changed
304 (transaction_id in varchar2)
305 return varchar2;
306 --
307 -- -------------------------------------------------------------------------
308 -- |---------------------< get_additional_details_changed >----------------|
309 -- -------------------------------------------------------------------------
310 --
311 function get_additional_details_changed
312 (transaction_id in varchar2)
313 return varchar2;
314 --
315 -- -------------------------------------------------------------------------
316 -- |-----------------------< get_how_to_apply_changed >--------------------|
317 -- -------------------------------------------------------------------------
318 --
319 function get_how_to_apply_changed
320 (transaction_id in varchar2)
321 return varchar2;
322 --
323 -- -------------------------------------------------------------------------
324 -- |-----------------------< get_posting_graphic_changed >-----------------|
325 -- -------------------------------------------------------------------------
326 --
327 function get_posting_graphic_changed
328 (transaction_id in varchar2)
329 return varchar2;
330 --
331 -- -------------------------------------------------------------------------
332 -- |----------------------------< get_ovn_changed >------------------------|
333 -- -------------------------------------------------------------------------
334 --
335 function get_ovn_changed
336 (transaction_id in varchar2)
337 return varchar2;
338 --
339 FUNCTION getTopOffersApprover(transaction_id in varchar2)
340 return fnd_user.user_id%type;
341 --
342 FUNCTION getTopApprover(transaction_id in varchar2)
343 return fnd_user.user_id%type;
344 --
345 procedure log (message in varchar2);
346 --
347 procedure check_self_approval
348 (p_application_id in number
349 ,p_transaction_type in varchar2
350 ,p_transaction_id in varchar2
351 ,p_number_of_approvers out nocopy number
352 );
353 --
354 procedure getNotifSubjectForCreate
355 (document_id in varchar2,
356 display_type in varchar2,
357 document in out nocopy varchar2,
358 document_type in out nocopy varchar2);
359 --
360 procedure getNotifSubjectForEdit
361 (document_id in varchar2,
362 display_type in varchar2,
363 document in out nocopy varchar2,
364 document_type in out nocopy varchar2);
365 --
366 procedure getNotificationSubject (document_id in varchar2,
367 display_type in varchar2,
368 document in out nocopy varchar2,
369 document_type in out nocopy varchar2,
370 flowmode in varchar2);
371 --
372 FUNCTION getPersonNameFromID
373 (p_person_id in per_all_people_f.person_id%type)
374 return per_all_people_f.full_name%type;
375 --
376 procedure getOfferNotifSubjectForCreate
377 (document_id in varchar2,
378 display_type in varchar2,
379 document in out nocopy varchar2,
380 document_type in out nocopy varchar2);
381 --
382 procedure getOfferNotifSubjectForEdit
383 (document_id in varchar2,
384 display_type in varchar2,
385 document in out nocopy varchar2,
386 document_type in out nocopy varchar2);
387 --
388 procedure getOfferNotificationSubject (document_id in varchar2,
389 display_type in varchar2,
390 document in out nocopy varchar2,
391 document_type in out nocopy varchar2,
392 flowmode in varchar2);
393 --
394 function getVacancyIdFromAssignmentId(assignment_id number)
395 return number;
396 --
397 function getVacancyNameFromId(vacancy_id number)
398 return varchar;
399 --
400 end IRC_APPROVALS;