91: CURSOR history_cur IS
92: SELECT document_type,document_number,orig_document_number,document_direction,transaction_status,
93: action_type,entity_number,entity_type,trading_partner_id,ecx_message_id,
94: event_name,event_key,internal_control_number,item_type
95: FROM WSH_TRANSACTIONS_HISTORY
96: WHERE transaction_id = P_transaction_id;
97:
98: cursor c_get_status (v_trx_id NUMBER)
99: IS select TRANSACTION_STATUS
96: WHERE transaction_id = P_transaction_id;
97:
98: cursor c_get_status (v_trx_id NUMBER)
99: IS select TRANSACTION_STATUS
100: FROM wsh_transactions_history
101: WHERE transaction_id = v_trx_id;
102:
103: l_trx_status wsh_transactions_history.transaction_status%TYPE;
104:
99: IS select TRANSACTION_STATUS
100: FROM wsh_transactions_history
101: WHERE transaction_id = v_trx_id;
102:
103: l_trx_status wsh_transactions_history.transaction_status%TYPE;
104:
105: --
106: l_debug_on BOOLEAN;
107: --