DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on GHR_PA_REMARKS

Line 4666: select * from ghr_pa_remarks

4662:
4663: l_proc varchar2(72) := g_package || '.create_lac_remarks';
4664:
4665: cursor cur_pa_rem_cur is
4666: select * from ghr_pa_remarks
4667: where pa_request_id = p_pa_request_id;
4668:
4669: l_remarks_rec ghr_pa_remarks%rowtype;
4670:

Line 4669: l_remarks_rec ghr_pa_remarks%rowtype;

4665: cursor cur_pa_rem_cur is
4666: select * from ghr_pa_remarks
4667: where pa_request_id = p_pa_request_id;
4668:
4669: l_remarks_rec ghr_pa_remarks%rowtype;
4670:
4671: begin
4672: g_proc := 'create_lac_remarks';
4673: hr_utility.set_location('Entering ' || l_proc,5);

Line 4683: ghr_pa_remarks_api.create_pa_remarks

4679:
4680: l_remarks_rec := cur_pa_rem_rec;
4681:
4682: pr('Rem id '||to_char(l_remarks_rec.remark_id));
4683: ghr_pa_remarks_api.create_pa_remarks
4684: (p_validate => false
4685: ,p_pa_request_id => p_new_pa_request_id
4686: ,p_remark_id => l_remarks_rec.remark_id
4687: ,p_description => l_remarks_rec.description