DBA Data[Home] [Help]

APPS.PQH_BUDGET_DETAILS_API dependencies on PQH_BUDGET_DETAILS

Line 1: Package Body pqh_budget_details_api as

1: Package Body pqh_budget_details_api as
2: /* $Header: pqbdtapi.pkb 115.6 2002/12/05 16:33:01 rpasapul ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqbdtapi.pkb 115.6 2002/12/05 16:33:01 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_budget_details_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_budget_detail >----------------------|
10: -- ----------------------------------------------------------------------------

Line 38: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;

34: ) is
35: --
36: -- Declare cursors and local variables
37: --
38: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
39: l_proc varchar2(72) := g_package||'create_budget_detail';
40: l_object_version_number pqh_budget_details.object_version_number%TYPE;
41: --
42: begin

Line 40: l_object_version_number pqh_budget_details.object_version_number%TYPE;

36: -- Declare cursors and local variables
37: --
38: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
39: l_proc varchar2(72) := g_package||'create_budget_detail';
40: l_object_version_number pqh_budget_details.object_version_number%TYPE;
41: --
42: begin
43: --
44: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 58: pqh_budget_details_bk1.create_budget_detail_b

54: begin
55: --
56: -- Start of API User Hook for the before hook of create_budget_detail
57: --
58: pqh_budget_details_bk1.create_budget_detail_b
59: (
60: p_organization_id => p_organization_id
61: ,p_job_id => p_job_id
62: ,p_position_id => p_position_id

Line 119: pqh_budget_details_bk1.create_budget_detail_a

115: begin
116: --
117: -- Start of API User Hook for the after hook of create_budget_detail
118: --
119: pqh_budget_details_bk1.create_budget_detail_a
120: (
121: p_budget_detail_id => l_budget_detail_id
122: ,p_organization_id => p_organization_id
123: ,p_job_id => p_job_id

Line 226: l_object_version_number pqh_budget_details.object_version_number%TYPE;

222: --
223: -- Declare cursors and local variables
224: --
225: l_proc varchar2(72) := g_package||'update_budget_detail';
226: l_object_version_number pqh_budget_details.object_version_number%TYPE;
227: --
228: begin
229: --
230: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 246: pqh_budget_details_bk2.update_budget_detail_b

242: begin
243: --
244: -- Start of API User Hook for the before hook of update_budget_detail
245: --
246: pqh_budget_details_bk2.update_budget_detail_b
247: (
248: p_budget_detail_id => p_budget_detail_id
249: ,p_organization_id => p_organization_id
250: ,p_job_id => p_job_id

Line 308: pqh_budget_details_bk2.update_budget_detail_a

304: begin
305: --
306: -- Start of API User Hook for the after hook of update_budget_detail
307: --
308: pqh_budget_details_bk2.update_budget_detail_a
309: (
310: p_budget_detail_id => p_budget_detail_id
311: ,p_organization_id => p_organization_id
312: ,p_job_id => p_job_id

Line 393: l_object_version_number pqh_budget_details.object_version_number%TYPE;

389: --
390: -- Declare cursors and local variables
391: --
392: l_proc varchar2(72) := g_package||'delete_budget_detail';
393: l_object_version_number pqh_budget_details.object_version_number%TYPE;
394: --
395: begin
396: --
397: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 414: pqh_budget_details_bk3.delete_budget_detail_b

410: begin
411: --
412: -- Start of API User Hook for the before hook of delete_budget_detail
413: --
414: pqh_budget_details_bk3.delete_budget_detail_b
415: (
416: p_budget_detail_id => p_budget_detail_id
417: ,p_object_version_number => p_object_version_number
418: );

Line 440: pqh_budget_details_bk3.delete_budget_detail_a

436: begin
437: --
438: -- Start of API User Hook for the after hook of delete_budget_detail
439: --
440: pqh_budget_details_bk3.delete_budget_detail_a
441: (
442: p_budget_detail_id => p_budget_detail_id
443: ,p_object_version_number => l_object_version_number
444: );

Line 518: end pqh_budget_details_api;

514: hr_utility.set_location(' Leaving:'||l_proc, 70);
515: --
516: end lck;
517: --
518: end pqh_budget_details_api;