DBA Data[Home] [Help]

APPS.PQH_BDGT_CMMTMNT_ELMNTS_API dependencies on PQH_BDGT_CMMTMNT_ELMNTS

Line 1: Package Body pqh_bdgt_cmmtmnt_elmnts_api as

1: Package Body pqh_bdgt_cmmtmnt_elmnts_api as
2: /* $Header: pqbceapi.pkb 115.5 2004/04/28 17:26:35 rthiagar ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqbceapi.pkb 115.5 2004/04/28 17:26:35 rthiagar ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_bdgt_cmmtmnt_elmnts_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_bdgt_cmmtmnt_elmnt >----------------------|
10: -- ----------------------------------------------------------------------------

Line 31: l_bdgt_cmmtmnt_elmnt_id pqh_bdgt_cmmtmnt_elmnts.bdgt_cmmtmnt_elmnt_id%TYPE;

27: ) is
28: --
29: -- Declare cursors and local variables
30: --
31: l_bdgt_cmmtmnt_elmnt_id pqh_bdgt_cmmtmnt_elmnts.bdgt_cmmtmnt_elmnt_id%TYPE;
32: l_proc varchar2(72) := g_package||'create_bdgt_cmmtmnt_elmnt';
33: l_object_version_number pqh_bdgt_cmmtmnt_elmnts.object_version_number%TYPE;
34: --
35: begin

Line 33: l_object_version_number pqh_bdgt_cmmtmnt_elmnts.object_version_number%TYPE;

29: -- Declare cursors and local variables
30: --
31: l_bdgt_cmmtmnt_elmnt_id pqh_bdgt_cmmtmnt_elmnts.bdgt_cmmtmnt_elmnt_id%TYPE;
32: l_proc varchar2(72) := g_package||'create_bdgt_cmmtmnt_elmnt';
33: l_object_version_number pqh_bdgt_cmmtmnt_elmnts.object_version_number%TYPE;
34: --
35: begin
36: --
37: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 51: pqh_bdgt_cmmtmnt_elmnts_bk1.create_bdgt_cmmtmnt_elmnt_b

47: begin
48: --
49: -- Start of API User Hook for the before hook of create_bdgt_cmmtmnt_elmnt
50: --
51: pqh_bdgt_cmmtmnt_elmnts_bk1.create_bdgt_cmmtmnt_elmnt_b
52: (
53: p_budget_id => p_budget_id
54: ,p_actual_commitment_type => p_actual_commitment_type
55: ,p_element_type_id => p_element_type_id

Line 98: pqh_bdgt_cmmtmnt_elmnts_bk1.create_bdgt_cmmtmnt_elmnt_a

94: begin
95: --
96: -- Start of API User Hook for the after hook of create_bdgt_cmmtmnt_elmnt
97: --
98: pqh_bdgt_cmmtmnt_elmnts_bk1.create_bdgt_cmmtmnt_elmnt_a
99: (
100: p_bdgt_cmmtmnt_elmnt_id => l_bdgt_cmmtmnt_elmnt_id
101: ,p_budget_id => p_budget_id
102: ,p_actual_commitment_type => p_actual_commitment_type

Line 191: l_object_version_number pqh_bdgt_cmmtmnt_elmnts.object_version_number%TYPE;

187: --
188: -- Declare cursors and local variables
189: --
190: l_proc varchar2(72) := g_package||'update_bdgt_cmmtmnt_elmnt';
191: l_object_version_number pqh_bdgt_cmmtmnt_elmnts.object_version_number%TYPE;
192: --
193: begin
194: --
195: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 211: pqh_bdgt_cmmtmnt_elmnts_bk2.update_bdgt_cmmtmnt_elmnt_b

207: begin
208: --
209: -- Start of API User Hook for the before hook of update_bdgt_cmmtmnt_elmnt
210: --
211: pqh_bdgt_cmmtmnt_elmnts_bk2.update_bdgt_cmmtmnt_elmnt_b
212: (
213: p_bdgt_cmmtmnt_elmnt_id => p_bdgt_cmmtmnt_elmnt_id
214: ,p_budget_id => p_budget_id
215: ,p_actual_commitment_type => p_actual_commitment_type

Line 259: pqh_bdgt_cmmtmnt_elmnts_bk2.update_bdgt_cmmtmnt_elmnt_a

255: begin
256: --
257: -- Start of API User Hook for the after hook of update_bdgt_cmmtmnt_elmnt
258: --
259: pqh_bdgt_cmmtmnt_elmnts_bk2.update_bdgt_cmmtmnt_elmnt_a
260: (
261: p_bdgt_cmmtmnt_elmnt_id => p_bdgt_cmmtmnt_elmnt_id
262: ,p_budget_id => p_budget_id
263: ,p_actual_commitment_type => p_actual_commitment_type

Line 338: l_object_version_number pqh_bdgt_cmmtmnt_elmnts.object_version_number%TYPE;

334: --
335: -- Declare cursors and local variables
336: --
337: l_proc varchar2(72) := g_package||'delete_bdgt_cmmtmnt_elmnt';
338: l_object_version_number pqh_bdgt_cmmtmnt_elmnts.object_version_number%TYPE;
339: --
340: begin
341: --
342: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 359: pqh_bdgt_cmmtmnt_elmnts_bk3.delete_bdgt_cmmtmnt_elmnt_b

355: begin
356: --
357: -- Start of API User Hook for the before hook of delete_bdgt_cmmtmnt_elmnt
358: --
359: pqh_bdgt_cmmtmnt_elmnts_bk3.delete_bdgt_cmmtmnt_elmnt_b
360: (
361: p_bdgt_cmmtmnt_elmnt_id => p_bdgt_cmmtmnt_elmnt_id
362: ,p_object_version_number => p_object_version_number
363: ,p_effective_date => trunc(p_effective_date)

Line 387: pqh_bdgt_cmmtmnt_elmnts_bk3.delete_bdgt_cmmtmnt_elmnt_a

383: begin
384: --
385: -- Start of API User Hook for the after hook of delete_bdgt_cmmtmnt_elmnt
386: --
387: pqh_bdgt_cmmtmnt_elmnts_bk3.delete_bdgt_cmmtmnt_elmnt_a
388: (
389: p_bdgt_cmmtmnt_elmnt_id => p_bdgt_cmmtmnt_elmnt_id
390: ,p_object_version_number => l_object_version_number
391: ,p_effective_date => trunc(p_effective_date)

Line 466: end pqh_bdgt_cmmtmnt_elmnts_api;

462: hr_utility.set_location(' Leaving:'||l_proc, 70);
463: --
464: end lck;
465: --
466: end pqh_bdgt_cmmtmnt_elmnts_api;