DBA Data[Home] [Help]

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_FIND_NOTIFY_APRS_PKG

Line 3148: l_select VARCHAR2(700) := 'SELECT SUM( HXC_FIND_NOTIFY_APRS_PKG.apply_round_rule('||''''||

3144: , p_decimal_precision IN VARCHAR2) IS
3145:
3146: l_proc VARCHAR2(72);
3147:
3148: l_select VARCHAR2(700) := 'SELECT SUM( HXC_FIND_NOTIFY_APRS_PKG.apply_round_rule('||''''||
3149: p_rounding_rule||''''||','||''''||
3150: p_decimal_precision||''''||',
3151: (DECODE( tbb.type, ''RANGE'',
3152: (((tbb.stop_time)-(tbb.start_time))*24),

Line 4957: l_timecard_hrs := l_timecard_hrs + hxc_find_notify_aprs_pkg.apply_round_rule(

4953: ELSE
4954:
4955: for hrs_rec in csr_timecard_hrs(p_tbb_id,p_tbb_ovn) loop
4956:
4957: l_timecard_hrs := l_timecard_hrs + hxc_find_notify_aprs_pkg.apply_round_rule(
4958: l_rounding_rule,
4959: l_precision,
4960: nvl(hrs_rec.hrs,0)
4961: );

Line 5189: l_total_hours := l_total_hours + hxc_find_notify_aprs_pkg.apply_round_rule(

5185:
5186: WHILE csr_get_total_timecard_hrs%FOUND
5187: LOOP
5188:
5189: l_total_hours := l_total_hours + hxc_find_notify_aprs_pkg.apply_round_rule(
5190: l_rounding_rule,
5191: l_precision,
5192: l_hours
5193: );