APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on HR_API

Line 1052: hr_api.set_legislation_context('GB');

1048: g_tab_event_map_cv := l_tab_config_values;
1049:
1050: -- For bug 7145485
1051:
1052: hr_api.set_legislation_context('GB');
1053:
1054: -- End Bug 7145485
1055: -- Event Description PCV_INFORMATION1
1056: -- Event Source PCV_INFORMATION4

Line 2958: NVL(l_source_pension_scheme, hr_api.g_varchar2) =

2954:
2955: IF p_event_desc = l_event_description
2956: AND (
2957: (
2958: NVL(l_source_pension_scheme, hr_api.g_varchar2) =
2959: NVL(l_pension_scheme, hr_api.g_varchar2)
2960: )
2961: OR (
2962: l_source_pension_scheme IS NOT NULL

Line 2959: NVL(l_pension_scheme, hr_api.g_varchar2)

2955: IF p_event_desc = l_event_description
2956: AND (
2957: (
2958: NVL(l_source_pension_scheme, hr_api.g_varchar2) =
2959: NVL(l_pension_scheme, hr_api.g_varchar2)
2960: )
2961: OR (
2962: l_source_pension_scheme IS NOT NULL
2963: AND l_pension_scheme = 'ANY'

Line 2975: nvl( p_employment_type,hr_api.g_varchar2) in

2971: p_employment_type = l_employment_type
2972: OR ( --115.70 5897563
2973: --ANY refers only to REGULAR and CASUAL employment types
2974: -- p_employment_type IS NOT NULL
2975: nvl( p_employment_type,hr_api.g_varchar2) in
2976: ('REGULAR','CASUAL')
2977: AND l_employment_type = 'ANY'
2978: )
2979: )

Line 3627: hr_api.g_eot

3623: -- Regular/fixed term employees can opt into partnership schemes as well
3624: -- IF g_tab_pen_sch_map_cv(i).pcv_information1 <> 'PARTNER'
3625: -- THEN
3626: IF l_rec_ele_ent_details.effective_end_date <>
3627: hr_api.g_eot
3628: AND -- Bug 4873436: chk opt out only as of or b4 cutover date
3629: l_rec_ele_ent_details.effective_end_date <=
3630: g_effective_date
3631: AND g_opt_out = 'Y'

Line 3747: hr_api.g_eot

3743: -- Check whether person is a member of partnership scheme
3744: IF g_tab_pen_sch_map_cv(i).pcv_information2 = 'PARTNER'
3745: THEN
3746: IF l_rec_ele_ent_details.effective_end_date <>
3747: hr_api.g_eot
3748: AND -- Bug 4873436: chk opt out only as of or b4 cutover date
3749: l_rec_ele_ent_details.effective_end_date <=
3750: g_effective_date
3751: AND g_opt_out = 'Y'

Line 4205: IF l_effective_date <> hr_api.g_eot

4201: OPEN csr_get_asg_details(l_ser_start_date);
4202: FETCH csr_get_asg_details INTO l_effective_date;
4203: FETCH csr_get_asg_details INTO l_next_effective_date;
4204:
4205: IF l_effective_date <> hr_api.g_eot
4206: AND csr_get_asg_details%NOTFOUND
4207: THEN
4208: -- This is due to termination event
4209: l_start_reason := 'ZZ';

Line 4242: AND NVL(l_asg_status_type_id, hr_api.g_number) <>

4238:
4239: g_ser_start_date := l_ser_start_date;
4240:
4241: IF l_start_reason = 'ZZ'
4242: AND NVL(l_asg_status_type_id, hr_api.g_number) <>
4243: g_terminate_asg_sts_id
4244: THEN
4245: l_asg_status_type_id := g_terminate_asg_sts_id;
4246: END IF;

Line 5189: and g_effective_date <> NVL(pps.final_process_date, hr_api.g_eot)

5185: AND paaf.assignment_status_type_id = past.assignment_status_type_id
5186: and pps.person_id = paaf.person_id
5187: and pps.period_of_service_id = paaf.period_of_service_id
5188: AND past.per_system_status = 'ACTIVE_ASSIGN'
5189: and g_effective_date <> NVL(pps.final_process_date, hr_api.g_eot)
5190: AND g_effective_date BETWEEN paaf.effective_start_date
5191: AND paaf.effective_end_date
5192: ORDER BY paaf.effective_start_date;
5193:

Line 5591: AND l_rec_ele_ent_info.effective_end_date <> hr_api.g_eot

5587: END IF;
5588:
5589: IF g_tab_pen_ele_ids.EXISTS(l_rec_ele_ent_info.element_type_id)
5590: AND g_opt_out = 'Y'
5591: AND l_rec_ele_ent_info.effective_end_date <> hr_api.g_eot
5592: AND l_rec_ele_ent_info.effective_end_date <=
5593: pqp_gb_psi_functions.g_effective_end_date
5594: THEN
5595: -- Yes this is an end date event

Line 5606: IF l_effective_end_date = hr_api.g_eot

5602: OPEN csr_get_asg_details;
5603: FETCH csr_get_asg_details INTO l_effective_end_date;
5604: -- FETCH csr_get_asg_details INTO l_next_effective_end_date;
5605:
5606: IF l_effective_end_date = hr_api.g_eot
5607: OR csr_get_asg_details%FOUND
5608: THEN
5609: -- This is NOT due to a leaver event
5610: -- might be an opt out event

Line 6802: AND NVL(l_asg_status_type_id, hr_api.g_number) <>

6798: END IF; -- End if of leaving reason is not null check ...
6799: END IF; -- End if of l_start_reason = 'ZZ' check ...
6800:
6801: IF l_start_reason = 'ZZ'
6802: AND NVL(l_asg_status_type_id, hr_api.g_number) <>
6803: g_terminate_asg_sts_id
6804: THEN
6805: l_asg_status_type_id := g_terminate_asg_sts_id;
6806: END IF;

Line 7055: IF NVL(g_person_id, hr_api.g_number) <> g_assignment_dtl.person_id

7051: ,p_assignment_dtl => g_assignment_dtl
7052: );
7053:
7054: -- Initialize counter only for a different person (tested for rehires)
7055: IF NVL(g_person_id, hr_api.g_number) <> g_assignment_dtl.person_id
7056: THEN
7057: clear_per_cache;
7058: g_person_id := g_assignment_dtl.person_id;
7059: -- ELSE