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_PHONE_API dependencies on HR_API

Line 120: when hr_api.cannot_find_prog_unit then

116: p_effective_date => p_effective_date ,
117: p_party_id => p_party_id , -- HR/TCA merge
118: p_validity => p_validity);
119: exception
120: when hr_api.cannot_find_prog_unit then
121: hr_api.cannot_find_prog_unit_error
122: (p_module_name => 'CREATE_PHONE',
123: p_hook_type => 'BP'
124: );

Line 121: hr_api.cannot_find_prog_unit_error

117: p_party_id => p_party_id , -- HR/TCA merge
118: p_validity => p_validity);
119: exception
120: when hr_api.cannot_find_prog_unit then
121: hr_api.cannot_find_prog_unit_error
122: (p_module_name => 'CREATE_PHONE',
123: p_hook_type => 'BP'
124: );
125: end;

Line 226: when hr_api.cannot_find_prog_unit then

222: p_party_id => p_party_id , -- HR/TCA merge
223: p_validity => p_validity);
224:
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'CREATE_PHONE',
229: p_hook_type => 'AP'
230: );

Line 227: hr_api.cannot_find_prog_unit_error

223: p_validity => p_validity);
224:
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'CREATE_PHONE',
229: p_hook_type => 'AP'
230: );
231: end;

Line 240: raise hr_api.validate_enabled;

236: --
237: -- When in validation only mode raise the Validate_Enabled exception
238: --
239: if p_validate then
240: raise hr_api.validate_enabled;
241: end if;
242: --
243: p_object_version_number := l_object_version_number;
244: p_phone_id := l_phone_id;

Line 248: when hr_api.validate_enabled then

244: p_phone_id := l_phone_id;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 11);
247: exception
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised
251: -- we must rollback to the savepoint
252: --

Line 285: p_date_from in date default hr_api.g_date,

281: -- ----------------------------------------------------------------------------
282: --
283: procedure update_phone
284: (p_phone_id in number,
285: p_date_from in date default hr_api.g_date,
286: p_date_to in date default hr_api.g_date,
287: p_phone_type in varchar2 default hr_api.g_varchar2,
288: p_phone_number in varchar2 default hr_api.g_varchar2,
289: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 286: p_date_to in date default hr_api.g_date,

282: --
283: procedure update_phone
284: (p_phone_id in number,
285: p_date_from in date default hr_api.g_date,
286: p_date_to in date default hr_api.g_date,
287: p_phone_type in varchar2 default hr_api.g_varchar2,
288: p_phone_number in varchar2 default hr_api.g_varchar2,
289: p_attribute_category in varchar2 default hr_api.g_varchar2,
290: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 287: p_phone_type in varchar2 default hr_api.g_varchar2,

283: procedure update_phone
284: (p_phone_id in number,
285: p_date_from in date default hr_api.g_date,
286: p_date_to in date default hr_api.g_date,
287: p_phone_type in varchar2 default hr_api.g_varchar2,
288: p_phone_number in varchar2 default hr_api.g_varchar2,
289: p_attribute_category in varchar2 default hr_api.g_varchar2,
290: p_attribute1 in varchar2 default hr_api.g_varchar2,
291: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 288: p_phone_number in varchar2 default hr_api.g_varchar2,

284: (p_phone_id in number,
285: p_date_from in date default hr_api.g_date,
286: p_date_to in date default hr_api.g_date,
287: p_phone_type in varchar2 default hr_api.g_varchar2,
288: p_phone_number in varchar2 default hr_api.g_varchar2,
289: p_attribute_category in varchar2 default hr_api.g_varchar2,
290: p_attribute1 in varchar2 default hr_api.g_varchar2,
291: p_attribute2 in varchar2 default hr_api.g_varchar2,
292: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 289: p_attribute_category in varchar2 default hr_api.g_varchar2,

285: p_date_from in date default hr_api.g_date,
286: p_date_to in date default hr_api.g_date,
287: p_phone_type in varchar2 default hr_api.g_varchar2,
288: p_phone_number in varchar2 default hr_api.g_varchar2,
289: p_attribute_category in varchar2 default hr_api.g_varchar2,
290: p_attribute1 in varchar2 default hr_api.g_varchar2,
291: p_attribute2 in varchar2 default hr_api.g_varchar2,
292: p_attribute3 in varchar2 default hr_api.g_varchar2,
293: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 290: p_attribute1 in varchar2 default hr_api.g_varchar2,

286: p_date_to in date default hr_api.g_date,
287: p_phone_type in varchar2 default hr_api.g_varchar2,
288: p_phone_number in varchar2 default hr_api.g_varchar2,
289: p_attribute_category in varchar2 default hr_api.g_varchar2,
290: p_attribute1 in varchar2 default hr_api.g_varchar2,
291: p_attribute2 in varchar2 default hr_api.g_varchar2,
292: p_attribute3 in varchar2 default hr_api.g_varchar2,
293: p_attribute4 in varchar2 default hr_api.g_varchar2,
294: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 291: p_attribute2 in varchar2 default hr_api.g_varchar2,

287: p_phone_type in varchar2 default hr_api.g_varchar2,
288: p_phone_number in varchar2 default hr_api.g_varchar2,
289: p_attribute_category in varchar2 default hr_api.g_varchar2,
290: p_attribute1 in varchar2 default hr_api.g_varchar2,
291: p_attribute2 in varchar2 default hr_api.g_varchar2,
292: p_attribute3 in varchar2 default hr_api.g_varchar2,
293: p_attribute4 in varchar2 default hr_api.g_varchar2,
294: p_attribute5 in varchar2 default hr_api.g_varchar2,
295: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 292: p_attribute3 in varchar2 default hr_api.g_varchar2,

288: p_phone_number in varchar2 default hr_api.g_varchar2,
289: p_attribute_category in varchar2 default hr_api.g_varchar2,
290: p_attribute1 in varchar2 default hr_api.g_varchar2,
291: p_attribute2 in varchar2 default hr_api.g_varchar2,
292: p_attribute3 in varchar2 default hr_api.g_varchar2,
293: p_attribute4 in varchar2 default hr_api.g_varchar2,
294: p_attribute5 in varchar2 default hr_api.g_varchar2,
295: p_attribute6 in varchar2 default hr_api.g_varchar2,
296: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 293: p_attribute4 in varchar2 default hr_api.g_varchar2,

289: p_attribute_category in varchar2 default hr_api.g_varchar2,
290: p_attribute1 in varchar2 default hr_api.g_varchar2,
291: p_attribute2 in varchar2 default hr_api.g_varchar2,
292: p_attribute3 in varchar2 default hr_api.g_varchar2,
293: p_attribute4 in varchar2 default hr_api.g_varchar2,
294: p_attribute5 in varchar2 default hr_api.g_varchar2,
295: p_attribute6 in varchar2 default hr_api.g_varchar2,
296: p_attribute7 in varchar2 default hr_api.g_varchar2,
297: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 294: p_attribute5 in varchar2 default hr_api.g_varchar2,

290: p_attribute1 in varchar2 default hr_api.g_varchar2,
291: p_attribute2 in varchar2 default hr_api.g_varchar2,
292: p_attribute3 in varchar2 default hr_api.g_varchar2,
293: p_attribute4 in varchar2 default hr_api.g_varchar2,
294: p_attribute5 in varchar2 default hr_api.g_varchar2,
295: p_attribute6 in varchar2 default hr_api.g_varchar2,
296: p_attribute7 in varchar2 default hr_api.g_varchar2,
297: p_attribute8 in varchar2 default hr_api.g_varchar2,
298: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 295: p_attribute6 in varchar2 default hr_api.g_varchar2,

291: p_attribute2 in varchar2 default hr_api.g_varchar2,
292: p_attribute3 in varchar2 default hr_api.g_varchar2,
293: p_attribute4 in varchar2 default hr_api.g_varchar2,
294: p_attribute5 in varchar2 default hr_api.g_varchar2,
295: p_attribute6 in varchar2 default hr_api.g_varchar2,
296: p_attribute7 in varchar2 default hr_api.g_varchar2,
297: p_attribute8 in varchar2 default hr_api.g_varchar2,
298: p_attribute9 in varchar2 default hr_api.g_varchar2,
299: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 296: p_attribute7 in varchar2 default hr_api.g_varchar2,

292: p_attribute3 in varchar2 default hr_api.g_varchar2,
293: p_attribute4 in varchar2 default hr_api.g_varchar2,
294: p_attribute5 in varchar2 default hr_api.g_varchar2,
295: p_attribute6 in varchar2 default hr_api.g_varchar2,
296: p_attribute7 in varchar2 default hr_api.g_varchar2,
297: p_attribute8 in varchar2 default hr_api.g_varchar2,
298: p_attribute9 in varchar2 default hr_api.g_varchar2,
299: p_attribute10 in varchar2 default hr_api.g_varchar2,
300: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 297: p_attribute8 in varchar2 default hr_api.g_varchar2,

293: p_attribute4 in varchar2 default hr_api.g_varchar2,
294: p_attribute5 in varchar2 default hr_api.g_varchar2,
295: p_attribute6 in varchar2 default hr_api.g_varchar2,
296: p_attribute7 in varchar2 default hr_api.g_varchar2,
297: p_attribute8 in varchar2 default hr_api.g_varchar2,
298: p_attribute9 in varchar2 default hr_api.g_varchar2,
299: p_attribute10 in varchar2 default hr_api.g_varchar2,
300: p_attribute11 in varchar2 default hr_api.g_varchar2,
301: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 298: p_attribute9 in varchar2 default hr_api.g_varchar2,

294: p_attribute5 in varchar2 default hr_api.g_varchar2,
295: p_attribute6 in varchar2 default hr_api.g_varchar2,
296: p_attribute7 in varchar2 default hr_api.g_varchar2,
297: p_attribute8 in varchar2 default hr_api.g_varchar2,
298: p_attribute9 in varchar2 default hr_api.g_varchar2,
299: p_attribute10 in varchar2 default hr_api.g_varchar2,
300: p_attribute11 in varchar2 default hr_api.g_varchar2,
301: p_attribute12 in varchar2 default hr_api.g_varchar2,
302: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 299: p_attribute10 in varchar2 default hr_api.g_varchar2,

295: p_attribute6 in varchar2 default hr_api.g_varchar2,
296: p_attribute7 in varchar2 default hr_api.g_varchar2,
297: p_attribute8 in varchar2 default hr_api.g_varchar2,
298: p_attribute9 in varchar2 default hr_api.g_varchar2,
299: p_attribute10 in varchar2 default hr_api.g_varchar2,
300: p_attribute11 in varchar2 default hr_api.g_varchar2,
301: p_attribute12 in varchar2 default hr_api.g_varchar2,
302: p_attribute13 in varchar2 default hr_api.g_varchar2,
303: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 300: p_attribute11 in varchar2 default hr_api.g_varchar2,

296: p_attribute7 in varchar2 default hr_api.g_varchar2,
297: p_attribute8 in varchar2 default hr_api.g_varchar2,
298: p_attribute9 in varchar2 default hr_api.g_varchar2,
299: p_attribute10 in varchar2 default hr_api.g_varchar2,
300: p_attribute11 in varchar2 default hr_api.g_varchar2,
301: p_attribute12 in varchar2 default hr_api.g_varchar2,
302: p_attribute13 in varchar2 default hr_api.g_varchar2,
303: p_attribute14 in varchar2 default hr_api.g_varchar2,
304: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 301: p_attribute12 in varchar2 default hr_api.g_varchar2,

297: p_attribute8 in varchar2 default hr_api.g_varchar2,
298: p_attribute9 in varchar2 default hr_api.g_varchar2,
299: p_attribute10 in varchar2 default hr_api.g_varchar2,
300: p_attribute11 in varchar2 default hr_api.g_varchar2,
301: p_attribute12 in varchar2 default hr_api.g_varchar2,
302: p_attribute13 in varchar2 default hr_api.g_varchar2,
303: p_attribute14 in varchar2 default hr_api.g_varchar2,
304: p_attribute15 in varchar2 default hr_api.g_varchar2,
305: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 302: p_attribute13 in varchar2 default hr_api.g_varchar2,

298: p_attribute9 in varchar2 default hr_api.g_varchar2,
299: p_attribute10 in varchar2 default hr_api.g_varchar2,
300: p_attribute11 in varchar2 default hr_api.g_varchar2,
301: p_attribute12 in varchar2 default hr_api.g_varchar2,
302: p_attribute13 in varchar2 default hr_api.g_varchar2,
303: p_attribute14 in varchar2 default hr_api.g_varchar2,
304: p_attribute15 in varchar2 default hr_api.g_varchar2,
305: p_attribute16 in varchar2 default hr_api.g_varchar2,
306: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 303: p_attribute14 in varchar2 default hr_api.g_varchar2,

299: p_attribute10 in varchar2 default hr_api.g_varchar2,
300: p_attribute11 in varchar2 default hr_api.g_varchar2,
301: p_attribute12 in varchar2 default hr_api.g_varchar2,
302: p_attribute13 in varchar2 default hr_api.g_varchar2,
303: p_attribute14 in varchar2 default hr_api.g_varchar2,
304: p_attribute15 in varchar2 default hr_api.g_varchar2,
305: p_attribute16 in varchar2 default hr_api.g_varchar2,
306: p_attribute17 in varchar2 default hr_api.g_varchar2,
307: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 304: p_attribute15 in varchar2 default hr_api.g_varchar2,

300: p_attribute11 in varchar2 default hr_api.g_varchar2,
301: p_attribute12 in varchar2 default hr_api.g_varchar2,
302: p_attribute13 in varchar2 default hr_api.g_varchar2,
303: p_attribute14 in varchar2 default hr_api.g_varchar2,
304: p_attribute15 in varchar2 default hr_api.g_varchar2,
305: p_attribute16 in varchar2 default hr_api.g_varchar2,
306: p_attribute17 in varchar2 default hr_api.g_varchar2,
307: p_attribute18 in varchar2 default hr_api.g_varchar2,
308: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 305: p_attribute16 in varchar2 default hr_api.g_varchar2,

301: p_attribute12 in varchar2 default hr_api.g_varchar2,
302: p_attribute13 in varchar2 default hr_api.g_varchar2,
303: p_attribute14 in varchar2 default hr_api.g_varchar2,
304: p_attribute15 in varchar2 default hr_api.g_varchar2,
305: p_attribute16 in varchar2 default hr_api.g_varchar2,
306: p_attribute17 in varchar2 default hr_api.g_varchar2,
307: p_attribute18 in varchar2 default hr_api.g_varchar2,
308: p_attribute19 in varchar2 default hr_api.g_varchar2,
309: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 306: p_attribute17 in varchar2 default hr_api.g_varchar2,

302: p_attribute13 in varchar2 default hr_api.g_varchar2,
303: p_attribute14 in varchar2 default hr_api.g_varchar2,
304: p_attribute15 in varchar2 default hr_api.g_varchar2,
305: p_attribute16 in varchar2 default hr_api.g_varchar2,
306: p_attribute17 in varchar2 default hr_api.g_varchar2,
307: p_attribute18 in varchar2 default hr_api.g_varchar2,
308: p_attribute19 in varchar2 default hr_api.g_varchar2,
309: p_attribute20 in varchar2 default hr_api.g_varchar2,
310: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 307: p_attribute18 in varchar2 default hr_api.g_varchar2,

303: p_attribute14 in varchar2 default hr_api.g_varchar2,
304: p_attribute15 in varchar2 default hr_api.g_varchar2,
305: p_attribute16 in varchar2 default hr_api.g_varchar2,
306: p_attribute17 in varchar2 default hr_api.g_varchar2,
307: p_attribute18 in varchar2 default hr_api.g_varchar2,
308: p_attribute19 in varchar2 default hr_api.g_varchar2,
309: p_attribute20 in varchar2 default hr_api.g_varchar2,
310: p_attribute21 in varchar2 default hr_api.g_varchar2,
311: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 308: p_attribute19 in varchar2 default hr_api.g_varchar2,

304: p_attribute15 in varchar2 default hr_api.g_varchar2,
305: p_attribute16 in varchar2 default hr_api.g_varchar2,
306: p_attribute17 in varchar2 default hr_api.g_varchar2,
307: p_attribute18 in varchar2 default hr_api.g_varchar2,
308: p_attribute19 in varchar2 default hr_api.g_varchar2,
309: p_attribute20 in varchar2 default hr_api.g_varchar2,
310: p_attribute21 in varchar2 default hr_api.g_varchar2,
311: p_attribute22 in varchar2 default hr_api.g_varchar2,
312: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 309: p_attribute20 in varchar2 default hr_api.g_varchar2,

305: p_attribute16 in varchar2 default hr_api.g_varchar2,
306: p_attribute17 in varchar2 default hr_api.g_varchar2,
307: p_attribute18 in varchar2 default hr_api.g_varchar2,
308: p_attribute19 in varchar2 default hr_api.g_varchar2,
309: p_attribute20 in varchar2 default hr_api.g_varchar2,
310: p_attribute21 in varchar2 default hr_api.g_varchar2,
311: p_attribute22 in varchar2 default hr_api.g_varchar2,
312: p_attribute23 in varchar2 default hr_api.g_varchar2,
313: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 310: p_attribute21 in varchar2 default hr_api.g_varchar2,

306: p_attribute17 in varchar2 default hr_api.g_varchar2,
307: p_attribute18 in varchar2 default hr_api.g_varchar2,
308: p_attribute19 in varchar2 default hr_api.g_varchar2,
309: p_attribute20 in varchar2 default hr_api.g_varchar2,
310: p_attribute21 in varchar2 default hr_api.g_varchar2,
311: p_attribute22 in varchar2 default hr_api.g_varchar2,
312: p_attribute23 in varchar2 default hr_api.g_varchar2,
313: p_attribute24 in varchar2 default hr_api.g_varchar2,
314: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 311: p_attribute22 in varchar2 default hr_api.g_varchar2,

307: p_attribute18 in varchar2 default hr_api.g_varchar2,
308: p_attribute19 in varchar2 default hr_api.g_varchar2,
309: p_attribute20 in varchar2 default hr_api.g_varchar2,
310: p_attribute21 in varchar2 default hr_api.g_varchar2,
311: p_attribute22 in varchar2 default hr_api.g_varchar2,
312: p_attribute23 in varchar2 default hr_api.g_varchar2,
313: p_attribute24 in varchar2 default hr_api.g_varchar2,
314: p_attribute25 in varchar2 default hr_api.g_varchar2,
315: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 312: p_attribute23 in varchar2 default hr_api.g_varchar2,

308: p_attribute19 in varchar2 default hr_api.g_varchar2,
309: p_attribute20 in varchar2 default hr_api.g_varchar2,
310: p_attribute21 in varchar2 default hr_api.g_varchar2,
311: p_attribute22 in varchar2 default hr_api.g_varchar2,
312: p_attribute23 in varchar2 default hr_api.g_varchar2,
313: p_attribute24 in varchar2 default hr_api.g_varchar2,
314: p_attribute25 in varchar2 default hr_api.g_varchar2,
315: p_attribute26 in varchar2 default hr_api.g_varchar2,
316: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 313: p_attribute24 in varchar2 default hr_api.g_varchar2,

309: p_attribute20 in varchar2 default hr_api.g_varchar2,
310: p_attribute21 in varchar2 default hr_api.g_varchar2,
311: p_attribute22 in varchar2 default hr_api.g_varchar2,
312: p_attribute23 in varchar2 default hr_api.g_varchar2,
313: p_attribute24 in varchar2 default hr_api.g_varchar2,
314: p_attribute25 in varchar2 default hr_api.g_varchar2,
315: p_attribute26 in varchar2 default hr_api.g_varchar2,
316: p_attribute27 in varchar2 default hr_api.g_varchar2,
317: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 314: p_attribute25 in varchar2 default hr_api.g_varchar2,

310: p_attribute21 in varchar2 default hr_api.g_varchar2,
311: p_attribute22 in varchar2 default hr_api.g_varchar2,
312: p_attribute23 in varchar2 default hr_api.g_varchar2,
313: p_attribute24 in varchar2 default hr_api.g_varchar2,
314: p_attribute25 in varchar2 default hr_api.g_varchar2,
315: p_attribute26 in varchar2 default hr_api.g_varchar2,
316: p_attribute27 in varchar2 default hr_api.g_varchar2,
317: p_attribute28 in varchar2 default hr_api.g_varchar2,
318: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 315: p_attribute26 in varchar2 default hr_api.g_varchar2,

311: p_attribute22 in varchar2 default hr_api.g_varchar2,
312: p_attribute23 in varchar2 default hr_api.g_varchar2,
313: p_attribute24 in varchar2 default hr_api.g_varchar2,
314: p_attribute25 in varchar2 default hr_api.g_varchar2,
315: p_attribute26 in varchar2 default hr_api.g_varchar2,
316: p_attribute27 in varchar2 default hr_api.g_varchar2,
317: p_attribute28 in varchar2 default hr_api.g_varchar2,
318: p_attribute29 in varchar2 default hr_api.g_varchar2,
319: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 316: p_attribute27 in varchar2 default hr_api.g_varchar2,

312: p_attribute23 in varchar2 default hr_api.g_varchar2,
313: p_attribute24 in varchar2 default hr_api.g_varchar2,
314: p_attribute25 in varchar2 default hr_api.g_varchar2,
315: p_attribute26 in varchar2 default hr_api.g_varchar2,
316: p_attribute27 in varchar2 default hr_api.g_varchar2,
317: p_attribute28 in varchar2 default hr_api.g_varchar2,
318: p_attribute29 in varchar2 default hr_api.g_varchar2,
319: p_attribute30 in varchar2 default hr_api.g_varchar2,
320: p_object_version_number in out nocopy number,

Line 317: p_attribute28 in varchar2 default hr_api.g_varchar2,

313: p_attribute24 in varchar2 default hr_api.g_varchar2,
314: p_attribute25 in varchar2 default hr_api.g_varchar2,
315: p_attribute26 in varchar2 default hr_api.g_varchar2,
316: p_attribute27 in varchar2 default hr_api.g_varchar2,
317: p_attribute28 in varchar2 default hr_api.g_varchar2,
318: p_attribute29 in varchar2 default hr_api.g_varchar2,
319: p_attribute30 in varchar2 default hr_api.g_varchar2,
320: p_object_version_number in out nocopy number,
321: p_validate in boolean default false,

Line 318: p_attribute29 in varchar2 default hr_api.g_varchar2,

314: p_attribute25 in varchar2 default hr_api.g_varchar2,
315: p_attribute26 in varchar2 default hr_api.g_varchar2,
316: p_attribute27 in varchar2 default hr_api.g_varchar2,
317: p_attribute28 in varchar2 default hr_api.g_varchar2,
318: p_attribute29 in varchar2 default hr_api.g_varchar2,
319: p_attribute30 in varchar2 default hr_api.g_varchar2,
320: p_object_version_number in out nocopy number,
321: p_validate in boolean default false,
322: p_effective_date in date,

Line 319: p_attribute30 in varchar2 default hr_api.g_varchar2,

315: p_attribute26 in varchar2 default hr_api.g_varchar2,
316: p_attribute27 in varchar2 default hr_api.g_varchar2,
317: p_attribute28 in varchar2 default hr_api.g_varchar2,
318: p_attribute29 in varchar2 default hr_api.g_varchar2,
319: p_attribute30 in varchar2 default hr_api.g_varchar2,
320: p_object_version_number in out nocopy number,
321: p_validate in boolean default false,
322: p_effective_date in date,
323: p_party_id in number default hr_api.g_number,

Line 323: p_party_id in number default hr_api.g_number,

319: p_attribute30 in varchar2 default hr_api.g_varchar2,
320: p_object_version_number in out nocopy number,
321: p_validate in boolean default false,
322: p_effective_date in date,
323: p_party_id in number default hr_api.g_number,
324: p_validity in varchar2 default hr_api.g_varchar2
325: )
326:
327: is

Line 324: p_validity in varchar2 default hr_api.g_varchar2

320: p_object_version_number in out nocopy number,
321: p_validate in boolean default false,
322: p_effective_date in date,
323: p_party_id in number default hr_api.g_number,
324: p_validity in varchar2 default hr_api.g_varchar2
325: )
326:
327: is
328: --

Line 392: when hr_api.cannot_find_prog_unit then

388: p_object_version_number => p_object_version_number,
389: p_effective_date => p_effective_date ,
390: p_validity => p_validity);
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'UPDATE_PHONE',
395: p_hook_type => 'BP'
396: );

Line 393: hr_api.cannot_find_prog_unit_error

389: p_effective_date => p_effective_date ,
390: p_validity => p_validity);
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'UPDATE_PHONE',
395: p_hook_type => 'BP'
396: );
397: end;

Line 495: when hr_api.cannot_find_prog_unit then

491: p_effective_date => p_effective_date ,
492: p_validity => p_validity);
493:
494: exception
495: when hr_api.cannot_find_prog_unit then
496: hr_api.cannot_find_prog_unit_error
497: (p_module_name => 'UPDATE_PHONE',
498: p_hook_type => 'AP'
499: );

Line 496: hr_api.cannot_find_prog_unit_error

492: p_validity => p_validity);
493:
494: exception
495: when hr_api.cannot_find_prog_unit then
496: hr_api.cannot_find_prog_unit_error
497: (p_module_name => 'UPDATE_PHONE',
498: p_hook_type => 'AP'
499: );
500: end;

Line 509: raise hr_api.validate_enabled;

505: --
506: -- When in validation only mode raise the Validate_Enabled exception
507: --
508: if p_validate then
509: raise hr_api.validate_enabled;
510: end if;
511: --
512: p_object_version_number := l_object_version_number;
513: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 515: when hr_api.validate_enabled then

511: --
512: p_object_version_number := l_object_version_number;
513: hr_utility.set_location(' Leaving:'||l_proc, 11);
514: exception
515: when hr_api.validate_enabled then
516: --
517: -- As the Validate_Enabled exception has been raised
518: -- we must rollback to the savepoint
519: --

Line 594: when hr_api.cannot_find_prog_unit then

590: (p_phone_id => p_phone_id
591: ,p_object_version_number => p_object_version_number
592: );
593: exception
594: when hr_api.cannot_find_prog_unit then
595: hr_api.cannot_find_prog_unit_error
596: (p_module_name => 'DELETE_PHONE',
597: p_hook_type => 'BP'
598: );

Line 595: hr_api.cannot_find_prog_unit_error

591: ,p_object_version_number => p_object_version_number
592: );
593: exception
594: when hr_api.cannot_find_prog_unit then
595: hr_api.cannot_find_prog_unit_error
596: (p_module_name => 'DELETE_PHONE',
597: p_hook_type => 'BP'
598: );
599: end;

Line 620: when hr_api.cannot_find_prog_unit then

616: ,p_object_version_number => p_object_version_number
617: ,p_person_id => l_person_id
618: );
619: exception
620: when hr_api.cannot_find_prog_unit then
621: hr_api.cannot_find_prog_unit_error
622: (p_module_name => 'DELETE_PHONE',
623: p_hook_type => 'AP'
624: );

Line 621: hr_api.cannot_find_prog_unit_error

617: ,p_person_id => l_person_id
618: );
619: exception
620: when hr_api.cannot_find_prog_unit then
621: hr_api.cannot_find_prog_unit_error
622: (p_module_name => 'DELETE_PHONE',
623: p_hook_type => 'AP'
624: );
625: end;

