DBA Data[Home] [Help]

APPS.PQH_BUDGETS_API dependencies on PQH_BUDGETS

Line 1: Package Body pqh_budgets_api as

1: Package Body pqh_budgets_api as
2: /* $Header: pqbgtapi.pkb 120.1 2005/11/18 11:06:21 srajakum noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqbgtapi.pkb 120.1 2005/11/18 11:06:21 srajakum noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_budgets_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_budget >----------------------|
10: -- ----------------------------------------------------------------------------

Line 46: l_budget_id pqh_budgets.budget_id%TYPE;

42: ) is
43: --
44: -- Declare cursors and local variables
45: --
46: l_budget_id pqh_budgets.budget_id%TYPE;
47: l_proc varchar2(72) := g_package||'create_budget';
48: l_object_version_number pqh_budgets.object_version_number%TYPE;
49: --
50: begin

Line 48: l_object_version_number pqh_budgets.object_version_number%TYPE;

44: -- Declare cursors and local variables
45: --
46: l_budget_id pqh_budgets.budget_id%TYPE;
47: l_proc varchar2(72) := g_package||'create_budget';
48: l_object_version_number pqh_budgets.object_version_number%TYPE;
49: --
50: begin
51: --
52: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 66: pqh_budgets_bk1.create_budget_b

62: begin
63: --
64: -- Start of API User Hook for the before hook of create_budget
65: --
66: pqh_budgets_bk1.create_budget_b
67: (
68: p_business_group_id => p_business_group_id
69: ,p_start_organization_id => p_start_organization_id
70: ,p_org_structure_version_id => p_org_structure_version_id

Line 143: pqh_budgets_bk1.create_budget_a

139: begin
140: --
141: -- Start of API User Hook for the after hook of create_budget
142: --
143: pqh_budgets_bk1.create_budget_a
144: (
145: p_budget_id => l_budget_id
146: ,p_business_group_id => p_business_group_id
147: ,p_start_organization_id => p_start_organization_id

Line 266: l_object_version_number pqh_budgets.object_version_number%TYPE;

262: --
263: -- Declare cursors and local variables
264: --
265: l_proc varchar2(72) := g_package||'update_budget';
266: l_object_version_number pqh_budgets.object_version_number%TYPE;
267: --
268: begin
269: --
270: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 286: pqh_budgets_bk2.update_budget_b

282: begin
283: --
284: -- Start of API User Hook for the before hook of update_budget
285: --
286: pqh_budgets_bk2.update_budget_b
287: (
288: p_budget_id => p_budget_id
289: ,p_business_group_id => p_business_group_id
290: ,p_start_organization_id => p_start_organization_id

Line 364: pqh_budgets_bk2.update_budget_a

360: begin
361: --
362: -- Start of API User Hook for the after hook of update_budget
363: --
364: pqh_budgets_bk2.update_budget_a
365: (
366: p_budget_id => p_budget_id
367: ,p_business_group_id => p_business_group_id
368: ,p_start_organization_id => p_start_organization_id

Line 458: l_object_version_number pqh_budgets.object_version_number%TYPE;

454: --
455: -- Declare cursors and local variables
456: --
457: l_proc varchar2(72) := g_package||'delete_budget';
458: l_object_version_number pqh_budgets.object_version_number%TYPE;
459: --
460: begin
461: --
462: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 479: pqh_budgets_bk3.delete_budget_b

475: begin
476: --
477: -- Start of API User Hook for the before hook of delete_budget
478: --
479: pqh_budgets_bk3.delete_budget_b
480: (
481: p_budget_id => p_budget_id
482: ,p_object_version_number => p_object_version_number
483: ,p_effective_date => trunc(p_effective_date)

Line 507: pqh_budgets_bk3.delete_budget_a

503: begin
504: --
505: -- Start of API User Hook for the after hook of delete_budget
506: --
507: pqh_budgets_bk3.delete_budget_a
508: (
509: p_budget_id => p_budget_id
510: ,p_object_version_number => l_object_version_number
511: ,p_effective_date => trunc(p_effective_date)

Line 586: end pqh_budgets_api;

582: hr_utility.set_location(' Leaving:'||l_proc, 70);
583: --
584: end lck;
585: --
586: end pqh_budgets_api;