APPS.GHR_PA_REQUESTS_PKG dependencies on HR_API

Line 1115: -- Use function in ghr_api package to get the occ_code, otherwise known as the job occupational_series

1111: p_grade_or_level := cur_grd_rec.grade_or_level;
1112: END LOOP;
1113: END IF;
1114: --
1115: -- Use function in ghr_api package to get the occ_code, otherwise known as the job occupational_series
1116: -- It is found in the Job KFF and the Oragnization DDF tells us which segemnt of the KFF it is in
1117: IF p_job_id IS NOT NULL AND l_business_group_id IS NOT NULL THEN
1118: p_occ_code := ghr_api.get_job_occ_series_job(p_job_id
1119: ,l_business_group_id);

Line 1118: p_occ_code := ghr_api.get_job_occ_series_job(p_job_id

1114: --
1115: -- Use function in ghr_api package to get the occ_code, otherwise known as the job occupational_series
1116: -- It is found in the Job KFF and the Oragnization DDF tells us which segemnt of the KFF it is in
1117: IF p_job_id IS NOT NULL AND l_business_group_id IS NOT NULL THEN
1118: p_occ_code := ghr_api.get_job_occ_series_job(p_job_id
1119: ,l_business_group_id);
1120: END IF;
1121: --
1122: -- Retrieve the location details

Line 2116: and nvl(par.first_noa_cancel_or_correct,hr_api.g_varchar2) <> 'CANCEL'

2112: and par.effective_date >= p_date
2113: and par.pa_notification_id is not null
2114: and par.first_noa_code <> '001'
2115: and par.pa_request_id <> nvl(p_altered_pa_request_id,par.pa_request_id)
2116: and nvl(par.first_noa_cancel_or_correct,hr_api.g_varchar2) <> 'CANCEL'
2117: and ((par.second_noa_code is null)
2118: or (par.second_noa_code is not null
2119: and nvl(par.second_noa_cancel_or_correct,hr_api.g_varchar2) <> 'CANCEL'))
2120: order by par.effective_date ,par.pa_request_id ;

Line 2119: and nvl(par.second_noa_cancel_or_correct,hr_api.g_varchar2) <> 'CANCEL'))

2115: and par.pa_request_id <> nvl(p_altered_pa_request_id,par.pa_request_id)
2116: and nvl(par.first_noa_cancel_or_correct,hr_api.g_varchar2) <> 'CANCEL'
2117: and ((par.second_noa_code is null)
2118: or (par.second_noa_code is not null
2119: and nvl(par.second_noa_cancel_or_correct,hr_api.g_varchar2) <> 'CANCEL'))
2120: order by par.effective_date ,par.pa_request_id ;
2121:
2122:
2123: /*CURSOR c_par IS

Line 2165: If p_date = nvl(l_update34_date,hr_api.g_date) then

2161: end loop;
2162:
2163: l_update34_date := ghr_pay_caps.update34_implemented_date(p_person_id);
2164:
2165: If p_date = nvl(l_update34_date,hr_api.g_date) then
2166: If not l_exists then
2167: hr_utility.set_location('Not exists',1);
2168: l_effective_date := NULL;
2169: l_del_flag := 'Y';

Line 2442: l_occ_series := ghr_api.get_job_occ_series_job

2438:
2439: FOR l_get_job_id IN get_job_id LOOP
2440: l_job_id := l_get_job_id.job_id;
2441: END LOOP;
2442: l_occ_series := ghr_api.get_job_occ_series_job
2443: (p_job_id => l_job_id
2444: ,p_business_group_id => p_business_group_id);
2445:
2446: hr_utility.set_location('Leaving ' || l_proc,25);