DBA Data[Home] [Help]

APPS.BEN_PGM_EXTRA_INFO_API dependencies on BEN_PGM_EXTRA_INFO

Line 1: Package Body ben_pgm_extra_info_api as

1: Package Body ben_pgm_extra_info_api as
2: /* $Header: bepgiapi.pkb 115.0 2003/09/23 10:20:09 hmani noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: bepgiapi.pkb 115.0 2003/09/23 10:20:09 hmani noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_pgm_extra_info_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |----------------------< create_pgm_extra_info >----------------------|
10: -- ----------------------------------------------------------------------------

Line 75: l_object_version_number ben_pgm_extra_info.object_version_number%type;

71: --
72: -- Declare cursors and local variables
73: --
74: l_proc varchar2(72) := g_package||'create_pgm_extra_info';
75: l_object_version_number ben_pgm_extra_info.object_version_number%type;
76: l_pgm_extra_info_id ben_pgm_extra_info.pgm_extra_info_id%type;
77: --
78: begin
79: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 76: l_pgm_extra_info_id ben_pgm_extra_info.pgm_extra_info_id%type;

72: -- Declare cursors and local variables
73: --
74: l_proc varchar2(72) := g_package||'create_pgm_extra_info';
75: l_object_version_number ben_pgm_extra_info.object_version_number%type;
76: l_pgm_extra_info_id ben_pgm_extra_info.pgm_extra_info_id%type;
77: --
78: begin
79: hr_utility.set_location('Entering:'|| l_proc, 5);
80: --

Line 89: ben_pgm_extra_info_bk1.create_pgm_extra_info_b

85: -- Call Before Process User Hook
86: --
87: begin
88:
89: ben_pgm_extra_info_bk1.create_pgm_extra_info_b
90: (
91: p_information_type => p_information_type,
92: p_pgm_id => p_pgm_id,
93: p_pgi_attribute_category => p_pgi_attribute_category,

Line 226: ben_pgm_extra_info_bk1.create_pgm_extra_info_a

222: --
223: -- Call After Process User Hook
224: --
225: begin
226: ben_pgm_extra_info_bk1.create_pgm_extra_info_a
227: (
228: p_pgm_extra_info_id => l_pgm_extra_info_id,
229: p_information_type => p_information_type,
230: p_pgm_id => p_pgm_id,

Line 399: l_object_version_number ben_pgm_extra_info.object_version_number%TYPE;

395: --
396: -- Declare cursors and local variables
397: --
398: l_proc varchar2(72) := g_package||'update_pgm_extra_info';
399: l_object_version_number ben_pgm_extra_info.object_version_number%TYPE;
400: l_ovn ben_pgm_extra_info.object_version_number%TYPE := p_object_version_number;
401: --
402: begin
403: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 400: l_ovn ben_pgm_extra_info.object_version_number%TYPE := p_object_version_number;

396: -- Declare cursors and local variables
397: --
398: l_proc varchar2(72) := g_package||'update_pgm_extra_info';
399: l_object_version_number ben_pgm_extra_info.object_version_number%TYPE;
400: l_ovn ben_pgm_extra_info.object_version_number%TYPE := p_object_version_number;
401: --
402: begin
403: hr_utility.set_location('Entering:'|| l_proc, 5);
404: --

Line 412: ben_pgm_extra_info_bk2.update_pgm_extra_info_b

408: --
409: -- Call Before Process User Hook
410: --
411: begin
412: ben_pgm_extra_info_bk2.update_pgm_extra_info_b
413: (
414: p_pgm_extra_info_id => p_pgm_extra_info_id,
415: p_pgi_attribute_category => p_pgi_attribute_category,
416: p_pgi_attribute1 => p_pgi_attribute1,

Line 550: ben_pgm_extra_info_bk2.update_pgm_extra_info_a

546: --
547: -- Call After Process User Hook
548: --
549: begin
550: ben_pgm_extra_info_bk2.update_pgm_extra_info_a
551: (
552: p_pgm_extra_info_id => p_pgm_extra_info_id,
553: p_pgi_attribute_category => p_pgi_attribute_category,
554: p_pgi_attribute1 => p_pgi_attribute1,

Line 679: ben_pgm_extra_info_bk3.delete_pgm_extra_info_b

675: --
676: -- Call Before Process User Hook
677: --
678: begin
679: ben_pgm_extra_info_bk3.delete_pgm_extra_info_b
680: (
681: p_pgm_extra_info_id => p_pgm_extra_info_id,
682: p_object_version_number => p_object_version_number
683: );

Line 707: ben_pgm_extra_info_bk3.delete_pgm_extra_info_a

703: --
704: -- Call After Process User Hook
705: --
706: begin
707: ben_pgm_extra_info_bk3.delete_pgm_extra_info_a
708: (
709: p_pgm_extra_info_id => p_pgm_extra_info_id,
710: p_object_version_number => p_object_version_number
711: );

Line 749: end ben_pgm_extra_info_api;

745: raise;
746: --
747: end delete_pgm_extra_info;
748: --
749: end ben_pgm_extra_info_api;