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 768: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2

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

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

812: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
813: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
814: ,p_hire_all_accepted_asgs IN VARCHAR2
815: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
816: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
817: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
818: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
819: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
820: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 972: hr_api.mandatory_arg_error

968: hr_utility.set_location('Entering:'||l_proc,10);
969: --
970: -- Ensure mandatory arguments have been passed
971: --
972: hr_api.mandatory_arg_error
973: (p_api_name => l_proc
974: ,p_argument => 'person_id'
975: ,p_argument_value => p_person_id
976: );

Line 978: hr_api.mandatory_arg_error

974: ,p_argument => 'person_id'
975: ,p_argument_value => p_person_id
976: );
977: --
978: hr_api.mandatory_arg_error
979: (p_api_name => l_proc
980: ,p_argument => 'hire_date'
981: ,p_argument_value => p_hire_date
982: );

Line 1014: hr_api.mandatory_arg_error

1010: THEN
1011: hr_utility.set_location(l_proc,45);
1012: l_hire_all_accepted_asgs := 'N';
1013: l_hire_single_asg_id := p_assignment_id;
1014: hr_api.mandatory_arg_error
1015: (p_api_name => l_proc
1016: ,p_argument => 'assignment_id'
1017: ,p_argument_value => p_assignment_id);
1018: ELSE

Line 1038: WHEN hr_api.cannot_find_prog_unit

1034: ,p_national_identifier => p_national_identifier
1035: ,p_employee_number => p_employee_number
1036: );
1037: EXCEPTION
1038: WHEN hr_api.cannot_find_prog_unit
1039: THEN
1040: hr_api.cannot_find_prog_unit_error
1041: (p_module_name => 'HIRE_TO_EMPLOYEE_APPLICANT'
1042: ,p_hook_type => 'BP'

Line 1040: hr_api.cannot_find_prog_unit_error

1036: );
1037: EXCEPTION
1038: WHEN hr_api.cannot_find_prog_unit
1039: THEN
1040: hr_api.cannot_find_prog_unit_error
1041: (p_module_name => 'HIRE_TO_EMPLOYEE_APPLICANT'
1042: ,p_hook_type => 'BP'
1043: );
1044: END;

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

1059: --
1060: -- Ensure the employee number will not be changed if it exists
1061: --
1062: IF l_per_details_rec.employee_number IS NOT NULL
1063: AND NVL(p_employee_number,hr_api.g_number) <> l_per_details_rec.employee_number
1064: THEN
1065: hr_utility.set_location(l_proc,80);
1066: p_employee_number := l_per_details_rec.employee_number;
1067: END IF;

Line 1183: hr_api.mandatory_arg_error

1179: CLOSE csr_accepted_asgs;
1180: l_new_primary_asg_id := l_accepted_asgs_rec.assignment_id;
1181: ELSE
1182: hr_utility.set_location(l_proc,200);
1183: hr_api.mandatory_arg_error
1184: (p_api_name => l_proc
1185: ,p_argument => 'assignment_id'
1186: ,p_argument_value => p_assignment_id);
1187: END IF;

Line 1293: ,p_datetrack_mode => hr_api.g_update

1289: ,p_full_name => l_full_name
1290: ,p_national_identifier => p_national_identifier
1291: ,p_object_version_number => l_object_version_number -- 3684087
1292: ,p_effective_date => l_hire_date
1293: ,p_datetrack_mode => hr_api.g_update
1294: ,p_name_combination_warning => l_name_combination_warning
1295: ,p_dob_null_warning => l_assign_payroll_warning
1296: ,p_orig_hire_warning => l_orig_hire_warning
1297: ,p_npw_number => l_per_details_rec.npw_number

Line 1427: ,p_datetrack_mode => hr_api.g_update

1423: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
1424: ,p_validation_start_date => l_validation_start_date
1425: ,p_validation_end_date => l_validation_end_date
1426: ,p_effective_date => l_hire_date
1427: ,p_datetrack_mode => hr_api.g_update
1428: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1429: );
1430: --
1431: -- Fix For Bug: 12612530 Starts ----

Line 1502: WHEN hr_api.cannot_find_prog_unit

1498: ,p_assign_payroll_warning => l_assign_payroll_warning
1499: ,p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id
1500: );
1501: EXCEPTION
1502: WHEN hr_api.cannot_find_prog_unit
1503: THEN
1504: hr_api.cannot_find_prog_unit_error
1505: (p_module_name => 'HIRE_TO_EMPLOYEE_APPLICANT'
1506: ,p_hook_type => 'AP'

Line 1504: hr_api.cannot_find_prog_unit_error

1500: );
1501: EXCEPTION
1502: WHEN hr_api.cannot_find_prog_unit
1503: THEN
1504: hr_api.cannot_find_prog_unit_error
1505: (p_module_name => 'HIRE_TO_EMPLOYEE_APPLICANT'
1506: ,p_hook_type => 'AP'
1507: );
1508: END;

Line 1516: RAISE hr_api.validate_enabled;

1512: -- When in validation only mode raise validate_enabled exception
1513: --
1514: IF p_validate
1515: THEN
1516: RAISE hr_api.validate_enabled;
1517: END IF;
1518: --
1519: -- Set OUT parameters
1520: --

Line 1532: WHEN hr_api.validate_enabled

1528: hr_utility.set_location(' Leaving:'||l_proc,1000);
1529: --
1530: EXCEPTION
1531: --
1532: WHEN hr_api.validate_enabled
1533: THEN
1534: --
1535: -- In validation only mode
1536: -- Rollback to savepoint

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

1813: and per.person_id = p_person_id
1814: and l_hire_date between per.effective_start_date
1815: and per.effective_end_date
1816: and l_hire_date between pap.date_received
1817: and nvl(pap.date_end,hr_api.g_eot);
1818: --
1819: cursor csr_chk_asg_status is
1820: select count(asg.assignment_id)
1821: from per_assignments_f asg,

Line 2038: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);

2034:
2035: cursor chk_apl_exists(p_asg_start_date date) is
2036: select application_id, date_end from per_applications
2037: where person_id = p_person_id
2038: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
2039: -- ER FPT
2040:
2041: begin
2042: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2044: hr_api.mandatory_arg_error

2040:
2041: begin
2042: hr_utility.set_location('Entering:'|| l_proc, 10);
2043: --
2044: hr_api.mandatory_arg_error
2045: (p_api_name => l_proc
2046: ,p_argument => 'person_id'
2047: ,p_argument_value => p_person_id
2048: );

Line 2050: hr_api.mandatory_arg_error

2046: ,p_argument => 'person_id'
2047: ,p_argument_value => p_person_id
2048: );
2049: --
2050: hr_api.mandatory_arg_error
2051: (p_api_name => l_proc
2052: ,p_argument => 'hire_date'
2053: ,p_argument_value => p_hire_date
2054: );

Line 2083: when hr_api.cannot_find_prog_unit then

2079: p_person_type_id => p_person_type_id,
2080: p_per_object_version_number => l_per_object_version_number
2081: );
2082: exception
2083: when hr_api.cannot_find_prog_unit then
2084: hr_api.cannot_find_prog_unit_error
2085: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
2086: ,p_hook_type => 'BP'
2087: );

Line 2084: hr_api.cannot_find_prog_unit_error

2080: p_per_object_version_number => l_per_object_version_number
2081: );
2082: exception
2083: when hr_api.cannot_find_prog_unit then
2084: hr_api.cannot_find_prog_unit_error
2085: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
2086: ,p_hook_type => 'BP'
2087: );
2088: --

Line 2201: hr_api.mandatory_arg_error

2197: if p_overwrite_primary='Y' then
2198: --
2199: hr_utility.set_location(l_proc,100);
2200: --
2201: hr_api.mandatory_arg_error
2202: (p_api_name => l_proc
2203: ,p_argument => 'assignment_id'
2204: ,p_argument_value => p_primary_assignment_id
2205: );

Line 2391: l_applicant_number:=hr_api.g_varchar2;

2387: --
2388: -- Update the person details by calling upd procedure in
2389: -- the per_all_people_f table.
2390: --
2391: l_applicant_number:=hr_api.g_varchar2;
2392: l_employee_number:=hr_api.g_varchar2;
2393: per_per_upd.upd
2394: (p_person_id => p_person_id
2395: ,p_effective_date => l_hire_date

Line 2392: l_employee_number:=hr_api.g_varchar2;

2388: -- Update the person details by calling upd procedure in
2389: -- the per_all_people_f table.
2390: --
2391: l_applicant_number:=hr_api.g_varchar2;
2392: l_employee_number:=hr_api.g_varchar2;
2393: per_per_upd.upd
2394: (p_person_id => p_person_id
2395: ,p_effective_date => l_hire_date
2396: ,p_applicant_number => l_applicant_number

Line 3719: if l_apl_end_date = hr_api.g_eot then

3715: where person_id = p_person_id
3716: and assignment_id = apl.assignment_id
3717: and assignment_type = 'A';
3718:
3719: if l_apl_end_date = hr_api.g_eot then
3720: l_apl_end_date := null;
3721: end if;
3722:
3723: -- check whether an application exists on the start date of the ASG

Line 3749: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then

3745:
3746: else
3747:
3748: -- if APLN end date < ASG end date, update the APLN
3749: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then
3750: update per_applications
3751: set date_end = l_apl_end_date
3752: where person_id = p_person_id
3753: and application_id = l_cur_apl_id;

Line 3817: if nvl(apl.date_end,hr_api.g_eot) <> hr_api.g_eot then

3813: ,p_orig_hire_warning => l_orig_hire_warning
3814: ,p_npw_number => l_npw_number
3815: );
3816:
3817: if nvl(apl.date_end,hr_api.g_eot) <> hr_api.g_eot then
3818:
3819: -- check whether back-to-back application exists
3820:
3821: open csr_back_toback_apln(apl.date_end) ;

Line 3923: when hr_api.cannot_find_prog_unit then

3919: p_assign_payroll_warning => l_assign_payroll_warning,
3920: p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id
3921: );
3922: exception
3923: when hr_api.cannot_find_prog_unit then
3924: hr_api.cannot_find_prog_unit_error
3925: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
3926: ,p_hook_type => 'AP'
3927: );

Line 3924: hr_api.cannot_find_prog_unit_error

3920: p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id
3921: );
3922: exception
3923: when hr_api.cannot_find_prog_unit then
3924: hr_api.cannot_find_prog_unit_error
3925: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
3926: ,p_hook_type => 'AP'
3927: );
3928: --

Line 3936: raise hr_api.validate_enabled;

3932: --
3933: -- When in validation only mode raise the Validate_Enabled exception
3934: --
3935: if p_validate then
3936: raise hr_api.validate_enabled;
3937: end if;
3938: --
3939: -- Set OUT parameters
3940: --

Line 3951: when hr_api.validate_enabled then

3947: --
3948: hr_utility.set_location(' Leaving:'||l_proc, 380);
3949: --
3950: exception
3951: when hr_api.validate_enabled then
3952: --
3953: -- As the Validate_Enabled exception has been raised
3954: -- we must rollback to the savepoint
3955: --

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

4286: and per.person_id = p_person_id
4287: and l_hire_date between per.effective_start_date
4288: and per.effective_end_date
4289: and l_hire_date between pap.date_received
4290: and nvl(pap.date_end,hr_api.g_eot);
4291: --
4292: cursor csr_chk_asg_status is
4293: select count(asg.assignment_id)
4294: from per_assignments_f asg,

Line 4568: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);

4564:
4565: cursor chk_apl_exists(p_asg_start_date date) is
4566: select application_id, date_end from per_applications
4567: where person_id = p_person_id
4568: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
4569:
4570: -- ER FPT
4571:
4572:

Line 4576: hr_api.mandatory_arg_error

4572:
4573: begin
4574: hr_utility.set_location('Entering:'|| l_proc, 10);
4575: --
4576: hr_api.mandatory_arg_error
4577: (p_api_name => l_proc
4578: ,p_argument => 'person_id'
4579: ,p_argument_value => p_person_id
4580: );

Line 4582: hr_api.mandatory_arg_error

4578: ,p_argument => 'person_id'
4579: ,p_argument_value => p_person_id
4580: );
4581: --
4582: hr_api.mandatory_arg_error
4583: (p_api_name => l_proc
4584: ,p_argument => 'hire_date'
4585: ,p_argument_value => p_hire_date
4586: );

Line 4615: when hr_api.cannot_find_prog_unit then

4611: p_person_type_id => p_person_type_id,
4612: p_per_object_version_number => l_per_object_version_number
4613: );
4614: exception
4615: when hr_api.cannot_find_prog_unit then
4616: hr_api.cannot_find_prog_unit_error
4617: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
4618: ,p_hook_type => 'BP'
4619: );

Line 4616: hr_api.cannot_find_prog_unit_error

4612: p_per_object_version_number => l_per_object_version_number
4613: );
4614: exception
4615: when hr_api.cannot_find_prog_unit then
4616: hr_api.cannot_find_prog_unit_error
4617: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
4618: ,p_hook_type => 'BP'
4619: );
4620: --

Line 4735: hr_api.mandatory_arg_error

4731: if p_overwrite_primary='Y' then
4732: --
4733: hr_utility.set_location(l_proc,100);
4734: --
4735: hr_api.mandatory_arg_error
4736: (p_api_name => l_proc
4737: ,p_argument => 'assignment_id'
4738: ,p_argument_value => p_primary_assignment_id
4739: );

Line 4963: l_applicant_number:=hr_api.g_varchar2;

4959: --
4960: -- Update the person details by calling upd procedure in
4961: -- the per_all_people_f table.
4962: --
4963: l_applicant_number:=hr_api.g_varchar2;
4964: l_employee_number:=hr_api.g_varchar2;
4965:
4966: ------ SSHR Enhancement (Bug # 8536819)-------
4967: -- If there are no aaplication other than the one into which we are hiring

Line 4964: l_employee_number:=hr_api.g_varchar2;

4960: -- Update the person details by calling upd procedure in
4961: -- the per_all_people_f table.
4962: --
4963: l_applicant_number:=hr_api.g_varchar2;
4964: l_employee_number:=hr_api.g_varchar2;
4965:
4966: ------ SSHR Enhancement (Bug # 8536819)-------
4967: -- If there are no aaplication other than the one into which we are hiring
4968: -- then need to change the person_type. Added the below IF.

Line 5054: l_soft_coding_keyflex_id := hr_api.g_number;

5050: -- 12970825 added l_legislation code condition.
5051: if l_soft_coding_keyflex_id is null and l_payroll_id is not null and l_legislation_code = 'US' then
5052: l_soft_coding_keyflex_id := l_dummy_soft_coding_keyflex_id;
5053: else
5054: l_soft_coding_keyflex_id := hr_api.g_number;
5055: end if;
5056: --- Fix For Bug # 8844816 Ends ---
5057:
5058: --

Line 6564: if l_apl_end_date = hr_api.g_eot then

6560: where person_id = p_person_id
6561: and assignment_id = apl.assignment_id
6562: and assignment_type = 'A';
6563:
6564: if l_apl_end_date = hr_api.g_eot then
6565: l_apl_end_date := null;
6566: end if;
6567:
6568: -- check whether an application exists on the start date of the ASG

Line 6594: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then

6590:
6591: else
6592:
6593: -- if APLN end date < ASG end date, update the APLN
6594: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then
6595: update per_applications
6596: set date_end = l_apl_end_date
6597: where person_id = p_person_id
6598: and application_id = l_cur_apl_id;

Line 6662: if nvl(apl.date_end,hr_api.g_eot) <> hr_api.g_eot then

6658: ,p_orig_hire_warning => l_orig_hire_warning
6659: ,p_npw_number => l_npw_number
6660: );
6661:
6662: if nvl(apl.date_end,hr_api.g_eot) <> hr_api.g_eot then
6663:
6664: -- check whether back-to-back application exists
6665:
6666: open csr_back_toback_apln(apl.date_end) ;

Line 6751: when hr_api.cannot_find_prog_unit then

6747: p_assign_payroll_warning => l_assign_payroll_warning,
6748: p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id
6749: );
6750: exception
6751: when hr_api.cannot_find_prog_unit then
6752: hr_api.cannot_find_prog_unit_error
6753: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
6754: ,p_hook_type => 'AP'
6755: );

Line 6752: hr_api.cannot_find_prog_unit_error

6748: p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id
6749: );
6750: exception
6751: when hr_api.cannot_find_prog_unit then
6752: hr_api.cannot_find_prog_unit_error
6753: (p_module_name => 'HIRE_EMPLOYEE_APPLICANT'
6754: ,p_hook_type => 'AP'
6755: );
6756: --

Line 6764: raise hr_api.validate_enabled;

6760: --
6761: -- When in validation only mode raise the Validate_Enabled exception
6762: --
6763: if p_validate then
6764: raise hr_api.validate_enabled;
6765: end if;
6766: --
6767: -- Set OUT parameters
6768: --

Line 6779: when hr_api.validate_enabled then

6775: --
6776: hr_utility.set_location(' Leaving:'||l_proc, 380);
6777: --
6778: exception
6779: when hr_api.validate_enabled then
6780: --
6781: -- As the Validate_Enabled exception has been raised
6782: -- we must rollback to the savepoint
6783: --