APPS.GHR_APPROVED_PA_REQUESTS dependencies on HR_API

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

1221: IF l_pa_req_rec.second_noa_code = '825' THEN
1222: l_noa_family_code := 'GHR_INCENTIVE';
1223: END IF;
1224: hr_utility.set_location('noa family code is' || l_noa_family_code ,20);
1225: IF nvl(l_noa_family_code,hr_api.g_varchar2) not in
1226: ('APP','APPT_TRANS','APPT_INFO') THEN
1227: hr_utility.set_location('notification id is' || l_pa_req_rec.pa_notification_id,22 );
1228: --BUG # 7216635 Added the parameter p_noa_id_correct
1229: GHR_APPROVED_PA_REQUESTS.determine_ia(

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

1260: -- If the retro action is cancellation action, then consider the RPA
1261: -- previous to this Cancellation RPA and use that for populating
1262: -- from side of this correction action.
1263:
1264: IF NVL(l_retro_first_noa,hr_api.g_varchar2) = '001' THEN
1265: -- Get the To side of the RPA previous to this cancellation action
1266: -- Need to modify the cursor. Need to add Order of processing too
1267: hr_utility.set_location('Cancellation RPA',11);
1268: FOR l_pa_before_retro IN c_pa_before_retro(l_effective_date,l_pa_req_rec.person_id) LOOP

Line 1367: l_noa_id_correct := hr_api.g_number;

1363: end loop;
1364: END IF;
1365: ELSE
1366: hr_utility.set_location('non IA : '||l_pa_req_rec.pay_rate_determinant,11);
1367: l_noa_id_correct := hr_api.g_number;
1368: l_altered_pa_request_id := l_pa_req_rec.altered_pa_request_id;
1369: GHR_API.sf52_from_data_elements(
1370: p_person_id => l_pa_req_rec.person_id
1371: ,p_assignment_id => l_pa_req_rec.employee_assignment_id

Line 1369: GHR_API.sf52_from_data_elements(

1365: ELSE
1366: hr_utility.set_location('non IA : '||l_pa_req_rec.pay_rate_determinant,11);
1367: l_noa_id_correct := hr_api.g_number;
1368: l_altered_pa_request_id := l_pa_req_rec.altered_pa_request_id;
1369: GHR_API.sf52_from_data_elements(
1370: p_person_id => l_pa_req_rec.person_id
1371: ,p_assignment_id => l_pa_req_rec.employee_assignment_id
1372: ,p_effective_date => nvl(l_effective_date, l_pa_req_rec.effective_date)
1373: ,p_altered_pa_request_id => l_altered_pa_request_id

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

1527:
1528:
1529: );
1530:
1531: IF nvl(l_noa_family_code,hr_api.g_varchar2) = 'GHR_INCENTIVE' THEN
1532: hr_utility.set_location('Inserting incentive records',0);
1533: INSERT INTO ghr_pa_incentives( pa_incentive_id,
1534: pa_request_id ,
1535: pa_incentive_category,

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

1749: ' PERSONNELIST= ' || L_PERSONNELIST_FLAG || l_proc, 10);
1750: --
1751: if l_return_value then
1752: hr_utility.set_location('l_return_value is TRUE',10);
1753: ghr_api.call_workflow(p_pa_request_id, 'CONTINUE');
1754:
1755: hr_utility.set_location('Re routed '|| l_proc, 15);
1756: hr_utility.set_location('Updated PA Requests '|| l_proc, 20);
1757: else