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 155: l_start_time hxc_time_building_blocks.start_time%TYPE;

151: ) IS
152:
153: l_proc varchar2(72);
154:
155: l_start_time hxc_time_building_blocks.start_time%TYPE;
156: l_stop_time hxc_time_building_blocks.stop_time%TYPE;
157:
158: l_period_tab hxc_app_period_summary_api.valid_period_tab;
159: l_ind PLS_INTEGER;

Line 156: l_stop_time hxc_time_building_blocks.stop_time%TYPE;

152:
153: l_proc varchar2(72);
154:
155: l_start_time hxc_time_building_blocks.start_time%TYPE;
156: l_stop_time hxc_time_building_blocks.stop_time%TYPE;
157:
158: l_period_tab hxc_app_period_summary_api.valid_period_tab;
159: l_ind PLS_INTEGER;
160: l_cnt PLS_INTEGER;

Line 1411: l_day_parent hxc_time_building_blocks.time_building_block_id%TYPE;

1407: TYPE t_day_table IS TABLE OF r_day_record INDEX BY BINARY_INTEGER;
1408:
1409: l_day_table t_day_table;
1410:
1411: l_day_parent hxc_time_building_blocks.time_building_block_id%TYPE;
1412:
1413: l_day_changed BOOLEAN;
1414: l_same_timecard BOOLEAN;
1415: