APPS.PQH_CER_SHD dependencies on PQH_COPY_ENTITY_RESULTS

Line 16: If (p_constraint_name = 'PQH_COPY_ENTITY_RESULTS_FK1') Then

12: --
13: Begin
14: hr_utility.set_location('Entering:'||l_proc, 5);
15: --
16: If (p_constraint_name = 'PQH_COPY_ENTITY_RESULTS_FK1') Then
17: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
18: hr_utility.set_message_token('PROCEDURE', l_proc);
19: hr_utility.set_message_token('STEP','5');
20: hr_utility.raise_error;

Line 21: ElsIf (p_constraint_name = 'PQH_COPY_ENTITY_RESULTS_FK2') Then

17: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
18: hr_utility.set_message_token('PROCEDURE', l_proc);
19: hr_utility.set_message_token('STEP','5');
20: hr_utility.raise_error;
21: ElsIf (p_constraint_name = 'PQH_COPY_ENTITY_RESULTS_FK2') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','10');
25: hr_utility.raise_error;

Line 26: ElsIf (p_constraint_name = 'PQH_COPY_ENTITY_RESULTS_PK') Then

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

Line 258: from pqh_copy_entity_results

254: parent_entity_result_id,
255: table_route_id,
256: long_attribute1,
257: object_version_number
258: from pqh_copy_entity_results
259: where copy_entity_result_id = p_copy_entity_result_id;
260: --
261: l_proc varchar2(72) := g_package||'api_updating';
262: l_fct_ret boolean;

Line 530: from pqh_copy_entity_results

526: parent_entity_result_id,
527: table_route_id,
528: long_attribute1,
529: object_version_number
530: from pqh_copy_entity_results
531: where copy_entity_result_id = p_copy_entity_result_id
532: for update nowait;
533: --
534: l_proc varchar2(72) := g_package||'lck';

Line 573: hr_utility.set_message_token('TABLE_NAME', 'pqh_copy_entity_results');

569: -- The object is locked therefore we need to supply a meaningful
570: -- error message.
571: --
572: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
573: hr_utility.set_message_token('TABLE_NAME', 'pqh_copy_entity_results');
574: hr_utility.raise_error;
575: End lck;
576: --
577: -- ----------------------------------------------------------------------------