DBA Data[Home] [Help]

APPS.PQH_BUDGET_VERSIONS_API dependencies on PQH_BUDGET_VERSIONS

Line 1: Package Body pqh_budget_versions_api as

1: Package Body pqh_budget_versions_api as
2: /* $Header: pqbvrapi.pkb 115.7 2002/12/05 19:30:21 rpasapul ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqbvrapi.pkb 115.7 2002/12/05 19:30:21 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_budget_versions_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_budget_version >----------------------|
10: -- ----------------------------------------------------------------------------

Line 34: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

30: ) is
31: --
32: -- Declare cursors and local variables
33: --
34: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
35: l_proc varchar2(72) := g_package||'create_budget_version';
36: l_object_version_number pqh_budget_versions.object_version_number%TYPE;
37: --
38: begin

Line 36: l_object_version_number pqh_budget_versions.object_version_number%TYPE;

32: -- Declare cursors and local variables
33: --
34: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
35: l_proc varchar2(72) := g_package||'create_budget_version';
36: l_object_version_number pqh_budget_versions.object_version_number%TYPE;
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 54: pqh_budget_versions_bk1.create_budget_version_b

50: begin
51: --
52: -- Start of API User Hook for the before hook of create_budget_version
53: --
54: pqh_budget_versions_bk1.create_budget_version_b
55: (
56: p_budget_id => p_budget_id
57: ,p_version_number => p_version_number
58: ,p_date_from => p_date_from

Line 107: pqh_budget_versions_bk1.create_budget_version_a

103: begin
104: --
105: -- Start of API User Hook for the after hook of create_budget_version
106: --
107: pqh_budget_versions_bk1.create_budget_version_a
108: (
109: p_budget_version_id => l_budget_version_id
110: ,p_budget_id => p_budget_id
111: ,p_version_number => p_version_number

Line 206: l_object_version_number pqh_budget_versions.object_version_number%TYPE;

202: --
203: -- Declare cursors and local variables
204: --
205: l_proc varchar2(72) := g_package||'update_budget_version';
206: l_object_version_number pqh_budget_versions.object_version_number%TYPE;
207: --
208: begin
209: --
210: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 226: pqh_budget_versions_bk2.update_budget_version_b

222: begin
223: --
224: -- Start of API User Hook for the before hook of update_budget_version
225: --
226: pqh_budget_versions_bk2.update_budget_version_b
227: (
228: p_budget_version_id => p_budget_version_id
229: ,p_budget_id => p_budget_id
230: ,p_version_number => p_version_number

Line 280: pqh_budget_versions_bk2.update_budget_version_a

276: begin
277: --
278: -- Start of API User Hook for the after hook of update_budget_version
279: --
280: pqh_budget_versions_bk2.update_budget_version_a
281: (
282: p_budget_version_id => p_budget_version_id
283: ,p_budget_id => p_budget_id
284: ,p_version_number => p_version_number

Line 362: l_object_version_number pqh_budget_versions.object_version_number%TYPE;

358: --
359: -- Declare cursors and local variables
360: --
361: l_proc varchar2(72) := g_package||'delete_budget_version';
362: l_object_version_number pqh_budget_versions.object_version_number%TYPE;
363: --
364: begin
365: --
366: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 383: pqh_budget_versions_bk3.delete_budget_version_b

379: begin
380: --
381: -- Start of API User Hook for the before hook of delete_budget_version
382: --
383: pqh_budget_versions_bk3.delete_budget_version_b
384: (
385: p_budget_version_id => p_budget_version_id
386: ,p_object_version_number => p_object_version_number
387: ,p_effective_date => trunc(p_effective_date)

Line 411: pqh_budget_versions_bk3.delete_budget_version_a

407: begin
408: --
409: -- Start of API User Hook for the after hook of delete_budget_version
410: --
411: pqh_budget_versions_bk3.delete_budget_version_a
412: (
413: p_budget_version_id => p_budget_version_id
414: ,p_object_version_number => l_object_version_number
415: ,p_effective_date => trunc(p_effective_date)

Line 490: end pqh_budget_versions_api;

486: hr_utility.set_location(' Leaving:'||l_proc, 70);
487: --
488: end lck;
489: --
490: end pqh_budget_versions_api;