APPS.PAY_PYR_UPD dependencies on HR_API

Line 112: WHEN hr_api.check_integrity_violated THEN

108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: --
111: EXCEPTION
112: WHEN hr_api.check_integrity_violated THEN
113: -- A check constraint has been violated
114: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
115: pay_pyr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

112: WHEN hr_api.check_integrity_violated THEN
113: -- A check constraint has been violated
114: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
115: pay_pyr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: WHEN hr_api.parent_integrity_violated THEN
118: -- Parent integrity has been violated
119: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
120: pay_pyr_shd.constraint_error

Line 117: WHEN hr_api.parent_integrity_violated THEN

113: -- A check constraint has been violated
114: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
115: pay_pyr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: WHEN hr_api.parent_integrity_violated THEN
118: -- Parent integrity has been violated
119: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
120: pay_pyr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

117: WHEN hr_api.parent_integrity_violated THEN
118: -- Parent integrity has been violated
119: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
120: pay_pyr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: WHEN hr_api.unique_integrity_violated THEN
123: -- Unique integrity has been violated
124: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
125: pay_pyr_shd.constraint_error

Line 122: WHEN hr_api.unique_integrity_violated THEN

118: -- Parent integrity has been violated
119: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
120: pay_pyr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: WHEN hr_api.unique_integrity_violated THEN
123: -- Unique integrity has been violated
124: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
125: pay_pyr_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

122: WHEN hr_api.unique_integrity_violated THEN
123: -- Unique integrity has been violated
124: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
125: pay_pyr_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: WHEN Others THEN
128: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
129: Raise;
130: END update_dml;

Line 363: when hr_api.cannot_find_prog_unit THEN

359: );
360: --
361: exception
362: --
363: when hr_api.cannot_find_prog_unit THEN
364: --
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'PAY_RATES'
367: ,p_hook_type => 'AU');

Line 365: hr_api.cannot_find_prog_unit_error

361: exception
362: --
363: when hr_api.cannot_find_prog_unit THEN
364: --
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'PAY_RATES'
367: ,p_hook_type => 'AU');
368: --
369: END;

Line 428: IF (p_rec.business_group_id = hr_api.g_number) THEN

424: -- p_rec plsql record structure
425: -- to see IF a system DEFAULT IS being used. IF a system DEFAULT
426: -- IS being used THEN we must set to the 'current' argument value.
427: --
428: IF (p_rec.business_group_id = hr_api.g_number) THEN
429: p_rec.business_group_id :=
430: pay_pyr_shd.g_old_rec.business_group_id;
431: END IF;
432: IF (p_rec.parent_spine_id = hr_api.g_number) THEN

Line 432: IF (p_rec.parent_spine_id = hr_api.g_number) THEN

428: IF (p_rec.business_group_id = hr_api.g_number) THEN
429: p_rec.business_group_id :=
430: pay_pyr_shd.g_old_rec.business_group_id;
431: END IF;
432: IF (p_rec.parent_spine_id = hr_api.g_number) THEN
433: p_rec.parent_spine_id :=
434: pay_pyr_shd.g_old_rec.parent_spine_id;
435: END IF;
436: IF (p_rec.name = hr_api.g_VARCHAR2) THEN

Line 436: IF (p_rec.name = hr_api.g_VARCHAR2) THEN

432: IF (p_rec.parent_spine_id = hr_api.g_number) THEN
433: p_rec.parent_spine_id :=
434: pay_pyr_shd.g_old_rec.parent_spine_id;
435: END IF;
436: IF (p_rec.name = hr_api.g_VARCHAR2) THEN
437: p_rec.name :=
438: pay_pyr_shd.g_old_rec.name;
439: END IF;
440: IF (p_rec.rate_type = hr_api.g_VARCHAR2) THEN

Line 440: IF (p_rec.rate_type = hr_api.g_VARCHAR2) THEN

