APPS.PER_PDP_INS dependencies on PER_PERIODS_OF_PLACEMENT

Line 87: -- Insert the row into: per_periods_of_placement

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

Line 89: insert into per_periods_of_placement

85: --
86: --
87: -- Insert the row into: per_periods_of_placement
88: --
89: insert into per_periods_of_placement
90: (object_version_number
91: ,business_group_id
92: ,person_id
93: ,date_start

Line 295: Cursor C_Sel1 is select per_periods_of_placement_s.nextval from sys.dual;

291: Procedure pre_insert
292: (p_rec in out nocopy per_pdp_shd.g_rec_type
293: ) is
294: --
295: Cursor C_Sel1 is select per_periods_of_placement_s.nextval from sys.dual;
296: --
297: Cursor C_Sel2 is
298: Select null
299: from per_periods_of_placement

Line 299: from per_periods_of_placement

295: Cursor C_Sel1 is select per_periods_of_placement_s.nextval from sys.dual;
296: --
297: Cursor C_Sel2 is
298: Select null
299: from per_periods_of_placement
300: where period_of_placement_id =
301: per_pdp_ins.g_period_of_placement_id_i;
302: --
303: l_proc varchar2(72) := g_package||'pre_insert';

Line 321: fnd_message.set_token('TABLE_NAME','per_periods_of_placement');

317: --
318: -- The primary key values are already in use.
319: --
320: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
321: fnd_message.set_token('TABLE_NAME','per_periods_of_placement');
322: fnd_message.raise_error;
323: End If;
324: Close C_Sel2;
325: --

Line 532: (p_module_name => 'PER_PERIODS_OF_PLACEMENT'

528: --
529: when hr_api.cannot_find_prog_unit then
530: --
531: hr_api.cannot_find_prog_unit_error
532: (p_module_name => 'PER_PERIODS_OF_PLACEMENT'
533: ,p_hook_type => 'AI');
534: --
535: end;
536: --