1: PACKAGE WSH_TRANSACTIONS_HISTORY_PKG AUTHID CURRENT_USER as
2: /* $Header: WSHTXHSS.pls 120.0.12010000.3 2009/12/03 10:26:42 mvudugul ship $ */
3:
4: C_SDEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL1;
5: C_DEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL2;
5: C_DEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL2;
6:
7: TYPE Txns_History_Record_Type is RECORD
8: (
9: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
10: document_type WSH_TRANSACTIONS_HISTORY.document_type%TYPE,
11: document_direction WSH_TRANSACTIONS_HISTORY.document_direction%TYPE,
12: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
13: orig_document_number WSH_TRANSACTIONS_HISTORY.orig_document_number%TYPE,
6:
7: TYPE Txns_History_Record_Type is RECORD
8: (
9: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
10: document_type WSH_TRANSACTIONS_HISTORY.document_type%TYPE,
11: document_direction WSH_TRANSACTIONS_HISTORY.document_direction%TYPE,
12: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
13: orig_document_number WSH_TRANSACTIONS_HISTORY.orig_document_number%TYPE,
14: entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE,
7: TYPE Txns_History_Record_Type is RECORD
8: (
9: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
10: document_type WSH_TRANSACTIONS_HISTORY.document_type%TYPE,
11: document_direction WSH_TRANSACTIONS_HISTORY.document_direction%TYPE,
12: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
13: orig_document_number WSH_TRANSACTIONS_HISTORY.orig_document_number%TYPE,
14: entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE,
15: entity_type WSH_TRANSACTIONS_HISTORY.entity_type%TYPE,
8: (
9: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
10: document_type WSH_TRANSACTIONS_HISTORY.document_type%TYPE,
11: document_direction WSH_TRANSACTIONS_HISTORY.document_direction%TYPE,
12: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
13: orig_document_number WSH_TRANSACTIONS_HISTORY.orig_document_number%TYPE,
14: entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE,
15: entity_type WSH_TRANSACTIONS_HISTORY.entity_type%TYPE,
16: trading_partner_id WSH_TRANSACTIONS_HISTORY.trading_partner_id%TYPE,
9: transaction_id WSH_TRANSACTIONS_HISTORY.transaction_id%TYPE,
10: document_type WSH_TRANSACTIONS_HISTORY.document_type%TYPE,
11: document_direction WSH_TRANSACTIONS_HISTORY.document_direction%TYPE,
12: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
13: orig_document_number WSH_TRANSACTIONS_HISTORY.orig_document_number%TYPE,
14: entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE,
15: entity_type WSH_TRANSACTIONS_HISTORY.entity_type%TYPE,
16: trading_partner_id WSH_TRANSACTIONS_HISTORY.trading_partner_id%TYPE,
17: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
10: document_type WSH_TRANSACTIONS_HISTORY.document_type%TYPE,
11: document_direction WSH_TRANSACTIONS_HISTORY.document_direction%TYPE,
12: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
13: orig_document_number WSH_TRANSACTIONS_HISTORY.orig_document_number%TYPE,
14: entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE,
15: entity_type WSH_TRANSACTIONS_HISTORY.entity_type%TYPE,
16: trading_partner_id WSH_TRANSACTIONS_HISTORY.trading_partner_id%TYPE,
17: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
18: transaction_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
11: document_direction WSH_TRANSACTIONS_HISTORY.document_direction%TYPE,
12: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
13: orig_document_number WSH_TRANSACTIONS_HISTORY.orig_document_number%TYPE,
14: entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE,
15: entity_type WSH_TRANSACTIONS_HISTORY.entity_type%TYPE,
16: trading_partner_id WSH_TRANSACTIONS_HISTORY.trading_partner_id%TYPE,
17: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
18: transaction_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
19: ecx_message_id WSH_TRANSACTIONS_HISTORY.ecx_message_id%TYPE,
12: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
13: orig_document_number WSH_TRANSACTIONS_HISTORY.orig_document_number%TYPE,
14: entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE,
15: entity_type WSH_TRANSACTIONS_HISTORY.entity_type%TYPE,
16: trading_partner_id WSH_TRANSACTIONS_HISTORY.trading_partner_id%TYPE,
17: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
18: transaction_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
19: ecx_message_id WSH_TRANSACTIONS_HISTORY.ecx_message_id%TYPE,
20: event_name WSH_TRANSACTIONS_HISTORY.event_name%TYPE,
13: orig_document_number WSH_TRANSACTIONS_HISTORY.orig_document_number%TYPE,
14: entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE,
15: entity_type WSH_TRANSACTIONS_HISTORY.entity_type%TYPE,
16: trading_partner_id WSH_TRANSACTIONS_HISTORY.trading_partner_id%TYPE,
17: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
18: transaction_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
19: ecx_message_id WSH_TRANSACTIONS_HISTORY.ecx_message_id%TYPE,
20: event_name WSH_TRANSACTIONS_HISTORY.event_name%TYPE,
21: event_key WSH_TRANSACTIONS_HISTORY.event_key%TYPE,
14: entity_number WSH_TRANSACTIONS_HISTORY.entity_number%TYPE,
15: entity_type WSH_TRANSACTIONS_HISTORY.entity_type%TYPE,
16: trading_partner_id WSH_TRANSACTIONS_HISTORY.trading_partner_id%TYPE,
17: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
18: transaction_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
19: ecx_message_id WSH_TRANSACTIONS_HISTORY.ecx_message_id%TYPE,
20: event_name WSH_TRANSACTIONS_HISTORY.event_name%TYPE,
21: event_key WSH_TRANSACTIONS_HISTORY.event_key%TYPE,
22: item_type WSH_TRANSACTIONS_HISTORY.item_type%TYPE,
15: entity_type WSH_TRANSACTIONS_HISTORY.entity_type%TYPE,
16: trading_partner_id WSH_TRANSACTIONS_HISTORY.trading_partner_id%TYPE,
17: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
18: transaction_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
19: ecx_message_id WSH_TRANSACTIONS_HISTORY.ecx_message_id%TYPE,
20: event_name WSH_TRANSACTIONS_HISTORY.event_name%TYPE,
21: event_key WSH_TRANSACTIONS_HISTORY.event_key%TYPE,
22: item_type WSH_TRANSACTIONS_HISTORY.item_type%TYPE,
23: internal_control_number WSH_TRANSACTIONS_HISTORY.internal_control_number%TYPE,
16: trading_partner_id WSH_TRANSACTIONS_HISTORY.trading_partner_id%TYPE,
17: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
18: transaction_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
19: ecx_message_id WSH_TRANSACTIONS_HISTORY.ecx_message_id%TYPE,
20: event_name WSH_TRANSACTIONS_HISTORY.event_name%TYPE,
21: event_key WSH_TRANSACTIONS_HISTORY.event_key%TYPE,
22: item_type WSH_TRANSACTIONS_HISTORY.item_type%TYPE,
23: internal_control_number WSH_TRANSACTIONS_HISTORY.internal_control_number%TYPE,
24: -- R12.1.1 STANDALONE PROJECT
17: action_type WSH_TRANSACTIONS_HISTORY.action_type%TYPE,
18: transaction_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
19: ecx_message_id WSH_TRANSACTIONS_HISTORY.ecx_message_id%TYPE,
20: event_name WSH_TRANSACTIONS_HISTORY.event_name%TYPE,
21: event_key WSH_TRANSACTIONS_HISTORY.event_key%TYPE,
22: item_type WSH_TRANSACTIONS_HISTORY.item_type%TYPE,
23: internal_control_number WSH_TRANSACTIONS_HISTORY.internal_control_number%TYPE,
24: -- R12.1.1 STANDALONE PROJECT
25: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
18: transaction_status WSH_TRANSACTIONS_HISTORY.transaction_status%TYPE,
19: ecx_message_id WSH_TRANSACTIONS_HISTORY.ecx_message_id%TYPE,
20: event_name WSH_TRANSACTIONS_HISTORY.event_name%TYPE,
21: event_key WSH_TRANSACTIONS_HISTORY.event_key%TYPE,
22: item_type WSH_TRANSACTIONS_HISTORY.item_type%TYPE,
23: internal_control_number WSH_TRANSACTIONS_HISTORY.internal_control_number%TYPE,
24: -- R12.1.1 STANDALONE PROJECT
25: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
26: attribute_category WSH_TRANSACTIONS_HISTORY.attribute_category%TYPE,
19: ecx_message_id WSH_TRANSACTIONS_HISTORY.ecx_message_id%TYPE,
20: event_name WSH_TRANSACTIONS_HISTORY.event_name%TYPE,
21: event_key WSH_TRANSACTIONS_HISTORY.event_key%TYPE,
22: item_type WSH_TRANSACTIONS_HISTORY.item_type%TYPE,
23: internal_control_number WSH_TRANSACTIONS_HISTORY.internal_control_number%TYPE,
24: -- R12.1.1 STANDALONE PROJECT
25: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
26: attribute_category WSH_TRANSACTIONS_HISTORY.attribute_category%TYPE,
27: attribute1 WSH_TRANSACTIONS_HISTORY.attribute1%TYPE,
21: event_key WSH_TRANSACTIONS_HISTORY.event_key%TYPE,
22: item_type WSH_TRANSACTIONS_HISTORY.item_type%TYPE,
23: internal_control_number WSH_TRANSACTIONS_HISTORY.internal_control_number%TYPE,
24: -- R12.1.1 STANDALONE PROJECT
25: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
26: attribute_category WSH_TRANSACTIONS_HISTORY.attribute_category%TYPE,
27: attribute1 WSH_TRANSACTIONS_HISTORY.attribute1%TYPE,
28: attribute2 WSH_TRANSACTIONS_HISTORY.attribute2%TYPE,
29: attribute3 WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
22: item_type WSH_TRANSACTIONS_HISTORY.item_type%TYPE,
23: internal_control_number WSH_TRANSACTIONS_HISTORY.internal_control_number%TYPE,
24: -- R12.1.1 STANDALONE PROJECT
25: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
26: attribute_category WSH_TRANSACTIONS_HISTORY.attribute_category%TYPE,
27: attribute1 WSH_TRANSACTIONS_HISTORY.attribute1%TYPE,
28: attribute2 WSH_TRANSACTIONS_HISTORY.attribute2%TYPE,
29: attribute3 WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
30: attribute4 WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
23: internal_control_number WSH_TRANSACTIONS_HISTORY.internal_control_number%TYPE,
24: -- R12.1.1 STANDALONE PROJECT
25: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
26: attribute_category WSH_TRANSACTIONS_HISTORY.attribute_category%TYPE,
27: attribute1 WSH_TRANSACTIONS_HISTORY.attribute1%TYPE,
28: attribute2 WSH_TRANSACTIONS_HISTORY.attribute2%TYPE,
29: attribute3 WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
30: attribute4 WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
31: attribute5 WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
24: -- R12.1.1 STANDALONE PROJECT
25: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
26: attribute_category WSH_TRANSACTIONS_HISTORY.attribute_category%TYPE,
27: attribute1 WSH_TRANSACTIONS_HISTORY.attribute1%TYPE,
28: attribute2 WSH_TRANSACTIONS_HISTORY.attribute2%TYPE,
29: attribute3 WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
30: attribute4 WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
31: attribute5 WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
32: attribute6 WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
25: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
26: attribute_category WSH_TRANSACTIONS_HISTORY.attribute_category%TYPE,
27: attribute1 WSH_TRANSACTIONS_HISTORY.attribute1%TYPE,
28: attribute2 WSH_TRANSACTIONS_HISTORY.attribute2%TYPE,
29: attribute3 WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
30: attribute4 WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
31: attribute5 WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
32: attribute6 WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
33: attribute7 WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
26: attribute_category WSH_TRANSACTIONS_HISTORY.attribute_category%TYPE,
27: attribute1 WSH_TRANSACTIONS_HISTORY.attribute1%TYPE,
28: attribute2 WSH_TRANSACTIONS_HISTORY.attribute2%TYPE,
29: attribute3 WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
30: attribute4 WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
31: attribute5 WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
32: attribute6 WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
33: attribute7 WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
34: attribute8 WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
27: attribute1 WSH_TRANSACTIONS_HISTORY.attribute1%TYPE,
28: attribute2 WSH_TRANSACTIONS_HISTORY.attribute2%TYPE,
29: attribute3 WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
30: attribute4 WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
31: attribute5 WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
32: attribute6 WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
33: attribute7 WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
34: attribute8 WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
35: attribute9 WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
28: attribute2 WSH_TRANSACTIONS_HISTORY.attribute2%TYPE,
29: attribute3 WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
30: attribute4 WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
31: attribute5 WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
32: attribute6 WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
33: attribute7 WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
34: attribute8 WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
35: attribute9 WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
36: attribute10 WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
29: attribute3 WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
30: attribute4 WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
31: attribute5 WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
32: attribute6 WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
33: attribute7 WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
34: attribute8 WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
35: attribute9 WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
36: attribute10 WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
37: attribute11 WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
30: attribute4 WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
31: attribute5 WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
32: attribute6 WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
33: attribute7 WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
34: attribute8 WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
35: attribute9 WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
36: attribute10 WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
37: attribute11 WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
38: attribute12 WSH_TRANSACTIONS_HISTORY.attribute12%TYPE,
31: attribute5 WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
32: attribute6 WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
33: attribute7 WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
34: attribute8 WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
35: attribute9 WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
36: attribute10 WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
37: attribute11 WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
38: attribute12 WSH_TRANSACTIONS_HISTORY.attribute12%TYPE,
39: attribute13 WSH_TRANSACTIONS_HISTORY.attribute13%TYPE,
32: attribute6 WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
33: attribute7 WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
34: attribute8 WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
35: attribute9 WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
36: attribute10 WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
37: attribute11 WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
38: attribute12 WSH_TRANSACTIONS_HISTORY.attribute12%TYPE,
39: attribute13 WSH_TRANSACTIONS_HISTORY.attribute13%TYPE,
40: attribute14 WSH_TRANSACTIONS_HISTORY.attribute14%TYPE,
33: attribute7 WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
34: attribute8 WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
35: attribute9 WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
36: attribute10 WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
37: attribute11 WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
38: attribute12 WSH_TRANSACTIONS_HISTORY.attribute12%TYPE,
39: attribute13 WSH_TRANSACTIONS_HISTORY.attribute13%TYPE,
40: attribute14 WSH_TRANSACTIONS_HISTORY.attribute14%TYPE,
41: attribute15 WSH_TRANSACTIONS_HISTORY.attribute15%TYPE,
34: attribute8 WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
35: attribute9 WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
36: attribute10 WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
37: attribute11 WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
38: attribute12 WSH_TRANSACTIONS_HISTORY.attribute12%TYPE,
39: attribute13 WSH_TRANSACTIONS_HISTORY.attribute13%TYPE,
40: attribute14 WSH_TRANSACTIONS_HISTORY.attribute14%TYPE,
41: attribute15 WSH_TRANSACTIONS_HISTORY.attribute15%TYPE,
42: client_code VARCHAR2(10)); -- LSP PROJECT :
35: attribute9 WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
36: attribute10 WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
37: attribute11 WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
38: attribute12 WSH_TRANSACTIONS_HISTORY.attribute12%TYPE,
39: attribute13 WSH_TRANSACTIONS_HISTORY.attribute13%TYPE,
40: attribute14 WSH_TRANSACTIONS_HISTORY.attribute14%TYPE,
41: attribute15 WSH_TRANSACTIONS_HISTORY.attribute15%TYPE,
42: client_code VARCHAR2(10)); -- LSP PROJECT :
43:
36: attribute10 WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
37: attribute11 WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
38: attribute12 WSH_TRANSACTIONS_HISTORY.attribute12%TYPE,
39: attribute13 WSH_TRANSACTIONS_HISTORY.attribute13%TYPE,
40: attribute14 WSH_TRANSACTIONS_HISTORY.attribute14%TYPE,
41: attribute15 WSH_TRANSACTIONS_HISTORY.attribute15%TYPE,
42: client_code VARCHAR2(10)); -- LSP PROJECT :
43:
44:
37: attribute11 WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
38: attribute12 WSH_TRANSACTIONS_HISTORY.attribute12%TYPE,
39: attribute13 WSH_TRANSACTIONS_HISTORY.attribute13%TYPE,
40: attribute14 WSH_TRANSACTIONS_HISTORY.attribute14%TYPE,
41: attribute15 WSH_TRANSACTIONS_HISTORY.attribute15%TYPE,
42: client_code VARCHAR2(10)); -- LSP PROJECT :
43:
44:
45: PROCEDURE Create_Update_Txns_History(
77: p_document_revision IN NUMBER DEFAULT NULL,
78: x_return_status OUT NOCOPY VARCHAR2
79: );
80:
81: END WSH_TRANSACTIONS_HISTORY_PKG;