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 686: ,p_category hxc_bld_blk_info_type_usages.building_block_category%type

682: p_appl_short_name in VARCHAR2
683: ,p_flexfield_name in VARCHAR2
684: ,p_legislation_code in hxc_bld_blk_info_types.legislation_code%type
685: ,p_bld_blk_info_type in hxc_bld_blk_info_types.bld_blk_info_type%type
686: ,p_category hxc_bld_blk_info_type_usages.building_block_category%type
687: ) RETURN NUMBER is
688:
689: cursor c_info_type_id (p_info_type in hxc_bld_blk_info_types.bld_blk_info_type%type) is
690: select bld_blk_info_type_id

Line 750: insert into HXC_BLD_BLK_INFO_TYPE_USAGES(

746:
747: --
748: -- Create the information type category usage record
749: --
750: insert into HXC_BLD_BLK_INFO_TYPE_USAGES(
751: bld_blk_info_type_usage_id,
752: building_block_category,
753: bld_blk_info_type_id,
754: created_by,

Line 761: hxc_bld_blk_info_type_usages_s.nextval,

757: last_update_date,
758: last_update_login,
759: object_version_number)
760: select
761: hxc_bld_blk_info_type_usages_s.nextval,
762: p_category,
763: l_bld_blk_info_type_id,
764: 0,
765: sysdate,

Line 773: from hxc_bld_blk_info_type_usages

769: 1
770: from sys.dual
771: where not exists(
772: select 'Y'
773: from hxc_bld_blk_info_type_usages
774: where bld_blk_info_type_id = l_bld_blk_info_type_id);
775:
776: RETURN l_bld_blk_info_type_id;
777: