[Home] [Help]
1: Package Body pqh_dflt_fund_srcs_api as
2: /* $Header: pqdfsapi.pkb 115.5 2002/11/27 23:43:12 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pqdfsapi.pkb 115.5 2002/11/27 23:43:12 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_dflt_fund_srcs_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_dflt_fund_src >----------------------|
10: -- ----------------------------------------------------------------------------
24: ) is
25: --
26: -- Declare cursors and local variables
27: --
28: l_dflt_fund_src_id pqh_dflt_fund_srcs.dflt_fund_src_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_dflt_fund_src';
30: l_object_version_number pqh_dflt_fund_srcs.object_version_number%TYPE;
31: --
32: begin
26: -- Declare cursors and local variables
27: --
28: l_dflt_fund_src_id pqh_dflt_fund_srcs.dflt_fund_src_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_dflt_fund_src';
30: l_object_version_number pqh_dflt_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_dflt_fund_src
47: --
48: pqh_dflt_fund_srcs_bk1.create_dflt_fund_src_b
49: (
50: p_dflt_budget_element_id => p_dflt_budget_element_id
51: ,p_dflt_dist_percentage => p_dflt_dist_percentage
52: ,p_project_id => p_project_id
85: begin
86: --
87: -- Start of API User Hook for the after hook of create_dflt_fund_src
88: --
89: pqh_dflt_fund_srcs_bk1.create_dflt_fund_src_a
90: (
91: p_dflt_fund_src_id => l_dflt_fund_src_id
92: ,p_dflt_budget_element_id => p_dflt_budget_element_id
93: ,p_dflt_dist_percentage => p_dflt_dist_percentage
172: --
173: -- Declare cursors and local variables
174: --
175: l_proc varchar2(72) := g_package||'update_dflt_fund_src';
176: l_object_version_number pqh_dflt_fund_srcs.object_version_number%TYPE;
177: --
178: begin
179: --
180: hr_utility.set_location('Entering:'|| l_proc, 10);
192: begin
193: --
194: -- Start of API User Hook for the before hook of update_dflt_fund_src
195: --
196: pqh_dflt_fund_srcs_bk2.update_dflt_fund_src_b
197: (
198: p_dflt_fund_src_id => p_dflt_fund_src_id
199: ,p_dflt_budget_element_id => p_dflt_budget_element_id
200: ,p_dflt_dist_percentage => p_dflt_dist_percentage
234: begin
235: --
236: -- Start of API User Hook for the after hook of update_dflt_fund_src
237: --
238: pqh_dflt_fund_srcs_bk2.update_dflt_fund_src_a
239: (
240: p_dflt_fund_src_id => p_dflt_fund_src_id
241: ,p_dflt_budget_element_id => p_dflt_budget_element_id
242: ,p_dflt_dist_percentage => p_dflt_dist_percentage
309: --
310: -- Declare cursors and local variables
311: --
312: l_proc varchar2(72) := g_package||'delete_dflt_fund_src';
313: l_object_version_number pqh_dflt_fund_srcs.object_version_number%TYPE;
314: --
315: begin
316: --
317: hr_utility.set_location('Entering:'|| l_proc, 10);
330: begin
331: --
332: -- Start of API User Hook for the before hook of delete_dflt_fund_src
333: --
334: pqh_dflt_fund_srcs_bk3.delete_dflt_fund_src_b
335: (
336: p_dflt_fund_src_id => p_dflt_fund_src_id
337: ,p_object_version_number => p_object_version_number
338: );
356: begin
357: --
358: -- Start of API User Hook for the after hook of delete_dflt_fund_src
359: --
360: pqh_dflt_fund_srcs_bk3.delete_dflt_fund_src_a
361: (
362: p_dflt_fund_src_id => p_dflt_fund_src_id
363: ,p_object_version_number => l_object_version_number
364: );
434: hr_utility.set_location(' Leaving:'||l_proc, 70);
435: --
436: end lck;
437: --
438: end pqh_dflt_fund_srcs_api;