APPS.WSH_TRANSACTIONS_HISTORY_PKG dependencies on WSH_TRANSACTIONS_HISTORY

Line 1: PACKAGE BODY WSH_TRANSACTIONS_HISTORY_PKG as

1: PACKAGE BODY WSH_TRANSACTIONS_HISTORY_PKG as
2: /* $Header: WSHTXHSB.pls 120.4 2011/12/21 10:15:02 skanduku ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRANSACTIONS_HISTORY_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRANSACTIONS_HISTORY_PKG';

1: PACKAGE BODY WSH_TRANSACTIONS_HISTORY_PKG as
2: /* $Header: WSHTXHSB.pls 120.4 2011/12/21 10:15:02 skanduku ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRANSACTIONS_HISTORY_PKG';
6: --
7:
8: PROCEDURE Create_Update_Txns_History(
9: p_txns_history_rec IN OUT NOCOPY Txns_History_Record_Type,

Line 32: FROM wsh_transactions_history

28:
29: --cursors
30: CURSOR txn_cur IS
31: SELECT transaction_id, transaction_status
32: FROM wsh_transactions_history
33: WHERE document_type = p_txns_history_rec.document_type AND
34: document_number = p_txns_history_rec.document_number AND
35: document_direction = p_txns_history_rec.document_direction AND
36: action_type = p_txns_history_rec.action_type AND

Line 54: wsh_transactions_history wth

50:
51: CURSOR c_get_del_status (v_doc_number varchar2) IS
52: SELECT wnd.status_code
53: FROM wsh_new_deliveries wnd,
54: wsh_transactions_history wth
55: WHERE wth.document_number = v_doc_number
56: AND wth.entity_type = 'DLVY'
57: AND wth.document_type = 'SR'
58: AND wth.document_direction = 'O'

Line 143: So create a new record in wsh_transactions_history');

139:
140: IF (txn_cur%NOTFOUND) THEN
141: IF l_debug_on THEN
142: wsh_debug_sv.log (l_module_name,'Record does not exist.
143: So create a new record in wsh_transactions_history');
144: wsh_debug_sv.log (l_module_name,'document_direction ',
145: p_txns_history_rec.document_direction);
146: wsh_debug_sv.log (l_module_name,'document_type ',
147: p_txns_history_rec.document_type);

Line 187: p_api_name => 'WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History',

183: WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors(
184: p_interface_errors_rec =>
185: l_loc_interface_error_rec,
186: p_msg_data => l_msg_data,
187: p_api_name => 'WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History',
188: x_return_status => l_return_status);
189:
190: wsh_util_core.api_post_call(
191: p_return_status => l_return_status,

Line 208: INSERT INTO wsh_transactions_history(

204: SELECT WSH_TRANSACTION_S.nextval
205: INTO x_transaction_id
206: FROM dual;
207:
208: INSERT INTO wsh_transactions_history(
209: TRANSACTION_ID,
210: DOCUMENT_TYPE,
211: DOCUMENT_NUMBER,
212: ORIG_DOCUMENT_NUMBER,

Line 299: wsh_debug_sv.log (l_module_name,'Record already exists. So Need to Update in wsh_transactions_history');

295: x_txns_id := x_transaction_id;
296:
297: ELSE
298: IF l_debug_on THEN
299: wsh_debug_sv.log (l_module_name,'Record already exists. So Need to Update in wsh_transactions_history');
300: END IF;
301: -- Record already exists. So Need to Update
302: -- Before Update Check for validity of status
303:

Line 319: UPDATE wsh_transactions_history

315:
316: END IF; -- if l_transaction_status checks
317:
318:
319: UPDATE wsh_transactions_history
320: SET entity_number = p_txns_history_rec.entity_number,
321: entity_type = p_txns_history_rec.entity_type,
322: transaction_status = p_txns_history_rec.transaction_status,
323: ecx_message_id = p_txns_history_rec.ecx_message_id,

Line 455: FROM wsh_transactions_history wth,

451: wth.attribute13,
452: wth.attribute14,
453: wth.attribute15,
454: wndi.client_code
455: FROM wsh_transactions_history wth,
456: wsh_new_del_interface wndi
457: WHERE wth.item_type = p_item_type
458: and wth.event_key = p_event_key
459: and wth.document_direction = p_direction

Line 645: END WSH_TRANSACTIONS_HISTORY_PKG;

641: wsh_debug_sv.pop(l_module_name,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
642: END IF;
643: END Create_Txns_History;
644:
645: END WSH_TRANSACTIONS_HISTORY_PKG;