APPS.PER_SSD_INS dependencies on PER_SP_SUCCESSEE_DETAILS

Line 87: -- Insert the row into: per_sp_successee_details

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

Line 89: insert into per_sp_successee_details

85: per_ssd_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_sp_successee_details
88: --
89: insert into per_sp_successee_details
90: (successee_detail_id
91: ,business_group_id
92: ,successee_type
93: ,successee_id

Line 189: Cursor C_Sel1 is select per_sp_successee_details_s.nextval from sys.dual;

185: Procedure pre_insert
186: (p_rec in out nocopy per_ssd_shd.g_rec_type
187: ) is
188: --
189: Cursor C_Sel1 is select per_sp_successee_details_s.nextval from sys.dual;
190: --
191: Cursor C_Sel2 is
192: Select null
193: from per_sp_successee_details

Line 193: from per_sp_successee_details

189: Cursor C_Sel1 is select per_sp_successee_details_s.nextval from sys.dual;
190: --
191: Cursor C_Sel2 is
192: Select null
193: from per_sp_successee_details
194: where successee_detail_id =
195: per_ssd_ins.g_successee_detail_id_i;
196: --
197: l_proc varchar2(72) := g_package||'pre_insert';

Line 215: fnd_message.set_token('TABLE_NAME','per_sp_successee_details');

211: --
212: -- The primary key values are already in use.
213: --
214: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
215: fnd_message.set_token('TABLE_NAME','per_sp_successee_details');
216: fnd_message.raise_error;
217: End If;
218: Close C_Sel2;
219: --

Line 322: (p_module_name => 'PER_SP_SUCCESSEE_DETAILS'

318: --
319: when hr_api.cannot_find_prog_unit then
320: --
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'PER_SP_SUCCESSEE_DETAILS'
323: ,p_hook_type => 'AI');
324: --
325: end;
326: --