DBA Data[Home] [Help]

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_FIND_NOTIFY_APRS_PKG

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

3261: , p_decimal_precision IN VARCHAR2) IS
3262:
3263: l_proc VARCHAR2(72);
3264:
3265: l_select VARCHAR2(700) := 'SELECT SUM( HXC_FIND_NOTIFY_APRS_PKG.apply_round_rule('||''''||
3266: p_rounding_rule||''''||','||''''||
3267: p_decimal_precision||''''||',
3268: (DECODE( tbb.type, ''RANGE'',
3269: (((tbb.stop_time)-(tbb.start_time))*24),

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

5070: ELSE
5071:
5072: for hrs_rec in csr_timecard_hrs(p_tbb_id,p_tbb_ovn) loop
5073:
5074: l_timecard_hrs := l_timecard_hrs + hxc_find_notify_aprs_pkg.apply_round_rule(
5075: l_rounding_rule,
5076: l_precision,
5077: nvl(hrs_rec.hrs,0)
5078: );

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

5302:
5303: WHILE csr_get_total_timecard_hrs%FOUND
5304: LOOP
5305:
5306: l_total_hours := l_total_hours + hxc_find_notify_aprs_pkg.apply_round_rule(
5307: l_rounding_rule,
5308: l_precision,
5309: l_hours
5310: );