APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DEL_DETAILS_INTERFACE

Line 196: FROM wsh_del_details_interface wddi,

192: wddi.EARLIEST_PICKUP_DATE ,
193: wddi.LATEST_PICKUP_DATE ,
194: wddi.EARLIEST_DROPOFF_DATE ,
195: wddi.LATEST_DROPOFF_DATE
196: FROM wsh_del_details_interface wddi,
197: wsh_del_assgn_interface wdai
198: WHERE wddi.delivery_detail_id= nvl(l_detail_id, wddi.delivery_detail_id)
199: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
200: AND wdai.delivery_interface_id= l_dlvy_interface_id

Line 322: - This procedure is used to process the delivery details in the wsh_del_details_interface

318: x_del_detail_id - Delivery_Detail_ID of the detail created
319: - using Create_Shipment_Lines api
320: x_return_status - return status of API
321: DESCRIPTION :
322: - This procedure is used to process the delivery details in the wsh_del_details_interface
323: table.
324: - If the action is CREATE, then we take the interface record columns and call
325: the 'Create_Shipment_Lines' api.
326: - If the action is UPDATE, then we do the following:

Line 525: FROM wsh_del_assgn_interface wdai, wsh_del_details_interface wddi

521: l_validation_level NUMBER;
522: -- cursors
523: CURSOR detail_ids_cur IS
524: SELECT count(*), wdai.delivery_detail_id, wddi.container_flag
525: FROM wsh_del_assgn_interface wdai, wsh_del_details_interface wddi
526: WHERE wdai.delivery_interface_id = p_delivery_interface_id
527: AND wdai.delivery_detail_interface_id = wddi.delivery_detail_interface_id
528: AND WDAI.INTERFACE_ACTION_CODE = '94X_INBOUND'
529: AND WDDI.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 1217: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai

1213: l_index NUMBER;
1214: --Cursors
1215: CURSOR c_det_count_cur(p_detail_id NUMBER, p_dlvy_int_id NUMBER) IS
1216: SELECT COUNT(*)
1217: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai
1218: WHERE wddi.delivery_Detail_interface_id = wdai.delivery_detail_interface_id
1219: AND wdai.delivery_interface_id = p_dlvy_int_id
1220: AND wddi.delivery_detail_id=p_detail_id
1221: AND WDAI.INTERFACE_ACTION_CODE = '94X_INBOUND'

Line 1265: if more than one record exists in wsh_del_details_interface, then

1261: END IF;
1262:
1263: /* New Logic for splitting at supplier instance 945 inbound. kvenkate.
1264: For a given delivery_detail_id ,
1265: if more than one record exists in wsh_del_details_interface, then
1266: if those records have the same not null source_line_id, then do not split.
1267: if those records have distinct source_line_id, then split. */
1268:
1269: FOR del_det_int_rec IN del_det_int_cur(NULL, p_delivery_interface_id) LOOP

Line 2911: FROM wsh_del_details_interface

2907:
2908: IF(p_del_detail_interface_id IS NOT NULL) THEN
2909: l_entity_interface_id := p_del_detail_interface_id;
2910: SELECT delivery_detail_id INTO l_del_detail_id
2911: FROM wsh_del_details_interface
2912: WHERE delivery_detail_interface_id = p_del_detail_interface_id
2913: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2914: IF l_debug_on THEN
2915: wsh_debug_sv.log (l_module_name, 'Delivery Detail Id', l_del_detail_id);