DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_PA_REMARKS

Line 4924: select * from ghr_pa_remarks

4920:
4921: l_proc varchar2(72) := g_package || '.create_lac_remarks';
4922:
4923: cursor cur_pa_rem_cur is
4924: select * from ghr_pa_remarks
4925: where pa_request_id = p_pa_request_id;
4926:
4927: l_remarks_rec ghr_pa_remarks%rowtype;
4928:

Line 4927: l_remarks_rec ghr_pa_remarks%rowtype;

4923: cursor cur_pa_rem_cur is
4924: select * from ghr_pa_remarks
4925: where pa_request_id = p_pa_request_id;
4926:
4927: l_remarks_rec ghr_pa_remarks%rowtype;
4928:
4929: begin
4930: g_proc := 'create_lac_remarks';
4931: hr_utility.set_location('Entering ' || l_proc,5);

Line 4941: ghr_pa_remarks_api.create_pa_remarks

4937:
4938: l_remarks_rec := cur_pa_rem_rec;
4939:
4940: pr('Rem id '||to_char(l_remarks_rec.remark_id));
4941: ghr_pa_remarks_api.create_pa_remarks
4942: (p_validate => false
4943: ,p_pa_request_id => p_new_pa_request_id
4944: ,p_remark_id => l_remarks_rec.remark_id
4945: ,p_description => l_remarks_rec.description