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_PTX_SHD dependencies on PQH_POSITION_TRANSACTIONS

Line 22: If (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK11') Then

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

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

23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') 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','10');
31: hr_utility.raise_error;

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

Line 37: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK5') Then

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

Line 42: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK6') Then

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

Line 47: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then

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

Line 52: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then

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

Line 57: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then

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

Line 228: from pqh_position_transactions

224: object_version_number,
225: pay_basis_id,
226: supervisor_id,
227: wf_transaction_category_id
228: from pqh_position_transactions
229: where position_transaction_id = p_position_transaction_id;
230: --
231: l_proc varchar2(72) := g_package||'api_updating';
232: l_fct_ret boolean;

Line 439: from pqh_position_transactions

435: object_version_number,
436: pay_basis_id,
437: supervisor_id,
438: wf_transaction_category_id
439: from pqh_position_transactions
440: where position_transaction_id = p_position_transaction_id
441: for update nowait;
442: --
443: l_proc varchar2(72) := g_package||'lck';

Line 482: hr_utility.set_message_token('TABLE_NAME', 'pqh_position_transactions');

478: -- The object is locked therefore we need to supply a meaningful
479: -- error message.
480: --
481: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
482: hr_utility.set_message_token('TABLE_NAME', 'pqh_position_transactions');
483: hr_utility.raise_error;
484: End lck;
485: --
486: -- ----------------------------------------------------------------------------