DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_FORM_PKG dependencies on WSH_TRANSACTIONS_HISTORY

Line 95: FROM WSH_TRANSACTIONS_HISTORY

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

Line 100: 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
100: FROM wsh_transactions_history
101: WHERE transaction_id = v_trx_id;
102:
103: l_trx_status wsh_transactions_history.transaction_status%TYPE;
104:

Line 103: l_trx_status wsh_transactions_history.transaction_status%TYPE;

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