APPS.WSH_TRANSACTIONS_TPW_UTIL dependencies on WSH_TRANSACTIONS_HISTORY_PKG

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 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 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 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);