PACKAGE: APPS.WSH_TRANSACTIONS_HISTORY_PKG

Source

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;
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         -- 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,
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,
42         client_code     VARCHAR2(10)); -- LSP PROJECT :
43 
44 
45 PROCEDURE Create_Update_Txns_History(
46 	p_txns_history_rec	IN OUT NOCOPY  Txns_History_Record_Type,
47 	x_txns_id		OUT NOCOPY 	NUMBER,
48 	x_return_status		OUT NOCOPY 	VARCHAR2
49 	);
50 
51 PROCEDURE Get_Txns_History(
52 	p_item_type		IN	VARCHAR2,
53 	p_event_key		IN	VARCHAR2,
54 	p_direction		IN	VARCHAR2,
55 	p_document_type		IN	VARCHAR2,
56 	p_txns_history_rec	OUT NOCOPY 	Txns_History_Record_Type,
57 	x_return_status		OUT NOCOPY 	VARCHAR2
58 	);
59 
60 PROCEDURE Create_Txns_History(
61 	p_transaction_id	IN	NUMBER,
62 	p_document_type		IN	VARCHAR2,
63 	p_document_direction 	IN	VARCHAR2,
64 	p_document_number 	IN	VARCHAR2,
65 	p_orig_document_number 	IN	VARCHAR2,
66 	p_entity_number		IN	VARCHAR2,
67 	p_entity_type		IN 	VARCHAR2,
68 	p_trading_partner_id 	IN	NUMBER,
69 	p_action_type 		IN	VARCHAR2,
70 	p_transaction_status 	IN	VARCHAR2,
71 	p_ecx_message_id	IN	VARCHAR2,
72 	p_event_name  		IN	VARCHAR2,
73 	p_event_key 		IN	VARCHAR2,
74 	p_item_type		IN	VARCHAR2,
75 	p_internal_control_number IN	VARCHAR2,
76 	--R12.1.1 STANDALONE PROJECT
77         p_document_revision     IN      NUMBER DEFAULT NULL,
78 	x_return_status		OUT NOCOPY 	VARCHAR2
79 	);
80 
81 END WSH_TRANSACTIONS_HISTORY_PKG;