APPS.PQH_CEA_SHD dependencies on PQH_COPY_ENTITY_ATTRIBS

Line 20: If (p_constraint_name = 'PQH_COPY_ENTITY_ATTRIBS_FK1') Then

16: --
17: Begin
18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: If (p_constraint_name = 'PQH_COPY_ENTITY_ATTRIBS_FK1') Then
21: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
22: hr_utility.set_message_token('PROCEDURE', l_proc);
23: hr_utility.set_message_token('STEP','5');
24: hr_utility.raise_error;

Line 25: ElsIf (p_constraint_name = 'PQH_COPY_ENTITY_ATTRIBS_PK') Then

21: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
22: hr_utility.set_message_token('PROCEDURE', l_proc);
23: hr_utility.set_message_token('STEP','5');
24: hr_utility.raise_error;
25: ElsIf (p_constraint_name = 'PQH_COPY_ENTITY_ATTRIBS_PK') Then
26: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;

Line 92: from pqh_copy_entity_attribs

88: check_information1,
89: check_information2,
90: check_information3,
91: object_version_number
92: from pqh_copy_entity_attribs
93: where copy_entity_attrib_id = p_copy_entity_attrib_id;
94: --
95: l_proc varchar2(72) := g_package||'api_updating';
96: l_fct_ret boolean;

Line 199: from pqh_copy_entity_attribs

195: check_information1,
196: check_information2,
197: check_information3,
198: object_version_number
199: from pqh_copy_entity_attribs
200: where copy_entity_attrib_id = p_copy_entity_attrib_id
201: for update nowait;
202: --
203: l_proc varchar2(72) := g_package||'lck';

Line 242: hr_utility.set_message_token('TABLE_NAME', 'pqh_copy_entity_attribs');

238: -- The object is locked therefore we need to supply a meaningful
239: -- error message.
240: --
241: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
242: hr_utility.set_message_token('TABLE_NAME', 'pqh_copy_entity_attribs');
243: hr_utility.raise_error;
244: End lck;
245: --
246: -- ----------------------------------------------------------------------------