436: IF (p_rec.name = hr_api.g_VARCHAR2) THEN
437: p_rec.name :=
438: pay_pyr_shd.g_old_rec.name;
439: END IF;
440: IF (p_rec.rate_type = hr_api.g_VARCHAR2) THEN
441: p_rec.rate_type :=
442: pay_pyr_shd.g_old_rec.rate_type;
443: END IF;
444: IF (p_rec.rate_uom = hr_api.g_VARCHAR2) THEN

Line 444: IF (p_rec.rate_uom = hr_api.g_VARCHAR2) THEN

440: IF (p_rec.rate_type = hr_api.g_VARCHAR2) THEN
441: p_rec.rate_type :=
442: pay_pyr_shd.g_old_rec.rate_type;
443: END IF;
444: IF (p_rec.rate_uom = hr_api.g_VARCHAR2) THEN
445: p_rec.rate_uom :=
446: pay_pyr_shd.g_old_rec.rate_uom;
447: END IF;
448: IF (p_rec.comments = hr_api.g_VARCHAR2) THEN

Line 448: IF (p_rec.comments = hr_api.g_VARCHAR2) THEN

444: IF (p_rec.rate_uom = hr_api.g_VARCHAR2) THEN
445: p_rec.rate_uom :=
446: pay_pyr_shd.g_old_rec.rate_uom;
447: END IF;
448: IF (p_rec.comments = hr_api.g_VARCHAR2) THEN
449: p_rec.comments :=
450: pay_pyr_shd.g_old_rec.comments;
451: END IF;
452: IF (p_rec.request_id = hr_api.g_number) THEN

Line 452: IF (p_rec.request_id = hr_api.g_number) THEN

448: IF (p_rec.comments = hr_api.g_VARCHAR2) THEN
449: p_rec.comments :=
450: pay_pyr_shd.g_old_rec.comments;
451: END IF;
452: IF (p_rec.request_id = hr_api.g_number) THEN
453: p_rec.request_id :=
454: pay_pyr_shd.g_old_rec.request_id;
455: END IF;
456: IF (p_rec.program_application_id = hr_api.g_number) THEN

Line 456: IF (p_rec.program_application_id = hr_api.g_number) THEN

452: IF (p_rec.request_id = hr_api.g_number) THEN
453: p_rec.request_id :=
454: pay_pyr_shd.g_old_rec.request_id;
455: END IF;
456: IF (p_rec.program_application_id = hr_api.g_number) THEN
457: p_rec.program_application_id :=
458: pay_pyr_shd.g_old_rec.program_application_id;
459: END IF;
460: IF (p_rec.program_id = hr_api.g_number) THEN

Line 460: IF (p_rec.program_id = hr_api.g_number) THEN

456: IF (p_rec.program_application_id = hr_api.g_number) THEN
457: p_rec.program_application_id :=
458: pay_pyr_shd.g_old_rec.program_application_id;
459: END IF;
460: IF (p_rec.program_id = hr_api.g_number) THEN
461: p_rec.program_id :=
462: pay_pyr_shd.g_old_rec.program_id;
463: END IF;
464: IF (p_rec.program_update_date = hr_api.g_date) THEN

Line 464: IF (p_rec.program_update_date = hr_api.g_date) THEN

460: IF (p_rec.program_id = hr_api.g_number) THEN
461: p_rec.program_id :=
462: pay_pyr_shd.g_old_rec.program_id;
463: END IF;
464: IF (p_rec.program_update_date = hr_api.g_date) THEN
465: p_rec.program_update_date :=
466: pay_pyr_shd.g_old_rec.program_update_date;
467: END IF;
468: IF (p_rec.attribute_category = hr_api.g_VARCHAR2) THEN

Line 468: IF (p_rec.attribute_category = hr_api.g_VARCHAR2) THEN

464: IF (p_rec.program_update_date = hr_api.g_date) THEN
465: p_rec.program_update_date :=
466: pay_pyr_shd.g_old_rec.program_update_date;
467: END IF;
468: IF (p_rec.attribute_category = hr_api.g_VARCHAR2) THEN
469: p_rec.attribute_category :=
470: pay_pyr_shd.g_old_rec.attribute_category;
471: END IF;
472: IF (p_rec.attribute1 = hr_api.g_VARCHAR2) THEN

