[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*) into l_exists
FROM wsh_transactions_history
WHERE document_number = p_delivery_rec.document_number
AND document_type = 'SA'
AND document_direction = 'I';
wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');
INSERT INTO WSH_NEW_DEL_INTERFACE(
DELIVERY_INTERFACE_ID,
NAME,
DESCRIPTION,
INITIAL_PICKUP_DATE,
ULTIMATE_DROPOFF_DATE,
FREIGHT_TERMS_CODE,
GROSS_WEIGHT,
NET_WEIGHT,
WEIGHT_UOM_CODE,
NUMBER_OF_LPN,
VOLUME,
VOLUME_UOM_CODE,
SHIPPING_MARKS,
FOB_CODE,
SHIP_METHOD_CODE,
ORGANIZATION_CODE,
LOADING_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
WAYBILL,
carrier_code,
SERVICE_LEVEL,
MODE_OF_TRANSPORT,
wv_frozen_flag,
SHIPMENT_DIRECTION,
DELIVERED_DATE,
CUSTOMER_NAME,
PLANNED_FLAG,
STATUS_CODE,
INTERFACE_ACTION_CODE,
DELIVERY_TYPE,
INITIAL_PICKUP_LOCATION_CODE,
SHIP_TO_CUSTOMER_NAME,
SHIP_TO_ADDRESS1,
SHIP_TO_ADDRESS2,
SHIP_TO_ADDRESS3,
SHIP_TO_ADDRESS4,
SHIP_TO_CITY,
SHIP_TO_STATE,
SHIP_TO_COUNTRY,
SHIP_TO_POSTAL_CODE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
program_application_id,
program_id,
program_update_date,
request_id
)
VALUES(
wsh_new_del_interface_s.nextval,
p_delivery_rec.name,
p_delivery_rec.DESCRIPTION,
p_delivery_rec.INITIAL_PICKUP_DATE,
p_delivery_rec.ULTIMATE_DROPOFF_DATE,
p_delivery_rec.FREIGHT_TERMS_CODE,
p_delivery_rec.GROSS_WEIGHT,
p_delivery_rec.NET_WEIGHT,
p_delivery_rec.WEIGHT_UOM_CODE,
p_delivery_rec.NUMBER_OF_LPN,
p_delivery_rec.VOLUME,
p_delivery_rec.VOLUME_UOM_CODE,
p_delivery_rec.SHIPPING_MARKS,
p_delivery_rec.FOB_CODE,
p_delivery_rec.SHIP_METHOD_CODE,
p_delivery_rec.ORGANIZATION_CODE,
p_delivery_rec.LOADING_SEQUENCE,
p_delivery_rec.ATTRIBUTE_CATEGORY,
p_delivery_rec.ATTRIBUTE1,
p_delivery_rec.ATTRIBUTE2,
p_delivery_rec.ATTRIBUTE3,
p_delivery_rec.ATTRIBUTE4,
p_delivery_rec.ATTRIBUTE5,
p_delivery_rec.ATTRIBUTE6,
p_delivery_rec.ATTRIBUTE7,
p_delivery_rec.ATTRIBUTE8,
p_delivery_rec.ATTRIBUTE9,
p_delivery_rec.ATTRIBUTE10,
p_delivery_rec.ATTRIBUTE11,
p_delivery_rec.ATTRIBUTE12,
p_delivery_rec.ATTRIBUTE13,
p_delivery_rec.ATTRIBUTE14,
p_delivery_rec.ATTRIBUTE15,
p_delivery_rec.WAYBILL,
p_delivery_rec.carrier_code,
p_delivery_rec.SERVICE_LEVEL,
p_delivery_rec.MODE_OF_TRANSPORT,
p_delivery_rec.wv_frozen_flag,
p_delivery_rec.shipment_direction,
p_delivery_rec.DELIVERED_DATE,
p_delivery_rec.CUSTOMER_NAME,
'N',
'OP',
G_INTERFACE_ACTION_CODE,
'STANDARD',
p_delivery_rec.INITIAL_PICKUP_LOCATION_CODE,
p_delivery_rec.SHIP_TO_CUSTOMER_NAME,
p_delivery_rec.SHIP_TO_ADDRESS1,
p_delivery_rec.SHIP_TO_ADDRESS2,
p_delivery_rec.SHIP_TO_ADDRESS3,
p_delivery_rec.SHIP_TO_ADDRESS4,
p_delivery_rec.SHIP_TO_CITY,
p_delivery_rec.SHIP_TO_STATE,
p_delivery_rec.SHIP_TO_COUNTRY,
p_delivery_rec.SHIP_TO_POSTAL_CODE,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
FND_GLOBAL.LOGIN_ID,
FND_GLOBAL.PROG_APPL_ID,
FND_GLOBAL.Conc_Program_Id,
sysdate,
FND_GLOBAL.Conc_Request_Id
)
RETURNING DELIVERY_INTERFACE_ID into l_delivery_interface_id;
WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_NEW_DEL_INTERFACE',l_ins_rows);
wsh_debug_sv.logmsg(l_module_name, 'Inserting WSH_FREIGHT_COSTS_INTERFACE for the delivery');
INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
FREIGHT_COST_INTERFACE_ID,
INTERFACE_ACTION_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
DELIVERY_INTERFACE_ID,
DELIVERY_DETAIL_INTERFACE_ID,
FREIGHT_COST_TYPE_CODE,
UNIT_AMOUNT,
CURRENCY_CODE)
VALUES(
wsh_freight_costs_interface_s.nextval,
G_INTERFACE_ACTION_CODE,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE_CATEGORY,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE1,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE2,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE3,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE4,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE5,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE6,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE7,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE8,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE9,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE10,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE11,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE12,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE13,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE14,
p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE15,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
l_delivery_interface_id,
NULL,
p_delivery_rec.delivery_freight_tab(k).FREIGHT_COST_TYPE_CODE,
p_delivery_rec.delivery_freight_tab(k).UNIT_AMOUNT,
p_delivery_rec.delivery_freight_tab(k).CURRENCY_CODE
);
wsh_debug_sv.logmsg(l_module_name, 'Inserting into WDDI and WFCI(delivery details freight info))');
wsh_debug_sv.logmsg(l_module_name, 'Inserting Rec'||i||' into WSH_DEL_DETAILS_INTERFACE (validating source_line_id)');
INSERT INTO WSH_DEL_DETAILS_INTERFACE(
DELIVERY_DETAIL_INTERFACE_ID,
ITEM_NUMBER,
REQUESTED_QUANTITY,
REQUESTED_QUANTITY_UOM,
ITEM_DESCRIPTION,
REVISION,
SHIPPED_QUANTITY,
VOLUME,
VOLUME_UOM_CODE,
GROSS_WEIGHT,
NET_WEIGHT,
WEIGHT_UOM_CODE,
DELIVERY_DETAIL_ID,
SOURCE_LINE_ID,
LOAD_SEQ_NUMBER,
SUBINVENTORY,
LOT_NUMBER,
PREFERRED_GRADE,
SERIAL_NUMBER,
TO_SERIAL_NUMBER,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
SOURCE_HEADER_NUMBER,
LINE_DIRECTION,
WV_FROZEN_FLAG,
CYCLE_COUNT_QUANTITY,
LOCATOR_CODE,
SOURCE_CODE,
CONTAINER_FLAG,
INTERFACE_ACTION_CODE,
ORGANIZATION_CODE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID
)
VALUES(
wsh_del_details_interface_s.nextval,
p_delivery_rec.delivery_details_tab(i).ITEM_NUMBER,
p_delivery_rec.delivery_details_tab(i).REQUESTED_QUANTITY,
p_delivery_rec.delivery_details_tab(i).REQUESTED_QUANTITY_UOM,
p_delivery_rec.delivery_details_tab(i).ITEM_DESCRIPTION,
p_delivery_rec.delivery_details_tab(i).REVISION,
p_delivery_rec.delivery_details_tab(i).SHIPPED_QUANTITY,
p_delivery_rec.delivery_details_tab(i).VOLUME,
p_delivery_rec.delivery_details_tab(i).VOLUME_UOM_CODE,
p_delivery_rec.delivery_details_tab(i).GROSS_WEIGHT,
p_delivery_rec.delivery_details_tab(i).NET_WEIGHT,
p_delivery_rec.delivery_details_tab(i).WEIGHT_UOM_CODE,
p_delivery_rec.delivery_details_tab(i).delivery_detail_number,
p_delivery_rec.delivery_details_tab(i).source_line_id,
p_delivery_rec.delivery_details_tab(i).LOAD_SEQ_NUMBER,
p_delivery_rec.delivery_details_tab(i).SUBINVENTORY,
p_delivery_rec.delivery_details_tab(i).LOT_NUMBER,
p_delivery_rec.delivery_details_tab(i).PREFERRED_GRADE,
p_delivery_rec.delivery_details_tab(i).SERIAL_NUMBER,
p_delivery_rec.delivery_details_tab(i).TO_SERIAL_NUMBER,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE_CATEGORY,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE1,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE2,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE3,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE4,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE5,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE6,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE7,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE8,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE9,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE10,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE11,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE12,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE13,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE14,
p_delivery_rec.delivery_details_tab(i).ATTRIBUTE15,
p_delivery_rec.delivery_details_tab(i).SOURCE_HEADER_NUMBER,
p_delivery_rec.delivery_details_tab(i).line_direction,
p_delivery_rec.delivery_details_tab(i).WV_FROZEN_FLAG,
p_delivery_rec.delivery_details_tab(i).CYCLE_COUNT_QUANTITY,
p_delivery_rec.delivery_details_tab(i).LOCATOR_CODE,
'WSH',
'N',
G_INTERFACE_ACTION_CODE,
p_delivery_rec.ORGANIZATION_CODE,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
FND_GLOBAL.LOGIN_ID,
FND_GLOBAL.PROG_APPL_ID,
FND_GLOBAL.Conc_Program_Id,
sysdate,
FND_GLOBAL.Conc_Request_Id)
RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
wsh_debug_sv.logmsg(l_module_name, 'Inserting into WFCI for delivery detail rec ' || i);
INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
FREIGHT_COST_INTERFACE_ID,
INTERFACE_ACTION_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
DELIVERY_INTERFACE_ID,
DELIVERY_DETAIL_INTERFACE_ID,
FREIGHT_COST_TYPE_CODE,
UNIT_AMOUNT,
CURRENCY_CODE)
VALUES(
wsh_freight_costs_interface_s.nextval,
G_INTERFACE_ACTION_CODE,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE_CATEGORY,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE1,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE2,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE3,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE4,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE5,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE6,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE7,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE8,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE9,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE10,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE11,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE12,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE13,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE14,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE15,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
NULL,
l_del_detail_interface_id,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).FREIGHT_COST_TYPE_CODE,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).UNIT_AMOUNT,
p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).CURRENCY_CODE
);
wsh_debug_sv.logmsg(l_module_name, 'Inserting Master Container records into WDDI');
INSERT INTO WSH_DEL_DETAILS_INTERFACE(
DELIVERY_DETAIL_INTERFACE_ID,
CONTAINER_NAME,
SEAL_CODE,
ITEM_NUMBER,
ITEM_DESCRIPTION,
DELIVERY_DETAIL_ID,
GROSS_WEIGHT,
NET_WEIGHT,
WEIGHT_UOM_CODE,
VOLUME,
VOLUME_UOM_CODE,
TRACKING_NUMBER,
SHIPPING_INSTRUCTIONS,
PACKING_INSTRUCTIONS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
WV_FROZEN_FLAG,
FILLED_VOLUME,
FILL_PERCENT,
SOURCE_CODE,
CONTAINER_FLAG,
INTERFACE_ACTION_CODE,
LINE_DIRECTION,
SOURCE_LINE_ID,
ORGANIZATION_CODE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY
)
VALUES(
wsh_del_details_interface_s.nextval,
p_delivery_rec.container_tab(i).CONTAINER_NAME,
p_delivery_rec.container_tab(i).SEAL_CODE,
p_delivery_rec.container_tab(i).ITEM_NUMBER,
p_delivery_rec.container_tab(i).ITEM_DESCRIPTION,
p_delivery_rec.container_tab(i).DELIVERY_DETAIL_NUMBER,
p_delivery_rec.container_tab(i).GROSS_WEIGHT,
p_delivery_rec.container_tab(i).NET_WEIGHT,
p_delivery_rec.container_tab(i).WEIGHT_UOM_CODE,
p_delivery_rec.container_tab(i).VOLUME,
p_delivery_rec.container_tab(i).VOLUME_UOM_CODE,
p_delivery_rec.container_tab(i).TRACKING_NUMBER,
p_delivery_rec.container_tab(i).SHIPPING_INSTRUCTIONS,
p_delivery_rec.container_tab(i).PACKING_INSTRUCTIONS,
p_delivery_rec.container_tab(i).ATTRIBUTE_CATEGORY,
p_delivery_rec.container_tab(i).ATTRIBUTE1,
p_delivery_rec.container_tab(i).ATTRIBUTE2,
p_delivery_rec.container_tab(i).ATTRIBUTE3,
p_delivery_rec.container_tab(i).ATTRIBUTE4,
p_delivery_rec.container_tab(i).ATTRIBUTE5,
p_delivery_rec.container_tab(i).ATTRIBUTE6,
p_delivery_rec.container_tab(i).ATTRIBUTE7,
p_delivery_rec.container_tab(i).ATTRIBUTE8,
p_delivery_rec.container_tab(i).ATTRIBUTE9,
p_delivery_rec.container_tab(i).ATTRIBUTE10,
p_delivery_rec.container_tab(i).ATTRIBUTE11,
p_delivery_rec.container_tab(i).ATTRIBUTE12,
p_delivery_rec.container_tab(i).ATTRIBUTE13,
p_delivery_rec.container_tab(i).ATTRIBUTE14,
p_delivery_rec.container_tab(i).ATTRIBUTE15,
p_delivery_rec.container_tab(i).WV_FROZEN_FLAG,
p_delivery_rec.container_tab(i).FILLED_VOLUME,
p_delivery_rec.container_tab(i).FILL_PERCENT,
'WSH',
'Y',
G_INTERFACE_ACTION_CODE,
p_delivery_rec.delivery_details_tab(i).line_direction,
p_delivery_rec.container_tab(i).DELIVERY_DETAIL_NUMBER,
p_delivery_rec.ORGANIZATION_CODE,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID)
RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
wsh_debug_sv.logmsg(l_module_name, 'Inserting Master Container Freight records into WFCI');
INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
FREIGHT_COST_INTERFACE_ID,
INTERFACE_ACTION_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
DELIVERY_INTERFACE_ID,
DELIVERY_DETAIL_INTERFACE_ID,
FREIGHT_COST_TYPE_CODE,
UNIT_AMOUNT,
CURRENCY_CODE)
VALUES(
wsh_freight_costs_interface_s.nextval,
G_INTERFACE_ACTION_CODE,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE_CATEGORY,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE1,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE2,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE3,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE4,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE5,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE6,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE7,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE8,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE9,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE10,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE11,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE12,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE13,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE14,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE15,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
NULL,
l_del_detail_interface_id,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).FREIGHT_COST_TYPE_CODE,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).UNIT_AMOUNT,
p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).CURRENCY_CODE
);
wsh_debug_sv.logmsg(l_module_name, 'Inserting Inner Container records into WDDI');
INSERT INTO WSH_DEL_DETAILS_INTERFACE(
DELIVERY_DETAIL_INTERFACE_ID,
CONTAINER_NAME,
SEAL_CODE,
ITEM_NUMBER,
ITEM_DESCRIPTION,
DELIVERY_DETAIL_ID,
GROSS_WEIGHT,
NET_WEIGHT,
WEIGHT_UOM_CODE,
VOLUME,
VOLUME_UOM_CODE,
TRACKING_NUMBER,
SHIPPING_INSTRUCTIONS,
PACKING_INSTRUCTIONS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
WV_FROZEN_FLAG,
FILLED_VOLUME,
FILL_PERCENT,
SOURCE_CODE,
CONTAINER_FLAG,
INTERFACE_ACTION_CODE,
LINE_DIRECTION,
SOURCE_LINE_ID,
ORGANIZATION_CODE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY
)
VALUES(
wsh_del_details_interface_s.nextval,
p_delivery_rec.container_tab(i).container_tab(k).CONTAINER_NAME,
p_delivery_rec.container_tab(i).container_tab(k).SEAL_CODE,
p_delivery_rec.container_tab(i).container_tab(k).ITEM_NUMBER,
p_delivery_rec.container_tab(i).container_tab(k).ITEM_DESCRIPTION,
p_delivery_rec.container_tab(i).container_tab(k).DELIVERY_DETAIL_NUMBER,
p_delivery_rec.container_tab(i).container_tab(k).GROSS_WEIGHT,
p_delivery_rec.container_tab(i).container_tab(k).NET_WEIGHT,
p_delivery_rec.container_tab(i).container_tab(k).WEIGHT_UOM_CODE,
p_delivery_rec.container_tab(i).container_tab(k).VOLUME,
p_delivery_rec.container_tab(i).container_tab(k).VOLUME_UOM_CODE,
p_delivery_rec.container_tab(i).container_tab(k).TRACKING_NUMBER,
p_delivery_rec.container_tab(i).container_tab(k).SHIPPING_INSTRUCTIONS,
p_delivery_rec.container_tab(i).container_tab(k).PACKING_INSTRUCTIONS,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE_CATEGORY,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE1,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE2,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE3,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE4,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE5,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE6,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE7,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE8,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE9,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE10,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE11,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE12,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE13,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE14,
p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE15,
p_delivery_rec.container_tab(i).container_tab(k).WV_FROZEN_FLAG,
p_delivery_rec.container_tab(i).container_tab(k).FILLED_VOLUME,
p_delivery_rec.container_tab(i).container_tab(k).FILL_PERCENT,
'WSH',
'Y',
G_INTERFACE_ACTION_CODE,
p_delivery_rec.delivery_details_tab(i).line_direction,
p_delivery_rec.container_tab(i).container_tab(k).DELIVERY_DETAIL_NUMBER,
p_delivery_rec.ORGANIZATION_CODE,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID)
RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
wsh_debug_sv.logmsg(l_module_name, 'Inserting Inner Container Freight records into WFCI');
INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
FREIGHT_COST_INTERFACE_ID,
INTERFACE_ACTION_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
DELIVERY_INTERFACE_ID,
DELIVERY_DETAIL_INTERFACE_ID,
FREIGHT_COST_TYPE_CODE,
UNIT_AMOUNT,
CURRENCY_CODE)
VALUES(
wsh_freight_costs_interface_s.nextval,
G_INTERFACE_ACTION_CODE,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE_CATEGORY,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE1,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE2,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE3,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE4,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE5,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE6,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE7,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE8,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE9,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE10,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE11,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE12,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE13,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE14,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE15,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
NULL,
l_del_detail_interface_id,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).FREIGHT_COST_TYPE_CODE,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).UNIT_AMOUNT,
p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).CURRENCY_CODE
);
wsh_debug_sv.log(l_module_name, 'Inserting Records into WSH_DEL_ASSGN_INTERFACE.Number of Records',l_del_assgn_cnt);
INSERT INTO WSH_DEL_ASSGN_INTERFACE(
DEL_ASSGN_INTERFACE_ID,
INTERFACE_ACTION_CODE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
DELIVERY_INTERFACE_ID ,
DELIVERY_DETAIL_INTERFACE_ID ,
DELIVERY_DETAIL_ID,
PARENT_DELIVERY_DETAIL_ID)
VALUES(
wsh_del_assgn_interface_s.nextval,
G_INTERFACE_ACTION_CODE,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
l_WDAI_DEL_INTERFACE_ID(i),
l_WDAI_DEL_DET_INTERFACE_ID(i),
l_WDAI_DEL_DETAIL_ID(i),
l_WDAI_PARENT_DEL_DETAIL_ID(i));
INSERT INTO WSH_DEL_ASSGN_INTERFACE(
DEL_ASSGN_INTERFACE_ID,
INTERFACE_ACTION_CODE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
DELIVERY_INTERFACE_ID ,
DELIVERY_DETAIL_INTERFACE_ID ,
DELIVERY_DETAIL_ID,
PARENT_DELIVERY_DETAIL_ID)
VALUES(
wsh_del_assgn_interface_s.nextval,
G_INTERFACE_ACTION_CODE,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
l_WDAI_DEL_INTERFACE_ID(i),
l_WDAI_DEL_DET_INTERFACE_ID(i),
l_WDAI_DEL_DETAIL_ID(i),
l_WDAI_PARENT_DEL_DETAIL_ID(i));
INSERT INTO wsh_transactions_history (
TRANSACTION_ID,
DOCUMENT_TYPE,
DOCUMENT_NUMBER,
DOCUMENT_DIRECTION,
TRANSACTION_STATUS,
ACTION_TYPE,
ENTITY_NUMBER,
ENTITY_TYPE,
TRADING_PARTNER_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE)
VALUES(
wsh_transaction_s.nextval,
'SA',
p_delivery_rec.DOCUMENT_NUMBER,
'I',
'AP',
'A',
l_delivery_interface_id,
'DLVY_INT',
-1,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
FND_GLOBAL.LOGIN_ID,
FND_GLOBAL.Conc_Request_Id,
FND_GLOBAL.PROG_APPL_ID,
FND_GLOBAL.Conc_Program_Id,
sysdate);