APPS.JDR_UTILS dependencies on JDR_ATTRIBUTES

Line 294: CURSOR c_atts(docID JDR_ATTRIBUTES.ATT_COMP_DOCID%TYPE,

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
297: FROM jdr_attributes
298: WHERE att_comp_docid = docID AND

Line 295: compID JDR_ATTRIBUTES.ATT_COMP_SEQ%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
297: FROM jdr_attributes
298: WHERE att_comp_docid = docID AND
299: att_comp_seq = compID;

Line 297: FROM jdr_attributes

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

Line 302: attName JDR_ATTRIBUTES.ATT_NAME%TYPE;

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
306: dbms_output.enable(1000000);

Line 482: jdr_attributes_trans

478: CURSOR cTrans(p_docID jdr_paths.path_docid%TYPE) IS
479: SELECT
480: atl_lang, atl_comp_ref, atl_name, atl_value
481: FROM
482: jdr_attributes_trans
483: WHERE
484: atl_comp_docid = p_docID
485: ORDER BY
486: atl_lang;

Line 629: FROM jdr_paths, jdr_attributes

625: PROCEDURE listCustomizations(p_document VARCHAR2)
626: IS
627: CURSOR c(pathName VARCHAR2, docName VARCHAR2) IS
628: SELECT jdr_mds_internal.getDocumentName(path_docid)
629: FROM jdr_paths, jdr_attributes
630: WHERE path_docid = att_comp_docid AND
631: path_name = pathName AND
632: att_comp_seq = 0 AND
633: att_name = 'customizes' AND

Line 684: SELECT DISTINCT(atl_lang) FROM jdr_attributes_trans

680: --
681: PROCEDURE listLanguages(p_document VARCHAR2)
682: IS
683: CURSOR c_languages(docid jdr_paths.path_docid%TYPE) IS
684: SELECT DISTINCT(atl_lang) FROM jdr_attributes_trans
685: WHERE atl_comp_docid IN (SELECT path_docid FROM jdr_paths
686: START WITH path_docid = docID
687: CONNECT BY PRIOR path_docid=path_owner_docid);
688:

Line 689: lang jdr_attributes_trans.atl_lang%TYPE;

685: WHERE atl_comp_docid IN (SELECT path_docid FROM jdr_paths
686: START WITH path_docid = docID
687: CONNECT BY PRIOR path_docid=path_owner_docid);
688:
689: lang jdr_attributes_trans.atl_lang%TYPE;
690: docID jdr_paths.path_docid%TYPE;
691: BEGIN
692: dbms_output.enable(1000000);
693:

Line 784: lang jdr_attributes_trans.atl_lang%TYPE;

780: p_translations translationList,
781: p_commit BOOLEAN := TRUE)
782: IS
783: docID jdr_paths.path_docid%TYPE;
784: lang jdr_attributes_trans.atl_lang%TYPE;
785: pos BINARY_INTEGER;
786: dashpos BINARY_INTEGER;
787: BEGIN
788: -- Get the document ID for this document

Line 801: DELETE FROM jdr_attributes_trans WHERE atl_comp_docid = docID;

797: -- Lock the document
798: jdr_mds_internal.lockDocument(docID, 100);
799:
800: -- Delete all of the translations
801: DELETE FROM jdr_attributes_trans WHERE atl_comp_docid = docID;
802:
803: -- Insert the new translations
804: FOR pos IN 1..p_translations.COUNT LOOP
805:

Line 815: INTO jdr_attributes_trans

811: UPPER(SUBSTR(p_translations(pos).lang, dashpos + 1));
812: END IF;
813:
814: INSERT
815: INTO jdr_attributes_trans
816: (atl_comp_docid,
817: atl_lang,
818: atl_comp_ref,
819: atl_name,