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_MDS_INTERNAL dependencies on JDR_ATTRIBUTES

Line 52: jdr_components, jdr_attributes

48: comp_use,
49: att_name,
50: att_value
51: FROM
52: jdr_components, jdr_attributes
53: WHERE
54: comp_docid = docid AND
55: comp_docid = att_comp_docid(+) AND
56: comp_seq = att_comp_seq(+)

Line 82: jdr_paths, jdr_components, jdr_attributes

78: comp_use,
79: att_name,
80: att_value
81: FROM
82: jdr_paths, jdr_components, jdr_attributes
83: WHERE
84: path_docid IN
85: (SELECT
86: path_docid

Line 114: jdr_attributes_trans

110: atl_comp_ref,
111: atl_name,
112: atl_value
113: FROM
114: jdr_attributes_trans
115: WHERE
116: atl_comp_docid IN (SELECT path_docid FROM jdr_paths
117: START WITH path_docid = docID
118: CONNECT BY PRIOR path_docid=path_owner_docid) AND

Line 143: TYPE attnametab IS TABLE OF jdr_attributes.att_name%TYPE;

139: TYPE compidtab IS TABLE OF jdr_components.comp_id%TYPE;
140: TYPE compreftab IS TABLE OF jdr_components.comp_ref%TYPE;
141: TYPE compextendstab IS TABLE OF jdr_components.comp_extends%TYPE;
142: TYPE compusetab IS TABLE OF jdr_components.comp_use%TYPE;
143: TYPE attnametab IS TABLE OF jdr_attributes.att_name%TYPE;
144: TYPE attvaluetab IS TABLE OF jdr_attributes.att_value%TYPE;
145: TYPE varchar64tab IS TABLE OF VARCHAR2(64) INDEX BY BINARY_INTEGER;
146:
147: mStack CharArray := NULL;

Line 144: TYPE attvaluetab IS TABLE OF jdr_attributes.att_value%TYPE;

140: TYPE compreftab IS TABLE OF jdr_components.comp_ref%TYPE;
141: TYPE compextendstab IS TABLE OF jdr_components.comp_extends%TYPE;
142: TYPE compusetab IS TABLE OF jdr_components.comp_use%TYPE;
143: TYPE attnametab IS TABLE OF jdr_attributes.att_name%TYPE;
144: TYPE attvaluetab IS TABLE OF jdr_attributes.att_value%TYPE;
145: TYPE varchar64tab IS TABLE OF VARCHAR2(64) INDEX BY BINARY_INTEGER;
146:
147: mStack CharArray := NULL;
148: mPackageNames CharArray := NULL;

Line 224: attname jdr_attributes.att_name%TYPE,

220: compid jdr_components.comp_id%TYPE,
221: compref jdr_components.comp_ref%TYPE,
222: compextends jdr_components.comp_extends%TYPE,
223: compuse jdr_components.comp_use%TYPE,
224: attname jdr_attributes.att_name%TYPE,
225: attvalue jdr_attributes.att_value%TYPE,
226: formatted BOOLEAN DEFAULT TRUE)
227: IS
228: adjLevel INTEGER;

Line 225: attvalue jdr_attributes.att_value%TYPE,

221: compref jdr_components.comp_ref%TYPE,
222: compextends jdr_components.comp_extends%TYPE,
223: compuse jdr_components.comp_use%TYPE,
224: attname jdr_attributes.att_name%TYPE,
225: attvalue jdr_attributes.att_value%TYPE,
226: formatted BOOLEAN DEFAULT TRUE)
227: IS
228: adjLevel INTEGER;
229: BEGIN

Line 672: DELETE jdr_attributes WHERE att_comp_docid IN

668: isDrop BOOLEAN DEFAULT FALSE)
669: IS
670: BEGIN
671: -- Delete the attributes of the document
672: DELETE jdr_attributes WHERE att_comp_docid IN
673: (SELECT path_docid FROM jdr_paths
674: START WITH path_docid = docid
675: CONNECT BY PRIOR path_docid=path_owner_docid);
676:

Line 1337: baseLanguage jdr_attributes.att_value%TYPE;

1333: r_trans c_trans%ROWTYPE;
1334: docID jdr_paths.path_docid%TYPE;
1335: chunk VARCHAR2(32000);
1336: newxml VARCHAR2(32000);
1337: baseLanguage jdr_attributes.att_value%TYPE;
1338: compref VARCHAR2(400);
1339: source jdr_attributes.att_value%TYPE;
1340: dotpos INTEGER;
1341: BEGIN

Line 1339: source jdr_attributes.att_value%TYPE;

1335: chunk VARCHAR2(32000);
1336: newxml VARCHAR2(32000);
1337: baseLanguage jdr_attributes.att_value%TYPE;
1338: compref VARCHAR2(400);
1339: source jdr_attributes.att_value%TYPE;
1340: dotpos INTEGER;
1341: BEGIN
1342: -- Assume that the document will fit in this 32k chunk
1343: exportFinished := 1;

Line 1354: SELECT att_value INTO baseLanguage FROM jdr_attributes

1350:
1351: -- Retrieve the base language. This is the same query which is
1352: -- executed in DBAccess.getBaseDevelopmentLanguage
1353: BEGIN
1354: SELECT att_value INTO baseLanguage FROM jdr_attributes
1355: WHERE att_comp_docid = docID AND
1356: att_name = 'xml:lang' AND
1357: att_comp_seq = 0;
1358: EXCEPTION

Line 1427: jdr_components, jdr_attributes source, jdr_attributes custs

1423: -- #(3258371) Get the source for customization documents as well.
1424: SELECT
1425: source.att_value INTO source
1426: FROM
1427: jdr_components, jdr_attributes source, jdr_attributes custs
1428: WHERE
1429: source.att_comp_docid = r_trans.atl_comp_docid AND
1430: comp_docid = r_trans.atl_comp_docid AND
1431: custs.att_comp_docid = r_trans.atl_comp_docid AND

Line 1479: jdr_components, jdr_attributes source, jdr_attributes custs

1475:
1476: SELECT
1477: DISTINCT source.att_value INTO source
1478: FROM
1479: jdr_components, jdr_attributes source, jdr_attributes custs
1480: WHERE
1481: source.att_comp_docid = r_trans.atl_comp_docid AND
1482: comp_docid = r_trans.atl_comp_docid AND
1483: custs.att_comp_docid = r_trans.atl_comp_docid AND

Line 1506: NOT EXISTS (SELECT att_name FROM jdr_attributes

1502: ) OR
1503: (
1504: viewCompRef IS NULL AND
1505: comp_element IN ('view', 'modify') AND
1506: NOT EXISTS (SELECT att_name FROM jdr_attributes
1507: WHERE att_comp_docid = r_trans.atl_comp_docid AND
1508: att_comp_seq = comp_seq AND
1509: att_name = 'element')
1510: )

Line 2103: FROM jdr_attributes, jdr_paths

2099: att_comp_seq,
2100: att_seq,
2101: att_name
2102: FROM (SELECT path_docid
2103: FROM jdr_attributes, jdr_paths
2104: WHERE path_docid = att_comp_docid AND
2105: path_name = baseName AND
2106: att_comp_seq = 0 AND
2107: att_name = 'customizes' AND

Line 2109: jdr_attributes, jdr_components

2105: path_name = baseName AND
2106: att_comp_seq = 0 AND
2107: att_name = 'customizes' AND
2108: att_value = fullName) docids,
2109: jdr_attributes, jdr_components
2110: WHERE att_comp_docid = docids.path_docid AND
2111: att_comp_docid = comp_docid AND
2112: att_comp_seq = comp_seq AND
2113: att_name IN ('element', 'before', 'after', 'parent') AND

Line 2123: FROM jdr_attributes, jdr_paths

2119: CURSOR c_translations(fullName VARCHAR2, baseName VARCHAR2, compID VARCHAR2) IS
2120: SELECT atl_comp_docid,
2121: atl_comp_ref
2122: FROM (SELECT path_docid
2123: FROM jdr_attributes, jdr_paths
2124: WHERE path_docid = att_comp_docid AND
2125: path_name = baseName AND
2126: att_comp_seq = 0 AND
2127: att_name = 'customizes' AND

Line 2129: jdr_attributes_trans

2125: path_name = baseName AND
2126: att_comp_seq = 0 AND
2127: att_name = 'customizes' AND
2128: att_value = fullName) docids,
2129: jdr_attributes_trans
2130: WHERE atl_comp_docid = docids.path_docid AND
2131: (atl_comp_ref = compID OR atl_comp_ref like ':%.'||compID);
2132:
2133: -- Retrieve all of the customization documents which customize the

Line 2137: FROM jdr_attributes, jdr_paths

2133: -- Retrieve all of the customization documents which customize the
2134: -- specified base document.
2135: CURSOR c_documents(fullName VARCHAR2, baseName VARCHAR2) IS
2136: SELECT path_docid, created_by, jdr_mds_internal.getDocumentName(path_docid)
2137: FROM jdr_attributes, jdr_paths
2138: WHERE path_docid = att_comp_docid AND
2139: path_name = baseName AND
2140: att_comp_seq = 0 AND
2141: att_name = 'customizes' AND

Line 2154: attCompSeq jdr_attributes.att_comp_seq%TYPE;

2150: oldCompName jdr_components.comp_id%TYPE;
2151: newCompName jdr_components.comp_id%TYPE;
2152: docID jdr_paths.path_docid%TYPE;
2153: ownerID jdr_paths.path_docid%TYPE;
2154: attCompSeq jdr_attributes.att_comp_seq%TYPE;
2155: attSeq jdr_attributes.att_seq%TYPE;
2156: attName jdr_attributes.att_name%TYPE;
2157: oldCompRef jdr_attributes_trans.atl_comp_ref%TYPE;
2158: newCompRef jdr_attributes_trans.atl_comp_ref%TYPE;

Line 2155: attSeq jdr_attributes.att_seq%TYPE;

2151: newCompName jdr_components.comp_id%TYPE;
2152: docID jdr_paths.path_docid%TYPE;
2153: ownerID jdr_paths.path_docid%TYPE;
2154: attCompSeq jdr_attributes.att_comp_seq%TYPE;
2155: attSeq jdr_attributes.att_seq%TYPE;
2156: attName jdr_attributes.att_name%TYPE;
2157: oldCompRef jdr_attributes_trans.atl_comp_ref%TYPE;
2158: newCompRef jdr_attributes_trans.atl_comp_ref%TYPE;
2159: username jdr_paths.created_by%TYPE;

Line 2156: attName jdr_attributes.att_name%TYPE;

2152: docID jdr_paths.path_docid%TYPE;
2153: ownerID jdr_paths.path_docid%TYPE;
2154: attCompSeq jdr_attributes.att_comp_seq%TYPE;
2155: attSeq jdr_attributes.att_seq%TYPE;
2156: attName jdr_attributes.att_name%TYPE;
2157: oldCompRef jdr_attributes_trans.atl_comp_ref%TYPE;
2158: newCompRef jdr_attributes_trans.atl_comp_ref%TYPE;
2159: username jdr_paths.created_by%TYPE;
2160: oldPeriodPos INTEGER;

Line 2157: oldCompRef jdr_attributes_trans.atl_comp_ref%TYPE;

2153: ownerID jdr_paths.path_docid%TYPE;
2154: attCompSeq jdr_attributes.att_comp_seq%TYPE;
2155: attSeq jdr_attributes.att_seq%TYPE;
2156: attName jdr_attributes.att_name%TYPE;
2157: oldCompRef jdr_attributes_trans.atl_comp_ref%TYPE;
2158: newCompRef jdr_attributes_trans.atl_comp_ref%TYPE;
2159: username jdr_paths.created_by%TYPE;
2160: oldPeriodPos INTEGER;
2161: newPeriodPos INTEGER;

Line 2158: newCompRef jdr_attributes_trans.atl_comp_ref%TYPE;

2154: attCompSeq jdr_attributes.att_comp_seq%TYPE;
2155: attSeq jdr_attributes.att_seq%TYPE;
2156: attName jdr_attributes.att_name%TYPE;
2157: oldCompRef jdr_attributes_trans.atl_comp_ref%TYPE;
2158: newCompRef jdr_attributes_trans.atl_comp_ref%TYPE;
2159: username jdr_paths.created_by%TYPE;
2160: oldPeriodPos INTEGER;
2161: newPeriodPos INTEGER;
2162: slashPos INTEGER;

Line 2216: UPDATE jdr_attributes SET att_value = newCompName

2212: CLOSE c_attributes;
2213: EXIT;
2214: END IF;
2215:
2216: UPDATE jdr_attributes SET att_value = newCompName
2217: WHERE att_comp_docid = docID AND
2218: att_comp_seq = attCompSeq AND
2219: att_seq = attSeq AND
2220: att_name = attName;

Line 2244: UPDATE jdr_attributes_trans SET atl_comp_ref = newCompRef

2240: ELSE
2241: newCompRef := newCompName;
2242: END IF;
2243:
2244: UPDATE jdr_attributes_trans SET atl_comp_ref = newCompRef
2245: WHERE atl_comp_docid = docID AND
2246: atl_comp_ref = oldCompRef;
2247:
2248: changesMade := changesMade + 1;

Line 2391: UPDATE jdr_attributes

2387: END;
2388:
2389: -- Make the necessary changes to the customization documents, replacing
2390: -- the customizes attribute with the new base document name.
2391: UPDATE jdr_attributes
2392: SET att_value = newDocName
2393: WHERE att_comp_docid = docID AND
2394: att_comp_seq = 0 AND
2395: att_name = 'customizes' AND

Line 2401: UPDATE jdr_attributes

2397:
2398: -- #(3456035) Modify the package attribute if the document has been
2399: -- moved to a new package
2400: IF (RTRIM(p_oldName, oldBaseName) <> RTRIM(p_newName, newBaseName)) THEN
2401: UPDATE jdr_attributes
2402: SET att_value = REPLACE(newCustDocName, '/'||newBaseName)
2403: WHERE att_comp_docid = docID AND
2404: att_comp_seq = 0 AND
2405: att_name = 'package';