APPS.WSH_TRANSACTIONS_UTIL dependencies on WSH_TRANSACTIONS_HISTORY_PKG

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