APPS.PQH_WORKSHEET_PERIODS_API dependencies on PQH_WORKSHEET_PERIODS

Line 1: Package Body pqh_WORKSHEET_PERIODS_api as

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

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

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

Line 36: l_worksheet_period_id pqh_worksheet_periods.worksheet_period_id%TYPE;

32: ) is
33: --
34: -- Declare cursors and local variables
35: --
36: l_worksheet_period_id pqh_worksheet_periods.worksheet_period_id%TYPE;
37: l_proc varchar2(72) := g_package||'create_WORKSHEET_PERIOD';
38: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;
39: --
40: begin

Line 38: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;

34: -- Declare cursors and local variables
35: --
36: l_worksheet_period_id pqh_worksheet_periods.worksheet_period_id%TYPE;
37: l_proc varchar2(72) := g_package||'create_WORKSHEET_PERIOD';
38: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;
39: --
40: begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 56: pqh_WORKSHEET_PERIODS_bk1.create_WORKSHEET_PERIOD_b

52: begin
53: --
54: -- Start of API User Hook for the before hook of create_WORKSHEET_PERIOD
55: --
56: pqh_WORKSHEET_PERIODS_bk1.create_WORKSHEET_PERIOD_b
57: (
58: p_end_time_period_id => p_end_time_period_id
59: ,p_worksheet_detail_id => p_worksheet_detail_id
60: ,p_budget_unit1_percent => p_budget_unit1_percent

Line 113: pqh_WORKSHEET_PERIODS_bk1.create_WORKSHEET_PERIOD_a

109: begin
110: --
111: -- Start of API User Hook for the after hook of create_WORKSHEET_PERIOD
112: --
113: pqh_WORKSHEET_PERIODS_bk1.create_WORKSHEET_PERIOD_a
114: (
115: p_worksheet_period_id => l_worksheet_period_id
116: ,p_end_time_period_id => p_end_time_period_id
117: ,p_worksheet_detail_id => p_worksheet_detail_id

Line 216: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;

212: --
213: -- Declare cursors and local variables
214: --
215: l_proc varchar2(72) := g_package||'update_WORKSHEET_PERIOD';
216: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;
217: --
218: begin
219: --
220: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 236: pqh_WORKSHEET_PERIODS_bk2.update_WORKSHEET_PERIOD_b

232: begin
233: --
234: -- Start of API User Hook for the before hook of update_WORKSHEET_PERIOD
235: --
236: pqh_WORKSHEET_PERIODS_bk2.update_WORKSHEET_PERIOD_b
237: (
238: p_worksheet_period_id => p_worksheet_period_id
239: ,p_end_time_period_id => p_end_time_period_id
240: ,p_worksheet_detail_id => p_worksheet_detail_id

Line 294: pqh_WORKSHEET_PERIODS_bk2.update_WORKSHEET_PERIOD_a

290: begin
291: --
292: -- Start of API User Hook for the after hook of update_WORKSHEET_PERIOD
293: --
294: pqh_WORKSHEET_PERIODS_bk2.update_WORKSHEET_PERIOD_a
295: (
296: p_worksheet_period_id => p_worksheet_period_id
297: ,p_end_time_period_id => p_end_time_period_id
298: ,p_worksheet_detail_id => p_worksheet_detail_id

Line 378: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;

374: --
375: -- Declare cursors and local variables
376: --
377: l_proc varchar2(72) := g_package||'delete_WORKSHEET_PERIOD';
378: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;
379: --
380: begin
381: --
382: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 399: pqh_WORKSHEET_PERIODS_bk3.delete_WORKSHEET_PERIOD_b

395: begin
396: --
397: -- Start of API User Hook for the before hook of delete_WORKSHEET_PERIOD
398: --
399: pqh_WORKSHEET_PERIODS_bk3.delete_WORKSHEET_PERIOD_b
400: (
401: p_worksheet_period_id => p_worksheet_period_id
402: ,p_object_version_number => p_object_version_number
403: ,p_effective_date => trunc(p_effective_date)

Line 427: pqh_WORKSHEET_PERIODS_bk3.delete_WORKSHEET_PERIOD_a

423: begin
424: --
425: -- Start of API User Hook for the after hook of delete_WORKSHEET_PERIOD
426: --
427: pqh_WORKSHEET_PERIODS_bk3.delete_WORKSHEET_PERIOD_a
428: (
429: p_worksheet_period_id => p_worksheet_period_id
430: ,p_object_version_number => l_object_version_number
431: ,p_effective_date => trunc(p_effective_date)

Line 506: end pqh_WORKSHEET_PERIODS_api;

502: hr_utility.set_location(' Leaving:'||l_proc, 70);
503: --
504: end lck;
505: --
506: end pqh_WORKSHEET_PERIODS_api;