1 PACKAGE WSH_DD_TXNS_PVT AS
2 /* $Header: WSHDXTHS.pls 120.0 2005/05/26 17:48:09 appldev noship $ */
3
4 TYPE DD_Txn_Rec_Type IS RECORD
5 (DD_TXN_ID NUMBER,
6 DD_TXN_DATE DATE,
7 DELIVERY_DETAIL_ID NUMBER,
8 RELEASED_STATUS VARCHAR2(1),
9 REQUESTED_QUANTITY NUMBER,
10 REQUESTED_QUANTITY_UOM VARCHAR2(3),
11 REQUESTED_QUANTITY2 NUMBER,
12 REQUESTED_QUANTITY_UOM2 VARCHAR2(3),
13 PICKED_QUANTITY NUMBER,
14 PICKED_QUANTITY2 NUMBER,
15 ATTRIBUTE_CATEGORY VARCHAR2(150),
16 ATTRIBUTE1 VARCHAR2(150),
17 ATTRIBUTE2 VARCHAR2(150),
18 ATTRIBUTE3 VARCHAR2(150),
19 ATTRIBUTE4 VARCHAR2(150),
20 ATTRIBUTE5 VARCHAR2(150),
21 ATTRIBUTE6 VARCHAR2(150),
22 ATTRIBUTE7 VARCHAR2(150),
23 ATTRIBUTE8 VARCHAR2(150),
24 ATTRIBUTE9 VARCHAR2(150),
25 ATTRIBUTE10 VARCHAR2(150),
26 ATTRIBUTE11 VARCHAR2(150),
27 ATTRIBUTE12 VARCHAR2(150),
28 ATTRIBUTE13 VARCHAR2(150),
29 ATTRIBUTE14 VARCHAR2(150),
30 ATTRIBUTE15 VARCHAR2(150),
31 CREATION_DATE DATE,
32 CREATED_BY NUMBER,
33 LAST_UPDATE_DATE DATE,
34 LAST_UPDATED_BY NUMBER,
35 LAST_UPDATE_LOGIN NUMBER);
36
37
38 --
39 -- Procedure: Insert_DD_Txn
40 -- Parameters: All Attributes of a Delivery Detail Record,
41 -- Row_id out
42 -- DD_Txn_id out
43 -- Return_Status out
44 -- Description: This procedure will create a delivery detail transaction.
45 -- It will return to the user the dd_txn_id as a
46 -- parameter.
47
48 PROCEDURE Insert_DD_Txn(
49 p_dd_txn_info IN DD_Txn_Rec_Type,
50 x_rowid OUT NOCOPY VARCHAR2,
51 x_dd_txn_id OUT NOCOPY NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2
53 );
54
55 -- Procedure: Get_DD_Snapshot
56 -- Parameters: p_delivery_detail_id : Delivery detail id for which the record to be populated.
57 -- Description: This procedure will copy the attributes of a delivery detail in wsh_delivery_details
58 -- and copy it to a dd transaction record.
59
60 PROCEDURE Get_DD_Snapshot (p_delivery_detail_id IN NUMBER,
61 x_dd_txn_info OUT NOCOPY DD_Txn_Rec_Type,
62 x_return_status OUT NOCOPY VARCHAR2);
63
64 -- Procedure: Create_DD_txn_from_dd
65 -- Parameters: p_delivery_detail_id : Delivery detail id for which the record to be populated.
66 -- Description: This procedure will create a dd txn record with the help of passed DD_ID and
67 -- return the status along with the dd_txn_id.
68
69 PROCEDURE create_dd_txn_from_dd (p_delivery_detail_id IN NUMBER,
70 x_dd_txn_id OUT NOCOPY NUMBER,
71 x_return_status OUT NOCOPY VARCHAR2);
72
73
74
75 END WSH_DD_TXNS_PVT;