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

Line 329: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

325: PROCEDURE Send_Cbod_Success ( P_item_type IN VARCHAR2,
326: P_item_key IN VARCHAR2,
327: X_Return_Status OUT NOCOPY VARCHAR2 )
328: IS
329: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
330: l_Return_Status VARCHAR2 (1);
331: l_Cbod_Status VARCHAR2 (5) := '00';
332:
333: wsh_get_txns_hist_error EXCEPTION;

Line 357: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,

353: END IF;
354:
355: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
356:
357: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
358: P_item_key,
359: 'I',
360: 'SR',
361: l_txn_hist_record,

Line 434: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

430: PROCEDURE Send_Cbod_Failure ( P_item_type IN VARCHAR2,
431: P_item_key IN VARCHAR2,
432: X_Return_Status OUT NOCOPY VARCHAR2 )
433: IS
434: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
435: l_Return_Status VARCHAR2 (1);
436: l_Cbod_Status VARCHAR2 (5) := '99';
437:
438: l_Event_Name VARCHAR2 (120);

Line 447: FROM wsh_transactions_history

443: IS
444: SELECT Event_Key,
445: Item_Type,
446: Internal_Control_Number
447: FROM wsh_transactions_history
448: WHERE Transaction_ID = (SELECT MAX (Transaction_ID)
449: FROM wsh_transactions_history
450: WHERE Document_Number = c_Orig_Document_Number
451: AND Trading_Partner_ID = c_Trading_Partner_ID

Line 449: FROM wsh_transactions_history

445: Item_Type,
446: Internal_Control_Number
447: FROM wsh_transactions_history
448: WHERE Transaction_ID = (SELECT MAX (Transaction_ID)
449: FROM wsh_transactions_history
450: WHERE Document_Number = c_Orig_Document_Number
451: AND Trading_Partner_ID = c_Trading_Partner_ID
452: AND Document_Direction = 'I'
453: AND Action_Type = 'A');

Line 480: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,

476: END IF;
477:
478: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
479:
480: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
481: P_item_key,
482: 'I',
483: 'SR',
484: l_txn_hist_record,

Line 595: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

591: PROCEDURE Check_Cancel_Allowed ( P_item_type IN VARCHAR2,
592: P_item_key IN VARCHAR2,
593: X_Return_Status OUT NOCOPY VARCHAR2 )
594: IS
595: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
596: l_Return_Status VARCHAR2 (1);
597: l_new_del_status VARCHAR2 (2);
598: l_Event_Name VARCHAR2 (120);
599: l_Event_Key VARCHAR2 (30);

Line 614: FROM wsh_transactions_history

610: IS
611: SELECT Entity_Number,
612: Trading_Partner_ID,
613: Transaction_Status
614: FROM wsh_transactions_history
615: WHERE Transaction_ID = (SELECT MAX (Transaction_ID)
616: FROM wsh_transactions_history
617: WHERE Document_Number = c_Orig_Document_Number
618: AND Trading_Partner_ID = c_Trading_Partner_ID

Line 616: FROM wsh_transactions_history

612: Trading_Partner_ID,
613: Transaction_Status
614: FROM wsh_transactions_history
615: WHERE Transaction_ID = (SELECT MAX (Transaction_ID)
616: FROM wsh_transactions_history
617: WHERE Document_Number = c_Orig_Document_Number
618: AND Trading_Partner_ID = c_Trading_Partner_ID
619: AND Document_Direction = 'I'
620: AND Action_Type = 'A');

Line 682: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,

678: RAISE wsh_invalid_item_key;
679: END IF;
680:
681: -- Get the record from the Transaction History Table.
682: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
683: P_item_key,
684: 'I',
685: 'SR',
686: l_txn_hist_record,

Line 733: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

729: END IF;
730:
731: IF ( l_Orig_Transaction_Status = 'IP' ) THEN
732: l_txn_hist_record.transaction_status := 'ER';
733: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
734: l_txn_hist_record.transaction_id,
735: l_Return_Status );
736: IF l_debug_on THEN
737: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);

Line 795: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

791: RAISE wsh_del_interface_rec;
792: END IF;
793:
794: l_txn_hist_record.transaction_status := 'SC';
795: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
796: l_txn_hist_record.transaction_id,
797: l_Return_Status );
798: IF l_debug_on THEN
799: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);

Line 864: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

860: END IF;
861:
862: IF ( l_new_del_status IN ('CL', 'IT', 'CO') ) THEN
863: l_txn_hist_record.transaction_status := 'ER';
864: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
865: l_txn_hist_record.transaction_id,
866: l_Return_Status );
867: IF l_debug_on THEN
868: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);

Line 926: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

