APPS.PQH_BVR_SHD dependencies on PQH_BUDGET_VERSIONS

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

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

68: budget_unit3_value,
69: budget_unit1_available,
70: budget_unit2_available,
71: budget_unit3_available
72: from pqh_budget_versions
73: where budget_version_id = p_budget_version_id;
74: --
75: l_proc varchar2(72) := g_package||'api_updating';
76: l_fct_ret boolean;

Line 156: from pqh_budget_versions

152: budget_unit3_value,
153: budget_unit1_available,
154: budget_unit2_available,
155: budget_unit3_available
156: from pqh_budget_versions
157: where budget_version_id = p_budget_version_id
158: for update nowait;
159: --
160: l_proc varchar2(72) := g_package||'lck';

Line 199: hr_utility.set_message_token('TABLE_NAME', 'pqh_budget_versions');

195: -- The object is locked therefore we need to supply a meaningful
196: -- error message.
197: --
198: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
199: hr_utility.set_message_token('TABLE_NAME', 'pqh_budget_versions');
200: hr_utility.raise_error;
201: End lck;
202: --
203: -- ----------------------------------------------------------------------------