DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_LOCATION_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< create_location >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_location
12: (p_validate in number default hr_api.g_false_num
13: ,p_configuration_code in varchar2
14: ,p_configuration_context in varchar2
15: ,p_location_code in varchar2
16: ,p_description in varchar2 default null

Line 69: hr_api.constant_to_boolean

65: --
66: -- Convert constant values to their corresponding boolean value
67: --
68: l_validate :=
69: hr_api.constant_to_boolean
70: (p_constant_value => p_validate);
71: --
72: -- Register Surrogate ID or user key values
73: --

Line 164: (p_validate in number default hr_api.g_false_num

160: -- ----------------------------------------------------------------------------
161: -- |----------------------------< update_location >---------------------------|
162: -- ----------------------------------------------------------------------------
163: PROCEDURE update_location
164: (p_validate in number default hr_api.g_false_num
165: ,p_location_id in number
166: ,p_configuration_code in varchar2
167: ,p_configuration_context in varchar2
168: ,p_location_code in varchar2

Line 169: ,p_description in varchar2 default hr_api.g_varchar2

165: ,p_location_id in number
166: ,p_configuration_code in varchar2
167: ,p_configuration_context in varchar2
168: ,p_location_code in varchar2
169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2

Line 170: ,p_style in varchar2 default hr_api.g_varchar2

166: ,p_configuration_code in varchar2
167: ,p_configuration_context in varchar2
168: ,p_location_code in varchar2
169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2

167: ,p_configuration_context in varchar2
168: ,p_location_code in varchar2
169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2

Line 172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2

168: ,p_location_code in varchar2
169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2

169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 174: ,p_town_or_city in varchar2 default hr_api.g_varchar2

170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 175: ,p_country in varchar2 default hr_api.g_varchar2

171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 176: ,p_postal_code in varchar2 default hr_api.g_varchar2

172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 177: ,p_region_1 in varchar2 default hr_api.g_varchar2

173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 178: ,p_region_2 in varchar2 default hr_api.g_varchar2

174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 179: ,p_region_3 in varchar2 default hr_api.g_varchar2

175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2

Line 180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2

Line 181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2

Line 182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2

Line 183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2

179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2

Line 184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2

180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2

Line 185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2

181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2

Line 186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2

182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2

Line 187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2

183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2

Line 188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2

184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2
192: ,p_effective_date in date

Line 189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2

185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2
192: ,p_effective_date in date
193: ,p_object_version_number in out nocopy number

Line 190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2

186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2
192: ,p_effective_date in date
193: ,p_object_version_number in out nocopy number
194: ,p_return_status out nocopy varchar2

Line 191: ,p_language_code in varchar2 default hr_api.g_varchar2

187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2
192: ,p_effective_date in date
193: ,p_object_version_number in out nocopy number
194: ,p_return_status out nocopy varchar2
195: ) is

Line 223: hr_api.constant_to_boolean

219: --
220: -- Convert constant values to their corresponding boolean value
221: --
222: l_validate :=
223: hr_api.constant_to_boolean
224: (p_constant_value => p_validate);
225: --
226: -- Register Surrogate ID or user key values
227: --

Line 316: (p_validate in number default hr_api.g_false_num

312: -- ----------------------------------------------------------------------------
313: -- |----------------------------< delete_location >---------------------------|
314: -- ----------------------------------------------------------------------------
315: PROCEDURE delete_location
316: (p_validate in number default hr_api.g_false_num
317: ,p_location_id in number
318: ,p_object_version_number in number
319: ,p_return_status out nocopy varchar2
320: ) is

Line 346: hr_api.constant_to_boolean

342: --
343: -- Convert constant values to their corresponding boolean value
344: --
345: l_validate :=
346: hr_api.constant_to_boolean
347: (p_constant_value => p_validate);
348: --
349: -- Register Surrogate ID or user key values
350: --