eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on HXC_BLD_BLK_INFO_TYPES

Line 16: hxc_bld_blk_info_types bbi

12: cursor c_delete(p_info_type_basis in VARCHAR2) is
13: select bbi.bld_blk_info_type_id
14: from hxc_mapping_comp_usages mcu,
15: hxc_mapping_components mc,
16: hxc_bld_blk_info_types bbi
17: where mcu.mapping_component_id = mc.mapping_component_id
18: and mc.bld_blk_info_type_id = bbi.bld_blk_info_type_id
19: and upper(bld_blk_info_type) like '%'||p_info_type_basis||'%';
20:

Line 21: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;

17: where mcu.mapping_component_id = mc.mapping_component_id
18: and mc.bld_blk_info_type_id = bbi.bld_blk_info_type_id
19: and upper(bld_blk_info_type) like '%'||p_info_type_basis||'%';
20:
21: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;
22:
23: BEGIN
24:
25: open c_delete(p_info_type_basis);

Line 145: (p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE)

141:
142: END add_comp_to_proc;
143:
144: PROCEDURE include_mapping_components
145: (p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE)
146: IS
147:
148:
149: cursor c_map_comp(

Line 150: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE

146: IS
147:
148:
149: cursor c_map_comp(
150: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE
151: ) is
152: select mc.mapping_component_id
153: from hxc_mapping_components mc,
154:

Line 155: hxc_bld_blk_info_types bbit

151: ) is
152: select mc.mapping_component_id
153: from hxc_mapping_components mc,
154:
155: hxc_bld_blk_info_types bbit
156: where upper(bbit.bld_blk_info_type) like '%'||upper(p_info_type_basis)||'%'
157: and bbit.bld_blk_info_type_id = mc.bld_blk_info_type_id;
158:
159:

Line 193: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE)

189:
190: END include_mapping_components;
191:
192: PROCEDURE remove_mapping_component(
193: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE)
194: IS
195:
196: cursor c_map_comp(
197: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE

Line 197: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE

193: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE)
194: IS
195:
196: cursor c_map_comp(
197: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE
198: ) is
199: select mc.mapping_component_id
200: from hxc_mapping_components mc,
201: hxc_bld_blk_info_types bbit

Line 201: hxc_bld_blk_info_types bbit

197: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE
198: ) is
199: select mc.mapping_component_id
200: from hxc_mapping_components mc,
201: hxc_bld_blk_info_types bbit
202: where upper(bbit.bld_blk_info_type) like '%'||upper(p_info_type_basis)||'%'
203: and bbit.bld_blk_info_type_id = mc.bld_blk_info_type_id;
204:
205: BEGIN

Line 233: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE)

229:
230: END remove_mapping_component;
231:
232: PROCEDURE remove_bld_blk_usage(
233: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE)
234: IS
235:
236: cursor c_bld_blk_usage(
237: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE

Line 237: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE

233: p_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE)
234: IS
235:
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

Line 241: hxc_bld_blk_info_types bbit

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:
245: BEGIN

Line 262: p_flex_context_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE

258: p_flexfield_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE,
259: p_flex_context_basis in VARCHAR2) IS
260:
261: cursor c_flex(
262: p_flex_context_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE
263: ) is
264: select bld_blk_info_type
265: from hxc_bld_blk_info_types
266: where upper(bld_blk_info_Type) like '%'||upper(p_flex_context_basis)||'%';

Line 265: from hxc_bld_blk_info_types

261: cursor c_flex(
262: p_flex_context_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE
263: ) is
264: select bld_blk_info_type
265: from hxc_bld_blk_info_types
266: where upper(bld_blk_info_Type) like '%'||upper(p_flex_context_basis)||'%';
267:
268: BEGIN
269:

Line 291: p_bld_blk_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE

287:
288: END remove_flex_context;
289:
290: PROCEDURE remove_bld_blk_info_type(
291: p_bld_blk_info_type_basis in HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE
292: ) is
293:
294: BEGIN
295:

Line 296: DELETE from HXC_BLD_BLK_INFO_TYPES

292: ) is
293:
294: BEGIN
295:
296: DELETE from HXC_BLD_BLK_INFO_TYPES
297: where upper(bld_blk_info_type) like '%'||upper(p_bld_blk_info_type_basis)||'%';
298:
299: END remove_bld_blk_info_type;
300:

Line 367: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;

363: and per.element_type_id = pet.element_type_id
364: and multiple_entries_allowed_flag = 'Y'
365: and p_effective_date between effective_start_date and effective_end_date;
366: -- End 115.24 Change
367: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;
368:
369: l_generate BOOLEAN default FALSE;
370: l_loop_var NUMBER default 0;
371: l_key_app VARCHAR2(30) := 'PAY';

Line 590: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,

586:
587: FUNCTION mapping_missing(
588: p_name in hxc_mapping_components.name%type,
589: p_field_name in hxc_mapping_components.field_name%type,
590: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,
591: p_segment in hxc_mapping_components.segment%type,
592: p_mp_id IN OUT NOCOPY NUMBER,
593: p_ovn IN OUT NOCOPY NUMBER ) RETURN BOOLEAN IS
594:

Line 643: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,

639:
640: PROCEDURE create_mapping(
641: p_name in hxc_mapping_components.name%type,
642: p_field_name in hxc_mapping_components.field_name%type,
643: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,
644: p_segment in hxc_mapping_components.segment%type) is
645:
646: l_mapping_component_id NUMBER;
647: l_ovn NUMBER;

Line 684: ,p_legislation_code in hxc_bld_blk_info_types.legislation_code%type

680:
681: FUNCTION create_bld_blk_info_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:

Line 685: ,p_bld_blk_info_type in hxc_bld_blk_info_types.bld_blk_info_type%type

681: FUNCTION create_bld_blk_info_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

Line 689: cursor c_info_type_id (p_info_type in hxc_bld_blk_info_types.bld_blk_info_type%type) is

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
691: from HXC_BLD_BLK_INFO_TYPES
692: where bld_blk_info_type = p_info_type;
693:

Line 691: from HXC_BLD_BLK_INFO_TYPES

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
691: from HXC_BLD_BLK_INFO_TYPES
692: where bld_blk_info_type = p_info_type;
693:
694: l_bld_blk_info_type_id NUMBER;
695:

Line 710: insert into HXC_BLD_BLK_INFO_TYPES(

706: --
707:
708: if c_info_type_id%NOTFOUND then
709:
710: insert into HXC_BLD_BLK_INFO_TYPES(
711: bld_blk_info_type_id,
712: legislation_code,
713: descriptive_flexfield_name,
714: bld_blk_info_type,

Line 723: HXC_BLD_BLK_INFO_TYPES_S.NEXTVAL,

719: last_update_date,
720: last_update_login,
721: object_version_number)
722: select
723: HXC_BLD_BLK_INFO_TYPES_S.NEXTVAL,
724: p_legislation_code,
725: p_flexfield_name,
726: p_bld_blk_info_type,
727: 'N',

Line 794: from hxc_bld_blk_info_types bbi

790: where descriptive_flexfield_name = p_flex_name
791: and fdfc.descriptive_flex_context_code <> 'Global Data Elements'
792: and not exists (
793: select 'Y'
794: from hxc_bld_blk_info_types bbi
795: where bbi.bld_blk_info_type = fdfc.descriptive_flex_context_code
796: );
797: l_dummy_info_type_id NUMBER;
798: