APPS.WSH_DELIVERY_LINES_DPW_V_PKG dependencies on SO_LINE_DETAILS

Line 6: -- Because the delivery lines consist of rows from SO_LINE_DETAILS and

2: /* $Header: WSHDLNHB.pls 115.0 99/07/16 08:18:48 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:

Line 8: -- The "LD" procedures update the SO_LINE_DETAILS table and the "PLD"

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,
12: X_Line_Detail_Id NUMBER,

Line 26: FROM so_line_details

22: X_Last_Update_Login NUMBER
23: ) IS
24: CURSOR C IS
25: SELECT *
26: FROM so_line_details
27: WHERE rowid = X_Rowid
28: FOR UPDATE of Line_Detail_Id NOWAIT;
29: Recinfo C%ROWTYPE;
30:

Line 92: UPDATE so_line_details

88: X_Last_Updated_By NUMBER,
89: X_Last_Update_Login NUMBER
90: ) IS
91: BEGIN
92: UPDATE so_line_details
93: SET
94: delivery_id = X_Delivery_Id,
95: departure_id = X_Departure_Id,
96: load_seq_number = X_Load_Seq_Number,