APPS.GHR_WF_WGI_PKG dependencies on GHR_PA_REQUESTS_PKG

Line 513: ghr_pa_requests_pkg.get_SF52_pos_ddf_details

509: AND poi.personnel_office_id = nvl(l_personnel_office_id,-99999999);
510: --
511: begin
512: --
513: ghr_pa_requests_pkg.get_SF52_pos_ddf_details
514: (p_position_id => p_position_id
515: ,p_date_effective => trunc(p_effective_date)
516: ,p_flsa_category => l_flsa_category
517: ,p_bargaining_unit_status => l_bargaining_unit_status

Line 1669: l_approving_official_full_name := ghr_pa_requests_pkg.get_full_name_fml (p_gbx_user_id);

1665: l_i_groupbox_id := p_groupbox_id;
1666: -- Get the Electronic Auth. values
1667: l_u_approval_status := 'APPROVE';
1668: l_approval_date := sysdate;
1669: l_approving_official_full_name := ghr_pa_requests_pkg.get_full_name_fml (p_gbx_user_id);
1670: l_approving_official_work_titl :=
1671: ghr_pa_requests_pkg.get_position_work_title (p_person_id => TO_CHAR(p_gbx_user_id));
1672: end if;
1673: -- Set Request Number

Line 1671: ghr_pa_requests_pkg.get_position_work_title (p_person_id => TO_CHAR(p_gbx_user_id));

1667: l_u_approval_status := 'APPROVE';
1668: l_approval_date := sysdate;
1669: l_approving_official_full_name := ghr_pa_requests_pkg.get_full_name_fml (p_gbx_user_id);
1670: l_approving_official_work_titl :=
1671: ghr_pa_requests_pkg.get_position_work_title (p_person_id => TO_CHAR(p_gbx_user_id));
1672: end if;
1673: -- Set Request Number
1674: l_request_number := 'WGI:' || p_pa_request_id;
1675: ghr_sf52_api.update_sf52(