2: /* $Header: INVTXHSS.pls 120.0.12010000.3 2010/02/03 20:32:49 musinha noship $ */
3:
4: TYPE Txns_History_Record_Type is RECORD
5: (
6: transaction_id MTL_TXNS_HISTORY.transaction_id%TYPE,
7: document_type MTL_TXNS_HISTORY.document_type%TYPE,
8: document_direction MTL_TXNS_HISTORY.document_direction%TYPE,
9: document_number MTL_TXNS_HISTORY.document_number%TYPE,
10: entity_number MTL_TXNS_HISTORY.entity_number%TYPE,
3:
4: TYPE Txns_History_Record_Type is RECORD
5: (
6: transaction_id MTL_TXNS_HISTORY.transaction_id%TYPE,
7: document_type MTL_TXNS_HISTORY.document_type%TYPE,
8: document_direction MTL_TXNS_HISTORY.document_direction%TYPE,
9: document_number MTL_TXNS_HISTORY.document_number%TYPE,
10: entity_number MTL_TXNS_HISTORY.entity_number%TYPE,
11: entity_type MTL_TXNS_HISTORY.entity_type%TYPE,
4: TYPE Txns_History_Record_Type is RECORD
5: (
6: transaction_id MTL_TXNS_HISTORY.transaction_id%TYPE,
7: document_type MTL_TXNS_HISTORY.document_type%TYPE,
8: document_direction MTL_TXNS_HISTORY.document_direction%TYPE,
9: document_number MTL_TXNS_HISTORY.document_number%TYPE,
10: entity_number MTL_TXNS_HISTORY.entity_number%TYPE,
11: entity_type MTL_TXNS_HISTORY.entity_type%TYPE,
12: trading_partner_id MTL_TXNS_HISTORY.trading_partner_id%TYPE,
5: (
6: transaction_id MTL_TXNS_HISTORY.transaction_id%TYPE,
7: document_type MTL_TXNS_HISTORY.document_type%TYPE,
8: document_direction MTL_TXNS_HISTORY.document_direction%TYPE,
9: document_number MTL_TXNS_HISTORY.document_number%TYPE,
10: entity_number MTL_TXNS_HISTORY.entity_number%TYPE,
11: entity_type MTL_TXNS_HISTORY.entity_type%TYPE,
12: trading_partner_id MTL_TXNS_HISTORY.trading_partner_id%TYPE,
13: action_type MTL_TXNS_HISTORY.action_type%TYPE,
6: transaction_id MTL_TXNS_HISTORY.transaction_id%TYPE,
7: document_type MTL_TXNS_HISTORY.document_type%TYPE,
8: document_direction MTL_TXNS_HISTORY.document_direction%TYPE,
9: document_number MTL_TXNS_HISTORY.document_number%TYPE,
10: entity_number MTL_TXNS_HISTORY.entity_number%TYPE,
11: entity_type MTL_TXNS_HISTORY.entity_type%TYPE,
12: trading_partner_id MTL_TXNS_HISTORY.trading_partner_id%TYPE,
13: action_type MTL_TXNS_HISTORY.action_type%TYPE,
14: transaction_status MTL_TXNS_HISTORY.transaction_status%TYPE,
7: document_type MTL_TXNS_HISTORY.document_type%TYPE,
8: document_direction MTL_TXNS_HISTORY.document_direction%TYPE,
9: document_number MTL_TXNS_HISTORY.document_number%TYPE,
10: entity_number MTL_TXNS_HISTORY.entity_number%TYPE,
11: entity_type MTL_TXNS_HISTORY.entity_type%TYPE,
12: trading_partner_id MTL_TXNS_HISTORY.trading_partner_id%TYPE,
13: action_type MTL_TXNS_HISTORY.action_type%TYPE,
14: transaction_status MTL_TXNS_HISTORY.transaction_status%TYPE,
15: ecx_message_id MTL_TXNS_HISTORY.ecx_message_id%TYPE,
8: document_direction MTL_TXNS_HISTORY.document_direction%TYPE,
9: document_number MTL_TXNS_HISTORY.document_number%TYPE,
10: entity_number MTL_TXNS_HISTORY.entity_number%TYPE,
11: entity_type MTL_TXNS_HISTORY.entity_type%TYPE,
12: trading_partner_id MTL_TXNS_HISTORY.trading_partner_id%TYPE,
13: action_type MTL_TXNS_HISTORY.action_type%TYPE,
14: transaction_status MTL_TXNS_HISTORY.transaction_status%TYPE,
15: ecx_message_id MTL_TXNS_HISTORY.ecx_message_id%TYPE,
16: event_name MTL_TXNS_HISTORY.event_name%TYPE,
9: document_number MTL_TXNS_HISTORY.document_number%TYPE,
10: entity_number MTL_TXNS_HISTORY.entity_number%TYPE,
11: entity_type MTL_TXNS_HISTORY.entity_type%TYPE,
12: trading_partner_id MTL_TXNS_HISTORY.trading_partner_id%TYPE,
13: action_type MTL_TXNS_HISTORY.action_type%TYPE,
14: transaction_status MTL_TXNS_HISTORY.transaction_status%TYPE,
15: ecx_message_id MTL_TXNS_HISTORY.ecx_message_id%TYPE,
16: event_name MTL_TXNS_HISTORY.event_name%TYPE,
17: event_key MTL_TXNS_HISTORY.event_key%TYPE,
10: entity_number MTL_TXNS_HISTORY.entity_number%TYPE,
11: entity_type MTL_TXNS_HISTORY.entity_type%TYPE,
12: trading_partner_id MTL_TXNS_HISTORY.trading_partner_id%TYPE,
13: action_type MTL_TXNS_HISTORY.action_type%TYPE,
14: transaction_status MTL_TXNS_HISTORY.transaction_status%TYPE,
15: ecx_message_id MTL_TXNS_HISTORY.ecx_message_id%TYPE,
16: event_name MTL_TXNS_HISTORY.event_name%TYPE,
17: event_key MTL_TXNS_HISTORY.event_key%TYPE,
18: item_type MTL_TXNS_HISTORY.item_type%TYPE,
11: entity_type MTL_TXNS_HISTORY.entity_type%TYPE,
12: trading_partner_id MTL_TXNS_HISTORY.trading_partner_id%TYPE,
13: action_type MTL_TXNS_HISTORY.action_type%TYPE,
14: transaction_status MTL_TXNS_HISTORY.transaction_status%TYPE,
15: ecx_message_id MTL_TXNS_HISTORY.ecx_message_id%TYPE,
16: event_name MTL_TXNS_HISTORY.event_name%TYPE,
17: event_key MTL_TXNS_HISTORY.event_key%TYPE,
18: item_type MTL_TXNS_HISTORY.item_type%TYPE,
19: internal_control_number MTL_TXNS_HISTORY.internal_control_number%TYPE,
12: trading_partner_id MTL_TXNS_HISTORY.trading_partner_id%TYPE,
13: action_type MTL_TXNS_HISTORY.action_type%TYPE,
14: transaction_status MTL_TXNS_HISTORY.transaction_status%TYPE,
15: ecx_message_id MTL_TXNS_HISTORY.ecx_message_id%TYPE,
16: event_name MTL_TXNS_HISTORY.event_name%TYPE,
17: event_key MTL_TXNS_HISTORY.event_key%TYPE,
18: item_type MTL_TXNS_HISTORY.item_type%TYPE,
19: internal_control_number MTL_TXNS_HISTORY.internal_control_number%TYPE,
20: document_revision MTL_TXNS_HISTORY.document_revision%TYPE,
13: action_type MTL_TXNS_HISTORY.action_type%TYPE,
14: transaction_status MTL_TXNS_HISTORY.transaction_status%TYPE,
15: ecx_message_id MTL_TXNS_HISTORY.ecx_message_id%TYPE,
16: event_name MTL_TXNS_HISTORY.event_name%TYPE,
17: event_key MTL_TXNS_HISTORY.event_key%TYPE,
18: item_type MTL_TXNS_HISTORY.item_type%TYPE,
19: internal_control_number MTL_TXNS_HISTORY.internal_control_number%TYPE,
20: document_revision MTL_TXNS_HISTORY.document_revision%TYPE,
21: attribute_category MTL_TXNS_HISTORY.attribute_category%TYPE,
14: transaction_status MTL_TXNS_HISTORY.transaction_status%TYPE,
15: ecx_message_id MTL_TXNS_HISTORY.ecx_message_id%TYPE,
16: event_name MTL_TXNS_HISTORY.event_name%TYPE,
17: event_key MTL_TXNS_HISTORY.event_key%TYPE,
18: item_type MTL_TXNS_HISTORY.item_type%TYPE,
19: internal_control_number MTL_TXNS_HISTORY.internal_control_number%TYPE,
20: document_revision MTL_TXNS_HISTORY.document_revision%TYPE,
21: attribute_category MTL_TXNS_HISTORY.attribute_category%TYPE,
22: attribute1 MTL_TXNS_HISTORY.attribute1%TYPE,
15: ecx_message_id MTL_TXNS_HISTORY.ecx_message_id%TYPE,
16: event_name MTL_TXNS_HISTORY.event_name%TYPE,
17: event_key MTL_TXNS_HISTORY.event_key%TYPE,
18: item_type MTL_TXNS_HISTORY.item_type%TYPE,
19: internal_control_number MTL_TXNS_HISTORY.internal_control_number%TYPE,
20: document_revision MTL_TXNS_HISTORY.document_revision%TYPE,
21: attribute_category MTL_TXNS_HISTORY.attribute_category%TYPE,
22: attribute1 MTL_TXNS_HISTORY.attribute1%TYPE,
23: attribute2 MTL_TXNS_HISTORY.attribute2%TYPE,
16: event_name MTL_TXNS_HISTORY.event_name%TYPE,
17: event_key MTL_TXNS_HISTORY.event_key%TYPE,
18: item_type MTL_TXNS_HISTORY.item_type%TYPE,
19: internal_control_number MTL_TXNS_HISTORY.internal_control_number%TYPE,
20: document_revision MTL_TXNS_HISTORY.document_revision%TYPE,
21: attribute_category MTL_TXNS_HISTORY.attribute_category%TYPE,
22: attribute1 MTL_TXNS_HISTORY.attribute1%TYPE,
23: attribute2 MTL_TXNS_HISTORY.attribute2%TYPE,
24: attribute3 MTL_TXNS_HISTORY.attribute3%TYPE,
17: event_key MTL_TXNS_HISTORY.event_key%TYPE,
18: item_type MTL_TXNS_HISTORY.item_type%TYPE,
19: internal_control_number MTL_TXNS_HISTORY.internal_control_number%TYPE,
20: document_revision MTL_TXNS_HISTORY.document_revision%TYPE,
21: attribute_category MTL_TXNS_HISTORY.attribute_category%TYPE,
22: attribute1 MTL_TXNS_HISTORY.attribute1%TYPE,
23: attribute2 MTL_TXNS_HISTORY.attribute2%TYPE,
24: attribute3 MTL_TXNS_HISTORY.attribute3%TYPE,
25: attribute4 MTL_TXNS_HISTORY.attribute4%TYPE,
18: item_type MTL_TXNS_HISTORY.item_type%TYPE,
19: internal_control_number MTL_TXNS_HISTORY.internal_control_number%TYPE,
20: document_revision MTL_TXNS_HISTORY.document_revision%TYPE,
21: attribute_category MTL_TXNS_HISTORY.attribute_category%TYPE,
22: attribute1 MTL_TXNS_HISTORY.attribute1%TYPE,
23: attribute2 MTL_TXNS_HISTORY.attribute2%TYPE,
24: attribute3 MTL_TXNS_HISTORY.attribute3%TYPE,
25: attribute4 MTL_TXNS_HISTORY.attribute4%TYPE,
26: attribute5 MTL_TXNS_HISTORY.attribute5%TYPE,
19: internal_control_number MTL_TXNS_HISTORY.internal_control_number%TYPE,
20: document_revision MTL_TXNS_HISTORY.document_revision%TYPE,
21: attribute_category MTL_TXNS_HISTORY.attribute_category%TYPE,
22: attribute1 MTL_TXNS_HISTORY.attribute1%TYPE,
23: attribute2 MTL_TXNS_HISTORY.attribute2%TYPE,
24: attribute3 MTL_TXNS_HISTORY.attribute3%TYPE,
25: attribute4 MTL_TXNS_HISTORY.attribute4%TYPE,
26: attribute5 MTL_TXNS_HISTORY.attribute5%TYPE,
27: attribute6 MTL_TXNS_HISTORY.attribute6%TYPE,
20: document_revision MTL_TXNS_HISTORY.document_revision%TYPE,
21: attribute_category MTL_TXNS_HISTORY.attribute_category%TYPE,
22: attribute1 MTL_TXNS_HISTORY.attribute1%TYPE,
23: attribute2 MTL_TXNS_HISTORY.attribute2%TYPE,
24: attribute3 MTL_TXNS_HISTORY.attribute3%TYPE,
25: attribute4 MTL_TXNS_HISTORY.attribute4%TYPE,
26: attribute5 MTL_TXNS_HISTORY.attribute5%TYPE,
27: attribute6 MTL_TXNS_HISTORY.attribute6%TYPE,
28: attribute7 MTL_TXNS_HISTORY.attribute7%TYPE,
21: attribute_category MTL_TXNS_HISTORY.attribute_category%TYPE,
22: attribute1 MTL_TXNS_HISTORY.attribute1%TYPE,
23: attribute2 MTL_TXNS_HISTORY.attribute2%TYPE,
24: attribute3 MTL_TXNS_HISTORY.attribute3%TYPE,
25: attribute4 MTL_TXNS_HISTORY.attribute4%TYPE,
26: attribute5 MTL_TXNS_HISTORY.attribute5%TYPE,
27: attribute6 MTL_TXNS_HISTORY.attribute6%TYPE,
28: attribute7 MTL_TXNS_HISTORY.attribute7%TYPE,
29: attribute8 MTL_TXNS_HISTORY.attribute8%TYPE,
22: attribute1 MTL_TXNS_HISTORY.attribute1%TYPE,
23: attribute2 MTL_TXNS_HISTORY.attribute2%TYPE,
24: attribute3 MTL_TXNS_HISTORY.attribute3%TYPE,
25: attribute4 MTL_TXNS_HISTORY.attribute4%TYPE,
26: attribute5 MTL_TXNS_HISTORY.attribute5%TYPE,
27: attribute6 MTL_TXNS_HISTORY.attribute6%TYPE,
28: attribute7 MTL_TXNS_HISTORY.attribute7%TYPE,
29: attribute8 MTL_TXNS_HISTORY.attribute8%TYPE,
30: attribute9 MTL_TXNS_HISTORY.attribute9%TYPE,
23: attribute2 MTL_TXNS_HISTORY.attribute2%TYPE,
24: attribute3 MTL_TXNS_HISTORY.attribute3%TYPE,
25: attribute4 MTL_TXNS_HISTORY.attribute4%TYPE,
26: attribute5 MTL_TXNS_HISTORY.attribute5%TYPE,
27: attribute6 MTL_TXNS_HISTORY.attribute6%TYPE,
28: attribute7 MTL_TXNS_HISTORY.attribute7%TYPE,
29: attribute8 MTL_TXNS_HISTORY.attribute8%TYPE,
30: attribute9 MTL_TXNS_HISTORY.attribute9%TYPE,
31: attribute10 MTL_TXNS_HISTORY.attribute10%TYPE,
24: attribute3 MTL_TXNS_HISTORY.attribute3%TYPE,
25: attribute4 MTL_TXNS_HISTORY.attribute4%TYPE,
26: attribute5 MTL_TXNS_HISTORY.attribute5%TYPE,
27: attribute6 MTL_TXNS_HISTORY.attribute6%TYPE,
28: attribute7 MTL_TXNS_HISTORY.attribute7%TYPE,
29: attribute8 MTL_TXNS_HISTORY.attribute8%TYPE,
30: attribute9 MTL_TXNS_HISTORY.attribute9%TYPE,
31: attribute10 MTL_TXNS_HISTORY.attribute10%TYPE,
32: attribute11 MTL_TXNS_HISTORY.attribute11%TYPE,
25: attribute4 MTL_TXNS_HISTORY.attribute4%TYPE,
26: attribute5 MTL_TXNS_HISTORY.attribute5%TYPE,
27: attribute6 MTL_TXNS_HISTORY.attribute6%TYPE,
28: attribute7 MTL_TXNS_HISTORY.attribute7%TYPE,
29: attribute8 MTL_TXNS_HISTORY.attribute8%TYPE,
30: attribute9 MTL_TXNS_HISTORY.attribute9%TYPE,
31: attribute10 MTL_TXNS_HISTORY.attribute10%TYPE,
32: attribute11 MTL_TXNS_HISTORY.attribute11%TYPE,
33: attribute12 MTL_TXNS_HISTORY.attribute12%TYPE,
26: attribute5 MTL_TXNS_HISTORY.attribute5%TYPE,
27: attribute6 MTL_TXNS_HISTORY.attribute6%TYPE,
28: attribute7 MTL_TXNS_HISTORY.attribute7%TYPE,
29: attribute8 MTL_TXNS_HISTORY.attribute8%TYPE,
30: attribute9 MTL_TXNS_HISTORY.attribute9%TYPE,
31: attribute10 MTL_TXNS_HISTORY.attribute10%TYPE,
32: attribute11 MTL_TXNS_HISTORY.attribute11%TYPE,
33: attribute12 MTL_TXNS_HISTORY.attribute12%TYPE,
34: attribute13 MTL_TXNS_HISTORY.attribute13%TYPE,
27: attribute6 MTL_TXNS_HISTORY.attribute6%TYPE,
28: attribute7 MTL_TXNS_HISTORY.attribute7%TYPE,
29: attribute8 MTL_TXNS_HISTORY.attribute8%TYPE,
30: attribute9 MTL_TXNS_HISTORY.attribute9%TYPE,
31: attribute10 MTL_TXNS_HISTORY.attribute10%TYPE,
32: attribute11 MTL_TXNS_HISTORY.attribute11%TYPE,
33: attribute12 MTL_TXNS_HISTORY.attribute12%TYPE,
34: attribute13 MTL_TXNS_HISTORY.attribute13%TYPE,
35: attribute14 MTL_TXNS_HISTORY.attribute14%TYPE,
28: attribute7 MTL_TXNS_HISTORY.attribute7%TYPE,
29: attribute8 MTL_TXNS_HISTORY.attribute8%TYPE,
30: attribute9 MTL_TXNS_HISTORY.attribute9%TYPE,
31: attribute10 MTL_TXNS_HISTORY.attribute10%TYPE,
32: attribute11 MTL_TXNS_HISTORY.attribute11%TYPE,
33: attribute12 MTL_TXNS_HISTORY.attribute12%TYPE,
34: attribute13 MTL_TXNS_HISTORY.attribute13%TYPE,
35: attribute14 MTL_TXNS_HISTORY.attribute14%TYPE,
36: attribute15 MTL_TXNS_HISTORY.attribute15%TYPE,
29: attribute8 MTL_TXNS_HISTORY.attribute8%TYPE,
30: attribute9 MTL_TXNS_HISTORY.attribute9%TYPE,
31: attribute10 MTL_TXNS_HISTORY.attribute10%TYPE,
32: attribute11 MTL_TXNS_HISTORY.attribute11%TYPE,
33: attribute12 MTL_TXNS_HISTORY.attribute12%TYPE,
34: attribute13 MTL_TXNS_HISTORY.attribute13%TYPE,
35: attribute14 MTL_TXNS_HISTORY.attribute14%TYPE,
36: attribute15 MTL_TXNS_HISTORY.attribute15%TYPE,
37: client_code MTL_CLIENT_PARAMETERS.client_code%TYPE
30: attribute9 MTL_TXNS_HISTORY.attribute9%TYPE,
31: attribute10 MTL_TXNS_HISTORY.attribute10%TYPE,
32: attribute11 MTL_TXNS_HISTORY.attribute11%TYPE,
33: attribute12 MTL_TXNS_HISTORY.attribute12%TYPE,
34: attribute13 MTL_TXNS_HISTORY.attribute13%TYPE,
35: attribute14 MTL_TXNS_HISTORY.attribute14%TYPE,
36: attribute15 MTL_TXNS_HISTORY.attribute15%TYPE,
37: client_code MTL_CLIENT_PARAMETERS.client_code%TYPE
38: );
31: attribute10 MTL_TXNS_HISTORY.attribute10%TYPE,
32: attribute11 MTL_TXNS_HISTORY.attribute11%TYPE,
33: attribute12 MTL_TXNS_HISTORY.attribute12%TYPE,
34: attribute13 MTL_TXNS_HISTORY.attribute13%TYPE,
35: attribute14 MTL_TXNS_HISTORY.attribute14%TYPE,
36: attribute15 MTL_TXNS_HISTORY.attribute15%TYPE,
37: client_code MTL_CLIENT_PARAMETERS.client_code%TYPE
38: );
39:
32: attribute11 MTL_TXNS_HISTORY.attribute11%TYPE,
33: attribute12 MTL_TXNS_HISTORY.attribute12%TYPE,
34: attribute13 MTL_TXNS_HISTORY.attribute13%TYPE,
35: attribute14 MTL_TXNS_HISTORY.attribute14%TYPE,
36: attribute15 MTL_TXNS_HISTORY.attribute15%TYPE,
37: client_code MTL_CLIENT_PARAMETERS.client_code%TYPE
38: );
39:
40: