APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_DEL_ASSGN_INTERFACE

Line 1143: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai

1139: wddi.intmed_ship_to_location_code, wddi.delivery_detail_interface_id,
1140: wddi.customer_name, wddi.container_flag,
1141: -- TPW - Distributed changes
1142: wddi.locator_code
1143: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai
1144: WHERE wdai.delivery_interface_id = p_delivery_interface_id
1145: AND wddi.delivery_detail_interface_id =
1146: wdai.delivery_detail_interface_id
1147: AND wddi.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 1518: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai

1514:
1515: BEGIN
1516: SELECT DISTINCT customer_name
1517: INTO l_detail_customer_name
1518: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai
1519: WHERE wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
1520: AND wddi.customer_name IS NOT NULL
1521: AND wdai.delivery_interface_id = p_delivery_interface_id
1522: AND wddi.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 2074: FROM wsh_del_assgn_interface

2070:
2071: CURSOR detail_interface_ids
2072: IS
2073: SELECT delivery_detail_interface_id, del_assgn_interface_id
2074: FROM wsh_del_assgn_interface
2075: WHERE delivery_interface_id = p_delivery_interface_id
2076: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2077:
2078: CURSOR ids

Line 2166: DELETE wsh_del_assgn_interface

2162: DELETE wsh_freight_costs_interface
2163: WHERE delivery_detail_interface_id = detail_interface_ids_rec.delivery_detail_interface_id
2164: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2165:
2166: DELETE wsh_del_assgn_interface
2167: WHERE delivery_detail_interface_id = detail_interface_ids_rec.delivery_detail_interface_id
2168: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2169: END LOOP; -- End of FOR Details_Interface_IDs_Rec ...
2170:

Line 2277: DELETE FROM wsh_del_assgn_interface

2273: END IF;
2274: --
2275: IF (p_del_assgn_interface_id_tbl.COUNT > 0) THEN
2276: FORALL i in p_del_assgn_interface_id_tbl.FIRST..p_del_assgn_interface_id_tbl.LAST
2277: DELETE FROM wsh_del_assgn_interface
2278: WHERE del_assgn_interface_id = p_del_assgn_interface_id_tbl(i);
2279: --
2280: IF l_debug_on THEN
2281: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_del_assgn_interface');

Line 2281: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_del_assgn_interface');

2277: DELETE FROM wsh_del_assgn_interface
2278: WHERE del_assgn_interface_id = p_del_assgn_interface_id_tbl(i);
2279: --
2280: IF l_debug_on THEN
2281: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_del_assgn_interface');
2282: END IF;
2283: --
2284: END IF;
2285: --