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

Line 114: WHEN hr_api.cannot_find_prog_unit THEN

110: ,p_attribute19 => p_attribute19
111: ,p_attribute20 => p_attribute20);
112: --
113: EXCEPTION
114: WHEN hr_api.cannot_find_prog_unit THEN
115: hr_api.cannot_find_prog_unit_error
116: (p_module_name => 'create_rate'
117: ,p_hook_type => 'BP');
118: --

Line 115: hr_api.cannot_find_prog_unit_error

111: ,p_attribute20 => p_attribute20);
112: --
113: EXCEPTION
114: WHEN hr_api.cannot_find_prog_unit THEN
115: hr_api.cannot_find_prog_unit_error
116: (p_module_name => 'create_rate'
117: ,p_hook_type => 'BP');
118: --
119: -- End of API User Hook for the before hook of create_rate

Line 215: WHEN hr_api.cannot_find_prog_unit THEN

211: ,p_attribute19 => p_attribute19
212: ,p_attribute20 => p_attribute20);
213: --
214: EXCEPTION
215: WHEN hr_api.cannot_find_prog_unit THEN
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'create_rate'
218: ,p_hook_type => 'AP');
219: --

Line 216: hr_api.cannot_find_prog_unit_error

212: ,p_attribute20 => p_attribute20);
213: --
214: EXCEPTION
215: WHEN hr_api.cannot_find_prog_unit THEN
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'create_rate'
218: ,p_hook_type => 'AP');
219: --
220: -- End of API User Hook for the after hook of create_rate

Line 230: RAISE hr_api.validate_enabled;

226: -- When in validation only mode raise the Validate_Enabled exception
227: --
228: IF p_validate THEN
229: --
230: RAISE hr_api.validate_enabled;
231: --
232: END IF;
233: --
234: -- Set all output arguments

Line 243: WHEN hr_api.validate_enabled THEN

239: hr_utility.set_location(' Leaving:'||l_proc, 999);
240: --
241: EXCEPTION
242: --
243: WHEN hr_api.validate_enabled THEN
244: --
245: -- As the Validate_Enabled exception has been raised
246: -- we must rollback to the savepoint
247: --

Line 283: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

279: (p_validate IN BOOLEAN DEFAULT FALSE
280: ,p_rate_id IN NUMBER
281: ,p_object_version_number IN OUT NOCOPY NUMBER
282: ,p_effective_date IN DATE
283: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 284: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2

280: ,p_rate_id IN NUMBER
281: ,p_object_version_number IN OUT NOCOPY NUMBER
282: ,p_effective_date IN DATE
283: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 285: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number

281: ,p_object_version_number IN OUT NOCOPY NUMBER
282: ,p_effective_date IN DATE
283: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 286: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2

282: ,p_effective_date IN DATE
283: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_asg_rate_type 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_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2

283: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_asg_rate_type 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_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

284: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_asg_rate_type 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_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
286: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_asg_rate_type 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_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_asg_rate_type 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_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_asg_rate_type 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_asg_rate_type 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) IS

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) IS
310: --

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) IS
310: --
311: -- Declare cursors and local variables

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) IS
310: --
311: -- Declare cursors and local variables
312: --

Line 309: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2) IS

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) IS
310: --
311: -- Declare cursors and local variables
312: --
313: l_proc VARCHAR2(72) := g_package||'update_rate';

Line 379: WHEN hr_api.cannot_find_prog_unit THEN

375: ,p_attribute19 => p_attribute19
376: ,p_attribute20 => p_attribute20);
377: --
378: EXCEPTION
379: WHEN hr_api.cannot_find_prog_unit THEN
380: hr_api.cannot_find_prog_unit_error
381: (p_module_name => 'update_rate'
382: ,p_hook_type => 'BP');
383: --

Line 380: hr_api.cannot_find_prog_unit_error

376: ,p_attribute20 => p_attribute20);
377: --
378: EXCEPTION
379: WHEN hr_api.cannot_find_prog_unit THEN
380: hr_api.cannot_find_prog_unit_error
381: (p_module_name => 'update_rate'
382: ,p_hook_type => 'BP');
383: --
384: -- End of API User Hook for the before hook of update_rate

Line 477: WHEN hr_api.cannot_find_prog_unit THEN

473: ,p_attribute19 => p_attribute19
474: ,p_attribute20 => p_attribute20);
475: --
476: EXCEPTION
477: WHEN hr_api.cannot_find_prog_unit THEN
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'update_rate'
480: ,p_hook_type => 'AP');
481: --

Line 478: hr_api.cannot_find_prog_unit_error

474: ,p_attribute20 => p_attribute20);
475: --
476: EXCEPTION
477: WHEN hr_api.cannot_find_prog_unit THEN
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'update_rate'
480: ,p_hook_type => 'AP');
481: --
482: -- End of API User Hook for the after hook of update_rate

Line 492: RAISE hr_api.validate_enabled;

488: -- When in validation only mode raise the Validate_Enabled exception
489: --
490: IF p_validate THEN
491: --
492: RAISE hr_api.validate_enabled;
493: --
494: END IF;
495: --
496: -- Set all output arguments

Line 504: WHEN hr_api.validate_enabled THEN

500: hr_utility.set_location(' Leaving:'||l_proc, 999);
501: --
502: EXCEPTION
503: --
504: WHEN hr_api.validate_enabled THEN
505: --
506: -- As the Validate_Enabled exception has been raised
507: -- we must rollback to the savepoint
508: --

Line 586: WHEN hr_api.cannot_find_prog_unit THEN

582: ,p_object_version_number => l_object_version_number
583: ,p_effective_date => l_effective_date);
584: --
585: EXCEPTION
586: WHEN hr_api.cannot_find_prog_unit THEN
587: --
588: hr_api.cannot_find_prog_unit_error
589: (p_module_name => 'delete_rate'
590: ,p_hook_type => 'BP');

Line 588: hr_api.cannot_find_prog_unit_error

584: --
585: EXCEPTION
586: WHEN hr_api.cannot_find_prog_unit THEN
587: --
588: hr_api.cannot_find_prog_unit_error
589: (p_module_name => 'delete_rate'
590: ,p_hook_type => 'BP');
591: --
592: -- End of API User Hook for the before hook of delete_rate

Line 642: WHEN hr_api.cannot_find_prog_unit THEN

638: ,p_object_version_number => l_object_version_number);
639: --
640: EXCEPTION
641: --
642: WHEN hr_api.cannot_find_prog_unit THEN
643: --
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'delete_rate'
646: ,p_hook_type => 'AP');

Line 644: hr_api.cannot_find_prog_unit_error

640: EXCEPTION
641: --
642: WHEN hr_api.cannot_find_prog_unit THEN
643: --
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'delete_rate'
646: ,p_hook_type => 'AP');
647: --
648: -- End of API User Hook for the after hook of delete_rate

Line 658: RAISE hr_api.validate_enabled;

654: -- When in validation only mode raise the Validate_Enabled exception
655: --
656: IF p_validate THEN
657: --
658: RAISE hr_api.validate_enabled;
659: --
660: END IF;
661: --
662: hr_utility.set_location(' Leaving:'||l_proc, 999);

Line 666: WHEN hr_api.validate_enabled THEN

662: hr_utility.set_location(' Leaving:'||l_proc, 999);
663: --
664: EXCEPTION
665: --
666: WHEN hr_api.validate_enabled THEN
667: --
668: -- As the Validate_Enabled exception has been raised
669: -- we must rollback to the savepoint
670: --

Line 790: WHEN hr_api.cannot_find_prog_unit THEN

786: ,p_attribute19 => p_attribute19
787: ,p_attribute20 => p_attribute20);
788: --
789: EXCEPTION
790: WHEN hr_api.cannot_find_prog_unit THEN
791: hr_api.cannot_find_prog_unit_error
792: (p_module_name => 'create_assignment_rate'
793: ,p_hook_type => 'BP');
794: --

Line 791: hr_api.cannot_find_prog_unit_error

787: ,p_attribute20 => p_attribute20);
788: --
789: EXCEPTION
790: WHEN hr_api.cannot_find_prog_unit THEN
791: hr_api.cannot_find_prog_unit_error
792: (p_module_name => 'create_assignment_rate'
793: ,p_hook_type => 'BP');
794: --
795: -- End of API User Hook for the before hook of create_assignment_rate

Line 872: WHEN hr_api.cannot_find_prog_unit THEN

868: ,p_attribute19 => p_attribute19
869: ,p_attribute20 => p_attribute20);
870: --
871: EXCEPTION
872: WHEN hr_api.cannot_find_prog_unit THEN
873: hr_api.cannot_find_prog_unit_error
874: (p_module_name => 'create_assignment_rate'
875: ,p_hook_type => 'AP');
876: --

Line 873: hr_api.cannot_find_prog_unit_error

869: ,p_attribute20 => p_attribute20);
870: --
871: EXCEPTION
872: WHEN hr_api.cannot_find_prog_unit THEN
873: hr_api.cannot_find_prog_unit_error
874: (p_module_name => 'create_assignment_rate'
875: ,p_hook_type => 'AP');
876: --
877: -- End of API User Hook for the after hook of create_assignment_rate

Line 887: RAISE hr_api.validate_enabled;

883: -- When in validation only mode raise the Validate_Enabled exception
884: --
885: IF p_validate THEN
886: --
887: RAISE hr_api.validate_enabled;
888: --
889: END IF;
890: --
891: -- Set all output arguments

Line 900: WHEN hr_api.validate_enabled THEN

896: hr_utility.set_location(' Leaving:'||l_proc, 999);
897: --
898: EXCEPTION
899: --
900: WHEN hr_api.validate_enabled THEN
901: --
902: -- As the Validate_Enabled exception has been raised
903: -- we must rollback to the savepoint
904: --

Line 940: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

936: (p_validate IN BOOLEAN DEFAULT FALSE
937: ,p_rate_id IN NUMBER
938: ,p_object_version_number IN OUT NOCOPY NUMBER
939: ,p_effective_date IN DATE
940: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
941: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
942: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
943: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 941: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2

937: ,p_rate_id IN NUMBER
938: ,p_object_version_number IN OUT NOCOPY NUMBER
939: ,p_effective_date IN DATE
940: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
941: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
942: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
943: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 942: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

938: ,p_object_version_number IN OUT NOCOPY NUMBER
939: ,p_effective_date IN DATE
940: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
941: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
942: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
943: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 943: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

939: ,p_effective_date IN DATE
940: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
941: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
942: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
943: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

940: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
941: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
942: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
943: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

941: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_varchar2
942: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
943: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

942: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
943: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

943: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

944: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

945: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

946: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

947: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

948: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

949: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

950: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

951: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

952: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
960: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

953: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
960: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
961: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

954: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
960: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
961: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
962: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

955: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
960: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
961: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
962: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
963: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2) IS

Line 960: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

956: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
960: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
961: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
962: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
963: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2) IS
964: --

Line 961: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

957: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
960: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
961: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
962: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
963: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2) IS
964: --
965: -- Declare cursors and local variables

Line 962: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

958: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
960: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
961: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
962: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
963: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2) IS
964: --
965: -- Declare cursors and local variables
966: --

Line 963: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2) IS

959: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
960: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
961: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
962: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
963: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2) IS
964: --
965: -- Declare cursors and local variables
966: --
967: l_proc VARCHAR2(72) := g_package||'update_assignment_rate';

Line 1021: WHEN hr_api.cannot_find_prog_unit THEN

1017: ,p_attribute19 => p_attribute19
1018: ,p_attribute20 => p_attribute20);
1019: --
1020: EXCEPTION
1021: WHEN hr_api.cannot_find_prog_unit THEN
1022: hr_api.cannot_find_prog_unit_error
1023: (p_module_name => 'update_assignment_rate'
1024: ,p_hook_type => 'BP');
1025: --

Line 1022: hr_api.cannot_find_prog_unit_error

1018: ,p_attribute20 => p_attribute20);
1019: --
1020: EXCEPTION
1021: WHEN hr_api.cannot_find_prog_unit THEN
1022: hr_api.cannot_find_prog_unit_error
1023: (p_module_name => 'update_assignment_rate'
1024: ,p_hook_type => 'BP');
1025: --
1026: -- End of API User Hook for the before hook of update_assignment_rate

Line 1097: WHEN hr_api.cannot_find_prog_unit THEN

1093: ,p_attribute19 => p_attribute19
1094: ,p_attribute20 => p_attribute20);
1095: --
1096: EXCEPTION
1097: WHEN hr_api.cannot_find_prog_unit THEN
1098: hr_api.cannot_find_prog_unit_error
1099: (p_module_name => 'update_assignment_rate'
1100: ,p_hook_type => 'AP');
1101: --

Line 1098: hr_api.cannot_find_prog_unit_error

1094: ,p_attribute20 => p_attribute20);
1095: --
1096: EXCEPTION
1097: WHEN hr_api.cannot_find_prog_unit THEN
1098: hr_api.cannot_find_prog_unit_error
1099: (p_module_name => 'update_assignment_rate'
1100: ,p_hook_type => 'AP');
1101: --
1102: -- End of API User Hook for the after hook of update_assignment_rate

Line 1112: RAISE hr_api.validate_enabled;

1108: -- When in validation only mode raise the Validate_Enabled exception
1109: --
1110: IF p_validate THEN
1111: --
1112: RAISE hr_api.validate_enabled;
1113: --
1114: END IF;
1115: --
1116: -- Set all output arguments

Line 1124: WHEN hr_api.validate_enabled THEN

1120: hr_utility.set_location(' Leaving:'||l_proc, 999);
1121: --
1122: EXCEPTION
1123: --
1124: WHEN hr_api.validate_enabled THEN
1125: --
1126: -- As the Validate_Enabled exception has been raised
1127: -- we must rollback to the savepoint
1128: --