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_COMPONENTS

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 135: TYPE compseqtab IS TABLE OF jdr_components.comp_seq%TYPE;

131: TYPE pathnametab IS TABLE OF VARCHAR2(400);
132: TYPE pathtypetab IS TABLE OF jdr_paths.path_type%TYPE;
133: TYPE pathseqtab IS TABLE OF jdr_paths.path_seq%TYPE;
134: TYPE pathownertab IS TABLE OF jdr_paths.path_owner_docid%TYPE;
135: TYPE compseqtab IS TABLE OF jdr_components.comp_seq%TYPE;
136: TYPE compelementtab IS TABLE OF jdr_components.comp_element%TYPE;
137: TYPE compleveltab IS TABLE OF jdr_components.comp_level%TYPE;
138: TYPE compgroupingtab IS TABLE OF jdr_components.comp_grouping%TYPE;
139: TYPE compidtab IS TABLE OF jdr_components.comp_id%TYPE;

Line 136: TYPE compelementtab IS TABLE OF jdr_components.comp_element%TYPE;

132: TYPE pathtypetab IS TABLE OF jdr_paths.path_type%TYPE;
133: TYPE pathseqtab IS TABLE OF jdr_paths.path_seq%TYPE;
134: TYPE pathownertab IS TABLE OF jdr_paths.path_owner_docid%TYPE;
135: TYPE compseqtab IS TABLE OF jdr_components.comp_seq%TYPE;
136: TYPE compelementtab IS TABLE OF jdr_components.comp_element%TYPE;
137: TYPE compleveltab IS TABLE OF jdr_components.comp_level%TYPE;
138: TYPE compgroupingtab IS TABLE OF jdr_components.comp_grouping%TYPE;
139: TYPE compidtab IS TABLE OF jdr_components.comp_id%TYPE;
140: TYPE compreftab IS TABLE OF jdr_components.comp_ref%TYPE;

Line 137: TYPE compleveltab IS TABLE OF jdr_components.comp_level%TYPE;

133: TYPE pathseqtab IS TABLE OF jdr_paths.path_seq%TYPE;
134: TYPE pathownertab IS TABLE OF jdr_paths.path_owner_docid%TYPE;
135: TYPE compseqtab IS TABLE OF jdr_components.comp_seq%TYPE;
136: TYPE compelementtab IS TABLE OF jdr_components.comp_element%TYPE;
137: TYPE compleveltab IS TABLE OF jdr_components.comp_level%TYPE;
138: TYPE compgroupingtab IS TABLE OF jdr_components.comp_grouping%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;

Line 138: TYPE compgroupingtab IS TABLE OF jdr_components.comp_grouping%TYPE;

134: TYPE pathownertab IS TABLE OF jdr_paths.path_owner_docid%TYPE;
135: TYPE compseqtab IS TABLE OF jdr_components.comp_seq%TYPE;
136: TYPE compelementtab IS TABLE OF jdr_components.comp_element%TYPE;
137: TYPE compleveltab IS TABLE OF jdr_components.comp_level%TYPE;
138: TYPE compgroupingtab IS TABLE OF jdr_components.comp_grouping%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;

Line 139: TYPE compidtab IS TABLE OF jdr_components.comp_id%TYPE;

135: TYPE compseqtab IS TABLE OF jdr_components.comp_seq%TYPE;
136: TYPE compelementtab IS TABLE OF jdr_components.comp_element%TYPE;
137: TYPE compleveltab IS TABLE OF jdr_components.comp_level%TYPE;
138: TYPE compgroupingtab IS TABLE OF jdr_components.comp_grouping%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;

Line 140: TYPE compreftab IS TABLE OF jdr_components.comp_ref%TYPE;

136: TYPE compelementtab IS TABLE OF jdr_components.comp_element%TYPE;
137: TYPE compleveltab IS TABLE OF jdr_components.comp_level%TYPE;
138: TYPE compgroupingtab IS TABLE OF jdr_components.comp_grouping%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;

Line 141: TYPE compextendstab IS TABLE OF jdr_components.comp_extends%TYPE;

137: TYPE compleveltab IS TABLE OF jdr_components.comp_level%TYPE;
138: TYPE compgroupingtab IS TABLE OF jdr_components.comp_grouping%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;

Line 142: TYPE compusetab IS TABLE OF jdr_components.comp_use%TYPE;

138: TYPE compgroupingtab IS TABLE OF jdr_components.comp_grouping%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:

Line 151: mPreviousLevel jdr_components.comp_level%TYPE;

147: mStack CharArray := NULL;
148: mPackageNames CharArray := NULL;
149: mPackageStack NumArray := NULL;
150: mPackageLevel INTEGER;
151: mPreviousLevel jdr_components.comp_level%TYPE;
152: mPreviousComp jdr_components.comp_seq%TYPE;
153: mPreviousDocID jdr_paths.path_docid%TYPE;
154: mPreviousType jdr_paths.path_type%TYPE;
155: mPartialChunk VARCHAR2(32000);

Line 152: mPreviousComp jdr_components.comp_seq%TYPE;

148: mPackageNames CharArray := NULL;
149: mPackageStack NumArray := NULL;
150: mPackageLevel INTEGER;
151: mPreviousLevel jdr_components.comp_level%TYPE;
152: mPreviousComp jdr_components.comp_seq%TYPE;
153: mPreviousDocID jdr_paths.path_docid%TYPE;
154: mPreviousType jdr_paths.path_type%TYPE;
155: mPartialChunk VARCHAR2(32000);
156: mPartialXLIFFChunk VARCHAR2(32000);

Line 216: compseq jdr_components.comp_seq%TYPE,

212: -- Creates the XML for the new component
213: --
214: PROCEDURE addComponent(
215: newxml IN OUT VARCHAR2,
216: compseq jdr_components.comp_seq%TYPE,
217: compelement jdr_components.comp_element%TYPE,
218: complevel jdr_components.comp_level%TYPE,
219: compgrouping jdr_components.comp_grouping%TYPE,
220: compid jdr_components.comp_id%TYPE,

Line 217: compelement jdr_components.comp_element%TYPE,

213: --
214: PROCEDURE addComponent(
215: newxml IN OUT VARCHAR2,
216: compseq jdr_components.comp_seq%TYPE,
217: compelement jdr_components.comp_element%TYPE,
218: complevel jdr_components.comp_level%TYPE,
219: compgrouping jdr_components.comp_grouping%TYPE,
220: compid jdr_components.comp_id%TYPE,
221: compref jdr_components.comp_ref%TYPE,

Line 218: complevel jdr_components.comp_level%TYPE,

214: PROCEDURE addComponent(
215: newxml IN OUT VARCHAR2,
216: compseq jdr_components.comp_seq%TYPE,
217: compelement jdr_components.comp_element%TYPE,
218: complevel jdr_components.comp_level%TYPE,
219: compgrouping jdr_components.comp_grouping%TYPE,
220: compid jdr_components.comp_id%TYPE,
221: compref jdr_components.comp_ref%TYPE,
222: compextends jdr_components.comp_extends%TYPE,

Line 219: compgrouping jdr_components.comp_grouping%TYPE,

215: newxml IN OUT VARCHAR2,
216: compseq jdr_components.comp_seq%TYPE,
217: compelement jdr_components.comp_element%TYPE,
218: complevel jdr_components.comp_level%TYPE,
219: compgrouping jdr_components.comp_grouping%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,

Line 220: compid jdr_components.comp_id%TYPE,

216: compseq jdr_components.comp_seq%TYPE,
217: compelement jdr_components.comp_element%TYPE,
218: complevel jdr_components.comp_level%TYPE,
219: compgrouping jdr_components.comp_grouping%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,

Line 221: compref jdr_components.comp_ref%TYPE,

217: compelement jdr_components.comp_element%TYPE,
218: complevel jdr_components.comp_level%TYPE,
219: compgrouping jdr_components.comp_grouping%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,

Line 222: compextends jdr_components.comp_extends%TYPE,

218: complevel jdr_components.comp_level%TYPE,
219: compgrouping jdr_components.comp_grouping%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)

Line 223: compuse jdr_components.comp_use%TYPE,

219: compgrouping jdr_components.comp_grouping%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

Line 678: DELETE jdr_components WHERE comp_docid IN

674: START WITH path_docid = docid
675: CONNECT BY PRIOR path_docid=path_owner_docid);
676:
677: -- Delete the components of the document
678: DELETE jdr_components WHERE comp_docid IN
679: (SELECT path_docid FROM jdr_paths
680: START WITH path_docid = docid
681: CONNECT BY PRIOR path_docid=path_owner_docid);
682:

Line 1416: startSeq jdr_components.comp_seq%TYPE;

1412: -- are going to special case customization views.
1413: DECLARE
1414: viewID VARCHAR2(255);
1415: viewCompRef VARCHAR2(255);
1416: startSeq jdr_components.comp_seq%TYPE;
1417: endSeq jdr_components.comp_seq%TYPE;
1418: startLevel jdr_components.comp_level%TYPE;
1419: BEGIN
1420: IF (INSTR(r_trans.atl_comp_ref, ':') <> 1) THEN

Line 1417: endSeq jdr_components.comp_seq%TYPE;

1413: DECLARE
1414: viewID VARCHAR2(255);
1415: viewCompRef VARCHAR2(255);
1416: startSeq jdr_components.comp_seq%TYPE;
1417: endSeq jdr_components.comp_seq%TYPE;
1418: startLevel jdr_components.comp_level%TYPE;
1419: BEGIN
1420: IF (INSTR(r_trans.atl_comp_ref, ':') <> 1) THEN
1421: -- This is not a translation for a customization view.

Line 1418: startLevel jdr_components.comp_level%TYPE;

1414: viewID VARCHAR2(255);
1415: viewCompRef VARCHAR2(255);
1416: startSeq jdr_components.comp_seq%TYPE;
1417: endSeq jdr_components.comp_seq%TYPE;
1418: startLevel jdr_components.comp_level%TYPE;
1419: BEGIN
1420: IF (INSTR(r_trans.atl_comp_ref, ':') <> 1) THEN
1421: -- This is not a translation for a customization view.
1422: --

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 1464: FROM jdr_components

1460: END IF;
1461:
1462: -- Get the starting sequence of the customization view
1463: SELECT comp_seq, comp_level INTO startSeq, startLevel
1464: FROM jdr_components
1465: WHERE comp_docid = r_trans.atl_comp_docid AND
1466: comp_element = 'view' AND
1467: comp_id = viewID;
1468:

Line 1471: FROM jdr_components

1467: comp_id = viewID;
1468:
1469: -- and the ending sequence
1470: SELECT MAX(comp_seq) - 1 INTO endSeq
1471: FROM jdr_components
1472: WHERE comp_docid = r_trans.atl_comp_docid AND
1473: comp_seq > startSeq AND
1474: comp_level <= startLevel;
1475:

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 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 2150: oldCompName jdr_components.comp_id%TYPE;

2146: oldCustDocName VARCHAR2(512);
2147: newCustDocName VARCHAR2(512);
2148: oldBaseName jdr_paths.path_name%TYPE;
2149: newBaseName jdr_paths.path_name%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;

Line 2151: newCompName jdr_components.comp_id%TYPE;

2147: newCustDocName VARCHAR2(512);
2148: oldBaseName jdr_paths.path_name%TYPE;
2149: newBaseName jdr_paths.path_name%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;