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 CLOB -- Bug 15977687
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 4745: FROM hxc_time_categories htc

4741: FUNCTION get_time_category_id ( p_time_category_name VARCHAR2 ) RETURN NUMBER IS
4742:
4743: CURSOR csr_get_time_category_id IS
4744: SELECT htc.time_category_id
4745: FROM hxc_time_categories htc
4746: WHERE htc.time_category_name = p_time_category_name;
4747:
4748: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4749:

Line 4748: l_time_category_id hxc_time_categories.time_category_id%TYPE;

4744: SELECT htc.time_category_id
4745: FROM hxc_time_categories htc
4746: WHERE htc.time_category_name = p_time_category_name;
4747:
4748: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4749:
4750: BEGIN
4751:
4752: OPEN csr_get_time_category_id;

Line 4865: l_time_category_id hxc_time_categories.time_category_id%TYPE;

4861: and detail.date_to = hr_general.end_of_time;
4862:
4863:
4864: l_timecard_hrs NUMBER := 0;
4865: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4866:
4867: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4868: l_tc_bb_ok_string VARCHAR2(32000);
4869: l_tc_bb_not_ok_string VARCHAR2(32000);

Line 4980: l_time_category_id hxc_time_categories.time_category_id%TYPE;

4976: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
4977: /* end of bug fix for 5526281 */
4978:
4979: l_timecard_hrs NUMBER := 0;
4980: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4981:
4982: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4983: l_tc_bb_ok_string VARCHAR2(32000);
4984: l_tc_bb_not_ok_string VARCHAR2(32000);

Line 5105: l_time_category_id hxc_time_categories.time_category_id%TYPE;

5101: , p_tbb_ovn NUMBER
5102: , p_time_category_name VARCHAR2 ) RETURN NUMBER IS
5103:
5104: l_timecard_hrs NUMBER;
5105: l_time_category_id hxc_time_categories.time_category_id%TYPE;
5106:
5107: BEGIN
5108:
5109: l_time_category_id := get_time_category_id ( p_time_category_name => p_time_category_name );

Line 5248: l_time_category_id hxc_time_categories.time_category_id%TYPE;

5244: , p_resource_id IN NUMBER
5245: , p_time_category_name IN VARCHAR2
5246: , p_application_period_id IN NUMBER ) RETURN NUMBER IS
5247:
5248: l_time_category_id hxc_time_categories.time_category_id%TYPE;
5249: l_hours NUMBER := 0;
5250: l_total_hours NUMBER :=0;
5251: l_precision VARCHAR2(4);
5252: l_rounding_rule VARCHAR2(20);

Line 5385: FROM hxc_time_categories htc

5381: , tcc.is_null
5382: , tcc.equal_to
5383: , tcc.type
5384: , tcc.object_version_number
5385: FROM hxc_time_categories htc
5386: , hxc_time_category_comps tcc
5387: WHERE tcc.time_category_id = htc.time_category_id
5388: AND tcc.type = 'AN'
5389: AND tcc.component_type_id = p_alias_value_id

Line 5392: l_time_category_name hxc_time_categories.time_category_name%TYPE;

5388: AND tcc.type = 'AN'
5389: AND tcc.component_type_id = p_alias_value_id
5390: ORDER BY htc.time_category_id;
5391:
5392: l_time_category_name hxc_time_categories.time_category_name%TYPE;
5393:
5394: l_rec hxc_tcc_shd.g_rec_type;
5395:
5396: BEGIN

Line 5454: FROM hxc_time_categories htc

5450: PROCEDURE alias_definition_ref_int_chk ( p_alias_definition_id NUMBER ) IS
5451:
5452: CURSOR csr_get_time_category IS
5453: SELECT htc.time_category_name
5454: FROM hxc_time_categories htc
5455: , hxc_time_category_comps tcc
5456: , hxc_alias_values av
5457: , hxc_alias_definitions ad
5458: WHERE

Line 5468: l_time_category_name hxc_time_categories.time_category_name%TYPE;

5464: tcc.type = 'AN'
5465: AND
5466: tcc.time_category_id = htc.time_category_id;
5467:
5468: l_time_category_name hxc_time_categories.time_category_name%TYPE;
5469:
5470:
5471: BEGIN
5472: