APPS.PQH_STS_INS dependencies on PQH_FR_STAT_SITUATIONS

Line 105: -- Insert the row into: pqh_fr_stat_situations

101: p_rec.object_version_number := 1; -- Initialise the object version
102: --
103: --
104: --
105: -- Insert the row into: pqh_fr_stat_situations
106: --
107: insert into pqh_fr_stat_situations
108: (statutory_situation_id
109: ,business_group_id

Line 107: insert into pqh_fr_stat_situations

103: --
104: --
105: -- Insert the row into: pqh_fr_stat_situations
106: --
107: insert into pqh_fr_stat_situations
108: (statutory_situation_id
109: ,business_group_id
110: ,situation_name
111: ,type_of_ps

Line 248: Cursor C_Sel1 is select pqh_fr_stat_situations_s.nextval from sys.dual;

244: Procedure pre_insert
245: (p_rec in out nocopy pqh_sts_shd.g_rec_type
246: ) is
247: --
248: Cursor C_Sel1 is select pqh_fr_stat_situations_s.nextval from sys.dual;
249: --
250: Cursor C_Sel2 is
251: Select null
252: from pqh_fr_stat_situations

Line 252: from pqh_fr_stat_situations

248: Cursor C_Sel1 is select pqh_fr_stat_situations_s.nextval from sys.dual;
249: --
250: Cursor C_Sel2 is
251: Select null
252: from pqh_fr_stat_situations
253: where statutory_situation_id =
254: pqh_sts_ins.g_statutory_situation_id_i;
255: --
256: l_proc varchar2(72) := g_package||'pre_insert';

Line 278: fnd_message.set_token('TABLE_NAME','pqh_fr_stat_situations');

274: --
275: -- The primary key values are already in use.
276: --
277: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
278: fnd_message.set_token('TABLE_NAME','pqh_fr_stat_situations');
279: fnd_message.raise_error;
280: End If;
281: Close C_Sel2;
282: --

Line 429: (p_module_name => 'PQH_FR_STAT_SITUATIONS'

425: --
426: when hr_api.cannot_find_prog_unit then
427: --
428: hr_api.cannot_find_prog_unit_error
429: (p_module_name => 'PQH_FR_STAT_SITUATIONS'
430: ,p_hook_type => 'AI');
431: --
432: end;
433: --