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

Line 14: lv_EndDate hr_api_transaction_steps.Information1%type;

10:
11: function getEndDate(p_transaction_id in number) return date
12: IS
13: c_proc constant varchar2(30) := 'getEndDate';
14: lv_EndDate hr_api_transaction_steps.Information1%type;
15: begin
16:
17: if(p_transaction_id is not null) then
18: begin

Line 21: from hr_api_transaction_steps

17: if(p_transaction_id is not null) then
18: begin
19: select nvl(Information2,Information4)
20: into lv_EndDate
21: from hr_api_transaction_steps
22: where transaction_id=p_transaction_id;
23:
24: exception
25: when others then

Line 50: lv_startDate hr_api_transaction_steps.Information1%type;

46: function getStartDate(p_transaction_id in number) return date
47:
48: IS
49: c_proc constant varchar2(30) := 'getStartDate';
50: lv_startDate hr_api_transaction_steps.Information1%type;
51: begin
52:
53: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
54:

Line 60: from hr_api_transaction_steps

56: if(p_transaction_id is not null) then
57: begin
58: select nvl(Information1,Information3)
59: into lv_startDate
60: from hr_api_transaction_steps
61: where transaction_id=p_transaction_id;
62:
63: exception
64: when others then

Line 112: from hr_api_transactions hat

108: ,p_time_start IN VARCHAR2
109: ,p_time_end IN VARCHAR2
110: ) IS
111: SELECT 1
112: from hr_api_transactions hat
113: where
114: hat.selected_person_id = p_person_id
115: and hat.TRANSACTION_IDENTIFIER = 'ABSENCES'
116: and hat.STATUS in ('Y','C')

Line 204: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

200: fetch get_category_code into l_absence_category ;
201: close get_category_code ;
202:
203: IF l_absence_category = 'S' THEN
204: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
205: IF l_legislation_code = 'GB' THEN
206: hr_utility.set_location(l_proc,10);
207:
208: populate_sickness_dates := true;

