[Home] [Help]
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;
58: --
59: --
60: -- Update the pqh_dflt_budget_elements Row
61: --
62: update pqh_dflt_budget_elements
63: set
64: dflt_budget_element_id = p_rec.dflt_budget_element_id,
58: --
59: --
60: -- Update the pqh_dflt_budget_elements Row
61: --
62: update pqh_dflt_budget_elements
63: set
64: dflt_budget_element_id = p_rec.dflt_budget_element_id,
65: dflt_budget_set_id = p_rec.dflt_budget_set_id,
66: element_type_id = p_rec.element_type_id,
171: l_sum number(15,2) := 0;
172:
173: cursor csr_element(p_dflt_budget_set_id in number) is
174: select SUM(NVL(dflt_dist_percentage,0))
175: from pqh_dflt_budget_elements
176: where dflt_budget_set_id = p_dflt_budget_set_id;
177:
178:
179: --
215: --
216: when hr_api.cannot_find_prog_unit then
217: --
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'pqh_dflt_budget_elements'
220: ,p_hook_type => 'AU');
221: --
222: end;
223: --