APPS.PQH_WORKSHEETS_API dependencies on PQH_WORKSHEETS

Line 1: Package Body pqh_WORKSHEETS_api as

1: Package Body pqh_WORKSHEETS_api as
2: /* $Header: pqwksapi.pkb 115.5 2002/12/06 23:49:58 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqwksapi.pkb 115.5 2002/12/06 23:49:58 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_WORKSHEETS_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_WORKSHEET >----------------------|
10: -- ----------------------------------------------------------------------------

Line 32: l_worksheet_id pqh_worksheets.worksheet_id%TYPE;

28: ) is
29: --
30: -- Declare cursors and local variables
31: --
32: l_worksheet_id pqh_worksheets.worksheet_id%TYPE;
33: l_proc varchar2(72) := g_package||'create_WORKSHEET';
34: l_object_version_number pqh_worksheets.object_version_number%TYPE;
35: --
36: begin

Line 34: l_object_version_number pqh_worksheets.object_version_number%TYPE;

30: -- Declare cursors and local variables
31: --
32: l_worksheet_id pqh_worksheets.worksheet_id%TYPE;
33: l_proc varchar2(72) := g_package||'create_WORKSHEET';
34: l_object_version_number pqh_worksheets.object_version_number%TYPE;
35: --
36: begin
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 52: pqh_WORKSHEETS_bk1.create_WORKSHEET_b

48: begin
49: --
50: -- Start of API User Hook for the before hook of create_WORKSHEET
51: --
52: pqh_WORKSHEETS_bk1.create_WORKSHEET_b
53: (
54: p_budget_id => p_budget_id
55: ,p_worksheet_name => p_worksheet_name
56: ,p_version_number => p_version_number

Line 101: pqh_WORKSHEETS_bk1.create_WORKSHEET_a

97: begin
98: --
99: -- Start of API User Hook for the after hook of create_WORKSHEET
100: --
101: pqh_WORKSHEETS_bk1.create_WORKSHEET_a
102: (
103: p_worksheet_id => l_worksheet_id
104: ,p_budget_id => p_budget_id
105: ,p_worksheet_name => p_worksheet_name

Line 196: l_object_version_number pqh_worksheets.object_version_number%TYPE;

192: --
193: -- Declare cursors and local variables
194: --
195: l_proc varchar2(72) := g_package||'update_WORKSHEET';
196: l_object_version_number pqh_worksheets.object_version_number%TYPE;
197: --
198: begin
199: --
200: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 216: pqh_WORKSHEETS_bk2.update_WORKSHEET_b

212: begin
213: --
214: -- Start of API User Hook for the before hook of update_WORKSHEET
215: --
216: pqh_WORKSHEETS_bk2.update_WORKSHEET_b
217: (
218: p_worksheet_id => p_worksheet_id
219: ,p_budget_id => p_budget_id
220: ,p_worksheet_name => p_worksheet_name

Line 266: pqh_WORKSHEETS_bk2.update_WORKSHEET_a

262: begin
263: --
264: -- Start of API User Hook for the after hook of update_WORKSHEET
265: --
266: pqh_WORKSHEETS_bk2.update_WORKSHEET_a
267: (
268: p_worksheet_id => p_worksheet_id
269: ,p_budget_id => p_budget_id
270: ,p_worksheet_name => p_worksheet_name

Line 346: l_object_version_number pqh_worksheets.object_version_number%TYPE;

342: --
343: -- Declare cursors and local variables
344: --
345: l_proc varchar2(72) := g_package||'delete_WORKSHEET';
346: l_object_version_number pqh_worksheets.object_version_number%TYPE;
347: --
348: begin
349: --
350: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 367: pqh_WORKSHEETS_bk3.delete_WORKSHEET_b

363: begin
364: --
365: -- Start of API User Hook for the before hook of delete_WORKSHEET
366: --
367: pqh_WORKSHEETS_bk3.delete_WORKSHEET_b
368: (
369: p_worksheet_id => p_worksheet_id
370: ,p_object_version_number => p_object_version_number
371: ,p_effective_date => trunc(p_effective_date)

Line 395: pqh_WORKSHEETS_bk3.delete_WORKSHEET_a

391: begin
392: --
393: -- Start of API User Hook for the after hook of delete_WORKSHEET
394: --
395: pqh_WORKSHEETS_bk3.delete_WORKSHEET_a
396: (
397: p_worksheet_id => p_worksheet_id
398: ,p_object_version_number => l_object_version_number
399: ,p_effective_date => trunc(p_effective_date)

Line 474: end pqh_WORKSHEETS_api;

470: hr_utility.set_location(' Leaving:'||l_proc, 70);
471: --
472: end lck;
473: --
474: end pqh_WORKSHEETS_api;