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