APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TIME_CATEGORIES

Line 14: FROM hxc_time_categories htc

10: g_tc_bb_not_ok_string VARCHAR2(32000);
11:
12: CURSOR csr_get_time_sql ( p_time_category_id NUMBER ) IS
13: SELECT htc.time_sql
14: FROM hxc_time_categories htc
15: WHERE htc.time_category_id = p_time_category_id;
16:
17: -- *******************************************
18: -- structures for backward compatibilty start

Line 66: time_category_id hxc_time_categories.time_category_id%TYPE

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
67: , time_card_id hxc_time_building_blocks.time_building_Block_id%TYPE
68: , operator hxc_time_categories.operator%TYPE
69: , attribute_count number );
70:

Line 68: , operator hxc_time_categories.operator%TYPE

64:
65: TYPE r_master_tc_info IS RECORD (
66: time_category_id hxc_time_categories.time_category_id%TYPE
67: , time_card_id hxc_time_building_blocks.time_building_Block_id%TYPE
68: , operator hxc_time_categories.operator%TYPE
69: , attribute_count number );
70:
71: TYPE r_tc_bb_ok IS RECORD ( bb_id_ok varchar2(1) );
72:

Line 77: g_tc_in_bb_ok hxc_time_categories.time_category_id%TYPE;

73: TYPE t_tc_bb_ok IS TABLE OF r_tc_bb_ok INDEX BY BINARY_INTEGER;
74:
75: g_tc_bb_ok_tab t_tc_bb_ok;
76:
77: g_tc_in_bb_ok hxc_time_categories.time_category_id%TYPE;
78:
79: g_time_category_id hxc_time_categories.time_category_id%TYPE;
80:
81: g_tc_bb_ok_string VARCHAR2(32000);

Line 79: g_time_category_id hxc_time_categories.time_category_id%TYPE;

75: g_tc_bb_ok_tab t_tc_bb_ok;
76:
77: g_tc_in_bb_ok hxc_time_categories.time_category_id%TYPE;
78:
79: g_time_category_id hxc_time_categories.time_category_id%TYPE;
80:
81: g_tc_bb_ok_string VARCHAR2(32000);
82:
83: g_master_tc_info_rec r_master_tc_info;