APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_TRANSACTIONS_HISTORY

Line 20: l_trns_history_rec IN wsh_transactions_history_pkg.txns_history_record_type,

16: --
17: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PROCESS_INTERFACED_PKG';
18: --
19: PROCEDURE process_inbound (
20: l_trns_history_rec IN wsh_transactions_history_pkg.txns_history_record_type,
21: x_return_status OUT NOCOPY VARCHAR2
22: )
23: IS
24:

Line 90: FROM wsh_transactions_history wth1,

86: wth3.attribute12,
87: wth3.attribute13,
88: wth3.attribute14,
89: wth3.attribute15
90: FROM wsh_transactions_history wth1,
91: wsh_transactions_history wth2,
92: wsh_transactions_history wth3
93: WHERE
94: wth2.entity_number = v_entity_number

Line 91: wsh_transactions_history wth2,

87: wth3.attribute13,
88: wth3.attribute14,
89: wth3.attribute15
90: FROM wsh_transactions_history wth1,
91: wsh_transactions_history wth2,
92: wsh_transactions_history wth3
93: WHERE
94: wth2.entity_number = v_entity_number
95: AND wth2.document_direction = 'I'

Line 92: wsh_transactions_history wth3

88: wth3.attribute14,
89: wth3.attribute15
90: FROM wsh_transactions_history wth1,
91: wsh_transactions_history wth2,
92: wsh_transactions_history wth3
93: WHERE
94: wth2.entity_number = v_entity_number
95: AND wth2.document_direction = 'I'
96: AND wth2.document_type = 'SA'

Line 286: UPDATE wsh_transactions_history

282: END IF;
283:
284: -- Update done only for 'SR' because , for 'SA', update
285: -- done in ship_advice_pkg
286: UPDATE wsh_transactions_history
287: SET transaction_status = 'SC',
288: entity_number = x_delivery_id,
289: entity_type = 'DLVY'
290: WHERE entity_type = 'DLVY_INT'

Line 310: UPDATE wsh_transactions_history

306: wsh_debug_sv.log (l_module_name, 'Ship Request or Advice error');
307: END IF;
308: -- Update done only for 'SR' because , for 'SA', update
309: -- done in ship_advice_pkg
310: UPDATE wsh_transactions_history
311: SET transaction_status = 'ER'
312: WHERE entity_type = 'DLVY_INT'
313: AND entity_number = to_char(l_delivery_interface_id)
314: AND document_type = 'SR';

Line 393: UPDATE wsh_transactions_history

389: ELSE
390: x_return_status := wsh_util_core.g_ret_sts_error;
391: -- Derive_ids returned error. Some validation has failed.
392: --Need to update the status to Error. Otherwise, status will continue to 'IP'
393: UPDATE wsh_transactions_history
394: SET transaction_status = 'ER'
395: WHERE entity_type = 'DLVY_INT'
396: AND entity_number = to_char(l_delivery_interface_id)
397: AND document_type IN ('SR', 'SA');

Line 1720: l_transaction_status wsh_transactions_history.transaction_status%TYPE;

1716: p_delivery_interface_id IN NUMBER,
1717: x_return_status OUT NOCOPY VARCHAR2
1718: )
1719: IS
1720: l_transaction_status wsh_transactions_history.transaction_status%TYPE;
1721: invalid_delete EXCEPTION;
1722: invalid_delivery EXCEPTION;
1723:
1724: CURSOR detail_interface_ids