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_MAPPING_COMPONENTS

Line 15: hxc_mapping_components mc,

11:
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||'%';

Line 39: (p_map_id in HXC_MAPPING_COMPONENTS.MAPPING_COMPONENT_ID%TYPE

35:
36: END check_delete_info_type;
37:
38: FUNCTION valid_to_add_map
39: (p_map_id in HXC_MAPPING_COMPONENTS.MAPPING_COMPONENT_ID%TYPE
40: ,p_process_map in HXC_DEPOSIT_PROCESSES.NAME%TYPE) RETURN BOOLEAN is
41:
42: cursor field_already_mapped(p_id in number,p_name in varchar2) is
43: SELECT 'Y'

Line 50: from hxc_mapping_components c1,

46: where m.name = p_name
47: and u.mapping_id = m.mapping_id
48: and u.mapping_component_id in
49: (select c2.mapping_component_id
50: from hxc_mapping_components c1,
51: hxc_mapping_components c2
52: where c1.mapping_component_id = p_id
53: and c2.segment = c1.segment
54: and c2.field_name = c1.field_name

Line 51: hxc_mapping_components c2

47: and u.mapping_id = m.mapping_id
48: and u.mapping_component_id in
49: (select c2.mapping_component_id
50: from hxc_mapping_components c1,
51: hxc_mapping_components c2
52: where c1.mapping_component_id = p_id
53: and c2.segment = c1.segment
54: and c2.field_name = c1.field_name
55: and c2.bld_blk_info_type_id = c1.bld_blk_info_type_id

Line 62: from hxc_mappings m, hxc_mapping_comp_usages u, hxc_mapping_components c

58: cursor field_name_already
59: (p_id in number
60: ,p_name in varchar2) is
61: select 'Y'
62: from hxc_mappings m, hxc_mapping_comp_usages u, hxc_mapping_components c
63: where m.mapping_id = u.mapping_id
64: and m.name = p_name
65: and u.mapping_component_id = c.mapping_component_id
66: and c.field_name =

Line 68: from hxc_mapping_components c1

64: and m.name = p_name
65: and u.mapping_component_id = c.mapping_component_id
66: and c.field_name =
67: (select field_name
68: from hxc_mapping_components c1
69: where c1.mapping_component_id = p_id);
70:
71: l_valid BOOLEAN := FALSE;
72: l_dummy VARCHAR2(2);

Line 153: from hxc_mapping_components mc,

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:
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;

Line 200: from hxc_mapping_components mc,

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

Line 225: DELETE from HXC_MAPPING_COMPONENTS

221: end if;
222:
223: for map_rec in c_map_comp(p_info_type_basis) LOOP
224:
225: DELETE from HXC_MAPPING_COMPONENTS
226: where mapping_component_id = map_rec.mapping_component_id;
227:
228: END LOOP;
229:

Line 687: p_name in hxc_mapping_components.name%type,

683:
684: END valid_segment_name;
685:
686: FUNCTION mapping_missing(
687: p_name in hxc_mapping_components.name%type,
688: p_field_name in hxc_mapping_components.field_name%type,
689: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,
690: p_segment in hxc_mapping_components.segment%type,
691: p_mp_id IN OUT NOCOPY NUMBER,

Line 688: p_field_name in hxc_mapping_components.field_name%type,

684: END valid_segment_name;
685:
686: FUNCTION mapping_missing(
687: p_name in hxc_mapping_components.name%type,
688: p_field_name in hxc_mapping_components.field_name%type,
689: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,
690: p_segment in hxc_mapping_components.segment%type,
691: p_mp_id IN OUT NOCOPY NUMBER,
692: p_ovn IN OUT NOCOPY NUMBER ) RETURN BOOLEAN IS

Line 690: p_segment in hxc_mapping_components.segment%type,

686: FUNCTION mapping_missing(
687: p_name in hxc_mapping_components.name%type,
688: p_field_name in hxc_mapping_components.field_name%type,
689: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,
690: p_segment in hxc_mapping_components.segment%type,
691: p_mp_id IN OUT NOCOPY NUMBER,
692: p_ovn IN OUT NOCOPY NUMBER ) RETURN BOOLEAN IS
693:
694:

Line 701: from hxc_mapping_components

697: select mapping_component_id,
698: object_version_number
699: into p_mp_id,
700: p_ovn
701: from hxc_mapping_components
702: where field_name = p_field_name
703: and name = p_name
704: and segment = p_segment;
705:

Line 715: (p_map_comp_id in HXC_MAPPING_COMPONENTS.MAPPING_COMPONENT_ID%TYPE) RETURN BOOLEAN is

711:
712: END;
713:
714: FUNCTION update_allowed
715: (p_map_comp_id in HXC_MAPPING_COMPONENTS.MAPPING_COMPONENT_ID%TYPE) RETURN BOOLEAN is
716:
717: l_dummy VARCHAR2(2);
718:
719: BEGIN

Line 740: p_name in hxc_mapping_components.name%type,

736:
737: END update_allowed;
738:
739: PROCEDURE create_mapping(
740: p_name in hxc_mapping_components.name%type,
741: p_field_name in hxc_mapping_components.field_name%type,
742: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,
743: p_segment in hxc_mapping_components.segment%type) is
744:

Line 741: p_field_name in hxc_mapping_components.field_name%type,

737: END update_allowed;
738:
739: PROCEDURE create_mapping(
740: p_name in hxc_mapping_components.name%type,
741: p_field_name in hxc_mapping_components.field_name%type,
742: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,
743: p_segment in hxc_mapping_components.segment%type) is
744:
745: l_mapping_component_id NUMBER;

Line 743: p_segment in hxc_mapping_components.segment%type) is

739: PROCEDURE create_mapping(
740: p_name in hxc_mapping_components.name%type,
741: p_field_name in hxc_mapping_components.field_name%type,
742: p_bld_blk_info_type_id in hxc_bld_blk_info_types.bld_blk_info_type_id%type,
743: p_segment in hxc_mapping_components.segment%type) is
744:
745: l_mapping_component_id NUMBER;
746: l_ovn NUMBER;
747: