APPS.HR_OPT_INS dependencies on HR_KI_OPTIONS

Line 87: -- Insert the row into: hr_ki_options

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

Line 89: insert into hr_ki_options

85: --
86: --
87: -- Insert the row into: hr_ki_options
88: --
89: insert into hr_ki_options
90: (option_id
91: ,option_type_id
92: ,option_level
93: ,option_level_id

Line 175: Cursor C_Sel1 is select hr_ki_options_s.nextval from sys.dual;

171: Procedure pre_insert
172: (p_rec in out nocopy hr_opt_shd.g_rec_type
173: ) is
174: --
175: Cursor C_Sel1 is select hr_ki_options_s.nextval from sys.dual;
176: --
177: Cursor C_Sel2 is
178: Select null
179: from hr_ki_options

Line 179: from hr_ki_options

175: Cursor C_Sel1 is select hr_ki_options_s.nextval from sys.dual;
176: --
177: Cursor C_Sel2 is
178: Select null
179: from hr_ki_options
180: where option_id =
181: hr_opt_ins.g_option_id_i;
182: --
183: l_proc varchar2(72) := g_package||'pre_insert';

Line 206: fnd_message.set_token('TABLE_NAME','hr_ki_options');

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

Line 307: (p_module_name => 'HR_KI_OPTIONS'

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