APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_BLD_BLK_INFO_TYPES

Line 233: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

229: l_attribute VARCHAR2 (15);
230: l_table_dot_column VARCHAR2 (2000);
231: l_blk_table_dot_column VARCHAR2 (2000);
232: l_att_table_dot_column VARCHAR2 (2000);
233: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
234: l_detail_exists VARCHAR2 (400)
235: := '
236: EXISTS ( select 1 from hxc_time_attribute_usages usage,
237: hxc_time_attributes att

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

3798: l_detail_att_copied VARCHAR2 (1) := 'N';
3799: l_bld_blks_to_transfer VARCHAR2 (1) := 'N';
3800:
3801: -- table and variable for the time/day/detail bld blk info type registers
3802: TYPE t_bld_blk_info_type_id IS TABLE OF hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
3803: INDEX BY BINARY_INTEGER;
3804:
3805: t_time_bld_blk_info t_bld_blk_info_type_id;
3806: t_day_bld_blk_info t_bld_blk_info_type_id;

Line 4073: p_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE

4069: -- p_scope - scope
4070: -- p_bld_blk_info_type_id - bld blk info type id
4071: FUNCTION att_copied_before (
4072: p_scope VARCHAR2,
4073: p_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE
4074: )
4075: RETURN BOOLEAN
4076:
4077: IS

Line 6879: hxc_bld_blk_info_types bbit,

6875: SELECT mpc.bld_blk_info_type_id, UPPER (mpc.field_name),
6876: mpc.SEGMENT, bbit.bld_blk_info_type CONTEXT,
6877: bbitu.building_block_category CATEGORY
6878: FROM hxc_bld_blk_info_type_usages bbitu,
6879: hxc_bld_blk_info_types bbit,
6880: hxc_mapping_components mpc,
6881: hxc_mapping_comp_usages mcu,
6882: hxc_mappings MAP
6883: WHERE MAP.mapping_id = p_mapping_id