APPS.HXC_TIMECARD_SEARCH_PKG dependencies on HXC_ALIAS_VALUES

Line 884: p_alias_definition_id IN hxc_alias_values.alias_definition_id%TYPE

880:
881: END get_value_from_string;
882:
883: FUNCTION get_attributes_by_alias(
884: p_alias_definition_id IN hxc_alias_values.alias_definition_id%TYPE
885: ,p_search_operator IN VARCHAR2
886: ,p_search_value IN VARCHAR2
887: )
888: RETURN VARCHAR2

Line 905: || ' FROM hxc_alias_values_v'

901: l_like_string := '';
902: END IF;
903:
904: l_alias_sql := 'SELECT attribute1'
905: || ' FROM hxc_alias_values_v'
906: ||' WHERE alias_definition_id = :p_alias_definition_id'
907: || ' AND alias_value_name '
908: || p_search_operator
909: || ':l_like_string||:p_search_value||:l_like_string';

Line 945: l_alias_definition_id hxc_alias_values.alias_definition_id%TYPE;

941: ,p_user_set IN VARCHAR2 DEFAULT 'Y'
942: )
943: RETURN VARCHAR2
944: IS
945: l_alias_definition_id hxc_alias_values.alias_definition_id%TYPE;
946: l_alias_used BOOLEAN := FALSE;
947: l_field_name hxc_alias_definitions.timecard_field%TYPE;
948:
949: CURSOR c_field_name(

Line 950: p_alias_definition_id hxc_alias_values.alias_definition_id%TYPE

946: l_alias_used BOOLEAN := FALSE;
947: l_field_name hxc_alias_definitions.timecard_field%TYPE;
948:
949: CURSOR c_field_name(
950: p_alias_definition_id hxc_alias_values.alias_definition_id%TYPE
951: )
952: IS
953: SELECT timecard_field
954: FROM hxc_alias_definitions