APPS.PQH_REI_SHD dependencies on PQH_ROLE_EXTRA_INFO

Line 21: If (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_FK1') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_FK1') Then
22: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
23: hr_utility.raise_error;
24: Elsif (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_FK2') Then
25: hr_utility.set_message(8302, 'PQH_INV_ROLE_ID');

Line 24: Elsif (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_FK2') Then

20: --
21: If (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_FK1') Then
22: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
23: hr_utility.raise_error;
24: Elsif (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_FK2') Then
25: hr_utility.set_message(8302, 'PQH_INV_ROLE_ID');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_PK') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 27: ElsIf (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_PK') Then

23: hr_utility.raise_error;
24: Elsif (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_FK2') Then
25: hr_utility.set_message(8302, 'PQH_INV_ROLE_ID');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_ROLE_EXTRA_INFO_PK') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','15');
31: hr_utility.raise_error;

Line 125: from pqh_role_extra_info

121: ,information28
122: ,information29
123: ,information30
124: ,object_version_number
125: from pqh_role_extra_info
126: where role_extra_info_id = p_role_extra_info_id;
127: --
128: l_fct_ret boolean;
129: --

Line 262: from pqh_role_extra_info

258: ,information28
259: ,information29
260: ,information30
261: ,object_version_number
262: from pqh_role_extra_info
263: where role_extra_info_id = p_role_extra_info_id
264: for update nowait;
265: --
266: l_proc varchar2(72) := g_package||'lck';

Line 312: hr_utility.set_message_token('TABLE_NAME', 'pqh_role_extra_info');

308: -- The object is locked therefore we need to supply a meaningful
309: -- error message.
310: --
311: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
312: hr_utility.set_message_token('TABLE_NAME', 'pqh_role_extra_info');
313: hr_utility.raise_error;
314: End lck;
315:
316: -- ----------------------------------------------------------------------------