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 386: if nvl(p_to_position_id,hr_api.g_number) <> hr_api.g_number then

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

Line 402: l_agency_code := ghr_api.get_position_agency_code_pos

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

Line 410: l_agency_code := ghr_api.get_position_agency_code_pos

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

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

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

Line 451: IF p_effective_date = hr_api.g_date THEN

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

Line 474: l_from_agency_code := ghr_api.get_position_agency_code_pos

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