DBA Data[Home] [Help]

APPS.PER_SLT_INS dependencies on PER_SOLUTION_TYPES

Line 87: -- Insert the row into: per_solution_types

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

Line 89: insert into per_solution_types

85: --
86: --
87: -- Insert the row into: per_solution_types
88: --
89: insert into per_solution_types
90: (solution_type_name
91: ,solution_category
92: ,updateable
93: ,object_version_number

Line 169: from per_solution_types

165: ) is
166: --
167: Cursor C_Sel2 is
168: Select null
169: from per_solution_types
170: where solution_type_name = p_rec.solution_type_name;
171: --
172: l_proc varchar2(72) := g_package||'pre_insert';
173: l_exists varchar2(1);

Line 190: fnd_message.set_token('TABLE_NAME','per_solution_types');

186: --
187: -- The primary key values are already in use.
188: --
189: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
190: fnd_message.set_token('TABLE_NAME','per_solution_types');
191: fnd_message.raise_error;
192: End If;
193: Close C_Sel2;
194: --

Line 269: (p_module_name => 'PER_SOLUTION_TYPES'

265: --
266: when hr_api.cannot_find_prog_unit then
267: --
268: hr_api.cannot_find_prog_unit_error
269: (p_module_name => 'PER_SOLUTION_TYPES'
270: ,p_hook_type => 'AI');
271: --
272: end;
273: --