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

Line 178: WHEN hr_api.cannot_find_prog_unit THEN

174: --
175: hr_utility.set_location(l_proc, 90);
176: --
177: EXCEPTION
178: WHEN hr_api.cannot_find_prog_unit THEN
179: hr_api.cannot_find_prog_unit_error
180: (
181: p_module_name => 'create_soc_ins_contributions'
182: ,p_hook_type => 'BP'

Line 179: hr_api.cannot_find_prog_unit_error

175: hr_utility.set_location(l_proc, 90);
176: --
177: EXCEPTION
178: WHEN hr_api.cannot_find_prog_unit THEN
179: hr_api.cannot_find_prog_unit_error
180: (
181: p_module_name => 'create_soc_ins_contributions'
182: ,p_hook_type => 'BP'
183: );

Line 325: WHEN hr_api.cannot_find_prog_unit THEN

321: hr_utility.set_location(l_proc, 130);
322: --
323:
324: EXCEPTION
325: WHEN hr_api.cannot_find_prog_unit THEN
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'create_soc_ins_contributions'
328: ,p_hook_type => 'AP'
329: );

Line 326: hr_api.cannot_find_prog_unit_error

322: --
323:
324: EXCEPTION
325: WHEN hr_api.cannot_find_prog_unit THEN
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'create_soc_ins_contributions'
328: ,p_hook_type => 'AP'
329: );
330: --

Line 340: RAISE hr_api.validate_enabled;

336: --
337: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
338: --
339: IF p_validate THEN
340: RAISE hr_api.validate_enabled;
341: END IF;
342: --
343: -- Set all output arguments
344: --

Line 355: WHEN hr_api.validate_enabled THEN

351: hr_utility.set_location(' Leaving:'||l_proc, 999);
352: --
353: EXCEPTION
354: --
355: WHEN hr_api.validate_enabled THEN
356: --
357: -- As the Validate_Enabled EXCEPTION has been RAISEd
358: -- we must rollback to the SAVEPOINT
359: --

Line 396: ,p_organization_id IN number default hr_api.g_number

392: PROCEDURE update_soc_ins_contributions
393: (
394:
395: p_validate IN boolean default false
396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number

Line 397: ,p_normal_percentage IN number default hr_api.g_number

393: (
394:
395: p_validate IN boolean default false
396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number

Line 398: ,p_normal_amount IN number default hr_api.g_number

394:
395: p_validate IN boolean default false
396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number

Line 399: ,p_increased_percentage IN number default hr_api.g_number

395: p_validate IN boolean default false
396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date

Line 400: ,p_increased_amount IN number default hr_api.g_number

396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date

Line 401: ,p_reduced_percentage IN number default hr_api.g_number

397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2

Line 402: ,p_reduced_amount IN number default hr_api.g_number

398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2

Line 405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2

401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2

Line 406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2

402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2

Line 407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2

403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2

Line 408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2

404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2

Line 409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2

405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2

Line 410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2

406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2

Line 411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2

407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2

Line 412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2

408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2

Line 413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2

409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2

Line 414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2

410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2

Line 415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2

411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2

Line 416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2

412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2

Line 417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2

413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2

Line 418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2

414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2

Line 419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2

415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2

Line 420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2

416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2

Line 421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2

417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2

Line 422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2

418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2

Line 423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2

419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2

Line 424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2

420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2

Line 425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2

421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2

Line 426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2

422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2

Line 427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2

423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2

Line 428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2

424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2

Line 429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2

425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2

Line 430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2

426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2

Line 431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2

427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2

Line 432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2

428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
436: ,p_effective_date IN date

Line 433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2

429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
436: ,p_effective_date IN date
437: ,p_object_version_number IN OUT NOCOPY number

Line 434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2

430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
436: ,p_effective_date IN date
437: ,p_object_version_number IN OUT NOCOPY number
438: ,p_soc_ins_contr_lvls_id IN number

Line 435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2

431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
436: ,p_effective_date IN date
437: ,p_object_version_number IN OUT NOCOPY number
438: ,p_soc_ins_contr_lvls_id IN number
439: ,p_datetrack_mode in varchar2

Line 440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number

436: ,p_effective_date IN date
437: ,p_object_version_number IN OUT NOCOPY number
438: ,p_soc_ins_contr_lvls_id IN number
439: ,p_datetrack_mode in varchar2
440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2

Line 441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number

437: ,p_object_version_number IN OUT NOCOPY number
438: ,p_soc_ins_contr_lvls_id IN number
439: ,p_datetrack_mode in varchar2
440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number

Line 442: ,p_min_increased_contribution IN number default hr_api.g_number

438: ,p_soc_ins_contr_lvls_id IN number
439: ,p_datetrack_mode in varchar2
440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number

Line 443: ,p_max_increased_contribution IN number default hr_api.g_number

439: ,p_datetrack_mode in varchar2
440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2

Line 444: ,p_month1 IN varchar2 default hr_api.g_varchar2

440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number

Line 445: ,p_month1_min_contribution IN number default hr_api.g_number

441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number

Line 446: ,p_month1_max_contribution IN number default hr_api.g_number

442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number

Line 447: ,p_month2 IN varchar2 default hr_api.g_varchar2

443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2

Line 448: ,p_month2_min_contribution IN number default hr_api.g_number

444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2
452: ) is

Line 449: ,p_month2_max_contribution IN number default hr_api.g_number

445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2
452: ) is
453:

Line 450: ,p_employee_contribution IN number default hr_api.g_number

446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2
452: ) is
453:
454:

Line 451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2

447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2
452: ) is
453:
454:
455: --

Line 551: WHEN hr_api.cannot_find_prog_unit THEN

547: , p_employee_contribution => p_employee_contribution
548: , p_contribution_level_type => p_contribution_level_type
549: );
550: EXCEPTION
551: WHEN hr_api.cannot_find_prog_unit THEN
552: hr_api.cannot_find_prog_unit_error
553: (p_module_name => 'update_soc_ins_contributions'
554: ,p_hook_type => 'BP'
555: );

Line 552: hr_api.cannot_find_prog_unit_error

548: , p_contribution_level_type => p_contribution_level_type
549: );
550: EXCEPTION
551: WHEN hr_api.cannot_find_prog_unit THEN
552: hr_api.cannot_find_prog_unit_error
553: (p_module_name => 'update_soc_ins_contributions'
554: ,p_hook_type => 'BP'
555: );
556: --

Line 685: WHEN hr_api.cannot_find_prog_unit THEN

681: , p_contribution_level_type => p_contribution_level_type
682: );
683:
684: EXCEPTION
685: WHEN hr_api.cannot_find_prog_unit THEN
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'update_soc_ins_contributions'
688: ,p_hook_type => 'AP'
689: );

Line 686: hr_api.cannot_find_prog_unit_error

682: );
683:
684: EXCEPTION
685: WHEN hr_api.cannot_find_prog_unit THEN
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'update_soc_ins_contributions'
688: ,p_hook_type => 'AP'
689: );
690: --

Line 700: RAISE hr_api.validate_enabled;

696: --
697: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
698: --
699: IF p_validate THEN
700: RAISE hr_api.validate_enabled;
701: END IF;
702: --
703: -- Set all output arguments
704: --

Line 713: WHEN hr_api.validate_enabled THEN

709: hr_utility.set_location(' Leaving:'||l_proc, 70);
710: --
711: EXCEPTION
712: --
713: WHEN hr_api.validate_enabled THEN
714: --
715: -- As the Validate_Enabled EXCEPTION has been RAISEd
716: -- we must rollback to the SAVEPOINT
717: --

Line 792: WHEN hr_api.cannot_find_prog_unit THEN

788: ,p_effective_date => TRUNC(p_effective_date)
789: ,p_datetrack_mode => p_datetrack_mode);
790: --
791: EXCEPTION
792: WHEN hr_api.cannot_find_prog_unit THEN
793: hr_api.cannot_find_prog_unit_error
794: (p_module_name => 'delete_soc_ins_contributions'
795: ,p_hook_type => 'BP'
796: );

Line 793: hr_api.cannot_find_prog_unit_error

789: ,p_datetrack_mode => p_datetrack_mode);
790: --
791: EXCEPTION
792: WHEN hr_api.cannot_find_prog_unit THEN
793: hr_api.cannot_find_prog_unit_error
794: (p_module_name => 'delete_soc_ins_contributions'
795: ,p_hook_type => 'BP'
796: );
797: --

Line 826: WHEN hr_api.cannot_find_prog_unit THEN

822: ,p_effective_date => TRUNC(p_effective_date)
823: ,p_datetrack_mode => p_datetrack_mode
824: );
825: EXCEPTION
826: WHEN hr_api.cannot_find_prog_unit THEN
827: hr_api.cannot_find_prog_unit_error
828: (p_module_name => 'delete_soc_ins_contributions'
829: ,p_hook_type => 'AP'
830: );

Line 827: hr_api.cannot_find_prog_unit_error

823: ,p_datetrack_mode => p_datetrack_mode
824: );
825: EXCEPTION
826: WHEN hr_api.cannot_find_prog_unit THEN
827: hr_api.cannot_find_prog_unit_error
828: (p_module_name => 'delete_soc_ins_contributions'
829: ,p_hook_type => 'AP'
830: );
831: --

Line 841: RAISE hr_api.validate_enabled;

837: --
838: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
839: --
840: IF p_validate THEN
841: RAISE hr_api.validate_enabled;
842: END IF;
843: --
844: p_object_version_number := l_object_version_number;
845: p_effective_start_date := l_effective_start_date;

Line 852: WHEN hr_api.validate_enabled THEN

848: hr_utility.set_location(' Leaving:'||l_proc, 70);
849: --
850: EXCEPTION
851: --
852: WHEN hr_api.validate_enabled THEN
853: --
854: -- As the Validate_Enabled EXCEPTION has been RAISEd
855: -- we must rollback to the SAVEPOINT
856: --