APPS.PER_PST_INS dependencies on PER_POSITION_STRUCTURES

Line 87: -- Insert the row into: per_position_structures

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: per_pst_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_position_structures
88: --
89: insert into per_position_structures
90: (position_structure_id
91: ,business_group_id

Line 89: insert into per_position_structures

85: per_pst_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_position_structures
88: --
89: insert into per_position_structures
90: (position_structure_id
91: ,business_group_id
92: ,name
93: ,comments

Line 221: Cursor C_Sel1 is select per_position_structures_s.nextval from sys.dual;

217: Procedure pre_insert
218: (p_rec in out nocopy per_pst_shd.g_rec_type
219: ) is
220: --
221: Cursor C_Sel1 is select per_position_structures_s.nextval from sys.dual;
222: --
223: Cursor C_Sel2 is
224: Select null
225: from per_position_structures

Line 225: from per_position_structures

221: Cursor C_Sel1 is select per_position_structures_s.nextval from sys.dual;
222: --
223: Cursor C_Sel2 is
224: Select null
225: from per_position_structures
226: where position_structure_id =
227: per_pst_ins.g_position_structure_id_i;
228: --
229: l_proc varchar2(72) := g_package||'pre_insert';

Line 247: fnd_message.set_token('TABLE_NAME','per_position_structures');

243: --
244: -- The primary key values are already in use.
245: --
246: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
247: fnd_message.set_token('TABLE_NAME','per_position_structures');
248: fnd_message.raise_error;
249: End If;
250: Close C_Sel2;
251: --

Line 386: (p_module_name => 'PER_POSITION_STRUCTURES'

382: --
383: when hr_api.cannot_find_prog_unit then
384: --
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'PER_POSITION_STRUCTURES'
387: ,p_hook_type => 'AI');
388: --
389: end;
390: --