eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_ADDRESS_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_person_address >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_person_address
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_pradd_ovlapval_override in number default null
15: ,p_validate_county in number default null
16: ,p_person_id in number default null

Line 97: hr_api.constant_to_boolean

93: --
94: -- Convert constant values to their corresponding boolean value
95: --
96: l_validate :=
97: hr_api.constant_to_boolean
98: (p_constant_value => p_validate);
99: l_pradd_ovlapval_override :=
100: hr_api.constant_to_boolean
101: (p_constant_value => p_pradd_ovlapval_override);

Line 100: hr_api.constant_to_boolean

96: l_validate :=
97: hr_api.constant_to_boolean
98: (p_constant_value => p_validate);
99: l_pradd_ovlapval_override :=
100: hr_api.constant_to_boolean
101: (p_constant_value => p_pradd_ovlapval_override);
102: l_validate_county :=
103: hr_api.constant_to_boolean
104: (p_constant_value => p_validate_county);

Line 103: hr_api.constant_to_boolean

99: l_pradd_ovlapval_override :=
100: hr_api.constant_to_boolean
101: (p_constant_value => p_pradd_ovlapval_override);
102: l_validate_county :=
103: hr_api.constant_to_boolean
104: (p_constant_value => p_validate_county);
105: --
106: -- Register Surrogate ID or user key values
107: --

