APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TIME_CATEGORY_COMPS

Line 53: , flex_value_set_id hxc_time_category_comps.flex_value_set_id%TYPE

49: , time_category_comp_id number(15)
50: , component_type_id number(15)
51: , is_null varchar2(1)
52: , equal_to varchar2(1)
53: , flex_value_set_id hxc_time_category_comps.flex_value_set_id%TYPE
54: , sql_string hxc_time_category_comp_sql.sql_string%TYPE
55: , last_update_date DATE );
56:
57: TYPE t_vs_comp IS TABLE OF r_vs_comp INDEX BY BINARY_INTEGER;

Line 62: TYPE r_tc_comp IS RECORD ( ref_tc_id hxc_time_category_comps.time_category_id%TYPE );

58:
59: TYPE r_an_comp IS RECORD ( sql_string hxc_time_category_comp_sql.sql_string%TYPE );
60: TYPE t_an_comp IS TABLE OF r_an_comp INDEX BY BINARY_INTEGER;
61:
62: TYPE r_tc_comp IS RECORD ( ref_tc_id hxc_time_category_comps.time_category_id%TYPE );
63: TYPE t_tc_comp IS TABLE OF r_tc_comp INDEX BY BINARY_INTEGER;
64:
65: TYPE r_master_tc_info IS RECORD (
66: time_category_id hxc_time_categories.time_category_id%TYPE

Line 239: -- used in the hxc_time_category_comps_v view.

235: -- get_flex_value
236: --
237: -- description
238: -- retrieves the value based on the id and flex value set id
239: -- used in the hxc_time_category_comps_v view.
240:
241: FUNCTION get_flex_value ( p_flex_value_set_id NUMBER
242: , p_id VARCHAR2 ) RETURN VARCHAR2;
243: