[Home] [Help]
PACKAGE: APPS.WSH_DELIVERY_LINES_DPW_V_PKG
Source
1 PACKAGE WSH_DELIVERY_LINES_DPW_V_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHDLNHS.pls 115.0 99/07/16 08:18:51 porting ship $ */
3
4 -- This package is required to lock and update the delivery lines' info for
5 -- the Departure Planning Workbench.
6 -- Because the delivery lines consist of rows from SO_LINE_DETAILS and
7 -- SO_PICKING_LINE_DETAILS, there are two Lock and Update row procedures.
8 -- The "LD" procedures update the SO_LINE_DETAILS table and the "PLD"
9 -- procedures update the SO_PICKING_LINE_DETAILS table.
10
11
12 PROCEDURE Lock_LD_Row(X_Rowid VARCHAR2,
13 X_Line_Detail_Id NUMBER,
14 X_Released_Flag VARCHAR2,
15 X_Delivery_Id NUMBER,
16 X_Departure_Id NUMBER,
17 X_Load_Seq_Number NUMBER,
18 X_Master_Container_Item_Id NUMBER,
19 X_Detail_Container_Item_Id NUMBER,
20 X_DPW_Assigned_Flag VARCHAR2,
21 X_Last_Update_Date DATE,
22 X_Last_Updated_By NUMBER,
23 X_Last_Update_Login NUMBER
24 );
25
26 PROCEDURE Update_LD_Row(X_Rowid VARCHAR2,
27 X_Delivery_Id NUMBER,
28 X_Departure_Id NUMBER,
29 X_Load_Seq_Number NUMBER,
30 X_Master_Container_Item_Id NUMBER,
31 X_Detail_Container_Item_Id NUMBER,
32 X_DPW_Assigned_Flag VARCHAR2,
33 X_Last_Update_Date DATE,
34 X_Last_Updated_By NUMBER,
35 X_Last_Update_Login NUMBER
36 );
37
38
39 PROCEDURE Lock_PLD_Row(X_Rowid VARCHAR2,
40 X_Picking_Line_Detail_Id NUMBER,
41 X_Released_Flag VARCHAR2,
42 X_Delivery_Id NUMBER,
43 X_Departure_Id NUMBER,
44 X_Load_Seq_Number NUMBER,
45 X_Master_Container_Item_Id NUMBER,
46 X_Detail_Container_Item_Id NUMBER,
47 X_DPW_Assigned_Flag VARCHAR2,
48 X_Last_Update_Date DATE,
49 X_Last_Updated_By NUMBER,
50 X_Last_Update_Login NUMBER
51 );
52
53 PROCEDURE Update_PLD_Row(X_Rowid VARCHAR2,
54 X_Delivery_Id NUMBER,
55 X_Departure_Id NUMBER,
56 X_Load_Seq_Number NUMBER,
57 X_Master_Container_Item_Id NUMBER,
58 X_Detail_Container_Item_Id NUMBER,
59 X_DPW_Assigned_Flag VARCHAR2,
60 X_Last_Update_Date DATE,
61 X_Last_Updated_By NUMBER,
62 X_Last_Update_Login NUMBER
63 );
64 END WSH_DELIVERY_LINES_DPW_V_PKG;