APPS.PQH_CEI_INS dependencies on PQH_CORPS_EXTRA_INFO

Line 87: -- Insert the row into: pqh_corps_extra_info

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

Line 89: insert into pqh_corps_extra_info

85: --
86: --
87: -- Insert the row into: pqh_corps_extra_info
88: --
89: insert into pqh_corps_extra_info
90: (corps_extra_info_id
91: ,corps_definition_id
92: ,information_type
93: ,information1

Line 291: Cursor C_Sel1 is select pqh_corps_extra_info_s.nextval from sys.dual;

287: Procedure pre_insert
288: (p_rec in out nocopy pqh_cei_shd.g_rec_type
289: ) is
290: --
291: Cursor C_Sel1 is select pqh_corps_extra_info_s.nextval from sys.dual;
292: --
293: Cursor C_Sel2 is
294: Select null
295: from pqh_corps_extra_info

Line 295: from pqh_corps_extra_info

291: Cursor C_Sel1 is select pqh_corps_extra_info_s.nextval from sys.dual;
292: --
293: Cursor C_Sel2 is
294: Select null
295: from pqh_corps_extra_info
296: where corps_extra_info_id =
297: pqh_cei_ins.g_corps_extra_info_id_i;
298: --
299: l_proc varchar2(72) := g_package||'pre_insert';

Line 317: fnd_message.set_token('TABLE_NAME','pqh_corps_extra_info');

313: --
314: -- The primary key values are already in use.
315: --
316: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
317: fnd_message.set_token('TABLE_NAME','pqh_corps_extra_info');
318: fnd_message.raise_error;
319: End If;
320: Close C_Sel2;
321: --

Line 526: (p_module_name => 'PQH_CORPS_EXTRA_INFO'

522: --
523: when hr_api.cannot_find_prog_unit then
524: --
525: hr_api.cannot_find_prog_unit_error
526: (p_module_name => 'PQH_CORPS_EXTRA_INFO'
527: ,p_hook_type => 'AI');
528: --
529: end;
530: --