[Home] [Help]
331:
332:
333:
334: FUNCTION create_jrad_region_item(
335: p_item_style IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
336:
337: BEGIN
338:
339: RETURN JDR_DOCBUILDER.createElement(jdr_docbuilder.OA_NS, p_item_style);
335: p_item_style IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
336:
337: BEGIN
338:
339: RETURN JDR_DOCBUILDER.createElement(jdr_docbuilder.OA_NS, p_item_style);
340:
341: END create_jrad_region_item;
342:
343:
342:
343:
344:
345: PROCEDURE add_child_to_parent(
346: parent_element IN JDR_DOCBUILDER.ELEMENT,
347: child_element IN JDR_DOCBUILDER.ELEMENT,
348: p_tag_name IN VARCHAR2) IS
349:
350: BEGIN
343:
344:
345: PROCEDURE add_child_to_parent(
346: parent_element IN JDR_DOCBUILDER.ELEMENT,
347: child_element IN JDR_DOCBUILDER.ELEMENT,
348: p_tag_name IN VARCHAR2) IS
349:
350: BEGIN
351: -- p_tag_name can be 'contents', 'detail'
348: p_tag_name IN VARCHAR2) IS
349:
350: BEGIN
351: -- p_tag_name can be 'contents', 'detail'
352: JDR_DOCBUILDER.addChild(parent_element, JDR_DOCBUILDER.UI_NS, p_tag_name,
353: child_element);
354:
355: END add_child_to_parent;
356:
580: p_region_code IN VARCHAR2,
581: p_region_style IN VARCHAR2,
582: p_prompt IN VARCHAR2,
583: p_columns IN VARCHAR2,
584: p_mode in VARCHAR2 default null) RETURN JDR_DOCBUILDER.ELEMENT IS
585:
586: l_element JDR_DOCBUILDER.ELEMENT := NULL;
587: l_addText VARCHAR2(1000);
588:
582: p_prompt IN VARCHAR2,
583: p_columns IN VARCHAR2,
584: p_mode in VARCHAR2 default null) RETURN JDR_DOCBUILDER.ELEMENT IS
585:
586: l_element JDR_DOCBUILDER.ELEMENT := NULL;
587: l_addText VARCHAR2(1000);
588:
589: l_api_name VARCHAR2(100) := 'CREATE_JRAD_REGION';
590:
592: -- region style choices:
593: -- stackLayout, defaultDoubleColumn, defaultSingleColumn, table
594: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
595:
596: l_element := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, p_region_style);
597:
598: -- 12.1 Inline Region Project
599: -- added advancedTable below
600: -- saurabh
602: -- 12.1 Device Integration Project
603: -- Added header to the in clause
604: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
605: if p_region_style in ('defaultDoubleColumn', 'defaultSingleColumn', 'table', 'header') then
606: jdr_docbuilder.setAttribute(l_element, 'text', p_prompt);
607: elsif p_region_style <> 'labeledFieldLayout' then
608: jdr_docbuilder.setAttribute(l_element, 'prompt', p_prompt);
609: end if;
610:
604: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
605: if p_region_style in ('defaultDoubleColumn', 'defaultSingleColumn', 'table', 'header') then
606: jdr_docbuilder.setAttribute(l_element, 'text', p_prompt);
607: elsif p_region_style <> 'labeledFieldLayout' then
608: jdr_docbuilder.setAttribute(l_element, 'prompt', p_prompt);
609: end if;
610:
611: if ( p_region_style = 'advancedTable') then
612: jdr_docbuilder.setAttribute(l_element, 'text', '');
608: jdr_docbuilder.setAttribute(l_element, 'prompt', p_prompt);
609: end if;
610:
611: if ( p_region_style = 'advancedTable') then
612: jdr_docbuilder.setAttribute(l_element, 'text', '');
613: end if;
614:
615: jdr_docbuilder.setAttribute(l_element, 'regionName', p_prompt);
616: jdr_docbuilder.setAttribute(l_element, 'id', p_region_code);
611: if ( p_region_style = 'advancedTable') then
612: jdr_docbuilder.setAttribute(l_element, 'text', '');
613: end if;
614:
615: jdr_docbuilder.setAttribute(l_element, 'regionName', p_prompt);
616: jdr_docbuilder.setAttribute(l_element, 'id', p_region_code);
617:
618: -- 12.1 Inline Region Project
619: -- added advancedTable below
612: jdr_docbuilder.setAttribute(l_element, 'text', '');
613: end if;
614:
615: jdr_docbuilder.setAttribute(l_element, 'regionName', p_prompt);
616: jdr_docbuilder.setAttribute(l_element, 'id', p_region_code);
617:
618: -- 12.1 Inline Region Project
619: -- added advancedTable below
620: -- saurabh
618: -- 12.1 Inline Region Project
619: -- added advancedTable below
620: -- saurabh
621: if (p_region_style = 'table' OR p_region_style = 'advancedTable') then
622: jdr_docbuilder.setAttribute(l_element, 'detailViewAttr', 'HideShowStatus');
623: jdr_docbuilder.setAttribute(l_element, 'unvalidated', 'True');
624: -- anagarwa Mon Nov 17 15:34:29 PST 2003
625: -- bug 3251538
626: -- we need to add addtional text for all tables.
619: -- added advancedTable below
620: -- saurabh
621: if (p_region_style = 'table' OR p_region_style = 'advancedTable') then
622: jdr_docbuilder.setAttribute(l_element, 'detailViewAttr', 'HideShowStatus');
623: jdr_docbuilder.setAttribute(l_element, 'unvalidated', 'True');
624: -- anagarwa Mon Nov 17 15:34:29 PST 2003
625: -- bug 3251538
626: -- we need to add addtional text for all tables.
627: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
632:
633: -- 12.1 QWB Usability Improvements
634: -- Encode the HTML special characters
635: -- ntungare
636: jdr_docbuilder.setAttribute(l_element, 'shortDesc', DBMS_XMLGEN.convert(l_addText));
637: end if;
638:
639: if p_region_style = 'labeledFieldLayout' then
640: jdr_docbuilder.setAttribute(l_element, 'columns', p_columns);
636: jdr_docbuilder.setAttribute(l_element, 'shortDesc', DBMS_XMLGEN.convert(l_addText));
637: end if;
638:
639: if p_region_style = 'labeledFieldLayout' then
640: jdr_docbuilder.setAttribute(l_element, 'columns', p_columns);
641: end if;
642:
643: -- 12.1 Device Integration Project
644: -- Setting width to 100% for tablelayout style
643: -- 12.1 Device Integration Project
644: -- Setting width to 100% for tablelayout style
645: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
646: if p_region_style = 'tableLayout' then
647: jdr_docbuilder.setAttribute(l_element, 'width', '100%');
648: end if;
649:
650: log_error(g_pkg_name || l_api_name, 'Function END returns ');
651:
714: PROCEDURE add_lov_relations (
715: p_plan_id IN NUMBER,
716: p_char_id IN NUMBER,
717: p_attribute_code IN VARCHAR2,
718: p_input_elem IN jdr_docbuilder.Element,
719: p_mode IN VARCHAR2 DEFAULT NULL) IS
720:
721:
722: l_row_id VARCHAR2(30);
732: -- ntungare
733: --
734: l_multirow_headers ParentArray;
735:
736: lovMap jdr_docbuilder.ELEMENT;
737:
738: -- bug 6884645
739: -- variable to check if the parent attribute
740: -- has been processed
746: -- This function adds lov relations for a region item.
747: -- Here the region item corresponds to a collection plan element.
748:
749: --Criteria
750: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
751: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
752: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
753: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
754: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
747: -- Here the region item corresponds to a collection plan element.
748:
749: --Criteria
750: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
751: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
752: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
753: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
754: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
755: lovMap);
748:
749: --Criteria
750: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
751: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
752: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
753: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
754: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
755: lovMap);
756: --Result
749: --Criteria
750: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
751: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
752: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
753: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
754: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
755: lovMap);
756: --Result
757: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
750: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
751: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
752: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
753: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
754: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
755: lovMap);
756: --Result
757: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
758: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
753: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
754: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
755: lovMap);
756: --Result
757: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
758: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
759: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
760: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
761: lovMap);
754: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
755: lovMap);
756: --Result
757: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
758: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
759: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
760: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
761: lovMap);
762: --Org Id
755: lovMap);
756: --Result
757: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
758: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
759: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
760: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
761: lovMap);
762: --Org Id
763: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
756: --Result
757: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
758: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
759: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
760: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
761: lovMap);
762: --Org Id
763: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
764: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
759: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
760: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
761: lovMap);
762: --Org Id
763: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
764: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
765: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
766: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
767: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
760: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
761: lovMap);
762: --Org Id
763: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
764: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
765: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
766: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
767: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
768: lovMap);
761: lovMap);
762: --Org Id
763: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
764: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
765: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
766: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
767: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
768: lovMap);
769: --Plan Id
762: --Org Id
763: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
764: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
765: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
766: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
767: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
768: lovMap);
769: --Plan Id
770: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
763: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
764: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
765: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
766: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
767: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
768: lovMap);
769: --Plan Id
770: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
771: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
766: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
767: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
768: lovMap);
769: --Plan Id
770: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
771: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
772: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
773: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
774: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
767: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
768: lovMap);
769: --Plan Id
770: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
771: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
772: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
773: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
774: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
775: lovMap);
768: lovMap);
769: --Plan Id
770: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
771: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
772: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
773: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
774: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
775: lovMap);
776:
769: --Plan Id
770: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
771: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
772: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
773: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
774: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
775: lovMap);
776:
777:
770: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
771: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
772: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
773: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
774: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
775: lovMap);
776:
777:
778: get_lov_dependencies(p_char_id, l_parents);
835: ELSE
836: l_base_attribute_code := cons_base_attribute_code(g_element_prefix, l_parents(i));
837: END IF;
838:
839: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
840: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
841: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
842: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
843: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
836: l_base_attribute_code := cons_base_attribute_code(g_element_prefix, l_parents(i));
837: END IF;
838:
839: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
840: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
841: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
842: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
843: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
844: 'lovMappings',lovMap);
837: END IF;
838:
839: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
840: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
841: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
842: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
843: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
844: 'lovMappings',lovMap);
845: END IF;
838:
839: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
840: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
841: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
842: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
843: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
844: 'lovMappings',lovMap);
845: END IF;
846:
839: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
840: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
841: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
842: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
843: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
844: 'lovMappings',lovMap);
845: END IF;
846:
847: --
864: FUNCTION create_id_item_for_eqr (
865: p_plan_id IN NUMBER,
866: p_char_id IN NUMBER,
867: p_mode IN VARCHAR2 DEFAULT NULL)
868: RETURN jdr_docbuilder.ELEMENT IS
869:
870: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
871: l_id_elem jdr_docbuilder.ELEMENT := NULL;
872:
867: p_mode IN VARCHAR2 DEFAULT NULL)
868: RETURN jdr_docbuilder.ELEMENT IS
869:
870: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
871: l_id_elem jdr_docbuilder.ELEMENT := NULL;
872:
873: BEGIN
874:
875: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
875: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
876: l_id_elem := create_jrad_region_item('formValue');
877:
878: -- set properties
879: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
880: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
881: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_vo_name);
882: --end if;
883: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
877:
878: -- set properties
879: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
880: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
881: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_vo_name);
882: --end if;
883: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
884: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
885:
879: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
880: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
881: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_vo_name);
882: --end if;
883: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
884: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
885:
886: return l_id_elem;
887:
880: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
881: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_vo_name);
882: --end if;
883: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
884: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
885:
886: return l_id_elem;
887:
888: END create_id_item_for_eqr;
956: PROCEDURE process_normalized_lov (
957: p_plan_id IN NUMBER,
958: p_char_id IN NUMBER,
959: p_attribute_code IN VARCHAR2,
960: p_char_item IN jdr_docbuilder.Element) IS
961:
962: lovMap jdr_docbuilder.ELEMENT;
963: l_lov_region VARCHAR2(100);
964:
958: p_char_id IN NUMBER,
959: p_attribute_code IN VARCHAR2,
960: p_char_item IN jdr_docbuilder.Element) IS
961:
962: lovMap jdr_docbuilder.ELEMENT;
963: l_lov_region VARCHAR2(100);
964:
965: BEGIN
966: l_lov_region := g_jrad_lov_dir_path || get_lov_region_name(p_plan_id,p_char_id);
963: l_lov_region VARCHAR2(100);
964:
965: BEGIN
966: l_lov_region := g_jrad_lov_dir_path || get_lov_region_name(p_plan_id,p_char_id);
967: jdr_docbuilder.setAttribute(p_char_item,
968: 'externalListOfValues',
969: l_lov_region);
970: --Criteria
971: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
967: jdr_docbuilder.setAttribute(p_char_item,
968: 'externalListOfValues',
969: l_lov_region);
970: --Criteria
971: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
972: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
973: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
974:
975: IF(p_char_id = qa_ss_const.po_number) THEN
968: 'externalListOfValues',
969: l_lov_region);
970: --Criteria
971: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
972: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
973: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
974:
975: IF(p_char_id = qa_ss_const.po_number) THEN
976: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
969: l_lov_region);
970: --Criteria
971: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
972: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
973: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
974:
975: IF(p_char_id = qa_ss_const.po_number) THEN
976: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
977: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
972: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
973: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
974:
975: IF(p_char_id = qa_ss_const.po_number) THEN
976: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
977: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
978: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
979: lovMap);
980:
973: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
974:
975: IF(p_char_id = qa_ss_const.po_number) THEN
976: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
977: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
978: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
979: lovMap);
980:
981: -- po_header_id
974:
975: IF(p_char_id = qa_ss_const.po_number) THEN
976: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
977: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
978: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
979: lovMap);
980:
981: -- po_header_id
982: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
978: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
979: lovMap);
980:
981: -- po_header_id
982: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
983: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
984: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
985: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
986: lovMap);
979: lovMap);
980:
981: -- po_header_id
982: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
983: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
984: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
985: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
986: lovMap);
987: --
980:
981: -- po_header_id
982: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
983: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
984: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
985: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
986: lovMap);
987: --
988: -- bug 5383667
981: -- po_header_id
982: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
983: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
984: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
985: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
986: lovMap);
987: --
988: -- bug 5383667
989: -- Processing for the Party Name element
989: -- Processing for the Party Name element
990: -- ntungare
991: --
992: ELSIF(p_char_id = qa_ss_const.party_name) THEN
993: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyName');
994: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
995: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
996: lovMap);
997:
990: -- ntungare
991: --
992: ELSIF(p_char_id = qa_ss_const.party_name) THEN
993: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyName');
994: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
995: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
996: lovMap);
997:
998: -- PartyId
991: --
992: ELSIF(p_char_id = qa_ss_const.party_name) THEN
993: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyName');
994: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
995: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
996: lovMap);
997:
998: -- PartyId
999: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
995: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
996: lovMap);
997:
998: -- PartyId
999: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1000: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1001: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1002: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1003: lovMap);
996: lovMap);
997:
998: -- PartyId
999: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1000: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1001: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1002: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1003: lovMap);
1004:
997:
998: -- PartyId
999: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1000: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1001: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1002: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1003: lovMap);
1004:
1005: END IF; -- PO Number
998: -- PartyId
999: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1000: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1001: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1002: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1003: lovMap);
1004:
1005: END IF; -- PO Number
1006:
1018: PROCEDURE process_regular_lov (
1019: p_plan_id IN NUMBER,
1020: p_char_id IN NUMBER,
1021: p_attribute_code IN VARCHAR2,
1022: p_char_item IN jdr_docbuilder.Element,
1023: p_mode IN VARCHAR2 DEFAULT NULL) IS
1024:
1025: BEGIN
1026:
1023: p_mode IN VARCHAR2 DEFAULT NULL) IS
1024:
1025: BEGIN
1026:
1027: jdr_docbuilder.setAttribute(p_char_item, 'externalListOfValues',
1028: g_jrad_lov_path);
1029:
1030: add_lov_relations(p_plan_id, p_char_id, p_attribute_code, p_char_item, p_mode);
1031:
1076: PROCEDURE process_messageLovInput (
1077: p_plan_id IN NUMBER,
1078: p_char_id IN NUMBER,
1079: p_attribute_code IN VARCHAR2,
1080: p_char_item IN jdr_docbuilder.Element,
1081: p_displayed_flag IN NUMBER,
1082: p_read_only_flag IN NUMBER,
1083: p_mode IN VARCHAR2 DEFAULT NULL) IS
1084:
1116:
1117: -- Common code
1118:
1119: IF (p_displayed_flag <> 1 OR p_read_only_flag = 1) THEN
1120: jdr_docbuilder.setAttribute(p_char_item, 'unvalidated', 'true');
1121: ELSE
1122: jdr_docbuilder.setAttribute(p_char_item, 'unvalidated', 'false');
1123: END IF;
1124:
1118:
1119: IF (p_displayed_flag <> 1 OR p_read_only_flag = 1) THEN
1120: jdr_docbuilder.setAttribute(p_char_item, 'unvalidated', 'true');
1121: ELSE
1122: jdr_docbuilder.setAttribute(p_char_item, 'unvalidated', 'false');
1123: END IF;
1124:
1125: --
1126: -- 12.1 QWB Usability improvements
1129: -- element or not. We need to do PPR processing for LOV elements
1130: -- to set the dependent elements and to fire online actions
1131: -- ntungare Sun Oct 14 03:08:47 PDT 2007
1132: --
1133: jdr_docbuilder.setAttribute(p_char_item, 'user:attribute1', 'qapprelement');
1134:
1135: --
1136: -- 12.1 QWB Usability improvements
1137: -- If the LOV has online actions defined,
1142: online_act_flg := is_online_action_defined(p_plan_id => p_plan_id,
1143: p_char_id => p_char_id);
1144:
1145: If (online_act_flg = 1) THEN
1146: jdr_docbuilder.setAttribute(p_char_item, 'user:attribute2', 'qaactionelement');
1147: End If;
1148:
1149: END process_messageLovInput;
1150:
1151: FUNCTION create_region_item_for_eqr (
1152: p_plan_id IN NUMBER,
1153: p_char_id IN NUMBER,
1154: p_element_prefix IN VARCHAR2 DEFAULT g_element_prefix,
1155: p_mode IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
1156:
1157: l_attribute_code VARCHAR2(30);
1158: l_item_style VARCHAR2(30);
1159: l_vo_attribute_name VARCHAR2(30);
1180: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1181: l_maximum_length NUMBER;
1182:
1183:
1184: l_char_item jdr_docbuilder.ELEMENT;
1185:
1186: l_api_name constant varchar2(50) := 'CREATE_REGION_ITEM_FOR_EQR';
1187:
1188: -- 12.1 QWB Usability Improvements
1187:
1188: -- 12.1 QWB Usability Improvements
1189: -- ntungare Tue Aug 28 04:20:24 PDT 2007
1190: -- PPRTEST
1191: ppr_event jdr_docbuilder.ELEMENT;
1192:
1193: online_act_flg PLS_INTEGER := 0;
1194:
1195: l_show_required_flag qa_plan_chars.mandatory_flag%TYPE;
1242: end if;
1243:
1244: l_char_item := create_jrad_region_item(l_item_style);
1245:
1246: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1247: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1248: jdr_docbuilder.setAttribute(l_char_item, 'readOnly', c_read_only_flag);
1249: -- if read only elmeent then set style class
1250: if c_read_only_flag = 'true' then
1243:
1244: l_char_item := create_jrad_region_item(l_item_style);
1245:
1246: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1247: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1248: jdr_docbuilder.setAttribute(l_char_item, 'readOnly', c_read_only_flag);
1249: -- if read only elmeent then set style class
1250: if c_read_only_flag = 'true' then
1251: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1244: l_char_item := create_jrad_region_item(l_item_style);
1245:
1246: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1247: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1248: jdr_docbuilder.setAttribute(l_char_item, 'readOnly', c_read_only_flag);
1249: -- if read only elmeent then set style class
1250: if c_read_only_flag = 'true' then
1251: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1252: end if;
1247: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1248: jdr_docbuilder.setAttribute(l_char_item, 'readOnly', c_read_only_flag);
1249: -- if read only elmeent then set style class
1250: if c_read_only_flag = 'true' then
1251: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1252: end if;
1253: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1254: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1255: jdr_docbuilder.setAttribute(l_char_item, 'required', c_mandatory_flag);
1249: -- if read only elmeent then set style class
1250: if c_read_only_flag = 'true' then
1251: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1252: end if;
1253: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1254: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1255: jdr_docbuilder.setAttribute(l_char_item, 'required', c_mandatory_flag);
1256:
1257: -- 12.1 QWB Usability
1250: if c_read_only_flag = 'true' then
1251: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1252: end if;
1253: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1254: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1255: jdr_docbuilder.setAttribute(l_char_item, 'required', c_mandatory_flag);
1256:
1257: -- 12.1 QWB Usability
1258: -- If the element is in a Multirow details block then
1251: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1252: end if;
1253: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1254: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1255: jdr_docbuilder.setAttribute(l_char_item, 'required', c_mandatory_flag);
1256:
1257: -- 12.1 QWB Usability
1258: -- If the element is in a Multirow details block then
1259: -- although the madatory check would not be enfored yet, the
1259: -- although the madatory check would not be enfored yet, the
1260: -- element must atleast be marked as mandatory.
1261: IF ((p_mode = g_eqr_advtable_layout OR p_mode = g_eqr_multiple_layout) AND
1262: (p_element_prefix = g_dtl_element_prefix))THEN
1263: jdr_docbuilder.setAttribute(l_char_item, 'showRequired', c_show_required_flag);
1264: END IF;
1265:
1266: jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
1267: -- Advanced Table does not require view name for each item, write code here and other places
1262: (p_element_prefix = g_dtl_element_prefix))THEN
1263: jdr_docbuilder.setAttribute(l_char_item, 'showRequired', c_show_required_flag);
1264: END IF;
1265:
1266: jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
1267: -- Advanced Table does not require view name for each item, write code here and other places
1268: -- jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1269: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
1270: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1264: END IF;
1265:
1266: jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
1267: -- Advanced Table does not require view name for each item, write code here and other places
1268: -- jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1269: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
1270: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1271: --end if;
1272: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1266: jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
1267: -- Advanced Table does not require view name for each item, write code here and other places
1268: -- jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1269: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
1270: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1271: --end if;
1272: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1273:
1274: -- Bug 4506400. OA Framework Integration. UT Bug fix.
1268: -- jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1269: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
1270: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1271: --end if;
1272: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1273:
1274: -- Bug 4506400. OA Framework Integration. UT Bug fix.
1275: -- Set maxLength property.
1276: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1276: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1277: IF (l_item_style IN ('messageTextInput','messageLovInput')) THEN
1278: l_maximum_length := get_max_length(l_vo_attribute_name);
1279: IF (l_maximum_length is not null AND l_maximum_length <> -1) THEN
1280: jdr_docbuilder.setAttribute(l_char_item, 'maximumLength', l_maximum_length);
1281: END IF;
1282: END IF;
1283:
1284: -- At this point, if the element has lovs then we must determine
1306: -- Bug 3202281 . Poplist vo should have plan name .
1307: -- This code has run time dependency on QaRenderCO.java changes
1308: --l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'VO';
1309: l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'PID' || p_plan_id || 'VO';
1310: jdr_docbuilder.setAttribute(l_char_item, 'pickListViewName', l_pop_vo_name);
1311: jdr_docbuilder.setAttribute(l_char_item, 'pickListDispAttr',
1312: g_pop_display_column);
1313: jdr_docbuilder.setAttribute(l_char_item, 'pickListValAttr', g_pop_value_column);
1314: END IF;
1307: -- This code has run time dependency on QaRenderCO.java changes
1308: --l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'VO';
1309: l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'PID' || p_plan_id || 'VO';
1310: jdr_docbuilder.setAttribute(l_char_item, 'pickListViewName', l_pop_vo_name);
1311: jdr_docbuilder.setAttribute(l_char_item, 'pickListDispAttr',
1312: g_pop_display_column);
1313: jdr_docbuilder.setAttribute(l_char_item, 'pickListValAttr', g_pop_value_column);
1314: END IF;
1315:
1309: l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'PID' || p_plan_id || 'VO';
1310: jdr_docbuilder.setAttribute(l_char_item, 'pickListViewName', l_pop_vo_name);
1311: jdr_docbuilder.setAttribute(l_char_item, 'pickListDispAttr',
1312: g_pop_display_column);
1313: jdr_docbuilder.setAttribute(l_char_item, 'pickListValAttr', g_pop_value_column);
1314: END IF;
1315:
1316: -- Set the text width and height properties for chars of type long comments
1317:
1315:
1316: -- Set the text width and height properties for chars of type long comments
1317:
1318: IF (l_datatype = g_comments_datatype) THEN
1319: jdr_docbuilder.setAttribute(l_char_item, 'columns', g_comments_width);
1320: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1321: -- Bug 4506400. Max length set above. So commenting it out.
1322: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1323:
1316: -- Set the text width and height properties for chars of type long comments
1317:
1318: IF (l_datatype = g_comments_datatype) THEN
1319: jdr_docbuilder.setAttribute(l_char_item, 'columns', g_comments_width);
1320: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1321: -- Bug 4506400. Max length set above. So commenting it out.
1322: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1323:
1324: -- jdr_docbuilder.setAttribute(l_char_item, 'maximumLength', g_comments_max_len);
1320: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1321: -- Bug 4506400. Max length set above. So commenting it out.
1322: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1323:
1324: -- jdr_docbuilder.setAttribute(l_char_item, 'maximumLength', g_comments_max_len);
1325: END IF;
1326:
1327: -- set data entry hint
1328: IF (l_data_entry_hint is not null) THEN
1325: END IF;
1326:
1327: -- set data entry hint
1328: IF (l_data_entry_hint is not null) THEN
1329: jdr_docbuilder.setAttribute(l_char_item, 'tipType', g_tip_type);
1330: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageName', g_tip_message_name);
1331: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageAppShortName', g_app_short_name);
1332: jdr_docbuilder.setAttribute(l_char_item, 'longTipRegion', g_long_tip_region);
1333: END IF;
1326:
1327: -- set data entry hint
1328: IF (l_data_entry_hint is not null) THEN
1329: jdr_docbuilder.setAttribute(l_char_item, 'tipType', g_tip_type);
1330: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageName', g_tip_message_name);
1331: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageAppShortName', g_app_short_name);
1332: jdr_docbuilder.setAttribute(l_char_item, 'longTipRegion', g_long_tip_region);
1333: END IF;
1334:
1327: -- set data entry hint
1328: IF (l_data_entry_hint is not null) THEN
1329: jdr_docbuilder.setAttribute(l_char_item, 'tipType', g_tip_type);
1330: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageName', g_tip_message_name);
1331: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageAppShortName', g_app_short_name);
1332: jdr_docbuilder.setAttribute(l_char_item, 'longTipRegion', g_long_tip_region);
1333: END IF;
1334:
1335: --
1328: IF (l_data_entry_hint is not null) THEN
1329: jdr_docbuilder.setAttribute(l_char_item, 'tipType', g_tip_type);
1330: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageName', g_tip_message_name);
1331: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageAppShortName', g_app_short_name);
1332: jdr_docbuilder.setAttribute(l_char_item, 'longTipRegion', g_long_tip_region);
1333: END IF;
1334:
1335: --
1336: -- 12.1 QWB Usability Improvements
1342: l_item_style = 'messageChoice') THEN
1343: -- Disabling the serverside validation to avoid the
1344: -- entire row being validated
1345: --
1346: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
1347:
1348: -- Adding the firePartialAction tag
1349: --
1350: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
1346: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
1347:
1348: -- Adding the firePartialAction tag
1349: --
1350: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
1351: p_tagName => 'firePartialAction');
1352:
1353: -- Setting the event name for PPR as qappract_CHARIDXX where XX
1354: -- represents the collection elements CharId
1352:
1353: -- Setting the event name for PPR as qappract_CHARIDXX where XX
1354: -- represents the collection elements CharId
1355: --
1356: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qappract_'||l_attribute_code);
1357:
1358: -- Setting the user:attribute1 to indicate the PPR processing is to be
1359: -- done for the element
1360: --
1357:
1358: -- Setting the user:attribute1 to indicate the PPR processing is to be
1359: -- done for the element
1360: --
1361: jdr_docbuilder.setAttribute(l_char_item, 'user:attribute1', 'qapprelement');
1362:
1363: -- Disabling the client side validation
1364: --
1365: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
1361: jdr_docbuilder.setAttribute(l_char_item, 'user:attribute1', 'qapprelement');
1362:
1363: -- Disabling the client side validation
1364: --
1365: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
1366:
1367: jdr_docbuilder.addchild (p_parent => l_char_item,
1368: p_groupingNS => JDR_DOCBUILDER.UI_NS,
1369: p_groupingTagName => 'primaryClientAction',
1363: -- Disabling the client side validation
1364: --
1365: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
1366:
1367: jdr_docbuilder.addchild (p_parent => l_char_item,
1368: p_groupingNS => JDR_DOCBUILDER.UI_NS,
1369: p_groupingTagName => 'primaryClientAction',
1370: p_child => ppr_event);
1371:
1364: --
1365: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
1366:
1367: jdr_docbuilder.addchild (p_parent => l_char_item,
1368: p_groupingNS => JDR_DOCBUILDER.UI_NS,
1369: p_groupingTagName => 'primaryClientAction',
1370: p_child => ppr_event);
1371:
1372:
1379: If (online_act_flg =1) then
1380: -- Setting the user:attribute2 since online actions
1381: -- have been defined.
1382: --
1383: jdr_docbuilder.setAttribute(l_char_item, 'user:attribute2', 'qaactionelement');
1384: online_act_flg := 0;
1385: end if; --(online_act_flg =1)
1386: end if; -- (l_item_style = 'messageTextInput' or l_item_style = 'messageChoice')
1387: -- End of changes for PPR
1398: p_plan_id IN NUMBER,
1399: p_char_id IN NUMBER,
1400: p_element_prefix IN VARCHAR2 DEFAULT g_element_prefix,
1401: p_mode IN VARCHAR2 DEFAULT NULL )
1402: RETURN JDR_DOCBUILDER.ELEMENT IS
1403:
1404: l_attribute_code VARCHAR2(30);
1405: l_item_style VARCHAR2(30) DEFAULT 'messageStyledText';
1406: l_vo_attribute_name VARCHAR2(30);
1419: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1420: c_displayed_flag VARCHAR2(10);
1421:
1422:
1423: l_char_item jdr_docbuilder.ELEMENT;
1424:
1425: BEGIN
1426: l_prompt := get_prompt(p_plan_id, p_char_id);
1427: l_attribute_code := construct_code(p_element_prefix, p_char_id);
1430: l_char_item := create_jrad_region_item(l_item_style);
1431: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1432: -- "Displayed Flag" not honoured in VQR. Get the displayed flag.
1433: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1434: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1435: --jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
1436: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1437: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1438:
1431: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1432: -- "Displayed Flag" not honoured in VQR. Get the displayed flag.
1433: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1434: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1435: --jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
1436: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1437: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1438:
1439:
1432: -- "Displayed Flag" not honoured in VQR. Get the displayed flag.
1433: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1434: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1435: --jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
1436: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1437: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1438:
1439:
1440: -- bug 3236302. rkaza. timezone support. 11/04/2003
1433: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1434: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1435: --jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
1436: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1437: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1438:
1439:
1440: -- bug 3236302. rkaza. timezone support. 11/04/2003
1441: -- Added datatype to vqr region items
1438:
1439:
1440: -- bug 3236302. rkaza. timezone support. 11/04/2003
1441: -- Added datatype to vqr region items
1442: jdr_docbuilder.setAttribute(l_char_item, 'dataType', convert_data_type(l_datatype));
1443:
1444: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1445: -- "Displayed Flag" not honoured in VQR. Set rendered property
1446: -- based on displayed flag.
1451: -- abgangul
1452: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
1453: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1454: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
1455: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1456:
1457: l_vo_attribute_name := get_vo_attribute_name(p_plan_id, p_char_id);
1458: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1459: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1454: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
1455: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1456:
1457: l_vo_attribute_name := get_vo_attribute_name(p_plan_id, p_char_id);
1458: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1459: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1460: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1461:
1462: end if;
1455: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1456:
1457: l_vo_attribute_name := get_vo_attribute_name(p_plan_id, p_char_id);
1458: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1459: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1460: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1461:
1462: end if;
1463:
1456:
1457: l_vo_attribute_name := get_vo_attribute_name(p_plan_id, p_char_id);
1458: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1459: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1460: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1461:
1462: end if;
1463:
1464: IF (l_datatype = g_comments_datatype) THEN
1462: end if;
1463:
1464: IF (l_datatype = g_comments_datatype) THEN
1465: -- fix me
1466: jdr_docbuilder.setAttribute(l_char_item, 'columns', g_comments_width);
1467: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1468: END IF;
1469:
1470: -- for vqr set all text to style OraDataText
1463:
1464: IF (l_datatype = g_comments_datatype) THEN
1465: -- fix me
1466: jdr_docbuilder.setAttribute(l_char_item, 'columns', g_comments_width);
1467: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1468: END IF;
1469:
1470: -- for vqr set all text to style OraDataText
1471:
1479: p_attribute_code IN VARCHAR2,
1480: p_item_style IN VARCHAR2,
1481: p_element_prefix IN VARCHAR2 DEFAULT g_element_prefix,
1482: p_mode IN VARCHAR2 DEFAULT NULL)
1483: RETURN jdr_docbuilder.ELEMENT IS
1484:
1485: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
1486: l_label_long VARCHAR2(30) DEFAULT NULL;
1487: l_special_elem jdr_docbuilder.ELEMENT := NULL;
1483: RETURN jdr_docbuilder.ELEMENT IS
1484:
1485: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
1486: l_label_long VARCHAR2(30) DEFAULT NULL;
1487: l_special_elem jdr_docbuilder.ELEMENT := NULL;
1488: l_data_type VARCHAR2(30);
1489: l_attribute_code VARCHAR2(30) := p_attribute_code;
1490:
1491: -- for attachments
1489: l_attribute_code VARCHAR2(30) := p_attribute_code;
1490:
1491: -- for attachments
1492: l_entity_id VARCHAR2(30) DEFAULT NULL;
1493: l_entityMap jdr_docbuilder.ELEMENT := NULL;
1494:
1495: BEGIN
1496:
1497: -- In EQR we add org_id, org_code, plan_id, plan_code, po_agent_id as special items.
1507: -- VO and VO attribute name is different for export page
1508: -- abgangul
1509: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
1510: l_vo_attribute_name := get_hardcoded_vo_attr_name(p_attribute_code);
1511: jdr_docbuilder.setAttribute(l_special_elem, 'viewName', g_vo_name);
1512: jdr_docbuilder.setAttribute(l_special_elem, 'viewAttr', l_vo_attribute_name);
1513: jdr_docbuilder.setAttribute(l_special_elem, 'styleClass', g_ora_data_text);
1514: else
1515: l_attribute_code := p_element_prefix || l_attribute_code;
1508: -- abgangul
1509: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
1510: l_vo_attribute_name := get_hardcoded_vo_attr_name(p_attribute_code);
1511: jdr_docbuilder.setAttribute(l_special_elem, 'viewName', g_vo_name);
1512: jdr_docbuilder.setAttribute(l_special_elem, 'viewAttr', l_vo_attribute_name);
1513: jdr_docbuilder.setAttribute(l_special_elem, 'styleClass', g_ora_data_text);
1514: else
1515: l_attribute_code := p_element_prefix || l_attribute_code;
1516: end if;
1509: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
1510: l_vo_attribute_name := get_hardcoded_vo_attr_name(p_attribute_code);
1511: jdr_docbuilder.setAttribute(l_special_elem, 'viewName', g_vo_name);
1512: jdr_docbuilder.setAttribute(l_special_elem, 'viewAttr', l_vo_attribute_name);
1513: jdr_docbuilder.setAttribute(l_special_elem, 'styleClass', g_ora_data_text);
1514: else
1515: l_attribute_code := p_element_prefix || l_attribute_code;
1516: end if;
1517:
1514: else
1515: l_attribute_code := p_element_prefix || l_attribute_code;
1516: end if;
1517:
1518: jdr_docbuilder.setAttribute(l_special_elem, 'id', l_attribute_code);
1519: jdr_docbuilder.setAttribute(l_special_elem, 'prompt', l_label_long);
1520:
1521: --
1522: -- Bug 5336860. Per Coding Standard contextual information needs
1515: l_attribute_code := p_element_prefix || l_attribute_code;
1516: end if;
1517:
1518: jdr_docbuilder.setAttribute(l_special_elem, 'id', l_attribute_code);
1519: jdr_docbuilder.setAttribute(l_special_elem, 'prompt', l_label_long);
1520:
1521: --
1522: -- Bug 5336860. Per Coding Standard contextual information needs
1523: -- this statement to set the font.
1528: -- Added datatype datetime to last_update_date
1529: IF (p_attribute_code = g_last_update_date_attribute) THEN
1530: -- Assign a datatype of DATETIME to last_update_date.
1531: l_data_type := convert_data_type(g_datetime_datatype);
1532: jdr_docbuilder.setAttribute(l_special_elem, 'dataType', l_data_type);
1533: END IF;
1534:
1535: IF (p_attribute_code = g_collection_id_attribute) THEN
1536: l_data_type := convert_data_type(g_num_datatype);
1533: END IF;
1534:
1535: IF (p_attribute_code = g_collection_id_attribute) THEN
1536: l_data_type := convert_data_type(g_num_datatype);
1537: jdr_docbuilder.setAttribute(l_special_elem, 'dataType', l_data_type);
1538: END IF;
1539:
1540: if p_attribute_code = g_multi_row_attachment then
1541: l_entity_id := g_attachment_entity;
1538: END IF;
1539:
1540: if p_attribute_code = g_multi_row_attachment then
1541: l_entity_id := g_attachment_entity;
1542: jdr_docbuilder.setAttribute(l_special_elem, 'shortDesc', l_label_long);
1543:
1544: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'entityMap');
1545: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1546: jdr_docbuilder.addChild(l_special_elem, jdr_docbuilder.OA_NS,
1540: if p_attribute_code = g_multi_row_attachment then
1541: l_entity_id := g_attachment_entity;
1542: jdr_docbuilder.setAttribute(l_special_elem, 'shortDesc', l_label_long);
1543:
1544: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'entityMap');
1545: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1546: jdr_docbuilder.addChild(l_special_elem, jdr_docbuilder.OA_NS,
1547: 'entityMappings', l_entityMap);
1548: end if;
1541: l_entity_id := g_attachment_entity;
1542: jdr_docbuilder.setAttribute(l_special_elem, 'shortDesc', l_label_long);
1543:
1544: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'entityMap');
1545: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1546: jdr_docbuilder.addChild(l_special_elem, jdr_docbuilder.OA_NS,
1547: 'entityMappings', l_entityMap);
1548: end if;
1549:
1542: jdr_docbuilder.setAttribute(l_special_elem, 'shortDesc', l_label_long);
1543:
1544: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'entityMap');
1545: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1546: jdr_docbuilder.addChild(l_special_elem, jdr_docbuilder.OA_NS,
1547: 'entityMappings', l_entityMap);
1548: end if;
1549:
1550: return l_special_elem;
1557: -- based on the plan and added elements
1558: FUNCTION create_item_for_advtable(p_plan_id IN NUMBER,
1559: p_char_id IN NUMBER,
1560: p_element_prefix IN VARCHAR2 DEFAULT g_element_prefix)
1561: RETURN jdr_docbuilder.element IS
1562:
1563: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_ITEM_FOR_ADVTABLE';
1564: l_err_num NUMBER;
1565: l_err_msg VARCHAR2(100);
1563: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_ITEM_FOR_ADVTABLE';
1564: l_err_num NUMBER;
1565: l_err_msg VARCHAR2(100);
1566:
1567: l_sort_hdr jdr_docbuilder.element := NULL;
1568: l_col_hdr jdr_docbuilder.element := NULL;
1569: l_char_item jdr_docbuilder.element := NULL;
1570:
1571: l_attr_code VARCHAR2(30);
1564: l_err_num NUMBER;
1565: l_err_msg VARCHAR2(100);
1566:
1567: l_sort_hdr jdr_docbuilder.element := NULL;
1568: l_col_hdr jdr_docbuilder.element := NULL;
1569: l_char_item jdr_docbuilder.element := NULL;
1570:
1571: l_attr_code VARCHAR2(30);
1572: l_col_code VARCHAR2(30);
1565: l_err_msg VARCHAR2(100);
1566:
1567: l_sort_hdr jdr_docbuilder.element := NULL;
1568: l_col_hdr jdr_docbuilder.element := NULL;
1569: l_char_item jdr_docbuilder.element := NULL;
1570:
1571: l_attr_code VARCHAR2(30);
1572: l_col_code VARCHAR2(30);
1573: l_hrd_code VARCHAR2(30);
1584: l_attr_code := construct_code(p_element_prefix, p_char_id);
1585: l_col_code := 'column' || l_attr_code;
1586: -- create column for the table
1587: -- this is an element from the plan
1588: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
1589: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
1590:
1591: -- Setting the rendered property based on the display flag value
1592: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1585: l_col_code := 'column' || l_attr_code;
1586: -- create column for the table
1587: -- this is an element from the plan
1588: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
1589: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
1590:
1591: -- Setting the rendered property based on the display flag value
1592: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1593: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
1591: -- Setting the rendered property based on the display flag value
1592: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1593: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
1594:
1595: jdr_docbuilder.setAttribute(l_col_hdr, 'rendered', c_displayed_flag);
1596:
1597: -- add actual element
1598: log_error(g_pkg_name || l_api_name, 'Creating Element ' || to_char(p_char_id));
1599: l_char_item := create_region_item_for_eqr(p_plan_id, p_char_id, p_element_prefix, l_mode);
1602: log_error(g_pkg_name || l_api_name, 'END');
1603:
1604: l_hrd_code := 'colHdr' || l_attr_code;
1605: -- add column header
1606: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
1607: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
1608: l_prompt := get_prompt(p_plan_id, p_char_id);
1609: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
1610:
1603:
1604: l_hrd_code := 'colHdr' || l_attr_code;
1605: -- add column header
1606: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
1607: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
1608: l_prompt := get_prompt(p_plan_id, p_char_id);
1609: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
1610:
1611: -- adding the mandatory sign
1605: -- add column header
1606: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
1607: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
1608: l_prompt := get_prompt(p_plan_id, p_char_id);
1609: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
1610:
1611: -- adding the mandatory sign
1612: l_mandatory_flag := qa_plan_element_api.qpc_mandatory_flag(p_plan_id, p_char_id);
1613: c_mandatory_flag := convert_yesno_flag(l_mandatory_flag);
1610:
1611: -- adding the mandatory sign
1612: l_mandatory_flag := qa_plan_element_api.qpc_mandatory_flag(p_plan_id, p_char_id);
1613: c_mandatory_flag := convert_yesno_flag(l_mandatory_flag);
1614: jdr_docbuilder.setAttribute(l_sort_hdr, 'required', c_mandatory_flag);
1615:
1616: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
1617:
1618:
1628:
1629: BEGIN
1630: -- delete the document if it exists.
1631:
1632: If jdr_docbuilder.documentExists(p_full_path) then
1633: jdr_docbuilder.deleteDocument(p_full_path);
1634: end if;
1635:
1636: END delete_old_top_document;
1629: BEGIN
1630: -- delete the document if it exists.
1631:
1632: If jdr_docbuilder.documentExists(p_full_path) then
1633: jdr_docbuilder.deleteDocument(p_full_path);
1634: end if;
1635:
1636: END delete_old_top_document;
1637:
1637:
1638:
1639:
1640: FUNCTION create_top_document(
1641: p_full_path IN VARCHAR2) RETURN JDR_DOCBUILDER.DOCUMENT IS
1642:
1643: BEGIN
1644:
1645: RETURN JDR_DOCBUILDER.createDocument(p_full_path, 'en-US');
1641: p_full_path IN VARCHAR2) RETURN JDR_DOCBUILDER.DOCUMENT IS
1642:
1643: BEGIN
1644:
1645: RETURN JDR_DOCBUILDER.createDocument(p_full_path, 'en-US');
1646:
1647: END create_top_document;
1648:
1649:
1647: END create_top_document;
1648:
1649:
1650: FUNCTION create_and_set_top_element(
1651: p_top_doc IN JDR_DOCBUILDER.DOCUMENT,
1652: p_top_region_code IN VARCHAR2,
1653: p_layout IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
1654:
1655: l_api_name constant varchar2(50) := 'CREATE_AND_SET_TOP_ELEMENT';
1649:
1650: FUNCTION create_and_set_top_element(
1651: p_top_doc IN JDR_DOCBUILDER.DOCUMENT,
1652: p_top_region_code IN VARCHAR2,
1653: p_layout IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
1654:
1655: l_api_name constant varchar2(50) := 'CREATE_AND_SET_TOP_ELEMENT';
1656: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
1657: l_prompt VARCHAR2(30);
1652: p_top_region_code IN VARCHAR2,
1653: p_layout IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
1654:
1655: l_api_name constant varchar2(50) := 'CREATE_AND_SET_TOP_ELEMENT';
1656: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
1657: l_prompt VARCHAR2(30);
1658: BEGIN
1659: -- Creates the top region and sets it as the top level element in the document
1660: -- p_layout can be stackLayout or table layout for top regions
1671: l_prompt := get_region_prompt('DATA');
1672: end if;
1673:
1674: l_top_region := create_jrad_region (p_top_region_code, p_layout,l_prompt, null);
1675: JDR_DOCBUILDER.setTopLevelElement(p_top_doc, l_top_region);
1676:
1677: -- 12.1 Inline region project
1678: -- saugupta
1679: if ( p_layout = 'advancedTable' ) then
1678: -- saugupta
1679: if ( p_layout = 'advancedTable' ) then
1680: -- found code bug, regionName appearing twice in the final XML
1681: -- saugupta
1682: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'regionName', l_prompt);
1683: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_vo_name);
1684: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'detailViewAttr', 'HideShowStatus');
1685: end if;
1686:
1679: if ( p_layout = 'advancedTable' ) then
1680: -- found code bug, regionName appearing twice in the final XML
1681: -- saugupta
1682: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'regionName', l_prompt);
1683: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_vo_name);
1684: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'detailViewAttr', 'HideShowStatus');
1685: end if;
1686:
1687: RETURN l_top_region;
1680: -- found code bug, regionName appearing twice in the final XML
1681: -- saugupta
1682: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'regionName', l_prompt);
1683: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_vo_name);
1684: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'detailViewAttr', 'HideShowStatus');
1685: end if;
1686:
1687: RETURN l_top_region;
1688:
1698: -- Returns no of plan chars added to the region
1699:
1700: FUNCTION add_plan_chars_to_region(
1701: p_plan_id IN NUMBER,
1702: p_content_region IN JDR_DOCBUILDER.ELEMENT,
1703: p_mode IN VARCHAR2,
1704: p_char_type IN VARCHAR2,
1705: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN NUMBER IS
1706:
1704: p_char_type IN VARCHAR2,
1705: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN NUMBER IS
1706:
1707: char_count NUMBER := 0;
1708: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
1709: -- MOAC
1710: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1711:
1712: l_element_prefix VARCHAR2(15) := g_element_prefix;
1706:
1707: char_count NUMBER := 0;
1708: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
1709: -- MOAC
1710: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1711:
1712: l_element_prefix VARCHAR2(15) := g_element_prefix;
1713:
1714: l_api_name CONSTANT VARCHAR2(50) := 'ADD_PLAN_CHARS_TO_REGION';
1784:
1785:
1786: PROCEDURE add_special_chars_to_region(
1787: p_plan_id IN NUMBER,
1788: p_content_region IN JDR_DOCBUILDER.ELEMENT,
1789: p_mode IN VARCHAR2,
1790: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) IS
1791:
1792: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
1788: p_content_region IN JDR_DOCBUILDER.ELEMENT,
1789: p_mode IN VARCHAR2,
1790: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) IS
1791:
1792: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
1793: l_item_style VARCHAR2(30) := null;
1794: l_element_prefix VARCHAR2(15) := g_element_prefix;
1795: BEGIN
1796:
1876: FUNCTION create_data_region(
1877: p_plan_id IN NUMBER,
1878: p_data_region_code IN VARCHAR2,
1879: p_mode IN VARCHAR2,
1880: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
1881:
1882: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
1883: l_prompt VARCHAR2(30) := null;
1884: l_char_count NUMBER := null;
1878: p_data_region_code IN VARCHAR2,
1879: p_mode IN VARCHAR2,
1880: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
1881:
1882: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
1883: l_prompt VARCHAR2(30) := null;
1884: l_char_count NUMBER := null;
1885:
1886: BEGIN
1930: p_plan_id IN NUMBER,
1931: p_comments_region_code IN VARCHAR2,
1932: p_mode IN VARCHAR2,
1933: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL)
1934: RETURN JDR_DOCBUILDER.ELEMENT IS
1935:
1936: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
1937: l_prompt VARCHAR2(30) := null;
1938: l_char_count NUMBER := null;
1932: p_mode IN VARCHAR2,
1933: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL)
1934: RETURN JDR_DOCBUILDER.ELEMENT IS
1935:
1936: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
1937: l_prompt VARCHAR2(30) := null;
1938: l_char_count NUMBER := null;
1939:
1940: BEGIN
1972:
1973:
1974: FUNCTION create_attachments_region(p_plan_id IN NUMBER,
1975: p_mode IN VARCHAR2)
1976: RETURN JDR_DOCBUILDER.ELEMENT IS
1977:
1978: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
1979: l_prompt VARCHAR2(30) := null;
1980: l_char_count NUMBER := null;
1974: FUNCTION create_attachments_region(p_plan_id IN NUMBER,
1975: p_mode IN VARCHAR2)
1976: RETURN JDR_DOCBUILDER.ELEMENT IS
1977:
1978: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
1979: l_prompt VARCHAR2(30) := null;
1980: l_char_count NUMBER := null;
1981:
1982: l_row_id VARCHAR2(30);
1995: l_image_file_name VARCHAR2(240) DEFAULT NULL;
1996: l_description VARCHAR2(240) DEFAULT NULL;
1997: --l_query_flag VARCHAR2(1) DEFAULT 'N';
1998:
1999: special_elem jdr_docbuilder.ELEMENT := NULL;
2000: l_entityMap jdr_docbuilder.ELEMENT := NULL;
2001:
2002: err_num NUMBER;
2003: err_msg VARCHAR2(100);
1996: l_description VARCHAR2(240) DEFAULT NULL;
1997: --l_query_flag VARCHAR2(1) DEFAULT 'N';
1998:
1999: special_elem jdr_docbuilder.ELEMENT := NULL;
2000: l_entityMap jdr_docbuilder.ELEMENT := NULL;
2001:
2002: err_num NUMBER;
2003: err_msg VARCHAR2(100);
2004: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2000: l_entityMap jdr_docbuilder.ELEMENT := NULL;
2001:
2002: err_num NUMBER;
2003: err_msg VARCHAR2(100);
2004: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2005:
2006:
2007: BEGIN
2008: -- create comments region
2024:
2025: --l_item_style := 'attachmentImage';
2026: l_item_style := 'attachmentLink';
2027: --special handling for attachments
2028: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2029: 'entityMap');
2030: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
2031:
2032: -- Bug 6718507
2026: l_item_style := 'attachmentLink';
2027: --special handling for attachments
2028: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2029: 'entityMap');
2030: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
2031:
2032: -- Bug 6718507
2033: -- in VQR we do not want the user to insert or update Attachements
2034: -- ntungare Wed Jan 23 04:20:57 PST 2008
2033: -- in VQR we do not want the user to insert or update Attachements
2034: -- ntungare Wed Jan 23 04:20:57 PST 2008
2035: --
2036: IF (p_mode = g_vqr_single_layout) THEN
2037: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false' );
2038: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false' );
2039: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false' );
2040: END IF;
2041:
2034: -- ntungare Wed Jan 23 04:20:57 PST 2008
2035: --
2036: IF (p_mode = g_vqr_single_layout) THEN
2037: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false' );
2038: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false' );
2039: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false' );
2040: END IF;
2041:
2042: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2035: --
2036: IF (p_mode = g_vqr_single_layout) THEN
2037: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false' );
2038: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false' );
2039: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false' );
2040: END IF;
2041:
2042: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2043: l_item_style);
2038: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false' );
2039: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false' );
2040: END IF;
2041:
2042: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2043: l_item_style);
2044: jdr_docbuilder.setAttribute(special_elem, 'id', 'AK_ATTACHMENT_LINK' );
2045: jdr_docbuilder.setAttribute(special_elem, 'viewName', 'QualityResultsVO' );
2046:
2040: END IF;
2041:
2042: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2043: l_item_style);
2044: jdr_docbuilder.setAttribute(special_elem, 'id', 'AK_ATTACHMENT_LINK' );
2045: jdr_docbuilder.setAttribute(special_elem, 'viewName', 'QualityResultsVO' );
2046:
2047: -- in VQR we do not want to user to insert or update Attachements
2048: IF (p_mode = g_vqr_single_layout) THEN
2041:
2042: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2043: l_item_style);
2044: jdr_docbuilder.setAttribute(special_elem, 'id', 'AK_ATTACHMENT_LINK' );
2045: jdr_docbuilder.setAttribute(special_elem, 'viewName', 'QualityResultsVO' );
2046:
2047: -- in VQR we do not want to user to insert or update Attachements
2048: IF (p_mode = g_vqr_single_layout) THEN
2049: jdr_docbuilder.setAttribute(special_elem, 'insertAllowed', 'false' );
2045: jdr_docbuilder.setAttribute(special_elem, 'viewName', 'QualityResultsVO' );
2046:
2047: -- in VQR we do not want to user to insert or update Attachements
2048: IF (p_mode = g_vqr_single_layout) THEN
2049: jdr_docbuilder.setAttribute(special_elem, 'insertAllowed', 'false' );
2050: jdr_docbuilder.setAttribute(special_elem, 'updateAllowed', 'false' );
2051: jdr_docbuilder.setAttribute(special_elem, 'deleteAllowed', 'false' );
2052:
2053:
2046:
2047: -- in VQR we do not want to user to insert or update Attachements
2048: IF (p_mode = g_vqr_single_layout) THEN
2049: jdr_docbuilder.setAttribute(special_elem, 'insertAllowed', 'false' );
2050: jdr_docbuilder.setAttribute(special_elem, 'updateAllowed', 'false' );
2051: jdr_docbuilder.setAttribute(special_elem, 'deleteAllowed', 'false' );
2052:
2053:
2054: END IF;
2047: -- in VQR we do not want to user to insert or update Attachements
2048: IF (p_mode = g_vqr_single_layout) THEN
2049: jdr_docbuilder.setAttribute(special_elem, 'insertAllowed', 'false' );
2050: jdr_docbuilder.setAttribute(special_elem, 'updateAllowed', 'false' );
2051: jdr_docbuilder.setAttribute(special_elem, 'deleteAllowed', 'false' );
2052:
2053:
2054: END IF;
2055:
2053:
2054: END IF;
2055:
2056:
2057: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,
2058: 'entityMappings', l_entityMap);
2059:
2060: JDR_DOCBUILDER.addChild(l_attachments_region, JDR_DOCBUILDER.UI_NS,
2061: 'contents', special_elem);
2056:
2057: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,
2058: 'entityMappings', l_entityMap);
2059:
2060: JDR_DOCBUILDER.addChild(l_attachments_region, JDR_DOCBUILDER.UI_NS,
2061: 'contents', special_elem);
2062:
2063: /*
2064: IF ( instr(p_prefix, g_vqr_prefix) = 1) THEN
2075:
2076: FUNCTION create_detail_region(
2077: p_plan_id IN NUMBER,
2078: p_dtl_region_code IN VARCHAR2,
2079: p_mode IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
2080:
2081: l_data_region_code VARCHAR2(35);
2082: l_comments_region_code VARCHAR2(35);
2083:
2080:
2081: l_data_region_code VARCHAR2(35);
2082: l_comments_region_code VARCHAR2(35);
2083:
2084: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2085: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2086: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2087:
2088: l_prompt VARCHAR2(30) := null;
2081: l_data_region_code VARCHAR2(35);
2082: l_comments_region_code VARCHAR2(35);
2083:
2084: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2085: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2086: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2087:
2088: l_prompt VARCHAR2(30) := null;
2089: l_char_count NUMBER := null;
2082: l_comments_region_code VARCHAR2(35);
2083:
2084: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2085: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2086: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2087:
2088: l_prompt VARCHAR2(30) := null;
2089: l_char_count NUMBER := null;
2090:
2118:
2119: END create_detail_region;
2120:
2121: -- create table action region containing buttons like duplicate and delete
2122: FUNCTION create_table_action_region RETURN jdr_docbuilder.element IS
2123:
2124: l_row_layout jdr_docbuilder.element := NULL;
2125: l_text jdr_docbuilder.element := NULL;
2126: l_dup_btn jdr_docbuilder.element := NULL;
2120:
2121: -- create table action region containing buttons like duplicate and delete
2122: FUNCTION create_table_action_region RETURN jdr_docbuilder.element IS
2123:
2124: l_row_layout jdr_docbuilder.element := NULL;
2125: l_text jdr_docbuilder.element := NULL;
2126: l_dup_btn jdr_docbuilder.element := NULL;
2127: l_del_btn jdr_docbuilder.element := NULL;
2128:
2121: -- create table action region containing buttons like duplicate and delete
2122: FUNCTION create_table_action_region RETURN jdr_docbuilder.element IS
2123:
2124: l_row_layout jdr_docbuilder.element := NULL;
2125: l_text jdr_docbuilder.element := NULL;
2126: l_dup_btn jdr_docbuilder.element := NULL;
2127: l_del_btn jdr_docbuilder.element := NULL;
2128:
2129: l_attr_code VARCHAR2(30);
2122: FUNCTION create_table_action_region RETURN jdr_docbuilder.element IS
2123:
2124: l_row_layout jdr_docbuilder.element := NULL;
2125: l_text jdr_docbuilder.element := NULL;
2126: l_dup_btn jdr_docbuilder.element := NULL;
2127: l_del_btn jdr_docbuilder.element := NULL;
2128:
2129: l_attr_code VARCHAR2(30);
2130:
2123:
2124: l_row_layout jdr_docbuilder.element := NULL;
2125: l_text jdr_docbuilder.element := NULL;
2126: l_dup_btn jdr_docbuilder.element := NULL;
2127: l_del_btn jdr_docbuilder.element := NULL;
2128:
2129: l_attr_code VARCHAR2(30);
2130:
2131: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_ACTION_REGION';
2139: -- create tableAction region items
2140: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2141: -- create rowLayout
2142: l_row_layout := create_jrad_region_item('rowLayout');
2143: jdr_docbuilder.setattribute(l_row_layout, 'id', 'rowLayoutRN'); -- set proper non static id
2144:
2145: -- create display text item
2146: l_text := create_jrad_region_item('messageStyledText');
2147: jdr_docbuilder.setattribute(l_text, 'id', 'displayText');
2143: jdr_docbuilder.setattribute(l_row_layout, 'id', 'rowLayoutRN'); -- set proper non static id
2144:
2145: -- create display text item
2146: l_text := create_jrad_region_item('messageStyledText');
2147: jdr_docbuilder.setattribute(l_text, 'id', 'displayText');
2148: l_label := fnd_message.get_string('QA','QA_TABLE_SELECT_MSG');
2149: jdr_docbuilder.setattribute(l_text, 'prompt', l_label);
2150:
2151: --create button
2145: -- create display text item
2146: l_text := create_jrad_region_item('messageStyledText');
2147: jdr_docbuilder.setattribute(l_text, 'id', 'displayText');
2148: l_label := fnd_message.get_string('QA','QA_TABLE_SELECT_MSG');
2149: jdr_docbuilder.setattribute(l_text, 'prompt', l_label);
2150:
2151: --create button
2152: l_dup_btn := create_jrad_region_item('submitButton');
2153: jdr_docbuilder.setattribute(l_dup_btn, 'id', 'dupBtn');
2149: jdr_docbuilder.setattribute(l_text, 'prompt', l_label);
2150:
2151: --create button
2152: l_dup_btn := create_jrad_region_item('submitButton');
2153: jdr_docbuilder.setattribute(l_dup_btn, 'id', 'dupBtn');
2154:
2155: -- do not set prompt with '&' instead use attribute sets
2156: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DUPLICATE_PROMPT');
2157: -- jdr_docbuilder.setattribute(l_dup_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2153: jdr_docbuilder.setattribute(l_dup_btn, 'id', 'dupBtn');
2154:
2155: -- do not set prompt with '&' instead use attribute sets
2156: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DUPLICATE_PROMPT');
2157: -- jdr_docbuilder.setattribute(l_dup_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2158: jdr_docbuilder.setattribute(l_dup_btn, 'use', l_dup_attr_set);
2159:
2160: jdr_docbuilder.setattribute(l_dup_btn, 'unvalidated', 'true');
2161:
2154:
2155: -- do not set prompt with '&' instead use attribute sets
2156: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DUPLICATE_PROMPT');
2157: -- jdr_docbuilder.setattribute(l_dup_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2158: jdr_docbuilder.setattribute(l_dup_btn, 'use', l_dup_attr_set);
2159:
2160: jdr_docbuilder.setattribute(l_dup_btn, 'unvalidated', 'true');
2161:
2162: --create button
2156: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DUPLICATE_PROMPT');
2157: -- jdr_docbuilder.setattribute(l_dup_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2158: jdr_docbuilder.setattribute(l_dup_btn, 'use', l_dup_attr_set);
2159:
2160: jdr_docbuilder.setattribute(l_dup_btn, 'unvalidated', 'true');
2161:
2162: --create button
2163: l_del_btn := create_jrad_region_item('submitButton');
2164: jdr_docbuilder.setattribute(l_del_btn, 'id', 'delBtn');
2160: jdr_docbuilder.setattribute(l_dup_btn, 'unvalidated', 'true');
2161:
2162: --create button
2163: l_del_btn := create_jrad_region_item('submitButton');
2164: jdr_docbuilder.setattribute(l_del_btn, 'id', 'delBtn');
2165:
2166: -- do not set prompt with '&' instead use attribute sets
2167: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DELETE_PROMPT');
2168: -- jdr_docbuilder.setattribute(l_del_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt) );
2164: jdr_docbuilder.setattribute(l_del_btn, 'id', 'delBtn');
2165:
2166: -- do not set prompt with '&' instead use attribute sets
2167: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DELETE_PROMPT');
2168: -- jdr_docbuilder.setattribute(l_del_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt) );
2169: jdr_docbuilder.setattribute(l_del_btn, 'use', l_del_attr_set);
2170:
2171: jdr_docbuilder.setattribute(l_del_btn, 'unvalidated', 'true');
2172: -- Bug 6856743 - Set server side validation to false.
2165:
2166: -- do not set prompt with '&' instead use attribute sets
2167: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DELETE_PROMPT');
2168: -- jdr_docbuilder.setattribute(l_del_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt) );
2169: jdr_docbuilder.setattribute(l_del_btn, 'use', l_del_attr_set);
2170:
2171: jdr_docbuilder.setattribute(l_del_btn, 'unvalidated', 'true');
2172: -- Bug 6856743 - Set server side validation to false.
2173: jdr_docbuilder.setattribute(l_del_btn, 'serverUnvalidated', 'True');
2167: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DELETE_PROMPT');
2168: -- jdr_docbuilder.setattribute(l_del_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt) );
2169: jdr_docbuilder.setattribute(l_del_btn, 'use', l_del_attr_set);
2170:
2171: jdr_docbuilder.setattribute(l_del_btn, 'unvalidated', 'true');
2172: -- Bug 6856743 - Set server side validation to false.
2173: jdr_docbuilder.setattribute(l_del_btn, 'serverUnvalidated', 'True');
2174:
2175: -- add items to region
2169: jdr_docbuilder.setattribute(l_del_btn, 'use', l_del_attr_set);
2170:
2171: jdr_docbuilder.setattribute(l_del_btn, 'unvalidated', 'true');
2172: -- Bug 6856743 - Set server side validation to false.
2173: jdr_docbuilder.setattribute(l_del_btn, 'serverUnvalidated', 'True');
2174:
2175: -- add items to region
2176: add_child_to_parent(l_row_layout, l_text, 'contents');
2177: add_child_to_parent(l_row_layout, l_dup_btn, 'contents');
2183:
2184: END create_table_action_region;
2185:
2186: -- create table single selection region with radio button
2187: FUNCTION create_table_selection RETURN jdr_docbuilder.element IS
2188:
2189: l_sing_select jdr_docbuilder.element := NULL;
2190: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_SELECTION';
2191:
2185:
2186: -- create table single selection region with radio button
2187: FUNCTION create_table_selection RETURN jdr_docbuilder.element IS
2188:
2189: l_sing_select jdr_docbuilder.element := NULL;
2190: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_SELECTION';
2191:
2192: -- 12.1 Device Integration Project
2193: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2191:
2192: -- 12.1 Device Integration Project
2193: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2194: -- For PPR Event
2195: ppr_event jdr_docbuilder.ELEMENT;
2196:
2197: BEGIN
2198: -- create tableSelection
2199: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2198: -- create tableSelection
2199: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2200: -- create singleSelection
2201: l_sing_select := create_jrad_region_item('singleSelection');
2202: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2203: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2204: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2205: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2206: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2199: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2200: -- create singleSelection
2201: l_sing_select := create_jrad_region_item('singleSelection');
2202: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2203: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2204: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2205: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2206: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2207:
2200: -- create singleSelection
2201: l_sing_select := create_jrad_region_item('singleSelection');
2202: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2203: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2204: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2205: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2206: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2207:
2208: -- 12.1 Device Integration Project
2201: l_sing_select := create_jrad_region_item('singleSelection');
2202: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2203: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2204: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2205: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2206: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2207:
2208: -- 12.1 Device Integration Project
2209: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2202: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2203: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2204: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2205: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2206: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2207:
2208: -- 12.1 Device Integration Project
2209: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2210: -- For PPR Event
2207:
2208: -- 12.1 Device Integration Project
2209: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2210: -- For PPR Event
2211: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2212: p_tagName => 'firePartialAction');
2213: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2214: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2215: jdr_docbuilder.addchild(p_parent => l_sing_select,
2209: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2210: -- For PPR Event
2211: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2212: p_tagName => 'firePartialAction');
2213: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2214: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2215: jdr_docbuilder.addchild(p_parent => l_sing_select,
2216: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2217: p_groupingTagName => 'primaryClientAction',
2210: -- For PPR Event
2211: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2212: p_tagName => 'firePartialAction');
2213: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2214: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2215: jdr_docbuilder.addchild(p_parent => l_sing_select,
2216: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2217: p_groupingTagName => 'primaryClientAction',
2218: p_child => ppr_event);
2211: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2212: p_tagName => 'firePartialAction');
2213: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2214: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2215: jdr_docbuilder.addchild(p_parent => l_sing_select,
2216: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2217: p_groupingTagName => 'primaryClientAction',
2218: p_child => ppr_event);
2219: -- Device Integration Project End.
2212: p_tagName => 'firePartialAction');
2213: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2214: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2215: jdr_docbuilder.addchild(p_parent => l_sing_select,
2216: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2217: p_groupingTagName => 'primaryClientAction',
2218: p_child => ppr_event);
2219: -- Device Integration Project End.
2220:
2228:
2229: END create_table_selection;
2230:
2231: -- create table single selection region with radio button
2232: FUNCTION create_table_footer RETURN jdr_docbuilder.element IS
2233:
2234: l_add_btn jdr_docbuilder.element := NULL;
2235: l_footer jdr_docbuilder.element := NULL;
2236: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_FOOTER';
2230:
2231: -- create table single selection region with radio button
2232: FUNCTION create_table_footer RETURN jdr_docbuilder.element IS
2233:
2234: l_add_btn jdr_docbuilder.element := NULL;
2235: l_footer jdr_docbuilder.element := NULL;
2236: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_FOOTER';
2237: l_prompt VARCHAR2(50);
2238:
2231: -- create table single selection region with radio button
2232: FUNCTION create_table_footer RETURN jdr_docbuilder.element IS
2233:
2234: l_add_btn jdr_docbuilder.element := NULL;
2235: l_footer jdr_docbuilder.element := NULL;
2236: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_FOOTER';
2237: l_prompt VARCHAR2(50);
2238:
2239: BEGIN
2240: -- create tableSelection
2241: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2242: -- create Button
2243: l_add_btn := create_jrad_region_item('addTableRow');
2244: jdr_docbuilder.setattribute(l_add_btn, 'id', 'addResultRow');
2245: jdr_docbuilder.setattribute(l_add_btn, 'autoInsertion', 'false');
2246:
2247: -- l_prompt := fnd_message.get_string('QA','QA_QWB_ADD_PROMPT');
2248: -- jdr_docbuilder.setattribute(l_add_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2241: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2242: -- create Button
2243: l_add_btn := create_jrad_region_item('addTableRow');
2244: jdr_docbuilder.setattribute(l_add_btn, 'id', 'addResultRow');
2245: jdr_docbuilder.setattribute(l_add_btn, 'autoInsertion', 'false');
2246:
2247: -- l_prompt := fnd_message.get_string('QA','QA_QWB_ADD_PROMPT');
2248: -- jdr_docbuilder.setattribute(l_add_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2249:
2244: jdr_docbuilder.setattribute(l_add_btn, 'id', 'addResultRow');
2245: jdr_docbuilder.setattribute(l_add_btn, 'autoInsertion', 'false');
2246:
2247: -- l_prompt := fnd_message.get_string('QA','QA_QWB_ADD_PROMPT');
2248: -- jdr_docbuilder.setattribute(l_add_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2249:
2250: l_footer := create_jrad_region_item('tableFooter');
2251: jdr_docbuilder.setattribute(l_footer, 'id', 'resultFooter');
2252:
2247: -- l_prompt := fnd_message.get_string('QA','QA_QWB_ADD_PROMPT');
2248: -- jdr_docbuilder.setattribute(l_add_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2249:
2250: l_footer := create_jrad_region_item('tableFooter');
2251: jdr_docbuilder.setattribute(l_footer, 'id', 'resultFooter');
2252:
2253: -- add button to footer
2254: add_child_to_parent(l_footer, l_add_btn, 'contents');
2255:
2259:
2260: END create_table_footer;
2261:
2262: -- add table action to table or advanced table
2263: PROCEDURE add_table_action(p_prnt_elm IN jdr_docbuilder.element ) IS
2264: l_tbl_act jdr_docbuilder.element := NULL;
2265: BEGIN
2266: -- add table actions to table or advanced table
2267: l_tbl_act := create_table_action_region;
2260: END create_table_footer;
2261:
2262: -- add table action to table or advanced table
2263: PROCEDURE add_table_action(p_prnt_elm IN jdr_docbuilder.element ) IS
2264: l_tbl_act jdr_docbuilder.element := NULL;
2265: BEGIN
2266: -- add table actions to table or advanced table
2267: l_tbl_act := create_table_action_region;
2268: add_child_to_parent(p_prnt_elm, l_tbl_act, 'tableActions');
2269: END add_table_action;
2270:
2271:
2272: -- add table single selection to table or advanced table
2273: PROCEDURE add_table_selection(p_prnt_elm IN jdr_docbuilder.element )IS
2274: l_tbl_s_sel jdr_docbuilder.element := NULL;
2275: BEGIN
2276: -- add ingle selection to table or advanced table
2277: l_tbl_s_sel := create_table_selection;
2270:
2271:
2272: -- add table single selection to table or advanced table
2273: PROCEDURE add_table_selection(p_prnt_elm IN jdr_docbuilder.element )IS
2274: l_tbl_s_sel jdr_docbuilder.element := NULL;
2275: BEGIN
2276: -- add ingle selection to table or advanced table
2277: l_tbl_s_sel := create_table_selection;
2278: add_child_to_parent(p_prnt_elm, l_tbl_s_sel, 'tableSelection');
2279: END add_table_selection;
2280:
2281:
2282: -- add footer to advanced table
2283: PROCEDURE add_table_footer(p_prnt_elm IN jdr_docbuilder.element) IS
2284: l_tbl_footer jdr_docbuilder.element := NULL;
2285: BEGIN
2286: -- add footer to table or advanced table
2287: l_tbl_footer := create_table_footer;
2280:
2281:
2282: -- add footer to advanced table
2283: PROCEDURE add_table_footer(p_prnt_elm IN jdr_docbuilder.element) IS
2284: l_tbl_footer jdr_docbuilder.element := NULL;
2285: BEGIN
2286: -- add footer to table or advanced table
2287: l_tbl_footer := create_table_footer;
2288: add_child_to_parent(p_prnt_elm, l_tbl_footer, 'footer');
2297: --
2298:
2299: PROCEDURE add_device_checkbox_to_parent(
2300: p_plan_id IN NUMBER,
2301: p_parent_region JDR_DOCBUILDER.ELEMENT) IS
2302:
2303: l_api_name CONSTANT VARCHAR2(50) := 'ADD_DEVICE_CHECKBOX_TO_PARENT';
2304: l_messageCompLayout JDR_DOCBUILDER.ELEMENT := NULL;
2305: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2300: p_plan_id IN NUMBER,
2301: p_parent_region JDR_DOCBUILDER.ELEMENT) IS
2302:
2303: l_api_name CONSTANT VARCHAR2(50) := 'ADD_DEVICE_CHECKBOX_TO_PARENT';
2304: l_messageCompLayout JDR_DOCBUILDER.ELEMENT := NULL;
2305: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2306: l_prompt VARCHAR2(100);
2307: l_element_prefix VARCHAR2(15) := g_element_prefix;
2308: l_element_suffix VARCHAR2(15) := g_device_element_suffix;
2301: p_parent_region JDR_DOCBUILDER.ELEMENT) IS
2302:
2303: l_api_name CONSTANT VARCHAR2(50) := 'ADD_DEVICE_CHECKBOX_TO_PARENT';
2304: l_messageCompLayout JDR_DOCBUILDER.ELEMENT := NULL;
2305: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2306: l_prompt VARCHAR2(100);
2307: l_element_prefix VARCHAR2(15) := g_element_prefix;
2308: l_element_suffix VARCHAR2(15) := g_device_element_suffix;
2309: l_attribute_code VARCHAR2(30);
2323: ORDER BY qpc.prompt_sequence;
2324:
2325: BEGIN
2326: log_error(g_pkg_name || l_api_name, 'Procedure BEGIN');
2327: l_messageCompLayout := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'messageComponentLayout');
2328: jdr_docbuilder.setAttribute(l_messageCompLayout, 'id', 'ChkBoxRN');
2329: jdr_docbuilder.setAttribute(l_messageCompLayout, 'rows', '1');
2330: jdr_docbuilder.setAttribute(l_messageCompLayout, 'columns', '4');
2331: log_error(g_pkg_name || l_api_name, 'message componenet layput created');
2324:
2325: BEGIN
2326: log_error(g_pkg_name || l_api_name, 'Procedure BEGIN');
2327: l_messageCompLayout := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'messageComponentLayout');
2328: jdr_docbuilder.setAttribute(l_messageCompLayout, 'id', 'ChkBoxRN');
2329: jdr_docbuilder.setAttribute(l_messageCompLayout, 'rows', '1');
2330: jdr_docbuilder.setAttribute(l_messageCompLayout, 'columns', '4');
2331: log_error(g_pkg_name || l_api_name, 'message componenet layput created');
2332:
2325: BEGIN
2326: log_error(g_pkg_name || l_api_name, 'Procedure BEGIN');
2327: l_messageCompLayout := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'messageComponentLayout');
2328: jdr_docbuilder.setAttribute(l_messageCompLayout, 'id', 'ChkBoxRN');
2329: jdr_docbuilder.setAttribute(l_messageCompLayout, 'rows', '1');
2330: jdr_docbuilder.setAttribute(l_messageCompLayout, 'columns', '4');
2331: log_error(g_pkg_name || l_api_name, 'message componenet layput created');
2332:
2333: FOR r in c LOOP
2326: log_error(g_pkg_name || l_api_name, 'Procedure BEGIN');
2327: l_messageCompLayout := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'messageComponentLayout');
2328: jdr_docbuilder.setAttribute(l_messageCompLayout, 'id', 'ChkBoxRN');
2329: jdr_docbuilder.setAttribute(l_messageCompLayout, 'rows', '1');
2330: jdr_docbuilder.setAttribute(l_messageCompLayout, 'columns', '4');
2331: log_error(g_pkg_name || l_api_name, 'message componenet layput created');
2332:
2333: FOR r in c LOOP
2334: l_char_item := create_jrad_region_item('messageCheckBox');
2334: l_char_item := create_jrad_region_item('messageCheckBox');
2335: l_prompt := get_prompt(p_plan_id, r.char_id);
2336: l_attribute_code := construct_code(l_element_prefix, r.char_id, l_element_suffix);
2337:
2338: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2339: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2340: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2341: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2342: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2335: l_prompt := get_prompt(p_plan_id, r.char_id);
2336: l_attribute_code := construct_code(l_element_prefix, r.char_id, l_element_suffix);
2337:
2338: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2339: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2340: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2341: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2342: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2343: add_child_to_parent(l_messageCompLayout, l_char_item,'contents');
2336: l_attribute_code := construct_code(l_element_prefix, r.char_id, l_element_suffix);
2337:
2338: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2339: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2340: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2341: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2342: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2343: add_child_to_parent(l_messageCompLayout, l_char_item,'contents');
2344: log_error(g_pkg_name || l_api_name, 'checkbox created for element: ' || l_prompt);
2337:
2338: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2339: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2340: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2341: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2342: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2343: add_child_to_parent(l_messageCompLayout, l_char_item,'contents');
2344: log_error(g_pkg_name || l_api_name, 'checkbox created for element: ' || l_prompt);
2345: END LOOP;
2338: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2339: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2340: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2341: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2342: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2343: add_child_to_parent(l_messageCompLayout, l_char_item,'contents');
2344: log_error(g_pkg_name || l_api_name, 'checkbox created for element: ' || l_prompt);
2345: END LOOP;
2346:
2348: log_error(g_pkg_name || l_api_name, 'Procedure END');
2349: END add_device_checkbox_to_parent;
2350:
2351: FUNCTION create_device_button_region
2352: RETURN JDR_DOCBUILDER.ELEMENT IS
2353: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_BUTTON_REGION';
2354: l_button_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2355: l_button_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2356: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2350:
2351: FUNCTION create_device_button_region
2352: RETURN JDR_DOCBUILDER.ELEMENT IS
2353: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_BUTTON_REGION';
2354: l_button_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2355: l_button_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2356: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2357: l_prompt VARCHAR2(30);
2358:
2351: FUNCTION create_device_button_region
2352: RETURN JDR_DOCBUILDER.ELEMENT IS
2353: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_BUTTON_REGION';
2354: l_button_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2355: l_button_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2356: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2357: l_prompt VARCHAR2(30);
2358:
2359: --PPRTEST
2352: RETURN JDR_DOCBUILDER.ELEMENT IS
2353: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_BUTTON_REGION';
2354: l_button_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2355: l_button_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2356: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2357: l_prompt VARCHAR2(30);
2358:
2359: --PPRTEST
2360: ppr_event jdr_docbuilder.ELEMENT;
2356: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2357: l_prompt VARCHAR2(30);
2358:
2359: --PPRTEST
2360: ppr_event jdr_docbuilder.ELEMENT;
2361: BEGIN
2362: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2363: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2364: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2359: --PPRTEST
2360: ppr_event jdr_docbuilder.ELEMENT;
2361: BEGIN
2362: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2363: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2364: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2365: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2366: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2367: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2360: ppr_event jdr_docbuilder.ELEMENT;
2361: BEGIN
2362: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2363: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2364: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2365: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2366: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2367: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2368:
2361: BEGIN
2362: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2363: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2364: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2365: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2366: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2367: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2368:
2369: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2362: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2363: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2364: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2365: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2366: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2367: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2368:
2369: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2370: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2363: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2364: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2365: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2366: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2367: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2368:
2369: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2370: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2371: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2365: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2366: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2367: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2368:
2369: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2370: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2371: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2372: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2373: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2366: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2367: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2368:
2369: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2370: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2371: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2372: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2373: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2374:
2367: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2368:
2369: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2370: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2371: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2372: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2373: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2374:
2375: l_submit_button := create_jrad_region_item('submitButton');
2368:
2369: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2370: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2371: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2372: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2373: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2374:
2375: l_submit_button := create_jrad_region_item('submitButton');
2376: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2369: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2370: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2371: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2372: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2373: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2374:
2375: l_submit_button := create_jrad_region_item('submitButton');
2376: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2377: jdr_docbuilder.setAttribute(l_submit_button, 'id', 'ReadDeviceButton');
2373: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2374:
2375: l_submit_button := create_jrad_region_item('submitButton');
2376: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2377: jdr_docbuilder.setAttribute(l_submit_button, 'id', 'ReadDeviceButton');
2378: jdr_docbuilder.setAttribute(l_submit_button, 'prompt', l_prompt);
2379: jdr_docbuilder.setAttribute(l_submit_button, 'unvalidated', 'true');
2380: -- bug 6737113
2381: -- Added accessKey for Read Device as O.
2374:
2375: l_submit_button := create_jrad_region_item('submitButton');
2376: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2377: jdr_docbuilder.setAttribute(l_submit_button, 'id', 'ReadDeviceButton');
2378: jdr_docbuilder.setAttribute(l_submit_button, 'prompt', l_prompt);
2379: jdr_docbuilder.setAttribute(l_submit_button, 'unvalidated', 'true');
2380: -- bug 6737113
2381: -- Added accessKey for Read Device as O.
2382: -- bhsankar Tue Jan 22 04:12:09 PST 2008
2375: l_submit_button := create_jrad_region_item('submitButton');
2376: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2377: jdr_docbuilder.setAttribute(l_submit_button, 'id', 'ReadDeviceButton');
2378: jdr_docbuilder.setAttribute(l_submit_button, 'prompt', l_prompt);
2379: jdr_docbuilder.setAttribute(l_submit_button, 'unvalidated', 'true');
2380: -- bug 6737113
2381: -- Added accessKey for Read Device as O.
2382: -- bhsankar Tue Jan 22 04:12:09 PST 2008
2383: jdr_docbuilder.setAttribute(l_submit_button, 'accessKey', '0');
2379: jdr_docbuilder.setAttribute(l_submit_button, 'unvalidated', 'true');
2380: -- bug 6737113
2381: -- Added accessKey for Read Device as O.
2382: -- bhsankar Tue Jan 22 04:12:09 PST 2008
2383: jdr_docbuilder.setAttribute(l_submit_button, 'accessKey', '0');
2384: jdr_docbuilder.setAttribute(l_submit_button, 'serverUnvalidated', 'true');
2385:
2386: --For PPR
2387: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2380: -- bug 6737113
2381: -- Added accessKey for Read Device as O.
2382: -- bhsankar Tue Jan 22 04:12:09 PST 2008
2383: jdr_docbuilder.setAttribute(l_submit_button, 'accessKey', '0');
2384: jdr_docbuilder.setAttribute(l_submit_button, 'serverUnvalidated', 'true');
2385:
2386: --For PPR
2387: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2388: p_tagName => 'firePartialAction');
2383: jdr_docbuilder.setAttribute(l_submit_button, 'accessKey', '0');
2384: jdr_docbuilder.setAttribute(l_submit_button, 'serverUnvalidated', 'true');
2385:
2386: --For PPR
2387: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2388: p_tagName => 'firePartialAction');
2389: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2390: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2391:
2385:
2386: --For PPR
2387: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2388: p_tagName => 'firePartialAction');
2389: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2390: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2391:
2392: jdr_docbuilder.addchild(p_parent => l_submit_button,
2393: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2386: --For PPR
2387: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2388: p_tagName => 'firePartialAction');
2389: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2390: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2391:
2392: jdr_docbuilder.addchild(p_parent => l_submit_button,
2393: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2394: p_groupingTagName => 'primaryClientAction',
2388: p_tagName => 'firePartialAction');
2389: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2390: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2391:
2392: jdr_docbuilder.addchild(p_parent => l_submit_button,
2393: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2394: p_groupingTagName => 'primaryClientAction',
2395: p_child => ppr_event);
2396:
2389: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2390: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2391:
2392: jdr_docbuilder.addchild(p_parent => l_submit_button,
2393: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2394: p_groupingTagName => 'primaryClientAction',
2395: p_child => ppr_event);
2396:
2397: add_child_to_parent(l_button_cellformat_region,l_submit_button,'contents');
2401:
2402: END create_device_button_region;
2403:
2404: FUNCTION create_device_checkbox_region(
2405: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
2406:
2407: l_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2408: l_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2409: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2403:
2404: FUNCTION create_device_checkbox_region(
2405: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
2406:
2407: l_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2408: l_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2409: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2410: BEGIN
2411: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2404: FUNCTION create_device_checkbox_region(
2405: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
2406:
2407: l_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2408: l_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2409: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2410: BEGIN
2411: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2412: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2408: l_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2409: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2410: BEGIN
2411: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2412: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2413: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2414: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2415:
2416: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2409: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2410: BEGIN
2411: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2412: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2413: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2414: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2415:
2416: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2417: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2410: BEGIN
2411: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2412: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2413: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2414: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2415:
2416: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2417: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2418: jdr_docbuilder.setAttribute(l_cellformat_region, 'width', '100%');
2412: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2413: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2414: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2415:
2416: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2417: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2418: jdr_docbuilder.setAttribute(l_cellformat_region, 'width', '100%');
2419:
2420: add_device_checkbox_to_parent(p_plan_id, l_cellformat_region);
2413: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2414: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2415:
2416: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2417: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2418: jdr_docbuilder.setAttribute(l_cellformat_region, 'width', '100%');
2419:
2420: add_device_checkbox_to_parent(p_plan_id, l_cellformat_region);
2421: add_child_to_parent(l_rowlayout_region,l_cellformat_region,'contents');
2414: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2415:
2416: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2417: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2418: jdr_docbuilder.setAttribute(l_cellformat_region, 'width', '100%');
2419:
2420: add_device_checkbox_to_parent(p_plan_id, l_cellformat_region);
2421: add_child_to_parent(l_rowlayout_region,l_cellformat_region,'contents');
2422: log_error(g_pkg_name || l_api_name, 'Function END');
2426:
2427: FUNCTION create_device_region(
2428: p_plan_id IN NUMBER,
2429: p_device_region_code IN VARCHAR2 DEFAULT g_eqr_device_prefix,
2430: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
2431: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2432: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2433: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2434: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2428: p_plan_id IN NUMBER,
2429: p_device_region_code IN VARCHAR2 DEFAULT g_eqr_device_prefix,
2430: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
2431: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2432: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2433: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2434: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2435: l_checkbox_region JDR_DOCBUILDER.ELEMENT := NULL;
2436:
2429: p_device_region_code IN VARCHAR2 DEFAULT g_eqr_device_prefix,
2430: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
2431: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2432: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2433: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2434: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2435: l_checkbox_region JDR_DOCBUILDER.ELEMENT := NULL;
2436:
2437: l_prompt VARCHAR2(100) := null;
2430: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
2431: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2432: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2433: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2434: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2435: l_checkbox_region JDR_DOCBUILDER.ELEMENT := NULL;
2436:
2437: l_prompt VARCHAR2(100) := null;
2438:
2431: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2432: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2433: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2434: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2435: l_checkbox_region JDR_DOCBUILDER.ELEMENT := NULL;
2436:
2437: l_prompt VARCHAR2(100) := null;
2438:
2439:
2477: l_saved PLS_INTEGER;
2478: l_err_num NUMBER;
2479: l_err_msg VARCHAR2(100);
2480:
2481: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2482: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2483: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2484: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2485: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2478: l_err_num NUMBER;
2479: l_err_msg VARCHAR2(100);
2480:
2481: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2482: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2483: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2484: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2485: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2486:
2479: l_err_msg VARCHAR2(100);
2480:
2481: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2482: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2483: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2484: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2485: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2486:
2487: --
2480:
2481: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2482: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2483: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2484: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2485: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2486:
2487: --
2488: -- 12.1 Device Integration Project
2481: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2482: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2483: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2484: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2485: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2486:
2487: --
2488: -- 12.1 Device Integration Project
2489: -- Functions to create the device region
2489: -- Functions to create the device region
2490: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
2491: --
2492: l_device_region_code VARCHAR2(35) := NULL;
2493: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
2494: l_api_name CONSTANT VARCHAR2(50) := 'map_plan_eqr_single';
2495:
2496: BEGIN
2497: -- this version of map_plan_eqr_single takes in prefix of top region, data region and comment region
2549: add_child_to_parent(l_top_region, l_attachments_region, 'contents');
2550: END IF;
2551:
2552: -- save the document
2553: l_saved := JDR_DOCBUILDER.SAVE;
2554:
2555: log_error(g_pkg_name || l_api_name, ' Function END');
2556:
2557: EXCEPTION
2586: l_saved PLS_INTEGER;
2587: l_err_num NUMBER;
2588: l_err_msg VARCHAR2(100);
2589:
2590: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2591: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2592: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2593: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2594: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2587: l_err_num NUMBER;
2588: l_err_msg VARCHAR2(100);
2589:
2590: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2591: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2592: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2593: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2594: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2595:
2588: l_err_msg VARCHAR2(100);
2589:
2590: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2591: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2592: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2593: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2594: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2595:
2596: BEGIN
2589:
2590: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2591: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2592: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2593: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2594: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2595:
2596: BEGIN
2597: -- Similar to map_plan_eqr_single logic
2590: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2591: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2592: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2593: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2594: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2595:
2596: BEGIN
2597: -- Similar to map_plan_eqr_single logic
2598:
2628: add_child_to_parent(l_top_region, l_attachments_region, 'contents');
2629: END IF;
2630:
2631: -- save the document
2632: l_saved := JDR_DOCBUILDER.SAVE;
2633:
2634: EXCEPTION
2635:
2636: WHEN OTHERS THEN
2692:
2693:
2694: FUNCTION create_item_for_mult_vqr( p_plan_id IN NUMBER,
2695: p_char_id IN NUMBER,
2696: x_char_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT,
2697: x_char_dtl_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT)
2698: RETURN VARCHAR2 IS
2699:
2700: l_vo_attribute_name VARCHAR2(50);
2693:
2694: FUNCTION create_item_for_mult_vqr( p_plan_id IN NUMBER,
2695: p_char_id IN NUMBER,
2696: x_char_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT,
2697: x_char_dtl_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT)
2698: RETURN VARCHAR2 IS
2699:
2700: l_vo_attribute_name VARCHAR2(50);
2701: l_attr_code VARCHAR2(50);
2706: c_datatype VARCHAR2(30);
2707:
2708: l_displayed_flag NUMBER;
2709:
2710: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2711: l_char_item JDR_DOCBUILDER.ELEMENT;
2712: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2713: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2714:
2707:
2708: l_displayed_flag NUMBER;
2709:
2710: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2711: l_char_item JDR_DOCBUILDER.ELEMENT;
2712: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2713: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2714:
2715: l_datatype qa_chars.datatype%TYPE;
2708: l_displayed_flag NUMBER;
2709:
2710: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2711: l_char_item JDR_DOCBUILDER.ELEMENT;
2712: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2713: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2714:
2715: l_datatype qa_chars.datatype%TYPE;
2716:
2709:
2710: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2711: l_char_item JDR_DOCBUILDER.ELEMENT;
2712: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2713: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2714:
2715: l_datatype qa_chars.datatype%TYPE;
2716:
2717:
2717:
2718: BEGIN
2719: l_attr_code := construct_code(g_element_prefix, p_char_id);
2720: l_col_code := 'column' || l_attr_code;
2721: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
2722: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
2723:
2724:
2725: l_char_item := create_region_item_for_vqr(p_plan_id, p_char_id,
2718: BEGIN
2719: l_attr_code := construct_code(g_element_prefix, p_char_id);
2720: l_col_code := 'column' || l_attr_code;
2721: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
2722: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
2723:
2724:
2725: l_char_item := create_region_item_for_vqr(p_plan_id, p_char_id,
2726: g_element_prefix, g_vqr_multiple_layout);
2727: l_char_dtl_item := create_region_item_for_vqr(p_plan_id, p_char_id,
2728: g_dtl_element_prefix, g_vqr_multiple_layout);
2729:
2730: l_vo_attribute_name := get_export_vo_attribute_name(p_plan_id, p_char_id);
2731: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2732: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2733: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2734: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2735:
2728: g_dtl_element_prefix, g_vqr_multiple_layout);
2729:
2730: l_vo_attribute_name := get_export_vo_attribute_name(p_plan_id, p_char_id);
2731: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2732: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2733: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2734: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2735:
2736: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2729:
2730: l_vo_attribute_name := get_export_vo_attribute_name(p_plan_id, p_char_id);
2731: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2732: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2733: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2734: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2735:
2736: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2737: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2730: l_vo_attribute_name := get_export_vo_attribute_name(p_plan_id, p_char_id);
2731: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2732: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2733: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2734: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2735:
2736: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2737: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2738: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2732: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2733: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2734: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2735:
2736: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2737: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2738: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2739:
2740:
2733: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2734: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2735:
2736: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2737: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2738: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2739:
2740:
2741: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2734: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2735:
2736: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2737: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2738: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2739:
2740:
2741: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2742:
2740:
2741: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2742:
2743: l_hrd_code := 'colHdr' || l_attr_code;
2744: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2745: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2746: l_prompt := get_prompt(p_plan_id, p_char_id);
2747: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2748: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2741: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2742:
2743: l_hrd_code := 'colHdr' || l_attr_code;
2744: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2745: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2746: l_prompt := get_prompt(p_plan_id, p_char_id);
2747: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2748: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2749: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2743: l_hrd_code := 'colHdr' || l_attr_code;
2744: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2745: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2746: l_prompt := get_prompt(p_plan_id, p_char_id);
2747: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2748: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2749: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2750: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2751:
2744: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2745: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2746: l_prompt := get_prompt(p_plan_id, p_char_id);
2747: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2748: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2749: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2750: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2751:
2752: l_datatype := qa_chars_api.datatype(p_char_id);
2745: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2746: l_prompt := get_prompt(p_plan_id, p_char_id);
2747: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2748: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2749: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2750: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2751:
2752: l_datatype := qa_chars_api.datatype(p_char_id);
2753: c_datatype := convert_data_type(l_datatype);
2750: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2751:
2752: l_datatype := qa_chars_api.datatype(p_char_id);
2753: c_datatype := convert_data_type(l_datatype);
2754: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2755:
2756: -- jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
2757: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'dataType', c_datatype);
2758:
2752: l_datatype := qa_chars_api.datatype(p_char_id);
2753: c_datatype := convert_data_type(l_datatype);
2754: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2755:
2756: -- jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
2757: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'dataType', c_datatype);
2758:
2759: x_char_item := l_col_hdr;
2760: x_char_dtl_item := l_char_dtl_item;
2753: c_datatype := convert_data_type(l_datatype);
2754: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2755:
2756: -- jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
2757: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'dataType', c_datatype);
2758:
2759: x_char_item := l_col_hdr;
2760: x_char_dtl_item := l_char_dtl_item;
2761:
2762: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
2763: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
2764:
2765: if c_displayed_flag = 'true' then
2766: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2767: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2768: end if;
2769:
2770: return c_displayed_flag;
2763: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
2764:
2765: if c_displayed_flag = 'true' then
2766: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2767: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2768: end if;
2769:
2770: return c_displayed_flag;
2771:
2772:
2773: END create_item_for_mult_vqr;
2774:
2775: PROCEDURE create_special_item_mult_vqr( p_attribute_code IN VARCHAR2,
2776: x_char_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT,
2777: x_char_dtl_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT)
2778: IS
2779:
2780: l_vo_attribute_name VARCHAR2(50);
2773: END create_item_for_mult_vqr;
2774:
2775: PROCEDURE create_special_item_mult_vqr( p_attribute_code IN VARCHAR2,
2776: x_char_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT,
2777: x_char_dtl_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT)
2778: IS
2779:
2780: l_vo_attribute_name VARCHAR2(50);
2781: l_attr_code VARCHAR2(50);
2782: l_col_code VARCHAR2(50);
2783: l_hrd_code VARCHAR2(50);
2784: l_prompt VARCHAR2(50);
2785:
2786: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2787: l_char_item JDR_DOCBUILDER.ELEMENT;
2788: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2789: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2790:
2783: l_hrd_code VARCHAR2(50);
2784: l_prompt VARCHAR2(50);
2785:
2786: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2787: l_char_item JDR_DOCBUILDER.ELEMENT;
2788: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2789: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2790:
2791: BEGIN
2784: l_prompt VARCHAR2(50);
2785:
2786: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2787: l_char_item JDR_DOCBUILDER.ELEMENT;
2788: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2789: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2790:
2791: BEGIN
2792:
2785:
2786: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2787: l_char_item JDR_DOCBUILDER.ELEMENT;
2788: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2789: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2790:
2791: BEGIN
2792:
2793: l_attr_code := construct_code(g_element_prefix, p_attribute_code);
2791: BEGIN
2792:
2793: l_attr_code := construct_code(g_element_prefix, p_attribute_code);
2794: l_col_code := 'column' || l_attr_code;
2795: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
2796: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
2797:
2798: l_char_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2799: g_element_prefix, g_vqr_multiple_layout);
2792:
2793: l_attr_code := construct_code(g_element_prefix, p_attribute_code);
2794: l_col_code := 'column' || l_attr_code;
2795: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
2796: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
2797:
2798: l_char_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2799: g_element_prefix, g_vqr_multiple_layout);
2800: l_char_dtl_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2799: g_element_prefix, g_vqr_multiple_layout);
2800: l_char_dtl_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2801: g_dtl_element_prefix, g_vqr_multiple_layout);
2802:
2803: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2804: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2805: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2806:
2807: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2800: l_char_dtl_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2801: g_dtl_element_prefix, g_vqr_multiple_layout);
2802:
2803: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2804: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2805: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2806:
2807: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2808:
2801: g_dtl_element_prefix, g_vqr_multiple_layout);
2802:
2803: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2804: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2805: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2806:
2807: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2808:
2809: l_hrd_code := 'colHdr' || l_attr_code;
2806:
2807: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2808:
2809: l_hrd_code := 'colHdr' || l_attr_code;
2810: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2811: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2812: l_prompt := get_special_item_label(p_attribute_code);
2813: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2814: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2807: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2808:
2809: l_hrd_code := 'colHdr' || l_attr_code;
2810: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2811: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2812: l_prompt := get_special_item_label(p_attribute_code);
2813: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2814: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2815: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2809: l_hrd_code := 'colHdr' || l_attr_code;
2810: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2811: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2812: l_prompt := get_special_item_label(p_attribute_code);
2813: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2814: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2815: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2816: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2817:
2810: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2811: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2812: l_prompt := get_special_item_label(p_attribute_code);
2813: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2814: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2815: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2816: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2817:
2818:
2811: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2812: l_prompt := get_special_item_label(p_attribute_code);
2813: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2814: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2815: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2816: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2817:
2818:
2819: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2815: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2816: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2817:
2818:
2819: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2820:
2821: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2822: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2823:
2817:
2818:
2819: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2820:
2821: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2822: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2823:
2824:
2825: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2818:
2819: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2820:
2821: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2822: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2823:
2824:
2825: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2826: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2822: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2823:
2824:
2825: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2826: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2827: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2828: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2829: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2830:
2823:
2824:
2825: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2826: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2827: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2828: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2829: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2830:
2831:
2824:
2825: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2826: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2827: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2828: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2829: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2830:
2831:
2832:
2825: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2826: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2827: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2828: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2829: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2830:
2831:
2832:
2833: x_char_item := l_col_hdr;
2854: l_displayed_flag NUMBER;
2855: c_displayed_flag VARCHAR2(10);
2856:
2857:
2858: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2859: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2860: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2861: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2862: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2855: c_displayed_flag VARCHAR2(10);
2856:
2857:
2858: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2859: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2860: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2861: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2862: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2863: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2856:
2857:
2858: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2859: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2860: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2861: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2862: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2863: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2864: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2857:
2858: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2859: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2860: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2861: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2862: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2863: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2864: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2865:
2858: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2859: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2860: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2861: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2862: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2863: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2864: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2865:
2866:
2859: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2860: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2861: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2862: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2863: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2864: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2865:
2866:
2867: CURSOR plan_chars (p_char_type VARCHAR2)IS
2860: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2861: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2862: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2863: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2864: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2865:
2866:
2867: CURSOR plan_chars (p_char_type VARCHAR2)IS
2868: SELECT qpc.char_id
2889: l_top_doc := create_top_document(g_jrad_region_path || l_top_region_code);
2890:
2891: l_prompt := get_region_prompt('DATA');
2892: l_top_region := create_jrad_region (l_top_region_code, 'advancedTable', l_prompt, null, g_vqr_multiple_layout);
2893: jdr_docbuilder.setAttribute(l_top_region, 'width', '100%');
2894: JDR_DOCBUILDER.setTopLevelElement(l_top_doc, l_top_region);
2895: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_export_vo_name);
2896:
2897: -- create the detail container region
2890:
2891: l_prompt := get_region_prompt('DATA');
2892: l_top_region := create_jrad_region (l_top_region_code, 'advancedTable', l_prompt, null, g_vqr_multiple_layout);
2893: jdr_docbuilder.setAttribute(l_top_region, 'width', '100%');
2894: JDR_DOCBUILDER.setTopLevelElement(l_top_doc, l_top_region);
2895: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_export_vo_name);
2896:
2897: -- create the detail container region
2898: l_dtl_region_code := construct_code(g_vqr_mult_dtl_prefix, p_plan_id);
2891: l_prompt := get_region_prompt('DATA');
2892: l_top_region := create_jrad_region (l_top_region_code, 'advancedTable', l_prompt, null, g_vqr_multiple_layout);
2893: jdr_docbuilder.setAttribute(l_top_region, 'width', '100%');
2894: JDR_DOCBUILDER.setTopLevelElement(l_top_doc, l_top_region);
2895: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_export_vo_name);
2896:
2897: -- create the detail container region
2898: l_dtl_region_code := construct_code(g_vqr_mult_dtl_prefix, p_plan_id);
2899: l_dtl_region := create_jrad_region(l_dtl_region_code, 'stackLayout', null, '-1');
2918: add_child_to_parent(l_top_region, l_char_item, 'contents');
2919: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2920:
2921: if c_displayed_flag = 'false' then
2922: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
2923: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', c_displayed_flag);
2924: elsif c_displayed_flag = 'true' then
2925: if l_counter < 5 then
2926: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2919: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2920:
2921: if c_displayed_flag = 'false' then
2922: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
2923: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', c_displayed_flag);
2924: elsif c_displayed_flag = 'true' then
2925: if l_counter < 5 then
2926: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2927: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2922: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
2923: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', c_displayed_flag);
2924: elsif c_displayed_flag = 'true' then
2925: if l_counter < 5 then
2926: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2927: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2928: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2929: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2930: l_counter := l_counter + 1;
2923: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', c_displayed_flag);
2924: elsif c_displayed_flag = 'true' then
2925: if l_counter < 5 then
2926: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2927: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2928: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2929: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2930: l_counter := l_counter + 1;
2931: else
2924: elsif c_displayed_flag = 'true' then
2925: if l_counter < 5 then
2926: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2927: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2928: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2929: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2930: l_counter := l_counter + 1;
2931: else
2932: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2925: if l_counter < 5 then
2926: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2927: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2928: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2929: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2930: l_counter := l_counter + 1;
2931: else
2932: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2933: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2928: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2929: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2930: l_counter := l_counter + 1;
2931: else
2932: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2933: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2934: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2935: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2936: end if;
2929: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2930: l_counter := l_counter + 1;
2931: else
2932: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2933: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2934: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2935: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2936: end if;
2937: end if;
2930: l_counter := l_counter + 1;
2931: else
2932: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2933: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2934: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2935: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2936: end if;
2937: end if;
2938:
2931: else
2932: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2933: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2934: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2935: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2936: end if;
2937: end if;
2938:
2939: end loop;
2943: create_special_item_mult_vqr(g_qa_created_by_attribute, l_char_item, l_char_dtl_item);
2944: add_child_to_parent(l_top_region, l_char_item, 'contents');
2945: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2946: if l_counter < 5 then
2947: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2948: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2949: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2950: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2951: l_counter := l_counter + 1;
2944: add_child_to_parent(l_top_region, l_char_item, 'contents');
2945: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2946: if l_counter < 5 then
2947: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2948: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2949: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2950: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2951: l_counter := l_counter + 1;
2952: else
2945: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2946: if l_counter < 5 then
2947: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2948: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2949: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2950: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2951: l_counter := l_counter + 1;
2952: else
2953: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2946: if l_counter < 5 then
2947: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2948: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2949: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2950: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2951: l_counter := l_counter + 1;
2952: else
2953: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2954: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2949: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2950: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2951: l_counter := l_counter + 1;
2952: else
2953: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2954: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2955: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2956: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2957: end if;
2950: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2951: l_counter := l_counter + 1;
2952: else
2953: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2954: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2955: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2956: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2957: end if;
2958:
2951: l_counter := l_counter + 1;
2952: else
2953: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2954: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2955: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2956: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2957: end if;
2958:
2959:
2952: else
2953: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2954: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2955: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2956: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2957: end if;
2958:
2959:
2960:
2962: create_special_item_mult_vqr(g_collection_id_attribute, l_char_item, l_char_dtl_item);
2963: add_child_to_parent(l_top_region, l_char_item, 'contents');
2964: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2965: if l_counter < 5 then
2966: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2967: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2968: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2969: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2970: l_counter := l_counter + 1;
2963: add_child_to_parent(l_top_region, l_char_item, 'contents');
2964: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2965: if l_counter < 5 then
2966: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2967: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2968: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2969: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2970: l_counter := l_counter + 1;
2971: else
2964: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2965: if l_counter < 5 then
2966: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2967: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2968: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2969: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2970: l_counter := l_counter + 1;
2971: else
2972: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2965: if l_counter < 5 then
2966: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2967: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2968: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2969: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2970: l_counter := l_counter + 1;
2971: else
2972: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2973: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2968: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2969: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2970: l_counter := l_counter + 1;
2971: else
2972: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2973: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2974: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2975: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2976: end if;
2969: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2970: l_counter := l_counter + 1;
2971: else
2972: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2973: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2974: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2975: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2976: end if;
2977:
2970: l_counter := l_counter + 1;
2971: else
2972: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2973: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2974: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2975: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2976: end if;
2977:
2978:
2971: else
2972: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2973: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2974: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2975: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2976: end if;
2977:
2978:
2979:
2980: create_special_item_mult_vqr(g_last_update_date_attribute, l_char_item, l_char_dtl_item);
2981: add_child_to_parent(l_top_region, l_char_item, 'contents');
2982: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2983: if l_counter < 5 then
2984: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2985: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2986: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2987: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2988: l_counter := l_counter + 1;
2981: add_child_to_parent(l_top_region, l_char_item, 'contents');
2982: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2983: if l_counter < 5 then
2984: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2985: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2986: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2987: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2988: l_counter := l_counter + 1;
2989: else
2982: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
2983: if l_counter < 5 then
2984: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2985: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2986: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2987: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2988: l_counter := l_counter + 1;
2989: else
2990: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2983: if l_counter < 5 then
2984: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
2985: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
2986: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2987: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2988: l_counter := l_counter + 1;
2989: else
2990: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2991: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2986: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2987: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2988: l_counter := l_counter + 1;
2989: else
2990: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2991: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2992: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2993: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2994: end if;
2987: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
2988: l_counter := l_counter + 1;
2989: else
2990: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2991: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2992: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2993: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2994: end if;
2995:
2988: l_counter := l_counter + 1;
2989: else
2990: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2991: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2992: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2993: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2994: end if;
2995:
2996:
2989: else
2990: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
2991: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
2992: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
2993: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2994: end if;
2995:
2996:
2997:
3006: end if;
3007: -- add to comment items to the region
3008: c_displayed_flag := create_item_for_mult_vqr(p_plan_id, rec.char_id, l_char_item, l_char_dtl_item);
3009: add_child_to_parent(l_comments_region, l_char_dtl_item, 'contents');
3010: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
3011: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', 'OraTableDetail');
3012:
3013: -- if c_displayed_flag = 'true' then
3014: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3007: -- add to comment items to the region
3008: c_displayed_flag := create_item_for_mult_vqr(p_plan_id, rec.char_id, l_char_item, l_char_dtl_item);
3009: add_child_to_parent(l_comments_region, l_char_dtl_item, 'contents');
3010: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
3011: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', 'OraTableDetail');
3012:
3013: -- if c_displayed_flag = 'true' then
3014: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3015: -- end if;
3010: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
3011: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', 'OraTableDetail');
3012:
3013: -- if c_displayed_flag = 'true' then
3014: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3015: -- end if;
3016:
3017: end loop;
3018:
3024: -- now add the detail region to the main region
3025: add_child_to_parent(l_top_region, l_dtl_region, 'detail');
3026:
3027: -- save the document
3028: l_saved := JDR_DOCBUILDER.SAVE;
3029:
3030: EXCEPTION
3031:
3032: WHEN OTHERS THEN
3052: l_err_num NUMBER;
3053: l_err_msg VARCHAR2(100);
3054: l_char_count NUMBER := NULL;
3055:
3056: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
3057: l_table_region JDR_DOCBUILDER.ELEMENT := NULL;
3058: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
3059:
3060: --
3053: l_err_msg VARCHAR2(100);
3054: l_char_count NUMBER := NULL;
3055:
3056: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
3057: l_table_region JDR_DOCBUILDER.ELEMENT := NULL;
3058: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
3059:
3060: --
3061: -- 12.1 Device Integration Project
3054: l_char_count NUMBER := NULL;
3055:
3056: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
3057: l_table_region JDR_DOCBUILDER.ELEMENT := NULL;
3058: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
3059:
3060: --
3061: -- 12.1 Device Integration Project
3062: -- Variables for adding device region
3062: -- Variables for adding device region
3063: -- to the multi row layout.
3064: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
3065: --
3066: l_stk_region JDR_DOCBUILDER.ELEMENT := NULL;
3067: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
3068: l_stk_region_code varchar2(35) := NULL;
3069: l_device_region_code varchar2(35) := NULL;
3070: l_prompt VARCHAR2(30);
3063: -- to the multi row layout.
3064: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
3065: --
3066: l_stk_region JDR_DOCBUILDER.ELEMENT := NULL;
3067: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
3068: l_stk_region_code varchar2(35) := NULL;
3069: l_device_region_code varchar2(35) := NULL;
3070: l_prompt VARCHAR2(30);
3071: BEGIN
3136: add_table_selection(l_table_region);
3137: add_table_action(l_table_region);
3138:
3139: -- save the document
3140: l_saved := JDR_DOCBUILDER.SAVE;
3141:
3142: EXCEPTION
3143:
3144: WHEN OTHERS THEN
3174: l_err_num NUMBER;
3175: l_err_msg VARCHAR2(100);
3176: l_char_count NUMBER := NULL;
3177:
3178: l_top_doc jdr_docbuilder.DOCUMENT := NULL;
3179: l_table_region jdr_docbuilder.element := NULL;
3180: l_dtl_region jdr_docbuilder.element := NULL;
3181:
3182: l_tbl_act jdr_docbuilder.element := NULL;
3175: l_err_msg VARCHAR2(100);
3176: l_char_count NUMBER := NULL;
3177:
3178: l_top_doc jdr_docbuilder.DOCUMENT := NULL;
3179: l_table_region jdr_docbuilder.element := NULL;
3180: l_dtl_region jdr_docbuilder.element := NULL;
3181:
3182: l_tbl_act jdr_docbuilder.element := NULL;
3183: l_tbl_s_sel jdr_docbuilder.element := NULL;
3176: l_char_count NUMBER := NULL;
3177:
3178: l_top_doc jdr_docbuilder.DOCUMENT := NULL;
3179: l_table_region jdr_docbuilder.element := NULL;
3180: l_dtl_region jdr_docbuilder.element := NULL;
3181:
3182: l_tbl_act jdr_docbuilder.element := NULL;
3183: l_tbl_s_sel jdr_docbuilder.element := NULL;
3184: l_tbl_footer jdr_docbuilder.element := NULL;
3178: l_top_doc jdr_docbuilder.DOCUMENT := NULL;
3179: l_table_region jdr_docbuilder.element := NULL;
3180: l_dtl_region jdr_docbuilder.element := NULL;
3181:
3182: l_tbl_act jdr_docbuilder.element := NULL;
3183: l_tbl_s_sel jdr_docbuilder.element := NULL;
3184: l_tbl_footer jdr_docbuilder.element := NULL;
3185: l_api_name constant varchar2(50) := 'MAP_PLAN_ADV_TABLE_EQR';
3186:
3179: l_table_region jdr_docbuilder.element := NULL;
3180: l_dtl_region jdr_docbuilder.element := NULL;
3181:
3182: l_tbl_act jdr_docbuilder.element := NULL;
3183: l_tbl_s_sel jdr_docbuilder.element := NULL;
3184: l_tbl_footer jdr_docbuilder.element := NULL;
3185: l_api_name constant varchar2(50) := 'MAP_PLAN_ADV_TABLE_EQR';
3186:
3187: --
3180: l_dtl_region jdr_docbuilder.element := NULL;
3181:
3182: l_tbl_act jdr_docbuilder.element := NULL;
3183: l_tbl_s_sel jdr_docbuilder.element := NULL;
3184: l_tbl_footer jdr_docbuilder.element := NULL;
3185: l_api_name constant varchar2(50) := 'MAP_PLAN_ADV_TABLE_EQR';
3186:
3187: --
3188: -- 12.1 Device Integration Project
3189: -- Variables for adding device region
3190: -- to the multi row layout.
3191: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
3192: --
3193: l_stk_region JDR_DOCBUILDER.ELEMENT := NULL;
3194: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
3195: l_stk_region_code varchar2(35) := NULL;
3196: l_device_region_code varchar2(35) := NULL;
3197: l_prompt VARCHAR2(30);
3190: -- to the multi row layout.
3191: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
3192: --
3193: l_stk_region JDR_DOCBUILDER.ELEMENT := NULL;
3194: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
3195: l_stk_region_code varchar2(35) := NULL;
3196: l_device_region_code varchar2(35) := NULL;
3197: l_prompt VARCHAR2(30);
3198:
3234: -- to the stack region (top document) already created.
3235: l_prompt := get_region_prompt('DATA');
3236:
3237: l_table_region := create_jrad_region (l_table_region_code, 'advancedTable', l_prompt, null);
3238: JDR_DOCBUILDER.setAttribute(l_table_region, 'viewName', g_vo_name);
3239: add_child_to_parent(l_stk_region, l_table_region, 'contents');
3240:
3241: -- 12.1 Device Integration Project End.
3242:
3267: add_table_action(l_table_region);
3268: add_table_footer(l_table_region);
3269:
3270: -- save the document
3271: l_saved := jdr_docbuilder.save;
3272: log_error(g_pkg_name || l_api_name, 'Saved Document. Function END');
3273:
3274: EXCEPTION
3275:
3453: --
3454:
3455: IF l_jrad_upgrade_ver IS NULL OR
3456: l_jrad_upgrade_ver < l_seed_ver OR
3457: NOT jdr_docbuilder.documentExists(l_eqr_single_doc) OR
3458: NOT jdr_docbuilder.documentExists(l_vqr_single_doc) OR
3459: NOT jdr_docbuilder.documentExists(l_vqr_multiple_doc) OR
3460: NOT jdr_docbuilder.documentExists(l_eqr_multiple_doc) THEN
3461: -- map plan. documents do not exist,
3454:
3455: IF l_jrad_upgrade_ver IS NULL OR
3456: l_jrad_upgrade_ver < l_seed_ver OR
3457: NOT jdr_docbuilder.documentExists(l_eqr_single_doc) OR
3458: NOT jdr_docbuilder.documentExists(l_vqr_single_doc) OR
3459: NOT jdr_docbuilder.documentExists(l_vqr_multiple_doc) OR
3460: NOT jdr_docbuilder.documentExists(l_eqr_multiple_doc) THEN
3461: -- map plan. documents do not exist,
3462: -- or of lower version than wanted.
3455: IF l_jrad_upgrade_ver IS NULL OR
3456: l_jrad_upgrade_ver < l_seed_ver OR
3457: NOT jdr_docbuilder.documentExists(l_eqr_single_doc) OR
3458: NOT jdr_docbuilder.documentExists(l_vqr_single_doc) OR
3459: NOT jdr_docbuilder.documentExists(l_vqr_multiple_doc) OR
3460: NOT jdr_docbuilder.documentExists(l_eqr_multiple_doc) THEN
3461: -- map plan. documents do not exist,
3462: -- or of lower version than wanted.
3463: map_plan(p_plan_id);
3456: l_jrad_upgrade_ver < l_seed_ver OR
3457: NOT jdr_docbuilder.documentExists(l_eqr_single_doc) OR
3458: NOT jdr_docbuilder.documentExists(l_vqr_single_doc) OR
3459: NOT jdr_docbuilder.documentExists(l_vqr_multiple_doc) OR
3460: NOT jdr_docbuilder.documentExists(l_eqr_multiple_doc) THEN
3461: -- map plan. documents do not exist,
3462: -- or of lower version than wanted.
3463: map_plan(p_plan_id);
3464: