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 1017: FROM wsh_new_del_interface

1013: IS
1014: SELECT name, organization_code, customer_number,
1015: intmed_ship_to_location_code, initial_pickup_location_code,
1016: ultimate_dropoff_location_code, customer_name
1017: FROM wsh_new_del_interface
1018: WHERE delivery_interface_id = p_delivery_interface_id
1019: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1020: --bug 3920178
1021: CURSOR c_loc_org_check(p_delivery_id NUMBER, p_org_id NUMBER) IS

Line 1077: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_id%TYPE;

1073: l_del_count NUMBER;
1074: l_dlvy_id NUMBER;
1075: l_d_temp_status VARCHAR2 (10) := ' ';
1076: l_dd_temp_status VARCHAR2 (10) := ' ';
1077: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_id%TYPE;
1078: l_customer_id wsh_new_del_interface.customer_id%TYPE;
1079: l_org_id wsh_new_del_interface.organization_id%TYPE;
1080: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;
1081: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;

Line 1078: l_customer_id wsh_new_del_interface.customer_id%TYPE;

1074: l_dlvy_id NUMBER;
1075: l_d_temp_status VARCHAR2 (10) := ' ';
1076: l_dd_temp_status VARCHAR2 (10) := ' ';
1077: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_id%TYPE;
1078: l_customer_id wsh_new_del_interface.customer_id%TYPE;
1079: l_org_id wsh_new_del_interface.organization_id%TYPE;
1080: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;
1081: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;
1082: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;

Line 1079: l_org_id wsh_new_del_interface.organization_id%TYPE;

1075: l_d_temp_status VARCHAR2 (10) := ' ';
1076: l_dd_temp_status VARCHAR2 (10) := ' ';
1077: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_id%TYPE;
1078: l_customer_id wsh_new_del_interface.customer_id%TYPE;
1079: l_org_id wsh_new_del_interface.organization_id%TYPE;
1080: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;
1081: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;
1082: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;
1083: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;

Line 1080: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;

1076: l_dd_temp_status VARCHAR2 (10) := ' ';
1077: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_id%TYPE;
1078: l_customer_id wsh_new_del_interface.customer_id%TYPE;
1079: l_org_id wsh_new_del_interface.organization_id%TYPE;
1080: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;
1081: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;
1082: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;
1083: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;
1084: l_det_org_id wsh_del_details_interface.organization_id%TYPE;

Line 1081: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;

1077: l_intmed_ship_to_location_id wsh_new_del_interface.intmed_ship_to_location_id%TYPE;
1078: l_customer_id wsh_new_del_interface.customer_id%TYPE;
1079: l_org_id wsh_new_del_interface.organization_id%TYPE;
1080: l_initial_pickup_location_id wsh_new_del_interface.initial_pickup_location_id%TYPE;
1081: l_ultimate_dropoff_location_id wsh_new_del_interface.ultimate_dropoff_location_id%TYPE;
1082: l_inventory_item_id wsh_del_details_interface.inventory_item_id%TYPE;
1083: l_customer_item_id wsh_del_details_interface.customer_item_number%TYPE;
1084: l_det_org_id wsh_del_details_interface.organization_id%TYPE;
1085: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;

Line 1134: FROM wsh_new_del_interface

1130: END IF;
1131:
1132: SELECT COUNT (delivery_interface_id)
1133: INTO l_del_count
1134: FROM wsh_new_del_interface
1135: WHERE delivery_interface_id = p_delivery_interface_id
1136: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1137:
1138: IF l_debug_on THEN

Line 1343: UPDATE wsh_new_del_interface

1339: END IF;
1340:
1341: IF (l_d_temp_status <> 'INVALID')
1342: THEN
1343: UPDATE wsh_new_del_interface
1344: SET delivery_id = decode(p_document_type, 'SA',l_dlvy_id,delivery_id),
1345: customer_id = l_customer_id,
1346: organization_id = l_org_id,
1347: intmed_ship_to_location_id = l_intmed_ship_to_location_id,

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

1355: END IF;
1356:
1357: IF (l_d_temp_status = 'INVALID')
1358: THEN
1359: interface_errors_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
1360: interface_errors_rec.p_interface_id := p_delivery_interface_id;
1361: wsh_interface_validations_pkg.log_interface_errors (
1362: p_interface_errors_rec =>interface_errors_rec,
1363: p_api_name =>'WSH_EXTERNAL_INTERFACE_SV.Validate_Ship_To',

Line 1764: FROM wsh_new_del_interface

1760: END IF;
1761:
1762: SELECT COUNT (*)
1763: INTO l_del_count
1764: FROM wsh_new_del_interface
1765: WHERE delivery_interface_id = p_delivery_interface_id
1766: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1767:
1768: IF (l_del_count <> 0)

Line 1800: DELETE wsh_new_del_interface

1796: WHERE delivery_detail_interface_id = detail_interface_ids_rec.delivery_detail_interface_id
1797: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1798: END LOOP; -- End of FOR Details_Interface_IDs_Rec ...
1799:
1800: DELETE wsh_new_del_interface
1801: WHERE delivery_interface_id = p_delivery_interface_id
1802: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1803:
1804: x_return_status := wsh_util_core.g_ret_sts_success;