APPS.GHR_MLC_PKG dependencies on GHR_PA_REMARKS

Line 4982: select * from ghr_pa_remarks

4978:
4979: l_proc varchar2(72) := g_package || '.create_lac_remarks';
4980:
4981: cursor cur_pa_rem_cur is
4982: select * from ghr_pa_remarks
4983: where pa_request_id = p_pa_request_id;
4984:
4985: l_remarks_rec ghr_pa_remarks%rowtype;
4986:

Line 4985: l_remarks_rec ghr_pa_remarks%rowtype;

4981: cursor cur_pa_rem_cur is
4982: select * from ghr_pa_remarks
4983: where pa_request_id = p_pa_request_id;
4984:
4985: l_remarks_rec ghr_pa_remarks%rowtype;
4986:
4987: begin
4988: g_proc := 'create_lac_remarks';
4989: hr_utility.set_location('Entering ' || l_proc,5);

Line 4999: ghr_pa_remarks_api.create_pa_remarks

4995:
4996: l_remarks_rec := cur_pa_rem_rec;
4997:
4998: pr('Rem id '||to_char(l_remarks_rec.remark_id));
4999: ghr_pa_remarks_api.create_pa_remarks
5000: (p_validate => false
5001: ,p_pa_request_id => p_new_pa_request_id
5002: ,p_remark_id => l_remarks_rec.remark_id
5003: ,p_description => l_remarks_rec.description