Line 472: IF (p_rec.attribute1 = hr_api.g_VARCHAR2) THEN

468: IF (p_rec.attribute_category = hr_api.g_VARCHAR2) THEN
469: p_rec.attribute_category :=
470: pay_pyr_shd.g_old_rec.attribute_category;
471: END IF;
472: IF (p_rec.attribute1 = hr_api.g_VARCHAR2) THEN
473: p_rec.attribute1 :=
474: pay_pyr_shd.g_old_rec.attribute1;
475: END IF;
476: IF (p_rec.attribute2 = hr_api.g_VARCHAR2) THEN

Line 476: IF (p_rec.attribute2 = hr_api.g_VARCHAR2) THEN

472: IF (p_rec.attribute1 = hr_api.g_VARCHAR2) THEN
473: p_rec.attribute1 :=
474: pay_pyr_shd.g_old_rec.attribute1;
475: END IF;
476: IF (p_rec.attribute2 = hr_api.g_VARCHAR2) THEN
477: p_rec.attribute2 :=
478: pay_pyr_shd.g_old_rec.attribute2;
479: END IF;
480: IF (p_rec.attribute3 = hr_api.g_VARCHAR2) THEN

Line 480: IF (p_rec.attribute3 = hr_api.g_VARCHAR2) THEN

476: IF (p_rec.attribute2 = hr_api.g_VARCHAR2) THEN
477: p_rec.attribute2 :=
478: pay_pyr_shd.g_old_rec.attribute2;
479: END IF;
480: IF (p_rec.attribute3 = hr_api.g_VARCHAR2) THEN
481: p_rec.attribute3 :=
482: pay_pyr_shd.g_old_rec.attribute3;
483: END IF;
484: IF (p_rec.attribute4 = hr_api.g_VARCHAR2) THEN

Line 484: IF (p_rec.attribute4 = hr_api.g_VARCHAR2) THEN

480: IF (p_rec.attribute3 = hr_api.g_VARCHAR2) THEN
481: p_rec.attribute3 :=
482: pay_pyr_shd.g_old_rec.attribute3;
483: END IF;
484: IF (p_rec.attribute4 = hr_api.g_VARCHAR2) THEN
485: p_rec.attribute4 :=
486: pay_pyr_shd.g_old_rec.attribute4;
487: END IF;
488: IF (p_rec.attribute5 = hr_api.g_VARCHAR2) THEN

Line 488: IF (p_rec.attribute5 = hr_api.g_VARCHAR2) THEN

484: IF (p_rec.attribute4 = hr_api.g_VARCHAR2) THEN
485: p_rec.attribute4 :=
486: pay_pyr_shd.g_old_rec.attribute4;
487: END IF;
488: IF (p_rec.attribute5 = hr_api.g_VARCHAR2) THEN
489: p_rec.attribute5 :=
490: pay_pyr_shd.g_old_rec.attribute5;
491: END IF;
492: IF (p_rec.attribute6 = hr_api.g_VARCHAR2) THEN

Line 492: IF (p_rec.attribute6 = hr_api.g_VARCHAR2) THEN

488: IF (p_rec.attribute5 = hr_api.g_VARCHAR2) THEN
489: p_rec.attribute5 :=
490: pay_pyr_shd.g_old_rec.attribute5;
491: END IF;
492: IF (p_rec.attribute6 = hr_api.g_VARCHAR2) THEN
493: p_rec.attribute6 :=
494: pay_pyr_shd.g_old_rec.attribute6;
495: END IF;
496: IF (p_rec.attribute7 = hr_api.g_VARCHAR2) THEN

Line 496: IF (p_rec.attribute7 = hr_api.g_VARCHAR2) THEN

