APPS.GHR_APPROVED_PA_REQUESTS dependencies on HR_API

Line 1300: IF nvl(l_noa_family_code,hr_api.g_varchar2) not in

1296: IF l_pa_req_rec.second_noa_code = '825' THEN
1297: l_noa_family_code := 'GHR_INCENTIVE';
1298: END IF;
1299: hr_utility.set_location('noa family code is' || l_noa_family_code ,20);
1300: IF nvl(l_noa_family_code,hr_api.g_varchar2) not in
1301: ('APP','APPT_TRANS','APPT_INFO') THEN
1302: hr_utility.set_location('notification id is' || l_pa_req_rec.pa_notification_id,22 );
1303: --BUG # 7216635 Added the parameter p_noa_id_correct
1304: GHR_APPROVED_PA_REQUESTS.determine_ia(

Line 1339: IF NVL(l_retro_first_noa,hr_api.g_varchar2) = '001' THEN

1335: -- If the retro action is cancellation action, then consider the RPA
1336: -- previous to this Cancellation RPA and use that for populating
1337: -- from side of this correction action.
1338:
1339: IF NVL(l_retro_first_noa,hr_api.g_varchar2) = '001' THEN
1340: -- Get the To side of the RPA previous to this cancellation action
1341: -- Need to modify the cursor. Need to add Order of processing too
1342: hr_utility.set_location('Cancellation RPA',11);
1343: FOR l_pa_before_retro IN c_pa_before_retro(l_effective_date,l_pa_req_rec.person_id) LOOP

Line 1446: l_noa_id_correct := hr_api.g_number;

1442: end loop;
1443: END IF;
1444: ELSE
1445: hr_utility.set_location('non IA : '||l_pa_req_rec.pay_rate_determinant,11);
1446: l_noa_id_correct := hr_api.g_number;
1447: l_altered_pa_request_id := l_pa_req_rec.altered_pa_request_id;
1448: GHR_API.sf52_from_data_elements(
1449: p_person_id => l_pa_req_rec.person_id
1450: ,p_assignment_id => l_pa_req_rec.employee_assignment_id

Line 1448: GHR_API.sf52_from_data_elements(

1444: ELSE
1445: hr_utility.set_location('non IA : '||l_pa_req_rec.pay_rate_determinant,11);
1446: l_noa_id_correct := hr_api.g_number;
1447: l_altered_pa_request_id := l_pa_req_rec.altered_pa_request_id;
1448: GHR_API.sf52_from_data_elements(
1449: p_person_id => l_pa_req_rec.person_id
1450: ,p_assignment_id => l_pa_req_rec.employee_assignment_id
1451: ,p_effective_date => nvl(l_effective_date, l_pa_req_rec.effective_date)
1452: ,p_altered_pa_request_id => l_altered_pa_request_id

Line 1612: IF nvl(l_noa_family_code,hr_api.g_varchar2) = 'GHR_INCENTIVE' THEN

1608:
1609:
1610: );
1611:
1612: IF nvl(l_noa_family_code,hr_api.g_varchar2) = 'GHR_INCENTIVE' THEN
1613: hr_utility.set_location('Inserting incentive records',0);
1614: INSERT INTO ghr_pa_incentives( pa_incentive_id,
1615: pa_request_id ,
1616: pa_incentive_category,

Line 1841: ghr_api.call_workflow(p_pa_request_id, 'CONTINUE');

1837: ' PERSONNELIST= ' || L_PERSONNELIST_FLAG || l_proc, 10);
1838: --
1839: if l_return_value then
1840: hr_utility.set_location('l_return_value is TRUE',10);
1841: ghr_api.call_workflow(p_pa_request_id, 'CONTINUE');
1842:
1843: hr_utility.set_location('Re routed '|| l_proc, 15);
1844: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);
1845: else