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 1052: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai

1048: wddi.deliver_to_location_code, wddi.customer_number, wddi.subinventory,
1049: wddi.revision, wddi.lot_number, wddi.locator_id,
1050: wddi.intmed_ship_to_location_code, wddi.delivery_detail_interface_id,
1051: wddi.customer_name, wddi.container_flag
1052: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai
1053: WHERE wdai.delivery_interface_id = p_delivery_interface_id
1054: AND wddi.delivery_detail_interface_id =
1055: wdai.delivery_detail_interface_id
1056: AND wddi.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 1082: l_inventory_item_id wsh_del_details_interface.inventory_item_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;
1086: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;

Line 1083: l_customer_item_id wsh_del_details_interface.customer_item_number%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;
1086: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1087: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

Line 1084: l_det_org_id wsh_del_details_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;
1086: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1087: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1088: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

Line 1085: l_ship_from_location_id wsh_del_details_interface.ship_from_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;
1086: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1087: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1088: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1089: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

Line 1086: l_ship_to_location_id wsh_del_details_interface.ship_to_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;
1086: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1087: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1088: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1089: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1090: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;

Line 1087: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_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;
1086: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1087: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1088: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1089: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1090: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;
1091: x_result BOOLEAN;

Line 1088: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%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;
1086: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1087: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1088: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1089: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1090: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;
1091: x_result BOOLEAN;
1092: l_seg_array fnd_flex_ext.segmentarray;

Line 1089: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;

1085: l_ship_from_location_id wsh_del_details_interface.ship_from_location_id%TYPE;
1086: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1087: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1088: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1089: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1090: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;
1091: x_result BOOLEAN;
1092: l_seg_array fnd_flex_ext.segmentarray;
1093: l_detail_customer_name VARCHAR2(360);

Line 1090: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;

1086: l_ship_to_location_id wsh_del_details_interface.ship_to_location_id%TYPE;
1087: l_det_intmed_shipto wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1088: l_deliver_to_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1089: l_intpickup_location_id wsh_del_details_interface.intmed_ship_to_location_id%TYPE;
1090: l_det_customer_id wsh_del_details_interface.customer_number%TYPE;
1091: x_result BOOLEAN;
1092: l_seg_array fnd_flex_ext.segmentarray;
1093: l_detail_customer_name VARCHAR2(360);
1094: l_dlvy_customer_name VARCHAR2(360);

Line 1098: l_ship_to_site_use_id wsh_del_details_interface.ship_to_site_use_id%TYPE;

1094: l_dlvy_customer_name VARCHAR2(360);
1095: l_op_unit_id NUMBER;
1096: l_line_op_unit_id NUMBER;
1097:
1098: l_ship_to_site_use_id wsh_del_details_interface.ship_to_site_use_id%TYPE;
1099: l_deliver_to_site_use_id wsh_del_details_interface.deliver_to_site_use_id%TYPE;
1100: l_dummy_site_use_id NUMBER;
1101: l_dummy VARCHAR2(10);
1102:

Line 1099: l_deliver_to_site_use_id wsh_del_details_interface.deliver_to_site_use_id%TYPE;

1095: l_op_unit_id NUMBER;
1096: l_line_op_unit_id NUMBER;
1097:
1098: l_ship_to_site_use_id wsh_del_details_interface.ship_to_site_use_id%TYPE;
1099: l_deliver_to_site_use_id wsh_del_details_interface.deliver_to_site_use_id%TYPE;
1100: l_dummy_site_use_id NUMBER;
1101: l_dummy VARCHAR2(10);
1102:
1103: invalid_delivery_int_id EXCEPTION;

Line 1221: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai

1217:
1218: BEGIN
1219: SELECT DISTINCT customer_name
1220: INTO l_detail_customer_name
1221: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai
1222: WHERE wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
1223: AND wddi.customer_name IS NOT NULL
1224: AND wdai.delivery_interface_id = p_delivery_interface_id
1225: AND wddi.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 1634: UPDATE wsh_del_details_interface

1630: END IF;
1631:
1632: IF (l_dd_temp_status <> 'INVALID')
1633: THEN
1634: UPDATE wsh_del_details_interface
1635: SET inventory_item_id = l_inventory_item_id,
1636: customer_item_id = l_customer_item_id,
1637: organization_id = l_det_org_id,
1638: ship_from_location_id = l_ship_from_location_id,

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

1649: END IF;
1650:
1651: IF (l_dd_temp_status = 'INVALID')
1652: THEN
1653: interface_errors_rec.p_interface_table_name := 'WSH_DEL_DETAILS_INTERFACE';
1654: interface_errors_rec.p_interface_id := delivery_detail_rec.delivery_detail_interface_id;
1655: wsh_interface_validations_pkg.log_interface_errors (
1656: p_interface_errors_rec =>interface_errors_rec,
1657: p_api_name => 'wsh_delivery_details_inv.validate_lot_number',

Line 1791: DELETE wsh_del_details_interface

1787: END LOOP; -- End of FOR IDs_Rec IN IDs LOOP
1788:
1789: FOR detail_interface_ids_rec IN detail_interface_ids
1790: LOOP
1791: DELETE wsh_del_details_interface
1792: WHERE delivery_detail_interface_id = detail_interface_ids_rec.delivery_detail_interface_id
1793: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1794:
1795: DELETE wsh_del_assgn_interface