eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WORKSHEET_BUDGET_SETS_API dependencies on PQH_WORKSHEET_BUDGET_SETS

Line 1: Package Body pqh_WORKSHEET_BUDGET_SETS_api as

1: Package Body pqh_WORKSHEET_BUDGET_SETS_api as
2: /* $Header: pqwstapi.pkb 115.3 2002/12/06 23:50:22 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqwstapi.pkb 115.3 2002/12/06 23:50:22 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_WORKSHEET_BUDGET_SETS_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_WORKSHEET_BUDGET_SET >----------------------|
10: -- ----------------------------------------------------------------------------

Line 35: l_worksheet_budget_set_id pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE;

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

Line 37: l_object_version_number pqh_worksheet_budget_sets.object_version_number%TYPE;

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

Line 55: pqh_WORKSHEET_BUDGET_SETS_bk1.create_WORKSHEET_BUDGET_SET_b

51: begin
52: --
53: -- Start of API User Hook for the before hook of create_WORKSHEET_BUDGET_SET
54: --
55: pqh_WORKSHEET_BUDGET_SETS_bk1.create_WORKSHEET_BUDGET_SET_b
56: (
57: p_dflt_budget_set_id => p_dflt_budget_set_id
58: ,p_worksheet_period_id => p_worksheet_period_id
59: ,p_budget_unit1_percent => p_budget_unit1_percent

Line 110: pqh_WORKSHEET_BUDGET_SETS_bk1.create_WORKSHEET_BUDGET_SET_a

106: begin
107: --
108: -- Start of API User Hook for the after hook of create_WORKSHEET_BUDGET_SET
109: --
110: pqh_WORKSHEET_BUDGET_SETS_bk1.create_WORKSHEET_BUDGET_SET_a
111: (
112: p_worksheet_budget_set_id => l_worksheet_budget_set_id
113: ,p_dflt_budget_set_id => p_dflt_budget_set_id
114: ,p_worksheet_period_id => p_worksheet_period_id

Line 211: l_object_version_number pqh_worksheet_budget_sets.object_version_number%TYPE;

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

Line 231: pqh_WORKSHEET_BUDGET_SETS_bk2.update_WORKSHEET_BUDGET_SET_b

227: begin
228: --
229: -- Start of API User Hook for the before hook of update_WORKSHEET_BUDGET_SET
230: --
231: pqh_WORKSHEET_BUDGET_SETS_bk2.update_WORKSHEET_BUDGET_SET_b
232: (
233: p_worksheet_budget_set_id => p_worksheet_budget_set_id
234: ,p_dflt_budget_set_id => p_dflt_budget_set_id
235: ,p_worksheet_period_id => p_worksheet_period_id

Line 287: pqh_WORKSHEET_BUDGET_SETS_bk2.update_WORKSHEET_BUDGET_SET_a

283: begin
284: --
285: -- Start of API User Hook for the after hook of update_WORKSHEET_BUDGET_SET
286: --
287: pqh_WORKSHEET_BUDGET_SETS_bk2.update_WORKSHEET_BUDGET_SET_a
288: (
289: p_worksheet_budget_set_id => p_worksheet_budget_set_id
290: ,p_dflt_budget_set_id => p_dflt_budget_set_id
291: ,p_worksheet_period_id => p_worksheet_period_id

Line 370: l_object_version_number pqh_worksheet_budget_sets.object_version_number%TYPE;

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

Line 391: pqh_WORKSHEET_BUDGET_SETS_bk3.delete_WORKSHEET_BUDGET_SET_b

387: begin
388: --
389: -- Start of API User Hook for the before hook of delete_WORKSHEET_BUDGET_SET
390: --
391: pqh_WORKSHEET_BUDGET_SETS_bk3.delete_WORKSHEET_BUDGET_SET_b
392: (
393: p_worksheet_budget_set_id => p_worksheet_budget_set_id
394: ,p_object_version_number => p_object_version_number
395: ,p_effective_date => trunc(p_effective_date)

Line 419: pqh_WORKSHEET_BUDGET_SETS_bk3.delete_WORKSHEET_BUDGET_SET_a

415: begin
416: --
417: -- Start of API User Hook for the after hook of delete_WORKSHEET_BUDGET_SET
418: --
419: pqh_WORKSHEET_BUDGET_SETS_bk3.delete_WORKSHEET_BUDGET_SET_a
420: (
421: p_worksheet_budget_set_id => p_worksheet_budget_set_id
422: ,p_object_version_number => l_object_version_number
423: ,p_effective_date => trunc(p_effective_date)

Line 498: end pqh_WORKSHEET_BUDGET_SETS_api;

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