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_FREIGHT_COSTS

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 1137: FROM wsh_freight_costs

1133: END IF;
1134: END IF;
1135:
1136: DELETE
1137: FROM wsh_freight_costs
1138: WHERE trip_id = l_trip_id;
1139:
1140: IF SQL%FOUND THEN
1141: IF l_debug_on THEN

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

1138: WHERE trip_id = l_trip_id;
1139:
1140: IF SQL%FOUND THEN
1141: IF l_debug_on THEN
1142: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1143: END IF;
1144: END IF;
1145:
1146: DELETE

Line 1198: WSH_FREIGHT_COSTS

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,
1202: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,

Line 1262: FROM wsh_freight_costs

1258: END IF;
1259: END IF;
1260:
1261: DELETE
1262: FROM wsh_freight_costs
1263: WHERE delivery_id = l_delivery_id;
1264:
1265: IF SQL%FOUND THEN
1266: IF l_debug_on THEN

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

1263: WHERE delivery_id = l_delivery_id;
1264:
1265: IF SQL%FOUND THEN
1266: IF l_debug_on THEN
1267: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1268: END IF;
1269: END IF;
1270:
1271: 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 1516: FROM wsh_freight_costs

1512: END IF;
1513: END IF;
1514:
1515: DELETE
1516: FROM wsh_freight_costs
1517: WHERE stop_id = l_stop_id;
1518:
1519: IF SQL%FOUND THEN
1520: IF l_debug_on THEN

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

1517: WHERE stop_id = l_stop_id;
1518:
1519: IF SQL%FOUND THEN
1520: IF l_debug_on THEN
1521: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: STOP_ID=' || l_stop_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1522: END IF;
1523: END IF;
1524:
1525: DELETE

Line 1565: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,

1561: Input: Table of Record Types for Delivery Legs
1562: Output: Return Status - success or failure
1563: ==============================================================================
1564: Logic: i) Delete records from the following tables:
1565: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,
1566: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS
1567:
1568: If FTE is installed,
1569: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,

Line 1601: FROM wsh_freight_costs

1597: LOOP
1598: l_leg_id := p_tbl_del_leg_purge_set(l_loop_index).delivery_leg_id;
1599:
1600: DELETE
1601: FROM wsh_freight_costs
1602: WHERE delivery_leg_id = l_leg_id;
1603:
1604: IF SQL%FOUND THEN
1605: IF l_debug_on THEN

Line 1606: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1602: WHERE delivery_leg_id = l_leg_id;
1603:
1604: IF SQL%FOUND THEN
1605: IF l_debug_on THEN
1606: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1607: END IF;
1608: END IF;
1609:
1610: IF (wsh_util_core.fte_is_installed='Y') THEN

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 1791: FROM wsh_freight_costs

1787: END IF;
1788: END IF;
1789:
1790: DELETE
1791: FROM wsh_freight_costs
1792: WHERE delivery_detail_id = l_detail_id;
1793:
1794: IF SQL%FOUND THEN
1795: IF l_debug_on THEN

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

1792: WHERE delivery_detail_id = l_detail_id;
1793:
1794: IF SQL%FOUND THEN
1795: IF l_debug_on THEN
1796: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: DELIVERY_DETAIL_ID=' || l_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1797: END IF;
1798: END IF;
1799:
1800: DELETE

Line 1897: FROM wsh_freight_costs

1893: END IF;
1894: END IF;
1895:
1896: DELETE
1897: FROM wsh_freight_costs
1898: WHERE delivery_detail_id = l_container_id;
1899:
1900: IF SQL%FOUND THEN
1901: IF l_debug_on THEN

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

1898: WHERE delivery_detail_id = l_container_id;
1899:
1900: IF SQL%FOUND THEN
1901: IF l_debug_on THEN
1902: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: CONTAINER_ID=' || l_container_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1903: END IF;
1904: END IF;
1905:
1906: DELETE