DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_PKG dependencies on DUAL

Line 110: -- CURSOR NEXTID IS SELECT wsh_picking_batches_s.nextval FROM sys.dual;

106: CURSOR C IS SELECT rowid FROM WSH_PICKING_BATCHES
107: WHERE batch_id = X_Batch_Id;
108:
109: -- bug 5117876, use sequence mtl_txn_request_headers_s
110: -- CURSOR NEXTID IS SELECT wsh_picking_batches_s.nextval FROM sys.dual;
111: CURSOR NEXTID IS SELECT mtl_txn_request_headers_s.nextval FROM sys.dual;
112:
113: -- bug 5117876, add one more parameter batchid
114: /*

Line 111: CURSOR NEXTID IS SELECT mtl_txn_request_headers_s.nextval FROM sys.dual;

107: WHERE batch_id = X_Batch_Id;
108:
109: -- bug 5117876, use sequence mtl_txn_request_headers_s
110: -- CURSOR NEXTID IS SELECT wsh_picking_batches_s.nextval FROM sys.dual;
111: CURSOR NEXTID IS SELECT mtl_txn_request_headers_s.nextval FROM sys.dual;
112:
113: -- bug 5117876, add one more parameter batchid
114: /*
115: CURSOR Batch (batch_name VARCHAR2) IS