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_WDT_SHD dependencies on PQH_WORKSHEET_DETAILS

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

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

Line 26: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK3') 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_WORKSHEET_DETAILS_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;

Line 31: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK4') 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_WORKSHEET_DETAILS_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;

Line 36: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK5') 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_WORKSHEET_DETAILS_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;

Line 41: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK6') 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_WORKSHEET_DETAILS_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;

Line 46: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK7') 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_WORKSHEET_DETAILS_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;

Line 51: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK8') 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_WORKSHEET_DETAILS_FK8') 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_WORKSHEET_DETAILS_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_WORKSHEET_DETAILS_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 61: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_UK') 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;
61: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_UK') Then
62: --
63: -- Code Changed to provide a more meaningful message on
64: -- unique constraint failure.
65: --

Line 128: from pqh_worksheet_details

124: old_unit2_value,
125: old_unit3_value,
126: defer_flag,
127: propagation_method
128: from pqh_worksheet_details
129: where worksheet_detail_id = p_worksheet_detail_id;
130: --
131: l_proc varchar2(72) := g_package||'api_updating';
132: l_fct_ret boolean;

Line 227: from pqh_worksheet_details

223: old_unit2_value,
224: old_unit3_value,
225: defer_flag,
226: propagation_method
227: from pqh_worksheet_details
228: where worksheet_detail_id = p_worksheet_detail_id
229: for update nowait;
230: --
231: l_proc varchar2(72) := g_package||'lck';

Line 270: hr_utility.set_message_token('TABLE_NAME', 'pqh_worksheet_details');

266: -- The object is locked therefore we need to supply a meaningful
267: -- error message.
268: --
269: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
270: hr_utility.set_message_token('TABLE_NAME', 'pqh_worksheet_details');
271: hr_utility.raise_error;
272: End lck;
273: --
274: -- ----------------------------------------------------------------------------