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_ATTRIBUTES

Line 51: TYPE tab_time_attribute_id IS TABLE OF hxc_time_attributes.time_attribute_id%TYPE INDEX BY BINARY_INTEGER;

47: TYPE tab_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;
48:
49: -- attribute types
50:
51: TYPE tab_time_attribute_id IS TABLE OF hxc_time_attributes.time_attribute_id%TYPE INDEX BY BINARY_INTEGER;
52: TYPE tab_attribute_category IS TABLE OF hxc_time_attributes.attribute_category%TYPE INDEX BY BINARY_INTEGER;
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:

Line 52: TYPE tab_attribute_category IS TABLE OF hxc_time_attributes.attribute_category%TYPE INDEX BY BINARY_INTEGER;

48:
49: -- attribute types
50:
51: TYPE tab_time_attribute_id IS TABLE OF hxc_time_attributes.time_attribute_id%TYPE INDEX BY BINARY_INTEGER;
52: TYPE tab_attribute_category IS TABLE OF hxc_time_attributes.attribute_category%TYPE INDEX BY BINARY_INTEGER;
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 (

Line 53: TYPE tab_attribute IS TABLE OF hxc_time_attributes.attribute1%TYPE INDEX BY BINARY_INTEGER;

49: -- attribute types
50:
51: TYPE tab_time_attribute_id IS TABLE OF hxc_time_attributes.time_attribute_id%TYPE INDEX BY BINARY_INTEGER;
52: TYPE tab_attribute_category IS TABLE OF hxc_time_attributes.attribute_category%TYPE INDEX BY BINARY_INTEGER;
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

Line 54: TYPE tab_bld_blk_info_type_id IS TABLE OF hxc_time_attributes.bld_blk_info_type_id%TYPE INDEX BY BINARY_INTEGER;

50:
51: TYPE tab_time_attribute_id IS TABLE OF hxc_time_attributes.time_attribute_id%TYPE INDEX BY BINARY_INTEGER;
52: TYPE tab_attribute_category IS TABLE OF hxc_time_attributes.attribute_category%TYPE INDEX BY BINARY_INTEGER;
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

Line 1410: l_return hxc_time_attributes.attribute1%TYPE;

1406:
1407: FUNCTION get_alternate_name_value ( p_alternate_name_comp_r csr_get_alternate_name_comps%ROWTYPE )
1408: RETURN VARCHAR2 IS
1409:
1410: l_return hxc_time_attributes.attribute1%TYPE;
1411:
1412: BEGIN
1413:
1414: IF ( p_alternate_name_comp_r.application_column_name = 'ATTRIBUTE1' )

Line 1648: l_value hxc_time_attributes.attribute1%TYPE;

1644: l_dynamic_sql CLOB; -- Bug 15977687
1645: l_ref_dyn_sql CLOB; -- Bug 15977687
1646: l_ind PLS_INTEGER := 1;
1647:
1648: l_value hxc_time_attributes.attribute1%TYPE;
1649:
1650: l_is_null VARCHAR2(20);
1651:
1652: l_comps_t l_comps_tab;

Line 2372: FROM hxc_time_attributes ta

2368: WHERE ';
2369:
2370: l_live_detail VARCHAR2(300) := '
2371: SELECT DISTINCT tau.time_building_block_id bb_id
2372: FROM hxc_time_attributes ta
2373: , hxc_time_attribute_usages tau
2374: WHERE tau.time_building_block_id = :p_tbb_id AND
2375: tau.time_building_block_ovn = :p_tbb_ovn
2376: AND ta.time_attribute_id = tau.time_attribute_id

Line 2381: from hxc_time_attributes ta,

2377: AND ';
2378:
2379: l_live_timecard VARCHAR2(875) := '
2380: SELECT DISTINCT detail.time_building_block_id bb_id
2381: from hxc_time_attributes ta,
2382: hxc_time_attribute_usages tau,
2383: hxc_latest_details tbb_latest,
2384: hxc_time_building_blocks detail,
2385: hxc_time_building_blocks day