Line 634: raise hr_api.validate_enabled;

630: --
631: -- When in validation only mode raise the Validate_Enabled exception
632: --
633: if p_validate then
634: raise hr_api.validate_enabled;
635: end if;
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 11);
638: exception

Line 639: when hr_api.validate_enabled then

635: end if;
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 11);
638: exception
639: when hr_api.validate_enabled then
640: --
641: -- As the Validate_Enabled exception has been raised
642: -- we must rollback to the savepoint
643: --

Line 664: (p_update_mode in varchar2 default hr_api.g_correction,

660: -- ----------------------------------------------------------------------------
661: -- |------------------------< create_or_update_phone >------------------------|
662: -- ----------------------------------------------------------------------------
663: procedure create_or_update_phone
664: (p_update_mode in varchar2 default hr_api.g_correction,
665: p_phone_id in out nocopy number,
666: p_object_version_number in out nocopy number,
667: p_date_from in date default hr_api.g_date,
668: p_date_to in date default hr_api.g_date,

Line 667: p_date_from in date default hr_api.g_date,

663: procedure create_or_update_phone
664: (p_update_mode in varchar2 default hr_api.g_correction,
665: p_phone_id in out nocopy number,
666: p_object_version_number in out nocopy number,
667: p_date_from in date default hr_api.g_date,
668: p_date_to in date default hr_api.g_date,
669: p_phone_type in varchar2 default hr_api.g_varchar2,
670: p_phone_number in varchar2 default hr_api.g_varchar2,
671: p_parent_id in number default hr_api.g_number,

Line 668: p_date_to in date default hr_api.g_date,

664: (p_update_mode in varchar2 default hr_api.g_correction,
665: p_phone_id in out nocopy number,
666: p_object_version_number in out nocopy number,
667: p_date_from in date default hr_api.g_date,
668: p_date_to in date default hr_api.g_date,
669: p_phone_type in varchar2 default hr_api.g_varchar2,
670: p_phone_number in varchar2 default hr_api.g_varchar2,
671: p_parent_id in number default hr_api.g_number,
672: p_parent_table in varchar2 default hr_api.g_varchar2,

Line 669: p_phone_type in varchar2 default hr_api.g_varchar2,

665: p_phone_id in out nocopy number,
666: p_object_version_number in out nocopy number,
667: p_date_from in date default hr_api.g_date,
668: p_date_to in date default hr_api.g_date,
669: p_phone_type in varchar2 default hr_api.g_varchar2,
670: p_phone_number in varchar2 default hr_api.g_varchar2,
671: p_parent_id in number default hr_api.g_number,
672: p_parent_table in varchar2 default hr_api.g_varchar2,
673: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 670: p_phone_number in varchar2 default hr_api.g_varchar2,

666: p_object_version_number in out nocopy number,
667: p_date_from in date default hr_api.g_date,
668: p_date_to in date default hr_api.g_date,
669: p_phone_type in varchar2 default hr_api.g_varchar2,
670: p_phone_number in varchar2 default hr_api.g_varchar2,
671: p_parent_id in number default hr_api.g_number,
672: p_parent_table in varchar2 default hr_api.g_varchar2,
673: p_attribute_category in varchar2 default hr_api.g_varchar2,
674: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 671: p_parent_id in number default hr_api.g_number,

667: p_date_from in date default hr_api.g_date,
668: p_date_to in date default hr_api.g_date,
669: p_phone_type in varchar2 default hr_api.g_varchar2,
670: p_phone_number in varchar2 default hr_api.g_varchar2,
671: p_parent_id in number default hr_api.g_number,
672: p_parent_table in varchar2 default hr_api.g_varchar2,
673: p_attribute_category in varchar2 default hr_api.g_varchar2,
674: p_attribute1 in varchar2 default hr_api.g_varchar2,
675: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 672: p_parent_table in varchar2 default hr_api.g_varchar2,

668: p_date_to in date default hr_api.g_date,
669: p_phone_type in varchar2 default hr_api.g_varchar2,
670: p_phone_number in varchar2 default hr_api.g_varchar2,
671: p_parent_id in number default hr_api.g_number,
672: p_parent_table in varchar2 default hr_api.g_varchar2,
673: p_attribute_category in varchar2 default hr_api.g_varchar2,
674: p_attribute1 in varchar2 default hr_api.g_varchar2,
675: p_attribute2 in varchar2 default hr_api.g_varchar2,
676: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 673: p_attribute_category in varchar2 default hr_api.g_varchar2,

669: p_phone_type in varchar2 default hr_api.g_varchar2,
670: p_phone_number in varchar2 default hr_api.g_varchar2,
671: p_parent_id in number default hr_api.g_number,
672: p_parent_table in varchar2 default hr_api.g_varchar2,
673: p_attribute_category in varchar2 default hr_api.g_varchar2,
674: p_attribute1 in varchar2 default hr_api.g_varchar2,
675: p_attribute2 in varchar2 default hr_api.g_varchar2,
676: p_attribute3 in varchar2 default hr_api.g_varchar2,
677: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 674: p_attribute1 in varchar2 default hr_api.g_varchar2,

670: p_phone_number in varchar2 default hr_api.g_varchar2,
671: p_parent_id in number default hr_api.g_number,
672: p_parent_table in varchar2 default hr_api.g_varchar2,
673: p_attribute_category in varchar2 default hr_api.g_varchar2,
674: p_attribute1 in varchar2 default hr_api.g_varchar2,
675: p_attribute2 in varchar2 default hr_api.g_varchar2,
676: p_attribute3 in varchar2 default hr_api.g_varchar2,
677: p_attribute4 in varchar2 default hr_api.g_varchar2,
678: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 675: p_attribute2 in varchar2 default hr_api.g_varchar2,

671: p_parent_id in number default hr_api.g_number,
672: p_parent_table in varchar2 default hr_api.g_varchar2,
673: p_attribute_category in varchar2 default hr_api.g_varchar2,
674: p_attribute1 in varchar2 default hr_api.g_varchar2,
675: p_attribute2 in varchar2 default hr_api.g_varchar2,
676: p_attribute3 in varchar2 default hr_api.g_varchar2,
677: p_attribute4 in varchar2 default hr_api.g_varchar2,
678: p_attribute5 in varchar2 default hr_api.g_varchar2,
679: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 676: p_attribute3 in varchar2 default hr_api.g_varchar2,

672: p_parent_table in varchar2 default hr_api.g_varchar2,
673: p_attribute_category in varchar2 default hr_api.g_varchar2,
674: p_attribute1 in varchar2 default hr_api.g_varchar2,
675: p_attribute2 in varchar2 default hr_api.g_varchar2,
676: p_attribute3 in varchar2 default hr_api.g_varchar2,
677: p_attribute4 in varchar2 default hr_api.g_varchar2,
678: p_attribute5 in varchar2 default hr_api.g_varchar2,
679: p_attribute6 in varchar2 default hr_api.g_varchar2,
680: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 677: p_attribute4 in varchar2 default hr_api.g_varchar2,

673: p_attribute_category in varchar2 default hr_api.g_varchar2,
674: p_attribute1 in varchar2 default hr_api.g_varchar2,
675: p_attribute2 in varchar2 default hr_api.g_varchar2,
676: p_attribute3 in varchar2 default hr_api.g_varchar2,
677: p_attribute4 in varchar2 default hr_api.g_varchar2,
678: p_attribute5 in varchar2 default hr_api.g_varchar2,
679: p_attribute6 in varchar2 default hr_api.g_varchar2,
680: p_attribute7 in varchar2 default hr_api.g_varchar2,
681: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 678: p_attribute5 in varchar2 default hr_api.g_varchar2,

674: p_attribute1 in varchar2 default hr_api.g_varchar2,
675: p_attribute2 in varchar2 default hr_api.g_varchar2,
676: p_attribute3 in varchar2 default hr_api.g_varchar2,
677: p_attribute4 in varchar2 default hr_api.g_varchar2,
678: p_attribute5 in varchar2 default hr_api.g_varchar2,
679: p_attribute6 in varchar2 default hr_api.g_varchar2,
680: p_attribute7 in varchar2 default hr_api.g_varchar2,
681: p_attribute8 in varchar2 default hr_api.g_varchar2,
682: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 679: p_attribute6 in varchar2 default hr_api.g_varchar2,

675: p_attribute2 in varchar2 default hr_api.g_varchar2,
676: p_attribute3 in varchar2 default hr_api.g_varchar2,
677: p_attribute4 in varchar2 default hr_api.g_varchar2,
678: p_attribute5 in varchar2 default hr_api.g_varchar2,
679: p_attribute6 in varchar2 default hr_api.g_varchar2,
680: p_attribute7 in varchar2 default hr_api.g_varchar2,
681: p_attribute8 in varchar2 default hr_api.g_varchar2,
682: p_attribute9 in varchar2 default hr_api.g_varchar2,
683: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 680: p_attribute7 in varchar2 default hr_api.g_varchar2,

676: p_attribute3 in varchar2 default hr_api.g_varchar2,
677: p_attribute4 in varchar2 default hr_api.g_varchar2,
678: p_attribute5 in varchar2 default hr_api.g_varchar2,
679: p_attribute6 in varchar2 default hr_api.g_varchar2,
680: p_attribute7 in varchar2 default hr_api.g_varchar2,
681: p_attribute8 in varchar2 default hr_api.g_varchar2,
682: p_attribute9 in varchar2 default hr_api.g_varchar2,
683: p_attribute10 in varchar2 default hr_api.g_varchar2,
684: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 681: p_attribute8 in varchar2 default hr_api.g_varchar2,

677: p_attribute4 in varchar2 default hr_api.g_varchar2,
678: p_attribute5 in varchar2 default hr_api.g_varchar2,
679: p_attribute6 in varchar2 default hr_api.g_varchar2,
680: p_attribute7 in varchar2 default hr_api.g_varchar2,
681: p_attribute8 in varchar2 default hr_api.g_varchar2,
682: p_attribute9 in varchar2 default hr_api.g_varchar2,
683: p_attribute10 in varchar2 default hr_api.g_varchar2,
684: p_attribute11 in varchar2 default hr_api.g_varchar2,
685: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 682: p_attribute9 in varchar2 default hr_api.g_varchar2,

678: p_attribute5 in varchar2 default hr_api.g_varchar2,
679: p_attribute6 in varchar2 default hr_api.g_varchar2,
680: p_attribute7 in varchar2 default hr_api.g_varchar2,
681: p_attribute8 in varchar2 default hr_api.g_varchar2,
682: p_attribute9 in varchar2 default hr_api.g_varchar2,
683: p_attribute10 in varchar2 default hr_api.g_varchar2,
684: p_attribute11 in varchar2 default hr_api.g_varchar2,
685: p_attribute12 in varchar2 default hr_api.g_varchar2,
686: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 683: p_attribute10 in varchar2 default hr_api.g_varchar2,

679: p_attribute6 in varchar2 default hr_api.g_varchar2,
680: p_attribute7 in varchar2 default hr_api.g_varchar2,
681: p_attribute8 in varchar2 default hr_api.g_varchar2,
682: p_attribute9 in varchar2 default hr_api.g_varchar2,
683: p_attribute10 in varchar2 default hr_api.g_varchar2,
684: p_attribute11 in varchar2 default hr_api.g_varchar2,
685: p_attribute12 in varchar2 default hr_api.g_varchar2,
686: p_attribute13 in varchar2 default hr_api.g_varchar2,
687: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 684: p_attribute11 in varchar2 default hr_api.g_varchar2,

680: p_attribute7 in varchar2 default hr_api.g_varchar2,
681: p_attribute8 in varchar2 default hr_api.g_varchar2,
682: p_attribute9 in varchar2 default hr_api.g_varchar2,
683: p_attribute10 in varchar2 default hr_api.g_varchar2,
684: p_attribute11 in varchar2 default hr_api.g_varchar2,
685: p_attribute12 in varchar2 default hr_api.g_varchar2,
686: p_attribute13 in varchar2 default hr_api.g_varchar2,
687: p_attribute14 in varchar2 default hr_api.g_varchar2,
688: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 685: p_attribute12 in varchar2 default hr_api.g_varchar2,

681: p_attribute8 in varchar2 default hr_api.g_varchar2,
682: p_attribute9 in varchar2 default hr_api.g_varchar2,
683: p_attribute10 in varchar2 default hr_api.g_varchar2,
684: p_attribute11 in varchar2 default hr_api.g_varchar2,
685: p_attribute12 in varchar2 default hr_api.g_varchar2,
686: p_attribute13 in varchar2 default hr_api.g_varchar2,
687: p_attribute14 in varchar2 default hr_api.g_varchar2,
688: p_attribute15 in varchar2 default hr_api.g_varchar2,
689: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 686: p_attribute13 in varchar2 default hr_api.g_varchar2,

682: p_attribute9 in varchar2 default hr_api.g_varchar2,
683: p_attribute10 in varchar2 default hr_api.g_varchar2,
684: p_attribute11 in varchar2 default hr_api.g_varchar2,
685: p_attribute12 in varchar2 default hr_api.g_varchar2,
686: p_attribute13 in varchar2 default hr_api.g_varchar2,
687: p_attribute14 in varchar2 default hr_api.g_varchar2,
688: p_attribute15 in varchar2 default hr_api.g_varchar2,
689: p_attribute16 in varchar2 default hr_api.g_varchar2,
690: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 687: p_attribute14 in varchar2 default hr_api.g_varchar2,

683: p_attribute10 in varchar2 default hr_api.g_varchar2,
684: p_attribute11 in varchar2 default hr_api.g_varchar2,
685: p_attribute12 in varchar2 default hr_api.g_varchar2,
686: p_attribute13 in varchar2 default hr_api.g_varchar2,
687: p_attribute14 in varchar2 default hr_api.g_varchar2,
688: p_attribute15 in varchar2 default hr_api.g_varchar2,
689: p_attribute16 in varchar2 default hr_api.g_varchar2,
690: p_attribute17 in varchar2 default hr_api.g_varchar2,
691: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 688: p_attribute15 in varchar2 default hr_api.g_varchar2,

684: p_attribute11 in varchar2 default hr_api.g_varchar2,
685: p_attribute12 in varchar2 default hr_api.g_varchar2,
686: p_attribute13 in varchar2 default hr_api.g_varchar2,
687: p_attribute14 in varchar2 default hr_api.g_varchar2,
688: p_attribute15 in varchar2 default hr_api.g_varchar2,
689: p_attribute16 in varchar2 default hr_api.g_varchar2,
690: p_attribute17 in varchar2 default hr_api.g_varchar2,
691: p_attribute18 in varchar2 default hr_api.g_varchar2,
692: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 689: p_attribute16 in varchar2 default hr_api.g_varchar2,

685: p_attribute12 in varchar2 default hr_api.g_varchar2,
686: p_attribute13 in varchar2 default hr_api.g_varchar2,
687: p_attribute14 in varchar2 default hr_api.g_varchar2,
688: p_attribute15 in varchar2 default hr_api.g_varchar2,
689: p_attribute16 in varchar2 default hr_api.g_varchar2,
690: p_attribute17 in varchar2 default hr_api.g_varchar2,
691: p_attribute18 in varchar2 default hr_api.g_varchar2,
692: p_attribute19 in varchar2 default hr_api.g_varchar2,
693: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 690: p_attribute17 in varchar2 default hr_api.g_varchar2,

686: p_attribute13 in varchar2 default hr_api.g_varchar2,
687: p_attribute14 in varchar2 default hr_api.g_varchar2,
688: p_attribute15 in varchar2 default hr_api.g_varchar2,
689: p_attribute16 in varchar2 default hr_api.g_varchar2,
690: p_attribute17 in varchar2 default hr_api.g_varchar2,
691: p_attribute18 in varchar2 default hr_api.g_varchar2,
692: p_attribute19 in varchar2 default hr_api.g_varchar2,
693: p_attribute20 in varchar2 default hr_api.g_varchar2,
694: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 691: p_attribute18 in varchar2 default hr_api.g_varchar2,

687: p_attribute14 in varchar2 default hr_api.g_varchar2,
688: p_attribute15 in varchar2 default hr_api.g_varchar2,
689: p_attribute16 in varchar2 default hr_api.g_varchar2,
690: p_attribute17 in varchar2 default hr_api.g_varchar2,
691: p_attribute18 in varchar2 default hr_api.g_varchar2,
692: p_attribute19 in varchar2 default hr_api.g_varchar2,
693: p_attribute20 in varchar2 default hr_api.g_varchar2,
694: p_attribute21 in varchar2 default hr_api.g_varchar2,
695: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 692: p_attribute19 in varchar2 default hr_api.g_varchar2,

688: p_attribute15 in varchar2 default hr_api.g_varchar2,
689: p_attribute16 in varchar2 default hr_api.g_varchar2,
690: p_attribute17 in varchar2 default hr_api.g_varchar2,
691: p_attribute18 in varchar2 default hr_api.g_varchar2,
692: p_attribute19 in varchar2 default hr_api.g_varchar2,
693: p_attribute20 in varchar2 default hr_api.g_varchar2,
694: p_attribute21 in varchar2 default hr_api.g_varchar2,
695: p_attribute22 in varchar2 default hr_api.g_varchar2,
696: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 693: p_attribute20 in varchar2 default hr_api.g_varchar2,

689: p_attribute16 in varchar2 default hr_api.g_varchar2,
690: p_attribute17 in varchar2 default hr_api.g_varchar2,
691: p_attribute18 in varchar2 default hr_api.g_varchar2,
692: p_attribute19 in varchar2 default hr_api.g_varchar2,
693: p_attribute20 in varchar2 default hr_api.g_varchar2,
694: p_attribute21 in varchar2 default hr_api.g_varchar2,
695: p_attribute22 in varchar2 default hr_api.g_varchar2,
696: p_attribute23 in varchar2 default hr_api.g_varchar2,
697: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 694: p_attribute21 in varchar2 default hr_api.g_varchar2,

690: p_attribute17 in varchar2 default hr_api.g_varchar2,
691: p_attribute18 in varchar2 default hr_api.g_varchar2,
692: p_attribute19 in varchar2 default hr_api.g_varchar2,
693: p_attribute20 in varchar2 default hr_api.g_varchar2,
694: p_attribute21 in varchar2 default hr_api.g_varchar2,
695: p_attribute22 in varchar2 default hr_api.g_varchar2,
696: p_attribute23 in varchar2 default hr_api.g_varchar2,
697: p_attribute24 in varchar2 default hr_api.g_varchar2,
698: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 695: p_attribute22 in varchar2 default hr_api.g_varchar2,

691: p_attribute18 in varchar2 default hr_api.g_varchar2,
692: p_attribute19 in varchar2 default hr_api.g_varchar2,
693: p_attribute20 in varchar2 default hr_api.g_varchar2,
694: p_attribute21 in varchar2 default hr_api.g_varchar2,
695: p_attribute22 in varchar2 default hr_api.g_varchar2,
696: p_attribute23 in varchar2 default hr_api.g_varchar2,
697: p_attribute24 in varchar2 default hr_api.g_varchar2,
698: p_attribute25 in varchar2 default hr_api.g_varchar2,
699: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 696: p_attribute23 in varchar2 default hr_api.g_varchar2,

692: p_attribute19 in varchar2 default hr_api.g_varchar2,
693: p_attribute20 in varchar2 default hr_api.g_varchar2,
694: p_attribute21 in varchar2 default hr_api.g_varchar2,
695: p_attribute22 in varchar2 default hr_api.g_varchar2,
696: p_attribute23 in varchar2 default hr_api.g_varchar2,
697: p_attribute24 in varchar2 default hr_api.g_varchar2,
698: p_attribute25 in varchar2 default hr_api.g_varchar2,
699: p_attribute26 in varchar2 default hr_api.g_varchar2,
700: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 697: p_attribute24 in varchar2 default hr_api.g_varchar2,

693: p_attribute20 in varchar2 default hr_api.g_varchar2,
694: p_attribute21 in varchar2 default hr_api.g_varchar2,
695: p_attribute22 in varchar2 default hr_api.g_varchar2,
696: p_attribute23 in varchar2 default hr_api.g_varchar2,
697: p_attribute24 in varchar2 default hr_api.g_varchar2,
698: p_attribute25 in varchar2 default hr_api.g_varchar2,
699: p_attribute26 in varchar2 default hr_api.g_varchar2,
700: p_attribute27 in varchar2 default hr_api.g_varchar2,
701: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 698: p_attribute25 in varchar2 default hr_api.g_varchar2,

694: p_attribute21 in varchar2 default hr_api.g_varchar2,
695: p_attribute22 in varchar2 default hr_api.g_varchar2,
696: p_attribute23 in varchar2 default hr_api.g_varchar2,
697: p_attribute24 in varchar2 default hr_api.g_varchar2,
698: p_attribute25 in varchar2 default hr_api.g_varchar2,
699: p_attribute26 in varchar2 default hr_api.g_varchar2,
700: p_attribute27 in varchar2 default hr_api.g_varchar2,
701: p_attribute28 in varchar2 default hr_api.g_varchar2,
702: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 699: p_attribute26 in varchar2 default hr_api.g_varchar2,

695: p_attribute22 in varchar2 default hr_api.g_varchar2,
696: p_attribute23 in varchar2 default hr_api.g_varchar2,
697: p_attribute24 in varchar2 default hr_api.g_varchar2,
698: p_attribute25 in varchar2 default hr_api.g_varchar2,
699: p_attribute26 in varchar2 default hr_api.g_varchar2,
700: p_attribute27 in varchar2 default hr_api.g_varchar2,
701: p_attribute28 in varchar2 default hr_api.g_varchar2,
702: p_attribute29 in varchar2 default hr_api.g_varchar2,
703: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 700: p_attribute27 in varchar2 default hr_api.g_varchar2,

696: p_attribute23 in varchar2 default hr_api.g_varchar2,
697: p_attribute24 in varchar2 default hr_api.g_varchar2,
698: p_attribute25 in varchar2 default hr_api.g_varchar2,
699: p_attribute26 in varchar2 default hr_api.g_varchar2,
700: p_attribute27 in varchar2 default hr_api.g_varchar2,
701: p_attribute28 in varchar2 default hr_api.g_varchar2,
702: p_attribute29 in varchar2 default hr_api.g_varchar2,
703: p_attribute30 in varchar2 default hr_api.g_varchar2,
704: p_validate in boolean default false,

Line 701: p_attribute28 in varchar2 default hr_api.g_varchar2,

697: p_attribute24 in varchar2 default hr_api.g_varchar2,
698: p_attribute25 in varchar2 default hr_api.g_varchar2,
699: p_attribute26 in varchar2 default hr_api.g_varchar2,
700: p_attribute27 in varchar2 default hr_api.g_varchar2,
701: p_attribute28 in varchar2 default hr_api.g_varchar2,
702: p_attribute29 in varchar2 default hr_api.g_varchar2,
703: p_attribute30 in varchar2 default hr_api.g_varchar2,
704: p_validate in boolean default false,
705: p_effective_date in date,

Line 702: p_attribute29 in varchar2 default hr_api.g_varchar2,

698: p_attribute25 in varchar2 default hr_api.g_varchar2,
699: p_attribute26 in varchar2 default hr_api.g_varchar2,
700: p_attribute27 in varchar2 default hr_api.g_varchar2,
701: p_attribute28 in varchar2 default hr_api.g_varchar2,
702: p_attribute29 in varchar2 default hr_api.g_varchar2,
703: p_attribute30 in varchar2 default hr_api.g_varchar2,
704: p_validate in boolean default false,
705: p_effective_date in date,
706: p_party_id in number default hr_api.g_number,

Line 703: p_attribute30 in varchar2 default hr_api.g_varchar2,

699: p_attribute26 in varchar2 default hr_api.g_varchar2,
700: p_attribute27 in varchar2 default hr_api.g_varchar2,
701: p_attribute28 in varchar2 default hr_api.g_varchar2,
702: p_attribute29 in varchar2 default hr_api.g_varchar2,
703: p_attribute30 in varchar2 default hr_api.g_varchar2,
704: p_validate in boolean default false,
705: p_effective_date in date,
706: p_party_id in number default hr_api.g_number,
707: p_validity in varchar2 default hr_api.g_varchar2

Line 706: p_party_id in number default hr_api.g_number,

702: p_attribute29 in varchar2 default hr_api.g_varchar2,
703: p_attribute30 in varchar2 default hr_api.g_varchar2,
704: p_validate in boolean default false,
705: p_effective_date in date,
706: p_party_id in number default hr_api.g_number,
707: p_validity in varchar2 default hr_api.g_varchar2
708: ) is
709: --
710: l_proc varchar2(72) := g_package||'create_or_update_phone';

Line 707: p_validity in varchar2 default hr_api.g_varchar2

703: p_attribute30 in varchar2 default hr_api.g_varchar2,
704: p_validate in boolean default false,
705: p_effective_date in date,
706: p_party_id in number default hr_api.g_number,
707: p_validity in varchar2 default hr_api.g_varchar2
708: ) is
709: --
710: l_proc varchar2(72) := g_package||'create_or_update_phone';
711: l_api_updating boolean;

Line 843: if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then

839: --
840: -- updating not inserting
841: --
842: -- Validating update_mode values
843: if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then
844: hr_utility.set_location(l_proc, 80);
845: hr_utility.set_message(800, 'HR_52858_PHN_CHK_MODE');
846: hr_utility.raise_error;
847: end if;

Line 852: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))

