APPS.GHR_LACS_REMARKS dependencies on GHR_REMARKS

Line 174: PROCEDURE Create_Remark(p_remark_code in ghr_remarks.code%TYPE,

170: FROM ghr_locality_pay_areas_f
171: WHERE locality_pay_area_id = p_ds_loc_area_id
172: AND p_eff_date between effective_start_date and effective_end_date;
173:
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;

Line 177: l_remark_id ghr_remarks.remark_id%TYPE;

173:
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;

Line 180: l_remark_desc ghr_remarks.description%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;
184: l_remark_information4 ghr_pa_remarks.remark_code_information4%TYPE;

Line 187: l_remark_desc_out ghr_remarks.description%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
190: l_location := 'Apply_894_Rules:Create_Remark(' || p_remark_code || ')';
191: ghr_mass_actions_pkg.get_remark_id_desc