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

Line 242: FROM Wsh_Transactions_History wth,

238: wth.Attribute13,
239: wth.Attribute14,
240: wth.Attribute15,
241: NULL -- LSP PROJECT : just added for dependency for client_id
242: FROM Wsh_Transactions_History wth,
243: Wsh_New_Del_Interface wndi
244: WHERE wndi.interface_action_code = g_interface_action_code
245: AND wndi.delivery_interface_id = to_number(wth.entity_number)
246: AND wth.transaction_id = p_transaction_id

Line 255: from wsh_transactions_history

251:
252: cursor c_get_status (v_trx_id NUMBER)
253: is
254: select transaction_status
255: from wsh_transactions_history
256: where transaction_id = v_trx_id;
257:
258:
259: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

Line 259: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

255: from wsh_transactions_history
256: where transaction_id = v_trx_id;
257:
258:
259: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
260: l_trx_status wsh_transactions_history.transaction_status%TYPE;
261:
262: l_from_creation_date DATE;
263: l_to_creation_date DATE;

Line 260: l_trx_status wsh_transactions_history.transaction_status%TYPE;

256: where transaction_id = v_trx_id;
257:
258:
259: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
260: l_trx_status wsh_transactions_history.transaction_status%TYPE;
261:
262: l_from_creation_date DATE;
263: l_to_creation_date DATE;
264:

Line 388: l_transaction_query := l_transaction_query || ' FROM Wsh_Transactions_History wth, ';

384: l_transaction_query := l_transaction_query || 'wth.Attribute14, ';
385: l_transaction_query := l_transaction_query || 'wth.Attribute15 ';
386:
387: --FROM Clause
388: l_transaction_query := l_transaction_query || ' FROM Wsh_Transactions_History wth, ';
389: --l_transaction_query := l_transaction_query || ' FROM Wsh_New_Del_Interface wndi, ';
390: l_transaction_query := l_transaction_query || '( SELECT max(wth1.document_revision) document_revision, ';
391: l_transaction_query := l_transaction_query || ' to_char(max(to_number(entity_number))) entity_number, ';
392: l_transaction_query := l_transaction_query || ' document_number, document_type, document_direction ';

Line 393: l_transaction_query := l_transaction_query || ' FROM Wsh_Transactions_History wth1 ';

389: --l_transaction_query := l_transaction_query || ' FROM Wsh_New_Del_Interface wndi, ';
390: l_transaction_query := l_transaction_query || '( SELECT max(wth1.document_revision) document_revision, ';
391: l_transaction_query := l_transaction_query || ' to_char(max(to_number(entity_number))) entity_number, ';
392: l_transaction_query := l_transaction_query || ' document_number, document_type, document_direction ';
393: l_transaction_query := l_transaction_query || ' FROM Wsh_Transactions_History wth1 ';
394:
395: l_transaction_query := l_transaction_query || ' WHERE wth1.document_type = ''SR'' ';
396: l_transaction_query := l_transaction_query || ' AND wth1.document_direction = ''I'' ';
397:

Line 782: p_transaction_rec IN WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type,

778: -- logged in Wsh_Interface_Errors table.
779: --=============================================================================
780: --
781: PROCEDURE Process_Shipment_Request (
782: p_transaction_rec IN WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type,
783: p_commit_flag IN VARCHAR2,
784: x_return_status OUT NOCOPY VARCHAR2 )
785: IS
786:

Line 866: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

862: l_delivery_interface_tbl WSH_UTIL_CORE.Id_Tab_Type;
863: l_detail_interface_tbl WSH_UTIL_CORE.Id_Tab_Type;
864: l_del_assgn_interface_tbl WSH_UTIL_CORE.Id_Tab_Type;
865: l_delivery_detail_tab WSH_UTIL_CORE.Id_Tab_Type;
866: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
867:
868: l_init_om_header_rec OM_Header_Rec_Type;
869: l_om_header_rec OM_Header_Rec_Type;
870: l_om_line_tbl_type OM_Line_Tbl_Type;

Line 1066: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_transactions_history Records');

1062: --Lock all transaction history before processing
1063: BEGIN
1064: --Lock all transaction history records
1065: IF l_debug_on THEN
1066: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_transactions_history Records');
1067: END IF;
1068: --
1069:
1070: SELECT transaction_id, entity_number

Line 1072: FROM wsh_transactions_history

1068: --
1069:
1070: SELECT transaction_id, entity_number
1071: BULK COLLECT INTO l_txn_history_tbl, l_entity_number_tbl
1072: FROM wsh_transactions_history
1073: WHERE transaction_status in ( 'IP', 'AP', 'ER' )
1074: AND document_type = 'SR'
1075: AND document_direction = 'I'
1076: AND document_revision <= l_transaction_rec.document_revision

Line 1083: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_transactions_history Records');

1079: for update nowait;
1080:
1081: --Lock all delivery interface records
1082: IF l_debug_on THEN
1083: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_transactions_history Records');
1084: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_new_del_interface Records');
1085: END IF;
1086: --
1087:

Line 1091: Wsh_Transactions_History wth

1087:
1088: SELECT wndi.delivery_interface_id
1089: BULK COLLECT INTO l_delivery_interface_tbl
1090: FROM Wsh_New_Del_Interface wndi,
1091: Wsh_Transactions_History wth
1092: WHERE wndi.interface_action_code = g_interface_action_code
1093: AND wndi.delivery_interface_id = to_number(wth.entity_number)
1094: AND wth.transaction_status in ( 'IP', 'AP', 'ER' )
1095: AND wth.document_type = 'SR'

Line 1112: Wsh_Transactions_History wth

1108: SELECT wddi.delivery_detail_interface_id, wdai.del_assgn_interface_id
1109: BULK COLLECT INTO l_detail_interface_tbl, l_del_assgn_interface_tbl
1110: FROM Wsh_Del_Details_Interface wddi,
1111: Wsh_Del_Assgn_Interface wdai,
1112: Wsh_Transactions_History wth
1113: WHERE wddi.interface_action_code = g_interface_action_code
1114: AND wdai.interface_action_code = g_interface_action_code
1115: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
1116: AND wdai.delivery_interface_id = wth.entity_number

Line 1134: wsh_transactions_history wth

1130:
1131: SELECT wie.interface_error_id
1132: BULK COLLECT INTO l_del_interface_error_tbl
1133: FROM wsh_interface_errors wie,
1134: wsh_transactions_history wth
1135: WHERE wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
1136: AND wie.interface_action_code = g_interface_action_code
1137: AND wth.transaction_status in ( 'IP', 'AP', 'ER' )
1138: AND wth.document_type = 'SR'

Line 1161: wsh_transactions_history wth

1157: AND interface_id in
1158: ( select wddi.delivery_detail_interface_id
1159: FROM Wsh_Del_Details_Interface wddi,
1160: Wsh_Del_Assgn_Interface wdai,
1161: wsh_transactions_history wth
1162: WHERE wddi.interface_action_code = g_interface_action_code
1163: AND wdai.interface_action_code = g_interface_action_code
1164: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
1165: AND wth.transaction_status in ( 'IP', 'AP', 'ER' )

Line 1488: UPDATE wsh_transactions_history

1484: END IF;
1485: --
1486: IF l_txn_history_tbl.count > 0 THEN
1487: FORALL i in l_txn_history_tbl.FIRST..l_txn_history_tbl.LAST
1488: UPDATE wsh_transactions_history
1489: SET transaction_status = 'SC',
1490: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1491: program_id = FND_GLOBAL.Conc_Program_Id,
1492: request_id = FND_GLOBAL.Conc_Request_Id,

Line 1501: WSH_DEBUG_SV.logmsg(l_module_name, sql%rowcount || ' row(s) updated in wsh_transactions_history');

1497: WHERE transaction_id = l_txn_history_tbl(i);
1498:
1499: --
1500: IF l_debug_on THEN
1501: WSH_DEBUG_SV.logmsg(l_module_name, sql%rowcount || ' row(s) updated in wsh_transactions_history');
1502: END IF;
1503: --
1504: END IF;
1505:

Line 2143: UPDATE wsh_transactions_history

2139: IF l_upd_txn_history_tbl.count > 0 THEN
2140: -- Entity Type and Entity Number should be updated only for current
2141: -- processing transaction history record
2142: FORALL i in l_upd_txn_history_tbl.FIRST..l_upd_txn_history_tbl.LAST
2143: UPDATE wsh_transactions_history
2144: SET transaction_status = 'SC',
2145: entity_type = decode(transaction_id, l_transaction_rec.transaction_id, 'ORDER', entity_type),
2146: entity_number = decode(transaction_id, l_transaction_rec.transaction_id, x_header_rec.header_id, entity_number),
2147: program_application_id = FND_GLOBAL.Prog_Appl_Id,

Line 2158: WSH_DEBUG_SV.logmsg(l_module_name, sql%rowcount || ' row(s) updated in wsh_transactions_history');

2154: WHERE transaction_id = l_upd_txn_history_tbl(i);
2155:
2156: --
2157: IF l_debug_on THEN
2158: WSH_DEBUG_SV.logmsg(l_module_name, sql%rowcount || ' row(s) updated in wsh_transactions_history');
2159: END IF;
2160: --
2161: END IF;
2162:

Line 2464: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History', WSH_DEBUG_SV.C_PROC_LEVEL);

2460: l_transaction_rec.transaction_status := 'ER';
2461:
2462: --
2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History', WSH_DEBUG_SV.C_PROC_LEVEL);
2465: END IF;
2466: --
2467: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History (
2468: p_txns_history_rec => l_transaction_rec,

Line 2467: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History (

2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History', WSH_DEBUG_SV.C_PROC_LEVEL);
2465: END IF;
2466: --
2467: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History (
2468: p_txns_history_rec => l_transaction_rec,
2469: x_txns_id => l_transaction_rec.transaction_id,
2470: x_return_status => l_return_status );
2471: