APPS.GHR_LACS_REMARKS dependencies on GHR_REMARKS

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

162: FROM ghr_locality_pay_areas_f
163: WHERE locality_pay_area_id = p_ds_loc_area_id
164: AND p_eff_date between effective_start_date and effective_end_date;
165:
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;

Line 169: l_remark_id ghr_remarks.remark_id%TYPE;

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

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

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