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

Line 113: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

109: x_valid_flag BOOLEAN;
110: l_assigned_to_trip VARCHAR2(1);
111: l_customer_id NUMBER;
112:
113: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
114:
115: cursor del_name_cur is
116: select name, customer_id from wsh_new_deliveries
117: where delivery_id = p_entity_id;

Line 160: from wsh_transactions_history

156: cursor orig_txn_hist_cur(p_entity_number IN VARCHAR2,
157: p_tp_id IN NUMBER
158: ) is
159: select document_number,transaction_status
160: from wsh_transactions_history
161: where transaction_id = (
162: select max(transaction_id)
163: from wsh_transactions_history
164: where entity_number = p_entity_number

Line 163: from wsh_transactions_history

159: select document_number,transaction_status
160: from wsh_transactions_history
161: where transaction_id = (
162: select max(transaction_id)
163: from wsh_transactions_history
164: where entity_number = p_entity_number
165: and trading_partner_id = p_tp_id
166: and document_direction = 'O'
167: --and transaction_status = 'ST'

Line 668: from wsh_transactions_history

664: IS
665:
666: cursor get_key is
667: select event_key
668: from wsh_transactions_history
669: where item_type = p_item_type
670: and document_number = p_orig_doc_number
671: and trading_partner_id = p_organization_id;
672:

Line 779: wsh_transactions_history wth

775:
776: CURSOR c_delId_cur IS
777: SELECT wnd.delivery_id
778: from wsh_new_deliveries wnd,
779: wsh_transactions_history wth
780: where wnd.name = wth.entity_number
781: and entity_type='DLVY'
782: and wth.event_key = item_key
783: and wth.item_type = item_type

Line 897: UPDATE wsh_transactions_history

893: wsh_debug_sv.push(l_module_name);
894: wsh_debug_sv.log(l_module_name, 'p_transaction_id',p_transaction_id);
895: END IF;
896:
897: UPDATE wsh_transactions_history
898: SET transaction_status = 'ER'
899: WHERE transaction_id = p_transaction_id;
900:
901: IF l_debug_on THEN

Line 933: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

929:
930: IS
931:
932:
933: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
934: l_return_status VARCHAR2(1);
935: l_document_type VARCHAR2(30);
936: --k proj
937: l_cancellation_in_progress BOOLEAN := FALSE;

Line 941: l_enity_number wsh_transactions_history.entity_number%TYPE;

937: l_cancellation_in_progress BOOLEAN := FALSE;
938: l_num_warn number := 0;
939: l_num_err number := 0;
940: l_sr_trx_id NUMBER;
941: l_enity_number wsh_transactions_history.entity_number%TYPE;
942:
943: CURSOR c_get_entity_number (v_trx_id NUMBER) IS --bmso
944: SELECT wth1.entity_number , wth1.transaction_id
945: FROM wsh_transactions_history wth1,

Line 945: FROM wsh_transactions_history wth1,

941: l_enity_number wsh_transactions_history.entity_number%TYPE;
942:
943: CURSOR c_get_entity_number (v_trx_id NUMBER) IS --bmso
944: SELECT wth1.entity_number , wth1.transaction_id
945: FROM wsh_transactions_history wth1,
946: wsh_transactions_history wth2
947: WHERE wth1.action_type = 'A'
948: AND wth1.entity_type = 'DLVY'
949: AND wth1.document_type = 'SR'

Line 946: wsh_transactions_history wth2

942:
943: CURSOR c_get_entity_number (v_trx_id NUMBER) IS --bmso
944: SELECT wth1.entity_number , wth1.transaction_id
945: FROM wsh_transactions_history wth1,
946: wsh_transactions_history wth2
947: WHERE wth1.action_type = 'A'
948: AND wth1.entity_type = 'DLVY'
949: AND wth1.document_type = 'SR'
950: AND wth1.document_direction = 'O'

Line 990: FROM wsh_transactions_history wth1,

986: wth2.attribute12 ,
987: wth2.attribute13 ,
988: wth2.attribute14 ,
989: wth2.attribute15
990: FROM wsh_transactions_history wth1,
991: wsh_transactions_history wth2
992: WHERE wth1.transaction_id = v_sr_trx_id
993: AND wth2.entity_number = wth1.entity_number
994: AND wth2.document_direction = 'O'

Line 991: wsh_transactions_history wth2

987: wth2.attribute13 ,
988: wth2.attribute14 ,
989: wth2.attribute15
990: FROM wsh_transactions_history wth1,
991: wsh_transactions_history wth2
992: WHERE wth1.transaction_id = v_sr_trx_id
993: AND wth2.entity_number = wth1.entity_number
994: AND wth2.document_direction = 'O'
995: AND wth2.document_type = 'SR'

Line 999: l_cancel_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

995: AND wth2.document_type = 'SR'
996: AND wth2.action_type = 'D'
997: ORDER BY wth2.transaction_id desc;
998:
999: l_cancel_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1000:
1001: wsh_process_inbound EXCEPTION;
1002: --
1003: l_debug_on BOOLEAN;

Line 1032: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History(

1028: l_document_type := 'SA';
1029: ELSE
1030: l_document_type := 'SR';
1031: END IF;
1032: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History(
1033: Item_type,
1034: Item_key,
1035: 'I',
1036: l_document_type,

Line 1323: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1319:
1320:
1321: pragma AUTONOMOUS_TRANSACTION;
1322:
1323: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1324: l_document_type VARCHAR2(2);
1325: l_txn_direction VARCHAR2(1);
1326: l_txn_id NUMBER;
1327:

Line 1361: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History( p_item_type,

1357: ELSE
1358: l_document_type := 'SA';
1359: l_txn_direction := 'O';
1360: END IF;
1361: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History( p_item_type,
1362: p_item_key,
1363: l_txn_direction,
1364: l_document_type,
1365: l_txns_history_rec,

Line 1376: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txns_history_rec,

1372: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1373: raise wsh_update_history;
1374: END IF;
1375:
1376: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txns_history_rec,
1377: l_txn_id,
1378: x_return_status );
1379: IF l_debug_on THEN
1380: wsh_debug_sv.log(l_module_name, 'Create_Update_Txns_History x_return_status',x_return_status);

Line 1592: FROM wsh_transactions_history

1588: WHERE name = v_delivery_name;
1589:
1590: CURSOR c_get_event_key(v_delivery_name NUMBER) IS
1591: SELECT event_key
1592: FROM wsh_transactions_history
1593: WHERE ENTITY_NUMBER = v_delivery_name
1594: AND ENTITY_TYPE = 'DLVY'
1595: AND ACTION_TYPE = 'D'
1596: AND document_direction = 'O'

Line 1762: FROM wsh_transactions_history wth1,

1758:
1759: --
1760: CURSOR c_del_name_cur (v_item_key varchar2, v_item_type VARCHAR2) IS --bmso
1761: SELECT wth2.entity_number , wth1.transaction_id
1762: FROM wsh_transactions_history wth1,
1763: wsh_transactions_history wth2
1764: where wth1.entity_type='DLVY_INT'
1765: and wth1.event_key = v_item_key
1766: and wth1.item_type = v_item_type

Line 1763: wsh_transactions_history wth2

1759: --
1760: CURSOR c_del_name_cur (v_item_key varchar2, v_item_type VARCHAR2) IS --bmso
1761: SELECT wth2.entity_number , wth1.transaction_id
1762: FROM wsh_transactions_history wth1,
1763: wsh_transactions_history wth2
1764: where wth1.entity_type='DLVY_INT'
1765: and wth1.event_key = v_item_key
1766: and wth1.item_type = v_item_type
1767: and wth1.document_type = 'SA'

Line 1836: UPDATE wsh_transactions_history

1832: x_num_errors => l_num_err);
1833:
1834: IF l_cancellation_in_progress THEN --{
1835:
1836: UPDATE wsh_transactions_history
1837: SET TRANSACTION_STATUS = 'AP'
1838: WHERE transaction_id = l_transaction_id;
1839:
1840: IF SQL%ROWCOUNT <> 1 THEN

Line 1951: l_sr_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1947: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||
1948: 'PROCESS_CBOD_WF';
1949: --
1950: l_cbod_status VARCHAR2(5);
1951: l_sr_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1952: l_entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE;
1953: l_result_code VARCHAR2(50);
1954: l_transaction_status VARCHAR2(5);
1955: l_trx_id NUMBER;

Line 1952: l_entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE;

1948: 'PROCESS_CBOD_WF';
1949: --
1950: l_cbod_status VARCHAR2(5);
1951: l_sr_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1952: l_entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE;
1953: l_result_code VARCHAR2(50);
1954: l_transaction_status VARCHAR2(5);
1955: l_trx_id NUMBER;
1956: l_return_status VARCHAR2(2);

Line 1967: FROM wsh_transactions_history wth1,

1963:
1964: CURSOR c_get_trx_id (v_name varchar2) IS --bmso
1965: SELECT wth2.transaction_id, wth2.transaction_status,
1966: to_number(wth2.entity_number)
1967: FROM wsh_transactions_history wth1,
1968: wsh_transactions_history wth2
1969: WHERE wth1.entity_number = v_name
1970: AND wth1.action_type = 'A'
1971: AND wth1.entity_type = 'DLVY'

Line 1968: wsh_transactions_history wth2

1964: CURSOR c_get_trx_id (v_name varchar2) IS --bmso
1965: SELECT wth2.transaction_id, wth2.transaction_status,
1966: to_number(wth2.entity_number)
1967: FROM wsh_transactions_history wth1,
1968: wsh_transactions_history wth2
1969: WHERE wth1.entity_number = v_name
1970: AND wth1.action_type = 'A'
1971: AND wth1.entity_type = 'DLVY'
1972: AND wth1.document_type = 'SR'

Line 2012: FROM wsh_transactions_history

2008: attribute12,
2009: attribute13,
2010: attribute14,
2011: attribute15
2012: FROM wsh_transactions_history
2013: WHERE
2014: entity_number = v_entity_number
2015: AND action_type = 'A'
2016: AND entity_type = 'DLVY'

Line 2031: FROM wsh_transactions_history

2027:
2028: cursor c_get_cancel_rec (v_item_type VARCHAR2, v_item_key VARCHAR2)
2029: IS
2030: SELECT entity_number
2031: FROM wsh_transactions_history
2032: WHERE item_type = v_item_type
2033: AND event_key = v_item_key
2034: AND document_direction = 'O'
2035: AND document_type = 'SR'

Line 2042: FROM wsh_transactions_history

2038:
2039: cursor c_sr_instance (v_item_type VARCHAR2, v_item_key VARCHAR2)
2040: IS
2041: SELECT 1
2042: FROM wsh_transactions_history
2043: WHERE item_type = v_item_type
2044: AND event_key = v_item_key
2045: AND document_direction = 'O'
2046: AND document_type = 'SR'

Line 2207: UPDATE wsh_transactions_history

2203: END IF;
2204:
2205: --Update the status_code for shipment advice record to 'SX'
2206:
2207: UPDATE wsh_transactions_history
2208: SET transaction_status= 'SX',
2209: entity_number = l_entity_number,
2210: entity_type = 'DLVY'
2211: WHERE