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_PROCESS_INTERFACED_PKG dependencies on WSH_DEL_DETAILS_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 1206: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;

1202: l_customer_id wsh_new_del_interface.customer_id%TYPE;
1203: l_org_id wsh_new_del_interface.organization_id%TYPE;
1204: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;
1205: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;
1206: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;
1207: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;
1208: l_det_org_id wsh_del_details_interface.organization_id%TYPE;
1209: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;
1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;

Line 1207: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;

1203: l_org_id wsh_new_del_interface.organization_id%TYPE;
1204: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;
1205: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;
1206: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;
1207: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;
1208: l_det_org_id wsh_del_details_interface.organization_id%TYPE;
1209: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;
1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1211: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

Line 1208: l_det_org_id wsh_del_details_interface.organization_id%TYPE;

1204: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;
1205: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;
1206: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;
1207: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;
1208: l_det_org_id wsh_del_details_interface.organization_id%TYPE;
1209: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;
1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1211: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1212: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

Line 1209: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;

1205: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;
1206: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;
1207: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;
1208: l_det_org_id wsh_del_details_interface.organization_id%TYPE;
1209: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;
1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1211: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1212: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1213: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

Line 1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;

1206: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;
1207: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;
1208: l_det_org_id wsh_del_details_interface.organization_id%TYPE;
1209: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;
1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1211: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1212: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1213: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1214: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;

Line 1211: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

1207: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;
1208: l_det_org_id wsh_del_details_interface.organization_id%TYPE;
1209: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;
1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1211: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1212: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1213: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1214: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;
1215: x_result BOOLEAN;

Line 1212: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

1208: l_det_org_id wsh_del_details_interface.organization_id%TYPE;
1209: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;
1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1211: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1212: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1213: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1214: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;
1215: x_result BOOLEAN;
1216: l_seg_array fnd_flex_ext.segmentarray;

Line 1213: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

1209: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;
1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1211: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1212: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1213: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1214: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;
1215: x_result BOOLEAN;
1216: l_seg_array fnd_flex_ext.segmentarray;
1217: l_detail_customer_name VARCHAR2(360);

Line 1214: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;

1210: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1211: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1212: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1213: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1214: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;
1215: x_result BOOLEAN;
1216: l_seg_array fnd_flex_ext.segmentarray;
1217: l_detail_customer_name VARCHAR2(360);
1218: l_dlvy_customer_name VARCHAR2(360);

Line 1222: l_ship_to_site_use_id wsh_del_details_interface.ship_to_site_use_id%TYPE;

1218: l_dlvy_customer_name VARCHAR2(360);
1219: l_op_unit_id NUMBER;
1220: l_line_op_unit_id NUMBER;
1221:
1222: l_ship_to_site_use_id wsh_del_details_interface.ship_to_site_use_id%TYPE;
1223: l_deliver_to_site_use_id wsh_del_details_interface.deliver_to_site_use_id%TYPE;
1224: l_dummy_site_use_id NUMBER;
1225: l_dummy VARCHAR2(10);
1226:

Line 1223: l_deliver_to_site_use_id wsh_del_details_interface.deliver_to_site_use_id%TYPE;

1219: l_op_unit_id NUMBER;
1220: l_line_op_unit_id NUMBER;
1221:
1222: l_ship_to_site_use_id wsh_del_details_interface.ship_to_site_use_id%TYPE;
1223: l_deliver_to_site_use_id wsh_del_details_interface.deliver_to_site_use_id%TYPE;
1224: l_dummy_site_use_id NUMBER;
1225: l_dummy VARCHAR2(10);
1226:
1227: -- TPW - Distributed changes

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 1938: UPDATE wsh_del_details_interface

1934: END IF;
1935:
1936: IF (l_dd_temp_status <> 'INVALID')
1937: THEN
1938: UPDATE wsh_del_details_interface
1939: SET inventory_item_id = l_inventory_item_id,
1940: customer_item_id = l_customer_item_id,
1941: organization_id = l_det_org_id,
1942: ship_from_location_id = l_ship_from_location_id,

Line 1960: interface_errors_rec.p_interface_table_name := 'WSH_DEL_DETAILS_INTERFACE';

1956:
1957: -- TPW - Distributed changes - added l_loc_temp_status status check
1958: IF (l_dd_temp_status = 'INVALID' or l_loc_temp_status = 'INVALID' )
1959: THEN
1960: interface_errors_rec.p_interface_table_name := 'WSH_DEL_DETAILS_INTERFACE';
1961: interface_errors_rec.p_interface_id := delivery_detail_rec.delivery_detail_interface_id;
1962: wsh_interface_validations_pkg.log_interface_errors (
1963: p_interface_errors_rec =>interface_errors_rec,
1964: p_api_name => 'wsh_delivery_details_inv.validate_lot_number',

Line 2157: DELETE wsh_del_details_interface

2153: END LOOP; -- End of FOR IDs_Rec IN IDs LOOP
2154:
2155: FOR detail_interface_ids_rec IN detail_interface_ids
2156: LOOP
2157: DELETE wsh_del_details_interface
2158: WHERE delivery_detail_interface_id = detail_interface_ids_rec.delivery_detail_interface_id
2159: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2160:
2161: --Added for bug 7615007

Line 2288: DELETE FROM wsh_del_details_interface

2284: END IF;
2285: --
2286: IF (p_del_det_interface_id_tbl.COUNT > 0) THEN
2287: FORALL i in p_del_det_interface_id_tbl.FIRST..p_del_det_interface_id_tbl.LAST
2288: DELETE FROM wsh_del_details_interface
2289: WHERE delivery_detail_interface_id = p_del_det_interface_id_tbl(i);
2290: --
2291: IF l_debug_on THEN
2292: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_del_details_interface');

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

2288: DELETE FROM wsh_del_details_interface
2289: WHERE delivery_detail_interface_id = p_del_det_interface_id_tbl(i);
2290: --
2291: IF l_debug_on THEN
2292: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_del_details_interface');
2293: END IF;
2294: --
2295: END IF;
2296: --