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

Line 13: name jdr_attributes.att_name%TYPE,

9: SUBTYPE DOC_ID IS DOCUMENT;
10:
11: -- Internal representation of a jrad attribute
12: TYPE ATTRIBUTE IS RECORD ( elemId NUMBER,
13: name jdr_attributes.att_name%TYPE,
14: value jdr_attributes.att_value%TYPE );
15:
16: -- Internal representation of a jrad grouping
17: TYPE GROUPING IS RECORD ( parentId NUMBER,

Line 14: value jdr_attributes.att_value%TYPE );

10:
11: -- Internal representation of a jrad attribute
12: TYPE ATTRIBUTE IS RECORD ( elemId NUMBER,
13: name jdr_attributes.att_name%TYPE,
14: value jdr_attributes.att_value%TYPE );
15:
16: -- Internal representation of a jrad grouping
17: TYPE GROUPING IS RECORD ( parentId NUMBER,
18: ns VARCHAR2(5),

Line 61: TYPE DB_ATTRIBUTE_L1 IS TABLE OF jdr_attributes.att_comp_seq%TYPE;

57: TYPE DB_COMPONENT_L10 IS TABLE OF jdr_components.comp_comment%TYPE;
58:
59: -- Tables containing a database attribute's properties in bulk-insert
60: -- compatible format
61: TYPE DB_ATTRIBUTE_L1 IS TABLE OF jdr_attributes.att_comp_seq%TYPE;
62: TYPE DB_ATTRIBUTE_L2 IS TABLE OF jdr_attributes.att_seq%TYPE;
63: TYPE DB_ATTRIBUTE_L3 IS TABLE OF jdr_attributes.att_name%TYPE;
64: TYPE DB_ATTRIBUTE_L4 IS TABLE OF jdr_attributes.att_value%TYPE;
65:

Line 62: TYPE DB_ATTRIBUTE_L2 IS TABLE OF jdr_attributes.att_seq%TYPE;

58:
59: -- Tables containing a database attribute's properties in bulk-insert
60: -- compatible format
61: TYPE DB_ATTRIBUTE_L1 IS TABLE OF jdr_attributes.att_comp_seq%TYPE;
62: TYPE DB_ATTRIBUTE_L2 IS TABLE OF jdr_attributes.att_seq%TYPE;
63: TYPE DB_ATTRIBUTE_L3 IS TABLE OF jdr_attributes.att_name%TYPE;
64: TYPE DB_ATTRIBUTE_L4 IS TABLE OF jdr_attributes.att_value%TYPE;
65:
66: -----------------------------------------------------------------------------

Line 63: TYPE DB_ATTRIBUTE_L3 IS TABLE OF jdr_attributes.att_name%TYPE;

59: -- Tables containing a database attribute's properties in bulk-insert
60: -- compatible format
61: TYPE DB_ATTRIBUTE_L1 IS TABLE OF jdr_attributes.att_comp_seq%TYPE;
62: TYPE DB_ATTRIBUTE_L2 IS TABLE OF jdr_attributes.att_seq%TYPE;
63: TYPE DB_ATTRIBUTE_L3 IS TABLE OF jdr_attributes.att_name%TYPE;
64: TYPE DB_ATTRIBUTE_L4 IS TABLE OF jdr_attributes.att_value%TYPE;
65:
66: -----------------------------------------------------------------------------
67: ---------------------------- PRIVATE VARIABLES ------------------------------

Line 64: TYPE DB_ATTRIBUTE_L4 IS TABLE OF jdr_attributes.att_value%TYPE;

60: -- compatible format
61: TYPE DB_ATTRIBUTE_L1 IS TABLE OF jdr_attributes.att_comp_seq%TYPE;
62: TYPE DB_ATTRIBUTE_L2 IS TABLE OF jdr_attributes.att_seq%TYPE;
63: TYPE DB_ATTRIBUTE_L3 IS TABLE OF jdr_attributes.att_name%TYPE;
64: TYPE DB_ATTRIBUTE_L4 IS TABLE OF jdr_attributes.att_value%TYPE;
65:
66: -----------------------------------------------------------------------------
67: ---------------------------- PRIVATE VARIABLES ------------------------------
68: -----------------------------------------------------------------------------

Line 186: -- represents the jdr_attributes table structure in the repository. Some

182: attList4(attList4.LAST) := p_doc.lang;
183: END;
184:
185: -- Build the entire list of attributes for a given document. This list closely
186: -- represents the jdr_attributes table structure in the repository. Some
187: -- special attributes, such as id and extends, will be stored directly on the
188: -- DBComponent itself, rather than as a DBAttribute.
189: --
190: -- Note: This function assumes that the ATTRIBUTE_TABLE mAttributes

Line 207: attName jdr_attributes.att_name%TYPE;

203: j PLS_INTEGER;
204: currAtt ATTRIBUTE;
205: comp_elemId NUMBER;
206: att_elemId NUMBER;
207: attName jdr_attributes.att_name%TYPE;
208: seq PLS_INTEGER;
209: foundElem BOOLEAN := FALSE;
210: BEGIN
211: IF compList1.COUNT > 0 AND mAttributes.COUNT > 0

Line 513: INSERT INTO jdr_attributes

509: IS
510: i PLS_INTEGER;
511: BEGIN
512: FORALL i in attList1.FIRST..attList1.LAST
513: INSERT INTO jdr_attributes
514: (ATT_COMP_DOCID, ATT_COMP_SEQ, ATT_SEQ, ATT_NAME, ATT_VALUE)
515: VALUES
516: (p_docid, attList1(i), attList2(i), attList3(i),attList4(i));
517: END;

Line 824: DELETE jdr_attributes WHERE att_comp_docid = db_docid;

820: 'DOCUMENT');
821: IF isDuplicate
822: THEN
823: -- Delete from jdr_attribute and jdr_components table
824: DELETE jdr_attributes WHERE att_comp_docid = db_docid;
825: DELETE jdr_components WHERE comp_docid = db_docid;
826: END IF;
827: END IF;
828: -- Bulk Insert the components/attributes