APPS.BEN_BCM_INS dependencies on BEN_CWB_MATRIX

Line 87: -- Insert the row into: ben_cwb_matrix

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

Line 89: insert into ben_cwb_matrix

85: --
86: --
87: -- Insert the row into: ben_cwb_matrix
88: --
89: insert into ben_cwb_matrix
90: (cwb_matrix_id
91: ,name
92: ,date_saved
93: ,plan_id

Line 181: Cursor C_Sel1 is select ben_cwb_matrix_s.nextval from sys.dual;

177: Procedure pre_insert
178: (p_rec in out nocopy ben_bcm_shd.g_rec_type
179: ) is
180: --
181: Cursor C_Sel1 is select ben_cwb_matrix_s.nextval from sys.dual;
182: --
183: Cursor C_Sel2 is
184: Select null
185: from ben_cwb_matrix

Line 185: from ben_cwb_matrix

181: Cursor C_Sel1 is select ben_cwb_matrix_s.nextval from sys.dual;
182: --
183: Cursor C_Sel2 is
184: Select null
185: from ben_cwb_matrix
186: where cwb_matrix_id =
187: ben_bcm_ins.g_cwb_matrix_id_i;
188: --
189: l_proc varchar2(72) := g_package||'pre_insert';

Line 207: fnd_message.set_token('TABLE_NAME','ben_cwb_matrix');

203: --
204: -- The primary key values are already in use.
205: --
206: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
207: fnd_message.set_token('TABLE_NAME','ben_cwb_matrix');
208: fnd_message.raise_error;
209: End If;
210: Close C_Sel2;
211: --

Line 306: (p_module_name => 'BEN_CWB_MATRIX'

302: --
303: when hr_api.cannot_find_prog_unit then
304: --
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'BEN_CWB_MATRIX'
307: ,p_hook_type => 'AI');
308: --
309: end;
310: --