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.MST_AUDIT_REP_EXCP dependencies on MST_GEOCODING

Line 1439: local_EPD := MST_GEOCODING.Get_local_time(shipFrom,earliest_pickup_date);

1435: EXIT WHEN cursor_DL%NOTFOUND;
1436:
1437: IF earliest_pickup_date IS NOT NULL AND latest_pickup_date IS NOT NULL THEN
1438: -- Adjust pickup time window to local time zone for ship_from facility (using Jin's function)
1439: local_EPD := MST_GEOCODING.Get_local_time(shipFrom,earliest_pickup_date);
1440: server_EPD := earliest_pickup_date;
1441: local_LPD := MST_GEOCODING.Get_local_time(shipFrom,latest_pickup_date);
1442: server_LPD := latest_pickup_date;
1443: /*

Line 1441: local_LPD := MST_GEOCODING.Get_local_time(shipFrom,latest_pickup_date);

1437: IF earliest_pickup_date IS NOT NULL AND latest_pickup_date IS NOT NULL THEN
1438: -- Adjust pickup time window to local time zone for ship_from facility (using Jin's function)
1439: local_EPD := MST_GEOCODING.Get_local_time(shipFrom,earliest_pickup_date);
1440: server_EPD := earliest_pickup_date;
1441: local_LPD := MST_GEOCODING.Get_local_time(shipFrom,latest_pickup_date);
1442: server_LPD := latest_pickup_date;
1443: /*
1444: debug_output('local_EPD=' || to_char(local_EPD,'MM/DD/YYYY HH24:MI:SS') || ', server_EPD=' || to_char(server_EPD,'MM/DD/YYYY HH24:MI:SS') ||
1445: ', local_LPD=' || to_char(local_LPD,'MM/DD/YYYY HH24:MI:SS') || ', server_LPD=' || to_char(server_LPD,'MM/DD/YYYY HH24:MI:SS') );

Line 1637: local_EDD := MST_GEOCODING.Get_local_time(shipTo,earliest_acceptable_date);

1633: EXIT WHEN cursor_DL%NOTFOUND;
1634:
1635: IF earliest_acceptable_date IS NOT NULL AND latest_acceptable_date IS NOT NULL THEN
1636: -- Adjust dropoff time window to local time zone for ship_to facility (using Jin's function)
1637: local_EDD := MST_GEOCODING.Get_local_time(shipTo,earliest_acceptable_date);
1638: server_EDD := earliest_acceptable_date;
1639: local_LDD := MST_GEOCODING.Get_local_time(shipTo,latest_acceptable_date);
1640: server_LDD := latest_acceptable_date;
1641: /*

Line 1639: local_LDD := MST_GEOCODING.Get_local_time(shipTo,latest_acceptable_date);

1635: IF earliest_acceptable_date IS NOT NULL AND latest_acceptable_date IS NOT NULL THEN
1636: -- Adjust dropoff time window to local time zone for ship_to facility (using Jin's function)
1637: local_EDD := MST_GEOCODING.Get_local_time(shipTo,earliest_acceptable_date);
1638: server_EDD := earliest_acceptable_date;
1639: local_LDD := MST_GEOCODING.Get_local_time(shipTo,latest_acceptable_date);
1640: server_LDD := latest_acceptable_date;
1641: /*
1642: debug_output('local_EDD=' || to_char(local_EDD,'MM/DD/YYYY HH24:MI:SS') || ', server_EDD=' || to_char(server_EDD,'MM/DD/YYYY HH24:MI:SS') ||
1643: ', local_LDD=' || to_char(local_LDD,'MM/DD/YYYY HH24:MI:SS') || ', server_LDD=' || to_char(server_LDD,'MM/DD/YYYY HH24:MI:SS') );