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