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 93: FROM wsh_transactions_history wth1,

89: wth3.attribute13,
90: wth3.attribute14,
91: wth3.attribute15,
92: NULL -- LSP PROJECT : just added for dependency for client_id
93: FROM wsh_transactions_history wth1,
94: wsh_transactions_history wth2,
95: wsh_transactions_history wth3
96: WHERE
97: wth2.entity_number = v_entity_number

Line 94: wsh_transactions_history wth2,

90: wth3.attribute14,
91: wth3.attribute15,
92: NULL -- LSP PROJECT : just added for dependency for client_id
93: FROM wsh_transactions_history wth1,
94: wsh_transactions_history wth2,
95: wsh_transactions_history wth3
96: WHERE
97: wth2.entity_number = v_entity_number
98: AND wth2.document_direction = 'I'

Line 95: wsh_transactions_history wth3

91: wth3.attribute15,
92: NULL -- LSP PROJECT : just added for dependency for client_id
93: FROM wsh_transactions_history wth1,
94: wsh_transactions_history wth2,
95: wsh_transactions_history wth3
96: WHERE
97: wth2.entity_number = v_entity_number
98: AND wth2.document_direction = 'I'
99: AND wth2.document_type = 'SA'

Line 358: UPDATE wsh_transactions_history

354:
355: -- Update done only for 'SR' because , for 'SA', update
356: -- done in ship_advice_pkg
357:
358: UPDATE wsh_transactions_history
359: SET transaction_status = 'SC',
360: entity_number = x_delivery_id,
361: entity_type = 'DLVY'
362: WHERE entity_type = 'DLVY_INT'

Line 392: UPDATE wsh_transactions_history

388: IF l_debug_on THEN
389: wsh_debug_sv.log (l_module_name, 'Ship Advice error.Move to error event in workflow.');
390: END IF;
391: ELSE
392: UPDATE wsh_transactions_history
393: SET transaction_status = 'ER'
394: WHERE entity_type = 'DLVY_INT'
395: AND entity_number = to_char(l_delivery_interface_id)
396: -- TPW - Distributed changes

Line 477: UPDATE wsh_transactions_history

473: ELSE
474: x_return_status := wsh_util_core.g_ret_sts_error;
475: -- Derive_ids returned error. Some validation has failed.
476: --Need to update the status to Error. Otherwise, status will continue to 'IP'
477: UPDATE wsh_transactions_history
478: SET transaction_status = 'ER'
479: WHERE entity_type = 'DLVY_INT'
480: AND entity_number = to_char(l_delivery_interface_id)
481: AND document_type IN ('SR', 'SA');

Line 2067: l_transaction_status wsh_transactions_history.transaction_status%TYPE;

2063: p_delivery_interface_id IN NUMBER,
2064: x_return_status OUT NOCOPY VARCHAR2
2065: )
2066: IS
2067: l_transaction_status wsh_transactions_history.transaction_status%TYPE;
2068: invalid_delete EXCEPTION;
2069: invalid_delivery EXCEPTION;
2070:
2071: CURSOR detail_interface_ids