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 815: wsh_transactions_history wth

811:
812: CURSOR c_delId_cur IS
813: SELECT wnd.delivery_id
814: from wsh_new_deliveries wnd,
815: wsh_transactions_history wth
816: where wnd.name = wth.entity_number
817: and entity_type='DLVY'
818: and wth.event_key = item_key
819: and wth.item_type = item_type

Line 933: UPDATE wsh_transactions_history

929: wsh_debug_sv.push(l_module_name);
930: wsh_debug_sv.log(l_module_name, 'p_transaction_id',p_transaction_id);
931: END IF;
932:
933: UPDATE wsh_transactions_history
934: SET transaction_status = 'ER'
935: WHERE transaction_id = p_transaction_id;
936:
937: IF l_debug_on THEN

Line 969: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

965:
966: IS
967:
968:
969: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
970: l_return_status VARCHAR2(1);
971: l_document_type VARCHAR2(30);
972: --k proj
973: l_cancellation_in_progress BOOLEAN := FALSE;

Line 977: l_enity_number wsh_transactions_history.entity_number%TYPE;

973: l_cancellation_in_progress BOOLEAN := FALSE;
974: l_num_warn number := 0;
975: l_num_err number := 0;
976: l_sr_trx_id NUMBER;
977: l_enity_number wsh_transactions_history.entity_number%TYPE;
978:
979: CURSOR c_get_entity_number (v_trx_id NUMBER) IS --bmso
980: SELECT wth1.entity_number , wth1.transaction_id
981: FROM wsh_transactions_history wth1,

Line 981: FROM wsh_transactions_history wth1,

977: l_enity_number wsh_transactions_history.entity_number%TYPE;
978:
979: CURSOR c_get_entity_number (v_trx_id NUMBER) IS --bmso
980: SELECT wth1.entity_number , wth1.transaction_id
981: FROM wsh_transactions_history wth1,
982: wsh_transactions_history wth2
983: WHERE wth1.action_type = 'A'
984: AND wth1.entity_type = 'DLVY'
985: AND wth1.document_type = 'SR'

Line 982: wsh_transactions_history wth2

978:
979: CURSOR c_get_entity_number (v_trx_id NUMBER) IS --bmso
980: SELECT wth1.entity_number , wth1.transaction_id
981: FROM wsh_transactions_history wth1,
982: wsh_transactions_history wth2
983: WHERE wth1.action_type = 'A'
984: AND wth1.entity_type = 'DLVY'
985: AND wth1.document_type = 'SR'
986: AND wth1.document_direction = 'O'

Line 1029: FROM wsh_transactions_history wth1,

1025: wth2.attribute13 ,
1026: wth2.attribute14 ,
1027: wth2.attribute15,
1028: NULL -- LSP PROJECT : just added for dependency for client_id
1029: FROM wsh_transactions_history wth1,
1030: wsh_transactions_history wth2
1031: WHERE wth1.transaction_id = v_sr_trx_id
1032: AND wth2.entity_number = wth1.entity_number
1033: AND wth2.document_direction = 'O'

Line 1030: wsh_transactions_history wth2

1026: wth2.attribute14 ,
1027: wth2.attribute15,
1028: NULL -- LSP PROJECT : just added for dependency for client_id
1029: FROM wsh_transactions_history wth1,
1030: wsh_transactions_history wth2
1031: WHERE wth1.transaction_id = v_sr_trx_id
1032: AND wth2.entity_number = wth1.entity_number
1033: AND wth2.document_direction = 'O'
1034: AND wth2.document_type = 'SR'

Line 1038: l_cancel_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1034: AND wth2.document_type = 'SR'
1035: AND wth2.action_type = 'D'
1036: ORDER BY wth2.transaction_id desc;
1037:
1038: l_cancel_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1039:
1040: wsh_process_inbound EXCEPTION;
1041:
1042: --Fulfillment Batch XML Project

Line 1074: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History(

1070: l_document_type := 'SA';
1071: ELSE
1072: l_document_type := 'SR';
1073: END IF;
1074: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History(
1075: Item_type,
1076: Item_key,
1077: 'I',
1078: l_document_type,

Line 1240: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1236:
1237: IS
1238:
1239:
1240: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1241: l_return_status VARCHAR2(1);
1242: l_document_type VARCHAR2(30);
1243:
1244: wsh_process_inbound EXCEPTION;

Line 1271: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History(

1267:
1268: IF ( funcmode = 'RUN' ) THEN
1269:
1270: l_document_type := 'SR';
1271: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History(
1272: Item_type,
1273: Item_key,
1274: 'I',
1275: l_document_type,

Line 1580: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1576:
1577:
1578: pragma AUTONOMOUS_TRANSACTION;
1579:
1580: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1581: l_document_type VARCHAR2(2);
1582: l_txn_direction VARCHAR2(1);
1583: l_txn_id NUMBER;
1584:

Line 1623: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History( p_item_type,

1619: ELSE
1620: l_document_type := 'SA';
1621: l_txn_direction := 'O';
1622: END IF;
1623: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History( p_item_type,
1624: p_item_key,
1625: l_txn_direction,
1626: l_document_type,
1627: l_txns_history_rec,

Line 1638: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txns_history_rec,

1634: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1635: raise wsh_update_history;
1636: END IF;
1637:
1638: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txns_history_rec,
1639: l_txn_id,
1640: x_return_status );
1641: IF l_debug_on THEN
1642: wsh_debug_sv.log(l_module_name, 'Create_Update_Txns_History x_return_status',x_return_status);

Line 1651: WHERE batch_id = (SELECT entity_number FROM WSH_TRANSACTIONS_HISTORY WHERE event_key = p_item_key AND item_type = p_item_type)

1647: ELSE
1648: IF p_item_type = 'WSHBATO' THEN --Fulfillment Batch XML Project
1649: UPDATE wsh_shipment_batches
1650: SET pending_request_flag = NULL
1651: WHERE batch_id = (SELECT entity_number FROM WSH_TRANSACTIONS_HISTORY WHERE event_key = p_item_key AND item_type = p_item_type)
1652: AND pending_request_flag = 'Y';
1653: END IF;
1654: COMMIT;
1655: END IF;

Line 1874: FROM wsh_transactions_history

1870: WHERE name = v_delivery_name;
1871:
1872: CURSOR c_get_event_key(v_delivery_name NUMBER) IS
1873: SELECT event_key
1874: FROM wsh_transactions_history
1875: WHERE ENTITY_NUMBER = v_delivery_name
1876: AND ENTITY_TYPE = 'DLVY'
1877: AND ACTION_TYPE = 'D'
1878: AND document_direction = 'O'

Line 2044: FROM wsh_transactions_history wth1,

2040:
2041: --
2042: CURSOR c_del_name_cur (v_item_key varchar2, v_item_type VARCHAR2) IS --bmso
2043: SELECT wth2.entity_number , wth1.transaction_id
2044: FROM wsh_transactions_history wth1,
2045: wsh_transactions_history wth2
2046: where wth1.entity_type='DLVY_INT'
2047: and wth1.event_key = v_item_key
2048: and wth1.item_type = v_item_type

Line 2045: wsh_transactions_history wth2

2041: --
2042: CURSOR c_del_name_cur (v_item_key varchar2, v_item_type VARCHAR2) IS --bmso
2043: SELECT wth2.entity_number , wth1.transaction_id
2044: FROM wsh_transactions_history wth1,
2045: wsh_transactions_history wth2
2046: where wth1.entity_type='DLVY_INT'
2047: and wth1.event_key = v_item_key
2048: and wth1.item_type = v_item_type
2049: and wth1.document_type = 'SA'

Line 2118: UPDATE wsh_transactions_history

2114: x_num_errors => l_num_err);
2115:
2116: IF l_cancellation_in_progress THEN --{
2117:
2118: UPDATE wsh_transactions_history
2119: SET TRANSACTION_STATUS = 'AP'
2120: WHERE transaction_id = l_transaction_id;
2121:
2122: IF SQL%ROWCOUNT <> 1 THEN

Line 2233: l_sr_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

2229: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||
2230: 'PROCESS_CBOD_WF';
2231: --
2232: l_cbod_status VARCHAR2(5);
2233: l_sr_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
2234: l_entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE;
2235: l_result_code VARCHAR2(50);
2236: l_transaction_status VARCHAR2(5);
2237: l_trx_id NUMBER;

Line 2234: l_entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE;

2230: 'PROCESS_CBOD_WF';
2231: --
2232: l_cbod_status VARCHAR2(5);
2233: l_sr_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
2234: l_entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE;
2235: l_result_code VARCHAR2(50);
2236: l_transaction_status VARCHAR2(5);
2237: l_trx_id NUMBER;
2238: l_return_status VARCHAR2(2);

Line 2249: FROM wsh_transactions_history wth1,

2245:
2246: CURSOR c_get_trx_id (v_name varchar2) IS --bmso
2247: SELECT wth2.transaction_id, wth2.transaction_status,
2248: to_number(wth2.entity_number)
2249: FROM wsh_transactions_history wth1,
2250: wsh_transactions_history wth2
2251: WHERE wth1.entity_number = v_name
2252: AND wth1.action_type = 'A'
2253: AND wth1.entity_type = 'DLVY'

Line 2250: wsh_transactions_history wth2

2246: CURSOR c_get_trx_id (v_name varchar2) IS --bmso
2247: SELECT wth2.transaction_id, wth2.transaction_status,
2248: to_number(wth2.entity_number)
2249: FROM wsh_transactions_history wth1,
2250: wsh_transactions_history wth2
2251: WHERE wth1.entity_number = v_name
2252: AND wth1.action_type = 'A'
2253: AND wth1.entity_type = 'DLVY'
2254: AND wth1.document_type = 'SR'

Line 2297: FROM wsh_transactions_history

2293: attribute13,
2294: attribute14,
2295: attribute15,
2296: NULL -- LSP PROJECT : just added for dependency for client_id
2297: FROM wsh_transactions_history
2298: WHERE
2299: entity_number = v_entity_number
2300: AND action_type = 'A'
2301: AND entity_type = 'DLVY'

Line 2316: FROM wsh_transactions_history

2312:
2313: cursor c_get_cancel_rec (v_item_type VARCHAR2, v_item_key VARCHAR2)
2314: IS
2315: SELECT entity_number
2316: FROM wsh_transactions_history
2317: WHERE item_type = v_item_type
2318: AND event_key = v_item_key
2319: AND document_direction = 'O'
2320: AND document_type = 'SR'

Line 2327: FROM wsh_transactions_history

2323:
2324: cursor c_sr_instance (v_item_type VARCHAR2, v_item_key VARCHAR2)
2325: IS
2326: SELECT 1
2327: FROM wsh_transactions_history
2328: WHERE item_type = v_item_type
2329: AND event_key = v_item_key
2330: AND document_direction = 'O'
2331: AND document_type = 'SR'

Line 2492: UPDATE wsh_transactions_history

2488: END IF;
2489:
2490: --Update the status_code for shipment advice record to 'SX'
2491:
2492: UPDATE wsh_transactions_history
2493: SET transaction_status= 'SX',
2494: entity_number = l_entity_number,
2495: entity_type = 'DLVY'
2496: WHERE