469: end if;
470:
471: l_rec.departure_time:=
472: TO_CHAR(l_actual_start_date - (
473: inv_convert.inv_um_convert(
474: 0
475: , NULL
476: , NVL(l_task_rec.actual_travel_duration, 0)
477: , NVL(l_task_rec.actual_travel_duration_uom, g_uom_minutes)
518: end if;
519:
520: l_rec.departure_time:=
521: TO_CHAR(l_scheduled_start_date - (
522: inv_convert.inv_um_convert(
523: 0
524: , NULL
525: , NVL(l_task_rec.sched_travel_duration, 0)
526: , NVL(l_task_rec.sched_travel_duration_uom, g_uom_minutes)
1039: end if;
1040:
1041: l_rec.departure_time:=
1042: TO_CHAR(l_actual_start_date - (
1043: inv_convert.inv_um_convert(
1044: 0
1045: , NULL
1046: , NVL(l_task_rec.actual_travel_duration, 0)
1047: , NVL(l_task_rec.actual_travel_duration_uom, g_uom_minutes)
1104: end if;
1105:
1106: /*l_rec.departure_time:=
1107: TO_CHAR(l_scheduled_start_date - (
1108: inv_convert.inv_um_convert(
1109: 0
1110: , NULL
1111: , NVL(l_task_rec.sched_travel_duration, 0)
1112: , NVL(l_task_rec.sched_travel_duration_uom, g_uom_minutes)
1397: RETURN NUMBER IS
1398: l_value NUMBER;
1399: BEGIN
1400: l_value :=
1401: inv_convert.inv_um_convert(
1402: item_id => 0
1403: , PRECISION => 20
1404: , from_quantity => p_duration
1405: , from_unit => p_uom
1714:
1715: l_departure_time :=
1716: TO_CHAR
1717: (l_scheduled_start
1718: - (inv_convert.inv_um_convert(0, NULL, p_duration, g_uom_minutes, g_uom_hours, NULL
1719: , NULL)
1720: / 24
1721: )
1722: , 'hh24:mi'
1728: l_scheduled_start := l_dc_scheduled_start_date;
1729: l_departure_time :=
1730: TO_CHAR
1731: (l_scheduled_start
1732: - (inv_convert.inv_um_convert(0, NULL, p_duration, g_uom_minutes, g_uom_hours, NULL
1733: , NULL)
1734: / 24
1735: )
1736: , 'hh24:mi'
2307: return number
2308: is
2309: l_value number;
2310: begin
2311: l_value := inv_convert.inv_um_convert
2312: ( item_id => 0
2313: , precision => null
2314: , from_quantity => p_duration
2315: , from_unit => nvl(p_uom,g_uom_minutes)