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_SHIPMENT_REQUEST_PUB dependencies on WSH_TRANSACTIONS_HISTORY

Line 657: FROM wsh_transactions_history

653:
654: if p_caller ='SHIPMENT_REQUEST' THEN
655: --{
656: select count(*) into l_exists
657: FROM wsh_transactions_history
658: WHERE document_number = to_char(p_shipment_request_info.document_number)
659: and document_revision = p_shipment_request_info.document_revision
660: AND document_type = 'SR'
661: AND document_direction = 'I';

Line 1151: WSH_DEBUG_SV.log(l_module_name, 'Inserting into WSH_TRANSACTIONS_HISTORY' );

1147: END IF;--(if count >0)
1148:
1149: IF p_caller = 'SHIPMENT_REQUEST' THEN
1150: IF l_debug_on THEN
1151: WSH_DEBUG_SV.log(l_module_name, 'Inserting into WSH_TRANSACTIONS_HISTORY' );
1152: END IF;
1153: INSERT INTO WSH_TRANSACTIONS_HISTORY(
1154: TRANSACTION_ID,
1155: DOCUMENT_TYPE,

Line 1153: INSERT INTO WSH_TRANSACTIONS_HISTORY(

1149: IF p_caller = 'SHIPMENT_REQUEST' THEN
1150: IF l_debug_on THEN
1151: WSH_DEBUG_SV.log(l_module_name, 'Inserting into WSH_TRANSACTIONS_HISTORY' );
1152: END IF;
1153: INSERT INTO WSH_TRANSACTIONS_HISTORY(
1154: TRANSACTION_ID,
1155: DOCUMENT_TYPE,
1156: DOCUMENT_NUMBER,
1157: DOCUMENT_DIRECTION,

Line 1331: FROM WSH_TRANSACTIONS_HISTORY WTH,

1327: WNDI.currency_code,
1328: WNDI.transaction_type_id,
1329: WNDI.price_list_id,
1330: WNDI.client_code -- LSP PROJECT
1331: FROM WSH_TRANSACTIONS_HISTORY WTH,
1332: WSH_NEW_DEL_INTERFACE WNDI
1333: WHERE WTH.document_number = to_char(p_shipment_request_info.document_number)
1334: AND WTH.document_revision = p_shipment_request_info.document_revision
1335: AND WTH.document_type ='SR'

Line 1563: FROM WSH_TRANSACTIONS_HISTORY WTH,

1559: x_return_status OUT NOCOPY VARCHAR2) AS
1560:
1561: CURSOR c_get_Details_DN IS
1562: SELECT wth.document_number,wth.document_revision,wndi.delivery_interface_id,wth.transaction_id
1563: FROM WSH_TRANSACTIONS_HISTORY WTH,
1564: WSH_NEW_DEL_INTERFACE WNDI,
1565: wsh_interface_errors wie
1566: WHERE WTH.document_number = to_char(p_shipment_request_info.document_number)
1567: and WTH.document_revision = p_shipment_request_info.document_revision

Line 1606: l_transaction_id WSH_TRANSACTIONS_HISTORY.Transaction_Id%TYPE;

1602: where wdai.delivery_interface_id= p_shipment_request_info.delivery_interface_id;
1603:
1604: --
1605: l_delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE;
1606: l_transaction_id WSH_TRANSACTIONS_HISTORY.Transaction_Id%TYPE;
1607: l_del_det_int_tab wsh_util_core.id_tab_type;
1608: l_document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE;
1609: l_document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE;
1610: l_count NUMBER;

Line 1608: l_document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE;

1604: --
1605: l_delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE;
1606: l_transaction_id WSH_TRANSACTIONS_HISTORY.Transaction_Id%TYPE;
1607: l_del_det_int_tab wsh_util_core.id_tab_type;
1608: l_document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE;
1609: l_document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE;
1610: l_count NUMBER;
1611: l_ins_rows NUMBER;
1612: l_ins_count NUMBER :=1;

Line 1609: l_document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE;

1605: l_delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE;
1606: l_transaction_id WSH_TRANSACTIONS_HISTORY.Transaction_Id%TYPE;
1607: l_del_det_int_tab wsh_util_core.id_tab_type;
1608: l_document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE;
1609: l_document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE;
1610: l_count NUMBER;
1611: l_ins_rows NUMBER;
1612: l_ins_count NUMBER :=1;
1613: l_upd_count NUMBER :=1;

Line 2086: delete from wsh_transactions_history where transaction_id = l_transaction_id;

2082: IF l_debug_on THEN
2083: WSH_DEBUG_SV.log(l_module_name, 'WNDI : Number of records Deleted',l_ins_rows);
2084: END IF;
2085: ---------
2086: delete from wsh_transactions_history where transaction_id = l_transaction_id;
2087: l_ins_rows := sql%rowcount;
2088: IF l_debug_on THEN
2089: WSH_DEBUG_SV.log(l_module_name, 'WTH : Number of records Deleted',l_ins_rows);
2090: END IF;