DBA Data[Home] [Help]

APPS.GHR_LACS_REMARKS dependencies on GHR_PA_REMARKS

Line 145: l_remark_id ghr_pa_remarks.pa_remark_id%type;

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:
149: CURSOR cur_loc_area_id(p_ds_id ghr_duty_Stations_f.duty_station_id%type,

Line 170: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;

166: PROCEDURE Create_Remark(p_remark_code in ghr_remarks.code%TYPE,
167: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE)
168: IS
169: l_remark_id ghr_remarks.remark_id%TYPE;
170: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
171: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
172: l_remark_desc ghr_remarks.description%TYPE;
173: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
174: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;

Line 171: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;

167: p_out_step_or_rate GHR_PA_REQUESTS.TO_STEP_OR_RATE%TYPE)
168: IS
169: l_remark_id ghr_remarks.remark_id%TYPE;
170: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
171: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
172: l_remark_desc ghr_remarks.description%TYPE;
173: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
174: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
175: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;

Line 173: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;

169: l_remark_id ghr_remarks.remark_id%TYPE;
170: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
171: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
172: l_remark_desc ghr_remarks.description%TYPE;
173: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
174: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
175: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
176: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
177: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;

Line 174: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;

170: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
171: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
172: l_remark_desc ghr_remarks.description%TYPE;
173: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
174: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
175: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
176: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
177: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
178: --Pradeep added for the Bug#3974979.

Line 175: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;

171: l_object_version_nbr ghr_pa_remarks.object_version_number%TYPE;
172: l_remark_desc ghr_remarks.description%TYPE;
173: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
174: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
175: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
176: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
177: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
178: --Pradeep added for the Bug#3974979.
179: l_remark_desc_out ghr_remarks.description%TYPE;

Line 176: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;

172: l_remark_desc ghr_remarks.description%TYPE;
173: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
174: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
175: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
176: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
177: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
178: --Pradeep added for the Bug#3974979.
179: l_remark_desc_out ghr_remarks.description%TYPE;
180:

Line 177: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;

173: l_remark_information1 ghr_pa_remarks.remark_code_information1%TYPE;
174: l_remark_information2 ghr_pa_remarks.remark_code_information2%TYPE;
175: l_remark_information3 ghr_pa_remarks.remark_code_information3%TYPE;
176: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;
177: l_remark_information5 ghr_pa_remarks.remark_code_information5%TYPE;
178: --Pradeep added for the Bug#3974979.
179: l_remark_desc_out ghr_remarks.description%TYPE;
180:
181: BEGIN

Line 247: ghr_pa_remarks_api.create_pa_remarks

243: );
244: l_remark_desc := l_remark_desc_out;
245:
246: END IF;
247: ghr_pa_remarks_api.create_pa_remarks
248: (p_pa_request_id => p_pa_request_id,
249: p_remark_id => l_remark_id,
250: p_description => l_remark_desc,
251: p_remark_code_information1 => l_remark_information1,