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 1389: l_return hxc_time_attributes.attribute1%TYPE;

1385:
1386: FUNCTION get_alternate_name_value ( p_alternate_name_comp_r csr_get_alternate_name_comps%ROWTYPE )
1387: RETURN VARCHAR2 IS
1388:
1389: l_return hxc_time_attributes.attribute1%TYPE;
1390:
1391: BEGIN
1392:
1393: IF ( p_alternate_name_comp_r.application_column_name = 'ATTRIBUTE1' )

Line 1627: l_value hxc_time_attributes.attribute1%TYPE;

1623: l_dynamic_sql LONG;
1624: l_ref_dyn_sql LONG;
1625: l_ind PLS_INTEGER := 1;
1626:
1627: l_value hxc_time_attributes.attribute1%TYPE;
1628:
1629: l_is_null VARCHAR2(20);
1630:
1631: l_comps_t l_comps_tab;

Line 2351: FROM hxc_time_attributes ta

2347: WHERE ';
2348:
2349: l_live_detail VARCHAR2(300) := '
2350: SELECT DISTINCT tau.time_building_block_id bb_id
2351: FROM hxc_time_attributes ta
2352: , hxc_time_attribute_usages tau
2353: WHERE tau.time_building_block_id = :p_tbb_id AND
2354: tau.time_building_block_ovn = :p_tbb_ovn
2355: AND ta.time_attribute_id = tau.time_attribute_id

Line 2360: from hxc_time_attributes ta,

2356: AND ';
2357:
2358: l_live_timecard VARCHAR2(875) := '
2359: SELECT DISTINCT detail.time_building_block_id bb_id
2360: from hxc_time_attributes ta,
2361: hxc_time_attribute_usages tau,
2362: hxc_latest_details tbb_latest,
2363: hxc_time_building_blocks detail,
2364: hxc_time_building_blocks day