eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TIMECARD_PROPERTIES

Line 3029: IF hxc_timecard_properties.g_rounding_rule = 'ROUND_UP'

3025: zero = 0
3026:
3027: */
3028:
3029: IF hxc_timecard_properties.g_rounding_rule = 'ROUND_UP'
3030: THEN
3031:
3032: l_select := REPLACE(l_select,'FUNCTION','TRUNC');
3033: l_select := REPLACE(l_select,'ZERO','0.1');

Line 3034: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);

3030: THEN
3031:
3032: l_select := REPLACE(l_select,'FUNCTION','TRUNC');
3033: l_select := REPLACE(l_select,'ZERO','0.1');
3034: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);
3035:
3036: l_select_null := REPLACE(l_select_null,'FUNCTION','TRUNC');
3037: l_select_null := REPLACE(l_select_null,'ZERO','0.1');
3038: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);

Line 3038: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);

3034: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);
3035:
3036: l_select_null := REPLACE(l_select_null,'FUNCTION','TRUNC');
3037: l_select_null := REPLACE(l_select_null,'ZERO','0.1');
3038: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);
3039:
3040:
3041: ELSIF hxc_timecard_properties.g_rounding_rule = 'ROUND_DOWN'
3042: THEN

Line 3041: ELSIF hxc_timecard_properties.g_rounding_rule = 'ROUND_DOWN'

3037: l_select_null := REPLACE(l_select_null,'ZERO','0.1');
3038: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);
3039:
3040:
3041: ELSIF hxc_timecard_properties.g_rounding_rule = 'ROUND_DOWN'
3042: THEN
3043:
3044: l_select := REPLACE(l_select,'FUNCTION','TRUNC');
3045: l_select := REPLACE(l_select,'ZERO','0');

Line 3046: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);

3042: THEN
3043:
3044: l_select := REPLACE(l_select,'FUNCTION','TRUNC');
3045: l_select := REPLACE(l_select,'ZERO','0');
3046: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);
3047:
3048: l_select_null := REPLACE(l_select_null,'FUNCTION','TRUNC');
3049: l_select_null := REPLACE(l_select_null,'ZERO','0');
3050: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);

Line 3050: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);

3046: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);
3047:
3048: l_select_null := REPLACE(l_select_null,'FUNCTION','TRUNC');
3049: l_select_null := REPLACE(l_select_null,'ZERO','0');
3050: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);
3051:
3052:
3053: ELSIF hxc_timecard_properties.g_rounding_rule = 'ROUND_TO_NEAREST'
3054: THEN

Line 3053: ELSIF hxc_timecard_properties.g_rounding_rule = 'ROUND_TO_NEAREST'

3049: l_select_null := REPLACE(l_select_null,'ZERO','0');
3050: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);
3051:
3052:
3053: ELSIF hxc_timecard_properties.g_rounding_rule = 'ROUND_TO_NEAREST'
3054: THEN
3055:
3056: l_select := REPLACE(l_select,'FUNCTION','ROUND');
3057: l_select := REPLACE(l_select,'ZERO','0');

Line 3058: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);

3054: THEN
3055:
3056: l_select := REPLACE(l_select,'FUNCTION','ROUND');
3057: l_select := REPLACE(l_select,'ZERO','0');
3058: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);
3059:
3060: l_select_null := REPLACE(l_select_null,'FUNCTION','ROUND');
3061: l_select_null := REPLACE(l_select_null,'ZERO','0');
3062: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);

Line 3062: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);

3058: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);
3059:
3060: l_select_null := REPLACE(l_select_null,'FUNCTION','ROUND');
3061: l_select_null := REPLACE(l_select_null,'ZERO','0');
3062: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);
3063:
3064: ELSIF hxc_timecard_properties.g_rounding_rule = 'SHOW_ERROR' -- Added for Bug 14582971
3065: THEN
3066:

Line 3064: ELSIF hxc_timecard_properties.g_rounding_rule = 'SHOW_ERROR' -- Added for Bug 14582971

3060: l_select_null := REPLACE(l_select_null,'FUNCTION','ROUND');
3061: l_select_null := REPLACE(l_select_null,'ZERO','0');
3062: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);
3063:
3064: ELSIF hxc_timecard_properties.g_rounding_rule = 'SHOW_ERROR' -- Added for Bug 14582971
3065: THEN
3066:
3067: l_select := REPLACE(l_select,'FUNCTION','ROUND');
3068: l_select := REPLACE(l_select,'ZERO','0');

Line 3069: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);

3065: THEN
3066:
3067: l_select := REPLACE(l_select,'FUNCTION','ROUND');
3068: l_select := REPLACE(l_select,'ZERO','0');
3069: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);
3070:
3071: l_select_null := REPLACE(l_select_null,'FUNCTION','ROUND');
3072: l_select_null := REPLACE(l_select_null,'ZERO','0');
3073: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);

Line 3073: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);

3069: l_select := REPLACE(l_select,'PRECISION',hxc_timecard_properties.g_precision);
3070:
3071: l_select_null := REPLACE(l_select_null,'FUNCTION','ROUND');
3072: l_select_null := REPLACE(l_select_null,'ZERO','0');
3073: l_select_null := REPLACE(l_select_null,'PRECISION',hxc_timecard_properties.g_precision);
3074:
3075:
3076: END IF;
3077: