PACKAGE: APPS.RCV_TRANSACTIONS_HISTORY_PKG

Source

1 PACKAGE rcv_transactions_history_pkg AUTHID CURRENT_USER as
2 /* $Header: RCVTXHSS.pls 120.1 2010/01/26 20:09:50 vthevark noship $
3  * */
4 
5 TYPE Txns_History_Record_Type is RECORD
6 (
7         transaction_id           MTL_TXNS_HISTORY.transaction_id%TYPE,
8         document_type            MTL_TXNS_HISTORY.document_type%TYPE,
9         document_direction       MTL_TXNS_HISTORY.document_direction%TYPE,
10         document_number          MTL_TXNS_HISTORY.document_number%TYPE,
11         entity_number            MTL_TXNS_HISTORY.entity_number%TYPE,
12         entity_type              MTL_TXNS_HISTORY.entity_type%TYPE,
13         trading_partner_id       MTL_TXNS_HISTORY.trading_partner_id%TYPE,
14         action_type              MTL_TXNS_HISTORY.action_type%TYPE,
15         transaction_status       MTL_TXNS_HISTORY.transaction_status%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         document_revision        MTL_TXNS_HISTORY.document_revision%TYPE,
20         attribute_category       MTL_TXNS_HISTORY.attribute_category%TYPE,
21         attribute1               MTL_TXNS_HISTORY.attribute1%TYPE,
22         attribute2               MTL_TXNS_HISTORY.attribute2%TYPE,
23         attribute3               MTL_TXNS_HISTORY.attribute3%TYPE,
24         attribute4               MTL_TXNS_HISTORY.attribute4%TYPE,
25         attribute5               MTL_TXNS_HISTORY.attribute5%TYPE,
26         attribute6               MTL_TXNS_HISTORY.attribute6%TYPE,
27         attribute7               MTL_TXNS_HISTORY.attribute7%TYPE,
28         attribute8               MTL_TXNS_HISTORY.attribute8%TYPE,
29         attribute9               MTL_TXNS_HISTORY.attribute9%TYPE,
30         attribute10              MTL_TXNS_HISTORY.attribute10%TYPE,
31         attribute11              MTL_TXNS_HISTORY.attribute11%TYPE,
32         attribute12              MTL_TXNS_HISTORY.attribute12%TYPE,
33         attribute13              MTL_TXNS_HISTORY.attribute13%TYPE,
34         attribute14              MTL_TXNS_HISTORY.attribute14%TYPE,
35         attribute15              MTL_TXNS_HISTORY.attribute15%TYPE,
36         client_code              MTL_CLIENT_PARAMETERS.client_code%TYPE
37         );
38 
39 
40 PROCEDURE Create_Update_Txns_History(
41         p_txns_history_rec   IN OUT NOCOPY  Txns_History_Record_Type,
42         p_xml_document_id    IN          NUMBER  DEFAULT NULL,
43         x_txns_id            OUT NOCOPY  NUMBER,
44         x_return_status      OUT NOCOPY  VARCHAR2
45         );
46 
47 PROCEDURE Get_Txns_History(
48         p_item_type          IN        VARCHAR2,
49         p_event_key          IN        VARCHAR2,
50         p_direction          IN        VARCHAR2,
51         p_document_type      IN        VARCHAR2,
52         p_txns_history_rec   OUT NOCOPY   Txns_History_Record_Type,
53         x_return_status      OUT NOCOPY   VARCHAR2
54         );
55 
56 END RCV_TRANSACTIONS_HISTORY_PKG;