APPS.JDR_DOCBUILDER dependencies on JDR_PATHS

Line 650: FROM jdr_paths

646: 1,
647: instr(p_fullPathName, '/', -1, 1) - 1);
648: BEGIN
649: SELECT path_docid INTO pkgDocId
650: FROM jdr_paths
651: WHERE jdr_mds_internal.getDocumentName(path_docid) = pkgName AND
652: path_type = 'PACKAGE' AND
653: path_seq = 0;
654: EXCEPTION

Line 701: pathType jdr_paths.path_type%TYPE;

697: PROCEDURE deleteDocument(
698: p_fullPathName VARCHAR2)
699: IS
700: docid NUMBER;
701: pathType jdr_paths.path_type%TYPE;
702: BEGIN
703: docid := jdr_mds_internal.getDocumentID(p_fullPathName);
704: IF docid = -1
705: THEN

Line 709: FROM jdr_paths

705: THEN
706: RAISE REF_NOT_FOUND;
707: ELSE
708: SELECT path_type INTO pathType
709: FROM jdr_paths
710: WHERE path_docid = docid;
711: IF pathType = 'DOCUMENT'
712: THEN
713: jdr_mds_internal.dropDocument(docid);

Line 754: docSeq jdr_paths.path_seq%TYPE;

750: db_docid NUMBER;
751: currDoc DOC;
752: topElem ELEM;
753: seq PLS_INTEGER := 0;
754: docSeq jdr_paths.path_seq%TYPE;
755: docName jdr_paths.path_name%TYPE;
756: isDuplicate BOOLEAN;
757: BEGIN
758: -- Sort the tables such that components, attributes can be found more easily

Line 755: docName jdr_paths.path_name%TYPE;

751: currDoc DOC;
752: topElem ELEM;
753: seq PLS_INTEGER := 0;
754: docSeq jdr_paths.path_seq%TYPE;
755: docName jdr_paths.path_name%TYPE;
756: isDuplicate BOOLEAN;
757: BEGIN
758: -- Sort the tables such that components, attributes can be found more easily
759: sortAttributesTable();

Line 803: FROM jdr_paths

799: docName := substr(currDoc.fullPath,
800: instr(currDoc.fullPath, '/', -1, 1) + 1);
801: BEGIN
802: SELECT path_seq INTO docSeq
803: FROM jdr_paths
804: WHERE path_name = docName AND
805: path_owner_docid = currDoc.parentId;
806: isDuplicate := TRUE;
807: EXCEPTION

Line 811: FROM jdr_paths

807: EXCEPTION
808: -- The document is unique
809: WHEN NO_DATA_FOUND THEN
810: SELECT max(path_seq) INTO docSeq
811: FROM jdr_paths
812: WHERE path_owner_docid = currDoc.parentId;
813: docSeq := docSeq + 1;
814: isDuplicate := FALSE;
815: END;