APPS.PQH_BRE_SHD dependencies on PQH_BDGT_POOL_REALLOCTIONS

Line 31: If (p_constraint_name = 'PQH_BDGT_POOL_REALLOCTIONS_FK1') Then

27: l_proc varchar2(72) := g_package||'constraint_error';
28: --
29: Begin
30: --
31: If (p_constraint_name = 'PQH_BDGT_POOL_REALLOCTIONS_FK1') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','5');
35: fnd_message.raise_error;

Line 36: ELSIf (p_constraint_name = 'PQH_BDGT_POOL_REALLOCTIONS_PK') Then

32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','5');
35: fnd_message.raise_error;
36: ELSIf (p_constraint_name = 'PQH_BDGT_POOL_REALLOCTIONS_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','10');
40: fnd_message.raise_error;

Line 77: from pqh_bdgt_pool_realloctions

73: ,budget_period_id
74: ,entity_id
75: ,start_date
76: ,end_date
77: from pqh_bdgt_pool_realloctions
78: where reallocation_id = p_reallocation_id;
79: --
80: l_fct_ret boolean;
81: --

Line 155: from pqh_bdgt_pool_realloctions

151: ,budget_period_id
152: ,entity_id
153: ,start_date
154: ,end_date
155: from pqh_bdgt_pool_realloctions
156: where reallocation_id = p_reallocation_id
157: for update nowait;
158: --
159: l_proc varchar2(72) := g_package||'lck';

Line 204: fnd_message.set_token('TABLE_NAME', 'pqh_bdgt_pool_realloctions');

200: -- The object is locked therefore we need to supply a meaningful
201: -- error message.
202: --
203: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
204: fnd_message.set_token('TABLE_NAME', 'pqh_bdgt_pool_realloctions');
205: fnd_message.raise_error;
206: End lck;
207: --
208: -- ----------------------------------------------------------------------------