APPS.PQH_WKS_INS dependencies on PQH_BUDGETS

Line 202: l_budgets_rec pqh_budgets%ROWTYPE;

198: --
199: l_proc varchar2(72) := g_package||'post_insert';
200: --
201:
202: l_budgets_rec pqh_budgets%ROWTYPE;
203:
204: cursor csr_budget(p_budget_id IN number) is
205: select *
206: from pqh_budgets

Line 206: from pqh_budgets

202: l_budgets_rec pqh_budgets%ROWTYPE;
203:
204: cursor csr_budget(p_budget_id IN number) is
205: select *
206: from pqh_budgets
207: where budget_id = p_budget_id
208: and nvl(status,'X') <> 'FROZEN';
209:
210: l_object_version_number number(9);

Line 236: pqh_budgets_api.update_budget

232: -- call update API of budget to update the budget status to frozen
233:
234: l_object_version_number := l_budgets_rec.object_version_number;
235:
236: pqh_budgets_api.update_budget
237: (
238: p_budget_id => l_budgets_rec.budget_id,
239: p_object_version_number => l_object_version_number,
240: p_status => 'FROZEN',