[Home] [Help]
286: END get_remark_descriptor;
287:
288: -- Bug#5482191 Added the function get_personnel_system_indicator
289: FUNCTION get_personnel_system_indicator(
290: p_position_id hr_all_positions_f.position_id%TYPE
291: ,p_effective_date date)
292: RETURN VARCHAR2 IS
293: l_pos_psi_data per_position_extra_info%rowtype;
294: l_personnel_system_indicator VARCHAR2(30);
809:
810: END get_SF52_asg_ddf_details;
811:
812: --vsm
813: PROCEDURE get_SF52_pos_ddf_details (p_position_id IN hr_all_positions_f.position_id%TYPE
814: ,p_date_Effective IN date default sysdate
815: ,p_flsa_category OUT NOCOPY varchar2
816: ,p_bargaining_unit_status OUT NOCOPY varchar2
817: ,p_work_schedule OUT NOCOPY varchar2
955:
956: END get_address_details;
957:
958: PROCEDURE get_SF52_to_data_elements
959: (p_position_id IN hr_all_positions_f.position_id%TYPE
960: ,p_effective_date IN date default sysdate
961: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
962: ,p_grade_id IN OUT NOCOPY number
963: ,p_job_id IN OUT NOCOPY number
975: ,p_position_org_line6 OUT NOCOPY varchar2
976: ,p_duty_station_id OUT NOCOPY number
977: ) IS
978: --
979: l_business_group_id hr_all_positions_f.business_group_id%type;
980: l_pos_ei_grade_data per_position_extra_info%rowtype;
981: l_pos_ei_grp1_data per_position_extra_info%rowtype;
982:
983: l_pos_organization_id hr_organization_information.organization_id%TYPE;
1006: SELECT pos.job_id
1007: ,pos.business_group_id
1008: ,pos.organization_id
1009: ,pos.location_id
1010: FROM hr_all_positions_f pos -- Venkat -- Position DT
1011: WHERE pos.position_id = p_position_id
1012: and p_effective_date between pos.effective_start_date
1013: and pos.effective_end_date ;
1014: --
1952: ) RETURN varchar2 IS
1953:
1954:
1955: l_proc varchar2(72) := 'get_position_work_title';
1956: l_position_id hr_all_positions_f.position_id%type;
1957: l_pos_ei_data per_position_extra_info%rowtype;
1958: l_title varchar2(150);
1959:
1960: CURSOR c_per_pos is