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 575: when hr_api.cannot_find_prog_unit then

571: (p_phone_id => p_phone_id
572: ,p_object_version_number => p_object_version_number
573: );
574: exception
575: when hr_api.cannot_find_prog_unit then
576: hr_api.cannot_find_prog_unit_error
577: (p_module_name => 'DELETE_PHONE',
578: p_hook_type => 'BP'
579: );

Line 576: hr_api.cannot_find_prog_unit_error

572: ,p_object_version_number => p_object_version_number
573: );
574: exception
575: when hr_api.cannot_find_prog_unit then
576: hr_api.cannot_find_prog_unit_error
577: (p_module_name => 'DELETE_PHONE',
578: p_hook_type => 'BP'
579: );
580: end;

Line 600: when hr_api.cannot_find_prog_unit then

596: (p_phone_id => p_phone_id
597: ,p_object_version_number => p_object_version_number
598: );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'DELETE_PHONE',
603: p_hook_type => 'AP'
604: );

Line 601: hr_api.cannot_find_prog_unit_error

597: ,p_object_version_number => p_object_version_number
598: );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'DELETE_PHONE',
603: p_hook_type => 'AP'
604: );
605: end;

Line 614: raise hr_api.validate_enabled;

610: --
611: -- When in validation only mode raise the Validate_Enabled exception
612: --
613: if p_validate then
614: raise hr_api.validate_enabled;
615: end if;
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 11);
618: exception

Line 619: when hr_api.validate_enabled then

615: end if;
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 11);
618: exception
619: when hr_api.validate_enabled then
620: --
621: -- As the Validate_Enabled exception has been raised
622: -- we must rollback to the savepoint
623: --

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

