DBA Data[Home] [Help]

APPS.PQH_WORKSHEET_BDGT_ELMNTS_API dependencies on PQH_WORKSHEET_BDGT_ELMNTS

Line 1: Package Body pqh_WORKSHEET_BDGT_ELMNTS_api as

1: Package Body pqh_WORKSHEET_BDGT_ELMNTS_api as
2: /* $Header: pqwelapi.pkb 115.3 2002/12/06 23:49:47 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

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

Line 23: l_worksheet_bdgt_elmnt_id pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE;

19: ) is
20: --
21: -- Declare cursors and local variables
22: --
23: l_worksheet_bdgt_elmnt_id pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE;
24: l_proc varchar2(72) := g_package||'create_WORKSHEET_BDGT_ELMNT';
25: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;
26: --
27: begin

Line 25: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;

21: -- Declare cursors and local variables
22: --
23: l_worksheet_bdgt_elmnt_id pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE;
24: l_proc varchar2(72) := g_package||'create_WORKSHEET_BDGT_ELMNT';
25: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;
26: --
27: begin
28: --
29: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 43: pqh_WORKSHEET_BDGT_ELMNTS_bk1.create_WORKSHEET_BDGT_ELMNT_b

39: begin
40: --
41: -- Start of API User Hook for the before hook of create_WORKSHEET_BDGT_ELMNT
42: --
43: pqh_WORKSHEET_BDGT_ELMNTS_bk1.create_WORKSHEET_BDGT_ELMNT_b
44: (
45: p_worksheet_budget_set_id => p_worksheet_budget_set_id
46: ,p_element_type_id => p_element_type_id
47: ,p_distribution_percentage => p_distribution_percentage

Line 74: pqh_WORKSHEET_BDGT_ELMNTS_bk1.create_WORKSHEET_BDGT_ELMNT_a

70: begin
71: --
72: -- Start of API User Hook for the after hook of create_WORKSHEET_BDGT_ELMNT
73: --
74: pqh_WORKSHEET_BDGT_ELMNTS_bk1.create_WORKSHEET_BDGT_ELMNT_a
75: (
76: p_worksheet_bdgt_elmnt_id => l_worksheet_bdgt_elmnt_id
77: ,p_worksheet_budget_set_id => p_worksheet_budget_set_id
78: ,p_element_type_id => p_element_type_id

Line 151: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;

147: --
148: -- Declare cursors and local variables
149: --
150: l_proc varchar2(72) := g_package||'update_WORKSHEET_BDGT_ELMNT';
151: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;
152: --
153: begin
154: --
155: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 171: pqh_WORKSHEET_BDGT_ELMNTS_bk2.update_WORKSHEET_BDGT_ELMNT_b

167: begin
168: --
169: -- Start of API User Hook for the before hook of update_WORKSHEET_BDGT_ELMNT
170: --
171: pqh_WORKSHEET_BDGT_ELMNTS_bk2.update_WORKSHEET_BDGT_ELMNT_b
172: (
173: p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id
174: ,p_worksheet_budget_set_id => p_worksheet_budget_set_id
175: ,p_element_type_id => p_element_type_id

Line 203: pqh_WORKSHEET_BDGT_ELMNTS_bk2.update_WORKSHEET_BDGT_ELMNT_a

199: begin
200: --
201: -- Start of API User Hook for the after hook of update_WORKSHEET_BDGT_ELMNT
202: --
203: pqh_WORKSHEET_BDGT_ELMNTS_bk2.update_WORKSHEET_BDGT_ELMNT_a
204: (
205: p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id
206: ,p_worksheet_budget_set_id => p_worksheet_budget_set_id
207: ,p_element_type_id => p_element_type_id

Line 274: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;

270: --
271: -- Declare cursors and local variables
272: --
273: l_proc varchar2(72) := g_package||'delete_WORKSHEET_BDGT_ELMNT';
274: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;
275: --
276: begin
277: --
278: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 295: pqh_WORKSHEET_BDGT_ELMNTS_bk3.delete_WORKSHEET_BDGT_ELMNT_b

291: begin
292: --
293: -- Start of API User Hook for the before hook of delete_WORKSHEET_BDGT_ELMNT
294: --
295: pqh_WORKSHEET_BDGT_ELMNTS_bk3.delete_WORKSHEET_BDGT_ELMNT_b
296: (
297: p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id
298: ,p_object_version_number => p_object_version_number
299: );

Line 321: pqh_WORKSHEET_BDGT_ELMNTS_bk3.delete_WORKSHEET_BDGT_ELMNT_a

317: begin
318: --
319: -- Start of API User Hook for the after hook of delete_WORKSHEET_BDGT_ELMNT
320: --
321: pqh_WORKSHEET_BDGT_ELMNTS_bk3.delete_WORKSHEET_BDGT_ELMNT_a
322: (
323: p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id
324: ,p_object_version_number => l_object_version_number
325: );

Line 399: end pqh_WORKSHEET_BDGT_ELMNTS_api;

395: hr_utility.set_location(' Leaving:'||l_proc, 70);
396: --
397: end lck;
398: --
399: end pqh_WORKSHEET_BDGT_ELMNTS_api;