DBA Data[Home] [Help]

APPS.FTE_TRIPS_PVT dependencies on FND_GLOBAL

Line 363: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),

359: 'OP',
360: decode(p_trip_info.private_trip, FND_API.G_MISS_CHAR, NULL, p_trip_info.private_trip),
361: decode(p_trip_info.validation_required, FND_API.G_MISS_CHAR, NULL, p_trip_info.validation_required),
362: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
363: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
364: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
365: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
366: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
367: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),

Line 365: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),

361: decode(p_trip_info.validation_required, FND_API.G_MISS_CHAR, NULL, p_trip_info.validation_required),
362: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
363: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
364: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
365: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
366: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
367: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
368: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
369: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),

Line 366: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),

362: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
363: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
364: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
365: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
366: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
367: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
368: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
369: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
370: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),

Line 522: created_by=decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),

518: status_code = decode(p_trip_info.status_code, FND_API.G_MISS_CHAR, status_code, p_trip_info.status_code),
519: private_trip=decode(p_trip_info.private_trip, FND_API.G_MISS_CHAR, NULL, p_trip_info.private_trip),
520: validation_required=decode(p_trip_info.validation_required, FND_API.G_MISS_CHAR, NULL, p_trip_info.validation_required),
521: creation_date=decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
522: created_by=decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
523: last_update_date=decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
524: last_updated_by=decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
525: last_update_login=decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
526: program_application_id=decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),

Line 524: last_updated_by=decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),

520: validation_required=decode(p_trip_info.validation_required, FND_API.G_MISS_CHAR, NULL, p_trip_info.validation_required),
521: creation_date=decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
522: created_by=decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
523: last_update_date=decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
524: last_updated_by=decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
525: last_update_login=decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
526: program_application_id=decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
527: program_id= decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
528: program_update_date=decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),

Line 525: last_update_login=decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),

521: creation_date=decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
522: created_by=decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
523: last_update_date=decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
524: last_updated_by=decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
525: last_update_login=decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
526: program_application_id=decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
527: program_id= decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
528: program_update_date=decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
529: request_id=decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),

Line 1506: --x_shipment_info := 'Shipment Pickup Information:' || FND_GLOBAL.TAB ||

1502: FND_MESSAGE.SET_NAME('FTE', 'FTE_MLS_TENDER_EMAIL_HDR_PU');
1503: l_mssg_text := FND_MESSAGE.GET;
1504: x_shipment_info := l_mssg_text;
1505:
1506: --x_shipment_info := 'Shipment Pickup Information:' || FND_GLOBAL.TAB ||
1507: -- 'Date and Time,' || FND_GLOBAL.TAB ||
1508: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1509: -- FND_GLOBAL.NEWLINE || 'Pickup Location:';
1510: ELSIF (l_loop_count = l_stop_count)

Line 1507: -- 'Date and Time,' || FND_GLOBAL.TAB ||

1503: l_mssg_text := FND_MESSAGE.GET;
1504: x_shipment_info := l_mssg_text;
1505:
1506: --x_shipment_info := 'Shipment Pickup Information:' || FND_GLOBAL.TAB ||
1507: -- 'Date and Time,' || FND_GLOBAL.TAB ||
1508: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1509: -- FND_GLOBAL.NEWLINE || 'Pickup Location:';
1510: ELSIF (l_loop_count = l_stop_count)
1511: THEN

Line 1508: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||

1504: x_shipment_info := l_mssg_text;
1505:
1506: --x_shipment_info := 'Shipment Pickup Information:' || FND_GLOBAL.TAB ||
1507: -- 'Date and Time,' || FND_GLOBAL.TAB ||
1508: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1509: -- FND_GLOBAL.NEWLINE || 'Pickup Location:';
1510: ELSIF (l_loop_count = l_stop_count)
1511: THEN
1512: FND_MESSAGE.SET_NAME('FTE', 'FTE_MLS_TENDER_EMAIL_HDR_DO');

Line 1509: -- FND_GLOBAL.NEWLINE || 'Pickup Location:';

1505:
1506: --x_shipment_info := 'Shipment Pickup Information:' || FND_GLOBAL.TAB ||
1507: -- 'Date and Time,' || FND_GLOBAL.TAB ||
1508: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1509: -- FND_GLOBAL.NEWLINE || 'Pickup Location:';
1510: ELSIF (l_loop_count = l_stop_count)
1511: THEN
1512: FND_MESSAGE.SET_NAME('FTE', 'FTE_MLS_TENDER_EMAIL_HDR_DO');
1513: l_mssg_text := FND_MESSAGE.GET;

Line 1514: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE || l_mssg_text;

1510: ELSIF (l_loop_count = l_stop_count)
1511: THEN
1512: FND_MESSAGE.SET_NAME('FTE', 'FTE_MLS_TENDER_EMAIL_HDR_DO');
1513: l_mssg_text := FND_MESSAGE.GET;
1514: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE || l_mssg_text;
1515:
1516: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1517: -- 'Shipment Delivery Information:' || FND_GLOBAL.TAB ||
1518: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||

Line 1516: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||

1512: FND_MESSAGE.SET_NAME('FTE', 'FTE_MLS_TENDER_EMAIL_HDR_DO');
1513: l_mssg_text := FND_MESSAGE.GET;
1514: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE || l_mssg_text;
1515:
1516: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1517: -- 'Shipment Delivery Information:' || FND_GLOBAL.TAB ||
1518: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1519: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1520: -- FND_GLOBAL.NEWLINE || 'Dropoff Location:';

Line 1517: -- 'Shipment Delivery Information:' || FND_GLOBAL.TAB ||

1513: l_mssg_text := FND_MESSAGE.GET;
1514: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE || l_mssg_text;
1515:
1516: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1517: -- 'Shipment Delivery Information:' || FND_GLOBAL.TAB ||
1518: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1519: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1520: -- FND_GLOBAL.NEWLINE || 'Dropoff Location:';
1521: ELSIF (l_loop_count < l_stop_count)

Line 1518: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||

1514: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE || l_mssg_text;
1515:
1516: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1517: -- 'Shipment Delivery Information:' || FND_GLOBAL.TAB ||
1518: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1519: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1520: -- FND_GLOBAL.NEWLINE || 'Dropoff Location:';
1521: ELSIF (l_loop_count < l_stop_count)
1522: THEN

Line 1519: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||

1515:
1516: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1517: -- 'Shipment Delivery Information:' || FND_GLOBAL.TAB ||
1518: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1519: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1520: -- FND_GLOBAL.NEWLINE || 'Dropoff Location:';
1521: ELSIF (l_loop_count < l_stop_count)
1522: THEN
1523: FND_MESSAGE.SET_NAME('FTE', 'FTE_MLS_TENDER_EMAIL_HDR_INT');

Line 1520: -- FND_GLOBAL.NEWLINE || 'Dropoff Location:';

1516: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1517: -- 'Shipment Delivery Information:' || FND_GLOBAL.TAB ||
1518: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1519: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1520: -- FND_GLOBAL.NEWLINE || 'Dropoff Location:';
1521: ELSIF (l_loop_count < l_stop_count)
1522: THEN
1523: FND_MESSAGE.SET_NAME('FTE', 'FTE_MLS_TENDER_EMAIL_HDR_INT');
1524: l_mssg_text := FND_MESSAGE.GET;

Line 1525: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||

1521: ELSIF (l_loop_count < l_stop_count)
1522: THEN
1523: FND_MESSAGE.SET_NAME('FTE', 'FTE_MLS_TENDER_EMAIL_HDR_INT');
1524: l_mssg_text := FND_MESSAGE.GET;
1525: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1526: l_mssg_text ||' '|| (l_loop_count-1);
1527:
1528: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1529: -- 'Intermediate Location Information:' || FND_GLOBAL.TAB ||

Line 1528: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||

1524: l_mssg_text := FND_MESSAGE.GET;
1525: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1526: l_mssg_text ||' '|| (l_loop_count-1);
1527:
1528: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1529: -- 'Intermediate Location Information:' || FND_GLOBAL.TAB ||
1530: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1531: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1532: -- FND_GLOBAL.NEWLINE || 'Intermediate Location:' || (l_loop_count-1);

Line 1529: -- 'Intermediate Location Information:' || FND_GLOBAL.TAB ||

1525: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1526: l_mssg_text ||' '|| (l_loop_count-1);
1527:
1528: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1529: -- 'Intermediate Location Information:' || FND_GLOBAL.TAB ||
1530: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1531: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1532: -- FND_GLOBAL.NEWLINE || 'Intermediate Location:' || (l_loop_count-1);
1533: END IF;

Line 1530: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||

1526: l_mssg_text ||' '|| (l_loop_count-1);
1527:
1528: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1529: -- 'Intermediate Location Information:' || FND_GLOBAL.TAB ||
1530: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1531: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1532: -- FND_GLOBAL.NEWLINE || 'Intermediate Location:' || (l_loop_count-1);
1533: END IF;
1534:

Line 1531: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||

1527:
1528: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1529: -- 'Intermediate Location Information:' || FND_GLOBAL.TAB ||
1530: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1531: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1532: -- FND_GLOBAL.NEWLINE || 'Intermediate Location:' || (l_loop_count-1);
1533: END IF;
1534:
1535: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||

Line 1532: -- FND_GLOBAL.NEWLINE || 'Intermediate Location:' || (l_loop_count-1);

1528: --x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1529: -- 'Intermediate Location Information:' || FND_GLOBAL.TAB ||
1530: -- FND_GLOBAL.TAB || 'Date and Time,' || FND_GLOBAL.TAB ||
1531: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1532: -- FND_GLOBAL.NEWLINE || 'Intermediate Location:' || (l_loop_count-1);
1533: END IF;
1534:
1535: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1536: l_pickup_location || FND_GLOBAL.TAB ||

Line 1535: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||

1531: -- FND_GLOBAL.TAB || 'Weight,' || FND_GLOBAL.TAB || 'Volume' ||
1532: -- FND_GLOBAL.NEWLINE || 'Intermediate Location:' || (l_loop_count-1);
1533: END IF;
1534:
1535: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1536: l_pickup_location || FND_GLOBAL.TAB ||
1537: l_planned_departure_date || FND_GLOBAL.TAB ||
1538: to_char(l_stop_total_weight) || ' ' || l_stop_weight_measure ||
1539: FND_GLOBAL.TAB ||

Line 1536: l_pickup_location || FND_GLOBAL.TAB ||

1532: -- FND_GLOBAL.NEWLINE || 'Intermediate Location:' || (l_loop_count-1);
1533: END IF;
1534:
1535: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1536: l_pickup_location || FND_GLOBAL.TAB ||
1537: l_planned_departure_date || FND_GLOBAL.TAB ||
1538: to_char(l_stop_total_weight) || ' ' || l_stop_weight_measure ||
1539: FND_GLOBAL.TAB ||
1540: to_char(l_stop_total_volume) || ' ' || l_stop_volume_measure ||

Line 1537: l_planned_departure_date || FND_GLOBAL.TAB ||

1533: END IF;
1534:
1535: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1536: l_pickup_location || FND_GLOBAL.TAB ||
1537: l_planned_departure_date || FND_GLOBAL.TAB ||
1538: to_char(l_stop_total_weight) || ' ' || l_stop_weight_measure ||
1539: FND_GLOBAL.TAB ||
1540: to_char(l_stop_total_volume) || ' ' || l_stop_volume_measure ||
1541: FND_GLOBAL.NEWLINE;

Line 1539: FND_GLOBAL.TAB ||

1535: x_shipment_info := x_shipment_info || FND_GLOBAL.NEWLINE ||
1536: l_pickup_location || FND_GLOBAL.TAB ||
1537: l_planned_departure_date || FND_GLOBAL.TAB ||
1538: to_char(l_stop_total_weight) || ' ' || l_stop_weight_measure ||
1539: FND_GLOBAL.TAB ||
1540: to_char(l_stop_total_volume) || ' ' || l_stop_volume_measure ||
1541: FND_GLOBAL.NEWLINE;
1542:
1543:

Line 1541: FND_GLOBAL.NEWLINE;

1537: l_planned_departure_date || FND_GLOBAL.TAB ||
1538: to_char(l_stop_total_weight) || ' ' || l_stop_weight_measure ||
1539: FND_GLOBAL.TAB ||
1540: to_char(l_stop_total_volume) || ' ' || l_stop_volume_measure ||
1541: FND_GLOBAL.NEWLINE;
1542:
1543:
1544: l_loop_count := l_loop_count+1;
1545: --}