Line 221: (p_validate in number default hr_api.g_false_num

217: -- ----------------------------------------------------------------------------
218: -- |-------------------------< create_person_absence >------------------------|
219: -- ----------------------------------------------------------------------------
220: PROCEDURE create_person_absence
221: (p_validate in number default hr_api.g_false_num
222: ,p_effective_date in date
223: ,p_person_id in number
224: ,p_business_group_id in number
225: ,p_absence_attendance_type_id in number

Line 374: hr_api.constant_to_boolean

370: --
371: -- Convert constant values to their corresponding boolean value
372: --
373: l_validate :=
374: hr_api.constant_to_boolean
375: (p_constant_value => p_validate);
376: l_create_element_entry :=
377: hr_api.constant_to_boolean
378: (p_constant_value => p_create_element_entry);

Line 377: hr_api.constant_to_boolean

373: l_validate :=
374: hr_api.constant_to_boolean
375: (p_constant_value => p_validate);
376: l_create_element_entry :=
377: hr_api.constant_to_boolean
378: (p_constant_value => p_create_element_entry);
379: --
380: -- Register Surrogate ID or user key values
381: --

Line 635: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then

631: if l_error_text is null then
632: l_error_text := fnd_message.get;
633: end if;
634:
635: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then
636: hr_utility.set_location(' Leaving:' || l_proc,45);
637: raise;
638: end if;
639: --

Line 654: (p_validate in number default hr_api.g_false_num

650: -- ----------------------------------------------------------------------------
651: -- |-------------------------< update_person_absence >------------------------|
652: -- ----------------------------------------------------------------------------
653: PROCEDURE update_person_absence
654: (p_validate in number default hr_api.g_false_num
655: ,p_effective_date in date
656: ,p_absence_attendance_id in number
657: ,p_abs_attendance_reason_id in number default hr_api.g_number
658: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792

Line 657: ,p_abs_attendance_reason_id in number default hr_api.g_number

653: PROCEDURE update_person_absence
654: (p_validate in number default hr_api.g_false_num
655: ,p_effective_date in date
656: ,p_absence_attendance_id in number
657: ,p_abs_attendance_reason_id in number default hr_api.g_number
658: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
659: ,p_date_notification in date default hr_api.g_date
660: ,p_date_projected_start in date default hr_api.g_date
661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2

Line 658: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792

654: (p_validate in number default hr_api.g_false_num
655: ,p_effective_date in date
656: ,p_absence_attendance_id in number
657: ,p_abs_attendance_reason_id in number default hr_api.g_number
658: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
659: ,p_date_notification in date default hr_api.g_date
660: ,p_date_projected_start in date default hr_api.g_date
661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
662: ,p_date_projected_end in date default hr_api.g_date

Line 659: ,p_date_notification in date default hr_api.g_date

655: ,p_effective_date in date
656: ,p_absence_attendance_id in number
657: ,p_abs_attendance_reason_id in number default hr_api.g_number
658: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
659: ,p_date_notification in date default hr_api.g_date
660: ,p_date_projected_start in date default hr_api.g_date
661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
662: ,p_date_projected_end in date default hr_api.g_date
663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2

Line 660: ,p_date_projected_start in date default hr_api.g_date

656: ,p_absence_attendance_id in number
657: ,p_abs_attendance_reason_id in number default hr_api.g_number
658: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
659: ,p_date_notification in date default hr_api.g_date
660: ,p_date_projected_start in date default hr_api.g_date
661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
662: ,p_date_projected_end in date default hr_api.g_date
663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
664: ,p_date_start in date default hr_api.g_date

Line 661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2

657: ,p_abs_attendance_reason_id in number default hr_api.g_number
658: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
659: ,p_date_notification in date default hr_api.g_date
660: ,p_date_projected_start in date default hr_api.g_date
661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
662: ,p_date_projected_end in date default hr_api.g_date
663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
664: ,p_date_start in date default hr_api.g_date
665: ,p_time_start in varchar2 default hr_api.g_varchar2

Line 662: ,p_date_projected_end in date default hr_api.g_date

658: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
659: ,p_date_notification in date default hr_api.g_date
660: ,p_date_projected_start in date default hr_api.g_date
661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
662: ,p_date_projected_end in date default hr_api.g_date
663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
664: ,p_date_start in date default hr_api.g_date
665: ,p_time_start in varchar2 default hr_api.g_varchar2
666: ,p_date_end in date default hr_api.g_date

Line 663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2

659: ,p_date_notification in date default hr_api.g_date
660: ,p_date_projected_start in date default hr_api.g_date
661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
662: ,p_date_projected_end in date default hr_api.g_date
663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
664: ,p_date_start in date default hr_api.g_date
665: ,p_time_start in varchar2 default hr_api.g_varchar2
666: ,p_date_end in date default hr_api.g_date
667: ,p_time_end in varchar2 default hr_api.g_varchar2

Line 664: ,p_date_start in date default hr_api.g_date

660: ,p_date_projected_start in date default hr_api.g_date
661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
662: ,p_date_projected_end in date default hr_api.g_date
663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
664: ,p_date_start in date default hr_api.g_date
665: ,p_time_start in varchar2 default hr_api.g_varchar2
666: ,p_date_end in date default hr_api.g_date
667: ,p_time_end in varchar2 default hr_api.g_varchar2
668: ,p_absence_days in out nocopy number

Line 665: ,p_time_start in varchar2 default hr_api.g_varchar2

661: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
662: ,p_date_projected_end in date default hr_api.g_date
663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
664: ,p_date_start in date default hr_api.g_date
665: ,p_time_start in varchar2 default hr_api.g_varchar2
666: ,p_date_end in date default hr_api.g_date
667: ,p_time_end in varchar2 default hr_api.g_varchar2
668: ,p_absence_days in out nocopy number
669: ,p_absence_hours in out nocopy number

Line 666: ,p_date_end in date default hr_api.g_date

662: ,p_date_projected_end in date default hr_api.g_date
663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
664: ,p_date_start in date default hr_api.g_date
665: ,p_time_start in varchar2 default hr_api.g_varchar2
666: ,p_date_end in date default hr_api.g_date
667: ,p_time_end in varchar2 default hr_api.g_varchar2
668: ,p_absence_days in out nocopy number
669: ,p_absence_hours in out nocopy number
670: ,p_authorising_person_id in number default hr_api.g_number

Line 667: ,p_time_end in varchar2 default hr_api.g_varchar2

663: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
664: ,p_date_start in date default hr_api.g_date
665: ,p_time_start in varchar2 default hr_api.g_varchar2
666: ,p_date_end in date default hr_api.g_date
667: ,p_time_end in varchar2 default hr_api.g_varchar2
668: ,p_absence_days in out nocopy number
669: ,p_absence_hours in out nocopy number
670: ,p_authorising_person_id in number default hr_api.g_number
671: ,p_replacement_person_id in number default hr_api.g_number

Line 670: ,p_authorising_person_id in number default hr_api.g_number

666: ,p_date_end in date default hr_api.g_date
667: ,p_time_end in varchar2 default hr_api.g_varchar2
668: ,p_absence_days in out nocopy number
669: ,p_absence_hours in out nocopy number
670: ,p_authorising_person_id in number default hr_api.g_number
671: ,p_replacement_person_id in number default hr_api.g_number
672: ,p_attribute_category in varchar2 default hr_api.g_varchar2
673: ,p_attribute1 in varchar2 default hr_api.g_varchar2
674: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 671: ,p_replacement_person_id in number default hr_api.g_number

667: ,p_time_end in varchar2 default hr_api.g_varchar2
668: ,p_absence_days in out nocopy number
669: ,p_absence_hours in out nocopy number
670: ,p_authorising_person_id in number default hr_api.g_number
671: ,p_replacement_person_id in number default hr_api.g_number
672: ,p_attribute_category in varchar2 default hr_api.g_varchar2
673: ,p_attribute1 in varchar2 default hr_api.g_varchar2
674: ,p_attribute2 in varchar2 default hr_api.g_varchar2
675: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 672: ,p_attribute_category in varchar2 default hr_api.g_varchar2

668: ,p_absence_days in out nocopy number
669: ,p_absence_hours in out nocopy number
670: ,p_authorising_person_id in number default hr_api.g_number
671: ,p_replacement_person_id in number default hr_api.g_number
672: ,p_attribute_category in varchar2 default hr_api.g_varchar2
673: ,p_attribute1 in varchar2 default hr_api.g_varchar2
674: ,p_attribute2 in varchar2 default hr_api.g_varchar2
675: ,p_attribute3 in varchar2 default hr_api.g_varchar2
676: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 673: ,p_attribute1 in varchar2 default hr_api.g_varchar2

669: ,p_absence_hours in out nocopy number
670: ,p_authorising_person_id in number default hr_api.g_number
671: ,p_replacement_person_id in number default hr_api.g_number
672: ,p_attribute_category in varchar2 default hr_api.g_varchar2
673: ,p_attribute1 in varchar2 default hr_api.g_varchar2
674: ,p_attribute2 in varchar2 default hr_api.g_varchar2
675: ,p_attribute3 in varchar2 default hr_api.g_varchar2
676: ,p_attribute4 in varchar2 default hr_api.g_varchar2
677: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 674: ,p_attribute2 in varchar2 default hr_api.g_varchar2

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

Line 675: ,p_attribute3 in varchar2 default hr_api.g_varchar2

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

Line 676: ,p_attribute4 in varchar2 default hr_api.g_varchar2

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

Line 677: ,p_attribute5 in varchar2 default hr_api.g_varchar2

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

Line 678: ,p_attribute6 in varchar2 default hr_api.g_varchar2

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

Line 679: ,p_attribute7 in varchar2 default hr_api.g_varchar2

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

Line 680: ,p_attribute8 in varchar2 default hr_api.g_varchar2

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

Line 681: ,p_attribute9 in varchar2 default hr_api.g_varchar2

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

Line 682: ,p_attribute10 in varchar2 default hr_api.g_varchar2

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

Line 683: ,p_attribute11 in varchar2 default hr_api.g_varchar2

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

Line 684: ,p_attribute12 in varchar2 default hr_api.g_varchar2

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

Line 685: ,p_attribute13 in varchar2 default hr_api.g_varchar2

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

Line 686: ,p_attribute14 in varchar2 default hr_api.g_varchar2

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

Line 687: ,p_attribute15 in varchar2 default hr_api.g_varchar2

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

Line 688: ,p_attribute16 in varchar2 default hr_api.g_varchar2

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

Line 689: ,p_attribute17 in varchar2 default hr_api.g_varchar2

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

Line 690: ,p_attribute18 in varchar2 default hr_api.g_varchar2

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

Line 691: ,p_attribute19 in varchar2 default hr_api.g_varchar2

687: ,p_attribute15 in varchar2 default hr_api.g_varchar2
688: ,p_attribute16 in varchar2 default hr_api.g_varchar2
689: ,p_attribute17 in varchar2 default hr_api.g_varchar2
690: ,p_attribute18 in varchar2 default hr_api.g_varchar2
691: ,p_attribute19 in varchar2 default hr_api.g_varchar2
692: ,p_attribute20 in varchar2 default hr_api.g_varchar2
693: ,p_period_of_incapacity_id in number default hr_api.g_number
694: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
695: ,p_maternity_id in number default hr_api.g_number

Line 692: ,p_attribute20 in varchar2 default hr_api.g_varchar2

688: ,p_attribute16 in varchar2 default hr_api.g_varchar2
689: ,p_attribute17 in varchar2 default hr_api.g_varchar2
690: ,p_attribute18 in varchar2 default hr_api.g_varchar2
691: ,p_attribute19 in varchar2 default hr_api.g_varchar2
692: ,p_attribute20 in varchar2 default hr_api.g_varchar2
693: ,p_period_of_incapacity_id in number default hr_api.g_number
694: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
695: ,p_maternity_id in number default hr_api.g_number
696: ,p_sickness_start_date in date default hr_api.g_date

Line 693: ,p_period_of_incapacity_id in number default hr_api.g_number

689: ,p_attribute17 in varchar2 default hr_api.g_varchar2
690: ,p_attribute18 in varchar2 default hr_api.g_varchar2
691: ,p_attribute19 in varchar2 default hr_api.g_varchar2
692: ,p_attribute20 in varchar2 default hr_api.g_varchar2
693: ,p_period_of_incapacity_id in number default hr_api.g_number
694: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
695: ,p_maternity_id in number default hr_api.g_number
696: ,p_sickness_start_date in date default hr_api.g_date
697: ,p_sickness_end_date in date default hr_api.g_date

Line 694: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2

690: ,p_attribute18 in varchar2 default hr_api.g_varchar2
691: ,p_attribute19 in varchar2 default hr_api.g_varchar2
692: ,p_attribute20 in varchar2 default hr_api.g_varchar2
693: ,p_period_of_incapacity_id in number default hr_api.g_number
694: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
695: ,p_maternity_id in number default hr_api.g_number
696: ,p_sickness_start_date in date default hr_api.g_date
697: ,p_sickness_end_date in date default hr_api.g_date
698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2

Line 695: ,p_maternity_id in number default hr_api.g_number

691: ,p_attribute19 in varchar2 default hr_api.g_varchar2
692: ,p_attribute20 in varchar2 default hr_api.g_varchar2
693: ,p_period_of_incapacity_id in number default hr_api.g_number
694: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
695: ,p_maternity_id in number default hr_api.g_number
696: ,p_sickness_start_date in date default hr_api.g_date
697: ,p_sickness_end_date in date default hr_api.g_date
698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2

Line 696: ,p_sickness_start_date in date default hr_api.g_date

692: ,p_attribute20 in varchar2 default hr_api.g_varchar2
693: ,p_period_of_incapacity_id in number default hr_api.g_number
694: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
695: ,p_maternity_id in number default hr_api.g_number
696: ,p_sickness_start_date in date default hr_api.g_date
697: ,p_sickness_end_date in date default hr_api.g_date
698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2

Line 697: ,p_sickness_end_date in date default hr_api.g_date

693: ,p_period_of_incapacity_id in number default hr_api.g_number
694: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
695: ,p_maternity_id in number default hr_api.g_number
696: ,p_sickness_start_date in date default hr_api.g_date
697: ,p_sickness_end_date in date default hr_api.g_date
698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
701: ,p_linked_absence_id in number default hr_api.g_number

Line 698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2

694: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
695: ,p_maternity_id in number default hr_api.g_number
696: ,p_sickness_start_date in date default hr_api.g_date
697: ,p_sickness_end_date in date default hr_api.g_date
698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
701: ,p_linked_absence_id in number default hr_api.g_number
702: ,p_batch_id in number default hr_api.g_number

Line 699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2

695: ,p_maternity_id in number default hr_api.g_number
696: ,p_sickness_start_date in date default hr_api.g_date
697: ,p_sickness_end_date in date default hr_api.g_date
698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
701: ,p_linked_absence_id in number default hr_api.g_number
702: ,p_batch_id in number default hr_api.g_number
703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2

Line 700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2

696: ,p_sickness_start_date in date default hr_api.g_date
697: ,p_sickness_end_date in date default hr_api.g_date
698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
701: ,p_linked_absence_id in number default hr_api.g_number
702: ,p_batch_id in number default hr_api.g_number
703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2

Line 701: ,p_linked_absence_id in number default hr_api.g_number

697: ,p_sickness_end_date in date default hr_api.g_date
698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
701: ,p_linked_absence_id in number default hr_api.g_number
702: ,p_batch_id in number default hr_api.g_number
703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2

Line 702: ,p_batch_id in number default hr_api.g_number

698: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
701: ,p_linked_absence_id in number default hr_api.g_number
702: ,p_batch_id in number default hr_api.g_number
703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2

Line 703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2

699: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
701: ,p_linked_absence_id in number default hr_api.g_number
702: ,p_batch_id in number default hr_api.g_number
703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2

Line 704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2

700: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
701: ,p_linked_absence_id in number default hr_api.g_number
702: ,p_batch_id in number default hr_api.g_number
703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2

Line 705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2

701: ,p_linked_absence_id in number default hr_api.g_number
702: ,p_batch_id in number default hr_api.g_number
703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2

Line 706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2

702: ,p_batch_id in number default hr_api.g_number
703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2

Line 707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2

703: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2

Line 708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2

704: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2

Line 709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2

705: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2

Line 710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2

706: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2

Line 711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2

707: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2

Line 712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2

708: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2

Line 713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2

709: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2

Line 714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2

710: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2

Line 715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2

711: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2

Line 716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2

712: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2

Line 717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2

713: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2

Line 718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2

714: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2

Line 719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2

715: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2

Line 720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2

716: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2

Line 721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2

717: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2

Line 722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2

718: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2

Line 723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2

719: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2

Line 724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2

720: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2

Line 725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2

721: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2

Line 726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2

722: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2

Line 727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2

723: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
731: ,p_abs_information28 in varchar2 default hr_api.g_varchar2

Line 728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2

724: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
731: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
732: ,p_abs_information29 in varchar2 default hr_api.g_varchar2

Line 729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2

725: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
731: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
732: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
733: ,p_abs_information30 in varchar2 default hr_api.g_varchar2

Line 730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2

726: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
731: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
732: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
733: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
734: ,p_absence_case_id in number default hr_api.g_number

Line 731: ,p_abs_information28 in varchar2 default hr_api.g_varchar2

727: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
731: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
732: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
733: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
734: ,p_absence_case_id in number default hr_api.g_number
735: ,p_object_version_number in out nocopy number

Line 732: ,p_abs_information29 in varchar2 default hr_api.g_varchar2

728: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
731: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
732: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
733: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
734: ,p_absence_case_id in number default hr_api.g_number
735: ,p_object_version_number in out nocopy number
736: ,p_return_status out nocopy varchar2

Line 733: ,p_abs_information30 in varchar2 default hr_api.g_varchar2

729: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
731: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
732: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
733: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
734: ,p_absence_case_id in number default hr_api.g_number
735: ,p_object_version_number in out nocopy number
736: ,p_return_status out nocopy varchar2
737: ) is

Line 734: ,p_absence_case_id in number default hr_api.g_number

730: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
731: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
732: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
733: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
734: ,p_absence_case_id in number default hr_api.g_number
735: ,p_object_version_number in out nocopy number
736: ,p_return_status out nocopy varchar2
737: ) is
738: --

Line 801: if p_date_start is null or p_date_start = hr_api.g_date then

797: --
798:
799: -- Bug 6347488,8671547 fix starts
800:
801: if p_date_start is null or p_date_start = hr_api.g_date then
802:
803: select date_start into l_date_start from per_absence_attendances where
804: absence_attendance_id = p_absence_attendance_id;
805:

Line 823: hr_api.constant_to_boolean

819: --
820: -- Convert constant values to their corresponding boolean value
821: --
822: l_validate :=
823: hr_api.constant_to_boolean
824: (p_constant_value => p_validate);
825: --
826: -- Register Surrogate ID or user key values
827: --

Line 836: IF (p_date_start <> hr_api.g_date) THEN

832: IF c_is_gb_leg%FOUND THEN
833: l_populate_sickness_dates := is_gb_leg_and_category_s(l_absence_attendance_type_id , l_business_group_id);
834:
835: IF l_populate_sickness_dates THEN
836: IF (p_date_start <> hr_api.g_date) THEN
837: IF p_date_start > SYSDATE THEN
838: fnd_message.set_name('SSP', 'SSP_35036_INV_NOTIF_DATE');
839: fnd_message.raise_error;
840: END IF;

Line 843: IF (p_date_end <> hr_api.g_date) THEN

839: fnd_message.raise_error;
840: END IF;
841: l_sickness_start_date := p_date_start;
842: END IF;
843: IF (p_date_end <> hr_api.g_date) THEN
844: l_sickness_end_date := p_date_end;
845: END IF;
846: END IF;
847: END IF;

Line 1083: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then

1079: if l_error_text is null then
1080: l_error_text := fnd_message.get;
1081: end if;
1082:
1083: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then
1084: hr_utility.set_location(' Leaving:' || l_proc,45);
1085: raise;
1086: end if;
1087:

Line 1101: (p_validate in number default hr_api.g_false_num

1097: -- ----------------------------------------------------------------------------
1098: -- |-------------------------< delete_person_absence >------------------------|
1099: -- ----------------------------------------------------------------------------
1100: PROCEDURE delete_person_absence
1101: (p_validate in number default hr_api.g_false_num
1102: ,p_absence_attendance_id in number
1103: ,p_object_version_number in number
1104: ,p_return_status out nocopy varchar2
1105: ) is

Line 1133: hr_api.constant_to_boolean

1129: --
1130: -- Convert constant values to their corresponding boolean value
1131: --
1132: l_validate :=
1133: hr_api.constant_to_boolean
1134: (p_constant_value => p_validate);
1135: --
1136: -- Register Surrogate ID or user key values
1137: --

Line 1501: ,p_validate in number default hr_api.g_false_num

1497:
1498: Procedure process_api
1499: ( p_document in CLOB
1500: ,p_return_status out nocopy VARCHAR2
1501: ,p_validate in number default hr_api.g_false_num
1502: ,p_effective_date in date default null
1503: )
1504: IS
1505: l_postState VARCHAR2(2);