APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_BLD_BLK_INFO_TYPE_USAGES

Line 240: from hxc_bld_blk_info_type_usages bbu,

236: cursor c_bld_blk_usage(
237: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE
238: ) is
239: select bbu.bld_blk_info_type_usage_id
240: from hxc_bld_blk_info_type_usages bbu,
241: hxc_bld_blk_info_types bbit
242: where upper(bbit.bld_blk_info_type) like '%'||upper(p_info_type_basis)||'%'
243: and bbit.bld_blk_info_type_id = bbu.bld_blk_info_type_id;
244:

Line 249: DELETE from HXC_BLD_BLK_INFO_TYPE_USAGES

245: BEGIN
246:
247: for usage_rec in c_bld_blk_usage(p_info_type_basis) LOOP
248:
249: DELETE from HXC_BLD_BLK_INFO_TYPE_USAGES
250: where bld_blk_info_type_usage_id = usage_rec.bld_blk_info_type_usage_id;
251:
252: END LOOP;
253:

Line 785: ,p_category hxc_bld_blk_info_type_usages.building_block_category%type

781: p_appl_short_name in VARCHAR2
782: ,p_flexfield_name in VARCHAR2
783: ,p_legislation_code in hxc_bld_blk_info_types.legislation_code%type
784: ,p_bld_blk_info_type in hxc_bld_blk_info_types.bld_blk_info_type%type
785: ,p_category hxc_bld_blk_info_type_usages.building_block_category%type
786: ) RETURN NUMBER is
787:
788: cursor c_info_type_id (p_info_type in hxc_bld_blk_info_types.bld_blk_info_type%type) is
789: select bld_blk_info_type_id

Line 849: insert into HXC_BLD_BLK_INFO_TYPE_USAGES(

845:
846: --
847: -- Create the information type category usage record
848: --
849: insert into HXC_BLD_BLK_INFO_TYPE_USAGES(
850: bld_blk_info_type_usage_id,
851: building_block_category,
852: bld_blk_info_type_id,
853: created_by,

Line 860: hxc_bld_blk_info_type_usages_s.nextval,

856: last_update_date,
857: last_update_login,
858: object_version_number)
859: select
860: hxc_bld_blk_info_type_usages_s.nextval,
861: p_category,
862: l_bld_blk_info_type_id,
863: 0,
864: sysdate,

Line 872: from hxc_bld_blk_info_type_usages

868: 1
869: from sys.dual
870: where not exists(
871: select 'Y'
872: from hxc_bld_blk_info_type_usages
873: where bld_blk_info_type_id = l_bld_blk_info_type_id);
874:
875: RETURN l_bld_blk_info_type_id;
876: