1 Package irc_location_preferences_swi AUTHID CURRENT_USER As
2 /* $Header: irilpswi.pkh 120.1 2011/01/05 07:15:08 avarri noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-----------------------< create_vac_rec_area_value >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: irc_location_preferences_api.create_vac_rec_area_value
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_vac_rec_area_value
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_vacancy_id in number default null
30 ,p_hierarchy_version_id in number default null
31 ,p_hierarchy_name in varchar2 default null
32 ,p_vac_rec_area_id in out nocopy number
33 ,p_object_version_number out nocopy number
34 ,p_return_status out nocopy varchar2
35 );
36 --
37 -- ----------------------------------------------------------------------------
38 -- |----------------------< delete_location_preference >----------------------|
39 -- ----------------------------------------------------------------------------
40 -- {Start of comments}
41 --
42 -- Description:
43 -- This procedure is the self-service wrapper procedure to the following
44 -- API: irc_location_preferences_api.delete_location_preference
45 --
46 -- Pre-requisites
47 -- All 'IN' parameters to this procedure have been appropriately derived.
48 --
49 -- Post Success:
50 -- p_return_status will return value indicating success.
51 --
52 -- Post Failure:
53 -- p_return_status will return value indication failure.
54 --
55 -- Access Status:
56 -- Internal Development use only.
57 --
58 -- {End of comments}
59 -- ----------------------------------------------------------------------------
60 PROCEDURE delete_location_preference
61 (p_validate in number default hr_api.g_false_num
62 ,p_location_pref_id in number
63 ,p_object_version_number in number
64 ,p_return_status out nocopy varchar2
65 );
66 -- ----------------------------------------------------------------------------
67 -- |----------------------< create_location_preference >----------------------|
68 -- ----------------------------------------------------------------------------
69 -- {Start of comments}
70 --
71 -- Description:
72 -- This procedure is the self-service wrapper procedure to the following
73 -- API: irc_location_preferences_api.create_location_preference
74 --
75 -- Pre-requisites
76 -- All 'IN' parameters to this procedure have been appropriately derived.
77 --
78 -- Post Success:
79 -- p_return_status will return value indicating success.
80 --
81 -- Post Failure:
82 -- p_return_status will return value indication failure.
83 --
84 -- Access Status:
85 -- Internal Development use only.
86 --
87 -- {End of comments}
88 -- ----------------------------------------------------------------------------
89 PROCEDURE create_location_preference
90 (p_validate in number default hr_api.g_false_num
91 ,p_effective_date in date
92 ,p_object_id in number
93 ,p_object_type in varchar2
94 ,p_rec_area_id in number default null
95 ,p_business_group_id in number default null
96 ,p_country_code in varchar2 default null
100 ,p_attribute2 in varchar2 default null
97 ,p_location_id in number default null
98 ,p_attribute_category in varchar2 default null
99 ,p_attribute1 in varchar2 default null
101 ,p_attribute3 in varchar2 default null
102 ,p_attribute4 in varchar2 default null
103 ,p_attribute5 in varchar2 default null
104 ,p_attribute6 in varchar2 default null
105 ,p_attribute7 in varchar2 default null
106 ,p_attribute8 in varchar2 default null
107 ,p_attribute9 in varchar2 default null
108 ,p_attribute10 in varchar2 default null
109 ,p_attribute11 in varchar2 default null
110 ,p_attribute12 in varchar2 default null
111 ,p_attribute13 in varchar2 default null
112 ,p_attribute14 in varchar2 default null
113 ,p_attribute15 in varchar2 default null
114 ,p_attribute16 in varchar2 default null
115 ,p_attribute17 in varchar2 default null
116 ,p_attribute18 in varchar2 default null
117 ,p_attribute19 in varchar2 default null
118 ,p_attribute20 in varchar2 default null
119 ,p_attribute21 in varchar2 default null
120 ,p_attribute22 in varchar2 default null
121 ,p_attribute23 in varchar2 default null
122 ,p_attribute24 in varchar2 default null
123 ,p_attribute25 in varchar2 default null
124 ,p_attribute26 in varchar2 default null
125 ,p_attribute27 in varchar2 default null
126 ,p_attribute28 in varchar2 default null
127 ,p_attribute29 in varchar2 default null
128 ,p_attribute30 in varchar2 default null
129 ,p_location_pref_id in out nocopy number
130 ,p_object_version_number out nocopy number
131 ,p_return_status out nocopy varchar2
132 );
133 -- ----------------------------------------------------------------------------
134 -- |-----------------------< delete_vac_rec_area_value >----------------------|
135 -- ----------------------------------------------------------------------------
136 -- {Start of comments}
137 --
138 -- Description:
139 -- This procedure is the self-service wrapper procedure to the following
140 -- API: irc_location_preferences_api.delete_vac_rec_area_value
141 --
142 -- Pre-requisites
143 -- All 'IN' parameters to this procedure have been appropriately derived.
144 --
145 -- Post Success:
146 -- p_return_status will return value indicating success.
147 --
148 -- Post Failure:
149 -- p_return_status will return value indication failure.
150 --
151 -- Access Status:
152 -- Internal Development use only.
153 --
154 -- {End of comments}
155 -- ----------------------------------------------------------------------------
156 PROCEDURE delete_vac_rec_area_value
157 (p_validate in number default hr_api.g_false_num
158 ,p_vac_rec_area_id in number
159 ,p_object_version_number in number
160 ,p_return_status out nocopy varchar2
161 );
162 --
163 -- ----------------------------------------------------------------------------
164 -- |-----------------------< update_vac_rec_area_value >----------------------|
165 -- ----------------------------------------------------------------------------
166 -- {Start of comments}
167 --
168 -- Description:
169 -- This procedure is the self-service wrapper procedure to the following
170 -- API: irc_location_preferences_api.update_vac_rec_area_value
171 --
172 -- Pre-requisites
173 -- All 'IN' parameters to this procedure have been appropriately derived.
174 --
175 -- Post Success:
176 -- p_return_status will return value indicating success.
177 --
178 -- Post Failure:
179 -- p_return_status will return value indication failure.
180 --
181 -- Access Status:
182 -- Internal Development use only.
183 --
184 -- {End of comments}
185 -- ----------------------------------------------------------------------------
186 PROCEDURE update_vac_rec_area_value
187 (p_validate in number default hr_api.g_false_num
188 ,p_effective_date in date
189 ,p_vacancy_id in number default hr_api.g_number
190 ,p_hierarchy_version_id in number default hr_api.g_number
191 ,p_hierarchy_name in varchar2 default hr_api.g_varchar2
192 ,p_vac_rec_area_id in number
193 ,p_object_version_number in out nocopy number
194 ,p_return_status out nocopy varchar2
195 );
196 --
197 -- ----------------------------------------------------------------------------
198 -- |-------------------------< process_vac_rec_area_api >--------------------|
199 -- ----------------------------------------------------------------------------
200 procedure process_vac_rec_area_api
201 (
202 p_document in CLOB
203 ,p_return_status out nocopy VARCHAR2
204 ,p_validate in number default hr_api.g_false_num
205 ,p_effective_date in date default null
206 );
207 --
208 -- ----------------------------------------------------------------------------
209 -- |-------------------------< process_location_pref_api >--------------------|
210 -- ----------------------------------------------------------------------------
211 procedure process_location_pref_api
212 (
213 p_document in CLOB
214 ,p_return_status out nocopy VARCHAR2
215 ,p_validate in number default hr_api.g_false_num
216 ,p_effective_date in date default null
217 );
218 --
219 end irc_location_preferences_swi;