DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_PKG dependencies on DUAL

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

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

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

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