APPS.HXC_ALIAS_DEFN_UPLOAD_PKG dependencies on HXC_ALIAS_TYPES

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_alias_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_alias_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_alias_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 53: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;

49: , p_alias_type IN VARCHAR2
50: , p_reference_object IN VARCHAR2
51: , p_custom_mode IN VARCHAR2 ) IS
52:
53: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
54: l_alias_reference_object hxc_alias_types.reference_object%TYPE;
55: l_alias_definition_id hxc_alias_definitions.alias_definition_id%TYPE;
56: l_business_group_id hxc_alias_definitions.business_group_id%TYPE;
57: l_legislation_code hxc_alias_definitions.legislation_code%TYPE;

Line 54: l_alias_reference_object hxc_alias_types.reference_object%TYPE;

50: , p_reference_object IN VARCHAR2
51: , p_custom_mode IN VARCHAR2 ) IS
52:
53: l_alias_type_id hxc_alias_types.alias_type_id%TYPE;
54: l_alias_reference_object hxc_alias_types.reference_object%TYPE;
55: l_alias_definition_id hxc_alias_definitions.alias_definition_id%TYPE;
56: l_business_group_id hxc_alias_definitions.business_group_id%TYPE;
57: l_legislation_code hxc_alias_definitions.legislation_code%TYPE;
58: l_alias_context_code hxc_alias_definitions.alias_context_code%TYPE;