922: RAISE wsh_del_interface_wrapper;
923: ELSE
924: l_txn_hist_record.transaction_status := 'SC';
925:
926: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
927: l_txn_hist_record.transaction_id,
928: l_Return_Status );
929:
930: IF l_debug_on THEN

Line 1187: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,

1183: END IF;
1184:
1185: WHEN wsh_del_interface_wrapper THEN
1186: l_txn_hist_record.transaction_status := 'ER';
1187: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
1188: l_txn_hist_record.transaction_id,
1189: l_Return_Status );
1190: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1191: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 1272: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1268: PROCEDURE Raise_Cancel_Event ( P_item_type IN VARCHAR2,
1269: P_item_key IN VARCHAR2,
1270: X_return_Status OUT NOCOPY VARCHAR2 )
1271: IS
1272: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1273: l_orig_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1274: l_Return_Status VARCHAR2 (1);
1275: l_Event_Name VARCHAR2 (120);
1276: l_Event_Key VARCHAR2 (30);

Line 1273: l_orig_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1269: P_item_key IN VARCHAR2,
1270: X_return_Status OUT NOCOPY VARCHAR2 )
1271: IS
1272: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1273: l_orig_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1274: l_Return_Status VARCHAR2 (1);
1275: l_Event_Name VARCHAR2 (120);
1276: l_Event_Key VARCHAR2 (30);
1277:

Line 1312: FROM wsh_transactions_history wth1,

1308: wth1.Attribute12,
1309: wth1.Attribute13,
1310: wth1.Attribute14,
1311: wth1.Attribute15
1312: FROM wsh_transactions_history wth1,
1313: wsh_transactions_history wth2
1314: WHERE wth2.Item_Type = c_Item_Type
1315: AND wth2.Event_Key = c_Item_Key
1316: AND wth1.Document_Number = wth2.Orig_Document_Number

Line 1313: wsh_transactions_history wth2

1309: wth1.Attribute13,
1310: wth1.Attribute14,
1311: wth1.Attribute15
1312: FROM wsh_transactions_history wth1,
1313: wsh_transactions_history wth2
1314: WHERE wth2.Item_Type = c_Item_Type
1315: AND wth2.Event_Key = c_Item_Key
1316: AND wth1.Document_Number = wth2.Orig_Document_Number
1317: AND wth1.Trading_Partner_ID = wth2.Trading_Partner_ID

Line 1429: FROM wsh_transactions_history wth1

1425: IS
1426: SELECT wth1.Document_Number,
1427: wth1.Transaction_Status,
1428: wth1.Event_Key
1429: FROM wsh_transactions_history wth1
1430: WHERE Transaction_ID = (SELECT MAX (Transaction_ID)
1431: FROM wsh_transactions_history
1432: WHERE Entity_Number = c_Entity_Number
1433: AND Trading_Partner_ID = c_Org_ID

Line 1431: FROM wsh_transactions_history

1427: wth1.Transaction_Status,
1428: wth1.Event_Key
1429: FROM wsh_transactions_history wth1
1430: WHERE Transaction_ID = (SELECT MAX (Transaction_ID)
1431: FROM wsh_transactions_history
1432: WHERE Entity_Number = c_Entity_Number
1433: AND Trading_Partner_ID = c_Org_ID
1434: AND Entity_Type = 'DLVY'
1435: AND Action_Type = 'A'

Line 1459: select transaction_status from wsh_transactions_history

1455: AND wnd.Organization_ID = c_Org_ID
1456: AND rownum = 1;
1457:
1458: cursor l_check_resend_cur(p_entity_number VARCHAR2 ) is
1459: select transaction_status from wsh_transactions_history
1460: where transaction_id =(select max(transaction_id) from wsh_transactions_history
1461: where entity_number= p_entity_number
1462: and trading_partner_id=p_org_id
1463: and document_direction = 'O'

Line 1460: where transaction_id =(select max(transaction_id) from wsh_transactions_history

1456: AND rownum = 1;
1457:
1458: cursor l_check_resend_cur(p_entity_number VARCHAR2 ) is
1459: select transaction_status from wsh_transactions_history
1460: where transaction_id =(select max(transaction_id) from wsh_transactions_history
1461: where entity_number= p_entity_number
1462: and trading_partner_id=p_org_id
1463: and document_direction = 'O'
1464: and document_type ='SA'

Line 1486: l_curr_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

1482:
1483: l_orig_document_number VARCHAR2 (120);
1484: l_orig_Transaction_Status VARCHAR2 (2);
1485: l_orig_Event_Key VARCHAR2 (240);
1486: l_curr_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
1487: l_Return_Status VARCHAR2 (1);
1488: l_new_del_status VARCHAR2 (2);
1489: l_Del_Name VARCHAR2 (30);
1490: l_txn_Status VARCHAR2 (2);