APPS.BEN_BCD_INS dependencies on BEN_CWB_MATRIX_DTL

Line 87: -- Insert the row into: ben_cwb_matrix_dtl

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

Line 89: insert into ben_cwb_matrix_dtl

85: --
86: --
87: -- Insert the row into: ben_cwb_matrix_dtl
88: --
89: insert into ben_cwb_matrix_dtl
90: (cwb_matrix_dtl_id
91: ,cwb_matrix_id
92: ,row_crit_val
93: ,col_crit_val

Line 177: Cursor C_Sel1 is select ben_cwb_matrix_dtl_s.nextval from sys.dual;

173: Procedure pre_insert
174: (p_rec in out nocopy ben_bcd_shd.g_rec_type
175: ) is
176: --
177: Cursor C_Sel1 is select ben_cwb_matrix_dtl_s.nextval from sys.dual;
178: --
179: Cursor C_Sel2 is
180: Select null
181: from ben_cwb_matrix_dtl

Line 181: from ben_cwb_matrix_dtl

177: Cursor C_Sel1 is select ben_cwb_matrix_dtl_s.nextval from sys.dual;
178: --
179: Cursor C_Sel2 is
180: Select null
181: from ben_cwb_matrix_dtl
182: where cwb_matrix_dtl_id =
183: ben_bcd_ins.g_cwb_matrix_dtl_id_i;
184: --
185: l_proc varchar2(72) := g_package||'pre_insert';

Line 203: fnd_message.set_token('TABLE_NAME','ben_cwb_matrix_dtl');

199: --
200: -- The primary key values are already in use.
201: --
202: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
203: fnd_message.set_token('TABLE_NAME','ben_cwb_matrix_dtl');
204: fnd_message.raise_error;
205: End If;
206: Close C_Sel2;
207: --

Line 296: (p_module_name => 'BEN_CWB_MATRIX_DTL'

292: --
293: when hr_api.cannot_find_prog_unit then
294: --
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'BEN_CWB_MATRIX_DTL'
297: ,p_hook_type => 'AI');
298: --
299: end;
300: --