APPS.PQH_BUDGET_SETS_API dependencies on PQH_BUDGET_SETS

Line 1: Package Body pqh_budget_sets_api as

1: Package Body pqh_budget_sets_api as
2: /* $Header: pqbstapi.pkb 115.7 2002/12/10 00:28:18 rpasapul ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' pqh_budget_sets_api.';

2: /* $Header: pqbstapi.pkb 115.7 2002/12/10 00:28:18 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_budget_sets_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_budget_set >----------------------|
10: -- ----------------------------------------------------------------------------

Line 35: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;

31: ) is
32: --
33: -- Declare cursors and local variables
34: --
35: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
36: l_proc varchar2(72) := g_package||'create_budget_set';
37: l_object_version_number pqh_budget_sets.object_version_number%TYPE;
38: --
39: begin

Line 37: l_object_version_number pqh_budget_sets.object_version_number%TYPE;

33: -- Declare cursors and local variables
34: --
35: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
36: l_proc varchar2(72) := g_package||'create_budget_set';
37: l_object_version_number pqh_budget_sets.object_version_number%TYPE;
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 55: pqh_budget_sets_bk1.create_budget_set_b

51: begin
52: --
53: -- Start of API User Hook for the before hook of create_budget_set
54: --
55: pqh_budget_sets_bk1.create_budget_set_b
56: (
57: p_dflt_budget_set_id => p_dflt_budget_set_id
58: ,p_budget_period_id => p_budget_period_id
59: ,p_budget_unit1_percent => p_budget_unit1_percent

Line 110: pqh_budget_sets_bk1.create_budget_set_a

106: begin
107: --
108: -- Start of API User Hook for the after hook of create_budget_set
109: --
110: pqh_budget_sets_bk1.create_budget_set_a
111: (
112: p_budget_set_id => l_budget_set_id
113: ,p_dflt_budget_set_id => p_dflt_budget_set_id
114: ,p_budget_period_id => p_budget_period_id

Line 212: l_object_version_number pqh_budget_sets.object_version_number%TYPE;

208: --
209: -- Declare cursors and local variables
210: --
211: l_proc varchar2(72) := g_package||'update_budget_set';
212: l_object_version_number pqh_budget_sets.object_version_number%TYPE;
213: --
214: begin
215: --
216: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 232: pqh_budget_sets_bk2.update_budget_set_b

228: begin
229: --
230: -- Start of API User Hook for the before hook of update_budget_set
231: --
232: pqh_budget_sets_bk2.update_budget_set_b
233: (
234: p_budget_set_id => p_budget_set_id
235: ,p_dflt_budget_set_id => p_dflt_budget_set_id
236: ,p_budget_period_id => p_budget_period_id

Line 288: pqh_budget_sets_bk2.update_budget_set_a

284: begin
285: --
286: -- Start of API User Hook for the after hook of update_budget_set
287: --
288: pqh_budget_sets_bk2.update_budget_set_a
289: (
290: p_budget_set_id => p_budget_set_id
291: ,p_dflt_budget_set_id => p_dflt_budget_set_id
292: ,p_budget_period_id => p_budget_period_id

Line 371: l_object_version_number pqh_budget_sets.object_version_number%TYPE;

367: --
368: -- Declare cursors and local variables
369: --
370: l_proc varchar2(72) := g_package||'delete_budget_set';
371: l_object_version_number pqh_budget_sets.object_version_number%TYPE;
372: --
373: begin
374: --
375: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 392: pqh_budget_sets_bk3.delete_budget_set_b

388: begin
389: --
390: -- Start of API User Hook for the before hook of delete_budget_set
391: --
392: pqh_budget_sets_bk3.delete_budget_set_b
393: (
394: p_budget_set_id => p_budget_set_id
395: ,p_object_version_number => p_object_version_number
396: ,p_effective_date => trunc(p_effective_date)

Line 420: pqh_budget_sets_bk3.delete_budget_set_a

416: begin
417: --
418: -- Start of API User Hook for the after hook of delete_budget_set
419: --
420: pqh_budget_sets_bk3.delete_budget_set_a
421: (
422: p_budget_set_id => p_budget_set_id
423: ,p_object_version_number => l_object_version_number
424: ,p_effective_date => trunc(p_effective_date)

Line 499: end pqh_budget_sets_api;

495: hr_utility.set_location(' Leaving:'||l_proc, 70);
496: --
497: end lck;
498: --
499: end pqh_budget_sets_api;