eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RHT_SHD dependencies on PQH_ROUTING_HISTORY

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

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PQH_ROUTING_HISTORY_FK1') 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','5');
25: hr_utility.raise_error;

Line 26: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_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','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK2') 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','10');
30: hr_utility.raise_error;

Line 31: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK3') 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','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK3') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;

Line 36: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK4') Then

32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK4') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','20');
40: hr_utility.raise_error;

Line 41: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK5') Then

37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','20');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK5') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','25');
45: hr_utility.raise_error;

Line 46: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK6') Then

42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','25');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK6') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','30');
50: hr_utility.raise_error;

Line 51: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK7') Then

47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','30');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK7') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','35');
55: hr_utility.raise_error;

Line 56: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_PK') Then

52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','35');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_PK') Then
57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('STEP','40');
60: hr_utility.raise_error;

Line 108: from pqh_routing_history

104: from_range_name,
105: to_range_name,
106: list_range_name,
107: object_version_number
108: from pqh_routing_history
109: where routing_history_id = p_routing_history_id;
110: --
111: l_proc varchar2(72) := g_package||'api_updating';
112: l_fct_ret boolean;

Line 200: from pqh_routing_history

196: from_range_name,
197: to_range_name,
198: list_range_name,
199: object_version_number
200: from pqh_routing_history
201: where routing_history_id = p_routing_history_id
202: for update nowait;
203: --
204: l_proc varchar2(72) := g_package||'lck';

Line 243: hr_utility.set_message_token('TABLE_NAME', 'pqh_routing_history');

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