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 1219: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS

1215: Input: Table of Record Types for Trips
1216: Output: Return Status - success or failure
1217: ==============================================================================
1218: Logic: i) Delete records from the following tables:
1219: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS
1220: -----------------------------------------------------------------------------*/
1221:
1222: PROCEDURE Purge_Trips( p_tbl_trip_purge_set Trip_ID_Tbl_Type,
1223: x_return_status OUT NOCOPY VARCHAR2

Line 1262: FROM wsh_freight_costs

1258: END IF;
1259: END IF;
1260:
1261: DELETE
1262: FROM wsh_freight_costs
1263: WHERE trip_id = l_trip_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: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1263: WHERE trip_id = l_trip_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: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1268: END IF;
1269: END IF;
1270:
1271: DELETE

Line 1323: WSH_FREIGHT_COSTS

1319: Output: Return Status - success or failure
1320: ==============================================================================
1321: Logic: i) Delete records from the following tables:
1322: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,
1323: WSH_FREIGHT_COSTS
1324:
1325: If FTE is installed,
1326: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,
1327: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,

Line 1387: FROM wsh_freight_costs

1383: END IF;
1384: END IF;
1385:
1386: DELETE
1387: FROM wsh_freight_costs
1388: WHERE delivery_id = l_delivery_id;
1389:
1390: IF SQL%FOUND THEN
1391: IF l_debug_on THEN

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

1388: WHERE delivery_id = l_delivery_id;
1389:
1390: IF SQL%FOUND THEN
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1393: END IF;
1394: END IF;
1395:
1396: DELETE

Line 1599: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_TRIP_STOPS

1595: Input: Table of Record Types for Trip Stops
1596: Output: Return Status - success or failure
1597: ==============================================================================
1598: Logic: i) Delete records from the following tables:
1599: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_TRIP_STOPS
1600: -----------------------------------------------------------------------------*/
1601:
1602: PROCEDURE Purge_Trip_Stops( p_tbl_trip_stop_purge_set Trip_Stop_ID_Tbl_Type,
1603: x_return_status OUT NOCOPY VARCHAR2

Line 1641: FROM wsh_freight_costs

1637: END IF;
1638: END IF;
1639:
1640: DELETE
1641: FROM wsh_freight_costs
1642: WHERE stop_id = l_stop_id;
1643:
1644: IF SQL%FOUND THEN
1645: IF l_debug_on THEN

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

1642: WHERE stop_id = l_stop_id;
1643:
1644: IF SQL%FOUND THEN
1645: IF l_debug_on THEN
1646: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: STOP_ID=' || l_stop_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1647: END IF;
1648: END IF;
1649:
1650: DELETE

Line 1690: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,

1686: Input: Table of Record Types for Delivery Legs
1687: Output: Return Status - success or failure
1688: ==============================================================================
1689: Logic: i) Delete records from the following tables:
1690: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,
1691: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS
1692:
1693: If FTE is installed,
1694: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,

Line 1726: FROM wsh_freight_costs

1722: LOOP
1723: l_leg_id := p_tbl_del_leg_purge_set(l_loop_index).delivery_leg_id;
1724:
1725: DELETE
1726: FROM wsh_freight_costs
1727: WHERE delivery_leg_id = l_leg_id;
1728:
1729: IF SQL%FOUND THEN
1730: IF l_debug_on THEN

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

1727: WHERE delivery_leg_id = l_leg_id;
1728:
1729: IF SQL%FOUND THEN
1730: IF l_debug_on THEN
1731: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1732: END IF;
1733: END IF;
1734:
1735: IF (wsh_util_core.fte_is_installed='Y') THEN

Line 1865: WSH_FREIGHT_COSTS, WSH_SERIAL_NUMBERS, WSH_EXCEPTIONS,

1861: Input: Table of Record Types for Delivery Details
1862: Output: Return Status - success or failure
1863: ==============================================================================
1864: Logic: i) Delete records from the following tables:
1865: WSH_FREIGHT_COSTS, WSH_SERIAL_NUMBERS, WSH_EXCEPTIONS,
1866: wsh_delivery_assignments_v, WSH_DELIVERY_DETAILS
1867: -----------------------------------------------------------------------------*/
1868: PROCEDURE Purge_Delivery_Details(p_tbl_del_detail_purge_set Del_Detail_ID_Tbl_Type,
1869: x_return_status OUT NOCOPY VARCHAR2

Line 1916: FROM wsh_freight_costs

1912: END IF;
1913: END IF;
1914:
1915: DELETE
1916: FROM wsh_freight_costs
1917: WHERE delivery_detail_id = l_detail_id;
1918:
1919: IF SQL%FOUND THEN
1920: IF l_debug_on THEN

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

1917: WHERE delivery_detail_id = l_detail_id;
1918:
1919: IF SQL%FOUND THEN
1920: IF l_debug_on THEN
1921: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: DELIVERY_DETAIL_ID=' || l_detail_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1922: END IF;
1923: END IF;
1924:
1925: DELETE

Line 2022: FROM wsh_freight_costs

2018: END IF;
2019: END IF;
2020:
2021: DELETE
2022: FROM wsh_freight_costs
2023: WHERE delivery_detail_id = l_container_id;
2024:
2025: IF SQL%FOUND THEN
2026: IF l_debug_on THEN

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

2023: WHERE delivery_detail_id = l_container_id;
2024:
2025: IF SQL%FOUND THEN
2026: IF l_debug_on THEN
2027: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_freight_costs: CONTAINER_ID=' || l_container_id, WSH_DEBUG_SV.C_PROC_LEVEL);
2028: END IF;
2029: END IF;
2030:
2031: DELETE