APPS.PER_ENV_INS dependencies on PER_CAL_ENTRY_VALUES

Line 87: -- Insert the row into: per_cal_entry_values

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: per_cal_entry_values
88: insert into per_cal_entry_values
89: (cal_entry_value_id
90: ,calendar_entry_id
91: ,hierarchy_node_id

Line 88: insert into per_cal_entry_values

84: --
85: --
86: --
87: -- Insert the row into: per_cal_entry_values
88: insert into per_cal_entry_values
89: (cal_entry_value_id
90: ,calendar_entry_id
91: ,hierarchy_node_id
92: ,idvalue

Line 182: Cursor C_Sel1 is select per_cal_entry_values_s.nextval from sys.dual;

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

Line 186: from per_cal_entry_values

182: Cursor C_Sel1 is select per_cal_entry_values_s.nextval from sys.dual;
183: --
184: Cursor C_Sel2 is
185: Select null
186: from per_cal_entry_values
187: where cal_entry_value_id =
188: per_env_ins.g_cal_entry_value_id_i;
189: --
190: l_proc varchar2(72) := g_package||'pre_insert';

Line 208: fnd_message.set_token('TABLE_NAME','per_cal_entry_values');

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

Line 296: (p_module_name => 'PER_CAL_ENTRY_VALUES'

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