DBA Data[Home] [Help]

APPS.GHR_NRE_INS dependencies on GHR_NOAC_REMARKS

Line 59: -- Insert the row into: ghr_noac_remarks

55: l_rec := p_rec;
56: p_rec.object_version_number := 1; -- Initialise the object version
57: --
58: --
59: -- Insert the row into: ghr_noac_remarks
60: --
61: insert into ghr_noac_remarks
62: ( noac_remark_id,
63: nature_of_action_id,

Line 61: insert into ghr_noac_remarks

57: --
58: --
59: -- Insert the row into: ghr_noac_remarks
60: --
61: insert into ghr_noac_remarks
62: ( noac_remark_id,
63: nature_of_action_id,
64: remark_id,
65: required_flag,

Line 147: Cursor C_Sel1 is select ghr_noac_remarks_s.nextval from sys.dual;

143: --
144: l_proc varchar2(72) ;
145: l_rec ghr_nre_shd.g_rec_type;
146: --
147: Cursor C_Sel1 is select ghr_noac_remarks_s.nextval from sys.dual;
148: --
149: Begin
150: l_proc := g_package||'pre_insert';
151: hr_utility.set_location('Entering:'||l_proc, 5);

Line 232: (p_module_name => 'ghr_noac_remarks'

228: --
229: when hr_api.cannot_find_prog_unit then
230: --
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'ghr_noac_remarks'
233: ,p_hook_type => 'AI');
234: --
235: end;
236: --