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_ALIAS_TYPES_UPLOAD_PKG dependencies on HXC_ALIAS_TYPE_COMPONENTS

Line 114: l_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE;

110: , p_owner IN VARCHAR2
111: , p_custom_mode IN VARCHAR2 ) IS
112: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
113: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
114: l_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE;
115: l_component_name hxc_alias_type_components.component_name%TYPE;
116: l_component_type hxc_alias_type_components.component_type%TYPE;
117: l_ovn hxc_alias_type_components.object_version_number%TYPE;
118: l_owner VARCHAR2(6);

Line 115: l_component_name hxc_alias_type_components.component_name%TYPE;

111: , p_custom_mode IN VARCHAR2 ) IS
112: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
113: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
114: l_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE;
115: l_component_name hxc_alias_type_components.component_name%TYPE;
116: l_component_type hxc_alias_type_components.component_type%TYPE;
117: l_ovn hxc_alias_type_components.object_version_number%TYPE;
118: l_owner VARCHAR2(6);
119: l_alias_reference_object hxc_alias_types.reference_object%TYPE;

Line 116: l_component_type hxc_alias_type_components.component_type%TYPE;

112: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
113: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
114: l_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE;
115: l_component_name hxc_alias_type_components.component_name%TYPE;
116: l_component_type hxc_alias_type_components.component_type%TYPE;
117: l_ovn hxc_alias_type_components.object_version_number%TYPE;
118: l_owner VARCHAR2(6);
119: l_alias_reference_object hxc_alias_types.reference_object%TYPE;
120:

Line 117: l_ovn hxc_alias_type_components.object_version_number%TYPE;

113: l_mapping_component_id hxc_mapping_components.mapping_component_id%TYPE;
114: l_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE;
115: l_component_name hxc_alias_type_components.component_name%TYPE;
116: l_component_type hxc_alias_type_components.component_type%TYPE;
117: l_ovn hxc_alias_type_components.object_version_number%TYPE;
118: l_owner VARCHAR2(6);
119: l_alias_reference_object hxc_alias_types.reference_object%TYPE;
120:
121: BEGIN

Line 136: FROM hxc_alias_type_components hatc

132: , l_ovn
133: , l_owner
134: , l_component_name
135: , l_component_type
136: FROM hxc_alias_type_components hatc
137: WHERE hatc.mapping_component_id = l_mapping_component_id
138: AND hatc.ALIAS_TYPE_ID = l_alias_type_id;
139: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
140: THEN