eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TIME_CATEGORIES

Line 13: TYPE rec_time_category_cache IS RECORD ( operator hxc_time_categories.operator%TYPE

9: g_debug boolean := hr_utility.debug_enabled;
10:
11: -- caching structures
12:
13: TYPE rec_time_category_cache IS RECORD ( operator hxc_time_categories.operator%TYPE
14: , start_index PLS_INTEGER
15: , stop_index PLS_INTEGER
16: , time_sql LONG
17: , cache_date DATE );

Line 57: p_time_category_id hxc_time_categories.time_category_id%TYPE

53: TYPE tab_attribute IS TABLE OF hxc_time_attributes.attribute1%TYPE INDEX BY BINARY_INTEGER;
54: TYPE tab_bld_blk_info_type_id IS TABLE OF hxc_time_attributes.bld_blk_info_type_id%TYPE INDEX BY BINARY_INTEGER;
55:
56: TYPE eval_time_category_params IS RECORD (
57: p_time_category_id hxc_time_categories.time_category_id%TYPE
58: , p_use_tc_cache BOOLEAN
59: , p_use_tc_bb_cache BOOLEAN
60: , p_use_temp_table BOOLEAN
61: , p_scope VARCHAR2(10)

Line 86: l_operator hxc_time_categories.operator%TYPE;

82:
83: l_tc_bb_cache_exists BOOLEAN := FALSE;
84: l_tc_cache_exists BOOLEAN := FALSE;
85:
86: l_operator hxc_time_categories.operator%TYPE;
87:
88: CURSOR csr_get_operator ( p_time_category_id NUMBER ) IS
89: SELECT operator
90: FROM hxc_time_categories

Line 90: FROM hxc_time_categories

86: l_operator hxc_time_categories.operator%TYPE;
87:
88: CURSOR csr_get_operator ( p_time_category_id NUMBER ) IS
89: SELECT operator
90: FROM hxc_time_categories
91: WHERE time_category_id = p_time_category_id;
92:
93:
94: CURSOR csr_get_category_comps ( p_time_category_id NUMBER ) IS

Line 186: FROM hxc_time_categories htc

182:
183: CURSOR csr_get_time_category ( p_time_category_id NUMBER ) IS
184: SELECT htc.time_sql
185: , htc.operator
186: FROM hxc_time_categories htc
187: WHERE htc.time_category_id = p_time_category_id
188: AND EXISTS ( select 'x'
189: from hxc_time_category_comps tcc
190: where tcc.time_category_id = htc.time_category_id );

Line 4628: FROM hxc_time_categories htc

4624: FUNCTION get_time_category_id ( p_time_category_name VARCHAR2 ) RETURN NUMBER IS
4625:
4626: CURSOR csr_get_time_category_id IS
4627: SELECT htc.time_category_id
4628: FROM hxc_time_categories htc
4629: WHERE htc.time_category_name = p_time_category_name;
4630:
4631: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4632:

Line 4631: l_time_category_id hxc_time_categories.time_category_id%TYPE;

4627: SELECT htc.time_category_id
4628: FROM hxc_time_categories htc
4629: WHERE htc.time_category_name = p_time_category_name;
4630:
4631: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4632:
4633: BEGIN
4634:
4635: OPEN csr_get_time_category_id;

Line 4748: l_time_category_id hxc_time_categories.time_category_id%TYPE;

4744: and detail.date_to = hr_general.end_of_time;
4745:
4746:
4747: l_timecard_hrs NUMBER := 0;
4748: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4749:
4750: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4751: l_tc_bb_ok_string VARCHAR2(32000);
4752: l_tc_bb_not_ok_string VARCHAR2(32000);

Line 4863: l_time_category_id hxc_time_categories.time_category_id%TYPE;

4859: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
4860: /* end of bug fix for 5526281 */
4861:
4862: l_timecard_hrs NUMBER := 0;
4863: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4864:
4865: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4866: l_tc_bb_ok_string VARCHAR2(32000);
4867: l_tc_bb_not_ok_string VARCHAR2(32000);

Line 4988: l_time_category_id hxc_time_categories.time_category_id%TYPE;

4984: , p_tbb_ovn NUMBER
4985: , p_time_category_name VARCHAR2 ) RETURN NUMBER IS
4986:
4987: l_timecard_hrs NUMBER;
4988: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4989:
4990: BEGIN
4991:
4992: l_time_category_id := get_time_category_id ( p_time_category_name => p_time_category_name );

Line 5131: l_time_category_id hxc_time_categories.time_category_id%TYPE;

5127: , p_resource_id IN NUMBER
5128: , p_time_category_name IN VARCHAR2
5129: , p_application_period_id IN NUMBER ) RETURN NUMBER IS
5130:
5131: l_time_category_id hxc_time_categories.time_category_id%TYPE;
5132: l_hours NUMBER := 0;
5133: l_total_hours NUMBER :=0;
5134: l_precision VARCHAR2(4);
5135: l_rounding_rule VARCHAR2(20);

Line 5268: FROM hxc_time_categories htc

5264: , tcc.is_null
5265: , tcc.equal_to
5266: , tcc.type
5267: , tcc.object_version_number
5268: FROM hxc_time_categories htc
5269: , hxc_time_category_comps tcc
5270: WHERE tcc.time_category_id = htc.time_category_id
5271: AND tcc.type = 'AN'
5272: AND tcc.component_type_id = p_alias_value_id

Line 5275: l_time_category_name hxc_time_categories.time_category_name%TYPE;

5271: AND tcc.type = 'AN'
5272: AND tcc.component_type_id = p_alias_value_id
5273: ORDER BY htc.time_category_id;
5274:
5275: l_time_category_name hxc_time_categories.time_category_name%TYPE;
5276:
5277: l_rec hxc_tcc_shd.g_rec_type;
5278:
5279: BEGIN

Line 5337: FROM hxc_time_categories htc

5333: PROCEDURE alias_definition_ref_int_chk ( p_alias_definition_id NUMBER ) IS
5334:
5335: CURSOR csr_get_time_category IS
5336: SELECT htc.time_category_name
5337: FROM hxc_time_categories htc
5338: , hxc_time_category_comps tcc
5339: , hxc_alias_values av
5340: , hxc_alias_definitions ad
5341: WHERE

Line 5351: l_time_category_name hxc_time_categories.time_category_name%TYPE;

5347: tcc.type = 'AN'
5348: AND
5349: tcc.time_category_id = htc.time_category_id;
5350:
5351: l_time_category_name hxc_time_categories.time_category_name%TYPE;
5352:
5353:
5354: BEGIN
5355: