[Home] [Help]
41: -- This procedure retrieve data from HR extra information tables and all other data required for CPDF Validations
42: --
43: Procedure populate_record_groups
44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
130: -- Cursor to select the Payrollname ,as entered by the user from the SF52 Extra Information.
131:
132: Cursor c_payroll_name is
133: select rei_information3 payroll_name
134: from ghr_pa_request_extra_info
135: where pa_request_id = p_pa_request_rec.pa_request_id
136: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
137:
138: -- Cursor to select the Rating Details of the person, required for CPDFs and for update to HR
154: rei_information16 appr_sys_ident,
155: rei_information17 optional_info,
156: rei_information18 performance_rating_points,
157: rei_information19 app_starts
158: from ghr_pa_request_extra_info
159: where pa_request_id = p_pa_request_rec.pa_request_id
160: and information_type = 'GHR_US_PAR_PERF_APPRAISAL';
161:
162: -- cursor to select the Conduct Performace of the person. (is it required for CPDFs??, sureis required for the reqd_Check)
853: WHERE par.pa_request_id = c_request_id;
854:
855: CURSOR c2 (c_request_id number) is
856: SELECT par.pa_request_id, par.altered_pa_request_id, pei.rei_information3
857: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei
858: WHERE par.pa_request_id = pei.pa_request_id
859: AND pei.pa_request_id = c_request_id
860: AND pei.information_type = 'GHR_US_PAR_TERM_RET_GRADE';
861:
1572: pos.effective_start_date and pos.effective_end_date;
1573:
1574: Cursor c_pa_request_extra_info (l_information_type varchar2) is
1575: Select *
1576: from ghr_pa_request_extra_info
1577: where pa_request_id = p_pa_request_rec.pa_request_id
1578: and information_type = l_information_type;
1579:
1580: --
1666: and ppf.effective_end_date;
1667:
1668: /*Cursor c_pa_request_extra_info (l_information_type varchar2) is
1669: Select rei_information4,rei_information8
1670: from ghr_pa_request_extra_info
1671: where pa_request_id = p_pa_request_rec.pa_request_id
1672: and information_type = l_information_type; */
1673: --
1674: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;
1670: from ghr_pa_request_extra_info
1671: where pa_request_id = p_pa_request_rec.pa_request_id
1672: and information_type = l_information_type; */
1673: --
1674: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;
1675: l_pos_org ghr_pa_request_extra_info.rei_information8%type;*/
1676: l_student_loan_repay ghr_api.student_loan_repay_type;
1677:
1678: --Bug 6881863
1671: where pa_request_id = p_pa_request_rec.pa_request_id
1672: and information_type = l_information_type; */
1673: --
1674: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;
1675: l_pos_org ghr_pa_request_extra_info.rei_information8%type;*/
1676: l_student_loan_repay ghr_api.student_loan_repay_type;
1677:
1678: --Bug 6881863
1679: l_calc_table_id pay_user_tables.user_table_id%type;
2086: --
2087: PROCEDURE Process_Non_Sf52_Extra_Info
2088: --
2089: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2090: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2150: l_proc varchar2(70) := 'Process_non_sf52_extra_info';
2151: l_noa_code ghr_nature_of_actions.code%type;
2152: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
2153: l_information_type ghr_pa_request_info_types.information_type%type;
2154: l_pa_request_ei_rec ghr_pa_request_extra_info%rowtype;
2155: p_extra_info_agency_rec ghr_api.extra_info_rec_type;
2156: l_session ghr_history_api.g_session_var_type;
2157: l_multiple_error_flag boolean;
2158: -- Bug#5668878
2175: AND NVL(nfa.end_date_active,p_pa_request_rec.effective_date);
2176: --
2177: Cursor c_pa_request_extra_info is
2178: Select *
2179: from ghr_pa_request_extra_info
2180: where pa_request_id = p_pa_request_rec.pa_request_id
2181: and information_type = l_information_type;
2182: -- Bug 3260890
2183: l_office_symbol per_position_extra_info.poei_information4%type := p_pos_grp1.office_symbol;
2184: l_organization_structure_id per_position_extra_info.poei_information5%type := p_pos_grp1.organization_structure_id;
2185: l_positions_organization per_position_extra_info.poei_information21%type := p_pos_grp1.positions_organization;
2186: l_organization_function_code per_position_extra_info.poei_information4%type := p_pos_grp2.organization_function_code;
2187: l_personnel_office_id per_position_extra_info.poei_information3%type := p_pos_grp1.personnel_office_id;
2188: l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type := p_pos_grp1.payroll_office_id;
2189: -- End Bug 3260890
2190:
2191: -- Bug# 4672772 Begin
2192:
3252: Function fetch_extra_info_id (p_request_id number)
3253: return number is
3254: CURSOR c2 (c_request_id number) is
3255: SELECT par.pa_request_id, par.altered_pa_request_id, pei.rei_information3
3256: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei
3257: WHERE par.pa_request_id = pei.pa_request_id(+)
3258: AND pei.pa_request_id = c_request_id
3259: AND pei.information_type = 'GHR_US_PAR_TERM_RET_GRADE';
3260: