APPS.PQH_DST_SHD dependencies on PQH_DFLT_BUDGET_SETS

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

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PQH_DFLT_BUDGET_SETS_FK1') 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 30: ElsIf (p_constraint_name = 'PQH_DFLT_BUDGET_SETS_PK') Then

26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_BUDGET_SETS_FK1') Then
28: hr_utility.set_message(8302, 'PQH_DEL_DFLT_BUDGET_SETS');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PQH_DFLT_BUDGET_SETS_PK') Then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','10');
34: hr_utility.raise_error;

Line 66: from pqh_dflt_budget_sets

62: dflt_budget_set_id,
63: dflt_budget_set_name,
64: business_group_id,
65: object_version_number
66: from pqh_dflt_budget_sets
67: where dflt_budget_set_id = p_dflt_budget_set_id;
68: --
69: l_proc varchar2(72) := g_package||'api_updating';
70: l_fct_ret boolean;

Line 139: from pqh_dflt_budget_sets

135: select dflt_budget_set_id,
136: dflt_budget_set_name,
137: business_group_id,
138: object_version_number
139: from pqh_dflt_budget_sets
140: where dflt_budget_set_id = p_dflt_budget_set_id
141: for update nowait;
142: --
143: l_proc varchar2(72) := g_package||'lck';

Line 182: hr_utility.set_message_token('TABLE_NAME', 'pqh_dflt_budget_sets');

178: -- The object is locked therefore we need to supply a meaningful
179: -- error message.
180: --
181: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
182: hr_utility.set_message_token('TABLE_NAME', 'pqh_dflt_budget_sets');
183: hr_utility.raise_error;
184: End lck;
185: --
186: -- ----------------------------------------------------------------------------