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

Line 606: when hr_api.cannot_find_prog_unit then

602: ,p_per_information29 => p_per_information29
603: ,p_per_information30 => p_per_information30
604: );
605: exception
606: when hr_api.cannot_find_prog_unit then
607: hr_api.cannot_find_prog_unit_error
608: (p_module_name => 'create_cwk'
609: ,p_hook_type => 'BP'
610: );

Line 607: hr_api.cannot_find_prog_unit_error

603: ,p_per_information30 => p_per_information30
604: );
605: exception
606: when hr_api.cannot_find_prog_unit then
607: hr_api.cannot_find_prog_unit_error
608: (p_module_name => 'create_cwk'
609: ,p_hook_type => 'BP'
610: );
611: end;

Line 990: when hr_api.cannot_find_prog_unit then

986: ,p_assignment_number => l_assignment_number
987: ,p_name_combination_warning => l_name_combination_warning
988: );
989: exception
990: when hr_api.cannot_find_prog_unit then
991: hr_api.cannot_find_prog_unit_error
992: (p_module_name => 'create_cwk'
993: ,p_hook_type => 'AP'
994: );

Line 991: hr_api.cannot_find_prog_unit_error

987: ,p_name_combination_warning => l_name_combination_warning
988: );
989: exception
990: when hr_api.cannot_find_prog_unit then
991: hr_api.cannot_find_prog_unit_error
992: (p_module_name => 'create_cwk'
993: ,p_hook_type => 'AP'
994: );
995: end;

Line 1000: raise hr_api.validate_enabled;

996: --
997: -- When in validation only mode raise the Validate_Enabled exception
998: --
999: if p_validate then
1000: raise hr_api.validate_enabled;
1001: end if;
1002: --
1003: -- Set all output arguments
1004: --

Line 1040: when hr_api.validate_enabled then

1036: p_name_combination_warning := l_name_combination_warning;
1037: --
1038: hr_utility.set_location(' Leaving:'||l_proc, 70);
1039: exception
1040: when hr_api.validate_enabled then
1041: --
1042: -- As the Validate_Enabled exception has been raised
1043: -- we must rollback to the savepoint
1044: --

Line 1178: hr_api.mandatory_arg_error

1174:
1175: --
1176: -- Ensure mandatory arguments have been passed
1177: --
1178: hr_api.mandatory_arg_error
1179: (p_api_name => l_proc
1180: ,p_argument => 'person_id'
1181: ,p_argument_value => p_person_id
1182: );

Line 1184: hr_api.mandatory_arg_error

1180: ,p_argument => 'person_id'
1181: ,p_argument_value => p_person_id
1182: );
1183: --
1184: hr_api.mandatory_arg_error
1185: (p_api_name => l_proc
1186: ,p_argument => 'effective_date'
1187: ,p_argument_value => p_effective_date
1188: );

Line 1214: when hr_api.cannot_find_prog_unit then

1210: ,p_person_type_id => p_person_type_id
1211: ,p_datetrack_update_mode => p_datetrack_update_mode
1212: );
1213: exception
1214: when hr_api.cannot_find_prog_unit then
1215: hr_api.cannot_find_prog_unit_error
1216: (p_module_name => 'convert_to_cwk'
1217: ,p_hook_type => 'BP'
1218: );

Line 1215: hr_api.cannot_find_prog_unit_error

1211: ,p_datetrack_update_mode => p_datetrack_update_mode
1212: );
1213: exception
1214: when hr_api.cannot_find_prog_unit then
1215: hr_api.cannot_find_prog_unit_error
1216: (p_module_name => 'convert_to_cwk'
1217: ,p_hook_type => 'BP'
1218: );
1219: end;

Line 1295: AND NVL(p_npw_number,hr_api.g_number) <> l_per_details_rec.npw_number

1291: --
1292: -- Ensure the npw_number will not be changed if it exists
1293: --
1294: IF l_per_details_rec.npw_number IS NOT NULL
1295: AND NVL(p_npw_number,hr_api.g_number) <> l_per_details_rec.npw_number
1296: THEN
1297: hr_utility.set_location(l_proc,60);
1298: p_npw_number := l_per_details_rec.npw_number;
1299: END IF;

Line 1480: when hr_api.cannot_find_prog_unit then

1476: ,p_asg_object_version_number => l_asg_object_version_number
1477: ,p_assignment_sequence => l_assignment_sequence
1478: );
1479: exception
1480: when hr_api.cannot_find_prog_unit then
1481: hr_api.cannot_find_prog_unit_error
1482: (p_module_name => 'convert_to_cwk'
1483: ,p_hook_type => 'AP'
1484: );

Line 1481: hr_api.cannot_find_prog_unit_error

1477: ,p_assignment_sequence => l_assignment_sequence
1478: );
1479: exception
1480: when hr_api.cannot_find_prog_unit then
1481: hr_api.cannot_find_prog_unit_error
1482: (p_module_name => 'convert_to_cwk'
1483: ,p_hook_type => 'AP'
1484: );
1485: end;

Line 1490: raise hr_api.validate_enabled;

1486: --
1487: -- When in validation only mode raise the Validate_Enabled exception
1488: --
1489: if p_validate then
1490: raise hr_api.validate_enabled;
1491: end if;
1492: --
1493: -- Set all output arguments
1494: --

Line 1504: when hr_api.validate_enabled then

1500: p_assignment_sequence := l_assignment_sequence;
1501: --
1502: hr_utility.set_location(' Leaving:'||l_proc, 170);
1503: exception
1504: when hr_api.validate_enabled then
1505: --
1506: -- As the Validate_Enabled exception has been raised
1507: -- we must rollback to the savepoint
1508: --

Line 1630: hr_api.mandatory_arg_error

1626: hr_utility.set_location('Entering:'|| l_proc, 10);
1627: --
1628: -- Ensure mandatory arguments have been passed
1629: --
1630: hr_api.mandatory_arg_error
1631: (p_api_name => l_proc
1632: ,p_argument => 'person_id'
1633: ,p_argument_value => p_person_id
1634: );

Line 1636: hr_api.mandatory_arg_error

1632: ,p_argument => 'person_id'
1633: ,p_argument_value => p_person_id
1634: );
1635: --
1636: hr_api.mandatory_arg_error
1637: (p_api_name => l_proc
1638: ,p_argument => 'effective_date'
1639: ,p_argument_value => p_effective_date
1640: );

Line 1665: when hr_api.cannot_find_prog_unit then

1661: ,p_person_type_id => p_person_type_id
1662: ,p_vacancy_id => p_vacancy_id
1663: );
1664: exception
1665: when hr_api.cannot_find_prog_unit then
1666: hr_api.cannot_find_prog_unit_error
1667: (p_module_name => 'apply_for_job'
1668: ,p_hook_type => 'BP'
1669: );

Line 1666: hr_api.cannot_find_prog_unit_error

1662: ,p_vacancy_id => p_vacancy_id
1663: );
1664: exception
1665: when hr_api.cannot_find_prog_unit then
1666: hr_api.cannot_find_prog_unit_error
1667: (p_module_name => 'apply_for_job'
1668: ,p_hook_type => 'BP'
1669: );
1670: end;

Line 1735: AND NVL(p_applicant_number,hr_api.g_number) <> l_per_details_rec.applicant_number

1731: --
1732: -- Ensure the applicant number will not be changed if it exists
1733: --
1734: IF l_per_details_rec.applicant_number IS NOT NULL
1735: AND NVL(p_applicant_number,hr_api.g_number) <> l_per_details_rec.applicant_number
1736: THEN
1737: hr_utility.set_location(l_proc,50);
1738: p_applicant_number := l_per_details_rec.applicant_number;
1739: END IF;

Line 1757: ,p_datetrack_mode => hr_api.g_update

1753: --
1754: per_per_upd.upd
1755: (p_person_id => p_person_id
1756: ,p_effective_date => l_effective_date
1757: ,p_datetrack_mode => hr_api.g_update
1758: ,p_person_type_id => l_person_type_id1
1759: ,p_applicant_number => p_applicant_number
1760: ,p_employee_number => l_per_details_rec.employee_number
1761: ,p_npw_number => l_per_details_rec.npw_number

Line 1835: when hr_api.cannot_find_prog_unit then

1831: ,p_asg_object_version_number => l_asg_object_version_number
1832: ,p_assignment_sequence => l_assignment_sequence
1833: );
1834: exception
1835: when hr_api.cannot_find_prog_unit then
1836: hr_api.cannot_find_prog_unit_error
1837: (p_module_name => 'apply_for_job'
1838: ,p_hook_type => 'AP'
1839: );

Line 1836: hr_api.cannot_find_prog_unit_error

1832: ,p_assignment_sequence => l_assignment_sequence
1833: );
1834: exception
1835: when hr_api.cannot_find_prog_unit then
1836: hr_api.cannot_find_prog_unit_error
1837: (p_module_name => 'apply_for_job'
1838: ,p_hook_type => 'AP'
1839: );
1840: end;

Line 1845: raise hr_api.validate_enabled;

1841: --
1842: -- When in validation only mode raise the Validate_Enabled exception
1843: --
1844: if p_validate then
1845: raise hr_api.validate_enabled;
1846: end if;
1847: --
1848: -- Set all output arguments
1849: --

Line 1860: when hr_api.validate_enabled then

1856: p_assignment_sequence := l_assignment_sequence;
1857: --
1858: hr_utility.set_location(' Leaving:'||l_proc, 170);
1859: exception
1860: when hr_api.validate_enabled then
1861: --
1862: -- As the Validate_Enabled exception has been raised
1863: -- we must rollback to the savepoint
1864: --

Line 2047: ,p_person_type_id in number default hr_api.g_number

2043: ,p_date_start in date
2044: ,p_object_version_number in out nocopy number
2045: ,p_actual_termination_date in date
2046: ,p_last_standard_process_date in out nocopy date
2047: ,p_person_type_id in number default hr_api.g_number
2048: ,p_assignment_status_type_id in number default hr_api.g_number
2049: ,p_termination_reason in varchar2 default hr_api.g_varchar2
2050: ,p_supervisor_warning out nocopy boolean
2051: ,p_event_warning out nocopy boolean

Line 2048: ,p_assignment_status_type_id in number default hr_api.g_number

2044: ,p_object_version_number in out nocopy number
2045: ,p_actual_termination_date in date
2046: ,p_last_standard_process_date in out nocopy date
2047: ,p_person_type_id in number default hr_api.g_number
2048: ,p_assignment_status_type_id in number default hr_api.g_number
2049: ,p_termination_reason in varchar2 default hr_api.g_varchar2
2050: ,p_supervisor_warning out nocopy boolean
2051: ,p_event_warning out nocopy boolean
2052: ,p_interview_warning out nocopy boolean

Line 2049: ,p_termination_reason in varchar2 default hr_api.g_varchar2

2045: ,p_actual_termination_date in date
2046: ,p_last_standard_process_date in out nocopy date
2047: ,p_person_type_id in number default hr_api.g_number
2048: ,p_assignment_status_type_id in number default hr_api.g_number
2049: ,p_termination_reason in varchar2 default hr_api.g_varchar2
2050: ,p_supervisor_warning out nocopy boolean
2051: ,p_event_warning out nocopy boolean
2052: ,p_interview_warning out nocopy boolean
2053: ,p_review_warning out nocopy boolean

Line 2114: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;

2110: l_date_of_death date;
2111: l_ptu_object_version_number number;
2112: l_person_type_usage_id number;
2113: l_applicant_number per_all_people_f.applicant_number%TYPE;
2114: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
2115: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
2116: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
2117: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
2118: --

Line 2211: hr_api.mandatory_arg_error

2207: -- Validation in addition to Table Handlers
2208: --
2209: -- Check period of placement and get business group details for validation.
2210: --
2211: hr_api.mandatory_arg_error
2212: (p_api_name => l_proc
2213: ,p_argument => 'person_id'
2214: ,p_argument_value => p_person_id
2215: );

Line 2217: hr_api.mandatory_arg_error

2213: ,p_argument => 'person_id'
2214: ,p_argument_value => p_person_id
2215: );
2216: --
2217: hr_api.mandatory_arg_error
2218: (p_api_name => l_proc
2219: ,p_argument => 'date_start'
2220: ,p_argument_value => p_date_start
2221: );

Line 2223: hr_api.mandatory_arg_error

2219: ,p_argument => 'date_start'
2220: ,p_argument_value => p_date_start
2221: );
2222: --
2223: hr_api.mandatory_arg_error
2224: (p_api_name => l_proc
2225: ,p_argument => 'actual_termination_date'
2226: ,p_argument_value => l_actual_termination_date
2227: );

Line 2660: raise hr_api.validate_enabled;

2656: --
2657: -- When in validation only mode raise the Validate_Enabled exception
2658: --
2659: if p_validate then
2660: raise hr_api.validate_enabled;
2661: end if;
2662: --
2663: -- Set all output arguments
2664: --

Line 2675: when hr_api.validate_enabled then

2671: --
2672: --
2673: hr_utility.set_location(' Leaving:'||l_proc, 340);
2674: exception
2675: when hr_api.validate_enabled then
2676: --
2677: -- As the Validate_Enabled exception has been raised
2678: -- we must rollback to the savepoint
2679: --

Line 2801: hr_api.mandatory_arg_error

2797: -- Validation in addition to Table Handlers
2798: --
2799: -- Check person id.
2800: --
2801: hr_api.mandatory_arg_error
2802: (p_api_name => l_proc
2803: ,p_argument => 'person_id'
2804: ,p_argument_value => p_person_id
2805: );

Line 2809: hr_api.mandatory_arg_error

2805: );
2806: --
2807: -- Check date start.
2808: --
2809: hr_api.mandatory_arg_error
2810: (p_api_name => l_proc
2811: ,p_argument => 'date_start'
2812: ,p_argument_value => p_date_start
2813: );

Line 2817: hr_api.mandatory_arg_error

2813: );
2814: --
2815: -- Check object version number.
2816: --
2817: hr_api.mandatory_arg_error
2818: (p_api_name => l_proc
2819: ,p_argument => 'object_version_number'
2820: ,p_argument_value => p_object_version_number
2821: );

Line 3040: raise hr_api.validate_enabled;

3036: --
3037: -- When in validation only mode raise the Validate_Enabled exception
3038: --
3039: if p_validate then
3040: raise hr_api.validate_enabled;
3041: end if;
3042: --
3043: -- Set all output arguments
3044: --

Line 3053: when hr_api.validate_enabled then

3049: p_org_now_no_manager_warning := l_org_now_no_manager_warning;
3050: --
3051: hr_utility.set_location(' Leaving:'||l_proc, 400);
3052: exception
3053: when hr_api.validate_enabled then
3054: --
3055: -- As the Validate_Enabled exception has been raised
3056: -- we must rollback to the savepoint
3057: --

Line 3096: ,p_person_type_id in number default hr_api.g_number

3092: ,p_effective_date in date
3093: ,p_person_id in number
3094: ,p_date_start in date
3095: ,p_object_version_number in out nocopy number
3096: ,p_person_type_id in number default hr_api.g_number
3097: ,p_assignment_status_type_id in number default hr_api.g_number
3098: ,p_actual_termination_date in date default hr_api.g_date
3099:
3100: /*

Line 3097: ,p_assignment_status_type_id in number default hr_api.g_number

3093: ,p_person_id in number
3094: ,p_date_start in date
3095: ,p_object_version_number in out nocopy number
3096: ,p_person_type_id in number default hr_api.g_number
3097: ,p_assignment_status_type_id in number default hr_api.g_number
3098: ,p_actual_termination_date in date default hr_api.g_date
3099:
3100: /*
3101: The following two parameters are available for internal-use only until

Line 3098: ,p_actual_termination_date in date default hr_api.g_date

3094: ,p_date_start in date
3095: ,p_object_version_number in out nocopy number
3096: ,p_person_type_id in number default hr_api.g_number
3097: ,p_assignment_status_type_id in number default hr_api.g_number
3098: ,p_actual_termination_date in date default hr_api.g_date
3099:
3100: /*
3101: The following two parameters are available for internal-use only until
3102: payroll support for contingent workers is introduced. Setting them has

Line 3108: ,p_termination_reason in varchar2 default hr_api.g_varchar2

3104: */
3105: ,p_final_process_date in out nocopy date
3106: ,p_last_standard_process_date in out nocopy date
3107:
3108: ,p_termination_reason in varchar2 default hr_api.g_varchar2
3109: ,p_projected_termination_date in date default hr_api.g_date
3110: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3111: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 3109: ,p_projected_termination_date in date default hr_api.g_date

3105: ,p_final_process_date in out nocopy date
3106: ,p_last_standard_process_date in out nocopy date
3107:
3108: ,p_termination_reason in varchar2 default hr_api.g_varchar2
3109: ,p_projected_termination_date in date default hr_api.g_date
3110: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3111: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 3110: ,p_attribute_category in varchar2 default hr_api.g_varchar2

3106: ,p_last_standard_process_date in out nocopy date
3107:
3108: ,p_termination_reason in varchar2 default hr_api.g_varchar2
3109: ,p_projected_termination_date in date default hr_api.g_date
3110: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3111: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 3111: ,p_attribute1 in varchar2 default hr_api.g_varchar2

3107:
3108: ,p_termination_reason in varchar2 default hr_api.g_varchar2
3109: ,p_projected_termination_date in date default hr_api.g_date
3110: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3111: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2

3108: ,p_termination_reason in varchar2 default hr_api.g_varchar2
3109: ,p_projected_termination_date in date default hr_api.g_date
3110: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3111: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2

3109: ,p_projected_termination_date in date default hr_api.g_date
3110: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3111: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2

3110: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3111: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2

3111: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2

3112: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2

3113: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2

3114: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2

3115: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2

3116: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2

3117: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2

3118: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2

3119: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2

3120: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2

3121: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2

3122: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2

3123: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2

3124: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2

3125: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2

3126: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2

3127: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2

3128: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2

3129: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2

3130: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2

3131: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2

3132: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2

3133: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3141: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2

3134: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3141: ,p_information_category in varchar2 default hr_api.g_varchar2
3142: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2

3135: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3141: ,p_information_category in varchar2 default hr_api.g_varchar2
3142: ,p_information1 in varchar2 default hr_api.g_varchar2
3143: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2

3136: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3141: ,p_information_category in varchar2 default hr_api.g_varchar2
3142: ,p_information1 in varchar2 default hr_api.g_varchar2
3143: ,p_information2 in varchar2 default hr_api.g_varchar2
3144: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 3141: ,p_information_category in varchar2 default hr_api.g_varchar2

3137: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3141: ,p_information_category in varchar2 default hr_api.g_varchar2
3142: ,p_information1 in varchar2 default hr_api.g_varchar2
3143: ,p_information2 in varchar2 default hr_api.g_varchar2
3144: ,p_information3 in varchar2 default hr_api.g_varchar2
3145: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 3142: ,p_information1 in varchar2 default hr_api.g_varchar2

3138: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3141: ,p_information_category in varchar2 default hr_api.g_varchar2
3142: ,p_information1 in varchar2 default hr_api.g_varchar2
3143: ,p_information2 in varchar2 default hr_api.g_varchar2
3144: ,p_information3 in varchar2 default hr_api.g_varchar2
3145: ,p_information4 in varchar2 default hr_api.g_varchar2
3146: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 3143: ,p_information2 in varchar2 default hr_api.g_varchar2

3139: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3141: ,p_information_category in varchar2 default hr_api.g_varchar2
3142: ,p_information1 in varchar2 default hr_api.g_varchar2
3143: ,p_information2 in varchar2 default hr_api.g_varchar2
3144: ,p_information3 in varchar2 default hr_api.g_varchar2
3145: ,p_information4 in varchar2 default hr_api.g_varchar2
3146: ,p_information5 in varchar2 default hr_api.g_varchar2
3147: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 3144: ,p_information3 in varchar2 default hr_api.g_varchar2

3140: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3141: ,p_information_category in varchar2 default hr_api.g_varchar2
3142: ,p_information1 in varchar2 default hr_api.g_varchar2
3143: ,p_information2 in varchar2 default hr_api.g_varchar2
3144: ,p_information3 in varchar2 default hr_api.g_varchar2
3145: ,p_information4 in varchar2 default hr_api.g_varchar2
3146: ,p_information5 in varchar2 default hr_api.g_varchar2
3147: ,p_information6 in varchar2 default hr_api.g_varchar2
3148: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 3145: ,p_information4 in varchar2 default hr_api.g_varchar2

3141: ,p_information_category in varchar2 default hr_api.g_varchar2
3142: ,p_information1 in varchar2 default hr_api.g_varchar2
3143: ,p_information2 in varchar2 default hr_api.g_varchar2
3144: ,p_information3 in varchar2 default hr_api.g_varchar2
3145: ,p_information4 in varchar2 default hr_api.g_varchar2
3146: ,p_information5 in varchar2 default hr_api.g_varchar2
3147: ,p_information6 in varchar2 default hr_api.g_varchar2
3148: ,p_information7 in varchar2 default hr_api.g_varchar2
3149: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 3146: ,p_information5 in varchar2 default hr_api.g_varchar2

3142: ,p_information1 in varchar2 default hr_api.g_varchar2
3143: ,p_information2 in varchar2 default hr_api.g_varchar2
3144: ,p_information3 in varchar2 default hr_api.g_varchar2
3145: ,p_information4 in varchar2 default hr_api.g_varchar2
3146: ,p_information5 in varchar2 default hr_api.g_varchar2
3147: ,p_information6 in varchar2 default hr_api.g_varchar2
3148: ,p_information7 in varchar2 default hr_api.g_varchar2
3149: ,p_information8 in varchar2 default hr_api.g_varchar2
3150: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 3147: ,p_information6 in varchar2 default hr_api.g_varchar2

3143: ,p_information2 in varchar2 default hr_api.g_varchar2
3144: ,p_information3 in varchar2 default hr_api.g_varchar2
3145: ,p_information4 in varchar2 default hr_api.g_varchar2
3146: ,p_information5 in varchar2 default hr_api.g_varchar2
3147: ,p_information6 in varchar2 default hr_api.g_varchar2
3148: ,p_information7 in varchar2 default hr_api.g_varchar2
3149: ,p_information8 in varchar2 default hr_api.g_varchar2
3150: ,p_information9 in varchar2 default hr_api.g_varchar2
3151: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 3148: ,p_information7 in varchar2 default hr_api.g_varchar2

3144: ,p_information3 in varchar2 default hr_api.g_varchar2
3145: ,p_information4 in varchar2 default hr_api.g_varchar2
3146: ,p_information5 in varchar2 default hr_api.g_varchar2
3147: ,p_information6 in varchar2 default hr_api.g_varchar2
3148: ,p_information7 in varchar2 default hr_api.g_varchar2
3149: ,p_information8 in varchar2 default hr_api.g_varchar2
3150: ,p_information9 in varchar2 default hr_api.g_varchar2
3151: ,p_information10 in varchar2 default hr_api.g_varchar2
3152: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 3149: ,p_information8 in varchar2 default hr_api.g_varchar2

3145: ,p_information4 in varchar2 default hr_api.g_varchar2
3146: ,p_information5 in varchar2 default hr_api.g_varchar2
3147: ,p_information6 in varchar2 default hr_api.g_varchar2
3148: ,p_information7 in varchar2 default hr_api.g_varchar2
3149: ,p_information8 in varchar2 default hr_api.g_varchar2
3150: ,p_information9 in varchar2 default hr_api.g_varchar2
3151: ,p_information10 in varchar2 default hr_api.g_varchar2
3152: ,p_information11 in varchar2 default hr_api.g_varchar2
3153: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 3150: ,p_information9 in varchar2 default hr_api.g_varchar2

3146: ,p_information5 in varchar2 default hr_api.g_varchar2
3147: ,p_information6 in varchar2 default hr_api.g_varchar2
3148: ,p_information7 in varchar2 default hr_api.g_varchar2
3149: ,p_information8 in varchar2 default hr_api.g_varchar2
3150: ,p_information9 in varchar2 default hr_api.g_varchar2
3151: ,p_information10 in varchar2 default hr_api.g_varchar2
3152: ,p_information11 in varchar2 default hr_api.g_varchar2
3153: ,p_information12 in varchar2 default hr_api.g_varchar2
3154: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 3151: ,p_information10 in varchar2 default hr_api.g_varchar2

3147: ,p_information6 in varchar2 default hr_api.g_varchar2
3148: ,p_information7 in varchar2 default hr_api.g_varchar2
3149: ,p_information8 in varchar2 default hr_api.g_varchar2
3150: ,p_information9 in varchar2 default hr_api.g_varchar2
3151: ,p_information10 in varchar2 default hr_api.g_varchar2
3152: ,p_information11 in varchar2 default hr_api.g_varchar2
3153: ,p_information12 in varchar2 default hr_api.g_varchar2
3154: ,p_information13 in varchar2 default hr_api.g_varchar2
3155: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 3152: ,p_information11 in varchar2 default hr_api.g_varchar2

3148: ,p_information7 in varchar2 default hr_api.g_varchar2
3149: ,p_information8 in varchar2 default hr_api.g_varchar2
3150: ,p_information9 in varchar2 default hr_api.g_varchar2
3151: ,p_information10 in varchar2 default hr_api.g_varchar2
3152: ,p_information11 in varchar2 default hr_api.g_varchar2
3153: ,p_information12 in varchar2 default hr_api.g_varchar2
3154: ,p_information13 in varchar2 default hr_api.g_varchar2
3155: ,p_information14 in varchar2 default hr_api.g_varchar2
3156: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 3153: ,p_information12 in varchar2 default hr_api.g_varchar2

3149: ,p_information8 in varchar2 default hr_api.g_varchar2
3150: ,p_information9 in varchar2 default hr_api.g_varchar2
3151: ,p_information10 in varchar2 default hr_api.g_varchar2
3152: ,p_information11 in varchar2 default hr_api.g_varchar2
3153: ,p_information12 in varchar2 default hr_api.g_varchar2
3154: ,p_information13 in varchar2 default hr_api.g_varchar2
3155: ,p_information14 in varchar2 default hr_api.g_varchar2
3156: ,p_information15 in varchar2 default hr_api.g_varchar2
3157: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 3154: ,p_information13 in varchar2 default hr_api.g_varchar2

3150: ,p_information9 in varchar2 default hr_api.g_varchar2
3151: ,p_information10 in varchar2 default hr_api.g_varchar2
3152: ,p_information11 in varchar2 default hr_api.g_varchar2
3153: ,p_information12 in varchar2 default hr_api.g_varchar2
3154: ,p_information13 in varchar2 default hr_api.g_varchar2
3155: ,p_information14 in varchar2 default hr_api.g_varchar2
3156: ,p_information15 in varchar2 default hr_api.g_varchar2
3157: ,p_information16 in varchar2 default hr_api.g_varchar2
3158: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 3155: ,p_information14 in varchar2 default hr_api.g_varchar2

3151: ,p_information10 in varchar2 default hr_api.g_varchar2
3152: ,p_information11 in varchar2 default hr_api.g_varchar2
3153: ,p_information12 in varchar2 default hr_api.g_varchar2
3154: ,p_information13 in varchar2 default hr_api.g_varchar2
3155: ,p_information14 in varchar2 default hr_api.g_varchar2
3156: ,p_information15 in varchar2 default hr_api.g_varchar2
3157: ,p_information16 in varchar2 default hr_api.g_varchar2
3158: ,p_information17 in varchar2 default hr_api.g_varchar2
3159: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 3156: ,p_information15 in varchar2 default hr_api.g_varchar2

3152: ,p_information11 in varchar2 default hr_api.g_varchar2
3153: ,p_information12 in varchar2 default hr_api.g_varchar2
3154: ,p_information13 in varchar2 default hr_api.g_varchar2
3155: ,p_information14 in varchar2 default hr_api.g_varchar2
3156: ,p_information15 in varchar2 default hr_api.g_varchar2
3157: ,p_information16 in varchar2 default hr_api.g_varchar2
3158: ,p_information17 in varchar2 default hr_api.g_varchar2
3159: ,p_information18 in varchar2 default hr_api.g_varchar2
3160: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 3157: ,p_information16 in varchar2 default hr_api.g_varchar2