848: hr_utility.set_location(l_proc, 90);
849: --
850: -- Validating effective_date
851: --
852: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))
853: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
854: then
855: hr_utility.set_location(l_proc, 100);
856: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');

Line 853: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))

849: --
850: -- Validating effective_date
851: --
852: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))
853: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
854: then
855: hr_utility.set_location(l_proc, 100);
856: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
857: hr_utility.raise_error;

Line 875: l_update_mode:= hr_api.g_correction;

871: -- effective date. This will always be a correction.
872: --
873: if per_phn_shd.g_old_rec.date_from = l_phn_rec.date_from
874: and l_phn_rec.date_from = l_effective_date then
875: l_update_mode:= hr_api.g_correction;
876: end if;
877: --
878: -- check for the modes mode
879: --

Line 880: if l_update_mode = hr_api.g_correction then

876: end if;
877: --
878: -- check for the modes mode
879: --
880: if l_update_mode = hr_api.g_correction then
881: --
882: -- correct the data
883: --
884: hr_utility.set_location(l_proc, 140);

Line 1016: raise hr_api.validate_enabled;

1012: end if;
1013: end if;
1014: --
1015: if p_validate then
1016: raise hr_api.validate_enabled;
1017: end if;
1018: --
1019: p_phone_id:=l_phn_rec.phone_id;
1020: p_object_version_number:=l_phn_rec.object_version_number;

Line 1024: when hr_api.validate_enabled then

1020: p_object_version_number:=l_phn_rec.object_version_number;
1021: hr_utility.set_location('Leaving:'||l_proc, 200);
1022: --
1023: exception
1024: when hr_api.validate_enabled then
1025: rollback to create_or_update_phone;
1026: p_phone_id:=null;
1027: p_object_version_number:=null;
1028: hr_utility.set_location('Leaving:'||l_proc, 220);