DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on GHR_PA_REMARKS

Line 4724: select * from ghr_pa_remarks

4720:
4721: l_proc varchar2(72) := g_package || '.create_lac_remarks';
4722:
4723: cursor cur_pa_rem_cur is
4724: select * from ghr_pa_remarks
4725: where pa_request_id = p_pa_request_id;
4726:
4727: l_remarks_rec ghr_pa_remarks%rowtype;
4728:

Line 4727: l_remarks_rec ghr_pa_remarks%rowtype;

4723: cursor cur_pa_rem_cur is
4724: select * from ghr_pa_remarks
4725: where pa_request_id = p_pa_request_id;
4726:
4727: l_remarks_rec ghr_pa_remarks%rowtype;
4728:
4729: begin
4730: g_proc := 'create_lac_remarks';
4731: hr_utility.set_location('Entering ' || l_proc,5);

Line 4741: ghr_pa_remarks_api.create_pa_remarks

4737:
4738: l_remarks_rec := cur_pa_rem_rec;
4739:
4740: pr('Rem id '||to_char(l_remarks_rec.remark_id));
4741: ghr_pa_remarks_api.create_pa_remarks
4742: (p_validate => false
4743: ,p_pa_request_id => p_new_pa_request_id
4744: ,p_remark_id => l_remarks_rec.remark_id
4745: ,p_description => l_remarks_rec.description