APPS.HR_NMF_INS dependencies on HR_NAME_FORMATS

Line 86: -- Insert the row into: hr_name_formats

82: hr_utility.set_location('Entering:'||l_proc, 5);
83: end if;
84: p_rec.object_version_number := 1; -- Initialise the object version
85: --
86: -- Insert the row into: hr_name_formats
87: --
88: insert into hr_name_formats
89: (name_format_id
90: ,format_name

Line 88: insert into hr_name_formats

84: p_rec.object_version_number := 1; -- Initialise the object version
85: --
86: -- Insert the row into: hr_name_formats
87: --
88: insert into hr_name_formats
89: (name_format_id
90: ,format_name
91: ,legislation_code
92: ,user_format_choice

Line 166: Cursor C_Sel1 is select hr_name_formats_s.nextval from sys.dual;

162: Procedure pre_insert
163: (p_rec in out nocopy hr_nmf_shd.g_rec_type
164: ) is
165: --
166: Cursor C_Sel1 is select hr_name_formats_s.nextval from sys.dual;
167: --
168: Cursor C_Sel2 is
169: Select null
170: from hr_name_formats

Line 170: from hr_name_formats

166: Cursor C_Sel1 is select hr_name_formats_s.nextval from sys.dual;
167: --
168: Cursor C_Sel2 is
169: Select null
170: from hr_name_formats
171: where name_format_id =
172: hr_nmf_ins.g_name_format_id_i;
173: --
174: l_proc varchar2(72) := g_package||'pre_insert';

Line 194: fnd_message.set_token('TABLE_NAME','hr_name_formats');

190: --
191: -- The primary key values are already in use.
192: --
193: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
194: fnd_message.set_token('TABLE_NAME','hr_name_formats');
195: fnd_message.raise_error;
196: End If;
197: Close C_Sel2;
198: --

Line 287: (p_module_name => 'HR_NAME_FORMATS'

283: --
284: when hr_api.cannot_find_prog_unit then
285: --
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'HR_NAME_FORMATS'
288: ,p_hook_type => 'AI');
289: --
290: end;
291: --