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,
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,
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:
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,