APPS.JDR_MDS_INTERNAL dependencies on DUAL

Line 589: SELECT jdr_document_id_s.NEXTVAL INTO docID FROM DUAL;

585: IS
586: docID JDR_PATHS.PATH_DOCID%TYPE;
587: BEGIN
588: -- Get the next document ID
589: SELECT jdr_document_id_s.NEXTVAL INTO docID FROM DUAL;
590:
591: INSERT INTO jdr_paths
592: (PATH_NAME, PATH_DOCID, PATH_OWNER_DOCID, PATH_TYPE, PATH_SEQ,
593: PATH_XML_VERSION, PATH_XML_ENCODING,

Line 1596: -- Break up the document name into the individual packages

1592: IF (INSTR(fullPath, '/', LENGTH(fullPath)) > 0) THEN
1593: fullPath := SUBSTR(fullPath, 1, LENGTH(fullPath) - 1);
1594: END IF;
1595:
1596: -- Break up the document name into the individual packages
1597: WHILE (endIdx <> 0) LOOP
1598: endIdx := INSTR(fullPath, '/');
1599: pathNames.extend;
1600: IF endIdx = 0 THEN