APPS.JDR_CUSTOM_INTERNAL dependencies on JDR_ATTRIBUTES

Line 37: pageCompSeq jdr_attributes.att_comp_seq%TYPE,

33: -- regionCompSeq Component sequence of the region component (source)
34: -- extendingRegion Component ID of the extending region
35: -- needElementAtt Is an element attribute needed?
36: PROCEDURE addAttributes(pageCustDocID jdr_paths.path_docid%TYPE,
37: pageCompSeq jdr_attributes.att_comp_seq%TYPE,
38: regionCustDocID jdr_paths.path_docid%TYPE,
39: regionCompSeq jdr_attributes.att_comp_seq%TYPE,
40: extendingRegion jdr_components.comp_id%TYPE,
41: needElementAtt BOOLEAN)

Line 39: regionCompSeq jdr_attributes.att_comp_seq%TYPE,

35: -- needElementAtt Is an element attribute needed?
36: PROCEDURE addAttributes(pageCustDocID jdr_paths.path_docid%TYPE,
37: pageCompSeq jdr_attributes.att_comp_seq%TYPE,
38: regionCustDocID jdr_paths.path_docid%TYPE,
39: regionCompSeq jdr_attributes.att_comp_seq%TYPE,
40: extendingRegion jdr_components.comp_id%TYPE,
41: needElementAtt BOOLEAN)
42: IS
43: CURSOR c_attributes(docID jdr_paths.path_docid%TYPE,

Line 46: FROM jdr_attributes

42: IS
43: CURSOR c_attributes(docID jdr_paths.path_docid%TYPE,
44: compSeq jdr_components.comp_seq%TYPE) IS
45: SELECT att_seq, att_name, att_value
46: FROM jdr_attributes
47: WHERE att_comp_docid = docID AND
48: att_comp_seq = compSeq;
49:
50: attRec c_attributes%ROWTYPE;

Line 51: nextAttSequence jdr_attributes.att_seq%TYPE;

47: WHERE att_comp_docid = docID AND
48: att_comp_seq = compSeq;
49:
50: attRec c_attributes%ROWTYPE;
51: nextAttSequence jdr_attributes.att_seq%TYPE;
52: addElementAtt BOOLEAN := needElementAtt;
53: BEGIN
54: nextAttSequence := 0;
55:

Line 79: INSERT INTO jdr_attributes

75: addElementAtt := FALSE;
76: END IF;
77:
78: -- Insert the component into the per instance view
79: INSERT INTO jdr_attributes
80: (att_comp_docid, att_comp_seq, att_seq, att_name, att_value)
81: VALUES
82: (pageCustDocID, pageCompSeq,
83: attRec.att_seq, attRec.att_name, attRec.att_value);

Line 94: INSERT INTO jdr_attributes

90: -- component (i.e. the region) and so was implicit. But since the
91: -- customization is moving from a top-level component to a non top-level
92: -- component, we now must specify the element attribute.
93: IF (addElementAtt = TRUE) THEN
94: INSERT INTO jdr_attributes
95: (att_comp_docid, att_comp_seq, att_seq, att_name, att_value)
96: VALUES
97: (pageCustDocID, pageCompSeq,
98: nextAttSequence, 'element', extendingRegion);

Line 329: UPDATE jdr_attributes

325: WHERE comp_docid = pageCustDocID AND
326: comp_seq > pageEndSeq;
327:
328: -- Shift the attributes to make room for the region view
329: UPDATE jdr_attributes
330: SET att_comp_seq = att_comp_seq + componentsAdded
331: WHERE att_comp_docid = pageCustDocID AND
332: att_comp_seq > pageEndSeq;
333:

Line 650: FROM jdr_attributes

646: IF activeOnly
647: THEN
648: BEGIN
649: SELECT att_value INTO isActive
650: FROM jdr_attributes
651: WHERE att_comp_docid = custDocID AND
652: att_comp_seq = 0 AND
653: att_name = 'MDSActiveDoc';
654: EXCEPTION

Line 690: FROM jdr_attributes_trans

686: extendingRegionName IN VARCHAR2)
687: IS
688: CURSOR c_translations(docID jdr_paths.path_docid%TYPE) IS
689: SELECT atl_lang, atl_comp_ref, atl_name, atl_value
690: FROM jdr_attributes_trans
691: WHERE atl_comp_docid = docID;
692:
693: CURSOR c_views(docID jdr_paths.path_docid%TYPE) IS
694: SELECT comp_id

Line 777: FROM jdr_components, jdr_attributes

773: -- contains any references to the region
774: BEGIN
775: SELECT 'x' INTO tempStr FROM DUAL WHERE EXISTS (
776: SELECT *
777: FROM jdr_components, jdr_attributes
778: WHERE comp_docid = pageCustDocID AND
779: att_comp_docid = pageCustDocID AND
780: att_comp_seq = comp_seq AND
781: comp_element IN ('view', 'modify', 'move', 'insert', 'criterion') AND

Line 893: INSERT INTO jdr_attributes_trans

889: SUBSTR(tranRec.atl_comp_ref, pos1);
890: END IF;
891: END IF;
892:
893: INSERT INTO jdr_attributes_trans
894: (atl_comp_docid, atl_lang, atl_comp_ref, atl_name, atl_value)
895: VALUES
896: (pageCustDocID,
897: tranRec.atl_lang, tranRec.atl_comp_ref,

Line 905: DELETE jdr_attributes_trans WHERE atl_comp_docid = regionCustDocID;

901:
902: -- Delete the document and remove any translations
903: jdr_mds_internal.deleteDocument(regionCustDocID, TRUE);
904:
905: DELETE jdr_attributes_trans WHERE atl_comp_docid = regionCustDocID;
906:
907: COMMIT;
908:
909: <>