492: IF (p_rec.attribute6 = hr_api.g_VARCHAR2) THEN
493: p_rec.attribute6 :=
494: pay_pyr_shd.g_old_rec.attribute6;
495: END IF;
496: IF (p_rec.attribute7 = hr_api.g_VARCHAR2) THEN
497: p_rec.attribute7 :=
498: pay_pyr_shd.g_old_rec.attribute7;
499: END IF;
500: IF (p_rec.attribute8 = hr_api.g_VARCHAR2) THEN

Line 500: IF (p_rec.attribute8 = hr_api.g_VARCHAR2) THEN

496: IF (p_rec.attribute7 = hr_api.g_VARCHAR2) THEN
497: p_rec.attribute7 :=
498: pay_pyr_shd.g_old_rec.attribute7;
499: END IF;
500: IF (p_rec.attribute8 = hr_api.g_VARCHAR2) THEN
501: p_rec.attribute8 :=
502: pay_pyr_shd.g_old_rec.attribute8;
503: END IF;
504: IF (p_rec.attribute9 = hr_api.g_VARCHAR2) THEN

Line 504: IF (p_rec.attribute9 = hr_api.g_VARCHAR2) THEN

500: IF (p_rec.attribute8 = hr_api.g_VARCHAR2) THEN
501: p_rec.attribute8 :=
502: pay_pyr_shd.g_old_rec.attribute8;
503: END IF;
504: IF (p_rec.attribute9 = hr_api.g_VARCHAR2) THEN
505: p_rec.attribute9 :=
506: pay_pyr_shd.g_old_rec.attribute9;
507: END IF;
508: IF (p_rec.attribute10 = hr_api.g_VARCHAR2) THEN

Line 508: IF (p_rec.attribute10 = hr_api.g_VARCHAR2) THEN

504: IF (p_rec.attribute9 = hr_api.g_VARCHAR2) THEN
505: p_rec.attribute9 :=
506: pay_pyr_shd.g_old_rec.attribute9;
507: END IF;
508: IF (p_rec.attribute10 = hr_api.g_VARCHAR2) THEN
509: p_rec.attribute10 :=
510: pay_pyr_shd.g_old_rec.attribute10;
511: END IF;
512: IF (p_rec.attribute11 = hr_api.g_VARCHAR2) THEN

Line 512: IF (p_rec.attribute11 = hr_api.g_VARCHAR2) THEN

508: IF (p_rec.attribute10 = hr_api.g_VARCHAR2) THEN
509: p_rec.attribute10 :=
510: pay_pyr_shd.g_old_rec.attribute10;
511: END IF;
512: IF (p_rec.attribute11 = hr_api.g_VARCHAR2) THEN
513: p_rec.attribute11 :=
514: pay_pyr_shd.g_old_rec.attribute11;
515: END IF;
516: IF (p_rec.attribute12 = hr_api.g_VARCHAR2) THEN

Line 516: IF (p_rec.attribute12 = hr_api.g_VARCHAR2) THEN

512: IF (p_rec.attribute11 = hr_api.g_VARCHAR2) THEN
513: p_rec.attribute11 :=
514: pay_pyr_shd.g_old_rec.attribute11;
515: END IF;
516: IF (p_rec.attribute12 = hr_api.g_VARCHAR2) THEN
517: p_rec.attribute12 :=
518: pay_pyr_shd.g_old_rec.attribute12;
519: END IF;
520: IF (p_rec.attribute13 = hr_api.g_VARCHAR2) THEN

Line 520: IF (p_rec.attribute13 = hr_api.g_VARCHAR2) THEN

516: IF (p_rec.attribute12 = hr_api.g_VARCHAR2) THEN
517: p_rec.attribute12 :=
518: pay_pyr_shd.g_old_rec.attribute12;
519: END IF;
520: IF (p_rec.attribute13 = hr_api.g_VARCHAR2) THEN
521: p_rec.attribute13 :=
522: pay_pyr_shd.g_old_rec.attribute13;
523: END IF;
524: IF (p_rec.attribute14 = hr_api.g_VARCHAR2) THEN

