DBA Data[Home] [Help]

APPS.JDR_MDS_INTERNAL dependencies on JDR_DOCUMENT_ID_S

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 604: -- (1) If the sequence JDR_DOCUMENT_ID_S is corrupt (i.e. the current value

600:
601: RETURN (docID);
602: EXCEPTION
603: -- An exception can be caused by one of the following situations:
604: -- (1) If the sequence JDR_DOCUMENT_ID_S is corrupt (i.e. the current value
605: -- of the sequence is less than the maximum document ID)
606: -- (2) We are trying to insert a document whose name matches an existing
607: -- package or vice versa. For example, suppose we have a document
608: -- called:

Line 1979: -- #(2669626) If the sequence, JDR_DOCUMENT_ID_S, is corrupt (which can

1975: pathType,
1976: xmlversion,
1977: xmlencoding);
1978: EXCEPTION
1979: -- #(2669626) If the sequence, JDR_DOCUMENT_ID_S, is corrupt (which can
1980: -- happen if it gets reset), then createPath will raise a NO_DATA_FOUND
1981: -- exception.
1982: WHEN corrupt_sequence THEN
1983: raise_application_error(ERROR_CORRUPT_SEQUENCE, NULL);