3153: ,p_information12 in varchar2 default hr_api.g_varchar2
3154: ,p_information13 in varchar2 default hr_api.g_varchar2
3155: ,p_information14 in varchar2 default hr_api.g_varchar2
3156: ,p_information15 in varchar2 default hr_api.g_varchar2
3157: ,p_information16 in varchar2 default hr_api.g_varchar2
3158: ,p_information17 in varchar2 default hr_api.g_varchar2
3159: ,p_information18 in varchar2 default hr_api.g_varchar2
3160: ,p_information19 in varchar2 default hr_api.g_varchar2
3161: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 3158: ,p_information17 in varchar2 default hr_api.g_varchar2

3154: ,p_information13 in varchar2 default hr_api.g_varchar2
3155: ,p_information14 in varchar2 default hr_api.g_varchar2
3156: ,p_information15 in varchar2 default hr_api.g_varchar2
3157: ,p_information16 in varchar2 default hr_api.g_varchar2
3158: ,p_information17 in varchar2 default hr_api.g_varchar2
3159: ,p_information18 in varchar2 default hr_api.g_varchar2
3160: ,p_information19 in varchar2 default hr_api.g_varchar2
3161: ,p_information20 in varchar2 default hr_api.g_varchar2
3162: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 3159: ,p_information18 in varchar2 default hr_api.g_varchar2

3155: ,p_information14 in varchar2 default hr_api.g_varchar2
3156: ,p_information15 in varchar2 default hr_api.g_varchar2
3157: ,p_information16 in varchar2 default hr_api.g_varchar2
3158: ,p_information17 in varchar2 default hr_api.g_varchar2
3159: ,p_information18 in varchar2 default hr_api.g_varchar2
3160: ,p_information19 in varchar2 default hr_api.g_varchar2
3161: ,p_information20 in varchar2 default hr_api.g_varchar2
3162: ,p_information21 in varchar2 default hr_api.g_varchar2
3163: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 3160: ,p_information19 in varchar2 default hr_api.g_varchar2

3156: ,p_information15 in varchar2 default hr_api.g_varchar2
3157: ,p_information16 in varchar2 default hr_api.g_varchar2
3158: ,p_information17 in varchar2 default hr_api.g_varchar2
3159: ,p_information18 in varchar2 default hr_api.g_varchar2
3160: ,p_information19 in varchar2 default hr_api.g_varchar2
3161: ,p_information20 in varchar2 default hr_api.g_varchar2
3162: ,p_information21 in varchar2 default hr_api.g_varchar2
3163: ,p_information22 in varchar2 default hr_api.g_varchar2
3164: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 3161: ,p_information20 in varchar2 default hr_api.g_varchar2

3157: ,p_information16 in varchar2 default hr_api.g_varchar2
3158: ,p_information17 in varchar2 default hr_api.g_varchar2
3159: ,p_information18 in varchar2 default hr_api.g_varchar2
3160: ,p_information19 in varchar2 default hr_api.g_varchar2
3161: ,p_information20 in varchar2 default hr_api.g_varchar2
3162: ,p_information21 in varchar2 default hr_api.g_varchar2
3163: ,p_information22 in varchar2 default hr_api.g_varchar2
3164: ,p_information23 in varchar2 default hr_api.g_varchar2
3165: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 3162: ,p_information21 in varchar2 default hr_api.g_varchar2

3158: ,p_information17 in varchar2 default hr_api.g_varchar2
3159: ,p_information18 in varchar2 default hr_api.g_varchar2
3160: ,p_information19 in varchar2 default hr_api.g_varchar2
3161: ,p_information20 in varchar2 default hr_api.g_varchar2
3162: ,p_information21 in varchar2 default hr_api.g_varchar2
3163: ,p_information22 in varchar2 default hr_api.g_varchar2
3164: ,p_information23 in varchar2 default hr_api.g_varchar2
3165: ,p_information24 in varchar2 default hr_api.g_varchar2
3166: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 3163: ,p_information22 in varchar2 default hr_api.g_varchar2

3159: ,p_information18 in varchar2 default hr_api.g_varchar2
3160: ,p_information19 in varchar2 default hr_api.g_varchar2
3161: ,p_information20 in varchar2 default hr_api.g_varchar2
3162: ,p_information21 in varchar2 default hr_api.g_varchar2
3163: ,p_information22 in varchar2 default hr_api.g_varchar2
3164: ,p_information23 in varchar2 default hr_api.g_varchar2
3165: ,p_information24 in varchar2 default hr_api.g_varchar2
3166: ,p_information25 in varchar2 default hr_api.g_varchar2
3167: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 3164: ,p_information23 in varchar2 default hr_api.g_varchar2

3160: ,p_information19 in varchar2 default hr_api.g_varchar2
3161: ,p_information20 in varchar2 default hr_api.g_varchar2
3162: ,p_information21 in varchar2 default hr_api.g_varchar2
3163: ,p_information22 in varchar2 default hr_api.g_varchar2
3164: ,p_information23 in varchar2 default hr_api.g_varchar2
3165: ,p_information24 in varchar2 default hr_api.g_varchar2
3166: ,p_information25 in varchar2 default hr_api.g_varchar2
3167: ,p_information26 in varchar2 default hr_api.g_varchar2
3168: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 3165: ,p_information24 in varchar2 default hr_api.g_varchar2

3161: ,p_information20 in varchar2 default hr_api.g_varchar2
3162: ,p_information21 in varchar2 default hr_api.g_varchar2
3163: ,p_information22 in varchar2 default hr_api.g_varchar2
3164: ,p_information23 in varchar2 default hr_api.g_varchar2
3165: ,p_information24 in varchar2 default hr_api.g_varchar2
3166: ,p_information25 in varchar2 default hr_api.g_varchar2
3167: ,p_information26 in varchar2 default hr_api.g_varchar2
3168: ,p_information27 in varchar2 default hr_api.g_varchar2
3169: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 3166: ,p_information25 in varchar2 default hr_api.g_varchar2

3162: ,p_information21 in varchar2 default hr_api.g_varchar2
3163: ,p_information22 in varchar2 default hr_api.g_varchar2
3164: ,p_information23 in varchar2 default hr_api.g_varchar2
3165: ,p_information24 in varchar2 default hr_api.g_varchar2
3166: ,p_information25 in varchar2 default hr_api.g_varchar2
3167: ,p_information26 in varchar2 default hr_api.g_varchar2
3168: ,p_information27 in varchar2 default hr_api.g_varchar2
3169: ,p_information28 in varchar2 default hr_api.g_varchar2
3170: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 3167: ,p_information26 in varchar2 default hr_api.g_varchar2

3163: ,p_information22 in varchar2 default hr_api.g_varchar2
3164: ,p_information23 in varchar2 default hr_api.g_varchar2
3165: ,p_information24 in varchar2 default hr_api.g_varchar2
3166: ,p_information25 in varchar2 default hr_api.g_varchar2
3167: ,p_information26 in varchar2 default hr_api.g_varchar2
3168: ,p_information27 in varchar2 default hr_api.g_varchar2
3169: ,p_information28 in varchar2 default hr_api.g_varchar2
3170: ,p_information29 in varchar2 default hr_api.g_varchar2
3171: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 3168: ,p_information27 in varchar2 default hr_api.g_varchar2

3164: ,p_information23 in varchar2 default hr_api.g_varchar2
3165: ,p_information24 in varchar2 default hr_api.g_varchar2
3166: ,p_information25 in varchar2 default hr_api.g_varchar2
3167: ,p_information26 in varchar2 default hr_api.g_varchar2
3168: ,p_information27 in varchar2 default hr_api.g_varchar2
3169: ,p_information28 in varchar2 default hr_api.g_varchar2
3170: ,p_information29 in varchar2 default hr_api.g_varchar2
3171: ,p_information30 in varchar2 default hr_api.g_varchar2
3172: ,p_supervisor_warning out nocopy boolean

Line 3169: ,p_information28 in varchar2 default hr_api.g_varchar2

3165: ,p_information24 in varchar2 default hr_api.g_varchar2
3166: ,p_information25 in varchar2 default hr_api.g_varchar2
3167: ,p_information26 in varchar2 default hr_api.g_varchar2
3168: ,p_information27 in varchar2 default hr_api.g_varchar2
3169: ,p_information28 in varchar2 default hr_api.g_varchar2
3170: ,p_information29 in varchar2 default hr_api.g_varchar2
3171: ,p_information30 in varchar2 default hr_api.g_varchar2
3172: ,p_supervisor_warning out nocopy boolean
3173: ,p_event_warning out nocopy boolean

Line 3170: ,p_information29 in varchar2 default hr_api.g_varchar2

3166: ,p_information25 in varchar2 default hr_api.g_varchar2
3167: ,p_information26 in varchar2 default hr_api.g_varchar2
3168: ,p_information27 in varchar2 default hr_api.g_varchar2
3169: ,p_information28 in varchar2 default hr_api.g_varchar2
3170: ,p_information29 in varchar2 default hr_api.g_varchar2
3171: ,p_information30 in varchar2 default hr_api.g_varchar2
3172: ,p_supervisor_warning out nocopy boolean
3173: ,p_event_warning out nocopy boolean
3174: ,p_interview_warning out nocopy boolean

Line 3171: ,p_information30 in varchar2 default hr_api.g_varchar2

3167: ,p_information26 in varchar2 default hr_api.g_varchar2
3168: ,p_information27 in varchar2 default hr_api.g_varchar2
3169: ,p_information28 in varchar2 default hr_api.g_varchar2
3170: ,p_information29 in varchar2 default hr_api.g_varchar2
3171: ,p_information30 in varchar2 default hr_api.g_varchar2
3172: ,p_supervisor_warning out nocopy boolean
3173: ,p_event_warning out nocopy boolean
3174: ,p_interview_warning out nocopy boolean
3175: ,p_review_warning out nocopy boolean

Line 3208: and nvl(end_date, hr_api.g_eot);

3204: from per_roles
3205: where person_id = p_person_id
3206: and p_actual_termination_date
3207: between start_date
3208: and nvl(end_date, hr_api.g_eot);
3209:
3210: cursor csr_chk_addl_rights is
3211: select role_id
3212: from per_roles

Line 3215: and nvl(end_of_rights_date, hr_api.g_eot) > p_actual_termination_date;

3211: select role_id
3212: from per_roles
3213: where person_id = p_person_id
3214: and EMP_RIGHTS_FLAG = 'Y'
3215: and nvl(end_of_rights_date, hr_api.g_eot) > p_actual_termination_date;
3216: -- end fix 1370960
3217:
3218: begin
3219:

Line 3320: when hr_api.cannot_find_prog_unit then

3316: ,p_information29 => p_information29
3317: ,p_information30 => p_information30
3318: );
3319: exception
3320: when hr_api.cannot_find_prog_unit then
3321: hr_api.cannot_find_prog_unit_error
3322: (p_module_name => 'TERMINATE_PLACEMENT',
3323: p_hook_type => 'BP'
3324: );

Line 3321: hr_api.cannot_find_prog_unit_error

3317: ,p_information30 => p_information30
3318: );
3319: exception
3320: when hr_api.cannot_find_prog_unit then
3321: hr_api.cannot_find_prog_unit_error
3322: (p_module_name => 'TERMINATE_PLACEMENT',
3323: p_hook_type => 'BP'
3324: );
3325: end;