Line 524: IF (p_rec.attribute14 = hr_api.g_VARCHAR2) THEN

520: IF (p_rec.attribute13 = hr_api.g_VARCHAR2) THEN
521: p_rec.attribute13 :=
522: pay_pyr_shd.g_old_rec.attribute13;
523: END IF;
524: IF (p_rec.attribute14 = hr_api.g_VARCHAR2) THEN
525: p_rec.attribute14 :=
526: pay_pyr_shd.g_old_rec.attribute14;
527: END IF;
528: IF (p_rec.attribute15 = hr_api.g_VARCHAR2) THEN

Line 528: IF (p_rec.attribute15 = hr_api.g_VARCHAR2) THEN

524: IF (p_rec.attribute14 = hr_api.g_VARCHAR2) THEN
525: p_rec.attribute14 :=
526: pay_pyr_shd.g_old_rec.attribute14;
527: END IF;
528: IF (p_rec.attribute15 = hr_api.g_VARCHAR2) THEN
529: p_rec.attribute15 :=
530: pay_pyr_shd.g_old_rec.attribute15;
531: END IF;
532: IF (p_rec.attribute16 = hr_api.g_VARCHAR2) THEN

Line 532: IF (p_rec.attribute16 = hr_api.g_VARCHAR2) THEN

528: IF (p_rec.attribute15 = hr_api.g_VARCHAR2) THEN
529: p_rec.attribute15 :=
530: pay_pyr_shd.g_old_rec.attribute15;
531: END IF;
532: IF (p_rec.attribute16 = hr_api.g_VARCHAR2) THEN
533: p_rec.attribute16 :=
534: pay_pyr_shd.g_old_rec.attribute16;
535: END IF;
536: IF (p_rec.attribute17 = hr_api.g_VARCHAR2) THEN

Line 536: IF (p_rec.attribute17 = hr_api.g_VARCHAR2) THEN

532: IF (p_rec.attribute16 = hr_api.g_VARCHAR2) THEN
533: p_rec.attribute16 :=
534: pay_pyr_shd.g_old_rec.attribute16;
535: END IF;
536: IF (p_rec.attribute17 = hr_api.g_VARCHAR2) THEN
537: p_rec.attribute17 :=
538: pay_pyr_shd.g_old_rec.attribute17;
539: END IF;
540: IF (p_rec.attribute18 = hr_api.g_VARCHAR2) THEN

Line 540: IF (p_rec.attribute18 = hr_api.g_VARCHAR2) THEN

536: IF (p_rec.attribute17 = hr_api.g_VARCHAR2) THEN
537: p_rec.attribute17 :=
538: pay_pyr_shd.g_old_rec.attribute17;
539: END IF;
540: IF (p_rec.attribute18 = hr_api.g_VARCHAR2) THEN
541: p_rec.attribute18 :=
542: pay_pyr_shd.g_old_rec.attribute18;
543: END IF;
544: IF (p_rec.attribute19 = hr_api.g_VARCHAR2) THEN

Line 544: IF (p_rec.attribute19 = hr_api.g_VARCHAR2) THEN

540: IF (p_rec.attribute18 = hr_api.g_VARCHAR2) THEN
541: p_rec.attribute18 :=
542: pay_pyr_shd.g_old_rec.attribute18;
543: END IF;
544: IF (p_rec.attribute19 = hr_api.g_VARCHAR2) THEN
545: p_rec.attribute19 :=
546: pay_pyr_shd.g_old_rec.attribute19;
547: END IF;
548: IF (p_rec.attribute20 = hr_api.g_VARCHAR2) THEN

Line 548: IF (p_rec.attribute20 = hr_api.g_VARCHAR2) THEN

544: IF (p_rec.attribute19 = hr_api.g_VARCHAR2) THEN
545: p_rec.attribute19 :=
546: pay_pyr_shd.g_old_rec.attribute19;
547: END IF;
548: IF (p_rec.attribute20 = hr_api.g_VARCHAR2) THEN
549: p_rec.attribute20 :=
550: pay_pyr_shd.g_old_rec.attribute20;
551: END IF;
552: IF (p_rec.rate_basis = hr_api.g_VARCHAR2) THEN

