7:
8: TYPE t_bld_blk_info IS TABLE OF r_bld_blk_info INDEX BY BINARY_INTEGER;
9:
10: TYPE Consolidated_info IS RECORD ( bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
11: ,field_name hxc_mapping_components.field_name%TYPE
12: ,field_value varchar2(1000)
13: ,segment hxc_mapping_components.segment%TYPE);
14:
15:
9:
10: TYPE Consolidated_info IS RECORD ( bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
11: ,field_name hxc_mapping_components.field_name%TYPE
12: ,field_value varchar2(1000)
13: ,segment hxc_mapping_components.segment%TYPE);
14:
15:
16: TYPE t_consolidated_info_1 IS TABLE OF Consolidated_info INDEX BY BINARY_INTEGER;
17:
208: ) RETURN NUMBER;
209:
210: Procedure get_mapping_value(p_bld_blk_info_type in varchar2,
211: p_field_name in varchar2,
212: p_segment out nocopy hxc_mapping_components.segment%TYPE,
213: p_bld_blk_info_type_id out nocopy hxc_mapping_components.bld_blk_info_type_id%TYPE ) ;
214:
215:
216:
209:
210: Procedure get_mapping_value(p_bld_blk_info_type in varchar2,
211: p_field_name in varchar2,
212: p_segment out nocopy hxc_mapping_components.segment%TYPE,
213: p_bld_blk_info_type_id out nocopy hxc_mapping_components.bld_blk_info_type_id%TYPE ) ;
214:
215:
216:
217: