DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PUB dependencies on WSH_TRANSACTIONS_HISTORY

Line 57: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,

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,

Line 59: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%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,

Line 60: action_type WSH_TRANSACTIONS_HISTORY.action_type%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,

Line 119: shipment_request_status WSH_TRANSACTIONS_HISTORY.transaction_status%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,

Line 122: from_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:

Line 123: to_shipment_request_date WSH_TRANSACTIONS_HISTORY.creation_date%TYPE,

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 (

Line 124: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%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 (
128: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,

Line 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:

Line 129: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%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:
133: