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_ASSIGNMENTS_F

Line 99: ,p_assignment_id in per_assignments_f.assignment_id%type default null

95: -- ---------------------------------------------------------------------------
96: --
97: procedure retrieve_business_group_id
98: (p_person_id in per_people_f.person_id%type default null
99: ,p_assignment_id in per_assignments_f.assignment_id%type default null
100: ,p_effective_date in date default sysdate
101: ,p_business_group_id OUT NOCOPY per_business_groups.business_group_id%type
102: ) is
103: --

Line 175: ,p_assignment_id in per_assignments_f.assignment_id%type default null

171: -- retrieve_business_group_id overloaded to cater to refresh for the correction of SF52.
172: -- vsm
173: procedure retrieve_business_group_id
174: (p_person_id in per_people_f.person_id%type default null
175: ,p_assignment_id in per_assignments_f.assignment_id%type default null
176: ,p_effective_date in date default sysdate
177: ,p_altered_pa_request_id in number
178: ,p_pa_history_id in number
179: ,p_noa_id_corrected in number

Line 1742: from per_assignments_f

1738: --
1739: --
1740: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
1741: Select distinct business_group_id bg
1742: from per_assignments_f
1743: where assignment_id = p_assignment_id
1744: and p_eff_date between effective_start_date
1745: and effective_end_date;
1746:

Line 1923: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

1919: -- ---------------------------------------------------------------------------
1920: --
1921: function get_position_title
1922: (p_person_id in per_people_f.person_id%type default NULL
1923: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1924: ,p_effective_date in date default sysdate
1925: ) return varchar2 is
1926: --
1927: l_proc varchar2(72) := g_package||'get_position_title';

Line 2058: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

2054: -- ---------------------------------------------------------------------------
2055: --
2056: function get_position_description_no
2057: (p_person_id in per_people_f.person_id%type default NULL
2058: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
2059: ,p_effective_date in date default sysdate
2060: ) return varchar2 is
2061: --
2062: l_proc varchar2(72) := g_package||'get_position_description_no';

Line 2195: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

2191: -- ---------------------------------------------------------------------------
2192: --
2193: function get_position_sequence_no
2194: (p_person_id in per_people_f.person_id%type default NULL
2195: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
2196: ,p_effective_date in date default sysdate
2197: ) return varchar2 is
2198: --
2199: l_proc varchar2(72) := g_package||'get_position_sequence_no';

Line 2332: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

2328: -- ---------------------------------------------------------------------------
2329: --
2330: function get_position_agency_code
2331: (p_person_id in per_people_f.person_id%type default NULL
2332: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
2333: ,p_effective_date in date default sysdate
2334: ) return varchar2 is
2335: --
2336: l_proc varchar2(72) := g_package||'get_position_agency_code';

Line 2469: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

2465: -- ---------------------------------------------------------------------------
2466: --
2467: function get_job_occupational_series
2468: (p_person_id in per_people_f.person_id%type default NULL
2469: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
2470: ,p_effective_date in date default sysdate
2471: ) return varchar2 is
2472: --
2473: l_proc varchar2(72) := g_package||'get_job_occupational_series';

Line 2605: ,p_assignment_id IN OUT NOCOPY per_assignments_f.assignment_id%type

2601: -- ---------------------------------------------------------------------------
2602: --
2603: procedure sf52_from_data_elements
2604: (p_person_id in per_people_f.person_id%type default NULL
2605: ,p_assignment_id IN OUT NOCOPY per_assignments_f.assignment_id%type
2606: ,p_effective_date in date default sysdate
2607: -- vsm added following 2 parameters
2608: ,p_altered_pa_request_id in number
2609: ,p_noa_id_corrected in number

Line 2693: l_assignment_id per_assignments_f.assignment_id%type;

2689: l_result_code varchar2(30);
2690: l_assignment_data per_all_assignments_f%rowtype;
2691: l_person_type per_person_types.system_person_type%type;
2692: l_effective_date date;
2693: l_assignment_id per_assignments_f.assignment_id%type;
2694: v_assignment_id per_assignments_f.assignment_id%type;
2695: l_session ghr_history_api.g_session_var_type;
2696: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2697: l_retained_grade ghr_pay_calc.retained_grade_rec_type;

Line 2694: v_assignment_id per_assignments_f.assignment_id%type;

2690: l_assignment_data per_all_assignments_f%rowtype;
2691: l_person_type per_person_types.system_person_type%type;
2692: l_effective_date date;
2693: l_assignment_id per_assignments_f.assignment_id%type;
2694: v_assignment_id per_assignments_f.assignment_id%type;
2695: l_session ghr_history_api.g_session_var_type;
2696: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2697: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
2698: l_update34_date date;