640: -- ----------------------------------------------------------------------------
641: -- |------------------------< create_or_update_phone >------------------------|
642: -- ----------------------------------------------------------------------------
643: procedure create_or_update_phone
644: (p_update_mode in varchar2 default hr_api.g_correction,
645: p_phone_id in out nocopy number,
646: p_object_version_number in out nocopy number,
647: p_date_from in date default hr_api.g_date,
648: p_date_to in date default hr_api.g_date,

Line 647: p_date_from in date default hr_api.g_date,

643: procedure create_or_update_phone
644: (p_update_mode in varchar2 default hr_api.g_correction,
645: p_phone_id in out nocopy number,
646: p_object_version_number in out nocopy number,
647: p_date_from in date default hr_api.g_date,
648: p_date_to in date default hr_api.g_date,
649: p_phone_type in varchar2 default hr_api.g_varchar2,
650: p_phone_number in varchar2 default hr_api.g_varchar2,
651: p_parent_id in number default hr_api.g_number,

Line 648: p_date_to in date default hr_api.g_date,

644: (p_update_mode in varchar2 default hr_api.g_correction,
645: p_phone_id in out nocopy number,
646: p_object_version_number in out nocopy number,
647: p_date_from in date default hr_api.g_date,
648: p_date_to in date default hr_api.g_date,
649: p_phone_type in varchar2 default hr_api.g_varchar2,
650: p_phone_number in varchar2 default hr_api.g_varchar2,
651: p_parent_id in number default hr_api.g_number,
652: p_parent_table in varchar2 default hr_api.g_varchar2,

Line 649: p_phone_type in varchar2 default hr_api.g_varchar2,

645: p_phone_id in out nocopy number,
646: p_object_version_number in out nocopy number,
647: p_date_from in date default hr_api.g_date,
648: p_date_to in date default hr_api.g_date,
649: p_phone_type in varchar2 default hr_api.g_varchar2,
650: p_phone_number in varchar2 default hr_api.g_varchar2,
651: p_parent_id in number default hr_api.g_number,
652: p_parent_table in varchar2 default hr_api.g_varchar2,
653: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 650: p_phone_number in varchar2 default hr_api.g_varchar2,

646: p_object_version_number in out nocopy number,
647: p_date_from in date default hr_api.g_date,
648: p_date_to in date default hr_api.g_date,
649: p_phone_type in varchar2 default hr_api.g_varchar2,
650: p_phone_number in varchar2 default hr_api.g_varchar2,
651: p_parent_id in number default hr_api.g_number,
652: p_parent_table in varchar2 default hr_api.g_varchar2,
653: p_attribute_category in varchar2 default hr_api.g_varchar2,
654: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 651: p_parent_id in number default hr_api.g_number,

647: p_date_from in date default hr_api.g_date,
648: p_date_to in date default hr_api.g_date,
649: p_phone_type in varchar2 default hr_api.g_varchar2,
650: p_phone_number in varchar2 default hr_api.g_varchar2,
651: p_parent_id in number default hr_api.g_number,
652: p_parent_table in varchar2 default hr_api.g_varchar2,
653: p_attribute_category in varchar2 default hr_api.g_varchar2,
654: p_attribute1 in varchar2 default hr_api.g_varchar2,
655: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 652: p_parent_table in varchar2 default hr_api.g_varchar2,

648: p_date_to in date default hr_api.g_date,
649: p_phone_type in varchar2 default hr_api.g_varchar2,
650: p_phone_number in varchar2 default hr_api.g_varchar2,
651: p_parent_id in number default hr_api.g_number,
652: p_parent_table in varchar2 default hr_api.g_varchar2,
653: p_attribute_category in varchar2 default hr_api.g_varchar2,
654: p_attribute1 in varchar2 default hr_api.g_varchar2,
655: p_attribute2 in varchar2 default hr_api.g_varchar2,
656: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 653: p_attribute_category in varchar2 default hr_api.g_varchar2,

649: p_phone_type in varchar2 default hr_api.g_varchar2,
650: p_phone_number in varchar2 default hr_api.g_varchar2,
651: p_parent_id in number default hr_api.g_number,
652: p_parent_table in varchar2 default hr_api.g_varchar2,
653: p_attribute_category in varchar2 default hr_api.g_varchar2,
654: p_attribute1 in varchar2 default hr_api.g_varchar2,
655: p_attribute2 in varchar2 default hr_api.g_varchar2,
656: p_attribute3 in varchar2 default hr_api.g_varchar2,
657: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 654: p_attribute1 in varchar2 default hr_api.g_varchar2,

650: p_phone_number in varchar2 default hr_api.g_varchar2,
651: p_parent_id in number default hr_api.g_number,
652: p_parent_table in varchar2 default hr_api.g_varchar2,
653: p_attribute_category in varchar2 default hr_api.g_varchar2,
654: p_attribute1 in varchar2 default hr_api.g_varchar2,
655: p_attribute2 in varchar2 default hr_api.g_varchar2,
656: p_attribute3 in varchar2 default hr_api.g_varchar2,
657: p_attribute4 in varchar2 default hr_api.g_varchar2,
658: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 655: p_attribute2 in varchar2 default hr_api.g_varchar2,

651: p_parent_id in number default hr_api.g_number,
652: p_parent_table in varchar2 default hr_api.g_varchar2,
653: p_attribute_category in varchar2 default hr_api.g_varchar2,
654: p_attribute1 in varchar2 default hr_api.g_varchar2,
655: p_attribute2 in varchar2 default hr_api.g_varchar2,
656: p_attribute3 in varchar2 default hr_api.g_varchar2,
657: p_attribute4 in varchar2 default hr_api.g_varchar2,
658: p_attribute5 in varchar2 default hr_api.g_varchar2,
659: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 656: p_attribute3 in varchar2 default hr_api.g_varchar2,

652: p_parent_table in varchar2 default hr_api.g_varchar2,
653: p_attribute_category in varchar2 default hr_api.g_varchar2,
654: p_attribute1 in varchar2 default hr_api.g_varchar2,
655: p_attribute2 in varchar2 default hr_api.g_varchar2,
656: p_attribute3 in varchar2 default hr_api.g_varchar2,
657: p_attribute4 in varchar2 default hr_api.g_varchar2,
658: p_attribute5 in varchar2 default hr_api.g_varchar2,
659: p_attribute6 in varchar2 default hr_api.g_varchar2,
660: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 657: p_attribute4 in varchar2 default hr_api.g_varchar2,

653: p_attribute_category in varchar2 default hr_api.g_varchar2,
654: p_attribute1 in varchar2 default hr_api.g_varchar2,
655: p_attribute2 in varchar2 default hr_api.g_varchar2,
656: p_attribute3 in varchar2 default hr_api.g_varchar2,
657: p_attribute4 in varchar2 default hr_api.g_varchar2,
658: p_attribute5 in varchar2 default hr_api.g_varchar2,
659: p_attribute6 in varchar2 default hr_api.g_varchar2,
660: p_attribute7 in varchar2 default hr_api.g_varchar2,
661: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 658: p_attribute5 in varchar2 default hr_api.g_varchar2,

654: p_attribute1 in varchar2 default hr_api.g_varchar2,
655: p_attribute2 in varchar2 default hr_api.g_varchar2,
656: p_attribute3 in varchar2 default hr_api.g_varchar2,
657: p_attribute4 in varchar2 default hr_api.g_varchar2,
658: p_attribute5 in varchar2 default hr_api.g_varchar2,
659: p_attribute6 in varchar2 default hr_api.g_varchar2,
660: p_attribute7 in varchar2 default hr_api.g_varchar2,
661: p_attribute8 in varchar2 default hr_api.g_varchar2,
662: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 659: p_attribute6 in varchar2 default hr_api.g_varchar2,

655: p_attribute2 in varchar2 default hr_api.g_varchar2,
656: p_attribute3 in varchar2 default hr_api.g_varchar2,
657: p_attribute4 in varchar2 default hr_api.g_varchar2,
658: p_attribute5 in varchar2 default hr_api.g_varchar2,
659: p_attribute6 in varchar2 default hr_api.g_varchar2,
660: p_attribute7 in varchar2 default hr_api.g_varchar2,
661: p_attribute8 in varchar2 default hr_api.g_varchar2,
662: p_attribute9 in varchar2 default hr_api.g_varchar2,
663: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 660: p_attribute7 in varchar2 default hr_api.g_varchar2,

656: p_attribute3 in varchar2 default hr_api.g_varchar2,
657: p_attribute4 in varchar2 default hr_api.g_varchar2,
658: p_attribute5 in varchar2 default hr_api.g_varchar2,
659: p_attribute6 in varchar2 default hr_api.g_varchar2,
660: p_attribute7 in varchar2 default hr_api.g_varchar2,
661: p_attribute8 in varchar2 default hr_api.g_varchar2,
662: p_attribute9 in varchar2 default hr_api.g_varchar2,
663: p_attribute10 in varchar2 default hr_api.g_varchar2,
664: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 661: p_attribute8 in varchar2 default hr_api.g_varchar2,

657: p_attribute4 in varchar2 default hr_api.g_varchar2,
658: p_attribute5 in varchar2 default hr_api.g_varchar2,
659: p_attribute6 in varchar2 default hr_api.g_varchar2,
660: p_attribute7 in varchar2 default hr_api.g_varchar2,
661: p_attribute8 in varchar2 default hr_api.g_varchar2,
662: p_attribute9 in varchar2 default hr_api.g_varchar2,
663: p_attribute10 in varchar2 default hr_api.g_varchar2,
664: p_attribute11 in varchar2 default hr_api.g_varchar2,
665: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 662: p_attribute9 in varchar2 default hr_api.g_varchar2,

658: p_attribute5 in varchar2 default hr_api.g_varchar2,
659: p_attribute6 in varchar2 default hr_api.g_varchar2,
660: p_attribute7 in varchar2 default hr_api.g_varchar2,
661: p_attribute8 in varchar2 default hr_api.g_varchar2,
662: p_attribute9 in varchar2 default hr_api.g_varchar2,
663: p_attribute10 in varchar2 default hr_api.g_varchar2,
664: p_attribute11 in varchar2 default hr_api.g_varchar2,
665: p_attribute12 in varchar2 default hr_api.g_varchar2,
666: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 663: p_attribute10 in varchar2 default hr_api.g_varchar2,

659: p_attribute6 in varchar2 default hr_api.g_varchar2,
660: p_attribute7 in varchar2 default hr_api.g_varchar2,
661: p_attribute8 in varchar2 default hr_api.g_varchar2,
662: p_attribute9 in varchar2 default hr_api.g_varchar2,
663: p_attribute10 in varchar2 default hr_api.g_varchar2,
664: p_attribute11 in varchar2 default hr_api.g_varchar2,
665: p_attribute12 in varchar2 default hr_api.g_varchar2,
666: p_attribute13 in varchar2 default hr_api.g_varchar2,
667: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 664: p_attribute11 in varchar2 default hr_api.g_varchar2,

660: p_attribute7 in varchar2 default hr_api.g_varchar2,
661: p_attribute8 in varchar2 default hr_api.g_varchar2,
662: p_attribute9 in varchar2 default hr_api.g_varchar2,
663: p_attribute10 in varchar2 default hr_api.g_varchar2,
664: p_attribute11 in varchar2 default hr_api.g_varchar2,
665: p_attribute12 in varchar2 default hr_api.g_varchar2,
666: p_attribute13 in varchar2 default hr_api.g_varchar2,
667: p_attribute14 in varchar2 default hr_api.g_varchar2,
668: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 665: p_attribute12 in varchar2 default hr_api.g_varchar2,

661: p_attribute8 in varchar2 default hr_api.g_varchar2,
662: p_attribute9 in varchar2 default hr_api.g_varchar2,
663: p_attribute10 in varchar2 default hr_api.g_varchar2,
664: p_attribute11 in varchar2 default hr_api.g_varchar2,
665: p_attribute12 in varchar2 default hr_api.g_varchar2,
666: p_attribute13 in varchar2 default hr_api.g_varchar2,
667: p_attribute14 in varchar2 default hr_api.g_varchar2,
668: p_attribute15 in varchar2 default hr_api.g_varchar2,
669: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 666: p_attribute13 in varchar2 default hr_api.g_varchar2,

662: p_attribute9 in varchar2 default hr_api.g_varchar2,
663: p_attribute10 in varchar2 default hr_api.g_varchar2,
664: p_attribute11 in varchar2 default hr_api.g_varchar2,
665: p_attribute12 in varchar2 default hr_api.g_varchar2,
666: p_attribute13 in varchar2 default hr_api.g_varchar2,
667: p_attribute14 in varchar2 default hr_api.g_varchar2,
668: p_attribute15 in varchar2 default hr_api.g_varchar2,
669: p_attribute16 in varchar2 default hr_api.g_varchar2,
670: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 667: p_attribute14 in varchar2 default hr_api.g_varchar2,

663: p_attribute10 in varchar2 default hr_api.g_varchar2,
664: p_attribute11 in varchar2 default hr_api.g_varchar2,
665: p_attribute12 in varchar2 default hr_api.g_varchar2,
666: p_attribute13 in varchar2 default hr_api.g_varchar2,
667: p_attribute14 in varchar2 default hr_api.g_varchar2,
668: p_attribute15 in varchar2 default hr_api.g_varchar2,
669: p_attribute16 in varchar2 default hr_api.g_varchar2,
670: p_attribute17 in varchar2 default hr_api.g_varchar2,
671: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 668: p_attribute15 in varchar2 default hr_api.g_varchar2,

664: p_attribute11 in varchar2 default hr_api.g_varchar2,
665: p_attribute12 in varchar2 default hr_api.g_varchar2,
666: p_attribute13 in varchar2 default hr_api.g_varchar2,
667: p_attribute14 in varchar2 default hr_api.g_varchar2,
668: p_attribute15 in varchar2 default hr_api.g_varchar2,
669: p_attribute16 in varchar2 default hr_api.g_varchar2,
670: p_attribute17 in varchar2 default hr_api.g_varchar2,
671: p_attribute18 in varchar2 default hr_api.g_varchar2,
672: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 669: p_attribute16 in varchar2 default hr_api.g_varchar2,

665: p_attribute12 in varchar2 default hr_api.g_varchar2,
666: p_attribute13 in varchar2 default hr_api.g_varchar2,
667: p_attribute14 in varchar2 default hr_api.g_varchar2,
668: p_attribute15 in varchar2 default hr_api.g_varchar2,
669: p_attribute16 in varchar2 default hr_api.g_varchar2,
670: p_attribute17 in varchar2 default hr_api.g_varchar2,
671: p_attribute18 in varchar2 default hr_api.g_varchar2,
672: p_attribute19 in varchar2 default hr_api.g_varchar2,
673: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 670: p_attribute17 in varchar2 default hr_api.g_varchar2,

666: p_attribute13 in varchar2 default hr_api.g_varchar2,
667: p_attribute14 in varchar2 default hr_api.g_varchar2,
668: p_attribute15 in varchar2 default hr_api.g_varchar2,
669: p_attribute16 in varchar2 default hr_api.g_varchar2,
670: p_attribute17 in varchar2 default hr_api.g_varchar2,
671: p_attribute18 in varchar2 default hr_api.g_varchar2,
672: p_attribute19 in varchar2 default hr_api.g_varchar2,
673: p_attribute20 in varchar2 default hr_api.g_varchar2,
674: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 671: p_attribute18 in varchar2 default hr_api.g_varchar2,

667: p_attribute14 in varchar2 default hr_api.g_varchar2,
668: p_attribute15 in varchar2 default hr_api.g_varchar2,
669: p_attribute16 in varchar2 default hr_api.g_varchar2,
670: p_attribute17 in varchar2 default hr_api.g_varchar2,
671: p_attribute18 in varchar2 default hr_api.g_varchar2,
672: p_attribute19 in varchar2 default hr_api.g_varchar2,
673: p_attribute20 in varchar2 default hr_api.g_varchar2,
674: p_attribute21 in varchar2 default hr_api.g_varchar2,
675: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 672: p_attribute19 in varchar2 default hr_api.g_varchar2,

668: p_attribute15 in varchar2 default hr_api.g_varchar2,
669: p_attribute16 in varchar2 default hr_api.g_varchar2,
670: p_attribute17 in varchar2 default hr_api.g_varchar2,
671: p_attribute18 in varchar2 default hr_api.g_varchar2,
672: p_attribute19 in varchar2 default hr_api.g_varchar2,
673: p_attribute20 in varchar2 default hr_api.g_varchar2,
674: p_attribute21 in varchar2 default hr_api.g_varchar2,
675: p_attribute22 in varchar2 default hr_api.g_varchar2,
676: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 673: p_attribute20 in varchar2 default hr_api.g_varchar2,

669: p_attribute16 in varchar2 default hr_api.g_varchar2,
670: p_attribute17 in varchar2 default hr_api.g_varchar2,
671: p_attribute18 in varchar2 default hr_api.g_varchar2,
672: p_attribute19 in varchar2 default hr_api.g_varchar2,
673: p_attribute20 in varchar2 default hr_api.g_varchar2,
674: p_attribute21 in varchar2 default hr_api.g_varchar2,
675: p_attribute22 in varchar2 default hr_api.g_varchar2,
676: p_attribute23 in varchar2 default hr_api.g_varchar2,
677: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 674: p_attribute21 in varchar2 default hr_api.g_varchar2,

670: p_attribute17 in varchar2 default hr_api.g_varchar2,
671: p_attribute18 in varchar2 default hr_api.g_varchar2,
672: p_attribute19 in varchar2 default hr_api.g_varchar2,
673: p_attribute20 in varchar2 default hr_api.g_varchar2,
674: p_attribute21 in varchar2 default hr_api.g_varchar2,
675: p_attribute22 in varchar2 default hr_api.g_varchar2,
676: p_attribute23 in varchar2 default hr_api.g_varchar2,
677: p_attribute24 in varchar2 default hr_api.g_varchar2,
678: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 675: p_attribute22 in varchar2 default hr_api.g_varchar2,

671: p_attribute18 in varchar2 default hr_api.g_varchar2,
672: p_attribute19 in varchar2 default hr_api.g_varchar2,
673: p_attribute20 in varchar2 default hr_api.g_varchar2,
674: p_attribute21 in varchar2 default hr_api.g_varchar2,
675: p_attribute22 in varchar2 default hr_api.g_varchar2,
676: p_attribute23 in varchar2 default hr_api.g_varchar2,
677: p_attribute24 in varchar2 default hr_api.g_varchar2,
678: p_attribute25 in varchar2 default hr_api.g_varchar2,
679: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 676: p_attribute23 in varchar2 default hr_api.g_varchar2,

672: p_attribute19 in varchar2 default hr_api.g_varchar2,
673: p_attribute20 in varchar2 default hr_api.g_varchar2,
674: p_attribute21 in varchar2 default hr_api.g_varchar2,
675: p_attribute22 in varchar2 default hr_api.g_varchar2,
676: p_attribute23 in varchar2 default hr_api.g_varchar2,
677: p_attribute24 in varchar2 default hr_api.g_varchar2,
678: p_attribute25 in varchar2 default hr_api.g_varchar2,
679: p_attribute26 in varchar2 default hr_api.g_varchar2,
680: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 677: p_attribute24 in varchar2 default hr_api.g_varchar2,

673: p_attribute20 in varchar2 default hr_api.g_varchar2,
674: p_attribute21 in varchar2 default hr_api.g_varchar2,
675: p_attribute22 in varchar2 default hr_api.g_varchar2,
676: p_attribute23 in varchar2 default hr_api.g_varchar2,
677: p_attribute24 in varchar2 default hr_api.g_varchar2,
678: p_attribute25 in varchar2 default hr_api.g_varchar2,
679: p_attribute26 in varchar2 default hr_api.g_varchar2,
680: p_attribute27 in varchar2 default hr_api.g_varchar2,
681: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 678: p_attribute25 in varchar2 default hr_api.g_varchar2,

674: p_attribute21 in varchar2 default hr_api.g_varchar2,
675: p_attribute22 in varchar2 default hr_api.g_varchar2,
676: p_attribute23 in varchar2 default hr_api.g_varchar2,
677: p_attribute24 in varchar2 default hr_api.g_varchar2,
678: p_attribute25 in varchar2 default hr_api.g_varchar2,
679: p_attribute26 in varchar2 default hr_api.g_varchar2,
680: p_attribute27 in varchar2 default hr_api.g_varchar2,
681: p_attribute28 in varchar2 default hr_api.g_varchar2,
682: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 679: p_attribute26 in varchar2 default hr_api.g_varchar2,

675: p_attribute22 in varchar2 default hr_api.g_varchar2,
676: p_attribute23 in varchar2 default hr_api.g_varchar2,
677: p_attribute24 in varchar2 default hr_api.g_varchar2,
678: p_attribute25 in varchar2 default hr_api.g_varchar2,
679: p_attribute26 in varchar2 default hr_api.g_varchar2,
680: p_attribute27 in varchar2 default hr_api.g_varchar2,
681: p_attribute28 in varchar2 default hr_api.g_varchar2,
682: p_attribute29 in varchar2 default hr_api.g_varchar2,
683: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 680: p_attribute27 in varchar2 default hr_api.g_varchar2,

676: p_attribute23 in varchar2 default hr_api.g_varchar2,
677: p_attribute24 in varchar2 default hr_api.g_varchar2,
678: p_attribute25 in varchar2 default hr_api.g_varchar2,
679: p_attribute26 in varchar2 default hr_api.g_varchar2,
680: p_attribute27 in varchar2 default hr_api.g_varchar2,
681: p_attribute28 in varchar2 default hr_api.g_varchar2,
682: p_attribute29 in varchar2 default hr_api.g_varchar2,
683: p_attribute30 in varchar2 default hr_api.g_varchar2,
684: p_validate in boolean default false,

Line 681: p_attribute28 in varchar2 default hr_api.g_varchar2,

677: p_attribute24 in varchar2 default hr_api.g_varchar2,
678: p_attribute25 in varchar2 default hr_api.g_varchar2,
679: p_attribute26 in varchar2 default hr_api.g_varchar2,
680: p_attribute27 in varchar2 default hr_api.g_varchar2,
681: p_attribute28 in varchar2 default hr_api.g_varchar2,
682: p_attribute29 in varchar2 default hr_api.g_varchar2,
683: p_attribute30 in varchar2 default hr_api.g_varchar2,
684: p_validate in boolean default false,
685: p_effective_date in date,

Line 682: p_attribute29 in varchar2 default hr_api.g_varchar2,

678: p_attribute25 in varchar2 default hr_api.g_varchar2,
679: p_attribute26 in varchar2 default hr_api.g_varchar2,
680: p_attribute27 in varchar2 default hr_api.g_varchar2,
681: p_attribute28 in varchar2 default hr_api.g_varchar2,
682: p_attribute29 in varchar2 default hr_api.g_varchar2,
683: p_attribute30 in varchar2 default hr_api.g_varchar2,
684: p_validate in boolean default false,
685: p_effective_date in date,
686: p_party_id in number default hr_api.g_number,

Line 683: p_attribute30 in varchar2 default hr_api.g_varchar2,

679: p_attribute26 in varchar2 default hr_api.g_varchar2,
680: p_attribute27 in varchar2 default hr_api.g_varchar2,
681: p_attribute28 in varchar2 default hr_api.g_varchar2,
682: p_attribute29 in varchar2 default hr_api.g_varchar2,
683: p_attribute30 in varchar2 default hr_api.g_varchar2,
684: p_validate in boolean default false,
685: p_effective_date in date,
686: p_party_id in number default hr_api.g_number,
687: p_validity in varchar2 default hr_api.g_varchar2

Line 686: p_party_id in number default hr_api.g_number,

682: p_attribute29 in varchar2 default hr_api.g_varchar2,
683: p_attribute30 in varchar2 default hr_api.g_varchar2,
684: p_validate in boolean default false,
685: p_effective_date in date,
686: p_party_id in number default hr_api.g_number,
687: p_validity in varchar2 default hr_api.g_varchar2
688: ) is
689: --
690: l_proc varchar2(72) := g_package||'create_or_update_phone';

Line 687: p_validity in varchar2 default hr_api.g_varchar2

683: p_attribute30 in varchar2 default hr_api.g_varchar2,
684: p_validate in boolean default false,
685: p_effective_date in date,
686: p_party_id in number default hr_api.g_number,
687: p_validity in varchar2 default hr_api.g_varchar2
688: ) is
689: --
690: l_proc varchar2(72) := g_package||'create_or_update_phone';
691: l_api_updating boolean;

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

819: --
820: -- updating not inserting
821: --
822: -- Validating update_mode values
823: if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then
824: hr_utility.set_location(l_proc, 80);
825: hr_utility.set_message(800, 'HR_52858_PHN_CHK_MODE');
826: hr_utility.raise_error;
827: end if;

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

828: hr_utility.set_location(l_proc, 90);
829: --
830: -- Validating effective_date
831: --
832: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))
833: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
834: then
835: hr_utility.set_location(l_proc, 100);
836: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');

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

829: --
830: -- Validating effective_date
831: --
832: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))
833: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
834: then
835: hr_utility.set_location(l_proc, 100);
836: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
837: hr_utility.raise_error;

Line 855: l_update_mode:= hr_api.g_correction;

851: -- effective date. This will always be a correction.
852: --
853: if per_phn_shd.g_old_rec.date_from = l_phn_rec.date_from
854: and l_phn_rec.date_from = l_effective_date then
855: l_update_mode:= hr_api.g_correction;
856: end if;
857: --
858: -- check for the modes mode
859: --

Line 860: if l_update_mode = hr_api.g_correction then

856: end if;
857: --
858: -- check for the modes mode
859: --
860: if l_update_mode = hr_api.g_correction then
861: --
862: -- correct the data
863: --
864: hr_utility.set_location(l_proc, 140);

Line 996: raise hr_api.validate_enabled;

992: end if;
993: end if;
994: --
995: if p_validate then
996: raise hr_api.validate_enabled;
997: end if;
998: --
999: p_phone_id:=l_phn_rec.phone_id;
1000: p_object_version_number:=l_phn_rec.object_version_number;

Line 1004: when hr_api.validate_enabled then

1000: p_object_version_number:=l_phn_rec.object_version_number;
1001: hr_utility.set_location('Leaving:'||l_proc, 200);
1002: --
1003: exception
1004: when hr_api.validate_enabled then
1005: rollback to create_or_update_phone;
1006: p_phone_id:=null;
1007: p_object_version_number:=null;
1008: hr_utility.set_location('Leaving:'||l_proc, 220);