APPS.HXC_GENERIC_RETRIEVAL_UTILS dependencies on HXC_TIME_BUILDING_BLOCKS

Line 30: FROM hxc_time_building_blocks tbb

26: , p_bb_ovn NUMBER )RETURN BOOLEAN IS
27:
28: CURSOR csr_get_bb_ovn IS
29: SELECT MAX(tbb.object_version_number)
30: FROM hxc_time_building_blocks tbb
31: WHERE tbb.time_building_block_id = p_bb_id;
32:
33: l_ovn hxc_time_building_blocks.object_version_number%TYPE;
34:

Line 33: l_ovn hxc_time_building_blocks.object_version_number%TYPE;

29: SELECT MAX(tbb.object_version_number)
30: FROM hxc_time_building_blocks tbb
31: WHERE tbb.time_building_block_id = p_bb_id;
32:
33: l_ovn hxc_time_building_blocks.object_version_number%TYPE;
34:
35: BEGIN
36:
37: OPEN csr_get_bb_ovn;

Line 238: l_start_time hxc_time_building_blocks.start_time%TYPE;

234: ) IS
235:
236: l_proc varchar2(72);
237:
238: l_start_time hxc_time_building_blocks.start_time%TYPE;
239: l_stop_time hxc_time_building_blocks.stop_time%TYPE;
240:
241: l_period_tab hxc_app_period_summary_api.valid_period_tab;
242: l_ind PLS_INTEGER;

Line 239: l_stop_time hxc_time_building_blocks.stop_time%TYPE;

235:
236: l_proc varchar2(72);
237:
238: l_start_time hxc_time_building_blocks.start_time%TYPE;
239: l_stop_time hxc_time_building_blocks.stop_time%TYPE;
240:
241: l_period_tab hxc_app_period_summary_api.valid_period_tab;
242: l_ind PLS_INTEGER;
243: l_cnt PLS_INTEGER;

Line 1562: l_day_parent hxc_time_building_blocks.time_building_block_id%TYPE;

1558: TYPE t_day_table IS TABLE OF r_day_record INDEX BY BINARY_INTEGER;
1559:
1560: l_day_table t_day_table;
1561:
1562: l_day_parent hxc_time_building_blocks.time_building_block_id%TYPE;
1563:
1564: l_day_changed BOOLEAN;
1565: l_same_timecard BOOLEAN;
1566: