APPS.PQH_BPL_SHD dependencies on PQH_BUDGET_POOLS

Line 32: If (p_constraint_name = 'PQH_BUDGET_POOLS_FK1') Then

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

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

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

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

38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PQH_BUDGET_POOLS_PK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;

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

43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PQH_BUDGET_POOLS_U1') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;

Line 85: from pqh_budget_pools

81: ,parent_pool_id
82: ,business_group_id
83: ,approval_status
84: ,wf_transaction_category_id
85: from pqh_budget_pools
86: where pool_id = p_pool_id;
87: --
88: l_fct_ret boolean;
89: --

Line 160: from pqh_budget_pools

156: ,parent_pool_id
157: ,business_group_id
158: ,approval_status
159: ,wf_transaction_category_id
160: from pqh_budget_pools
161: where pool_id = p_pool_id
162: for update nowait;
163: --
164: l_proc varchar2(72) := g_package||'lck';

Line 209: fnd_message.set_token('TABLE_NAME', 'pqh_budget_pools');

205: -- The object is locked therefore we need to supply a meaningful
206: -- error message.
207: --
208: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
209: fnd_message.set_token('TABLE_NAME', 'pqh_budget_pools');
210: fnd_message.raise_error;
211: End lck;
212: --
213: -- ----------------------------------------------------------------------------