PACKAGE: APPS.WSH_TRANSACTIONS_HISTORY_PKG

Source

1 PACKAGE WSH_TRANSACTIONS_HISTORY_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHTXHSS.pls 115.2 2002/11/12 01:59:06 nparikh ship $ */
3 
4 C_SDEBUG              CONSTANT   NUMBER := wsh_debug_sv.C_LEVEL1;
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,
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,
23 	internal_control_number WSH_TRANSACTIONS_HISTORY.internal_control_number%TYPE,
24 	attribute_category 	WSH_TRANSACTIONS_HISTORY.attribute_category%TYPE,
25 	attribute1 	WSH_TRANSACTIONS_HISTORY.attribute1%TYPE,
26 	attribute2 	WSH_TRANSACTIONS_HISTORY.attribute2%TYPE,
27 	attribute3 	WSH_TRANSACTIONS_HISTORY.attribute3%TYPE,
28 	attribute4 	WSH_TRANSACTIONS_HISTORY.attribute4%TYPE,
29 	attribute5 	WSH_TRANSACTIONS_HISTORY.attribute5%TYPE,
30 	attribute6 	WSH_TRANSACTIONS_HISTORY.attribute6%TYPE,
31 	attribute7 	WSH_TRANSACTIONS_HISTORY.attribute7%TYPE,
32 	attribute8 	WSH_TRANSACTIONS_HISTORY.attribute8%TYPE,
33 	attribute9 	WSH_TRANSACTIONS_HISTORY.attribute9%TYPE,
34 	attribute10 	WSH_TRANSACTIONS_HISTORY.attribute10%TYPE,
35 	attribute11 	WSH_TRANSACTIONS_HISTORY.attribute11%TYPE,
36 	attribute12 	WSH_TRANSACTIONS_HISTORY.attribute12%TYPE,
37 	attribute13	WSH_TRANSACTIONS_HISTORY.attribute13%TYPE,
38 	attribute14 	WSH_TRANSACTIONS_HISTORY.attribute14%TYPE,
39 	attribute15 	WSH_TRANSACTIONS_HISTORY.attribute15%TYPE);
40 
41 
42 PROCEDURE Create_Update_Txns_History(
43 	p_txns_history_rec	IN OUT NOCOPY  Txns_History_Record_Type,
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 
58 PROCEDURE Create_Txns_History(
59 	p_transaction_id	IN	NUMBER,
60 	p_document_type		IN	VARCHAR2,
61 	p_document_direction 	IN	VARCHAR2,
62 	p_document_number 	IN	VARCHAR2,
63 	p_orig_document_number 	IN	VARCHAR2,
64 	p_entity_number		IN	VARCHAR2,
65 	p_entity_type		IN 	VARCHAR2,
66 	p_trading_partner_id 	IN	NUMBER,
67 	p_action_type 		IN	VARCHAR2,
68 	p_transaction_status 	IN	VARCHAR2,
69 	p_ecx_message_id	IN	VARCHAR2,
70 	p_event_name  		IN	VARCHAR2,
71 	p_event_key 		IN	VARCHAR2,
72 	p_item_type		IN	VARCHAR2,
73 	p_internal_control_number IN	VARCHAR2,
74 	x_return_status		OUT NOCOPY 	VARCHAR2
75 	);
76 
77 END WSH_TRANSACTIONS_HISTORY_PKG;