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 323: when hr_api.cannot_find_prog_unit then

319: ,p_per_information29 => p_per_information29
320: ,p_per_information30 => p_per_information30
321: );
322: exception
323: when hr_api.cannot_find_prog_unit then
324: hr_api.cannot_find_prog_unit_error
325: (p_module_name => 'create_cwk'
326: ,p_hook_type => 'BP'
327: );

Line 324: hr_api.cannot_find_prog_unit_error

320: ,p_per_information30 => p_per_information30
321: );
322: exception
323: when hr_api.cannot_find_prog_unit then
324: hr_api.cannot_find_prog_unit_error
325: (p_module_name => 'create_cwk'
326: ,p_hook_type => 'BP'
327: );
328: end;

Line 703: when hr_api.cannot_find_prog_unit then

699: ,p_assignment_number => l_assignment_number
700: ,p_name_combination_warning => l_name_combination_warning
701: );
702: exception
703: when hr_api.cannot_find_prog_unit then
704: hr_api.cannot_find_prog_unit_error
705: (p_module_name => 'create_cwk'
706: ,p_hook_type => 'AP'
707: );

Line 704: hr_api.cannot_find_prog_unit_error

700: ,p_name_combination_warning => l_name_combination_warning
701: );
702: exception
703: when hr_api.cannot_find_prog_unit then
704: hr_api.cannot_find_prog_unit_error
705: (p_module_name => 'create_cwk'
706: ,p_hook_type => 'AP'
707: );
708: end;

Line 713: raise hr_api.validate_enabled;

709: --
710: -- When in validation only mode raise the Validate_Enabled exception
711: --
712: if p_validate then
713: raise hr_api.validate_enabled;
714: end if;
715: --
716: -- Set all output arguments
717: --

Line 753: when hr_api.validate_enabled then

749: p_name_combination_warning := l_name_combination_warning;
750: --
751: hr_utility.set_location(' Leaving:'||l_proc, 70);
752: exception
753: when hr_api.validate_enabled then
754: --
755: -- As the Validate_Enabled exception has been raised
756: -- we must rollback to the savepoint
757: --

Line 875: hr_api.mandatory_arg_error

871:
872: --
873: -- Ensure mandatory arguments have been passed
874: --
875: hr_api.mandatory_arg_error
876: (p_api_name => l_proc
877: ,p_argument => 'person_id'
878: ,p_argument_value => p_person_id
879: );

Line 881: hr_api.mandatory_arg_error

877: ,p_argument => 'person_id'
878: ,p_argument_value => p_person_id
879: );
880: --
881: hr_api.mandatory_arg_error
882: (p_api_name => l_proc
883: ,p_argument => 'effective_date'
884: ,p_argument_value => p_effective_date
885: );

Line 911: when hr_api.cannot_find_prog_unit then

907: ,p_person_type_id => p_person_type_id
908: ,p_datetrack_update_mode => p_datetrack_update_mode
909: );
910: exception
911: when hr_api.cannot_find_prog_unit then
912: hr_api.cannot_find_prog_unit_error
913: (p_module_name => 'convert_to_cwk'
914: ,p_hook_type => 'BP'
915: );

Line 912: hr_api.cannot_find_prog_unit_error

908: ,p_datetrack_update_mode => p_datetrack_update_mode
909: );
910: exception
911: when hr_api.cannot_find_prog_unit then
912: hr_api.cannot_find_prog_unit_error
913: (p_module_name => 'convert_to_cwk'
914: ,p_hook_type => 'BP'
915: );
916: end;

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

976: --
977: -- Ensure the npw_number will not be changed if it exists
978: --
979: IF l_per_details_rec.npw_number IS NOT NULL
980: AND NVL(p_npw_number,hr_api.g_number) <> l_per_details_rec.npw_number
981: THEN
982: hr_utility.set_location(l_proc,60);
983: p_npw_number := l_per_details_rec.npw_number;
984: END IF;

Line 1114: when hr_api.cannot_find_prog_unit then

1110: ,p_asg_object_version_number => l_asg_object_version_number
1111: ,p_assignment_sequence => l_assignment_sequence
1112: );
1113: exception
1114: when hr_api.cannot_find_prog_unit then
1115: hr_api.cannot_find_prog_unit_error
1116: (p_module_name => 'convert_to_cwk'
1117: ,p_hook_type => 'AP'
1118: );

Line 1115: hr_api.cannot_find_prog_unit_error

1111: ,p_assignment_sequence => l_assignment_sequence
1112: );
1113: exception
1114: when hr_api.cannot_find_prog_unit then
1115: hr_api.cannot_find_prog_unit_error
1116: (p_module_name => 'convert_to_cwk'
1117: ,p_hook_type => 'AP'
1118: );
1119: end;

Line 1124: raise hr_api.validate_enabled;

1120: --
1121: -- When in validation only mode raise the Validate_Enabled exception
1122: --
1123: if p_validate then
1124: raise hr_api.validate_enabled;
1125: end if;
1126: --
1127: -- Set all output arguments
1128: --

Line 1138: when hr_api.validate_enabled then

1134: p_assignment_sequence := l_assignment_sequence;
1135: --
1136: hr_utility.set_location(' Leaving:'||l_proc, 170);
1137: exception
1138: when hr_api.validate_enabled then
1139: --
1140: -- As the Validate_Enabled exception has been raised
1141: -- we must rollback to the savepoint
1142: --

Line 1264: hr_api.mandatory_arg_error

1260: hr_utility.set_location('Entering:'|| l_proc, 10);
1261: --
1262: -- Ensure mandatory arguments have been passed
1263: --
1264: hr_api.mandatory_arg_error
1265: (p_api_name => l_proc
1266: ,p_argument => 'person_id'
1267: ,p_argument_value => p_person_id
1268: );

Line 1270: hr_api.mandatory_arg_error

1266: ,p_argument => 'person_id'
1267: ,p_argument_value => p_person_id
1268: );
1269: --
1270: hr_api.mandatory_arg_error
1271: (p_api_name => l_proc
1272: ,p_argument => 'effective_date'
1273: ,p_argument_value => p_effective_date
1274: );

Line 1299: when hr_api.cannot_find_prog_unit then

1295: ,p_person_type_id => p_person_type_id
1296: ,p_vacancy_id => p_vacancy_id
1297: );
1298: exception
1299: when hr_api.cannot_find_prog_unit then
1300: hr_api.cannot_find_prog_unit_error
1301: (p_module_name => 'apply_for_job'
1302: ,p_hook_type => 'BP'
1303: );

Line 1300: hr_api.cannot_find_prog_unit_error

1296: ,p_vacancy_id => p_vacancy_id
1297: );
1298: exception
1299: when hr_api.cannot_find_prog_unit then
1300: hr_api.cannot_find_prog_unit_error
1301: (p_module_name => 'apply_for_job'
1302: ,p_hook_type => 'BP'
1303: );
1304: end;

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

1365: --
1366: -- Ensure the applicant number will not be changed if it exists
1367: --
1368: IF l_per_details_rec.applicant_number IS NOT NULL
1369: AND NVL(p_applicant_number,hr_api.g_number) <> l_per_details_rec.applicant_number
1370: THEN
1371: hr_utility.set_location(l_proc,50);
1372: p_applicant_number := l_per_details_rec.applicant_number;
1373: END IF;

Line 1384: ,p_datetrack_mode => hr_api.g_update

1380: --
1381: per_per_upd.upd
1382: (p_person_id => p_person_id
1383: ,p_effective_date => l_effective_date
1384: ,p_datetrack_mode => hr_api.g_update
1385: ,p_person_type_id => l_person_type_id1
1386: ,p_applicant_number => p_applicant_number
1387: ,p_employee_number => l_per_details_rec.employee_number
1388: ,p_npw_number => l_per_details_rec.npw_number

Line 1462: when hr_api.cannot_find_prog_unit then

1458: ,p_asg_object_version_number => l_asg_object_version_number
1459: ,p_assignment_sequence => l_assignment_sequence
1460: );
1461: exception
1462: when hr_api.cannot_find_prog_unit then
1463: hr_api.cannot_find_prog_unit_error
1464: (p_module_name => 'apply_for_job'
1465: ,p_hook_type => 'AP'
1466: );

Line 1463: hr_api.cannot_find_prog_unit_error

1459: ,p_assignment_sequence => l_assignment_sequence
1460: );
1461: exception
1462: when hr_api.cannot_find_prog_unit then
1463: hr_api.cannot_find_prog_unit_error
1464: (p_module_name => 'apply_for_job'
1465: ,p_hook_type => 'AP'
1466: );
1467: end;

Line 1472: raise hr_api.validate_enabled;

1468: --
1469: -- When in validation only mode raise the Validate_Enabled exception
1470: --
1471: if p_validate then
1472: raise hr_api.validate_enabled;
1473: end if;
1474: --
1475: -- Set all output arguments
1476: --

Line 1487: when hr_api.validate_enabled then

1483: p_assignment_sequence := l_assignment_sequence;
1484: --
1485: hr_utility.set_location(' Leaving:'||l_proc, 170);
1486: exception
1487: when hr_api.validate_enabled then
1488: --
1489: -- As the Validate_Enabled exception has been raised
1490: -- we must rollback to the savepoint
1491: --

Line 1674: ,p_person_type_id in number default hr_api.g_number

1670: ,p_date_start in date
1671: ,p_object_version_number in out nocopy number
1672: ,p_actual_termination_date in date
1673: ,p_last_standard_process_date in out nocopy date
1674: ,p_person_type_id in number default hr_api.g_number
1675: ,p_assignment_status_type_id in number default hr_api.g_number
1676: ,p_termination_reason in varchar2 default hr_api.g_varchar2
1677: ,p_supervisor_warning out nocopy boolean
1678: ,p_event_warning out nocopy boolean

Line 1675: ,p_assignment_status_type_id in number default hr_api.g_number

1671: ,p_object_version_number in out nocopy number
1672: ,p_actual_termination_date in date
1673: ,p_last_standard_process_date in out nocopy date
1674: ,p_person_type_id in number default hr_api.g_number
1675: ,p_assignment_status_type_id in number default hr_api.g_number
1676: ,p_termination_reason in varchar2 default hr_api.g_varchar2
1677: ,p_supervisor_warning out nocopy boolean
1678: ,p_event_warning out nocopy boolean
1679: ,p_interview_warning out nocopy boolean

Line 1676: ,p_termination_reason in varchar2 default hr_api.g_varchar2

1672: ,p_actual_termination_date in date
1673: ,p_last_standard_process_date in out nocopy date
1674: ,p_person_type_id in number default hr_api.g_number
1675: ,p_assignment_status_type_id in number default hr_api.g_number
1676: ,p_termination_reason in varchar2 default hr_api.g_varchar2
1677: ,p_supervisor_warning out nocopy boolean
1678: ,p_event_warning out nocopy boolean
1679: ,p_interview_warning out nocopy boolean
1680: ,p_review_warning out nocopy boolean

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

1737: l_date_of_death date;
1738: l_ptu_object_version_number number;
1739: l_person_type_usage_id number;
1740: l_applicant_number per_all_people_f.applicant_number%TYPE;
1741: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
1742: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
1743: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
1744: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
1745: --

Line 1823: hr_api.mandatory_arg_error

1819: -- Validation in addition to Table Handlers
1820: --
1821: -- Check period of placement and get business group details for validation.
1822: --
1823: hr_api.mandatory_arg_error
1824: (p_api_name => l_proc
1825: ,p_argument => 'person_id'
1826: ,p_argument_value => p_person_id
1827: );

Line 1829: hr_api.mandatory_arg_error

1825: ,p_argument => 'person_id'
1826: ,p_argument_value => p_person_id
1827: );
1828: --
1829: hr_api.mandatory_arg_error
1830: (p_api_name => l_proc
1831: ,p_argument => 'date_start'
1832: ,p_argument_value => p_date_start
1833: );

Line 1835: hr_api.mandatory_arg_error

1831: ,p_argument => 'date_start'
1832: ,p_argument_value => p_date_start
1833: );
1834: --
1835: hr_api.mandatory_arg_error
1836: (p_api_name => l_proc
1837: ,p_argument => 'actual_termination_date'
1838: ,p_argument_value => l_actual_termination_date
1839: );

Line 2239: raise hr_api.validate_enabled;

2235: --
2236: -- When in validation only mode raise the Validate_Enabled exception
2237: --
2238: if p_validate then
2239: raise hr_api.validate_enabled;
2240: end if;
2241: --
2242: -- Set all output arguments
2243: --

Line 2254: when hr_api.validate_enabled then

2250: --
2251: --
2252: hr_utility.set_location(' Leaving:'||l_proc, 340);
2253: exception
2254: when hr_api.validate_enabled then
2255: --
2256: -- As the Validate_Enabled exception has been raised
2257: -- we must rollback to the savepoint
2258: --

Line 2380: hr_api.mandatory_arg_error

2376: -- Validation in addition to Table Handlers
2377: --
2378: -- Check person id.
2379: --
2380: hr_api.mandatory_arg_error
2381: (p_api_name => l_proc
2382: ,p_argument => 'person_id'
2383: ,p_argument_value => p_person_id
2384: );

Line 2388: hr_api.mandatory_arg_error

2384: );
2385: --
2386: -- Check date start.
2387: --
2388: hr_api.mandatory_arg_error
2389: (p_api_name => l_proc
2390: ,p_argument => 'date_start'
2391: ,p_argument_value => p_date_start
2392: );

Line 2396: hr_api.mandatory_arg_error

2392: );
2393: --
2394: -- Check object version number.
2395: --
2396: hr_api.mandatory_arg_error
2397: (p_api_name => l_proc
2398: ,p_argument => 'object_version_number'
2399: ,p_argument_value => p_object_version_number
2400: );

Line 2619: raise hr_api.validate_enabled;

2615: --
2616: -- When in validation only mode raise the Validate_Enabled exception
2617: --
2618: if p_validate then
2619: raise hr_api.validate_enabled;
2620: end if;
2621: --
2622: -- Set all output arguments
2623: --

Line 2632: when hr_api.validate_enabled then

2628: p_org_now_no_manager_warning := l_org_now_no_manager_warning;
2629: --
2630: hr_utility.set_location(' Leaving:'||l_proc, 400);
2631: exception
2632: when hr_api.validate_enabled then
2633: --
2634: -- As the Validate_Enabled exception has been raised
2635: -- we must rollback to the savepoint
2636: --

Line 2675: ,p_person_type_id in number default hr_api.g_number

2671: ,p_effective_date in date
2672: ,p_person_id in number
2673: ,p_date_start in date
2674: ,p_object_version_number in out nocopy number
2675: ,p_person_type_id in number default hr_api.g_number
2676: ,p_assignment_status_type_id in number default hr_api.g_number
2677: ,p_actual_termination_date in date default hr_api.g_date
2678:
2679: /*

Line 2676: ,p_assignment_status_type_id in number default hr_api.g_number

2672: ,p_person_id in number
2673: ,p_date_start in date
2674: ,p_object_version_number in out nocopy number
2675: ,p_person_type_id in number default hr_api.g_number
2676: ,p_assignment_status_type_id in number default hr_api.g_number
2677: ,p_actual_termination_date in date default hr_api.g_date
2678:
2679: /*
2680: The following two parameters are available for internal-use only until

Line 2677: ,p_actual_termination_date in date default hr_api.g_date

2673: ,p_date_start in date
2674: ,p_object_version_number in out nocopy number
2675: ,p_person_type_id in number default hr_api.g_number
2676: ,p_assignment_status_type_id in number default hr_api.g_number
2677: ,p_actual_termination_date in date default hr_api.g_date
2678:
2679: /*
2680: The following two parameters are available for internal-use only until
2681: payroll support for contingent workers is introduced. Setting them has

Line 2687: ,p_termination_reason in varchar2 default hr_api.g_varchar2

2683: */
2684: ,p_final_process_date in out nocopy date
2685: ,p_last_standard_process_date in out nocopy date
2686:
2687: ,p_termination_reason in varchar2 default hr_api.g_varchar2
2688: ,p_projected_termination_date in date default hr_api.g_date
2689: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2690: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 2688: ,p_projected_termination_date in date default hr_api.g_date

2684: ,p_final_process_date in out nocopy date
2685: ,p_last_standard_process_date in out nocopy date
2686:
2687: ,p_termination_reason in varchar2 default hr_api.g_varchar2
2688: ,p_projected_termination_date in date default hr_api.g_date
2689: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2690: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 2689: ,p_attribute_category in varchar2 default hr_api.g_varchar2

2685: ,p_last_standard_process_date in out nocopy date
2686:
2687: ,p_termination_reason in varchar2 default hr_api.g_varchar2
2688: ,p_projected_termination_date in date default hr_api.g_date
2689: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2690: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 2690: ,p_attribute1 in varchar2 default hr_api.g_varchar2

2686:
2687: ,p_termination_reason in varchar2 default hr_api.g_varchar2
2688: ,p_projected_termination_date in date default hr_api.g_date
2689: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2690: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2

2687: ,p_termination_reason in varchar2 default hr_api.g_varchar2
2688: ,p_projected_termination_date in date default hr_api.g_date
2689: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2690: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2

2688: ,p_projected_termination_date in date default hr_api.g_date
2689: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2690: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2

2689: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2690: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2

2690: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2

2691: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2

2692: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2

2693: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2

2694: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2

2695: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2

2696: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2

2697: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2

2698: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2

2699: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2

2700: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2

2701: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2

2702: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2

2703: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2

2704: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2

2705: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2

2706: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2

2707: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2

2708: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2

2709: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2

2710: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2

2711: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2

2712: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2720: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2

2713: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2720: ,p_information_category in varchar2 default hr_api.g_varchar2
2721: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2

2714: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2720: ,p_information_category in varchar2 default hr_api.g_varchar2
2721: ,p_information1 in varchar2 default hr_api.g_varchar2
2722: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2

2715: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2720: ,p_information_category in varchar2 default hr_api.g_varchar2
2721: ,p_information1 in varchar2 default hr_api.g_varchar2
2722: ,p_information2 in varchar2 default hr_api.g_varchar2
2723: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 2720: ,p_information_category in varchar2 default hr_api.g_varchar2

2716: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2720: ,p_information_category in varchar2 default hr_api.g_varchar2
2721: ,p_information1 in varchar2 default hr_api.g_varchar2
2722: ,p_information2 in varchar2 default hr_api.g_varchar2
2723: ,p_information3 in varchar2 default hr_api.g_varchar2
2724: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 2721: ,p_information1 in varchar2 default hr_api.g_varchar2

2717: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2720: ,p_information_category in varchar2 default hr_api.g_varchar2
2721: ,p_information1 in varchar2 default hr_api.g_varchar2
2722: ,p_information2 in varchar2 default hr_api.g_varchar2
2723: ,p_information3 in varchar2 default hr_api.g_varchar2
2724: ,p_information4 in varchar2 default hr_api.g_varchar2
2725: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 2722: ,p_information2 in varchar2 default hr_api.g_varchar2

2718: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2720: ,p_information_category in varchar2 default hr_api.g_varchar2
2721: ,p_information1 in varchar2 default hr_api.g_varchar2
2722: ,p_information2 in varchar2 default hr_api.g_varchar2
2723: ,p_information3 in varchar2 default hr_api.g_varchar2
2724: ,p_information4 in varchar2 default hr_api.g_varchar2
2725: ,p_information5 in varchar2 default hr_api.g_varchar2
2726: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 2723: ,p_information3 in varchar2 default hr_api.g_varchar2

2719: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2720: ,p_information_category in varchar2 default hr_api.g_varchar2
2721: ,p_information1 in varchar2 default hr_api.g_varchar2
2722: ,p_information2 in varchar2 default hr_api.g_varchar2
2723: ,p_information3 in varchar2 default hr_api.g_varchar2
2724: ,p_information4 in varchar2 default hr_api.g_varchar2
2725: ,p_information5 in varchar2 default hr_api.g_varchar2
2726: ,p_information6 in varchar2 default hr_api.g_varchar2
2727: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 2724: ,p_information4 in varchar2 default hr_api.g_varchar2

2720: ,p_information_category in varchar2 default hr_api.g_varchar2
2721: ,p_information1 in varchar2 default hr_api.g_varchar2
2722: ,p_information2 in varchar2 default hr_api.g_varchar2
2723: ,p_information3 in varchar2 default hr_api.g_varchar2
2724: ,p_information4 in varchar2 default hr_api.g_varchar2
2725: ,p_information5 in varchar2 default hr_api.g_varchar2
2726: ,p_information6 in varchar2 default hr_api.g_varchar2
2727: ,p_information7 in varchar2 default hr_api.g_varchar2
2728: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 2725: ,p_information5 in varchar2 default hr_api.g_varchar2

2721: ,p_information1 in varchar2 default hr_api.g_varchar2
2722: ,p_information2 in varchar2 default hr_api.g_varchar2
2723: ,p_information3 in varchar2 default hr_api.g_varchar2
2724: ,p_information4 in varchar2 default hr_api.g_varchar2
2725: ,p_information5 in varchar2 default hr_api.g_varchar2
2726: ,p_information6 in varchar2 default hr_api.g_varchar2
2727: ,p_information7 in varchar2 default hr_api.g_varchar2
2728: ,p_information8 in varchar2 default hr_api.g_varchar2
2729: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 2726: ,p_information6 in varchar2 default hr_api.g_varchar2

2722: ,p_information2 in varchar2 default hr_api.g_varchar2
2723: ,p_information3 in varchar2 default hr_api.g_varchar2
2724: ,p_information4 in varchar2 default hr_api.g_varchar2
2725: ,p_information5 in varchar2 default hr_api.g_varchar2
2726: ,p_information6 in varchar2 default hr_api.g_varchar2
2727: ,p_information7 in varchar2 default hr_api.g_varchar2
2728: ,p_information8 in varchar2 default hr_api.g_varchar2
2729: ,p_information9 in varchar2 default hr_api.g_varchar2
2730: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 2727: ,p_information7 in varchar2 default hr_api.g_varchar2

2723: ,p_information3 in varchar2 default hr_api.g_varchar2
2724: ,p_information4 in varchar2 default hr_api.g_varchar2
2725: ,p_information5 in varchar2 default hr_api.g_varchar2
2726: ,p_information6 in varchar2 default hr_api.g_varchar2
2727: ,p_information7 in varchar2 default hr_api.g_varchar2
2728: ,p_information8 in varchar2 default hr_api.g_varchar2
2729: ,p_information9 in varchar2 default hr_api.g_varchar2
2730: ,p_information10 in varchar2 default hr_api.g_varchar2
2731: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 2728: ,p_information8 in varchar2 default hr_api.g_varchar2

2724: ,p_information4 in varchar2 default hr_api.g_varchar2
2725: ,p_information5 in varchar2 default hr_api.g_varchar2
2726: ,p_information6 in varchar2 default hr_api.g_varchar2
2727: ,p_information7 in varchar2 default hr_api.g_varchar2
2728: ,p_information8 in varchar2 default hr_api.g_varchar2
2729: ,p_information9 in varchar2 default hr_api.g_varchar2
2730: ,p_information10 in varchar2 default hr_api.g_varchar2
2731: ,p_information11 in varchar2 default hr_api.g_varchar2
2732: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 2729: ,p_information9 in varchar2 default hr_api.g_varchar2

2725: ,p_information5 in varchar2 default hr_api.g_varchar2
2726: ,p_information6 in varchar2 default hr_api.g_varchar2
2727: ,p_information7 in varchar2 default hr_api.g_varchar2
2728: ,p_information8 in varchar2 default hr_api.g_varchar2
2729: ,p_information9 in varchar2 default hr_api.g_varchar2
2730: ,p_information10 in varchar2 default hr_api.g_varchar2
2731: ,p_information11 in varchar2 default hr_api.g_varchar2
2732: ,p_information12 in varchar2 default hr_api.g_varchar2
2733: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 2730: ,p_information10 in varchar2 default hr_api.g_varchar2

2726: ,p_information6 in varchar2 default hr_api.g_varchar2
2727: ,p_information7 in varchar2 default hr_api.g_varchar2
2728: ,p_information8 in varchar2 default hr_api.g_varchar2
2729: ,p_information9 in varchar2 default hr_api.g_varchar2
2730: ,p_information10 in varchar2 default hr_api.g_varchar2
2731: ,p_information11 in varchar2 default hr_api.g_varchar2
2732: ,p_information12 in varchar2 default hr_api.g_varchar2
2733: ,p_information13 in varchar2 default hr_api.g_varchar2
2734: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 2731: ,p_information11 in varchar2 default hr_api.g_varchar2

2727: ,p_information7 in varchar2 default hr_api.g_varchar2
2728: ,p_information8 in varchar2 default hr_api.g_varchar2
2729: ,p_information9 in varchar2 default hr_api.g_varchar2
2730: ,p_information10 in varchar2 default hr_api.g_varchar2
2731: ,p_information11 in varchar2 default hr_api.g_varchar2
2732: ,p_information12 in varchar2 default hr_api.g_varchar2
2733: ,p_information13 in varchar2 default hr_api.g_varchar2
2734: ,p_information14 in varchar2 default hr_api.g_varchar2
2735: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 2732: ,p_information12 in varchar2 default hr_api.g_varchar2

2728: ,p_information8 in varchar2 default hr_api.g_varchar2
2729: ,p_information9 in varchar2 default hr_api.g_varchar2
2730: ,p_information10 in varchar2 default hr_api.g_varchar2
2731: ,p_information11 in varchar2 default hr_api.g_varchar2
2732: ,p_information12 in varchar2 default hr_api.g_varchar2
2733: ,p_information13 in varchar2 default hr_api.g_varchar2
2734: ,p_information14 in varchar2 default hr_api.g_varchar2
2735: ,p_information15 in varchar2 default hr_api.g_varchar2
2736: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 2733: ,p_information13 in varchar2 default hr_api.g_varchar2

2729: ,p_information9 in varchar2 default hr_api.g_varchar2
2730: ,p_information10 in varchar2 default hr_api.g_varchar2
2731: ,p_information11 in varchar2 default hr_api.g_varchar2
2732: ,p_information12 in varchar2 default hr_api.g_varchar2
2733: ,p_information13 in varchar2 default hr_api.g_varchar2
2734: ,p_information14 in varchar2 default hr_api.g_varchar2
2735: ,p_information15 in varchar2 default hr_api.g_varchar2
2736: ,p_information16 in varchar2 default hr_api.g_varchar2
2737: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 2734: ,p_information14 in varchar2 default hr_api.g_varchar2

2730: ,p_information10 in varchar2 default hr_api.g_varchar2
2731: ,p_information11 in varchar2 default hr_api.g_varchar2
2732: ,p_information12 in varchar2 default hr_api.g_varchar2
2733: ,p_information13 in varchar2 default hr_api.g_varchar2
2734: ,p_information14 in varchar2 default hr_api.g_varchar2
2735: ,p_information15 in varchar2 default hr_api.g_varchar2
2736: ,p_information16 in varchar2 default hr_api.g_varchar2
2737: ,p_information17 in varchar2 default hr_api.g_varchar2
2738: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 2735: ,p_information15 in varchar2 default hr_api.g_varchar2

2731: ,p_information11 in varchar2 default hr_api.g_varchar2
2732: ,p_information12 in varchar2 default hr_api.g_varchar2
2733: ,p_information13 in varchar2 default hr_api.g_varchar2
2734: ,p_information14 in varchar2 default hr_api.g_varchar2
2735: ,p_information15 in varchar2 default hr_api.g_varchar2
2736: ,p_information16 in varchar2 default hr_api.g_varchar2
2737: ,p_information17 in varchar2 default hr_api.g_varchar2
2738: ,p_information18 in varchar2 default hr_api.g_varchar2
2739: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 2736: ,p_information16 in varchar2 default hr_api.g_varchar2

2732: ,p_information12 in varchar2 default hr_api.g_varchar2
2733: ,p_information13 in varchar2 default hr_api.g_varchar2
2734: ,p_information14 in varchar2 default hr_api.g_varchar2
2735: ,p_information15 in varchar2 default hr_api.g_varchar2
2736: ,p_information16 in varchar2 default hr_api.g_varchar2
2737: ,p_information17 in varchar2 default hr_api.g_varchar2
2738: ,p_information18 in varchar2 default hr_api.g_varchar2
2739: ,p_information19 in varchar2 default hr_api.g_varchar2
2740: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 2737: ,p_information17 in varchar2 default hr_api.g_varchar2

2733: ,p_information13 in varchar2 default hr_api.g_varchar2
2734: ,p_information14 in varchar2 default hr_api.g_varchar2
2735: ,p_information15 in varchar2 default hr_api.g_varchar2
2736: ,p_information16 in varchar2 default hr_api.g_varchar2
2737: ,p_information17 in varchar2 default hr_api.g_varchar2
2738: ,p_information18 in varchar2 default hr_api.g_varchar2
2739: ,p_information19 in varchar2 default hr_api.g_varchar2
2740: ,p_information20 in varchar2 default hr_api.g_varchar2
2741: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 2738: ,p_information18 in varchar2 default hr_api.g_varchar2

2734: ,p_information14 in varchar2 default hr_api.g_varchar2
2735: ,p_information15 in varchar2 default hr_api.g_varchar2
2736: ,p_information16 in varchar2 default hr_api.g_varchar2
2737: ,p_information17 in varchar2 default hr_api.g_varchar2
2738: ,p_information18 in varchar2 default hr_api.g_varchar2
2739: ,p_information19 in varchar2 default hr_api.g_varchar2
2740: ,p_information20 in varchar2 default hr_api.g_varchar2
2741: ,p_information21 in varchar2 default hr_api.g_varchar2
2742: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 2739: ,p_information19 in varchar2 default hr_api.g_varchar2

2735: ,p_information15 in varchar2 default hr_api.g_varchar2
2736: ,p_information16 in varchar2 default hr_api.g_varchar2
2737: ,p_information17 in varchar2 default hr_api.g_varchar2
2738: ,p_information18 in varchar2 default hr_api.g_varchar2
2739: ,p_information19 in varchar2 default hr_api.g_varchar2
2740: ,p_information20 in varchar2 default hr_api.g_varchar2
2741: ,p_information21 in varchar2 default hr_api.g_varchar2
2742: ,p_information22 in varchar2 default hr_api.g_varchar2
2743: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 2740: ,p_information20 in varchar2 default hr_api.g_varchar2

2736: ,p_information16 in varchar2 default hr_api.g_varchar2
2737: ,p_information17 in varchar2 default hr_api.g_varchar2
2738: ,p_information18 in varchar2 default hr_api.g_varchar2
2739: ,p_information19 in varchar2 default hr_api.g_varchar2
2740: ,p_information20 in varchar2 default hr_api.g_varchar2
2741: ,p_information21 in varchar2 default hr_api.g_varchar2
2742: ,p_information22 in varchar2 default hr_api.g_varchar2
2743: ,p_information23 in varchar2 default hr_api.g_varchar2
2744: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 2741: ,p_information21 in varchar2 default hr_api.g_varchar2

2737: ,p_information17 in varchar2 default hr_api.g_varchar2
2738: ,p_information18 in varchar2 default hr_api.g_varchar2
2739: ,p_information19 in varchar2 default hr_api.g_varchar2
2740: ,p_information20 in varchar2 default hr_api.g_varchar2
2741: ,p_information21 in varchar2 default hr_api.g_varchar2
2742: ,p_information22 in varchar2 default hr_api.g_varchar2
2743: ,p_information23 in varchar2 default hr_api.g_varchar2
2744: ,p_information24 in varchar2 default hr_api.g_varchar2
2745: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 2742: ,p_information22 in varchar2 default hr_api.g_varchar2

2738: ,p_information18 in varchar2 default hr_api.g_varchar2
2739: ,p_information19 in varchar2 default hr_api.g_varchar2
2740: ,p_information20 in varchar2 default hr_api.g_varchar2
2741: ,p_information21 in varchar2 default hr_api.g_varchar2
2742: ,p_information22 in varchar2 default hr_api.g_varchar2
2743: ,p_information23 in varchar2 default hr_api.g_varchar2
2744: ,p_information24 in varchar2 default hr_api.g_varchar2
2745: ,p_information25 in varchar2 default hr_api.g_varchar2
2746: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 2743: ,p_information23 in varchar2 default hr_api.g_varchar2

2739: ,p_information19 in varchar2 default hr_api.g_varchar2
2740: ,p_information20 in varchar2 default hr_api.g_varchar2
2741: ,p_information21 in varchar2 default hr_api.g_varchar2
2742: ,p_information22 in varchar2 default hr_api.g_varchar2
2743: ,p_information23 in varchar2 default hr_api.g_varchar2
2744: ,p_information24 in varchar2 default hr_api.g_varchar2
2745: ,p_information25 in varchar2 default hr_api.g_varchar2
2746: ,p_information26 in varchar2 default hr_api.g_varchar2
2747: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 2744: ,p_information24 in varchar2 default hr_api.g_varchar2

2740: ,p_information20 in varchar2 default hr_api.g_varchar2
2741: ,p_information21 in varchar2 default hr_api.g_varchar2
2742: ,p_information22 in varchar2 default hr_api.g_varchar2
2743: ,p_information23 in varchar2 default hr_api.g_varchar2
2744: ,p_information24 in varchar2 default hr_api.g_varchar2
2745: ,p_information25 in varchar2 default hr_api.g_varchar2
2746: ,p_information26 in varchar2 default hr_api.g_varchar2
2747: ,p_information27 in varchar2 default hr_api.g_varchar2
2748: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 2745: ,p_information25 in varchar2 default hr_api.g_varchar2

2741: ,p_information21 in varchar2 default hr_api.g_varchar2
2742: ,p_information22 in varchar2 default hr_api.g_varchar2
2743: ,p_information23 in varchar2 default hr_api.g_varchar2
2744: ,p_information24 in varchar2 default hr_api.g_varchar2
2745: ,p_information25 in varchar2 default hr_api.g_varchar2
2746: ,p_information26 in varchar2 default hr_api.g_varchar2
2747: ,p_information27 in varchar2 default hr_api.g_varchar2
2748: ,p_information28 in varchar2 default hr_api.g_varchar2
2749: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 2746: ,p_information26 in varchar2 default hr_api.g_varchar2

2742: ,p_information22 in varchar2 default hr_api.g_varchar2
2743: ,p_information23 in varchar2 default hr_api.g_varchar2
2744: ,p_information24 in varchar2 default hr_api.g_varchar2
2745: ,p_information25 in varchar2 default hr_api.g_varchar2
2746: ,p_information26 in varchar2 default hr_api.g_varchar2
2747: ,p_information27 in varchar2 default hr_api.g_varchar2
2748: ,p_information28 in varchar2 default hr_api.g_varchar2
2749: ,p_information29 in varchar2 default hr_api.g_varchar2
2750: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 2747: ,p_information27 in varchar2 default hr_api.g_varchar2

2743: ,p_information23 in varchar2 default hr_api.g_varchar2
2744: ,p_information24 in varchar2 default hr_api.g_varchar2
2745: ,p_information25 in varchar2 default hr_api.g_varchar2
2746: ,p_information26 in varchar2 default hr_api.g_varchar2
2747: ,p_information27 in varchar2 default hr_api.g_varchar2
2748: ,p_information28 in varchar2 default hr_api.g_varchar2
2749: ,p_information29 in varchar2 default hr_api.g_varchar2
2750: ,p_information30 in varchar2 default hr_api.g_varchar2
2751: ,p_supervisor_warning out nocopy boolean

Line 2748: ,p_information28 in varchar2 default hr_api.g_varchar2

2744: ,p_information24 in varchar2 default hr_api.g_varchar2
2745: ,p_information25 in varchar2 default hr_api.g_varchar2
2746: ,p_information26 in varchar2 default hr_api.g_varchar2
2747: ,p_information27 in varchar2 default hr_api.g_varchar2
2748: ,p_information28 in varchar2 default hr_api.g_varchar2
2749: ,p_information29 in varchar2 default hr_api.g_varchar2
2750: ,p_information30 in varchar2 default hr_api.g_varchar2
2751: ,p_supervisor_warning out nocopy boolean
2752: ,p_event_warning out nocopy boolean

Line 2749: ,p_information29 in varchar2 default hr_api.g_varchar2

2745: ,p_information25 in varchar2 default hr_api.g_varchar2
2746: ,p_information26 in varchar2 default hr_api.g_varchar2
2747: ,p_information27 in varchar2 default hr_api.g_varchar2
2748: ,p_information28 in varchar2 default hr_api.g_varchar2
2749: ,p_information29 in varchar2 default hr_api.g_varchar2
2750: ,p_information30 in varchar2 default hr_api.g_varchar2
2751: ,p_supervisor_warning out nocopy boolean
2752: ,p_event_warning out nocopy boolean
2753: ,p_interview_warning out nocopy boolean

Line 2750: ,p_information30 in varchar2 default hr_api.g_varchar2

2746: ,p_information26 in varchar2 default hr_api.g_varchar2
2747: ,p_information27 in varchar2 default hr_api.g_varchar2
2748: ,p_information28 in varchar2 default hr_api.g_varchar2
2749: ,p_information29 in varchar2 default hr_api.g_varchar2
2750: ,p_information30 in varchar2 default hr_api.g_varchar2
2751: ,p_supervisor_warning out nocopy boolean
2752: ,p_event_warning out nocopy boolean
2753: ,p_interview_warning out nocopy boolean
2754: ,p_review_warning out nocopy boolean

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

2783: from per_roles
2784: where person_id = p_person_id
2785: and p_actual_termination_date
2786: between start_date
2787: and nvl(end_date, hr_api.g_eot);
2788:
2789: cursor csr_chk_addl_rights is
2790: select role_id
2791: from per_roles

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

2790: select role_id
2791: from per_roles
2792: where person_id = p_person_id
2793: and EMP_RIGHTS_FLAG = 'Y'
2794: and nvl(end_of_rights_date, hr_api.g_eot) > p_actual_termination_date;
2795: -- end fix 1370960
2796:
2797: begin
2798:

Line 2899: when hr_api.cannot_find_prog_unit then

2895: ,p_information29 => p_information29
2896: ,p_information30 => p_information30
2897: );
2898: exception
2899: when hr_api.cannot_find_prog_unit then
2900: hr_api.cannot_find_prog_unit_error
2901: (p_module_name => 'TERMINATE_PLACEMENT',
2902: p_hook_type => 'BP'
2903: );

Line 2900: hr_api.cannot_find_prog_unit_error

2896: ,p_information30 => p_information30
2897: );
2898: exception
2899: when hr_api.cannot_find_prog_unit then
2900: hr_api.cannot_find_prog_unit_error
2901: (p_module_name => 'TERMINATE_PLACEMENT',
2902: p_hook_type => 'BP'
2903: );
2904: end;

Line 3190: when hr_api.cannot_find_prog_unit then

3186: ,p_org_now_no_manager_warning => p_org_now_no_manager_warning
3187: ,p_addl_rights_warning => p_addl_rights_warning -- Fix 1370960
3188: );
3189: exception
3190: when hr_api.cannot_find_prog_unit then
3191: hr_api.cannot_find_prog_unit_error
3192: (p_module_name => 'TERMINATE_PLACEMENT',
3193: p_hook_type => 'AP'
3194: );

Line 3191: hr_api.cannot_find_prog_unit_error

3187: ,p_addl_rights_warning => p_addl_rights_warning -- Fix 1370960
3188: );
3189: exception
3190: when hr_api.cannot_find_prog_unit then
3191: hr_api.cannot_find_prog_unit_error
3192: (p_module_name => 'TERMINATE_PLACEMENT',
3193: p_hook_type => 'AP'
3194: );
3195: end;

Line 3201: RAISE hr_api.validate_enabled;

3197: --
3198: -- When in validation only mode raise the Validate_Enabled exception
3199: --
3200: IF p_validate THEN
3201: RAISE hr_api.validate_enabled;
3202: END IF;
3203:
3204: hr_utility.set_location('Leaving: '||l_proc, 90);
3205:

Line 3207: when hr_api.validate_enabled then

3203:
3204: hr_utility.set_location('Leaving: '||l_proc, 90);
3205:
3206: EXCEPTION
3207: when hr_api.validate_enabled then
3208: --
3209: -- As the Validate_Enabled exception has been raised
3210: -- we must rollback to the savepoint
3211: --

Line 3324: hr_api.mandatory_arg_error

3320: -- Issue a savepoint.
3321: --
3322: savepoint reverse_terminate_placement;
3323:
3324: hr_api.mandatory_arg_error
3325: (p_api_name => l_proc
3326: ,p_argument => 'person_id'
3327: ,p_argument_value => p_person_id
3328: );

Line 3330: hr_api.mandatory_arg_error

3326: ,p_argument => 'person_id'
3327: ,p_argument_value => p_person_id
3328: );
3329: --
3330: hr_api.mandatory_arg_error
3331: (p_api_name => l_proc
3332: ,p_argument => 'actual_termination_date'
3333: ,p_argument_value => p_actual_termination_date
3334: );

Line 3347: when hr_api.cannot_find_prog_unit then

3343: ,p_actual_termination_date => p_actual_termination_date
3344: ,p_clear_details => p_clear_details
3345: );
3346: exception
3347: when hr_api.cannot_find_prog_unit then
3348: hr_api.cannot_find_prog_unit_error
3349: (p_module_name => 'REVERSE_TERMINATE_PLACEMENT',
3350: p_hook_type => 'BP'
3351: );

Line 3348: hr_api.cannot_find_prog_unit_error

3344: ,p_clear_details => p_clear_details
3345: );
3346: exception
3347: when hr_api.cannot_find_prog_unit then
3348: hr_api.cannot_find_prog_unit_error
3349: (p_module_name => 'REVERSE_TERMINATE_PLACEMENT',
3350: p_hook_type => 'BP'
3351: );
3352: end;

Line 3476: SET pp.effective_end_date = hr_api.g_eot

3472: FPD_FLAG := (l_final_process_date IS NOT NULL);
3473: --
3474: hr_utility.set_location(l_proc,55);
3475: UPDATE per_people_f pp
3476: SET pp.effective_end_date = hr_api.g_eot
3477: WHERE pp.person_id = p_person_id
3478: AND p_actual_termination_date
3479: BETWEEN pp.effective_start_date
3480: AND pp.effective_end_date;

Line 3650: l_effective_end_date := hr_api.g_eot;

3646: if l_max_end_date <> l_final_process_date then
3647: l_effective_end_date := l_max_end_date;
3648: else
3649: hr_utility.set_location(l_proc,95);
3650: l_effective_end_date := hr_api.g_eot;
3651: end if;
3652: else
3653: hr_utility.set_location(l_proc,100);
3654: l_effective_end_date := l_max_end_date;

Line 3690: l_effective_end_date := hr_api.g_eot;

3686: if l_max_end_date <> l_final_process_date then
3687: null;
3688: else
3689: hr_utility.set_location(l_proc,115);
3690: l_effective_end_date := hr_api.g_eot;
3691: --
3692: hr_utility.set_location(l_proc,120);
3693: UPDATE per_secondary_ass_statuses sas
3694: SET sas.end_date = null

Line 3825: when hr_api.cannot_find_prog_unit then

3821: ,p_clear_details => p_clear_details
3822: ,p_fut_actns_exist_warning => p_fut_actns_exist_warning
3823: );
3824: exception
3825: when hr_api.cannot_find_prog_unit then
3826: hr_api.cannot_find_prog_unit_error
3827: (p_module_name => 'REVERSE_TERMINATE_PLACEMENT',
3828: p_hook_type => 'AP'
3829: );

Line 3826: hr_api.cannot_find_prog_unit_error

3822: ,p_fut_actns_exist_warning => p_fut_actns_exist_warning
3823: );
3824: exception
3825: when hr_api.cannot_find_prog_unit then
3826: hr_api.cannot_find_prog_unit_error
3827: (p_module_name => 'REVERSE_TERMINATE_PLACEMENT',
3828: p_hook_type => 'AP'
3829: );
3830: end;

Line 3850: when hr_api.validate_enabled then

3846:
3847: hr_utility.set_location('Leaving: '||l_proc, 200);
3848:
3849: exception
3850: when hr_api.validate_enabled then
3851: --
3852: -- As the Validate_Enabled exception has been raised
3853: -- we must rollback to the savepoint
3854: --