Line 552: IF (p_rec.rate_basis = hr_api.g_VARCHAR2) THEN

548: IF (p_rec.attribute20 = hr_api.g_VARCHAR2) THEN
549: p_rec.attribute20 :=
550: pay_pyr_shd.g_old_rec.attribute20;
551: END IF;
552: IF (p_rec.rate_basis = hr_api.g_VARCHAR2) THEN
553: p_rec.rate_basis :=
554: pay_pyr_shd.g_old_rec.rate_basis;
555: END IF;
556: IF (p_rec.asg_rate_type = hr_api.g_VARCHAR2) THEN

Line 556: IF (p_rec.asg_rate_type = hr_api.g_VARCHAR2) THEN

552: IF (p_rec.rate_basis = hr_api.g_VARCHAR2) THEN
553: p_rec.rate_basis :=
554: pay_pyr_shd.g_old_rec.rate_basis;
555: END IF;
556: IF (p_rec.asg_rate_type = hr_api.g_VARCHAR2) THEN
557: p_rec.asg_rate_type :=
558: pay_pyr_shd.g_old_rec.asg_rate_type;
559: END IF;
560: --

Line 624: ,p_name IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

620: PROCEDURE upd
621: (p_effective_date IN DATE
622: ,p_rate_id IN NUMBER
623: ,p_object_version_number IN OUT NOCOPY NUMBER
624: ,p_name IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
625: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
626: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
627: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 625: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

621: (p_effective_date IN DATE
622: ,p_rate_id IN NUMBER
623: ,p_object_version_number IN OUT NOCOPY NUMBER
624: ,p_name IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
625: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
626: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
627: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 626: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number

622: ,p_rate_id IN NUMBER
623: ,p_object_version_number IN OUT NOCOPY NUMBER
624: ,p_name IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
625: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
626: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
627: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 627: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

623: ,p_object_version_number IN OUT NOCOPY NUMBER
624: ,p_name IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
625: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
626: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
627: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

624: ,p_name IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
625: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
626: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
627: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

625: ,p_rate_uom IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
626: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
627: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

626: ,p_parent_spine_id IN NUMBER DEFAULT hr_api.g_number
627: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

627: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

628: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

629: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

630: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

631: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

632: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

633: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

634: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

635: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

636: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

637: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

638: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

639: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
647: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

640: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
647: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
648: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

641: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
647: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
648: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
649: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

642: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
647: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
648: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
649: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
650: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 647: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

643: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
647: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
648: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
649: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
650: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
651: ) IS

Line 648: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

644: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
647: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
648: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
649: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
650: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
651: ) IS
652: --

Line 649: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

645: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
647: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
648: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
649: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
650: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
651: ) IS
652: --
653: l_rec pay_pyr_shd.g_rec_type;

Line 650: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

646: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
647: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
648: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
649: ,p_rate_basis IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
650: ,p_asg_rate_type IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
651: ) IS
652: --
653: l_rec pay_pyr_shd.g_rec_type;
654: l_proc VARCHAR2(72) := g_package||'upd';

Line 665: ,hr_api.g_number --p_business_group_id

661: --
662: l_rec :=
663: pay_pyr_shd.convert_args
664: (p_rate_id
665: ,hr_api.g_number --p_business_group_id
666: ,p_parent_spine_id
667: ,p_name
668: ,hr_api.g_varchar2 --p_rate_type
669: ,p_rate_uom

Line 668: ,hr_api.g_varchar2 --p_rate_type

664: (p_rate_id
665: ,hr_api.g_number --p_business_group_id
666: ,p_parent_spine_id
667: ,p_name
668: ,hr_api.g_varchar2 --p_rate_type
669: ,p_rate_uom
670: ,p_comments
671: ,p_attribute_category
672: ,p_attribute1