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

Line 51: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT hr_api.g_number

47: --
48: CURSOR csr_accepted_asgs
49: (p_person_id IN per_all_people_f.person_id%TYPE
50: ,p_effective_date IN DATE
51: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT hr_api.g_number
52: )
53: IS
54: SELECT asg.assignment_id
55: ,asg.object_version_number

Line 62: OR csr_accepted_asgs.p_assignment_id = hr_api.g_number)

58: ,per_assignment_status_types ast
59: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
60: AND asg.person_id = csr_accepted_asgs.p_person_id
61: AND ( asg.assignment_id = csr_accepted_asgs.p_assignment_id
62: OR csr_accepted_asgs.p_assignment_id = hr_api.g_number)
63: AND csr_accepted_asgs.p_effective_date BETWEEN asg.effective_start_date
64: AND asg.effective_end_date
65: AND asg.assignment_type = 'A'
66: AND ast.per_system_status = 'ACCEPTED';

Line 118: AND NVL(apl.date_end,hr_api.g_eot);

114: ,apl.object_version_number
115: FROM per_applications apl
116: WHERE apl.person_id = csr_apl_details.p_person_id
117: AND csr_apl_details.p_effective_date BETWEEN apl.date_received
118: AND NVL(apl.date_end,hr_api.g_eot);
119: --
120: CURSOR csr_pds_details
121: (p_person_id IN per_all_people_f.person_id%TYPE
122: ,p_effective_date IN DATE

Line 130: AND NVL(pds.actual_termination_date,hr_api.g_eot);

126: ,pds.object_version_number
127: FROM per_periods_of_service pds
128: WHERE pds.person_id = csr_pds_details.p_person_id
129: AND csr_pds_details.p_effective_date BETWEEN pds.date_start
130: AND NVL(pds.actual_termination_date,hr_api.g_eot);
131: --
132: -- -----------------------------------------------------------------------------
133: -- |--------------------------< future_asgs_count >----------------------------|
134: -- -----------------------------------------------------------------------------

Line 766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2

762: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
763: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
764: ,p_hire_all_accepted_asgs IN VARCHAR2
765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
767: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
768: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
769: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
770: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 854: hr_api.mandatory_arg_error

850: hr_utility.set_location('Entering:'||l_proc,10);
851: --
852: -- Ensure mandatory arguments have been passed
853: --
854: hr_api.mandatory_arg_error
855: (p_api_name => l_proc
856: ,p_argument => 'person_id'
857: ,p_argument_value => p_person_id
858: );

Line 860: hr_api.mandatory_arg_error

856: ,p_argument => 'person_id'
857: ,p_argument_value => p_person_id
858: );
859: --
860: hr_api.mandatory_arg_error
861: (p_api_name => l_proc
862: ,p_argument => 'hire_date'
863: ,p_argument_value => p_hire_date
864: );

Line 896: hr_api.mandatory_arg_error

892: THEN
893: hr_utility.set_location(l_proc,45);
894: l_hire_all_accepted_asgs := 'N';
895: l_hire_single_asg_id := p_assignment_id;
896: hr_api.mandatory_arg_error
897: (p_api_name => l_proc
898: ,p_argument => 'assignment_id'
899: ,p_argument_value => p_assignment_id);
900: ELSE

Line 920: WHEN hr_api.cannot_find_prog_unit

916: ,p_national_identifier => p_national_identifier
917: ,p_employee_number => p_employee_number
918: );
919: EXCEPTION
920: WHEN hr_api.cannot_find_prog_unit
921: THEN
922: hr_api.cannot_find_prog_unit_error
923: (p_module_name => 'HIRE_TO_EMPLOYEE_APPLICANT'
924: ,p_hook_type => 'BP'

Line 922: hr_api.cannot_find_prog_unit_error

918: );
919: EXCEPTION
920: WHEN hr_api.cannot_find_prog_unit
921: THEN
922: hr_api.cannot_find_prog_unit_error
923: (p_module_name => 'HIRE_TO_EMPLOYEE_APPLICANT'
924: ,p_hook_type => 'BP'
925: );
926: END;

Line 945: AND NVL(p_employee_number,hr_api.g_number) <> l_per_details_rec.employee_number

941: --
942: -- Ensure the employee number will not be changed if it exists
943: --
944: IF l_per_details_rec.employee_number IS NOT NULL
945: AND NVL(p_employee_number,hr_api.g_number) <> l_per_details_rec.employee_number
946: THEN
947: hr_utility.set_location(l_proc,80);
948: p_employee_number := l_per_details_rec.employee_number;
949: END IF;

Line 1065: hr_api.mandatory_arg_error

1061: CLOSE csr_accepted_asgs;
1062: l_new_primary_asg_id := l_accepted_asgs_rec.assignment_id;
1063: ELSE
1064: hr_utility.set_location(l_proc,200);
1065: hr_api.mandatory_arg_error
1066: (p_api_name => l_proc
1067: ,p_argument => 'assignment_id'
1068: ,p_argument_value => p_assignment_id);
1069: END IF;

Line 1152: ,p_datetrack_mode => hr_api.g_update

1148: ,p_full_name => l_full_name
1149: ,p_national_identifier => p_national_identifier
1150: ,p_object_version_number => l_object_version_number -- 3684087
1151: ,p_effective_date => l_hire_date
1152: ,p_datetrack_mode => hr_api.g_update
1153: ,p_name_combination_warning => l_name_combination_warning
1154: ,p_dob_null_warning => l_assign_payroll_warning
1155: ,p_orig_hire_warning => l_orig_hire_warning
1156: ,p_npw_number => l_per_details_rec.npw_number

Line 1285: ,p_datetrack_mode => hr_api.g_update

1281: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
1282: ,p_validation_start_date => l_validation_start_date
1283: ,p_validation_end_date => l_validation_end_date
1284: ,p_effective_date => l_hire_date
1285: ,p_datetrack_mode => hr_api.g_update
1286: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1287: );
1288: --
1289: open csr_vacs(l_accepted_asgs_rec.vacancy_id);

Line 1338: WHEN hr_api.cannot_find_prog_unit

1334: ,p_assign_payroll_warning => l_assign_payroll_warning
1335: ,p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id
1336: );
1337: EXCEPTION
1338: WHEN hr_api.cannot_find_prog_unit
1339: THEN
1340: hr_api.cannot_find_prog_unit_error
1341: (p_module_name => 'HIRE_TO_EMPLOYEE_APPLICANT'
1342: ,p_hook_type => 'AP'

Line 1340: hr_api.cannot_find_prog_unit_error

1336: );
1337: EXCEPTION
1338: WHEN hr_api.cannot_find_prog_unit
1339: THEN
1340: hr_api.cannot_find_prog_unit_error
1341: (p_module_name => 'HIRE_TO_EMPLOYEE_APPLICANT'
1342: ,p_hook_type => 'AP'
1343: );
1344: END;

Line 1352: RAISE hr_api.validate_enabled;

1348: -- When in validation only mode raise validate_enabled exception
1349: --
1350: IF p_validate
1351: THEN
1352: RAISE hr_api.validate_enabled;
1353: END IF;
1354: --
1355: -- Set OUT parameters
1356: --

Line 1368: WHEN hr_api.validate_enabled

1364: hr_utility.set_location(' Leaving:'||l_proc,1000);
1365: --
1366: EXCEPTION
1367: --
1368: WHEN hr_api.validate_enabled
1369: THEN
1370: --
1371: -- In validation only mode
1372: -- Rollback to savepoint

Line 1596: and nvl(pap.date_end,hr_api.g_eot);

1592: and per.person_id = p_person_id
1593: and l_hire_date between per.effective_start_date
1594: and per.effective_end_date
1595: and l_hire_date between pap.date_received
1596: and nvl(pap.date_end,hr_api.g_eot);
1597: --
1598: cursor csr_chk_asg_status is
1599: select count(asg.assignment_id)
1600: from per_assignments_f asg,

Line 1774: hr_api.mandatory_arg_error

1770: --
1771: begin
1772: hr_utility.set_location('Entering:'|| l_proc, 10);
1773: --
1774: hr_api.mandatory_arg_error
1775: (p_api_name => l_proc
1776: ,p_argument => 'person_id'
1777: ,p_argument_value => p_person_id
1778: );

Line 1780: hr_api.mandatory_arg_error

1776: ,p_argument => 'person_id'
1777: ,p_argument_value => p_person_id
1778: );
1779: --
1780: hr_api.mandatory_arg_error
1781: (p_api_name => l_proc
1782: ,p_argument => 'hire_date'
1783: ,p_argument_value => p_hire_date
1784: );

Line 1813: when hr_api.cannot_find_prog_unit then

1809: p_person_type_id => p_person_type_id,
1810: p_per_object_version_number => l_per_object_version_number
1811: );
1812: exception
1813: when hr_api.cannot_find_prog_unit then
1814: hr_api.cannot_find_prog_unit_error
1815: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
1816: ,p_hook_type => 'BP'
1817: );

Line 1814: hr_api.cannot_find_prog_unit_error

1810: p_per_object_version_number => l_per_object_version_number
1811: );
1812: exception
1813: when hr_api.cannot_find_prog_unit then
1814: hr_api.cannot_find_prog_unit_error
1815: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
1816: ,p_hook_type => 'BP'
1817: );
1818: --

Line 1924: hr_api.mandatory_arg_error

1920: if p_overwrite_primary='Y' then
1921: --
1922: hr_utility.set_location(l_proc,100);
1923: --
1924: hr_api.mandatory_arg_error
1925: (p_api_name => l_proc
1926: ,p_argument => 'assignment_id'
1927: ,p_argument_value => p_primary_assignment_id
1928: );

Line 2077: l_applicant_number:=hr_api.g_varchar2;

2073: --
2074: -- Update the person details by calling upd procedure in
2075: -- the per_all_people_f table.
2076: --
2077: l_applicant_number:=hr_api.g_varchar2;
2078: l_employee_number:=hr_api.g_varchar2;
2079: per_per_upd.upd
2080: (p_person_id => p_person_id
2081: ,p_effective_date => l_hire_date

Line 2078: l_employee_number:=hr_api.g_varchar2;

2074: -- Update the person details by calling upd procedure in
2075: -- the per_all_people_f table.
2076: --
2077: l_applicant_number:=hr_api.g_varchar2;
2078: l_employee_number:=hr_api.g_varchar2;
2079: per_per_upd.upd
2080: (p_person_id => p_person_id
2081: ,p_effective_date => l_hire_date
2082: ,p_applicant_number => l_applicant_number

Line 3399: when hr_api.cannot_find_prog_unit then

3395: p_assign_payroll_warning => l_assign_payroll_warning,
3396: p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id
3397: );
3398: exception
3399: when hr_api.cannot_find_prog_unit then
3400: hr_api.cannot_find_prog_unit_error
3401: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
3402: ,p_hook_type => 'AP'
3403: );

Line 3400: hr_api.cannot_find_prog_unit_error

3396: p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id
3397: );
3398: exception
3399: when hr_api.cannot_find_prog_unit then
3400: hr_api.cannot_find_prog_unit_error
3401: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
3402: ,p_hook_type => 'AP'
3403: );
3404: --

Line 3412: raise hr_api.validate_enabled;

3408: --
3409: -- When in validation only mode raise the Validate_Enabled exception
3410: --
3411: if p_validate then
3412: raise hr_api.validate_enabled;
3413: end if;
3414: --
3415: -- Set OUT parameters
3416: --

Line 3427: when hr_api.validate_enabled then

3423: --
3424: hr_utility.set_location(' Leaving:'||l_proc, 380);
3425: --
3426: exception
3427: when hr_api.validate_enabled then
3428: --
3429: -- As the Validate_Enabled exception has been raised
3430: -- we must rollback to the savepoint
3431: --