Line 3611: when hr_api.cannot_find_prog_unit then

3607: ,p_org_now_no_manager_warning => p_org_now_no_manager_warning
3608: ,p_addl_rights_warning => p_addl_rights_warning -- Fix 1370960
3609: );
3610: exception
3611: when hr_api.cannot_find_prog_unit then
3612: hr_api.cannot_find_prog_unit_error
3613: (p_module_name => 'TERMINATE_PLACEMENT',
3614: p_hook_type => 'AP'
3615: );

Line 3612: hr_api.cannot_find_prog_unit_error

3608: ,p_addl_rights_warning => p_addl_rights_warning -- Fix 1370960
3609: );
3610: exception
3611: when hr_api.cannot_find_prog_unit then
3612: hr_api.cannot_find_prog_unit_error
3613: (p_module_name => 'TERMINATE_PLACEMENT',
3614: p_hook_type => 'AP'
3615: );
3616: end;

Line 3622: RAISE hr_api.validate_enabled;

3618: --
3619: -- When in validation only mode raise the Validate_Enabled exception
3620: --
3621: IF p_validate THEN
3622: RAISE hr_api.validate_enabled;
3623: END IF;
3624:
3625: hr_utility.set_location('Leaving: '||l_proc, 90);
3626:

Line 3628: when hr_api.validate_enabled then

3624:
3625: hr_utility.set_location('Leaving: '||l_proc, 90);
3626:
3627: EXCEPTION
3628: when hr_api.validate_enabled then
3629: --
3630: -- As the Validate_Enabled exception has been raised
3631: -- we must rollback to the savepoint
3632: --

Line 3755: hr_api.mandatory_arg_error

3751: -- Issue a savepoint.
3752: --
3753: savepoint reverse_terminate_placement;
3754:
3755: hr_api.mandatory_arg_error
3756: (p_api_name => l_proc
3757: ,p_argument => 'person_id'
3758: ,p_argument_value => p_person_id
3759: );

Line 3761: hr_api.mandatory_arg_error

3757: ,p_argument => 'person_id'
3758: ,p_argument_value => p_person_id
3759: );
3760: --
3761: hr_api.mandatory_arg_error
3762: (p_api_name => l_proc
3763: ,p_argument => 'actual_termination_date'
3764: ,p_argument_value => p_actual_termination_date
3765: );

Line 3778: when hr_api.cannot_find_prog_unit then

3774: ,p_actual_termination_date => p_actual_termination_date
3775: ,p_clear_details => p_clear_details
3776: );
3777: exception
3778: when hr_api.cannot_find_prog_unit then
3779: hr_api.cannot_find_prog_unit_error
3780: (p_module_name => 'REVERSE_TERMINATE_PLACEMENT',
3781: p_hook_type => 'BP'
3782: );

Line 3779: hr_api.cannot_find_prog_unit_error

3775: ,p_clear_details => p_clear_details
3776: );
3777: exception
3778: when hr_api.cannot_find_prog_unit then
3779: hr_api.cannot_find_prog_unit_error
3780: (p_module_name => 'REVERSE_TERMINATE_PLACEMENT',
3781: p_hook_type => 'BP'
3782: );
3783: end;

Line 3932: SET pp.effective_end_date = hr_api.g_eot

3928: else
3929:
3930:
3931: UPDATE per_people_f pp
3932: SET pp.effective_end_date = hr_api.g_eot
3933: WHERE pp.person_id = p_person_id
3934: AND p_actual_termination_date
3935: BETWEEN pp.effective_start_date
3936: AND pp.effective_end_date;

Line 4107: l_effective_end_date := hr_api.g_eot;

4103: if l_max_end_date <> l_final_process_date then
4104: l_effective_end_date := l_max_end_date;
4105: else
4106: hr_utility.set_location(l_proc,95);
4107: l_effective_end_date := hr_api.g_eot;
4108: end if;
4109: else
4110: hr_utility.set_location(l_proc,100);
4111: l_effective_end_date := l_max_end_date;

Line 4147: l_effective_end_date := hr_api.g_eot;

4143: if l_max_end_date <> l_final_process_date then
4144: null;
4145: else
4146: hr_utility.set_location(l_proc,115);
4147: l_effective_end_date := hr_api.g_eot;
4148: --
4149: hr_utility.set_location(l_proc,120);
4150: UPDATE per_secondary_ass_statuses sas
4151: SET sas.end_date = null

Line 4282: when hr_api.cannot_find_prog_unit then

4278: ,p_clear_details => p_clear_details
4279: ,p_fut_actns_exist_warning => p_fut_actns_exist_warning
4280: );
4281: exception
4282: when hr_api.cannot_find_prog_unit then
4283: hr_api.cannot_find_prog_unit_error
4284: (p_module_name => 'REVERSE_TERMINATE_PLACEMENT',
4285: p_hook_type => 'AP'
4286: );

Line 4283: hr_api.cannot_find_prog_unit_error

4279: ,p_fut_actns_exist_warning => p_fut_actns_exist_warning
4280: );
4281: exception
4282: when hr_api.cannot_find_prog_unit then
4283: hr_api.cannot_find_prog_unit_error
4284: (p_module_name => 'REVERSE_TERMINATE_PLACEMENT',
4285: p_hook_type => 'AP'
4286: );
4287: end;

Line 4307: when hr_api.validate_enabled then

4303:
4304: hr_utility.set_location('Leaving: '||l_proc, 200);
4305:
4306: exception
4307: when hr_api.validate_enabled then
4308: --
4309: -- As the Validate_Enabled exception has been raised
4310: -- we must rollback to the savepoint
4311: --