Line 224: (p_validate in number default hr_api.g_false_num

220: -- ----------------------------------------------------------------------------
221: -- |-------------------------< update_person_address >------------------------|
222: -- ----------------------------------------------------------------------------
223: PROCEDURE update_person_address
224: (p_validate in number default hr_api.g_false_num
225: ,p_effective_date in date
226: ,p_validate_county in number default hr_api.g_true_num
227: ,p_address_id in number
228: ,p_object_version_number in out nocopy number

Line 226: ,p_validate_county in number default hr_api.g_true_num

222: -- ----------------------------------------------------------------------------
223: PROCEDURE update_person_address
224: (p_validate in number default hr_api.g_false_num
225: ,p_effective_date in date
226: ,p_validate_county in number default hr_api.g_true_num
227: ,p_address_id in number
228: ,p_object_version_number in out nocopy number
229: ,p_date_from in date default hr_api.g_date
230: ,p_date_to in date default hr_api.g_date

Line 229: ,p_date_from in date default hr_api.g_date

225: ,p_effective_date in date
226: ,p_validate_county in number default hr_api.g_true_num
227: ,p_address_id in number
228: ,p_object_version_number in out nocopy number
229: ,p_date_from in date default hr_api.g_date
230: ,p_date_to in date default hr_api.g_date
231: ,p_address_type in varchar2 default hr_api.g_varchar2
232: ,p_comments in clob default hr_api.g_varchar2
233: ,p_address_line1 in varchar2 default hr_api.g_varchar2

Line 230: ,p_date_to in date default hr_api.g_date

226: ,p_validate_county in number default hr_api.g_true_num
227: ,p_address_id in number
228: ,p_object_version_number in out nocopy number
229: ,p_date_from in date default hr_api.g_date
230: ,p_date_to in date default hr_api.g_date
231: ,p_address_type in varchar2 default hr_api.g_varchar2
232: ,p_comments in clob default hr_api.g_varchar2
233: ,p_address_line1 in varchar2 default hr_api.g_varchar2
234: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 231: ,p_address_type in varchar2 default hr_api.g_varchar2

227: ,p_address_id in number
228: ,p_object_version_number in out nocopy number
229: ,p_date_from in date default hr_api.g_date
230: ,p_date_to in date default hr_api.g_date
231: ,p_address_type in varchar2 default hr_api.g_varchar2
232: ,p_comments in clob default hr_api.g_varchar2
233: ,p_address_line1 in varchar2 default hr_api.g_varchar2
234: ,p_address_line2 in varchar2 default hr_api.g_varchar2
235: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 232: ,p_comments in clob default hr_api.g_varchar2

228: ,p_object_version_number in out nocopy number
229: ,p_date_from in date default hr_api.g_date
230: ,p_date_to in date default hr_api.g_date
231: ,p_address_type in varchar2 default hr_api.g_varchar2
232: ,p_comments in clob default hr_api.g_varchar2
233: ,p_address_line1 in varchar2 default hr_api.g_varchar2
234: ,p_address_line2 in varchar2 default hr_api.g_varchar2
235: ,p_address_line3 in varchar2 default hr_api.g_varchar2
236: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 233: ,p_address_line1 in varchar2 default hr_api.g_varchar2

229: ,p_date_from in date default hr_api.g_date
230: ,p_date_to in date default hr_api.g_date
231: ,p_address_type in varchar2 default hr_api.g_varchar2
232: ,p_comments in clob default hr_api.g_varchar2
233: ,p_address_line1 in varchar2 default hr_api.g_varchar2
234: ,p_address_line2 in varchar2 default hr_api.g_varchar2
235: ,p_address_line3 in varchar2 default hr_api.g_varchar2
236: ,p_town_or_city in varchar2 default hr_api.g_varchar2
237: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 234: ,p_address_line2 in varchar2 default hr_api.g_varchar2

230: ,p_date_to in date default hr_api.g_date
231: ,p_address_type in varchar2 default hr_api.g_varchar2
232: ,p_comments in clob default hr_api.g_varchar2
233: ,p_address_line1 in varchar2 default hr_api.g_varchar2
234: ,p_address_line2 in varchar2 default hr_api.g_varchar2
235: ,p_address_line3 in varchar2 default hr_api.g_varchar2
236: ,p_town_or_city in varchar2 default hr_api.g_varchar2
237: ,p_region_1 in varchar2 default hr_api.g_varchar2
238: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 235: ,p_address_line3 in varchar2 default hr_api.g_varchar2

231: ,p_address_type in varchar2 default hr_api.g_varchar2
232: ,p_comments in clob default hr_api.g_varchar2
233: ,p_address_line1 in varchar2 default hr_api.g_varchar2
234: ,p_address_line2 in varchar2 default hr_api.g_varchar2
235: ,p_address_line3 in varchar2 default hr_api.g_varchar2
236: ,p_town_or_city in varchar2 default hr_api.g_varchar2
237: ,p_region_1 in varchar2 default hr_api.g_varchar2
238: ,p_region_2 in varchar2 default hr_api.g_varchar2
239: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 236: ,p_town_or_city in varchar2 default hr_api.g_varchar2

232: ,p_comments in clob default hr_api.g_varchar2
233: ,p_address_line1 in varchar2 default hr_api.g_varchar2
234: ,p_address_line2 in varchar2 default hr_api.g_varchar2
235: ,p_address_line3 in varchar2 default hr_api.g_varchar2
236: ,p_town_or_city in varchar2 default hr_api.g_varchar2
237: ,p_region_1 in varchar2 default hr_api.g_varchar2
238: ,p_region_2 in varchar2 default hr_api.g_varchar2
239: ,p_region_3 in varchar2 default hr_api.g_varchar2
240: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 237: ,p_region_1 in varchar2 default hr_api.g_varchar2

233: ,p_address_line1 in varchar2 default hr_api.g_varchar2
234: ,p_address_line2 in varchar2 default hr_api.g_varchar2
235: ,p_address_line3 in varchar2 default hr_api.g_varchar2
236: ,p_town_or_city in varchar2 default hr_api.g_varchar2
237: ,p_region_1 in varchar2 default hr_api.g_varchar2
238: ,p_region_2 in varchar2 default hr_api.g_varchar2
239: ,p_region_3 in varchar2 default hr_api.g_varchar2
240: ,p_postal_code in varchar2 default hr_api.g_varchar2
241: ,p_country in varchar2 default hr_api.g_varchar2

Line 238: ,p_region_2 in varchar2 default hr_api.g_varchar2

234: ,p_address_line2 in varchar2 default hr_api.g_varchar2
235: ,p_address_line3 in varchar2 default hr_api.g_varchar2
236: ,p_town_or_city in varchar2 default hr_api.g_varchar2
237: ,p_region_1 in varchar2 default hr_api.g_varchar2
238: ,p_region_2 in varchar2 default hr_api.g_varchar2
239: ,p_region_3 in varchar2 default hr_api.g_varchar2
240: ,p_postal_code in varchar2 default hr_api.g_varchar2
241: ,p_country in varchar2 default hr_api.g_varchar2
242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 239: ,p_region_3 in varchar2 default hr_api.g_varchar2

235: ,p_address_line3 in varchar2 default hr_api.g_varchar2
236: ,p_town_or_city in varchar2 default hr_api.g_varchar2
237: ,p_region_1 in varchar2 default hr_api.g_varchar2
238: ,p_region_2 in varchar2 default hr_api.g_varchar2
239: ,p_region_3 in varchar2 default hr_api.g_varchar2
240: ,p_postal_code in varchar2 default hr_api.g_varchar2
241: ,p_country in varchar2 default hr_api.g_varchar2
242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 240: ,p_postal_code in varchar2 default hr_api.g_varchar2

236: ,p_town_or_city in varchar2 default hr_api.g_varchar2
237: ,p_region_1 in varchar2 default hr_api.g_varchar2
238: ,p_region_2 in varchar2 default hr_api.g_varchar2
239: ,p_region_3 in varchar2 default hr_api.g_varchar2
240: ,p_postal_code in varchar2 default hr_api.g_varchar2
241: ,p_country in varchar2 default hr_api.g_varchar2
242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 241: ,p_country in varchar2 default hr_api.g_varchar2

237: ,p_region_1 in varchar2 default hr_api.g_varchar2
238: ,p_region_2 in varchar2 default hr_api.g_varchar2
239: ,p_region_3 in varchar2 default hr_api.g_varchar2
240: ,p_postal_code in varchar2 default hr_api.g_varchar2
241: ,p_country in varchar2 default hr_api.g_varchar2
242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

238: ,p_region_2 in varchar2 default hr_api.g_varchar2
239: ,p_region_3 in varchar2 default hr_api.g_varchar2
240: ,p_postal_code in varchar2 default hr_api.g_varchar2
241: ,p_country in varchar2 default hr_api.g_varchar2
242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

239: ,p_region_3 in varchar2 default hr_api.g_varchar2
240: ,p_postal_code in varchar2 default hr_api.g_varchar2
241: ,p_country in varchar2 default hr_api.g_varchar2
242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

240: ,p_postal_code in varchar2 default hr_api.g_varchar2
241: ,p_country in varchar2 default hr_api.g_varchar2
242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

241: ,p_country in varchar2 default hr_api.g_varchar2
242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

242: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

243: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

244: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

245: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

246: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

247: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

248: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

249: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

250: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

251: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

252: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

253: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

254: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

255: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

256: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

257: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

258: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_add_information13 in varchar2 default hr_api.g_varchar2

Line 263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

259: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_add_information13 in varchar2 default hr_api.g_varchar2
267: ,p_add_information14 in varchar2 default hr_api.g_varchar2

Line 264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

260: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_add_information13 in varchar2 default hr_api.g_varchar2
267: ,p_add_information14 in varchar2 default hr_api.g_varchar2
268: ,p_add_information15 in varchar2 default hr_api.g_varchar2

Line 265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

261: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_add_information13 in varchar2 default hr_api.g_varchar2
267: ,p_add_information14 in varchar2 default hr_api.g_varchar2
268: ,p_add_information15 in varchar2 default hr_api.g_varchar2
269: ,p_add_information16 in varchar2 default hr_api.g_varchar2

Line 266: ,p_add_information13 in varchar2 default hr_api.g_varchar2

262: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_add_information13 in varchar2 default hr_api.g_varchar2
267: ,p_add_information14 in varchar2 default hr_api.g_varchar2
268: ,p_add_information15 in varchar2 default hr_api.g_varchar2
269: ,p_add_information16 in varchar2 default hr_api.g_varchar2
270: ,p_add_information17 in varchar2 default hr_api.g_varchar2

Line 267: ,p_add_information14 in varchar2 default hr_api.g_varchar2

263: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_add_information13 in varchar2 default hr_api.g_varchar2
267: ,p_add_information14 in varchar2 default hr_api.g_varchar2
268: ,p_add_information15 in varchar2 default hr_api.g_varchar2
269: ,p_add_information16 in varchar2 default hr_api.g_varchar2
270: ,p_add_information17 in varchar2 default hr_api.g_varchar2
271: ,p_add_information18 in varchar2 default hr_api.g_varchar2

Line 268: ,p_add_information15 in varchar2 default hr_api.g_varchar2

264: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_add_information13 in varchar2 default hr_api.g_varchar2
267: ,p_add_information14 in varchar2 default hr_api.g_varchar2
268: ,p_add_information15 in varchar2 default hr_api.g_varchar2
269: ,p_add_information16 in varchar2 default hr_api.g_varchar2
270: ,p_add_information17 in varchar2 default hr_api.g_varchar2
271: ,p_add_information18 in varchar2 default hr_api.g_varchar2
272: ,p_add_information19 in varchar2 default hr_api.g_varchar2

Line 269: ,p_add_information16 in varchar2 default hr_api.g_varchar2

265: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
266: ,p_add_information13 in varchar2 default hr_api.g_varchar2
267: ,p_add_information14 in varchar2 default hr_api.g_varchar2
268: ,p_add_information15 in varchar2 default hr_api.g_varchar2
269: ,p_add_information16 in varchar2 default hr_api.g_varchar2
270: ,p_add_information17 in varchar2 default hr_api.g_varchar2
271: ,p_add_information18 in varchar2 default hr_api.g_varchar2
272: ,p_add_information19 in varchar2 default hr_api.g_varchar2
273: ,p_add_information20 in varchar2 default hr_api.g_varchar2

Line 270: ,p_add_information17 in varchar2 default hr_api.g_varchar2

266: ,p_add_information13 in varchar2 default hr_api.g_varchar2
267: ,p_add_information14 in varchar2 default hr_api.g_varchar2
268: ,p_add_information15 in varchar2 default hr_api.g_varchar2
269: ,p_add_information16 in varchar2 default hr_api.g_varchar2
270: ,p_add_information17 in varchar2 default hr_api.g_varchar2
271: ,p_add_information18 in varchar2 default hr_api.g_varchar2
272: ,p_add_information19 in varchar2 default hr_api.g_varchar2
273: ,p_add_information20 in varchar2 default hr_api.g_varchar2
274: ,p_party_id in number default hr_api.g_number

Line 271: ,p_add_information18 in varchar2 default hr_api.g_varchar2

267: ,p_add_information14 in varchar2 default hr_api.g_varchar2
268: ,p_add_information15 in varchar2 default hr_api.g_varchar2
269: ,p_add_information16 in varchar2 default hr_api.g_varchar2
270: ,p_add_information17 in varchar2 default hr_api.g_varchar2
271: ,p_add_information18 in varchar2 default hr_api.g_varchar2
272: ,p_add_information19 in varchar2 default hr_api.g_varchar2
273: ,p_add_information20 in varchar2 default hr_api.g_varchar2
274: ,p_party_id in number default hr_api.g_number
275: ,p_style in varchar2

Line 272: ,p_add_information19 in varchar2 default hr_api.g_varchar2

268: ,p_add_information15 in varchar2 default hr_api.g_varchar2
269: ,p_add_information16 in varchar2 default hr_api.g_varchar2
270: ,p_add_information17 in varchar2 default hr_api.g_varchar2
271: ,p_add_information18 in varchar2 default hr_api.g_varchar2
272: ,p_add_information19 in varchar2 default hr_api.g_varchar2
273: ,p_add_information20 in varchar2 default hr_api.g_varchar2
274: ,p_party_id in number default hr_api.g_number
275: ,p_style in varchar2
276: ,p_return_status out nocopy varchar2

Line 273: ,p_add_information20 in varchar2 default hr_api.g_varchar2

269: ,p_add_information16 in varchar2 default hr_api.g_varchar2
270: ,p_add_information17 in varchar2 default hr_api.g_varchar2
271: ,p_add_information18 in varchar2 default hr_api.g_varchar2
272: ,p_add_information19 in varchar2 default hr_api.g_varchar2
273: ,p_add_information20 in varchar2 default hr_api.g_varchar2
274: ,p_party_id in number default hr_api.g_number
275: ,p_style in varchar2
276: ,p_return_status out nocopy varchar2
277: ) is

Line 274: ,p_party_id in number default hr_api.g_number

270: ,p_add_information17 in varchar2 default hr_api.g_varchar2
271: ,p_add_information18 in varchar2 default hr_api.g_varchar2
272: ,p_add_information19 in varchar2 default hr_api.g_varchar2
273: ,p_add_information20 in varchar2 default hr_api.g_varchar2
274: ,p_party_id in number default hr_api.g_number
275: ,p_style in varchar2
276: ,p_return_status out nocopy varchar2
277: ) is
278: --

Line 306: hr_api.constant_to_boolean

302: --
303: -- Convert constant values to their corresponding boolean value
304: --
305: l_validate :=
306: hr_api.constant_to_boolean
307: (p_constant_value => p_validate);
308: l_validate_county :=
309: hr_api.constant_to_boolean
310: (p_constant_value => p_validate_county);

Line 309: hr_api.constant_to_boolean

305: l_validate :=
306: hr_api.constant_to_boolean
307: (p_constant_value => p_validate);
308: l_validate_county :=
309: hr_api.constant_to_boolean
310: (p_constant_value => p_validate_county);
311: --
312: -- Register Surrogate ID or user key values
313: --