APPS.HXC_TIME_ATTRIBUTES_API dependencies on HXC_BLD_BLK_INFO_TYPES

Line 179: l_information_type hxc_bld_blk_info_types.bld_blk_info_type%type;

175: l_rownum number;
176: l_mapping_exists boolean;
177: l_column_name varchar2(30);
178: l_column_number number;
179: l_information_type hxc_bld_blk_info_types.bld_blk_info_type%type;
180: l_set_attribute_category boolean := false;
181:
182: e_no_attribute_mapping exception;
183:

Line 337: from hxc_bld_blk_info_types

333: -- select hxc_time_attribute_usages_s.nextval from dual; -- refer Bug#3062133
334:
335: cursor c_bld_blk_info_type_id(p_bld_blk_info_type varchar2) is
336: select bld_blk_info_type_id
337: from hxc_bld_blk_info_types
338: where bld_blk_info_type = p_bld_blk_info_type;
339:
340: cursor c_get_data_set(p_tbb_id number,p_tbb_ovn number)
341: is

Line 355: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

351: l_time_attribute_usage_id number;
352: l_rownum number;
353: l_info_type_table info_type_table;
354: l_information_type varchar2(80);
355: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
356:
357: l_attribute1 hxc_time_attributes.attribute1%TYPE;
358: l_attribute2 hxc_time_attributes.attribute2%TYPE;
359: l_attribute3 hxc_time_attributes.attribute3%TYPE;