[Home] [Help]
1: Package Body pqh_budget_fund_srcs_api as
2: /* $Header: pqbfsapi.pkb 115.5 2002/11/27 04:42:44 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pqbfsapi.pkb 115.5 2002/11/27 04:42:44 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_budget_fund_srcs_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_budget_fund_src >----------------------|
10: -- ----------------------------------------------------------------------------
24: ) is
25: --
26: -- Declare cursors and local variables
27: --
28: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_budget_fund_src';
30: l_object_version_number pqh_budget_fund_srcs.object_version_number%TYPE;
31: --
32: begin
26: -- Declare cursors and local variables
27: --
28: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_budget_fund_src';
30: l_object_version_number pqh_budget_fund_srcs.object_version_number%TYPE;
31: --
32: begin
33: --
34: hr_utility.set_location('Entering:'|| l_proc, 10);
44: begin
45: --
46: -- Start of API User Hook for the before hook of create_budget_fund_src
47: --
48: pqh_budget_fund_srcs_bk1.create_budget_fund_src_b
49: (
50: p_budget_element_id => p_budget_element_id
51: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
52: ,p_project_id => p_project_id
85: begin
86: --
87: -- Start of API User Hook for the after hook of create_budget_fund_src
88: --
89: pqh_budget_fund_srcs_bk1.create_budget_fund_src_a
90: (
91: p_budget_fund_src_id => l_budget_fund_src_id
92: ,p_budget_element_id => p_budget_element_id
93: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
173: --
174: -- Declare cursors and local variables
175: --
176: l_proc varchar2(72) := g_package||'update_budget_fund_src';
177: l_object_version_number pqh_budget_fund_srcs.object_version_number%TYPE ;
178: --
179: begin
180: --
181: hr_utility.set_location('Entering:'|| l_proc, 10);
193: begin
194: --
195: -- Start of API User Hook for the before hook of update_budget_fund_src
196: --
197: pqh_budget_fund_srcs_bk2.update_budget_fund_src_b
198: (
199: p_budget_fund_src_id => p_budget_fund_src_id
200: ,p_budget_element_id => p_budget_element_id
201: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
235: begin
236: --
237: -- Start of API User Hook for the after hook of update_budget_fund_src
238: --
239: pqh_budget_fund_srcs_bk2.update_budget_fund_src_a
240: (
241: p_budget_fund_src_id => p_budget_fund_src_id
242: ,p_budget_element_id => p_budget_element_id
243: ,p_cost_allocation_keyflex_id => p_cost_allocation_keyflex_id
310: --
311: -- Declare cursors and local variables
312: --
313: l_proc varchar2(72) := g_package||'delete_budget_fund_src';
314: l_object_version_number pqh_budget_fund_srcs.object_version_number%TYPE;
315: --
316: begin
317: --
318: hr_utility.set_location('Entering:'|| l_proc, 10);
331: begin
332: --
333: -- Start of API User Hook for the before hook of delete_budget_fund_src
334: --
335: pqh_budget_fund_srcs_bk3.delete_budget_fund_src_b
336: (
337: p_budget_fund_src_id => p_budget_fund_src_id
338: ,p_object_version_number => p_object_version_number
339: );
357: begin
358: --
359: -- Start of API User Hook for the after hook of delete_budget_fund_src
360: --
361: pqh_budget_fund_srcs_bk3.delete_budget_fund_src_a
362: (
363: p_budget_fund_src_id => p_budget_fund_src_id
364: ,p_object_version_number => l_object_version_number
365: );
435: hr_utility.set_location(' Leaving:'||l_proc, 70);
436: --
437: end lck;
438: --
439: end pqh_budget_fund_srcs_api;