DBA Data[Home] [Help]

APPS.HXC_ALIAS_DEFN_UPLOAD_PKG dependencies on HXC_ALIAS_DEFINITIONS

Line 55: l_alias_definition_id hxc_alias_definitions.alias_definition_id%TYPE;

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;
59: l_description hxc_alias_definitions.description%TYPE;

Line 56: l_business_group_id hxc_alias_definitions.business_group_id%TYPE;

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;
59: l_description hxc_alias_definitions.description%TYPE;
60: l_alias_definition_name hxc_alias_definitions.alias_definition_name%TYPE;

Line 57: l_legislation_code hxc_alias_definitions.legislation_code%TYPE;

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;
59: l_description hxc_alias_definitions.description%TYPE;
60: l_alias_definition_name hxc_alias_definitions.alias_definition_name%TYPE;
61: l_timecard_field hxc_alias_definitions.timecard_field%TYPE;

Line 58: l_alias_context_code hxc_alias_definitions.alias_context_code%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;
59: l_description hxc_alias_definitions.description%TYPE;
60: l_alias_definition_name hxc_alias_definitions.alias_definition_name%TYPE;
61: l_timecard_field hxc_alias_definitions.timecard_field%TYPE;
62: l_ovn hxc_alias_definitions.object_version_number%TYPE;

Line 59: l_description hxc_alias_definitions.description%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;
59: l_description hxc_alias_definitions.description%TYPE;
60: l_alias_definition_name hxc_alias_definitions.alias_definition_name%TYPE;
61: l_timecard_field hxc_alias_definitions.timecard_field%TYPE;
62: l_ovn hxc_alias_definitions.object_version_number%TYPE;
63: l_owner VARCHAR2(6);

Line 60: l_alias_definition_name hxc_alias_definitions.alias_definition_name%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;
59: l_description hxc_alias_definitions.description%TYPE;
60: l_alias_definition_name hxc_alias_definitions.alias_definition_name%TYPE;
61: l_timecard_field hxc_alias_definitions.timecard_field%TYPE;
62: l_ovn hxc_alias_definitions.object_version_number%TYPE;
63: l_owner VARCHAR2(6);
64:

Line 61: l_timecard_field hxc_alias_definitions.timecard_field%TYPE;

57: l_legislation_code hxc_alias_definitions.legislation_code%TYPE;
58: l_alias_context_code hxc_alias_definitions.alias_context_code%TYPE;
59: l_description hxc_alias_definitions.description%TYPE;
60: l_alias_definition_name hxc_alias_definitions.alias_definition_name%TYPE;
61: l_timecard_field hxc_alias_definitions.timecard_field%TYPE;
62: l_ovn hxc_alias_definitions.object_version_number%TYPE;
63: l_owner VARCHAR2(6);
64:
65: BEGIN

Line 62: l_ovn hxc_alias_definitions.object_version_number%TYPE;

58: l_alias_context_code hxc_alias_definitions.alias_context_code%TYPE;
59: l_description hxc_alias_definitions.description%TYPE;
60: l_alias_definition_name hxc_alias_definitions.alias_definition_name%TYPE;
61: l_timecard_field hxc_alias_definitions.timecard_field%TYPE;
62: l_ovn hxc_alias_definitions.object_version_number%TYPE;
63: l_owner VARCHAR2(6);
64:
65: BEGIN
66: l_alias_reference_object:= find_alias_reference_object(p_alias_type, p_reference_object);

Line 91: FROM hxc_alias_definitions had

87: ,l_alias_definition_name
88: ,l_timecard_field
89: ,l_ovn
90:
91: FROM hxc_alias_definitions had
92: WHERE had.alias_definition_name = p_alias_definition_name
93: and had.ALIAS_TYPE_ID = l_alias_type_id;
94:
95: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )