PACKAGE: APPS.INV_TRANSACTIONS_HISTORY_PKG

Source

1 PACKAGE inv_transactions_history_pkg AUTHID CURRENT_USER as
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,
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,
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,
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
38 	);
39 
40 
41 PROCEDURE Create_Update_Txns_History(
42 	p_txns_history_rec	IN OUT NOCOPY  Txns_History_Record_Type,
43         P_xml_document_id       IN  NUMBER DEFAULT NULL,
44 	x_txns_id		OUT NOCOPY 	NUMBER,
45 	x_return_status		OUT NOCOPY 	VARCHAR2
46 	);
47 
48 PROCEDURE Get_Txns_History(
49 	p_item_type		IN	VARCHAR2,
50 	p_event_key		IN	VARCHAR2,
51 	p_direction		IN	VARCHAR2,
52 	p_document_type		IN	VARCHAR2,
53 	p_txns_history_rec	OUT NOCOPY 	Txns_History_Record_Type,
54 	x_return_status		OUT NOCOPY 	VARCHAR2
55 	);
56 
57 /* Should be deleted if not needed.
58 
59 PROCEDURE Create_Txns_History(
60 	p_transaction_id	IN	NUMBER,
61 	p_document_type		IN	VARCHAR2,
62 	p_document_direction 	IN	VARCHAR2,
63 	p_document_number 	IN	VARCHAR2,
64 	p_orig_document_number 	IN	VARCHAR2,
65 	p_entity_number		IN	VARCHAR2,
66 	p_entity_type		IN 	VARCHAR2,
67 	p_trading_partner_id 	IN	NUMBER,
68 	p_action_type 		IN	VARCHAR2,
69 	p_transaction_status 	IN	VARCHAR2,
70 	p_ecx_message_id	IN	VARCHAR2,
71 	p_event_name  		IN	VARCHAR2,
72 	p_event_key 		IN	VARCHAR2,
73 	p_item_type		IN	VARCHAR2,
74 	p_internal_control_number IN	VARCHAR2,
75 	p_document_revision     IN      NUMBER DEFAULT NULL,
76 	x_return_status		OUT NOCOPY 	VARCHAR2
77 	);
78 
79 */
80 
81 END INV_TRANSACTIONS_HISTORY_PKG;