eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PA_REQUESTS_PKG dependencies on HR_ALL_POSITIONS_F

Line 290: p_position_id hr_all_positions_f.position_id%TYPE

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);

Line 813: PROCEDURE get_SF52_pos_ddf_details (p_position_id IN hr_all_positions_f.position_id%TYPE

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

Line 959: (p_position_id IN hr_all_positions_f.position_id%TYPE

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

Line 979: l_business_group_id hr_all_positions_f.business_group_id%type;

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;

Line 1010: FROM hr_all_positions_f pos -- Venkat -- Position DT

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: --

Line 1956: l_position_id hr_all_positions_f.position_id%type;

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

Line 2263: FUNCTION get_flsa_category(p_position_id in hr_all_positions_f.position_id%TYPE,

2259: END IF;
2260: END temp_step_true;
2261:
2262: --Begin bug# 8653508
2263: FUNCTION get_flsa_category(p_position_id in hr_all_positions_f.position_id%TYPE,
2264: p_effective_date in date default sysdate
2265: ) RETURN varchar2 IS
2266:
2267:

Line 2289: FUNCTION get_bargaining_unit(p_position_id in hr_all_positions_f.position_id%TYPE,

2285: return(l_flsa);
2286:
2287: End get_flsa_category;
2288:
2289: FUNCTION get_bargaining_unit(p_position_id in hr_all_positions_f.position_id%TYPE,
2290: p_effective_date in date default sysdate
2291: ) RETURN varchar2 IS
2292:
2293:

Line 2315: FUNCTION get_work_schedule(p_position_id in hr_all_positions_f.position_id%TYPE,

2311: return(l_bargaining_unit);
2312:
2313: End get_bargaining_unit;
2314:
2315: FUNCTION get_work_schedule(p_position_id in hr_all_positions_f.position_id%TYPE,
2316: p_effective_date in date default sysdate
2317: ) RETURN varchar2 IS
2318:
2319:

Line 2342: FUNCTION get_valid_grade(p_position_id in hr_all_positions_f.position_id%TYPE,

2338:
2339: End get_work_schedule;
2340:
2341:
2342: FUNCTION get_valid_grade(p_position_id in hr_all_positions_f.position_id%TYPE,
2343: p_effective_date in date default sysdate
2344: ) RETURN varchar2 IS
2345:
2346:

Line 2376: FUNCTION get_duty_station(p_position_id in hr_all_positions_f.position_id%TYPE,

2372: return(l_valid_grade);
2373:
2374: End get_valid_grade;
2375:
2376: FUNCTION get_duty_station(p_position_id in hr_all_positions_f.position_id%TYPE,
2377: p_effective_date in date default sysdate
2378: ) RETURN varchar2 IS
2379:
2380:

Line 2383: l_location_id hr_all_positions_f.location_id%type;

2379:
2380:
2381: l_proc varchar2(72) := 'get_duty_station';
2382: l_duty_station ghr_duty_stations_v.duty_station_code%type;
2383: l_location_id hr_all_positions_f.location_id%type;
2384:
2385: CURSOR get_loc_id IS
2386: SELECT location_id
2387: FROM hr_all_positions_f

Line 2387: FROM hr_all_positions_f

2383: l_location_id hr_all_positions_f.location_id%type;
2384:
2385: CURSOR get_loc_id IS
2386: SELECT location_id
2387: FROM hr_all_positions_f
2388: WHERE position_id = p_position_id
2389: and p_effective_date between
2390: effective_start_date and effective_end_date;
2391:

Line 2420: FUNCTION get_occ_series(p_position_id in hr_all_positions_f.position_id%TYPE,

2416: return(l_duty_station);
2417:
2418: End get_duty_station;
2419:
2420: FUNCTION get_occ_series(p_position_id in hr_all_positions_f.position_id%TYPE,
2421: p_effective_date in date default sysdate,
2422: p_business_group_id in per_assignments_f.business_group_id%type
2423: ) RETURN varchar2 IS
2424:

Line 2428: l_job_id hr_all_positions_f.location_id%type;

2424:
2425:
2426: l_proc varchar2(72) := 'get_occ_series';
2427: l_occ_series varchar2(150);
2428: l_job_id hr_all_positions_f.location_id%type;
2429:
2430: CURSOR get_job_id IS
2431: SELECT pos.job_id
2432: FROM hr_all_positions_f pos

Line 2432: FROM hr_all_positions_f pos

2428: l_job_id hr_all_positions_f.location_id%type;
2429:
2430: CURSOR get_job_id IS
2431: SELECT pos.job_id
2432: FROM hr_all_positions_f pos
2433: WHERE pos.position_id = p_position_id
2434: AND p_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;
2435:
2436: BEGIN

Line 2452: p_position_id hr_all_positions_f.position_id%TYPE

2448:
2449: End get_occ_series;
2450:
2451: FUNCTION get_appropriation_code(
2452: p_position_id hr_all_positions_f.position_id%TYPE
2453: ,p_effective_date date default sysdate) RETURN VARCHAR2 IS
2454:
2455:
2456: l_proc varchar2(72) := 'get_appropriation_code';

Line 2474: FUNCTION get_pos_organization( p_position_id hr_all_positions_f.position_id%TYPE

2470: return(l_pos_ei_grp2_data.poei_information13);
2471:
2472: END get_appropriation_code;
2473: --Begin 9647383
2474: FUNCTION get_pos_organization( p_position_id hr_all_positions_f.position_id%TYPE
2475: ,p_effective_date date default sysdate
2476: ,p_business_group_id in per_assignments_f.business_group_id%type)
2477: RETURN VARCHAR2 IS
2478: