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_DETAILS_API dependencies on PQH_WORKSHEET_DETAILS

Line 1: Package Body pqh_WORKSHEET_DETAILS_api as

1: Package Body pqh_WORKSHEET_DETAILS_api as
2: /* $Header: pqwdtapi.pkb 120.1.12000000.1 2007/01/17 00:29:36 appldev noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqwdtapi.pkb 120.1.12000000.1 2007/01/17 00:29:36 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_WORKSHEET_DETAILS_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_WORKSHEET_DETAIL >----------------------|
10: -- ----------------------------------------------------------------------------

Line 49: l_worksheet_detail_id pqh_worksheet_details.worksheet_detail_id%TYPE;

45: ) is
46: --
47: -- Declare cursors and local variables
48: --
49: l_worksheet_detail_id pqh_worksheet_details.worksheet_detail_id%TYPE;
50: l_proc varchar2(72) := g_package||'create_WORKSHEET_DETAIL';
51: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
52: --
53: begin

Line 51: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;

47: -- Declare cursors and local variables
48: --
49: l_worksheet_detail_id pqh_worksheet_details.worksheet_detail_id%TYPE;
50: l_proc varchar2(72) := g_package||'create_WORKSHEET_DETAIL';
51: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
52: --
53: begin
54: --
55: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 69: pqh_WORKSHEET_DETAILS_bk1.create_WORKSHEET_DETAIL_b

65: begin
66: --
67: -- Start of API User Hook for the before hook of create_WORKSHEET_DETAIL
68: --
69: pqh_WORKSHEET_DETAILS_bk1.create_WORKSHEET_DETAIL_b
70: (
71: p_worksheet_id => p_worksheet_id
72: ,p_organization_id => p_organization_id
73: ,p_job_id => p_job_id

Line 152: pqh_WORKSHEET_DETAILS_bk1.create_WORKSHEET_DETAIL_a

148: begin
149: --
150: -- Start of API User Hook for the after hook of create_WORKSHEET_DETAIL
151: --
152: pqh_WORKSHEET_DETAILS_bk1.create_WORKSHEET_DETAIL_a
153: (
154: p_worksheet_detail_id => l_worksheet_detail_id
155: ,p_worksheet_id => p_worksheet_id
156: ,p_organization_id => p_organization_id

Line 282: l_worksheet_detail_id pqh_worksheet_details.worksheet_detail_id%TYPE;

278: ) is
279: --
280: -- Declare cursors and local variables
281: --
282: l_worksheet_detail_id pqh_worksheet_details.worksheet_detail_id%TYPE;
283: l_proc varchar2(72) := g_package||'create_WORKSHEET_DETAIL_BP';
284: l_wkd_ovn pqh_worksheet_details.object_version_number%TYPE;
285: l_wpr_ovn pqh_worksheet_periods.object_version_number%TYPE;
286: l_worksheet_period_id pqh_worksheet_periods.worksheet_period_id%TYPE;

Line 284: l_wkd_ovn pqh_worksheet_details.object_version_number%TYPE;

280: -- Declare cursors and local variables
281: --
282: l_worksheet_detail_id pqh_worksheet_details.worksheet_detail_id%TYPE;
283: l_proc varchar2(72) := g_package||'create_WORKSHEET_DETAIL_BP';
284: l_wkd_ovn pqh_worksheet_details.object_version_number%TYPE;
285: l_wpr_ovn pqh_worksheet_periods.object_version_number%TYPE;
286: l_worksheet_period_id pqh_worksheet_periods.worksheet_period_id%TYPE;
287: l_budget_unit1_available number;
288: l_budget_unit2_available number;

Line 306: pqh_WORKSHEET_DETAILS_api.create_WORKSHEET_DETAIL

302: l_budget_unit3_available := p_budget_unit3_available;
303: end if;
304: -- call the create worksheet details API
305: --
306: pqh_WORKSHEET_DETAILS_api.create_WORKSHEET_DETAIL
307: (
308: p_validate => p_validate
309: ,p_worksheet_detail_id => l_worksheet_detail_id
310: ,p_worksheet_id => p_worksheet_id

Line 423: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;

419: --
420: -- Declare cursors and local variables
421: --
422: l_proc varchar2(72) := g_package||'update_WORKSHEET_DETAIL';
423: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
424: --
425: begin
426: --
427: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 443: pqh_WORKSHEET_DETAILS_bk2.update_WORKSHEET_DETAIL_b

439: begin
440: --
441: -- Start of API User Hook for the before hook of update_WORKSHEET_DETAIL
442: --
443: pqh_WORKSHEET_DETAILS_bk2.update_WORKSHEET_DETAIL_b
444: (
445: p_worksheet_detail_id => p_worksheet_detail_id
446: ,p_worksheet_id => p_worksheet_id
447: ,p_organization_id => p_organization_id

Line 527: pqh_WORKSHEET_DETAILS_bk2.update_WORKSHEET_DETAIL_a

523: begin
524: --
525: -- Start of API User Hook for the after hook of update_WORKSHEET_DETAIL
526: --
527: pqh_WORKSHEET_DETAILS_bk2.update_WORKSHEET_DETAIL_a
528: (
529: p_worksheet_detail_id => p_worksheet_detail_id
530: ,p_worksheet_id => p_worksheet_id
531: ,p_organization_id => p_organization_id

Line 624: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;

620: --
621: -- Declare cursors and local variables
622: --
623: l_proc varchar2(72) := g_package||'delete_WORKSHEET_DETAIL';
624: l_object_version_number pqh_worksheet_details.object_version_number%TYPE;
625: --
626: begin
627: --
628: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 645: pqh_WORKSHEET_DETAILS_bk3.delete_WORKSHEET_DETAIL_b

641: begin
642: --
643: -- Start of API User Hook for the before hook of delete_WORKSHEET_DETAIL
644: --
645: pqh_WORKSHEET_DETAILS_bk3.delete_WORKSHEET_DETAIL_b
646: (
647: p_worksheet_detail_id => p_worksheet_detail_id
648: ,p_object_version_number => p_object_version_number
649: ,p_effective_date => trunc(p_effective_date)

Line 673: pqh_WORKSHEET_DETAILS_bk3.delete_WORKSHEET_DETAIL_a

669: begin
670: --
671: -- Start of API User Hook for the after hook of delete_WORKSHEET_DETAIL
672: --
673: pqh_WORKSHEET_DETAILS_bk3.delete_WORKSHEET_DETAIL_a
674: (
675: p_worksheet_detail_id => p_worksheet_detail_id
676: ,p_object_version_number => l_object_version_number
677: ,p_effective_date => trunc(p_effective_date)

Line 752: end pqh_WORKSHEET_DETAILS_api;

748: hr_utility.set_location(' Leaving:'||l_proc, 70);
749: --
750: end lck;
751: --
752: end pqh_WORKSHEET_DETAILS_api;