[Home] [Help]
1789: CURSOR csr_chk_bld_blks_not_empty IS
1790: SELECT 'x'
1791: FROM dual
1792: WHERE EXISTS ( select 'y'
1793: from hxc_tmp_blks );
1794:
1795: t_bb_id tab_bb_id;
1796: t_ta_id tab_time_attribute_id;
1797: t_attribute_category tab_attribute_category;
2041: procedure gaz_debug_push_timecard is
2042:
2043: CURSOR gaz_blk IS
2044: SELECT *
2045: from hxc_tmp_blks;
2046:
2047: CURSOR gaz_att IS
2048: SELECT *
2049: from hxc_tmp_atts;
2143:
2144: l_start_time DATE;
2145: l_stop_time DATE;
2146:
2147: l_trunc_blks VARCHAR2(30) := 'delete from hxc_tmp_blks';
2148: l_trunc_atts VARCHAR2(30) := 'delete from hxc_tmp_atts';
2149:
2150: BEGIN
2151:
2289: -- blk insert
2290:
2291: FORALL blkx IN 1 .. x
2292:
2293: INSERT INTO hxc_tmp_blks (
2294: bb_id
2295: , measure
2296: , type
2297: , start_time
2962: l_select VARCHAR2(500) := '
2963: SELECT SUM( DECODE( tbb.type, ''RANGE'',
2964: FUNCTION((((tbb.stop_time)-(tbb.start_time))*24),PRECISION) + power(ZERO,PRECISION),
2965: NVL(tbb.measure, 0) )) hrs
2966: FROM hxc_tmp_blks tbb
2967: WHERE tbb.scope = ''DETAIL'' AND
2968: tbb.start_time < :p_period_end AND
2969: tbb.start_time >= :p_period_start AND
2970: tbb.bb_id IN ( ';
2973: l_select_null VARCHAR2(500) := '
2974: SELECT SUM( DECODE( tbb.type, ''RANGE'',
2975: FUNCTION((((tbb.stop_time)-(tbb.start_time))*24),PRECISION) + power(ZERO,PRECISION),
2976: NVL(tbb.measure, 0) )) hrs
2977: FROM hxc_tmp_blks tbb
2978: WHERE tbb.scope = ''DETAIL'' AND
2979: tbb.start_time < :p_period_end AND
2980: tbb.start_time >= :p_period_start ';
2981:
3376:
3377: CURSOR csr_get_tbbs IS
3378: SELECT bb_id,
3379: scope
3380: FROM hxc_tmp_blks;
3381:
3382:
3383: CURSOR csr_get_live_tbbs ( p_bb_id NUMBER, p_bb_ovn NUMBER ) IS
3384: SELECT detail.time_building_block_id bb_id,