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.WSH_PURGE dependencies on WSH_EXCEPTIONS

Line 1094: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS

1090: Input: Table of Record Types for Trips
1091: Output: Return Status - success or failure
1092: ==============================================================================
1093: Logic: i) Delete records from the following tables:
1094: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS
1095: -----------------------------------------------------------------------------*/
1096:
1097: PROCEDURE Purge_Trips( p_tbl_trip_purge_set Trip_ID_Tbl_Type,
1098: x_return_status OUT NOCOPY VARCHAR2

Line 1127: FROM wsh_exceptions

1123: LOOP
1124: l_trip_id := p_tbl_trip_purge_set(l_loop_index).trip_id;
1125:
1126: DELETE
1127: FROM wsh_exceptions
1128: WHERE trip_id = l_trip_id;
1129:
1130: IF SQL%FOUND THEN
1131: IF l_debug_on THEN

Line 1132: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1128: WHERE trip_id = l_trip_id;
1129:
1130: IF SQL%FOUND THEN
1131: IF l_debug_on THEN
1132: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1133: END IF;
1134: END IF;
1135:
1136: DELETE

Line 1197: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,

1193: Input: Table of Record Types for Deliveries
1194: Output: Return Status - success or failure
1195: ==============================================================================
1196: Logic: i) Delete records from the following tables:
1197: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,
1198: WSH_FREIGHT_COSTS
1199:
1200: If FTE is installed,
1201: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,

Line 1241: FROM wsh_exceptions

1237:
1238: l_delivery_id := p_tbl_delivery_purge_set(l_loop_index).delivery_id;
1239:
1240: DELETE
1241: FROM wsh_exceptions
1242: WHERE delivery_id = l_delivery_id;
1243:
1244: IF SQL%FOUND THEN
1245: IF l_debug_on THEN

Line 1246: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1242: WHERE delivery_id = l_delivery_id;
1243:
1244: IF SQL%FOUND THEN
1245: IF l_debug_on THEN
1246: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1247: END IF;
1248: END IF;
1249:
1250: DELETE

Line 1474: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_TRIP_STOPS

1470: Input: Table of Record Types for Trip Stops
1471: Output: Return Status - success or failure
1472: ==============================================================================
1473: Logic: i) Delete records from the following tables:
1474: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_TRIP_STOPS
1475: -----------------------------------------------------------------------------*/
1476:
1477: PROCEDURE Purge_Trip_Stops( p_tbl_trip_stop_purge_set Trip_Stop_ID_Tbl_Type,
1478: x_return_status OUT NOCOPY VARCHAR2

Line 1506: FROM wsh_exceptions

1502: LOOP
1503: l_stop_id := p_tbl_trip_stop_purge_set(l_loop_index).stop_id;
1504:
1505: DELETE
1506: FROM wsh_exceptions
1507: WHERE trip_stop_id = l_stop_id;
1508:
1509: IF SQL%FOUND THEN
1510: IF l_debug_on THEN

Line 1511: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: STOP_ID=' || l_stop_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1507: WHERE trip_stop_id = l_stop_id;
1508:
1509: IF SQL%FOUND THEN
1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: STOP_ID=' || l_stop_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1512: END IF;
1513: END IF;
1514:
1515: DELETE

Line 1740: WSH_FREIGHT_COSTS, WSH_SERIAL_NUMBERS, WSH_EXCEPTIONS,

1736: Input: Table of Record Types for Delivery Details
1737: Output: Return Status - success or failure
1738: ==============================================================================
1739: Logic: i) Delete records from the following tables:
1740: WSH_FREIGHT_COSTS, WSH_SERIAL_NUMBERS, WSH_EXCEPTIONS,
1741: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS
1742: -----------------------------------------------------------------------------*/
1743: PROCEDURE Purge_Delivery_Details(p_tbl_del_detail_purge_set Del_Detail_ID_Tbl_Type,
1744: x_return_status OUT NOCOPY VARCHAR2

Line 1781: FROM wsh_exceptions

1777: END IF;
1778: END IF;
1779:
1780: DELETE
1781: FROM wsh_exceptions
1782: WHERE delivery_detail_id = l_detail_id;
1783:
1784: IF SQL%FOUND THEN
1785: IF l_debug_on THEN

Line 1786: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: DELIVERY_DETAIL_ID=' || l_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1782: WHERE delivery_detail_id = l_detail_id;
1783:
1784: IF SQL%FOUND THEN
1785: IF l_debug_on THEN
1786: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: DELIVERY_DETAIL_ID=' || l_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1787: END IF;
1788: END IF;
1789:
1790: DELETE

Line 1887: FROM wsh_exceptions

1883: l_container_id := p_tbl_containers_purge_set(l_loop_index).container_id;
1884:
1885:
1886: DELETE
1887: FROM wsh_exceptions
1888: WHERE delivery_detail_id = l_container_id;
1889:
1890: IF SQL%FOUND THEN
1891: IF l_debug_on THEN

Line 1892: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: CONTAINER_ID=' || l_container_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1888: WHERE delivery_detail_id = l_container_id;
1889:
1890: IF SQL%FOUND THEN
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_exceptions: CONTAINER_ID=' || l_container_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1893: END IF;
1894: END IF;
1895:
1896: DELETE