APPS.WSH_PURGE dependencies on WSH_SERIAL_NUMBERS

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 1896: FROM wsh_serial_numbers

1892: LOOP
1893: l_detail_id := p_tbl_del_detail_purge_set(l_loop_index).delivery_detail_id;
1894:
1895: DELETE
1896: FROM wsh_serial_numbers
1897: WHERE delivery_detail_id = l_detail_id;
1898:
1899: IF SQL%FOUND THEN
1900: IF l_debug_on THEN

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

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