DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on GHR_NATURE_OF_ACTIONS

Line 2498: (p_noa_code in ghr_nature_of_actions.code%type,

2494: -- Function get_asg_status_type
2495: -- ********************************
2496: --- Bug# 4672772 added Parameter p_assignment_id
2497: Procedure get_asg_status_type
2498: (p_noa_code in ghr_nature_of_actions.code%type,
2499: p_business_group_id in per_people_f.business_group_id%type,
2500: p_assignment_id in number,
2501: p_pa_request_id in ghr_pa_requests.pa_request_id%type, --Bug# 8724192
2502: p_status_type_id out nocopy per_assignment_status_types.assignment_status_type_id%type,

Line 3045: l_noa_code ghr_nature_of_actions.code%type;

3041: procedure Process_Family
3042: (P_PA_REQUEST_REC IN OUT NOCOPY GHR_PA_REQUESTS%ROWTYPE,
3043: P_AGENCY_CODE IN varchar2 ) is
3044:
3045: l_noa_code ghr_nature_of_actions.code%type;
3046: --
3047: l_pa_request_rec ghr_pa_requests%rowtype;
3048: l_proc varchar2(70) := 'Process_family';
3049: l_hr_person_api_update varchar2(1) := 'N';