APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_BLD_BLK_INFO_TYPES

Line 248: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

244: l_attribute VARCHAR2 (15);
245: l_table_dot_column VARCHAR2 (2000);
246: l_blk_table_dot_column VARCHAR2 (2000);
247: l_att_table_dot_column VARCHAR2 (2000);
248: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
249: l_detail_exists VARCHAR2 (400)
250: := '
251: EXISTS ( select 1 from hxc_time_attribute_usages usage,
252: hxc_time_attributes att

Line 4432: TYPE t_bld_blk_info_type_id IS TABLE OF hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

4428: l_detail_att_copied VARCHAR2 (1) := 'N';
4429: l_bld_blks_to_transfer VARCHAR2 (1) := 'N';
4430:
4431: -- table and variable for the time/day/detail bld blk info type registers
4432: TYPE t_bld_blk_info_type_id IS TABLE OF hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
4433: INDEX BY BINARY_INTEGER;
4434:
4435: t_time_bld_blk_info t_bld_blk_info_type_id;
4436: t_day_bld_blk_info t_bld_blk_info_type_id;

Line 4738: p_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

4734: -- p_scope - scope
4735: -- p_bld_blk_info_type_id - bld blk info type id
4736: FUNCTION att_copied_before (
4737: p_scope VARCHAR2,
4738: p_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
4739: )
4740: RETURN BOOLEAN
4741:
4742: IS

Line 7764: hxc_bld_blk_info_types bbit,

7760: SELECT mpc.bld_blk_info_type_id, UPPER (mpc.field_name),
7761: mpc.SEGMENT, bbit.bld_blk_info_type CONTEXT,
7762: bbitu.building_block_category CATEGORY
7763: FROM hxc_bld_blk_info_type_usages bbitu,
7764: hxc_bld_blk_info_types bbit,
7765: hxc_mapping_components mpc,
7766: hxc_mapping_comp_usages mcu,
7767: hxc_mappings MAP
7768: WHERE MAP.mapping_id = p_mapping_id