53: TYPE Shipment_Details_Rec_Tab IS TABLE OF Shipment_Details_Rec_Type index by binary_integer;
54:
55: TYPE Shipment_Request_Rec_Type IS RECORD (
56: delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE,
57: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
58: document_number NUMBER,
59: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
60: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
61: organization_code WSH_NEW_DEL_INTERFACE.organization_code%TYPE,
55: TYPE Shipment_Request_Rec_Type IS RECORD (
56: delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE,
57: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
58: document_number NUMBER,
59: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
60: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
61: organization_code WSH_NEW_DEL_INTERFACE.organization_code%TYPE,
62: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
63: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
56: delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE,
57: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
58: document_number NUMBER,
59: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
60: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
61: organization_code WSH_NEW_DEL_INTERFACE.organization_code%TYPE,
62: customer_id WSH_NEW_DEL_INTERFACE.customer_id%TYPE,
63: customer_name WSH_NEW_DEL_INTERFACE.customer_name%TYPE,
64: ship_to_customer_id WSH_NEW_DEL_INTERFACE.ship_to_customer_id%TYPE,
115: shipment_details_tab Shipment_Details_Rec_Tab
116: );
117:
118: TYPE Criteria_Rec_Type IS RECORD (
119: shipment_request_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
120: from_shipment_request_number NUMBER,
121: to_shipment_request_number NUMBER,
122: from_shipment_request_date WSH_TRANSACTIONS_HISTORY.creation_date%TYPE,
123: to_shipment_request_date WSH_TRANSACTIONS_HISTORY.creation_date%TYPE,
118: TYPE Criteria_Rec_Type IS RECORD (
119: shipment_request_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
120: from_shipment_request_number NUMBER,
121: to_shipment_request_number NUMBER,
122: from_shipment_request_date WSH_TRANSACTIONS_HISTORY.creation_date%TYPE,
123: to_shipment_request_date WSH_TRANSACTIONS_HISTORY.creation_date%TYPE,
124: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
125: client_code WSH_NEW_DEL_INTERFACE.client_code%TYPE); -- LSP PROJECT : Added Client_code
126:
119: shipment_request_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
120: from_shipment_request_number NUMBER,
121: to_shipment_request_number NUMBER,
122: from_shipment_request_date WSH_TRANSACTIONS_HISTORY.creation_date%TYPE,
123: to_shipment_request_date WSH_TRANSACTIONS_HISTORY.creation_date%TYPE,
124: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
125: client_code WSH_NEW_DEL_INTERFACE.client_code%TYPE); -- LSP PROJECT : Added Client_code
126:
127: TYPE Interface_Errors_Rec_Type IS RECORD (
120: from_shipment_request_number NUMBER,
121: to_shipment_request_number NUMBER,
122: from_shipment_request_date WSH_TRANSACTIONS_HISTORY.creation_date%TYPE,
123: to_shipment_request_date WSH_TRANSACTIONS_HISTORY.creation_date%TYPE,
124: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
125: client_code WSH_NEW_DEL_INTERFACE.client_code%TYPE); -- LSP PROJECT : Added Client_code
126:
127: TYPE Interface_Errors_Rec_Type IS RECORD (
128: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
124: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
125: client_code WSH_NEW_DEL_INTERFACE.client_code%TYPE); -- LSP PROJECT : Added Client_code
126:
127: TYPE Interface_Errors_Rec_Type IS RECORD (
128: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
129: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
130: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
131: error_message WSH_INTERFACE_ERRORS.error_message%TYPE);
132:
125: client_code WSH_NEW_DEL_INTERFACE.client_code%TYPE); -- LSP PROJECT : Added Client_code
126:
127: TYPE Interface_Errors_Rec_Type IS RECORD (
128: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
129: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
130: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
131: error_message WSH_INTERFACE_ERRORS.error_message%TYPE);
132:
133: