eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JDR_UTILS dependencies on JDR_PATHS

Line 33: p_type VARCHAR2 DEFAULT 'ANY') RETURN jdr_paths.path_docid%TYPE

29: -- PATH - matches (4) above
30: -- ANY - matches (1) and (2) and (3) and (4) above
31: FUNCTION getDocumentID(
32: p_document VARCHAR2,
33: p_type VARCHAR2 DEFAULT 'ANY') RETURN jdr_paths.path_docid%TYPE
34: IS
35: docID jdr_paths.path_docid%TYPE;
36: pathType jdr_paths.path_type%TYPE;
37: pathSeq jdr_paths.path_seq%TYPE;

Line 35: docID jdr_paths.path_docid%TYPE;

31: FUNCTION getDocumentID(
32: p_document VARCHAR2,
33: p_type VARCHAR2 DEFAULT 'ANY') RETURN jdr_paths.path_docid%TYPE
34: IS
35: docID jdr_paths.path_docid%TYPE;
36: pathType jdr_paths.path_type%TYPE;
37: pathSeq jdr_paths.path_seq%TYPE;
38: BEGIN
39: -- Get the ID of the document

Line 36: pathType jdr_paths.path_type%TYPE;

32: p_document VARCHAR2,
33: p_type VARCHAR2 DEFAULT 'ANY') RETURN jdr_paths.path_docid%TYPE
34: IS
35: docID jdr_paths.path_docid%TYPE;
36: pathType jdr_paths.path_type%TYPE;
37: pathSeq jdr_paths.path_seq%TYPE;
38: BEGIN
39: -- Get the ID of the document
40: docID := jdr_mds_internal.getDocumentID(p_document);

Line 37: pathSeq jdr_paths.path_seq%TYPE;

33: p_type VARCHAR2 DEFAULT 'ANY') RETURN jdr_paths.path_docid%TYPE
34: IS
35: docID jdr_paths.path_docid%TYPE;
36: pathType jdr_paths.path_type%TYPE;
37: pathSeq jdr_paths.path_seq%TYPE;
38: BEGIN
39: -- Get the ID of the document
40: docID := jdr_mds_internal.getDocumentID(p_document);
41:

Line 45: FROM jdr_paths WHERE path_docid = docID;

41:
42: -- Verify that we have found a document of the correct type
43: IF ((docID <> -1) AND (p_type <> 'ANY')) THEN
44: SELECT path_type, path_seq INTO pathType, pathSeq
45: FROM jdr_paths WHERE path_docid = docID;
46:
47: IF (p_type = 'FILE') THEN
48: -- Make sure we are dealing with a document or package file
49: IF ((pathType = 'DOCUMENT' AND pathSeq = -1) OR

Line 267: docID JDR_PATHS.PATH_DOCID%TYPE;

263: -- (i.e. '/oracle/apps/ak/attributeSets')
264: --
265: PROCEDURE deleteDocument(p_document VARCHAR2)
266: IS
267: docID JDR_PATHS.PATH_DOCID%TYPE;
268: BEGIN
269: -- Get the ID of the document
270: docID := getDocumentID(p_document, 'FILE');
271: IF (docID = -1) THEN

Line 286: FROM jdr_paths

282: PROCEDURE deleteEmptyCustomizations
283: IS
284: CURSOR c_docs IS
285: SELECT path_docid
286: FROM jdr_paths
287: WHERE jdr_mds_internal.getDocumentName(path_docid)
288: LIKE '%/customizations/%' AND
289: path_type = 'DOCUMENT';
290: CURSOR c_comps(docID JDR_COMPONENTS.COMP_DOCID%TYPE) IS

Line 300: docID JDR_PATHS.PATH_DOCID%TYPE;

296: SELECT att_name
297: FROM jdr_attributes
298: WHERE att_comp_docid = docID AND
299: att_comp_seq = compID;
300: docID JDR_PATHS.PATH_DOCID%TYPE;
301: compElem JDR_COMPONENTS.COMP_ELEMENT%TYPE;
302: attName JDR_ATTRIBUTES.ATT_NAME%TYPE;
303: compsIsEmpty BOOLEAN;
304: attsIsEmpty BOOLEAN;

Line 378: docID JDR_PATHS.PATH_DOCID%TYPE;

374: -- (i.e. '/oracle/apps')
375: --
376: PROCEDURE deletePackage(p_package VARCHAR2)
377: IS
378: docID JDR_PATHS.PATH_DOCID%TYPE;
379: contents INTEGER;
380: BEGIN
381: -- Get the ID of the document
382: docID := getDocumentID(p_package, 'PATH');

Line 390: FROM jdr_paths

386: END IF;
387:
388: -- Make sure that the package is empty
389: SELECT COUNT(*) INTO contents
390: FROM jdr_paths
391: WHERE path_owner_docid = docID;
392:
393: IF (contents <> 0) THEN
394: dbms_output.put_line('Error: Unable to delete ' || p_package ||

Line 449: p_docid jdr_paths.path_docid%TYPE,

445: -- p_compid - the ID of the component (from comp_id in the
446: -- jdr_components table
447: --
448: FUNCTION getComponentName(
449: p_docid jdr_paths.path_docid%TYPE,
450: p_compid jdr_components.comp_id%TYPE) RETURN VARCHAR2
451: IS
452: separator VARCHAR2(1) := NULL;
453: BEGIN

Line 467: p_docid jdr_paths.path_docid%TYPE) RETURN VARCHAR2

463: --
464: -- Parameters:
465: -- p_docid - the ID of the document
466: FUNCTION getDocumentName(
467: p_docid jdr_paths.path_docid%TYPE) RETURN VARCHAR2
468: IS
469: BEGIN
470: RETURN (jdr_mds_internal.getDocumentName(p_docid));
471: END;

Line 478: CURSOR cTrans(p_docID jdr_paths.path_docid%TYPE) IS

474: -- Gets all of the translations of the specified document.
475: FUNCTION getTranslations(
476: p_document VARCHAR2) RETURN translationList
477: IS
478: CURSOR cTrans(p_docID jdr_paths.path_docid%TYPE) IS
479: SELECT
480: atl_lang, atl_comp_ref, atl_name, atl_value
481: FROM
482: jdr_attributes_trans

Line 488: docID jdr_paths.path_docid%TYPE;

484: atl_comp_docid = p_docID
485: ORDER BY
486: atl_lang;
487:
488: docID jdr_paths.path_docid%TYPE;
489: trans translationList;
490: pos BINARY_INTEGER;
491: BEGIN
492: -- Get the document ID for this document

Line 531: CURSOR c_docs(docid JDR_PATHS.PATH_DOCID%TYPE) IS

527: -- Lists the contents of a package.
528: PROCEDURE listContents(p_path VARCHAR2, p_recursive BOOLEAN DEFAULT FALSE)
529: IS
530: -- Selects documents in the current directory
531: CURSOR c_docs(docid JDR_PATHS.PATH_DOCID%TYPE) IS
532: SELECT
533: jdr_mds_internal.getDocumentName(path_docid), path_type, path_seq
534: FROM
535: jdr_paths

Line 535: jdr_paths

531: CURSOR c_docs(docid JDR_PATHS.PATH_DOCID%TYPE) IS
532: SELECT
533: jdr_mds_internal.getDocumentName(path_docid), path_type, path_seq
534: FROM
535: jdr_paths
536: WHERE
537: path_owner_docid = docid AND
538: ((path_type = 'DOCUMENT' AND path_seq = -1) OR
539: (path_type = 'PACKAGE' AND (path_seq = 0 OR path_seq = -1)));

Line 542: CURSOR c_alldocs(docid JDR_PATHS.PATH_DOCID%TYPE) IS

538: ((path_type = 'DOCUMENT' AND path_seq = -1) OR
539: (path_type = 'PACKAGE' AND (path_seq = 0 OR path_seq = -1)));
540:
541: -- Selects documents in the current directory, plus its children
542: CURSOR c_alldocs(docid JDR_PATHS.PATH_DOCID%TYPE) IS
543: SELECT
544: jdr_mds_internal.getDocumentName(path_docid), path_type, path_seq
545: FROM
546: (SELECT path_docid, path_type, path_seq

Line 547: FROM jdr_paths

543: SELECT
544: jdr_mds_internal.getDocumentName(path_docid), path_type, path_seq
545: FROM
546: (SELECT path_docid, path_type, path_seq
547: FROM jdr_paths
548: START WITH path_owner_docid = docid
549: CONNECT BY PRIOR path_docid = path_owner_docid) paths
550: WHERE
551: (path_type = 'DOCUMENT' AND path_seq = -1) OR

Line 554: NOT EXISTS (SELECT * FROM jdr_paths

550: WHERE
551: (path_type = 'DOCUMENT' AND path_seq = -1) OR
552: (path_type = 'PACKAGE' AND path_seq = 0) OR
553: (path_type = 'PACKAGE' AND path_seq = -1 AND
554: NOT EXISTS (SELECT * FROM jdr_paths
555: WHERE path_owner_docid = paths.path_docid));
556:
557: docID JDR_PATHS.PATH_DOCID%TYPE;
558: pathSeq JDR_PATHS.PATH_SEQ%TYPE;

Line 557: docID JDR_PATHS.PATH_DOCID%TYPE;

553: (path_type = 'PACKAGE' AND path_seq = -1 AND
554: NOT EXISTS (SELECT * FROM jdr_paths
555: WHERE path_owner_docid = paths.path_docid));
556:
557: docID JDR_PATHS.PATH_DOCID%TYPE;
558: pathSeq JDR_PATHS.PATH_SEQ%TYPE;
559: pathType JDR_PATHS.PATH_TYPE%TYPE;
560: docname VARCHAR2(1024);
561: BEGIN

Line 558: pathSeq JDR_PATHS.PATH_SEQ%TYPE;

554: NOT EXISTS (SELECT * FROM jdr_paths
555: WHERE path_owner_docid = paths.path_docid));
556:
557: docID JDR_PATHS.PATH_DOCID%TYPE;
558: pathSeq JDR_PATHS.PATH_SEQ%TYPE;
559: pathType JDR_PATHS.PATH_TYPE%TYPE;
560: docname VARCHAR2(1024);
561: BEGIN
562: dbms_output.enable(1000000);

Line 559: pathType JDR_PATHS.PATH_TYPE%TYPE;

555: WHERE path_owner_docid = paths.path_docid));
556:
557: docID JDR_PATHS.PATH_DOCID%TYPE;
558: pathSeq JDR_PATHS.PATH_SEQ%TYPE;
559: pathType JDR_PATHS.PATH_TYPE%TYPE;
560: docname VARCHAR2(1024);
561: BEGIN
562: dbms_output.enable(1000000);
563:

Line 629: FROM jdr_paths, jdr_attributes

625: PROCEDURE listCustomizations(p_document VARCHAR2)
626: IS
627: CURSOR c(pathName VARCHAR2, docName VARCHAR2) IS
628: SELECT jdr_mds_internal.getDocumentName(path_docid)
629: FROM jdr_paths, jdr_attributes
630: WHERE path_docid = att_comp_docid AND
631: path_name = pathName AND
632: att_comp_seq = 0 AND
633: att_name = 'customizes' AND

Line 635: pathName JDR_PATHS.PATH_NAME%TYPE;

631: path_name = pathName AND
632: att_comp_seq = 0 AND
633: att_name = 'customizes' AND
634: att_value = docName;
635: pathName JDR_PATHS.PATH_NAME%TYPE;
636: oldCustName VARCHAR2(1024);
637: startDoc VARCHAR2(1024);
638: endDoc VARCHAR2(1024);
639: name VARCHAR2(1024);

Line 683: CURSOR c_languages(docid jdr_paths.path_docid%TYPE) IS

679: -- (i.e. '/oracle/apps/ak/attributeSets')
680: --
681: PROCEDURE listLanguages(p_document VARCHAR2)
682: IS
683: CURSOR c_languages(docid jdr_paths.path_docid%TYPE) IS
684: SELECT DISTINCT(atl_lang) FROM jdr_attributes_trans
685: WHERE atl_comp_docid IN (SELECT path_docid FROM jdr_paths
686: START WITH path_docid = docID
687: CONNECT BY PRIOR path_docid=path_owner_docid);

Line 685: WHERE atl_comp_docid IN (SELECT path_docid FROM jdr_paths

681: PROCEDURE listLanguages(p_document VARCHAR2)
682: IS
683: CURSOR c_languages(docid jdr_paths.path_docid%TYPE) IS
684: SELECT DISTINCT(atl_lang) FROM jdr_attributes_trans
685: WHERE atl_comp_docid IN (SELECT path_docid FROM jdr_paths
686: START WITH path_docid = docID
687: CONNECT BY PRIOR path_docid=path_owner_docid);
688:
689: lang jdr_attributes_trans.atl_lang%TYPE;

Line 690: docID jdr_paths.path_docid%TYPE;

686: START WITH path_docid = docID
687: CONNECT BY PRIOR path_docid=path_owner_docid);
688:
689: lang jdr_attributes_trans.atl_lang%TYPE;
690: docID jdr_paths.path_docid%TYPE;
691: BEGIN
692: dbms_output.enable(1000000);
693:
694: docID := getDocumentID(p_document, 'FILE');

Line 783: docID jdr_paths.path_docid%TYPE;

779: p_document VARCHAR2,
780: p_translations translationList,
781: p_commit BOOLEAN := TRUE)
782: IS
783: docID jdr_paths.path_docid%TYPE;
784: lang jdr_attributes_trans.atl_lang%TYPE;
785: pos BINARY_INTEGER;
786: dashpos BINARY_INTEGER;
787: BEGIN