DBA Data[Home] [Help]

APPS.PQH_BGT_DEL dependencies on PQH_BUDGETS

Line 53: -- Delete the pqh_budgets row.

49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: --
53: -- Delete the pqh_budgets row.
54: --
55: delete from pqh_budgets
56: where budget_id = p_rec.budget_id;
57: --

Line 55: delete from pqh_budgets

51: --
52: --
53: -- Delete the pqh_budgets row.
54: --
55: delete from pqh_budgets
56: where budget_id = p_rec.budget_id;
57: --
58: --
59: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 106: l_budgets_rec pqh_budgets%ROWTYPE;

102: Procedure pre_delete(p_rec in pqh_bgt_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: l_budgets_rec pqh_budgets%ROWTYPE;
107:
108: cursor csr_budget(p_budget_id IN number) is
109: select *
110: from pqh_budgets

Line 110: from pqh_budgets

106: l_budgets_rec pqh_budgets%ROWTYPE;
107:
108: cursor csr_budget(p_budget_id IN number) is
109: select *
110: from pqh_budgets
111: where budget_id = p_budget_id;
112: --
113: Begin
114: hr_utility.set_location('Entering:'||l_proc, 5);

Line 231: (p_module_name => 'pqh_budgets'

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