1: Package Body ben_EXT_DATA_ELMT_api as
2: /* $Header: bexelapi.pkb 120.1 2005/06/08 13:17:21 tjesumic noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: bexelapi.pkb 120.1 2005/06/08 13:17:21 tjesumic noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_EXT_DATA_ELMT_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_EXT_DATA_ELMT >----------------------|
10: -- ----------------------------------------------------------------------------
66: ) is
67: --
68: -- Declare cursors and local variables
69: --
70: l_ext_data_elmt_id ben_ext_data_elmt.ext_data_elmt_id%TYPE;
71: l_proc varchar2(72) := g_package||'create_EXT_DATA_ELMT';
72: l_object_version_number ben_ext_data_elmt.object_version_number%TYPE;
73: --
74: begin
68: -- Declare cursors and local variables
69: --
70: l_ext_data_elmt_id ben_ext_data_elmt.ext_data_elmt_id%TYPE;
71: l_proc varchar2(72) := g_package||'create_EXT_DATA_ELMT';
72: l_object_version_number ben_ext_data_elmt.object_version_number%TYPE;
73: --
74: begin
75: --
76: hr_utility.set_location('Entering:'|| l_proc, 10);
86: begin
87: --
88: -- Start of API User Hook for the before hook of create_EXT_DATA_ELMT
89: --
90: ben_EXT_DATA_ELMT_bk1.create_EXT_DATA_ELMT_b
91: (
92: p_name => p_name
93: ,p_xml_tag_name => p_xml_tag_name
94: ,p_data_elmt_typ_cd => p_data_elmt_typ_cd
211: begin
212: --
213: -- Start of API User Hook for the after hook of create_EXT_DATA_ELMT
214: --
215: ben_EXT_DATA_ELMT_bk1.create_EXT_DATA_ELMT_a
216: (
217: p_ext_data_elmt_id => l_ext_data_elmt_id
218: ,p_name => p_name
219: ,p_xml_tag_name => p_xml_tag_name
380: --
381: -- Declare cursors and local variables
382: --
383: l_proc varchar2(72) := g_package||'update_EXT_DATA_ELMT';
384: l_object_version_number ben_ext_data_elmt.object_version_number%TYPE;
385: --
386: begin
387: --
388: hr_utility.set_location('Entering:'|| l_proc, 10);
400: begin
401: --
402: -- Start of API User Hook for the before hook of update_EXT_DATA_ELMT
403: --
404: ben_EXT_DATA_ELMT_bk2.update_EXT_DATA_ELMT_b
405: (
406: p_ext_data_elmt_id => p_ext_data_elmt_id
407: ,p_name => p_name
408: ,p_xml_tag_name => p_xml_tag_name
526: begin
527: --
528: -- Start of API User Hook for the after hook of update_EXT_DATA_ELMT
529: --
530: ben_EXT_DATA_ELMT_bk2.update_EXT_DATA_ELMT_a
531: (
532: p_ext_data_elmt_id => p_ext_data_elmt_id
533: ,p_name => p_name
534: ,p_xml_tag_name => p_xml_tag_name
644: --
645: -- Declare cursors and local variables
646: --
647: l_proc varchar2(72) := g_package||'update_EXT_DATA_ELMT';
648: l_object_version_number ben_ext_data_elmt.object_version_number%TYPE;
649: --
650: begin
651: --
652: hr_utility.set_location('Entering:'|| l_proc, 10);
665: begin
666: --
667: -- Start of API User Hook for the before hook of delete_EXT_DATA_ELMT
668: --
669: ben_EXT_DATA_ELMT_bk3.delete_EXT_DATA_ELMT_b
670: (
671: p_ext_data_elmt_id => p_ext_data_elmt_id
672: ,p_legislation_code => p_legislation_code
673: ,p_object_version_number => p_object_version_number
695: begin
696: --
697: -- Start of API User Hook for the after hook of delete_EXT_DATA_ELMT
698: --
699: ben_EXT_DATA_ELMT_bk3.delete_EXT_DATA_ELMT_a
700: (
701: p_ext_data_elmt_id => p_ext_data_elmt_id
702: ,p_legislation_code => p_legislation_code
703: ,p_object_version_number => l_object_version_number
775: hr_utility.set_location(' Leaving:'||l_proc, 70);
776: --
777: end lck;
778: --
779: end ben_EXT_DATA_ELMT_api;