DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_LOCATION_API dependencies on HR_API

Line 44: ,p_language_code In Varchar2 Default hr_api.userenv_lang

40: ,p_loc_information17 In Varchar2 Default Null
41: ,p_loc_information18 In Varchar2 Default Null
42: ,p_loc_information19 In Varchar2 Default Null
43: ,p_loc_information20 In Varchar2 Default Null
44: ,p_language_code In Varchar2 Default hr_api.userenv_lang
45: ,p_effective_date In Date
46: ,p_object_version_number Out Nocopy Number
47: ,p_location_id Out Nocopy Number
48: )

Line 79: hr_api.validate_language_code(p_language_code => l_language_code);

75: -- instead of p_language_code from now on, to allow an IN OUT parameter to
76: -- be passed through.
77: --
78: l_language_code := p_language_code;
79: hr_api.validate_language_code(p_language_code => l_language_code);
80: --
81: hr_utility.set_location(l_proc, 20);
82:
83: -- Process Logic

Line 124: Raise hr_api.validate_enabled;

120: --
121: -- When in validation only mode raise the Validate_Enabled exception
122: --
123: If p_validate Then
124: Raise hr_api.validate_enabled;
125: End If;
126: --
127: -- Set all output arguments
128: --

Line 135: When hr_api.validate_enabled Then

131: hr_utility.set_location(' Leaving:'||l_proc, 70);
132: --
133: Exception
134: --
135: When hr_api.validate_enabled Then
136: --
137: -- As the Validate_Enabled exception has been raised
138: -- we must rollback to the savepoint
139: --

Line 168: ,p_description In Varchar2 Default hr_api.g_varchar2

164: ,p_location_id In Number
165: ,p_configuration_code In Varchar2
166: ,p_configuration_context In Varchar2
167: ,p_location_code In Varchar2
168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2

Line 169: ,p_style In Varchar2 Default hr_api.g_varchar2

165: ,p_configuration_code In Varchar2
166: ,p_configuration_context In Varchar2
167: ,p_location_code In Varchar2
168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2

Line 170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2

166: ,p_configuration_context In Varchar2
167: ,p_location_code In Varchar2
168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2

Line 171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2

167: ,p_location_code In Varchar2
168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2

Line 172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2

168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2

Line 173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2

169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2

Line 174: ,p_country In Varchar2 Default hr_api.g_varchar2

170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2

Line 175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2

171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2

Line 176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2

172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2

Line 177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2

173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2

Line 178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2

174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2

Line 179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2

175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2

Line 180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2

176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2

Line 181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2

177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2

Line 182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2

178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2

Line 183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2

179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2

Line 184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2

180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2

Line 185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2

181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2

Line 186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2

182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang

Line 187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2

183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang
191: ,p_effective_date In Date

Line 188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2

184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang
191: ,p_effective_date In Date
192: ,p_object_version_number In Out Nocopy Number

Line 189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2

185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang
191: ,p_effective_date In Date
192: ,p_object_version_number In Out Nocopy Number
193: ) Is

Line 190: ,p_language_code In Varchar2 Default hr_api.userenv_lang

186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang
191: ,p_effective_date In Date
192: ,p_object_version_number In Out Nocopy Number
193: ) Is
194: --

Line 224: hr_api.validate_language_code(p_language_code => l_language_code);

220: -- instead of p_language_code from now on, to allow an IN OUT parameter to be
221: -- passed through.
222: --
223: l_language_code := p_language_code;
224: hr_api.validate_language_code(p_language_code => l_language_code);
225: hr_utility.set_location(l_proc, 20);
226: --
227: --
228: -- Process Logic

Line 272: Raise hr_api.validate_enabled;

268: --
269: -- When in validation only mode raise the Validate_Enabled exception
270: --
271: If p_validate Then
272: Raise hr_api.validate_enabled;
273: End If;
274: --
275: -- Set all output arguments. If p_validate was TRUE, this bit is
276: -- never reached, so p_object_version_number is passed back unchanged.

Line 284: When hr_api.validate_enabled Then

280: hr_utility.set_location(' Leaving:'||l_proc, 70);
281: --
282: Exception
283: --
284: When hr_api.validate_enabled Then
285: --
286: -- As the Validate_Enabled exception has been raised
287: -- we must rollback to the savepoint
288: --

Line 347: Raise hr_api.validate_enabled;

343: --
344: -- When in validation only mode raise the Validate_Enabled exception
345: --
346: If p_validate Then
347: Raise hr_api.validate_enabled;
348: End If;
349: --
350: --
351: Exception

Line 353: When hr_api.validate_enabled Then

349: --
350: --
351: Exception
352: --
353: When hr_api.validate_enabled Then
354: --
355: -- As the Validate_Enabled exception has been raised
356: -- we must rollback to the savepoint
357: --