DBA Data[Home] [Help]

APPS.SHP_PICKING_BATCHES_PKG dependencies on DUAL

Line 64: CURSOR NEXTID IS SELECT so_picking_batches_s.nextval FROM sys.dual;

60: X_Org_Id NUMBER
61: ) IS
62: CURSOR C IS SELECT rowid FROM SO_PICKING_BATCHES_ALL
63: WHERE batch_id = X_Batch_Id;
64: CURSOR NEXTID IS SELECT so_picking_batches_s.nextval FROM sys.dual;
65: CURSOR Batch (batch_name VARCHAR2) IS
66: Select count(*) From SO_PICKING_BATCHES_ALL
67: Where NAME = batch_name;
68: userid NUMBER;