DBA Data[Home] [Help]

APPS.BEN_AUD_INS dependencies on BEN_CWB_AUDIT

Line 87: -- Insert the row into: ben_cwb_audit

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: ben_cwb_audit
88: --
89: insert into ben_cwb_audit
90: (cwb_audit_id
91: ,group_per_in_ler_id

Line 89: insert into ben_cwb_audit

85: --
86: --
87: -- Insert the row into: ben_cwb_audit
88: --
89: insert into ben_cwb_audit
90: (cwb_audit_id
91: ,group_per_in_ler_id
92: ,group_pl_id
93: ,lf_evt_ocrd_dt

Line 195: Cursor C_Sel1 is select ben_cwb_audit_s.nextval from sys.dual;

191: Procedure pre_insert
192: (p_rec in out nocopy ben_aud_shd.g_rec_type
193: ) is
194: --
195: Cursor C_Sel1 is select ben_cwb_audit_s.nextval from sys.dual;
196: --
197: Cursor C_Sel2 is
198: Select null
199: from ben_cwb_audit

Line 199: from ben_cwb_audit

195: Cursor C_Sel1 is select ben_cwb_audit_s.nextval from sys.dual;
196: --
197: Cursor C_Sel2 is
198: Select null
199: from ben_cwb_audit
200: where cwb_audit_id =
201: ben_aud_ins.g_cwb_audit_id_i;
202: --
203: l_proc varchar2(72) := g_package||'pre_insert';

Line 221: fnd_message.set_token('TABLE_NAME','ben_cwb_audit');

217: --
218: -- The primary key values are already in use.
219: --
220: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
221: fnd_message.set_token('TABLE_NAME','ben_cwb_audit');
222: fnd_message.raise_error;
223: End If;
224: Close C_Sel2;
225: --

Line 332: (p_module_name => 'BEN_CWB_AUDIT'

328: --
329: when hr_api.cannot_find_prog_unit then
330: --
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'BEN_CWB_AUDIT'
333: ,p_hook_type => 'AI');
334: --
335: end;
336: --