[Home] [Help]
141:
142: l_adj_bp ghr_pa_requests.from_adj_basic_pay%type;
143: l_pay_cap_amount ghr_pa_requests.from_adj_basic_pay%type;
144: l_create_rmk BOOLEAN:=FALSE;
145: l_remark_id ghr_pa_remarks.pa_remark_id%type;
146: l_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type;
147: l_loc_perc ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
148: --Begin Bug 10387022
149: l_rpa_type ghr_pa_requests.rpa_type%type;
174: PROCEDURE Create_Remark(p_remark_code in ghr_remarks.code%TYPE,
175: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE)
176: IS
177: l_remark_id ghr_remarks.remark_id%TYPE;
178: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
179: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
180: l_remark_desc ghr_remarks.description%TYPE;
181: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
182: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
175: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE)
176: IS
177: l_remark_id ghr_remarks.remark_id%TYPE;
178: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
179: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
180: l_remark_desc ghr_remarks.description%TYPE;
181: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
182: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
183: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
177: l_remark_id ghr_remarks.remark_id%TYPE;
178: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
179: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
180: l_remark_desc ghr_remarks.description%TYPE;
181: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
182: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
183: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
184: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
185: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
178: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
179: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
180: l_remark_desc ghr_remarks.description%TYPE;
181: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
182: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
183: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
184: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
185: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
186: --Pradeep added for the Bug#3974979.
179: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
180: l_remark_desc ghr_remarks.description%TYPE;
181: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
182: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
183: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
184: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
185: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
186: --Pradeep added for the Bug#3974979.
187: l_remark_desc_out ghr_remarks.description%TYPE;
180: l_remark_desc ghr_remarks.description%TYPE;
181: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
182: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
183: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
184: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
185: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
186: --Pradeep added for the Bug#3974979.
187: l_remark_desc_out ghr_remarks.description%TYPE;
188:
181: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
182: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
183: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
184: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
185: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
186: --Pradeep added for the Bug#3974979.
187: l_remark_desc_out ghr_remarks.description%TYPE;
188:
189: BEGIN
251: );
252: l_remark_desc := l_remark_desc_out;
253:
254: END IF;
255: ghr_pa_remarks_api.create_pa_remarks
256: (p_pa_request_id => p_pa_request_id,
257: p_remark_id => l_remark_id,
258: p_description => l_remark_desc,
259: p_remark_code_information1 => l_remark_information1,