APPS.JDR_MDS_INTERNAL dependencies on JDR_ATTRIBUTES_TRANS

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 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 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 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;