APPS.JDR_UTILS dependencies on JDR_COMPONENTS

Line 290: CURSOR c_comps(docID JDR_COMPONENTS.COMP_DOCID%TYPE) IS

286: FROM jdr_paths
287: WHERE jdr_mds_internal.getDocumentName(path_docid)
288: LIKE '%/customizations/%' AND
289: path_type = 'DOCUMENT';
290: CURSOR c_comps(docID JDR_COMPONENTS.COMP_DOCID%TYPE) IS
291: SELECT comp_element
292: FROM jdr_components
293: WHERE comp_docid = docID;
294: CURSOR c_atts(docID JDR_ATTRIBUTES.ATT_COMP_DOCID%TYPE,

Line 292: FROM jdr_components

288: LIKE '%/customizations/%' AND
289: path_type = 'DOCUMENT';
290: CURSOR c_comps(docID JDR_COMPONENTS.COMP_DOCID%TYPE) IS
291: SELECT comp_element
292: FROM jdr_components
293: WHERE comp_docid = docID;
294: CURSOR c_atts(docID JDR_ATTRIBUTES.ATT_COMP_DOCID%TYPE,
295: compID JDR_ATTRIBUTES.ATT_COMP_SEQ%TYPE) IS
296: SELECT att_name

Line 301: compElem JDR_COMPONENTS.COMP_ELEMENT%TYPE;

297: FROM jdr_attributes
298: WHERE att_comp_docid = docID AND
299: att_comp_seq = compID;
300: docID JDR_PATHS.PATH_DOCID%TYPE;
301: compElem JDR_COMPONENTS.COMP_ELEMENT%TYPE;
302: attName JDR_ATTRIBUTES.ATT_NAME%TYPE;
303: compsIsEmpty BOOLEAN;
304: attsIsEmpty BOOLEAN;
305: BEGIN

Line 446: -- jdr_components table

442: -- Parameters:
443: -- p_docid - the ID of the document which contains the component
444: --
445: -- p_compid - the ID of the component (from comp_id in the
446: -- jdr_components table
447: --
448: FUNCTION getComponentName(
449: p_docid jdr_paths.path_docid%TYPE,
450: p_compid jdr_components.comp_id%TYPE) RETURN VARCHAR2

Line 450: p_compid jdr_components.comp_id%TYPE) RETURN VARCHAR2

446: -- jdr_components table
447: --
448: FUNCTION getComponentName(
449: p_docid jdr_paths.path_docid%TYPE,
450: p_compid jdr_components.comp_id%TYPE) RETURN VARCHAR2
451: IS
452: separator VARCHAR2(1) := NULL;
453: BEGIN
454: IF (p_compid IS NOT NULL) THEN