DBA Data[Home] [Help]

APPS.BEN_DSGN_RQMT_RLSHP_TYP_API dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 1: Package Body ben_DSGN_RQMT_RLSHP_TYP_api as

1: Package Body ben_DSGN_RQMT_RLSHP_TYP_api as
2: /* $Header: bedrrapi.pkb 115.2 2002/12/11 10:37:24 lakrish ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: bedrrapi.pkb 115.2 2002/12/11 10:37:24 lakrish ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_DSGN_RQMT_RLSHP_TYP_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_DSGN_RQMT_RLSHP_TYP >----------------------|
10: -- ----------------------------------------------------------------------------

Line 55: l_dsgn_rqmt_rlshp_typ_id ben_dsgn_rqmt_rlshp_typ.dsgn_rqmt_rlshp_typ_id%TYPE;

51: ) is
52: --
53: -- Declare cursors and local variables
54: --
55: l_dsgn_rqmt_rlshp_typ_id ben_dsgn_rqmt_rlshp_typ.dsgn_rqmt_rlshp_typ_id%TYPE;
56: l_proc varchar2(72) := g_package||'create_DSGN_RQMT_RLSHP_TYP';
57: l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;
58: --
59: begin

Line 57: l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;

53: -- Declare cursors and local variables
54: --
55: l_dsgn_rqmt_rlshp_typ_id ben_dsgn_rqmt_rlshp_typ.dsgn_rqmt_rlshp_typ_id%TYPE;
56: l_proc varchar2(72) := g_package||'create_DSGN_RQMT_RLSHP_TYP';
57: l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;
58: --
59: begin
60: --
61: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 75: ben_DSGN_RQMT_RLSHP_TYP_bk1.create_DSGN_RQMT_RLSHP_TYP_b

71: begin
72: --
73: -- Start of API User Hook for the before hook of create_DSGN_RQMT_RLSHP_TYP
74: --
75: ben_DSGN_RQMT_RLSHP_TYP_bk1.create_DSGN_RQMT_RLSHP_TYP_b
76: (
77: p_rlshp_typ_cd => p_rlshp_typ_cd
78: ,p_dsgn_rqmt_id => p_dsgn_rqmt_id
79: ,p_business_group_id => p_business_group_id

Line 170: ben_DSGN_RQMT_RLSHP_TYP_bk1.create_DSGN_RQMT_RLSHP_TYP_a

166: begin
167: --
168: -- Start of API User Hook for the after hook of create_DSGN_RQMT_RLSHP_TYP
169: --
170: ben_DSGN_RQMT_RLSHP_TYP_bk1.create_DSGN_RQMT_RLSHP_TYP_a
171: (
172: p_dsgn_rqmt_rlshp_typ_id => l_dsgn_rqmt_rlshp_typ_id
173: ,p_rlshp_typ_cd => p_rlshp_typ_cd
174: ,p_dsgn_rqmt_id => p_dsgn_rqmt_id

Line 314: l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;

310: --
311: -- Declare cursors and local variables
312: --
313: l_proc varchar2(72) := g_package||'update_DSGN_RQMT_RLSHP_TYP';
314: l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;
315: --
316: begin
317: --
318: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 334: ben_DSGN_RQMT_RLSHP_TYP_bk2.update_DSGN_RQMT_RLSHP_TYP_b

330: begin
331: --
332: -- Start of API User Hook for the before hook of update_DSGN_RQMT_RLSHP_TYP
333: --
334: ben_DSGN_RQMT_RLSHP_TYP_bk2.update_DSGN_RQMT_RLSHP_TYP_b
335: (
336: p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
337: ,p_rlshp_typ_cd => p_rlshp_typ_cd
338: ,p_dsgn_rqmt_id => p_dsgn_rqmt_id

Line 430: ben_DSGN_RQMT_RLSHP_TYP_bk2.update_DSGN_RQMT_RLSHP_TYP_a

426: begin
427: --
428: -- Start of API User Hook for the after hook of update_DSGN_RQMT_RLSHP_TYP
429: --
430: ben_DSGN_RQMT_RLSHP_TYP_bk2.update_DSGN_RQMT_RLSHP_TYP_a
431: (
432: p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
433: ,p_rlshp_typ_cd => p_rlshp_typ_cd
434: ,p_dsgn_rqmt_id => p_dsgn_rqmt_id

Line 532: l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;

528: --
529: -- Declare cursors and local variables
530: --
531: l_proc varchar2(72) := g_package||'update_DSGN_RQMT_RLSHP_TYP';
532: l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;
533: --
534: begin
535: --
536: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 553: ben_DSGN_RQMT_RLSHP_TYP_bk3.delete_DSGN_RQMT_RLSHP_TYP_b

549: begin
550: --
551: -- Start of API User Hook for the before hook of delete_DSGN_RQMT_RLSHP_TYP
552: --
553: ben_DSGN_RQMT_RLSHP_TYP_bk3.delete_DSGN_RQMT_RLSHP_TYP_b
554: (
555: p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
556: ,p_object_version_number => p_object_version_number
557: ,p_effective_date => trunc(p_effective_date)

Line 581: ben_DSGN_RQMT_RLSHP_TYP_bk3.delete_DSGN_RQMT_RLSHP_TYP_a

577: begin
578: --
579: -- Start of API User Hook for the after hook of delete_DSGN_RQMT_RLSHP_TYP
580: --
581: ben_DSGN_RQMT_RLSHP_TYP_bk3.delete_DSGN_RQMT_RLSHP_TYP_a
582: (
583: p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
584: ,p_object_version_number => l_object_version_number
585: ,p_effective_date => trunc(p_effective_date)

Line 660: end ben_DSGN_RQMT_RLSHP_TYP_api;

656: hr_utility.set_location(' Leaving:'||l_proc, 70);
657: --
658: end lck;
659: --
660: end ben_DSGN_RQMT_RLSHP_TYP_api;