[Home] [Help]
PACKAGE BODY: APPS.HXC_INTEGRATION_LAYER_V2_GRP
Source
1 PACKAGE BODY HXC_INTEGRATION_LAYER_V2_GRP AS
2 /* $Header: hxcintegrationv2.pkb 120.0 2005/05/29 06:28:00 appldev noship $ */
3
4 --
5 -- HXC_MAPPING_UTILITIES
6 --
7 -- ----------------------------------------------------------------------------
8 -- |---------------------------< get_mappingvalue_sum >------------------------|
9 -- ----------------------------------------------------------------------------
10 FUNCTION get_mappingvalue_sum ( p_bld_blk_info_type VARCHAR2
11 , p_field_name1 VARCHAR2
12 , p_bld_blk_info_type2 VARCHAR2 default null
13 , p_field_name2 VARCHAR2
14 , p_field_value2 VARCHAR2
15 , p_bld_blk_info_type3 VARCHAR2 default null
16 , p_field_name3 VARCHAR2 default null
17 , p_field_value3 VARCHAR2 default null
18 , p_bld_blk_info_type4 VARCHAR2 default null
19 , p_field_name4 VARCHAR2 default null
20 , p_field_value4 VARCHAR2 default null
21 , p_bld_blk_info_type5 VARCHAR2 default null
22 , p_field_name5 VARCHAR2 default null
23 , p_field_value5 VARCHAR2 default null
24 , p_status VARCHAR2
25 , p_resource_id VARCHAR2
26 ) RETURN NUMBER IS
27
28 l_return NUMBER;
29
30 BEGIN
31
32 --
33 -- call of the OTL API
34 --
35 l_return :=
36 HXC_MAPPING_UTILITIES.get_mappingvalue_sum (
37 p_bld_blk_info_type => p_bld_blk_info_type
38 ,p_field_name1 => p_field_name1
39 ,p_bld_blk_info_type2 => p_bld_blk_info_type2
40 ,p_field_name2 => p_field_name2
41 ,p_field_value2 => p_field_value2
42 ,p_bld_blk_info_type3 => p_bld_blk_info_type3
43 ,p_field_name3 => p_field_name3
44 ,p_field_value3 => p_field_value3
45 ,p_bld_blk_info_type4 => p_bld_blk_info_type4
46 ,p_field_name4 => p_field_name4
47 ,p_field_value4 => p_field_value4
48 ,p_bld_blk_info_type5 => p_bld_blk_info_type5
49 ,p_field_name5 => p_field_name5
50 ,p_field_value5 => p_field_value5
51 ,p_status => p_status
52 ,p_resource_id => p_resource_id);
53
54 return l_return;
55
56 END get_mappingvalue_sum;
57
58 END HXC_INTEGRATION_LAYER_V2_GRP;
59