APPS.WSH_TRANSACTIONS_FORM_PKG dependencies on WSH_TRANSACTIONS_HISTORY

Line 96: FROM WSH_TRANSACTIONS_HISTORY wth,

92: CURSOR history_cur IS
93: SELECT wth.document_type,wth.document_number,wth.orig_document_number,wth.document_direction,wth.transaction_status,wth.
94: action_type,wth.entity_number,wth.entity_type,wth.trading_partner_id,wth.ecx_message_id,wth.
95: event_name,wth.event_key,wth.internal_control_number,wth.item_type,wndi.client_code
96: FROM WSH_TRANSACTIONS_HISTORY wth,
97: WSH_NEW_DEL_INTERFACE wndi
98: WHERE wth.transaction_id = P_transaction_id
99: AND wth.entity_number = wndi.delivery_interface_id(+);
100:

Line 103: FROM wsh_transactions_history

99: AND wth.entity_number = wndi.delivery_interface_id(+);
100:
101: cursor c_get_status (v_trx_id NUMBER)
102: IS select TRANSACTION_STATUS
103: FROM wsh_transactions_history
104: WHERE transaction_id = v_trx_id;
105:
106: l_trx_status wsh_transactions_history.transaction_status%TYPE;
107: -- TPW - Distribution Changes

Line 106: l_trx_status wsh_transactions_history.transaction_status%TYPE;

102: IS select TRANSACTION_STATUS
103: FROM wsh_transactions_history
104: WHERE transaction_id = v_trx_id;
105:
106: l_trx_status wsh_transactions_history.transaction_status%TYPE;
107: -- TPW - Distribution Changes
108: l_trns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
109: --R12.1.1 STANDALONE PROJECT
110: l_wms_deploy_mode VARCHAR2(1);

Line 108: l_trns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

104: WHERE transaction_id = v_trx_id;
105:
106: l_trx_status wsh_transactions_history.transaction_status%TYPE;
107: -- TPW - Distribution Changes
108: l_trns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
109: --R12.1.1 STANDALONE PROJECT
110: l_wms_deploy_mode VARCHAR2(1);
111:
112: --