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_NEW_DEL_INTERFACE

Line 1106: FROM wsh_new_del_interface

1102: -- TPW - Distributed changes
1103: ship_to_customer_name,
1104: ship_to_address1, ship_to_address2, ship_to_address3, ship_to_address4,
1105: ship_to_city, ship_to_state, ship_to_postal_code, ship_to_country
1106: FROM wsh_new_del_interface
1107: WHERE delivery_interface_id = p_delivery_interface_id
1108: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1109: --bug 3920178
1110: CURSOR c_loc_org_check(p_delivery_id NUMBER, p_org_id NUMBER) IS

Line 1201: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_id%TYPE;

1197: l_d_temp_status VARCHAR2 (10) := ' ';
1198: l_dd_temp_status VARCHAR2 (10) := ' ';
1199: -- TPW - Distributed changes - New Variable added
1200: l_loc_temp_status VARCHAR2 (10) := ' ';
1201: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_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;

Line 1202: l_customer_id wsh_new_del_interface.customer_id%TYPE;

1198: l_dd_temp_status VARCHAR2 (10) := ' ';
1199: -- TPW - Distributed changes - New Variable added
1200: l_loc_temp_status VARCHAR2 (10) := ' ';
1201: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_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;

Line 1203: l_org_id wsh_new_del_interface.organization_id%TYPE;

1199: -- TPW - Distributed changes - New Variable added
1200: l_loc_temp_status VARCHAR2 (10) := ' ';
1201: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_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;

Line 1204: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;

1200: l_loc_temp_status VARCHAR2 (10) := ' ';
1201: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_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;

Line 1205: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;

1201: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_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;

Line 1232: l_ou_org_id wsh_new_del_interface.organization_id%TYPE;

1228: l_ship_to_cust_id number;
1229: l_return_status varchar2(1);
1230: l_warehouse_type varchar2(10);
1231: l_locator_id number;
1232: l_ou_org_id wsh_new_del_interface.organization_id%TYPE;
1233:
1234: invalid_delivery_int_id EXCEPTION;
1235: invalid_delivery_name EXCEPTION;
1236: invalid_customer_name EXCEPTION;

Line 1269: FROM wsh_new_del_interface

1265: END IF;
1266:
1267: SELECT COUNT (delivery_interface_id)
1268: INTO l_del_count
1269: FROM wsh_new_del_interface
1270: WHERE delivery_interface_id = p_delivery_interface_id
1271: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1272:
1273: IF l_debug_on THEN

Line 1610: UPDATE wsh_new_del_interface

1606: END IF;
1607:
1608: IF (l_d_temp_status <> 'INVALID')
1609: THEN
1610: UPDATE wsh_new_del_interface
1611: SET delivery_id = decode(p_document_type, 'SA',l_dlvy_id,delivery_id),
1612: customer_id = l_customer_id,
1613: organization_id = l_org_id,
1614: intmed_ship_to_location_id = l_intmed_ship_to_location_id,

Line 1629: interface_errors_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';

1625: END IF;
1626:
1627: IF (l_d_temp_status = 'INVALID')
1628: THEN
1629: interface_errors_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
1630: interface_errors_rec.p_interface_id := p_delivery_interface_id;
1631: wsh_interface_validations_pkg.log_interface_errors (
1632: p_interface_errors_rec =>interface_errors_rec,
1633: p_api_name =>'WSH_EXTERNAL_INTERFACE_SV.Validate_Ship_To',

Line 2111: FROM wsh_new_del_interface

2107: END IF;
2108:
2109: SELECT COUNT (*)
2110: INTO l_del_count
2111: FROM wsh_new_del_interface
2112: WHERE delivery_interface_id = p_delivery_interface_id
2113: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2114:
2115: IF (l_del_count <> 0)

Line 2171: DELETE wsh_new_del_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:
2171: DELETE wsh_new_del_interface
2172: WHERE delivery_interface_id = p_delivery_interface_id
2173: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2174:
2175: --Added for bug 7615007

Line 2299: DELETE FROM wsh_new_del_interface

2295: END IF;
2296: --
2297: IF (p_del_interface_id_tbl.COUNT > 0) THEN
2298: FORALL i in p_del_interface_id_tbl.FIRST..p_del_interface_id_tbl.LAST
2299: DELETE FROM wsh_new_del_interface
2300: WHERE delivery_interface_id = p_del_interface_id_tbl(i);
2301: --
2302: IF l_debug_on THEN
2303: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_new_del_interface');

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

2299: DELETE FROM wsh_new_del_interface
2300: WHERE delivery_interface_id = p_del_interface_id_tbl(i);
2301: --
2302: IF l_debug_on THEN
2303: wsh_debug_sv.logmsg ( l_module_name, 'Deleted '||SQL%ROWCOUNT||' Records from wsh_new_del_interface');
2304: END IF;
2305: --
2306: END IF;
2307: --