APPS.PQH_BVR_UPD dependencies on PQH_BUDGETS

Line 186: l_budgets_rec pqh_budgets%ROWTYPE;

182:
183:
184: --
185:
186: l_budgets_rec pqh_budgets%ROWTYPE;
187:
188: cursor csr_budget(p_budget_id IN number) is
189: select *
190: from pqh_budgets

Line 190: from pqh_budgets

186: l_budgets_rec pqh_budgets%ROWTYPE;
187:
188: cursor csr_budget(p_budget_id IN number) is
189: select *
190: from pqh_budgets
191: where budget_id = p_budget_id
192: and nvl(status,'X') <> 'FROZEN';
193:
194: l_object_version_number number(9);

Line 222: pqh_budgets_api.update_budget

218: -- call update API of budget to update the budget status to frozen
219:
220: l_object_version_number := l_budgets_rec.object_version_number;
221:
222: pqh_budgets_api.update_budget
223: (
224: p_budget_id => l_budgets_rec.budget_id,
225: p_object_version_number => l_object_version_number,
226: p_status => 'FROZEN',