APPS.PQH_DEL_INS dependencies on PQH_DFLT_BUDGET_ELEMENTS

Line 56: -- Insert the row into: pqh_dflt_budget_elements

52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: pqh_dflt_budget_elements
57: --
58: insert into pqh_dflt_budget_elements
59: ( dflt_budget_element_id,
60: dflt_budget_set_id,

Line 58: insert into pqh_dflt_budget_elements

54: --
55: --
56: -- Insert the row into: pqh_dflt_budget_elements
57: --
58: insert into pqh_dflt_budget_elements
59: ( dflt_budget_element_id,
60: dflt_budget_set_id,
61: element_type_id,
62: dflt_dist_percentage,

Line 133: Cursor C_Sel1 is select pqh_dflt_budget_elements_s.nextval from sys.dual;

129: Procedure pre_insert(p_rec in out nocopy pqh_del_shd.g_rec_type) is
130: --
131: l_proc varchar2(72) := g_package||'pre_insert';
132: --
133: Cursor C_Sel1 is select pqh_dflt_budget_elements_s.nextval from sys.dual;
134: --
135: Begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --

Line 189: from pqh_dflt_budget_elements

185: l_sum number(15,2) := 0;
186:
187: cursor csr_element(p_dflt_budget_set_id in number) is
188: select SUM(NVL(dflt_dist_percentage,0))
189: from pqh_dflt_budget_elements
190: where dflt_budget_set_id = p_dflt_budget_set_id;
191:
192:
193: --

Line 231: (p_module_name => 'pqh_dflt_budget_elements'

227: --
228: when hr_api.cannot_find_prog_unit then
229: --
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'pqh_dflt_budget_elements'
232: ,p_hook_type => 'AI');
233: --
234: end;
235: --