APPS.GHR_SF52_POST_UPDATE dependencies on HR_API

Line 52: IF nvl(p_called_from,hr_api.g_varchar2) = 'CORRECTION_SF52' THEN

48: Fetch C_Sel1 Into l_pa_notification_id;
49: Close C_Sel1;
50:
51: hr_utility.set_location('to_position_id is '||p_sf52_data_result.to_position_id ,10);
52: IF nvl(p_called_from,hr_api.g_varchar2) = 'CORRECTION_SF52' THEN
53: ghr_par_upd.upd
54: (p_pa_request_id => p_pa_request_id
55: ,p_object_version_number => l_object_version_number
56: ,p_pa_notification_id => l_pa_notification_id

Line 389: if nvl(p_to_position_id,hr_api.g_number) <> hr_api.g_number then

385: end loop;
386: hr_utility.set_location('PA Req ID : '||p_pa_request_id,10);
387: hr_utility.set_location('l_noa_code is '||l_noa_code,20);
388: -- Agency Desc
389: if nvl(p_to_position_id,hr_api.g_number) <> hr_api.g_number then
390: for bus_gp in c_bus_gp(p_to_position_id) loop
391: l_bus_gp := bus_gp.business_group_id;
392: end loop;
393: hr_utility.set_location(l_proc, 15);

Line 405: l_agency_code := ghr_api.get_position_agency_code_pos

401: l_agency_code := p_parei.rei_information10;
402: end LOOP;
403: -- Bug 3451929
404: IF l_agency_code is NULL then
405: l_agency_code := ghr_api.get_position_agency_code_pos
406: (p_position_id => p_to_position_id,
407: p_business_group_id => l_bus_gp,
408: p_effective_date => p_effective_date
409: );

Line 413: l_agency_code := ghr_api.get_position_agency_code_pos

409: );
410: END IF;
411: -- End of bug 3451929
412: else
413: l_agency_code := ghr_api.get_position_agency_code_pos
414: (p_position_id => p_to_position_id,
415: p_business_group_id => l_bus_gp,
416: p_effective_date => p_effective_date
417: );

Line 449: if nvl(p_from_position_id,hr_api.g_number) <> hr_api.g_number then

445:
446: End if;
447:
448: -- personnel_office_id and from_office_symbol
449: if nvl(p_from_position_id,hr_api.g_number) <> hr_api.g_number then
450: -- Bug#4005843 Added the IF condition.
451: IF l_noa_code = '790' THEN
452: hr_utility.set_location('NOA Code is 790',20);
453: -- Bug#4344353 added the following code to get rid of ora-1841

Line 454: IF p_effective_date = hr_api.g_date THEN

450: -- Bug#4005843 Added the IF condition.
451: IF l_noa_code = '790' THEN
452: hr_utility.set_location('NOA Code is 790',20);
453: -- Bug#4344353 added the following code to get rid of ora-1841
454: IF p_effective_date = hr_api.g_date THEN
455: l_effective_date := trunc(sysdate) - 1;
456: ELSE
457: l_effective_date := p_effective_date - 1;
458: END IF;

Line 477: l_from_agency_code := ghr_api.get_position_agency_code_pos

473:
474: for bus_gp in c_bus_gp(p_from_position_id) loop
475: l_bus_gp := bus_gp.business_group_id;
476: end loop;
477: l_from_agency_code := ghr_api.get_position_agency_code_pos
478: (p_position_id => p_from_position_id,
479: p_business_group_id => l_bus_gp,
480: p_effective_date => p_effective_date
481: );