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_TYPES

Line 1: PACKAGE BODY hxc_alias_types_upload_pkg AS

1: PACKAGE BODY hxc_alias_types_upload_pkg AS
2: /* $Header: hxcaltload.pkb 115.1 2002/09/03 12:10:15 ksethi noship $ */
3:
4: FUNCTION find_alias_reference_object ( p_alias_type VARCHAR2,p_reference_object VARCHAR2 ) RETURN VARCHAR2 IS
5:

Line 17: l_alias_reference_object hxc_alias_types.reference_object%TYPE;

13: from fnd_flex_value_sets ff
14: where ff.FLEX_VALUE_SET_NAME = p_reference_object
15: and p_alias_type in ('VALUE_SET_NONE','VALUE_SET_TABLE')
16: );
17: l_alias_reference_object hxc_alias_types.reference_object%TYPE;
18: BEGIN
19: OPEN csr_get_alias_reference_object;
20: FETCH csr_get_alias_reference_object INTO l_alias_reference_object;
21: CLOSE csr_get_alias_reference_object;

Line 29: FROM hxc_alias_types

25:
26: FUNCTION find_alias_type_id ( p_alias_type VARCHAR2,p_reference_object VARCHAR2 ) RETURN number IS
27: CURSOR csr_get_alias_type_id IS
28: SELECT alias_type_id
29: FROM hxc_alias_types
30: WHERE alias_type = p_alias_type
31: and reference_object = p_reference_object;
32: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
33: BEGIN

Line 32: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;

28: SELECT alias_type_id
29: FROM hxc_alias_types
30: WHERE alias_type = p_alias_type
31: and reference_object = p_reference_object;
32: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
33: BEGIN
34: OPEN csr_get_alias_type_id;
35: FETCH csr_get_alias_type_id INTO l_alias_type_id;
36: CLOSE csr_get_alias_type_id;

Line 58: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;

54: p_alias_type IN VARCHAR2
55: , p_reference_object IN VARCHAR2
56: , p_owner IN VARCHAR2
57: , p_custom_mode IN VARCHAR2 ) IS
58: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
59: l_alias_type hxc_alias_types.alias_type%TYPE;
60: l_reference_object hxc_alias_types.reference_object%TYPE;
61: l_ovn hxc_alias_types.object_version_number%TYPE;
62: l_owner VARCHAR2(6);

Line 59: l_alias_type hxc_alias_types.alias_type%TYPE;

55: , p_reference_object IN VARCHAR2
56: , p_owner IN VARCHAR2
57: , p_custom_mode IN VARCHAR2 ) IS
58: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
59: l_alias_type hxc_alias_types.alias_type%TYPE;
60: l_reference_object hxc_alias_types.reference_object%TYPE;
61: l_ovn hxc_alias_types.object_version_number%TYPE;
62: l_owner VARCHAR2(6);
63: l_alias_reference_object hxc_alias_types.reference_object%TYPE;

Line 60: l_reference_object hxc_alias_types.reference_object%TYPE;

56: , p_owner IN VARCHAR2
57: , p_custom_mode IN VARCHAR2 ) IS
58: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
59: l_alias_type hxc_alias_types.alias_type%TYPE;
60: l_reference_object hxc_alias_types.reference_object%TYPE;
61: l_ovn hxc_alias_types.object_version_number%TYPE;
62: l_owner VARCHAR2(6);
63: l_alias_reference_object hxc_alias_types.reference_object%TYPE;
64: BEGIN

Line 61: l_ovn hxc_alias_types.object_version_number%TYPE;

57: , p_custom_mode IN VARCHAR2 ) IS
58: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
59: l_alias_type hxc_alias_types.alias_type%TYPE;
60: l_reference_object hxc_alias_types.reference_object%TYPE;
61: l_ovn hxc_alias_types.object_version_number%TYPE;
62: l_owner VARCHAR2(6);
63: l_alias_reference_object hxc_alias_types.reference_object%TYPE;
64: BEGIN
65: l_alias_reference_object:= find_alias_reference_object(p_alias_type, p_reference_object);

Line 63: l_alias_reference_object hxc_alias_types.reference_object%TYPE;

59: l_alias_type hxc_alias_types.alias_type%TYPE;
60: l_reference_object hxc_alias_types.reference_object%TYPE;
61: l_ovn hxc_alias_types.object_version_number%TYPE;
62: l_owner VARCHAR2(6);
63: l_alias_reference_object hxc_alias_types.reference_object%TYPE;
64: BEGIN
65: l_alias_reference_object:= find_alias_reference_object(p_alias_type, p_reference_object);
66: BEGIN
67: SELECT alias_type_id

Line 77: FROM hxc_alias_types

73: , l_alias_type
74: , l_reference_object
75: , l_ovn
76: , l_owner
77: FROM hxc_alias_types
78: WHERE alias_type = P_alias_type
79: and reference_object= l_alias_reference_object;
80: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
81: THEN

Line 112: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;

108: , p_alias_type IN VARCHAR2
109: , p_reference_object IN VARCHAR2
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;

Line 119: l_alias_reference_object hxc_alias_types.reference_object%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
122: l_alias_reference_object:= find_alias_reference_object(p_alias_type, p_reference_object);
123: l_alias_type_id := find_alias_type_id (p_alias_type, l_alias_reference_object);

Line 167: END hxc_alias_types_upload_pkg;

163: ,p_object_version_number => l_ovn
164: );
165: END;
166: END load_alias_comp_row;
167: END hxc_alias_types_upload_pkg;