DBA Data[Home] [Help]

APPS.OE_SO_PLN_SERVER dependencies on SO_PICKING_LINES

Line 165: FROM SO_PICKING_LINES

161: , P_Db_Warehouse_Id
162: , P_Db_Ship_To_Contact_Id
163: , P_Db_Shipment_Priority_Code
164: , P_Db_Ship_Method_Code
165: FROM SO_PICKING_LINES
166: WHERE rowid = X_Row_Id;
167:
168: P_Db_Reserved_Quantity :=
169: OE_SO_PLN_SERVER.DB_Reserved_Quantity(X_Picking_Line_Id);

Line 237: CURSOR C IS SELECT * FROM so_picking_lines

233: X_UNIT_CODE VARCHAR2,
234: X_WAREHOUSE_ID NUMBER,
235: Result OUT VARCHAR2)IS
236:
237: CURSOR C IS SELECT * FROM so_picking_lines
238: WHERE rowid = X_rowid
239: FOR UPDATE NOWAIT;
240:
241: Recinfo C%ROWTYPE;

Line 459: UPDATE so_picking_lines

455: X_WAREHOUSE_ID NUMBER
456: )IS
457:
458: BEGIN
459: UPDATE so_picking_lines
460: SET
461: ATTRIBUTE1 = X_ATTRIBUTE1,
462: ATTRIBUTE10 = X_ATTRIBUTE10,
463: ATTRIBUTE11 = X_ATTRIBUTE11,