APPS.WSH_DELIVERY_LINES_DPW_V_PKG dependencies on SO_PICKING_LINE_DETAILS

Line 7: -- SO_PICKING_LINE_DETAILS, there are two Lock and Update row procedures.

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: PROCEDURE Lock_LD_Row(X_Rowid VARCHAR2,

Line 9: -- procedures update the SO_PICKING_LINE_DETAILS table.

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: PROCEDURE Lock_LD_Row(X_Rowid VARCHAR2,
12: X_Line_Detail_Id NUMBER,
13: X_Released_Flag VARCHAR2,

Line 126: FROM so_picking_line_details

122: X_Last_Update_Login NUMBER
123: ) IS
124: CURSOR C IS
125: SELECT *
126: FROM so_picking_line_details
127: WHERE rowid = X_Rowid
128: FOR UPDATE of Picking_Line_Detail_Id NOWAIT;
129: Recinfo C%ROWTYPE;
130:

Line 193: UPDATE so_picking_line_details

189: X_Last_Updated_By NUMBER,
190: X_Last_Update_Login NUMBER
191: ) IS
192: BEGIN
193: UPDATE so_picking_line_details
194: SET
195: delivery_id = X_Delivery_Id,
196: departure_id = X_Departure_Id,
197: load_seq_number = X_Load_Seq_Number,