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_API dependencies on PER_ALL_POSITIONS

Line 1929: l_business_group_id per_all_positions.business_group_id%type;

1925: ) return varchar2 is
1926: --
1927: l_proc varchar2(72) := g_package||'get_position_title';
1928: l_effective_date date;
1929: l_business_group_id per_all_positions.business_group_id%type;
1930: l_position_id per_all_positions.position_id%type;
1931: l_segment_rec org_info_rec_type;
1932: l_segment per_position_definitions.segment1%type;
1933: l_asg_pos_by_per_id_found boolean := FALSE;

Line 1930: l_position_id per_all_positions.position_id%type;

1926: --
1927: l_proc varchar2(72) := g_package||'get_position_title';
1928: l_effective_date date;
1929: l_business_group_id per_all_positions.business_group_id%type;
1930: l_position_id per_all_positions.position_id%type;
1931: l_segment_rec org_info_rec_type;
1932: l_segment per_position_definitions.segment1%type;
1933: l_asg_pos_by_per_id_found boolean := FALSE;
1934: l_asg_pos_by_asg_id_found boolean := FALSE;

Line 2011: (p_position_id in per_all_positions.position_id%type

2007: -- |--------------------------< get_position_title_pos >----------------------|
2008: -- ---------------------------------------------------------------------------
2009: --
2010: function get_position_title_pos
2011: (p_position_id in per_all_positions.position_id%type
2012: ,p_business_group_id in per_all_positions.business_group_id%type
2013: ,p_effective_date in date default sysdate
2014: ) return varchar2 IS
2015: --

Line 2012: ,p_business_group_id in per_all_positions.business_group_id%type

2008: -- ---------------------------------------------------------------------------
2009: --
2010: function get_position_title_pos
2011: (p_position_id in per_all_positions.position_id%type
2012: ,p_business_group_id in per_all_positions.business_group_id%type
2013: ,p_effective_date in date default sysdate
2014: ) return varchar2 IS
2015: --
2016: l_proc varchar2(72) := g_package||'get_position_title_pos';

Line 2064: l_business_group_id per_all_positions.business_group_id%type;

2060: ) return varchar2 is
2061: --
2062: l_proc varchar2(72) := g_package||'get_position_description_no';
2063: l_effective_date date;
2064: l_business_group_id per_all_positions.business_group_id%type;
2065: l_position_id per_all_positions.position_id%type;
2066: l_segment_rec org_info_rec_type;
2067: l_segment per_position_definitions.segment1%type;
2068: l_asg_pos_by_per_id_found boolean := FALSE;

Line 2065: l_position_id per_all_positions.position_id%type;

2061: --
2062: l_proc varchar2(72) := g_package||'get_position_description_no';
2063: l_effective_date date;
2064: l_business_group_id per_all_positions.business_group_id%type;
2065: l_position_id per_all_positions.position_id%type;
2066: l_segment_rec org_info_rec_type;
2067: l_segment per_position_definitions.segment1%type;
2068: l_asg_pos_by_per_id_found boolean := FALSE;
2069: l_asg_pos_by_asg_id_found boolean := FALSE;

Line 2148: (p_position_id in per_all_positions.position_id%type

2144: -- |--------------------------< get_position_desc_no_pos >----------------------|
2145: -- ---------------------------------------------------------------------------
2146: --
2147: function get_position_desc_no_pos
2148: (p_position_id in per_all_positions.position_id%type
2149: ,p_business_group_id in per_all_positions.business_group_id%type
2150: ,p_effective_date in date default sysdate
2151: ) return varchar2 IS
2152: --

Line 2149: ,p_business_group_id in per_all_positions.business_group_id%type

2145: -- ---------------------------------------------------------------------------
2146: --
2147: function get_position_desc_no_pos
2148: (p_position_id in per_all_positions.position_id%type
2149: ,p_business_group_id in per_all_positions.business_group_id%type
2150: ,p_effective_date in date default sysdate
2151: ) return varchar2 IS
2152: --
2153: l_proc varchar2(72) := g_package||'get_position_desc_no_pos';

Line 2201: l_business_group_id per_all_positions.business_group_id%type;

2197: ) return varchar2 is
2198: --
2199: l_proc varchar2(72) := g_package||'get_position_sequence_no';
2200: l_effective_date date;
2201: l_business_group_id per_all_positions.business_group_id%type;
2202: l_position_id per_all_positions.position_id%type;
2203: l_segment_rec org_info_rec_type;
2204: l_segment per_position_definitions.segment1%type;
2205: l_asg_pos_by_per_id_found boolean := FALSE;

Line 2202: l_position_id per_all_positions.position_id%type;

2198: --
2199: l_proc varchar2(72) := g_package||'get_position_sequence_no';
2200: l_effective_date date;
2201: l_business_group_id per_all_positions.business_group_id%type;
2202: l_position_id per_all_positions.position_id%type;
2203: l_segment_rec org_info_rec_type;
2204: l_segment per_position_definitions.segment1%type;
2205: l_asg_pos_by_per_id_found boolean := FALSE;
2206: l_asg_pos_by_asg_id_found boolean := FALSE;

Line 2285: (p_position_id in per_all_positions.position_id%type

2281: -- |--------------------------< get_position_sequence_no_pos >----------------|
2282: -- ---------------------------------------------------------------------------
2283: --
2284: function get_position_sequence_no_pos
2285: (p_position_id in per_all_positions.position_id%type
2286: ,p_business_group_id in per_all_positions.business_group_id%type
2287: ,p_effective_date in date default sysdate
2288: ) return varchar2 IS
2289: --

Line 2286: ,p_business_group_id in per_all_positions.business_group_id%type

2282: -- ---------------------------------------------------------------------------
2283: --
2284: function get_position_sequence_no_pos
2285: (p_position_id in per_all_positions.position_id%type
2286: ,p_business_group_id in per_all_positions.business_group_id%type
2287: ,p_effective_date in date default sysdate
2288: ) return varchar2 IS
2289: --
2290: l_proc varchar2(72) := g_package||'get_position_desc_no_pos';

Line 2338: l_business_group_id per_all_positions.business_group_id%type;

2334: ) return varchar2 is
2335: --
2336: l_proc varchar2(72) := g_package||'get_position_agency_code';
2337: l_effective_date date;
2338: l_business_group_id per_all_positions.business_group_id%type;
2339: l_position_id per_all_positions.position_id%type;
2340: l_segment_rec org_info_rec_type;
2341: l_segment per_position_definitions.segment1%type;
2342: l_asg_pos_by_per_id_found boolean := FALSE;

Line 2339: l_position_id per_all_positions.position_id%type;

2335: --
2336: l_proc varchar2(72) := g_package||'get_position_agency_code';
2337: l_effective_date date;
2338: l_business_group_id per_all_positions.business_group_id%type;
2339: l_position_id per_all_positions.position_id%type;
2340: l_segment_rec org_info_rec_type;
2341: l_segment per_position_definitions.segment1%type;
2342: l_asg_pos_by_per_id_found boolean := FALSE;
2343: l_asg_pos_by_asg_id_found boolean := FALSE;

Line 2422: (p_position_id in per_all_positions.position_id%type

2418: -- |--------------------------< get_position_agency_code_pos >----------------|
2419: -- ---------------------------------------------------------------------------
2420: --
2421: function get_position_agency_code_pos
2422: (p_position_id in per_all_positions.position_id%type
2423: ,p_business_group_id in per_all_positions.business_group_id%type
2424: ,p_effective_date in date default sysdate
2425: ) return varchar2 IS
2426: --

Line 2423: ,p_business_group_id in per_all_positions.business_group_id%type

2419: -- ---------------------------------------------------------------------------
2420: --
2421: function get_position_agency_code_pos
2422: (p_position_id in per_all_positions.position_id%type
2423: ,p_business_group_id in per_all_positions.business_group_id%type
2424: ,p_effective_date in date default sysdate
2425: ) return varchar2 IS
2426: --
2427: l_proc varchar2(72) := g_package||'get_position_agency_code_pos';

Line 2475: l_business_group_id per_all_positions.business_group_id%type;

2471: ) return varchar2 is
2472: --
2473: l_proc varchar2(72) := g_package||'get_job_occupational_series';
2474: l_effective_date date;
2475: l_business_group_id per_all_positions.business_group_id%type;
2476: l_job_id per_jobs.job_id%type;
2477: l_segment_rec org_info_rec_type;
2478: l_segment per_position_definitions.segment1%type;
2479: l_asg_job_by_per_id_found boolean := FALSE;

Line 2560: ,p_business_group_id in per_all_positions.business_group_id%type

2556: -- ---------------------------------------------------------------------------
2557: --
2558: function get_job_occ_series_job
2559: (p_job_id in per_jobs.job_id%type
2560: ,p_business_group_id in per_all_positions.business_group_id%type
2561: ) return varchar2 IS
2562: --
2563: l_proc varchar2(72) := g_package||'get_job_occ_series_job';
2564: l_segment_rec org_info_rec_type;

Line 2647: ,p_position_id OUT NOCOPY per_all_positions.position_id%type

2643: ,p_position_org_line3 OUT NOCOPY varchar2
2644: ,p_position_org_line4 OUT NOCOPY varchar2
2645: ,p_position_org_line5 OUT NOCOPY varchar2
2646: ,p_position_org_line6 OUT NOCOPY varchar2
2647: ,p_position_id OUT NOCOPY per_all_positions.position_id%type
2648: ,p_duty_station_location_id OUT NOCOPY hr_locations.location_id%type -- duty_station_location_id
2649: ,p_pay_rate_determinant OUT NOCOPY varchar2
2650: ,p_work_schedule OUT NOCOPY varchar2
2651: ) is

Line 2655: l_position_id per_all_positions.position_id%type;

2651: ) is
2652: --
2653: l_proc varchar2(72) := g_package||'sf52_from_by_assignment';
2654: l_organization_id hr_organization_units.organization_id%type;
2655: l_position_id per_all_positions.position_id%type;
2656: l_job_id per_jobs.job_id%type;
2657: l_grade_id per_grades.grade_id%type;
2658: l_location_id hr_locations.location_id%type;
2659: l_total_salary number;