[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:
630: p_region_code IN VARCHAR2,
631: p_region_style IN VARCHAR2,
632: p_prompt IN VARCHAR2,
633: p_columns IN VARCHAR2,
634: p_mode in VARCHAR2 default null) RETURN JDR_DOCBUILDER.ELEMENT IS
635:
636: l_element JDR_DOCBUILDER.ELEMENT := NULL;
637: l_addText VARCHAR2(1000);
638:
632: p_prompt IN VARCHAR2,
633: p_columns IN VARCHAR2,
634: p_mode in VARCHAR2 default null) RETURN JDR_DOCBUILDER.ELEMENT IS
635:
636: l_element JDR_DOCBUILDER.ELEMENT := NULL;
637: l_addText VARCHAR2(1000);
638:
639: l_api_name VARCHAR2(100) := 'CREATE_JRAD_REGION';
640:
642: -- region style choices:
643: -- stackLayout, defaultDoubleColumn, defaultSingleColumn, table
644: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
645:
646: l_element := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, p_region_style);
647:
648: -- 12.1 Inline Region Project
649: -- added advancedTable below
650: -- saurabh
652: -- 12.1 Device Integration Project
653: -- Added header to the in clause
654: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
655: if p_region_style in ('defaultDoubleColumn', 'defaultSingleColumn', 'table', 'header') then
656: jdr_docbuilder.setAttribute(l_element, 'text', p_prompt);
657: elsif p_region_style <> 'labeledFieldLayout' then
658: jdr_docbuilder.setAttribute(l_element, 'prompt', p_prompt);
659: end if;
660:
654: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
655: if p_region_style in ('defaultDoubleColumn', 'defaultSingleColumn', 'table', 'header') then
656: jdr_docbuilder.setAttribute(l_element, 'text', p_prompt);
657: elsif p_region_style <> 'labeledFieldLayout' then
658: jdr_docbuilder.setAttribute(l_element, 'prompt', p_prompt);
659: end if;
660:
661: if ( p_region_style = 'advancedTable') then
662: jdr_docbuilder.setAttribute(l_element, 'text', '');
658: jdr_docbuilder.setAttribute(l_element, 'prompt', p_prompt);
659: end if;
660:
661: if ( p_region_style = 'advancedTable') then
662: jdr_docbuilder.setAttribute(l_element, 'text', '');
663: end if;
664:
665: jdr_docbuilder.setAttribute(l_element, 'regionName', p_prompt);
666: jdr_docbuilder.setAttribute(l_element, 'id', p_region_code);
661: if ( p_region_style = 'advancedTable') then
662: jdr_docbuilder.setAttribute(l_element, 'text', '');
663: end if;
664:
665: jdr_docbuilder.setAttribute(l_element, 'regionName', p_prompt);
666: jdr_docbuilder.setAttribute(l_element, 'id', p_region_code);
667:
668: -- 12.1 Inline Region Project
669: -- added advancedTable below
662: jdr_docbuilder.setAttribute(l_element, 'text', '');
663: end if;
664:
665: jdr_docbuilder.setAttribute(l_element, 'regionName', p_prompt);
666: jdr_docbuilder.setAttribute(l_element, 'id', p_region_code);
667:
668: -- 12.1 Inline Region Project
669: -- added advancedTable below
670: -- saurabh
668: -- 12.1 Inline Region Project
669: -- added advancedTable below
670: -- saurabh
671: if (p_region_style = 'table' OR p_region_style = 'advancedTable') then
672: jdr_docbuilder.setAttribute(l_element, 'detailViewAttr', 'HideShowStatus');
673: jdr_docbuilder.setAttribute(l_element, 'unvalidated', 'True');
674: -- anagarwa Mon Nov 17 15:34:29 PST 2003
675: -- bug 3251538
676: -- we need to add addtional text for all tables.
669: -- added advancedTable below
670: -- saurabh
671: if (p_region_style = 'table' OR p_region_style = 'advancedTable') then
672: jdr_docbuilder.setAttribute(l_element, 'detailViewAttr', 'HideShowStatus');
673: jdr_docbuilder.setAttribute(l_element, 'unvalidated', 'True');
674: -- anagarwa Mon Nov 17 15:34:29 PST 2003
675: -- bug 3251538
676: -- we need to add addtional text for all tables.
677: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
682:
683: -- 12.1 QWB Usability Improvements
684: -- Encode the HTML special characters
685: -- ntungare
686: jdr_docbuilder.setAttribute(l_element, 'shortDesc', DBMS_XMLGEN.convert(l_addText));
687: end if;
688:
689: if p_region_style = 'labeledFieldLayout' then
690: jdr_docbuilder.setAttribute(l_element, 'columns', p_columns);
686: jdr_docbuilder.setAttribute(l_element, 'shortDesc', DBMS_XMLGEN.convert(l_addText));
687: end if;
688:
689: if p_region_style = 'labeledFieldLayout' then
690: jdr_docbuilder.setAttribute(l_element, 'columns', p_columns);
691: end if;
692:
693: -- 12.1 Device Integration Project
694: -- Setting width to 100% for tablelayout style
693: -- 12.1 Device Integration Project
694: -- Setting width to 100% for tablelayout style
695: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
696: if p_region_style = 'tableLayout' then
697: jdr_docbuilder.setAttribute(l_element, 'width', '100%');
698: end if;
699:
700: log_error(g_pkg_name || l_api_name, 'Function END returns ');
701:
764: PROCEDURE add_lov_relations (
765: p_plan_id IN NUMBER,
766: p_char_id IN NUMBER,
767: p_attribute_code IN VARCHAR2,
768: p_input_elem IN jdr_docbuilder.Element,
769: p_mode IN VARCHAR2 DEFAULT NULL) IS
770:
771:
772: l_row_id VARCHAR2(30);
782: -- ntungare
783: --
784: l_multirow_headers ParentArray;
785:
786: lovMap jdr_docbuilder.ELEMENT;
787:
788: -- bug 6884645
789: -- variable to check if the parent attribute
790: -- has been processed
796: -- This function adds lov relations for a region item.
797: -- Here the region item corresponds to a collection plan element.
798:
799: --Criteria
800: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
801: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
802: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
803: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
804: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
797: -- Here the region item corresponds to a collection plan element.
798:
799: --Criteria
800: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
801: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
802: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
803: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
804: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
805: lovMap);
798:
799: --Criteria
800: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
801: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
802: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
803: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
804: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
805: lovMap);
806: --Result
799: --Criteria
800: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
801: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
802: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
803: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
804: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
805: lovMap);
806: --Result
807: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
800: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
801: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
802: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
803: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
804: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
805: lovMap);
806: --Result
807: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
808: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
803: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
804: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
805: lovMap);
806: --Result
807: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
808: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
809: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
810: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
811: lovMap);
804: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
805: lovMap);
806: --Result
807: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
808: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
809: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
810: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
811: lovMap);
812: --Org Id
805: lovMap);
806: --Result
807: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
808: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
809: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
810: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
811: lovMap);
812: --Org Id
813: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
806: --Result
807: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
808: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
809: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
810: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
811: lovMap);
812: --Org Id
813: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
814: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
809: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
810: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
811: lovMap);
812: --Org Id
813: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
814: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
815: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
816: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
817: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
810: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
811: lovMap);
812: --Org Id
813: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
814: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
815: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
816: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
817: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
818: lovMap);
811: lovMap);
812: --Org Id
813: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
814: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
815: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
816: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
817: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
818: lovMap);
819: --Plan Id
812: --Org Id
813: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
814: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
815: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
816: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
817: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
818: lovMap);
819: --Plan Id
820: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
813: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
814: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
815: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
816: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
817: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
818: lovMap);
819: --Plan Id
820: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
821: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
816: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
817: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
818: lovMap);
819: --Plan Id
820: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
821: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
822: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
823: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
824: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
817: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
818: lovMap);
819: --Plan Id
820: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
821: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
822: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
823: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
824: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
825: lovMap);
818: lovMap);
819: --Plan Id
820: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
821: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
822: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
823: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
824: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
825: lovMap);
826:
819: --Plan Id
820: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
821: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
822: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
823: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
824: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
825: lovMap);
826:
827:
820: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
821: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
822: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
823: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
824: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
825: lovMap);
826:
827:
828: get_lov_dependencies(p_char_id, l_parents);
885: ELSE
886: l_base_attribute_code := cons_base_attribute_code(g_element_prefix, l_parents(i));
887: END IF;
888:
889: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
890: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
891: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
892: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
893: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
886: l_base_attribute_code := cons_base_attribute_code(g_element_prefix, l_parents(i));
887: END IF;
888:
889: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
890: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
891: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
892: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
893: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
894: 'lovMappings',lovMap);
887: END IF;
888:
889: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
890: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
891: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
892: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
893: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
894: 'lovMappings',lovMap);
895: END IF;
888:
889: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
890: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
891: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
892: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
893: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
894: 'lovMappings',lovMap);
895: END IF;
896:
889: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
890: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', l_base_attribute_code);
891: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
892: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
893: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS,
894: 'lovMappings',lovMap);
895: END IF;
896:
897: --
914: FUNCTION create_id_item_for_eqr (
915: p_plan_id IN NUMBER,
916: p_char_id IN NUMBER,
917: p_mode IN VARCHAR2 DEFAULT NULL)
918: RETURN jdr_docbuilder.ELEMENT IS
919:
920: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
921: l_id_elem jdr_docbuilder.ELEMENT := NULL;
922:
917: p_mode IN VARCHAR2 DEFAULT NULL)
918: RETURN jdr_docbuilder.ELEMENT IS
919:
920: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
921: l_id_elem jdr_docbuilder.ELEMENT := NULL;
922:
923: BEGIN
924:
925: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
925: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
926: l_id_elem := create_jrad_region_item('formValue');
927:
928: -- set properties
929: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
930: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
931: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_vo_name);
932: --end if;
933: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
927:
928: -- set properties
929: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
930: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
931: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_vo_name);
932: --end if;
933: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
934: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
935:
929: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
930: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
931: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_vo_name);
932: --end if;
933: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
934: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
935:
936: return l_id_elem;
937:
930: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
931: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_vo_name);
932: --end if;
933: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
934: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
935:
936: return l_id_elem;
937:
938: END create_id_item_for_eqr;
1006: PROCEDURE process_normalized_lov (
1007: p_plan_id IN NUMBER,
1008: p_char_id IN NUMBER,
1009: p_attribute_code IN VARCHAR2,
1010: p_char_item IN jdr_docbuilder.Element) IS
1011:
1012: lovMap jdr_docbuilder.ELEMENT;
1013: l_lov_region VARCHAR2(100);
1014:
1008: p_char_id IN NUMBER,
1009: p_attribute_code IN VARCHAR2,
1010: p_char_item IN jdr_docbuilder.Element) IS
1011:
1012: lovMap jdr_docbuilder.ELEMENT;
1013: l_lov_region VARCHAR2(100);
1014:
1015: BEGIN
1016: l_lov_region := g_jrad_lov_dir_path || get_lov_region_name(p_plan_id,p_char_id);
1013: l_lov_region VARCHAR2(100);
1014:
1015: BEGIN
1016: l_lov_region := g_jrad_lov_dir_path || get_lov_region_name(p_plan_id,p_char_id);
1017: jdr_docbuilder.setAttribute(p_char_item,
1018: 'externalListOfValues',
1019: l_lov_region);
1020: --Criteria
1021: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1017: jdr_docbuilder.setAttribute(p_char_item,
1018: 'externalListOfValues',
1019: l_lov_region);
1020: --Criteria
1021: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1022: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1023: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1024:
1025: IF(p_char_id = qa_ss_const.po_number) THEN
1018: 'externalListOfValues',
1019: l_lov_region);
1020: --Criteria
1021: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1022: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1023: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1024:
1025: IF(p_char_id = qa_ss_const.po_number) THEN
1026: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1019: l_lov_region);
1020: --Criteria
1021: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1022: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1023: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1024:
1025: IF(p_char_id = qa_ss_const.po_number) THEN
1026: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1027: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1022: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1023: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1024:
1025: IF(p_char_id = qa_ss_const.po_number) THEN
1026: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1027: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1028: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1029: lovMap);
1030:
1023: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1024:
1025: IF(p_char_id = qa_ss_const.po_number) THEN
1026: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1027: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1028: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1029: lovMap);
1030:
1031: -- po_header_id
1024:
1025: IF(p_char_id = qa_ss_const.po_number) THEN
1026: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1027: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1028: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1029: lovMap);
1030:
1031: -- po_header_id
1032: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1028: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1029: lovMap);
1030:
1031: -- po_header_id
1032: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1033: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1034: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1035: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1036: lovMap);
1029: lovMap);
1030:
1031: -- po_header_id
1032: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1033: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1034: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1035: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1036: lovMap);
1037: --
1030:
1031: -- po_header_id
1032: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1033: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1034: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1035: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1036: lovMap);
1037: --
1038: -- bug 5383667
1031: -- po_header_id
1032: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1033: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1034: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1035: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1036: lovMap);
1037: --
1038: -- bug 5383667
1039: -- Processing for the Party Name element
1039: -- Processing for the Party Name element
1040: -- ntungare
1041: --
1042: ELSIF(p_char_id = qa_ss_const.party_name) THEN
1043: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyName');
1044: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1045: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1046: lovMap);
1047:
1040: -- ntungare
1041: --
1042: ELSIF(p_char_id = qa_ss_const.party_name) THEN
1043: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyName');
1044: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1045: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1046: lovMap);
1047:
1048: -- PartyId
1041: --
1042: ELSIF(p_char_id = qa_ss_const.party_name) THEN
1043: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyName');
1044: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1045: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1046: lovMap);
1047:
1048: -- PartyId
1049: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1045: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1046: lovMap);
1047:
1048: -- PartyId
1049: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1050: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1051: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1052: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1053: lovMap);
1046: lovMap);
1047:
1048: -- PartyId
1049: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1050: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1051: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1052: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1053: lovMap);
1054:
1047:
1048: -- PartyId
1049: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1050: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1051: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1052: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1053: lovMap);
1054:
1055: END IF; -- PO Number
1048: -- PartyId
1049: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1050: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1051: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1052: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1053: lovMap);
1054:
1055: END IF; -- PO Number
1056:
1068: PROCEDURE process_regular_lov (
1069: p_plan_id IN NUMBER,
1070: p_char_id IN NUMBER,
1071: p_attribute_code IN VARCHAR2,
1072: p_char_item IN jdr_docbuilder.Element,
1073: p_mode IN VARCHAR2 DEFAULT NULL) IS
1074:
1075: BEGIN
1076:
1073: p_mode IN VARCHAR2 DEFAULT NULL) IS
1074:
1075: BEGIN
1076:
1077: jdr_docbuilder.setAttribute(p_char_item, 'externalListOfValues',
1078: g_jrad_lov_path);
1079:
1080: add_lov_relations(p_plan_id, p_char_id, p_attribute_code, p_char_item, p_mode);
1081:
1126: PROCEDURE process_messageLovInput (
1127: p_plan_id IN NUMBER,
1128: p_char_id IN NUMBER,
1129: p_attribute_code IN VARCHAR2,
1130: p_char_item IN jdr_docbuilder.Element,
1131: p_displayed_flag IN NUMBER,
1132: p_read_only_flag IN NUMBER,
1133: p_mode IN VARCHAR2 DEFAULT NULL) IS
1134:
1166:
1167: -- Common code
1168:
1169: IF (p_displayed_flag <> 1 OR p_read_only_flag = 1) THEN
1170: jdr_docbuilder.setAttribute(p_char_item, 'unvalidated', 'true');
1171: ELSE
1172: jdr_docbuilder.setAttribute(p_char_item, 'unvalidated', 'false');
1173: END IF;
1174:
1168:
1169: IF (p_displayed_flag <> 1 OR p_read_only_flag = 1) THEN
1170: jdr_docbuilder.setAttribute(p_char_item, 'unvalidated', 'true');
1171: ELSE
1172: jdr_docbuilder.setAttribute(p_char_item, 'unvalidated', 'false');
1173: END IF;
1174:
1175: --
1176: -- 12.1 QWB Usability improvements
1179: -- element or not. We need to do PPR processing for LOV elements
1180: -- to set the dependent elements and to fire online actions
1181: -- ntungare Sun Oct 14 03:08:47 PDT 2007
1182: --
1183: jdr_docbuilder.setAttribute(p_char_item, 'user:attribute1', 'qapprelement');
1184:
1185: --
1186: -- 12.1 QWB Usability improvements
1187: -- If the LOV has online actions defined,
1192: online_act_flg := is_online_action_defined(p_plan_id => p_plan_id,
1193: p_char_id => p_char_id);
1194:
1195: If (online_act_flg = 1) THEN
1196: jdr_docbuilder.setAttribute(p_char_item, 'user:attribute2', 'qaactionelement');
1197: End If;
1198:
1199: END process_messageLovInput;
1200:
1201: FUNCTION create_region_item_for_eqr (
1202: p_plan_id IN NUMBER,
1203: p_char_id IN NUMBER,
1204: p_element_prefix IN VARCHAR2 DEFAULT g_element_prefix,
1205: p_mode IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
1206:
1207: l_attribute_code VARCHAR2(30);
1208: l_item_style VARCHAR2(30);
1209: l_vo_attribute_name VARCHAR2(30);
1230: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1231: l_maximum_length NUMBER;
1232:
1233:
1234: l_char_item jdr_docbuilder.ELEMENT;
1235:
1236: l_api_name constant varchar2(50) := 'CREATE_REGION_ITEM_FOR_EQR';
1237:
1238: -- 12.1 QWB Usability Improvements
1237:
1238: -- 12.1 QWB Usability Improvements
1239: -- ntungare Tue Aug 28 04:20:24 PDT 2007
1240: -- PPRTEST
1241: ppr_event jdr_docbuilder.ELEMENT;
1242:
1243: online_act_flg PLS_INTEGER := 0;
1244:
1245: l_show_required_flag qa_plan_chars.mandatory_flag%TYPE;
1292: end if;
1293:
1294: l_char_item := create_jrad_region_item(l_item_style);
1295:
1296: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1297: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1298: jdr_docbuilder.setAttribute(l_char_item, 'readOnly', c_read_only_flag);
1299: -- if read only elmeent then set style class
1300: if c_read_only_flag = 'true' then
1293:
1294: l_char_item := create_jrad_region_item(l_item_style);
1295:
1296: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1297: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1298: jdr_docbuilder.setAttribute(l_char_item, 'readOnly', c_read_only_flag);
1299: -- if read only elmeent then set style class
1300: if c_read_only_flag = 'true' then
1301: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1294: l_char_item := create_jrad_region_item(l_item_style);
1295:
1296: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1297: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1298: jdr_docbuilder.setAttribute(l_char_item, 'readOnly', c_read_only_flag);
1299: -- if read only elmeent then set style class
1300: if c_read_only_flag = 'true' then
1301: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1302: end if;
1297: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1298: jdr_docbuilder.setAttribute(l_char_item, 'readOnly', c_read_only_flag);
1299: -- if read only elmeent then set style class
1300: if c_read_only_flag = 'true' then
1301: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1302: end if;
1303: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1304: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1305: jdr_docbuilder.setAttribute(l_char_item, 'required', c_mandatory_flag);
1299: -- if read only elmeent then set style class
1300: if c_read_only_flag = 'true' then
1301: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1302: end if;
1303: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1304: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1305: jdr_docbuilder.setAttribute(l_char_item, 'required', c_mandatory_flag);
1306:
1307: -- 12.1 QWB Usability
1300: if c_read_only_flag = 'true' then
1301: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1302: end if;
1303: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1304: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1305: jdr_docbuilder.setAttribute(l_char_item, 'required', c_mandatory_flag);
1306:
1307: -- 12.1 QWB Usability
1308: -- If the element is in a Multirow details block then
1301: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1302: end if;
1303: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1304: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1305: jdr_docbuilder.setAttribute(l_char_item, 'required', c_mandatory_flag);
1306:
1307: -- 12.1 QWB Usability
1308: -- If the element is in a Multirow details block then
1309: -- although the madatory check would not be enfored yet, the
1309: -- although the madatory check would not be enfored yet, the
1310: -- element must atleast be marked as mandatory.
1311: IF ((p_mode = g_eqr_advtable_layout OR p_mode = g_eqr_multiple_layout) AND
1312: (p_element_prefix = g_dtl_element_prefix))THEN
1313: jdr_docbuilder.setAttribute(l_char_item, 'showRequired', c_show_required_flag);
1314: END IF;
1315:
1316: jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
1317: -- Advanced Table does not require view name for each item, write code here and other places
1312: (p_element_prefix = g_dtl_element_prefix))THEN
1313: jdr_docbuilder.setAttribute(l_char_item, 'showRequired', c_show_required_flag);
1314: END IF;
1315:
1316: jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
1317: -- Advanced Table does not require view name for each item, write code here and other places
1318: -- jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1319: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
1320: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1314: END IF;
1315:
1316: jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
1317: -- Advanced Table does not require view name for each item, write code here and other places
1318: -- jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1319: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
1320: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1321: --end if;
1322: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1316: jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
1317: -- Advanced Table does not require view name for each item, write code here and other places
1318: -- jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1319: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
1320: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1321: --end if;
1322: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1323:
1324: -- Bug 4506400. OA Framework Integration. UT Bug fix.
1318: -- jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1319: --if( p_mode <> g_eqr_advtable_layout OR p_mode is NULL) then
1320: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1321: --end if;
1322: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1323:
1324: -- Bug 4506400. OA Framework Integration. UT Bug fix.
1325: -- Set maxLength property.
1326: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1326: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1327: IF (l_item_style IN ('messageTextInput','messageLovInput')) THEN
1328: l_maximum_length := get_max_length(l_vo_attribute_name);
1329: IF (l_maximum_length is not null AND l_maximum_length <> -1) THEN
1330: jdr_docbuilder.setAttribute(l_char_item, 'maximumLength', l_maximum_length);
1331: END IF;
1332: END IF;
1333:
1334: -- At this point, if the element has lovs then we must determine
1356: -- Bug 3202281 . Poplist vo should have plan name .
1357: -- This code has run time dependency on QaRenderCO.java changes
1358: --l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'VO';
1359: l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'PID' || p_plan_id || 'VO';
1360: jdr_docbuilder.setAttribute(l_char_item, 'pickListViewName', l_pop_vo_name);
1361: jdr_docbuilder.setAttribute(l_char_item, 'pickListDispAttr',
1362: g_pop_display_column);
1363: jdr_docbuilder.setAttribute(l_char_item, 'pickListValAttr', g_pop_value_column);
1364: END IF;
1357: -- This code has run time dependency on QaRenderCO.java changes
1358: --l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'VO';
1359: l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'PID' || p_plan_id || 'VO';
1360: jdr_docbuilder.setAttribute(l_char_item, 'pickListViewName', l_pop_vo_name);
1361: jdr_docbuilder.setAttribute(l_char_item, 'pickListDispAttr',
1362: g_pop_display_column);
1363: jdr_docbuilder.setAttribute(l_char_item, 'pickListValAttr', g_pop_value_column);
1364: END IF;
1365:
1359: l_pop_vo_name := construct_code(g_pop_vo_prefix, p_char_id) || 'PID' || p_plan_id || 'VO';
1360: jdr_docbuilder.setAttribute(l_char_item, 'pickListViewName', l_pop_vo_name);
1361: jdr_docbuilder.setAttribute(l_char_item, 'pickListDispAttr',
1362: g_pop_display_column);
1363: jdr_docbuilder.setAttribute(l_char_item, 'pickListValAttr', g_pop_value_column);
1364: END IF;
1365:
1366: -- Set the text width and height properties for chars of type long comments
1367:
1365:
1366: -- Set the text width and height properties for chars of type long comments
1367:
1368: IF (l_datatype = g_comments_datatype) THEN
1369: jdr_docbuilder.setAttribute(l_char_item, 'columns', g_comments_width);
1370: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1371: -- Bug 4506400. Max length set above. So commenting it out.
1372: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1373:
1366: -- Set the text width and height properties for chars of type long comments
1367:
1368: IF (l_datatype = g_comments_datatype) THEN
1369: jdr_docbuilder.setAttribute(l_char_item, 'columns', g_comments_width);
1370: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1371: -- Bug 4506400. Max length set above. So commenting it out.
1372: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1373:
1374: -- jdr_docbuilder.setAttribute(l_char_item, 'maximumLength', g_comments_max_len);
1370: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1371: -- Bug 4506400. Max length set above. So commenting it out.
1372: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.
1373:
1374: -- jdr_docbuilder.setAttribute(l_char_item, 'maximumLength', g_comments_max_len);
1375: END IF;
1376:
1377: -- set data entry hint
1378: IF (l_data_entry_hint is not null) THEN
1375: END IF;
1376:
1377: -- set data entry hint
1378: IF (l_data_entry_hint is not null) THEN
1379: jdr_docbuilder.setAttribute(l_char_item, 'tipType', g_tip_type);
1380: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageName', g_tip_message_name);
1381: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageAppShortName', g_app_short_name);
1382: jdr_docbuilder.setAttribute(l_char_item, 'longTipRegion', g_long_tip_region);
1383: END IF;
1376:
1377: -- set data entry hint
1378: IF (l_data_entry_hint is not null) THEN
1379: jdr_docbuilder.setAttribute(l_char_item, 'tipType', g_tip_type);
1380: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageName', g_tip_message_name);
1381: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageAppShortName', g_app_short_name);
1382: jdr_docbuilder.setAttribute(l_char_item, 'longTipRegion', g_long_tip_region);
1383: END IF;
1384:
1377: -- set data entry hint
1378: IF (l_data_entry_hint is not null) THEN
1379: jdr_docbuilder.setAttribute(l_char_item, 'tipType', g_tip_type);
1380: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageName', g_tip_message_name);
1381: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageAppShortName', g_app_short_name);
1382: jdr_docbuilder.setAttribute(l_char_item, 'longTipRegion', g_long_tip_region);
1383: END IF;
1384:
1385: --
1378: IF (l_data_entry_hint is not null) THEN
1379: jdr_docbuilder.setAttribute(l_char_item, 'tipType', g_tip_type);
1380: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageName', g_tip_message_name);
1381: --jdr_docbuilder.setAttribute(l_char_item, 'tipMessageAppShortName', g_app_short_name);
1382: jdr_docbuilder.setAttribute(l_char_item, 'longTipRegion', g_long_tip_region);
1383: END IF;
1384:
1385: --
1386: -- 12.1 QWB Usability Improvements
1392: l_item_style = 'messageChoice') THEN
1393: -- Disabling the serverside validation to avoid the
1394: -- entire row being validated
1395: --
1396: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
1397:
1398: -- Adding the firePartialAction tag
1399: --
1400: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
1396: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
1397:
1398: -- Adding the firePartialAction tag
1399: --
1400: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
1401: p_tagName => 'firePartialAction');
1402:
1403: -- Setting the event name for PPR as qappract_CHARIDXX where XX
1404: -- represents the collection elements CharId
1402:
1403: -- Setting the event name for PPR as qappract_CHARIDXX where XX
1404: -- represents the collection elements CharId
1405: --
1406: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qappract_'||l_attribute_code);
1407:
1408: -- Setting the user:attribute1 to indicate the PPR processing is to be
1409: -- done for the element
1410: --
1407:
1408: -- Setting the user:attribute1 to indicate the PPR processing is to be
1409: -- done for the element
1410: --
1411: jdr_docbuilder.setAttribute(l_char_item, 'user:attribute1', 'qapprelement');
1412:
1413: -- Disabling the client side validation
1414: --
1415: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
1411: jdr_docbuilder.setAttribute(l_char_item, 'user:attribute1', 'qapprelement');
1412:
1413: -- Disabling the client side validation
1414: --
1415: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
1416:
1417: jdr_docbuilder.addchild (p_parent => l_char_item,
1418: p_groupingNS => JDR_DOCBUILDER.UI_NS,
1419: p_groupingTagName => 'primaryClientAction',
1413: -- Disabling the client side validation
1414: --
1415: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
1416:
1417: jdr_docbuilder.addchild (p_parent => l_char_item,
1418: p_groupingNS => JDR_DOCBUILDER.UI_NS,
1419: p_groupingTagName => 'primaryClientAction',
1420: p_child => ppr_event);
1421:
1414: --
1415: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
1416:
1417: jdr_docbuilder.addchild (p_parent => l_char_item,
1418: p_groupingNS => JDR_DOCBUILDER.UI_NS,
1419: p_groupingTagName => 'primaryClientAction',
1420: p_child => ppr_event);
1421:
1422:
1429: If (online_act_flg =1) then
1430: -- Setting the user:attribute2 since online actions
1431: -- have been defined.
1432: --
1433: jdr_docbuilder.setAttribute(l_char_item, 'user:attribute2', 'qaactionelement');
1434: online_act_flg := 0;
1435: end if; --(online_act_flg =1)
1436: end if; -- (l_item_style = 'messageTextInput' or l_item_style = 'messageChoice')
1437: -- End of changes for PPR
1448: p_plan_id IN NUMBER,
1449: p_char_id IN NUMBER,
1450: p_element_prefix IN VARCHAR2 DEFAULT g_element_prefix,
1451: p_mode IN VARCHAR2 DEFAULT NULL )
1452: RETURN JDR_DOCBUILDER.ELEMENT IS
1453:
1454: l_attribute_code VARCHAR2(30);
1455: l_item_style VARCHAR2(30) DEFAULT 'messageStyledText';
1456: l_vo_attribute_name VARCHAR2(30);
1469: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1470: c_displayed_flag VARCHAR2(10);
1471:
1472:
1473: l_char_item jdr_docbuilder.ELEMENT;
1474:
1475: BEGIN
1476: l_prompt := get_prompt(p_plan_id, p_char_id);
1477: l_attribute_code := construct_code(p_element_prefix, p_char_id);
1480: l_char_item := create_jrad_region_item(l_item_style);
1481: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1482: -- "Displayed Flag" not honoured in VQR. Get the displayed flag.
1483: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1484: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1485: --jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
1486: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1487: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1488:
1481: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1482: -- "Displayed Flag" not honoured in VQR. Get the displayed flag.
1483: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1484: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1485: --jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
1486: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1487: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1488:
1489:
1482: -- "Displayed Flag" not honoured in VQR. Get the displayed flag.
1483: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1484: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1485: --jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
1486: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1487: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1488:
1489:
1490: -- bug 3236302. rkaza. timezone support. 11/04/2003
1483: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1484: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
1485: --jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
1486: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
1487: jdr_docbuilder.setAttribute(l_char_item, 'shortDesc', l_prompt);
1488:
1489:
1490: -- bug 3236302. rkaza. timezone support. 11/04/2003
1491: -- Added datatype to vqr region items
1488:
1489:
1490: -- bug 3236302. rkaza. timezone support. 11/04/2003
1491: -- Added datatype to vqr region items
1492: jdr_docbuilder.setAttribute(l_char_item, 'dataType', convert_data_type(l_datatype));
1493:
1494: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1495: -- "Displayed Flag" not honoured in VQR. Set rendered property
1496: -- based on displayed flag.
1501: -- abgangul
1502: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
1503: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1504: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
1505: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1506:
1507: l_vo_attribute_name := get_vo_attribute_name(p_plan_id, p_char_id);
1508: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1509: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1504: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
1505: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1506:
1507: l_vo_attribute_name := get_vo_attribute_name(p_plan_id, p_char_id);
1508: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1509: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1510: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1511:
1512: end if;
1505: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
1506:
1507: l_vo_attribute_name := get_vo_attribute_name(p_plan_id, p_char_id);
1508: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1509: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1510: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1511:
1512: end if;
1513:
1506:
1507: l_vo_attribute_name := get_vo_attribute_name(p_plan_id, p_char_id);
1508: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_vo_name);
1509: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
1510: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', g_ora_data_text);
1511:
1512: end if;
1513:
1514: IF (l_datatype = g_comments_datatype) THEN
1512: end if;
1513:
1514: IF (l_datatype = g_comments_datatype) THEN
1515: -- fix me
1516: jdr_docbuilder.setAttribute(l_char_item, 'columns', g_comments_width);
1517: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1518: END IF;
1519:
1520: -- for vqr set all text to style OraDataText
1513:
1514: IF (l_datatype = g_comments_datatype) THEN
1515: -- fix me
1516: jdr_docbuilder.setAttribute(l_char_item, 'columns', g_comments_width);
1517: jdr_docbuilder.setAttribute(l_char_item, 'rows', g_comments_height);
1518: END IF;
1519:
1520: -- for vqr set all text to style OraDataText
1521:
1529: p_attribute_code IN VARCHAR2,
1530: p_item_style IN VARCHAR2,
1531: p_element_prefix IN VARCHAR2 DEFAULT g_element_prefix,
1532: p_mode IN VARCHAR2 DEFAULT NULL)
1533: RETURN jdr_docbuilder.ELEMENT IS
1534:
1535: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
1536: l_label_long VARCHAR2(30) DEFAULT NULL;
1537: l_special_elem jdr_docbuilder.ELEMENT := NULL;
1533: RETURN jdr_docbuilder.ELEMENT IS
1534:
1535: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
1536: l_label_long VARCHAR2(30) DEFAULT NULL;
1537: l_special_elem jdr_docbuilder.ELEMENT := NULL;
1538: l_data_type VARCHAR2(30);
1539: l_attribute_code VARCHAR2(30) := p_attribute_code;
1540:
1541: -- for attachments
1539: l_attribute_code VARCHAR2(30) := p_attribute_code;
1540:
1541: -- for attachments
1542: l_entity_id VARCHAR2(30) DEFAULT NULL;
1543: l_entityMap jdr_docbuilder.ELEMENT := NULL;
1544:
1545: BEGIN
1546:
1547: -- In EQR we add org_id, org_code, plan_id, plan_code, po_agent_id as special items.
1557: -- VO and VO attribute name is different for export page
1558: -- abgangul
1559: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
1560: l_vo_attribute_name := get_hardcoded_vo_attr_name(p_attribute_code);
1561: jdr_docbuilder.setAttribute(l_special_elem, 'viewName', g_vo_name);
1562: jdr_docbuilder.setAttribute(l_special_elem, 'viewAttr', l_vo_attribute_name);
1563: jdr_docbuilder.setAttribute(l_special_elem, 'styleClass', g_ora_data_text);
1564: else
1565: l_attribute_code := p_element_prefix || l_attribute_code;
1558: -- abgangul
1559: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
1560: l_vo_attribute_name := get_hardcoded_vo_attr_name(p_attribute_code);
1561: jdr_docbuilder.setAttribute(l_special_elem, 'viewName', g_vo_name);
1562: jdr_docbuilder.setAttribute(l_special_elem, 'viewAttr', l_vo_attribute_name);
1563: jdr_docbuilder.setAttribute(l_special_elem, 'styleClass', g_ora_data_text);
1564: else
1565: l_attribute_code := p_element_prefix || l_attribute_code;
1566: end if;
1559: if nvl(p_mode, '@') <> g_vqr_multiple_layout then
1560: l_vo_attribute_name := get_hardcoded_vo_attr_name(p_attribute_code);
1561: jdr_docbuilder.setAttribute(l_special_elem, 'viewName', g_vo_name);
1562: jdr_docbuilder.setAttribute(l_special_elem, 'viewAttr', l_vo_attribute_name);
1563: jdr_docbuilder.setAttribute(l_special_elem, 'styleClass', g_ora_data_text);
1564: else
1565: l_attribute_code := p_element_prefix || l_attribute_code;
1566: end if;
1567:
1564: else
1565: l_attribute_code := p_element_prefix || l_attribute_code;
1566: end if;
1567:
1568: jdr_docbuilder.setAttribute(l_special_elem, 'id', l_attribute_code);
1569: jdr_docbuilder.setAttribute(l_special_elem, 'prompt', l_label_long);
1570:
1571: --
1572: -- Bug 5336860. Per Coding Standard contextual information needs
1565: l_attribute_code := p_element_prefix || l_attribute_code;
1566: end if;
1567:
1568: jdr_docbuilder.setAttribute(l_special_elem, 'id', l_attribute_code);
1569: jdr_docbuilder.setAttribute(l_special_elem, 'prompt', l_label_long);
1570:
1571: --
1572: -- Bug 5336860. Per Coding Standard contextual information needs
1573: -- this statement to set the font.
1578: -- Added datatype datetime to last_update_date
1579: IF (p_attribute_code = g_last_update_date_attribute) THEN
1580: -- Assign a datatype of DATETIME to last_update_date.
1581: l_data_type := convert_data_type(g_datetime_datatype);
1582: jdr_docbuilder.setAttribute(l_special_elem, 'dataType', l_data_type);
1583: END IF;
1584:
1585: IF (p_attribute_code = g_collection_id_attribute) THEN
1586: l_data_type := convert_data_type(g_num_datatype);
1583: END IF;
1584:
1585: IF (p_attribute_code = g_collection_id_attribute) THEN
1586: l_data_type := convert_data_type(g_num_datatype);
1587: jdr_docbuilder.setAttribute(l_special_elem, 'dataType', l_data_type);
1588: END IF;
1589:
1590: if p_attribute_code = g_multi_row_attachment then
1591: l_entity_id := g_attachment_entity;
1588: END IF;
1589:
1590: if p_attribute_code = g_multi_row_attachment then
1591: l_entity_id := g_attachment_entity;
1592: jdr_docbuilder.setAttribute(l_special_elem, 'shortDesc', l_label_long);
1593:
1594: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'entityMap');
1595: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1596: jdr_docbuilder.addChild(l_special_elem, jdr_docbuilder.OA_NS,
1590: if p_attribute_code = g_multi_row_attachment then
1591: l_entity_id := g_attachment_entity;
1592: jdr_docbuilder.setAttribute(l_special_elem, 'shortDesc', l_label_long);
1593:
1594: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'entityMap');
1595: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1596: jdr_docbuilder.addChild(l_special_elem, jdr_docbuilder.OA_NS,
1597: 'entityMappings', l_entityMap);
1598: end if;
1591: l_entity_id := g_attachment_entity;
1592: jdr_docbuilder.setAttribute(l_special_elem, 'shortDesc', l_label_long);
1593:
1594: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'entityMap');
1595: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1596: jdr_docbuilder.addChild(l_special_elem, jdr_docbuilder.OA_NS,
1597: 'entityMappings', l_entityMap);
1598: end if;
1599:
1592: jdr_docbuilder.setAttribute(l_special_elem, 'shortDesc', l_label_long);
1593:
1594: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'entityMap');
1595: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1596: jdr_docbuilder.addChild(l_special_elem, jdr_docbuilder.OA_NS,
1597: 'entityMappings', l_entityMap);
1598: end if;
1599:
1600: return l_special_elem;
1607: -- based on the plan and added elements
1608: FUNCTION create_item_for_advtable(p_plan_id IN NUMBER,
1609: p_char_id IN NUMBER,
1610: p_element_prefix IN VARCHAR2 DEFAULT g_element_prefix)
1611: RETURN jdr_docbuilder.element IS
1612:
1613: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_ITEM_FOR_ADVTABLE';
1614: l_err_num NUMBER;
1615: l_err_msg VARCHAR2(100);
1613: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_ITEM_FOR_ADVTABLE';
1614: l_err_num NUMBER;
1615: l_err_msg VARCHAR2(100);
1616:
1617: l_sort_hdr jdr_docbuilder.element := NULL;
1618: l_col_hdr jdr_docbuilder.element := NULL;
1619: l_char_item jdr_docbuilder.element := NULL;
1620:
1621: l_attr_code VARCHAR2(30);
1614: l_err_num NUMBER;
1615: l_err_msg VARCHAR2(100);
1616:
1617: l_sort_hdr jdr_docbuilder.element := NULL;
1618: l_col_hdr jdr_docbuilder.element := NULL;
1619: l_char_item jdr_docbuilder.element := NULL;
1620:
1621: l_attr_code VARCHAR2(30);
1622: l_col_code VARCHAR2(30);
1615: l_err_msg VARCHAR2(100);
1616:
1617: l_sort_hdr jdr_docbuilder.element := NULL;
1618: l_col_hdr jdr_docbuilder.element := NULL;
1619: l_char_item jdr_docbuilder.element := NULL;
1620:
1621: l_attr_code VARCHAR2(30);
1622: l_col_code VARCHAR2(30);
1623: l_hrd_code VARCHAR2(30);
1634: l_attr_code := construct_code(p_element_prefix, p_char_id);
1635: l_col_code := 'column' || l_attr_code;
1636: -- create column for the table
1637: -- this is an element from the plan
1638: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
1639: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
1640:
1641: -- Setting the rendered property based on the display flag value
1642: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1635: l_col_code := 'column' || l_attr_code;
1636: -- create column for the table
1637: -- this is an element from the plan
1638: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
1639: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
1640:
1641: -- Setting the rendered property based on the display flag value
1642: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1643: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
1641: -- Setting the rendered property based on the display flag value
1642: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1643: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
1644:
1645: jdr_docbuilder.setAttribute(l_col_hdr, 'rendered', c_displayed_flag);
1646:
1647: -- add actual element
1648: log_error(g_pkg_name || l_api_name, 'Creating Element ' || to_char(p_char_id));
1649: l_char_item := create_region_item_for_eqr(p_plan_id, p_char_id, p_element_prefix, l_mode);
1652: log_error(g_pkg_name || l_api_name, 'END');
1653:
1654: l_hrd_code := 'colHdr' || l_attr_code;
1655: -- add column header
1656: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
1657: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
1658: l_prompt := get_prompt(p_plan_id, p_char_id);
1659: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
1660:
1653:
1654: l_hrd_code := 'colHdr' || l_attr_code;
1655: -- add column header
1656: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
1657: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
1658: l_prompt := get_prompt(p_plan_id, p_char_id);
1659: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
1660:
1661: -- adding the mandatory sign
1655: -- add column header
1656: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
1657: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
1658: l_prompt := get_prompt(p_plan_id, p_char_id);
1659: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
1660:
1661: -- adding the mandatory sign
1662: l_mandatory_flag := qa_plan_element_api.qpc_mandatory_flag(p_plan_id, p_char_id);
1663: c_mandatory_flag := convert_yesno_flag(l_mandatory_flag);
1660:
1661: -- adding the mandatory sign
1662: l_mandatory_flag := qa_plan_element_api.qpc_mandatory_flag(p_plan_id, p_char_id);
1663: c_mandatory_flag := convert_yesno_flag(l_mandatory_flag);
1664: jdr_docbuilder.setAttribute(l_sort_hdr, 'required', c_mandatory_flag);
1665:
1666: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
1667:
1668:
1678:
1679: BEGIN
1680: -- delete the document if it exists.
1681:
1682: If jdr_docbuilder.documentExists(p_full_path) then
1683: jdr_docbuilder.deleteDocument(p_full_path);
1684: end if;
1685:
1686: END delete_old_top_document;
1679: BEGIN
1680: -- delete the document if it exists.
1681:
1682: If jdr_docbuilder.documentExists(p_full_path) then
1683: jdr_docbuilder.deleteDocument(p_full_path);
1684: end if;
1685:
1686: END delete_old_top_document;
1687:
1687:
1688:
1689:
1690: FUNCTION create_top_document(
1691: p_full_path IN VARCHAR2) RETURN JDR_DOCBUILDER.DOCUMENT IS
1692:
1693: BEGIN
1694:
1695: RETURN JDR_DOCBUILDER.createDocument(p_full_path, 'en-US');
1691: p_full_path IN VARCHAR2) RETURN JDR_DOCBUILDER.DOCUMENT IS
1692:
1693: BEGIN
1694:
1695: RETURN JDR_DOCBUILDER.createDocument(p_full_path, 'en-US');
1696:
1697: END create_top_document;
1698:
1699:
1697: END create_top_document;
1698:
1699:
1700: FUNCTION create_and_set_top_element(
1701: p_top_doc IN JDR_DOCBUILDER.DOCUMENT,
1702: p_top_region_code IN VARCHAR2,
1703: p_layout IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
1704:
1705: l_api_name constant varchar2(50) := 'CREATE_AND_SET_TOP_ELEMENT';
1699:
1700: FUNCTION create_and_set_top_element(
1701: p_top_doc IN JDR_DOCBUILDER.DOCUMENT,
1702: p_top_region_code IN VARCHAR2,
1703: p_layout IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
1704:
1705: l_api_name constant varchar2(50) := 'CREATE_AND_SET_TOP_ELEMENT';
1706: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
1707: l_prompt VARCHAR2(30);
1702: p_top_region_code IN VARCHAR2,
1703: p_layout IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
1704:
1705: l_api_name constant varchar2(50) := 'CREATE_AND_SET_TOP_ELEMENT';
1706: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
1707: l_prompt VARCHAR2(30);
1708: BEGIN
1709: -- Creates the top region and sets it as the top level element in the document
1710: -- p_layout can be stackLayout or table layout for top regions
1721: l_prompt := get_region_prompt('DATA');
1722: end if;
1723:
1724: l_top_region := create_jrad_region (p_top_region_code, p_layout,l_prompt, null);
1725: JDR_DOCBUILDER.setTopLevelElement(p_top_doc, l_top_region);
1726:
1727: -- 12.1 Inline region project
1728: -- saugupta
1729: if ( p_layout = 'advancedTable' ) then
1728: -- saugupta
1729: if ( p_layout = 'advancedTable' ) then
1730: -- found code bug, regionName appearing twice in the final XML
1731: -- saugupta
1732: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'regionName', l_prompt);
1733: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_vo_name);
1734: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'detailViewAttr', 'HideShowStatus');
1735: end if;
1736:
1729: if ( p_layout = 'advancedTable' ) then
1730: -- found code bug, regionName appearing twice in the final XML
1731: -- saugupta
1732: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'regionName', l_prompt);
1733: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_vo_name);
1734: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'detailViewAttr', 'HideShowStatus');
1735: end if;
1736:
1737: RETURN l_top_region;
1730: -- found code bug, regionName appearing twice in the final XML
1731: -- saugupta
1732: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'regionName', l_prompt);
1733: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_vo_name);
1734: -- JDR_DOCBUILDER.setAttribute(l_top_region, 'detailViewAttr', 'HideShowStatus');
1735: end if;
1736:
1737: RETURN l_top_region;
1738:
1748: -- Returns no of plan chars added to the region
1749:
1750: FUNCTION add_plan_chars_to_region(
1751: p_plan_id IN NUMBER,
1752: p_content_region IN JDR_DOCBUILDER.ELEMENT,
1753: p_mode IN VARCHAR2,
1754: p_char_type IN VARCHAR2,
1755: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN NUMBER IS
1756:
1754: p_char_type IN VARCHAR2,
1755: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN NUMBER IS
1756:
1757: char_count NUMBER := 0;
1758: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
1759: -- MOAC
1760: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1761:
1762: l_element_prefix VARCHAR2(15) := g_element_prefix;
1756:
1757: char_count NUMBER := 0;
1758: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
1759: -- MOAC
1760: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1761:
1762: l_element_prefix VARCHAR2(15) := g_element_prefix;
1763:
1764: l_api_name CONSTANT VARCHAR2(50) := 'ADD_PLAN_CHARS_TO_REGION';
1873:
1874:
1875: PROCEDURE add_special_chars_to_region(
1876: p_plan_id IN NUMBER,
1877: p_content_region IN JDR_DOCBUILDER.ELEMENT,
1878: p_mode IN VARCHAR2,
1879: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) IS
1880:
1881: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
1877: p_content_region IN JDR_DOCBUILDER.ELEMENT,
1878: p_mode IN VARCHAR2,
1879: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) IS
1880:
1881: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
1882: l_item_style VARCHAR2(30) := null;
1883: l_element_prefix VARCHAR2(15) := g_element_prefix;
1884: BEGIN
1885:
1965: FUNCTION create_data_region(
1966: p_plan_id IN NUMBER,
1967: p_data_region_code IN VARCHAR2,
1968: p_mode IN VARCHAR2,
1969: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
1970:
1971: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
1972: l_prompt VARCHAR2(30) := null;
1973: l_char_count NUMBER := null;
1967: p_data_region_code IN VARCHAR2,
1968: p_mode IN VARCHAR2,
1969: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
1970:
1971: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
1972: l_prompt VARCHAR2(30) := null;
1973: l_char_count NUMBER := null;
1974:
1975: BEGIN
2019: p_plan_id IN NUMBER,
2020: p_comments_region_code IN VARCHAR2,
2021: p_mode IN VARCHAR2,
2022: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL)
2023: RETURN JDR_DOCBUILDER.ELEMENT IS
2024:
2025: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2026: l_prompt VARCHAR2(30) := null;
2027: l_char_count NUMBER := null;
2021: p_mode IN VARCHAR2,
2022: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL)
2023: RETURN JDR_DOCBUILDER.ELEMENT IS
2024:
2025: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2026: l_prompt VARCHAR2(30) := null;
2027: l_char_count NUMBER := null;
2028:
2029: BEGIN
2061:
2062:
2063: FUNCTION create_attachments_region(p_plan_id IN NUMBER,
2064: p_mode IN VARCHAR2)
2065: RETURN JDR_DOCBUILDER.ELEMENT IS
2066:
2067: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2068: l_prompt VARCHAR2(30) := null;
2069: l_char_count NUMBER := null;
2063: FUNCTION create_attachments_region(p_plan_id IN NUMBER,
2064: p_mode IN VARCHAR2)
2065: RETURN JDR_DOCBUILDER.ELEMENT IS
2066:
2067: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2068: l_prompt VARCHAR2(30) := null;
2069: l_char_count NUMBER := null;
2070:
2071: l_row_id VARCHAR2(30);
2084: l_image_file_name VARCHAR2(240) DEFAULT NULL;
2085: l_description VARCHAR2(240) DEFAULT NULL;
2086: --l_query_flag VARCHAR2(1) DEFAULT 'N';
2087:
2088: special_elem jdr_docbuilder.ELEMENT := NULL;
2089: l_entityMap jdr_docbuilder.ELEMENT := NULL;
2090:
2091: err_num NUMBER;
2092: err_msg VARCHAR2(100);
2085: l_description VARCHAR2(240) DEFAULT NULL;
2086: --l_query_flag VARCHAR2(1) DEFAULT 'N';
2087:
2088: special_elem jdr_docbuilder.ELEMENT := NULL;
2089: l_entityMap jdr_docbuilder.ELEMENT := NULL;
2090:
2091: err_num NUMBER;
2092: err_msg VARCHAR2(100);
2093: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2089: l_entityMap jdr_docbuilder.ELEMENT := NULL;
2090:
2091: err_num NUMBER;
2092: err_msg VARCHAR2(100);
2093: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2094:
2095:
2096: BEGIN
2097: -- create comments region
2113:
2114: --l_item_style := 'attachmentImage';
2115: l_item_style := 'attachmentLink';
2116: --special handling for attachments
2117: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2118: 'entityMap');
2119: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
2120: --
2121: -- Bug 8671769
2115: l_item_style := 'attachmentLink';
2116: --special handling for attachments
2117: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2118: 'entityMap');
2119: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
2120: --
2121: -- Bug 8671769
2122: -- Adding 'id' for the entity map so that the personalization works perfectly.
2123: -- skolluku
2121: -- Bug 8671769
2122: -- Adding 'id' for the entity map so that the personalization works perfectly.
2123: -- skolluku
2124: --
2125: jdr_docbuilder.setAttribute(l_entityMap, 'id', 'qaEntityMap1');
2126:
2127: -- Bug 6718507
2128: -- in VQR we do not want the user to insert or update Attachements
2129: -- ntungare Wed Jan 23 04:20:57 PST 2008
2128: -- in VQR we do not want the user to insert or update Attachements
2129: -- ntungare Wed Jan 23 04:20:57 PST 2008
2130: --
2131: IF (p_mode = g_vqr_single_layout) THEN
2132: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false' );
2133: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false' );
2134: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false' );
2135: END IF;
2136:
2129: -- ntungare Wed Jan 23 04:20:57 PST 2008
2130: --
2131: IF (p_mode = g_vqr_single_layout) THEN
2132: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false' );
2133: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false' );
2134: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false' );
2135: END IF;
2136:
2137: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2130: --
2131: IF (p_mode = g_vqr_single_layout) THEN
2132: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false' );
2133: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false' );
2134: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false' );
2135: END IF;
2136:
2137: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2138: l_item_style);
2133: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false' );
2134: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false' );
2135: END IF;
2136:
2137: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2138: l_item_style);
2139: jdr_docbuilder.setAttribute(special_elem, 'id', 'AK_ATTACHMENT_LINK' );
2140: jdr_docbuilder.setAttribute(special_elem, 'viewName', 'QualityResultsVO' );
2141:
2135: END IF;
2136:
2137: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2138: l_item_style);
2139: jdr_docbuilder.setAttribute(special_elem, 'id', 'AK_ATTACHMENT_LINK' );
2140: jdr_docbuilder.setAttribute(special_elem, 'viewName', 'QualityResultsVO' );
2141:
2142: -- in VQR we do not want to user to insert or update Attachements
2143: IF (p_mode = g_vqr_single_layout) THEN
2136:
2137: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
2138: l_item_style);
2139: jdr_docbuilder.setAttribute(special_elem, 'id', 'AK_ATTACHMENT_LINK' );
2140: jdr_docbuilder.setAttribute(special_elem, 'viewName', 'QualityResultsVO' );
2141:
2142: -- in VQR we do not want to user to insert or update Attachements
2143: IF (p_mode = g_vqr_single_layout) THEN
2144: jdr_docbuilder.setAttribute(special_elem, 'insertAllowed', 'false' );
2140: jdr_docbuilder.setAttribute(special_elem, 'viewName', 'QualityResultsVO' );
2141:
2142: -- in VQR we do not want to user to insert or update Attachements
2143: IF (p_mode = g_vqr_single_layout) THEN
2144: jdr_docbuilder.setAttribute(special_elem, 'insertAllowed', 'false' );
2145: jdr_docbuilder.setAttribute(special_elem, 'updateAllowed', 'false' );
2146: jdr_docbuilder.setAttribute(special_elem, 'deleteAllowed', 'false' );
2147:
2148:
2141:
2142: -- in VQR we do not want to user to insert or update Attachements
2143: IF (p_mode = g_vqr_single_layout) THEN
2144: jdr_docbuilder.setAttribute(special_elem, 'insertAllowed', 'false' );
2145: jdr_docbuilder.setAttribute(special_elem, 'updateAllowed', 'false' );
2146: jdr_docbuilder.setAttribute(special_elem, 'deleteAllowed', 'false' );
2147:
2148:
2149: END IF;
2142: -- in VQR we do not want to user to insert or update Attachements
2143: IF (p_mode = g_vqr_single_layout) THEN
2144: jdr_docbuilder.setAttribute(special_elem, 'insertAllowed', 'false' );
2145: jdr_docbuilder.setAttribute(special_elem, 'updateAllowed', 'false' );
2146: jdr_docbuilder.setAttribute(special_elem, 'deleteAllowed', 'false' );
2147:
2148:
2149: END IF;
2150:
2148:
2149: END IF;
2150:
2151:
2152: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,
2153: 'entityMappings', l_entityMap);
2154:
2155: JDR_DOCBUILDER.addChild(l_attachments_region, JDR_DOCBUILDER.UI_NS,
2156: 'contents', special_elem);
2151:
2152: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,
2153: 'entityMappings', l_entityMap);
2154:
2155: JDR_DOCBUILDER.addChild(l_attachments_region, JDR_DOCBUILDER.UI_NS,
2156: 'contents', special_elem);
2157:
2158: /*
2159: IF ( instr(p_prefix, g_vqr_prefix) = 1) THEN
2170:
2171: FUNCTION create_detail_region(
2172: p_plan_id IN NUMBER,
2173: p_dtl_region_code IN VARCHAR2,
2174: p_mode IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
2175:
2176: l_data_region_code VARCHAR2(35);
2177: l_comments_region_code VARCHAR2(35);
2178:
2175:
2176: l_data_region_code VARCHAR2(35);
2177: l_comments_region_code VARCHAR2(35);
2178:
2179: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2180: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2181: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2182:
2183: l_prompt VARCHAR2(30) := null;
2176: l_data_region_code VARCHAR2(35);
2177: l_comments_region_code VARCHAR2(35);
2178:
2179: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2180: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2181: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2182:
2183: l_prompt VARCHAR2(30) := null;
2184: l_char_count NUMBER := null;
2177: l_comments_region_code VARCHAR2(35);
2178:
2179: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2180: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2181: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2182:
2183: l_prompt VARCHAR2(30) := null;
2184: l_char_count NUMBER := null;
2185:
2213:
2214: END create_detail_region;
2215:
2216: -- create table action region containing buttons like duplicate and delete
2217: FUNCTION create_table_action_region RETURN jdr_docbuilder.element IS
2218:
2219: l_row_layout jdr_docbuilder.element := NULL;
2220: l_text jdr_docbuilder.element := NULL;
2221: l_dup_btn jdr_docbuilder.element := NULL;
2215:
2216: -- create table action region containing buttons like duplicate and delete
2217: FUNCTION create_table_action_region RETURN jdr_docbuilder.element IS
2218:
2219: l_row_layout jdr_docbuilder.element := NULL;
2220: l_text jdr_docbuilder.element := NULL;
2221: l_dup_btn jdr_docbuilder.element := NULL;
2222: l_del_btn jdr_docbuilder.element := NULL;
2223:
2216: -- create table action region containing buttons like duplicate and delete
2217: FUNCTION create_table_action_region RETURN jdr_docbuilder.element IS
2218:
2219: l_row_layout jdr_docbuilder.element := NULL;
2220: l_text jdr_docbuilder.element := NULL;
2221: l_dup_btn jdr_docbuilder.element := NULL;
2222: l_del_btn jdr_docbuilder.element := NULL;
2223:
2224: l_attr_code VARCHAR2(30);
2217: FUNCTION create_table_action_region RETURN jdr_docbuilder.element IS
2218:
2219: l_row_layout jdr_docbuilder.element := NULL;
2220: l_text jdr_docbuilder.element := NULL;
2221: l_dup_btn jdr_docbuilder.element := NULL;
2222: l_del_btn jdr_docbuilder.element := NULL;
2223:
2224: l_attr_code VARCHAR2(30);
2225:
2218:
2219: l_row_layout jdr_docbuilder.element := NULL;
2220: l_text jdr_docbuilder.element := NULL;
2221: l_dup_btn jdr_docbuilder.element := NULL;
2222: l_del_btn jdr_docbuilder.element := NULL;
2223:
2224: l_attr_code VARCHAR2(30);
2225:
2226: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_ACTION_REGION';
2234: -- create tableAction region items
2235: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2236: -- create rowLayout
2237: l_row_layout := create_jrad_region_item('rowLayout');
2238: jdr_docbuilder.setattribute(l_row_layout, 'id', 'rowLayoutRN'); -- set proper non static id
2239:
2240: -- create display text item
2241: l_text := create_jrad_region_item('messageStyledText');
2242: jdr_docbuilder.setattribute(l_text, 'id', 'displayText');
2238: jdr_docbuilder.setattribute(l_row_layout, 'id', 'rowLayoutRN'); -- set proper non static id
2239:
2240: -- create display text item
2241: l_text := create_jrad_region_item('messageStyledText');
2242: jdr_docbuilder.setattribute(l_text, 'id', 'displayText');
2243: l_label := fnd_message.get_string('QA','QA_TABLE_SELECT_MSG');
2244: jdr_docbuilder.setattribute(l_text, 'prompt', l_label);
2245:
2246: --create button
2240: -- create display text item
2241: l_text := create_jrad_region_item('messageStyledText');
2242: jdr_docbuilder.setattribute(l_text, 'id', 'displayText');
2243: l_label := fnd_message.get_string('QA','QA_TABLE_SELECT_MSG');
2244: jdr_docbuilder.setattribute(l_text, 'prompt', l_label);
2245:
2246: --create button
2247: l_dup_btn := create_jrad_region_item('submitButton');
2248: jdr_docbuilder.setattribute(l_dup_btn, 'id', 'dupBtn');
2244: jdr_docbuilder.setattribute(l_text, 'prompt', l_label);
2245:
2246: --create button
2247: l_dup_btn := create_jrad_region_item('submitButton');
2248: jdr_docbuilder.setattribute(l_dup_btn, 'id', 'dupBtn');
2249:
2250: -- do not set prompt with '&' instead use attribute sets
2251: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DUPLICATE_PROMPT');
2252: -- jdr_docbuilder.setattribute(l_dup_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2248: jdr_docbuilder.setattribute(l_dup_btn, 'id', 'dupBtn');
2249:
2250: -- do not set prompt with '&' instead use attribute sets
2251: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DUPLICATE_PROMPT');
2252: -- jdr_docbuilder.setattribute(l_dup_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2253: jdr_docbuilder.setattribute(l_dup_btn, 'use', l_dup_attr_set);
2254:
2255: jdr_docbuilder.setattribute(l_dup_btn, 'unvalidated', 'true');
2256:
2249:
2250: -- do not set prompt with '&' instead use attribute sets
2251: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DUPLICATE_PROMPT');
2252: -- jdr_docbuilder.setattribute(l_dup_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2253: jdr_docbuilder.setattribute(l_dup_btn, 'use', l_dup_attr_set);
2254:
2255: jdr_docbuilder.setattribute(l_dup_btn, 'unvalidated', 'true');
2256:
2257: --create button
2251: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DUPLICATE_PROMPT');
2252: -- jdr_docbuilder.setattribute(l_dup_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2253: jdr_docbuilder.setattribute(l_dup_btn, 'use', l_dup_attr_set);
2254:
2255: jdr_docbuilder.setattribute(l_dup_btn, 'unvalidated', 'true');
2256:
2257: --create button
2258: l_del_btn := create_jrad_region_item('submitButton');
2259: jdr_docbuilder.setattribute(l_del_btn, 'id', 'delBtn');
2255: jdr_docbuilder.setattribute(l_dup_btn, 'unvalidated', 'true');
2256:
2257: --create button
2258: l_del_btn := create_jrad_region_item('submitButton');
2259: jdr_docbuilder.setattribute(l_del_btn, 'id', 'delBtn');
2260:
2261: -- do not set prompt with '&' instead use attribute sets
2262: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DELETE_PROMPT');
2263: -- jdr_docbuilder.setattribute(l_del_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt) );
2259: jdr_docbuilder.setattribute(l_del_btn, 'id', 'delBtn');
2260:
2261: -- do not set prompt with '&' instead use attribute sets
2262: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DELETE_PROMPT');
2263: -- jdr_docbuilder.setattribute(l_del_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt) );
2264: jdr_docbuilder.setattribute(l_del_btn, 'use', l_del_attr_set);
2265:
2266: jdr_docbuilder.setattribute(l_del_btn, 'unvalidated', 'true');
2267: -- Bug 6856743 - Set server side validation to false.
2260:
2261: -- do not set prompt with '&' instead use attribute sets
2262: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DELETE_PROMPT');
2263: -- jdr_docbuilder.setattribute(l_del_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt) );
2264: jdr_docbuilder.setattribute(l_del_btn, 'use', l_del_attr_set);
2265:
2266: jdr_docbuilder.setattribute(l_del_btn, 'unvalidated', 'true');
2267: -- Bug 6856743 - Set server side validation to false.
2268: jdr_docbuilder.setattribute(l_del_btn, 'serverUnvalidated', 'True');
2262: -- l_prompt := fnd_message.get_string('QA','QA_QWB_DELETE_PROMPT');
2263: -- jdr_docbuilder.setattribute(l_del_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt) );
2264: jdr_docbuilder.setattribute(l_del_btn, 'use', l_del_attr_set);
2265:
2266: jdr_docbuilder.setattribute(l_del_btn, 'unvalidated', 'true');
2267: -- Bug 6856743 - Set server side validation to false.
2268: jdr_docbuilder.setattribute(l_del_btn, 'serverUnvalidated', 'True');
2269:
2270: -- add items to region
2264: jdr_docbuilder.setattribute(l_del_btn, 'use', l_del_attr_set);
2265:
2266: jdr_docbuilder.setattribute(l_del_btn, 'unvalidated', 'true');
2267: -- Bug 6856743 - Set server side validation to false.
2268: jdr_docbuilder.setattribute(l_del_btn, 'serverUnvalidated', 'True');
2269:
2270: -- add items to region
2271: add_child_to_parent(l_row_layout, l_text, 'contents');
2272: add_child_to_parent(l_row_layout, l_dup_btn, 'contents');
2278:
2279: END create_table_action_region;
2280:
2281: -- create table single selection region with radio button
2282: FUNCTION create_table_selection RETURN jdr_docbuilder.element IS
2283:
2284: l_sing_select jdr_docbuilder.element := NULL;
2285: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_SELECTION';
2286:
2280:
2281: -- create table single selection region with radio button
2282: FUNCTION create_table_selection RETURN jdr_docbuilder.element IS
2283:
2284: l_sing_select jdr_docbuilder.element := NULL;
2285: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_SELECTION';
2286:
2287: -- 12.1 Device Integration Project
2288: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2286:
2287: -- 12.1 Device Integration Project
2288: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2289: -- For PPR Event
2290: ppr_event jdr_docbuilder.ELEMENT;
2291:
2292: BEGIN
2293: -- create tableSelection
2294: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2293: -- create tableSelection
2294: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2295: -- create singleSelection
2296: l_sing_select := create_jrad_region_item('singleSelection');
2297: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2298: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2299: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2300: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2301: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2294: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2295: -- create singleSelection
2296: l_sing_select := create_jrad_region_item('singleSelection');
2297: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2298: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2299: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2300: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2301: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2302:
2295: -- create singleSelection
2296: l_sing_select := create_jrad_region_item('singleSelection');
2297: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2298: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2299: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2300: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2301: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2302:
2303: -- 12.1 Device Integration Project
2296: l_sing_select := create_jrad_region_item('singleSelection');
2297: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2298: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2299: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2300: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2301: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2302:
2303: -- 12.1 Device Integration Project
2304: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2297: jdr_docbuilder.setattribute(l_sing_select, 'id', 'ResultSelection');
2298: jdr_docbuilder.setattribute(l_sing_select, 'text', ''); -- get it from message
2299: jdr_docbuilder.setattribute(l_sing_select, 'viewAttr', 'SelectFlag');
2300: jdr_docbuilder.setAttribute(l_sing_select, 'unvalidated', 'true');
2301: jdr_docbuilder.setAttribute(l_sing_select, 'serverUnvalidated', 'true');
2302:
2303: -- 12.1 Device Integration Project
2304: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2305: -- For PPR Event
2302:
2303: -- 12.1 Device Integration Project
2304: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2305: -- For PPR Event
2306: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2307: p_tagName => 'firePartialAction');
2308: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2309: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2310: jdr_docbuilder.addchild(p_parent => l_sing_select,
2304: -- bhsankar Tue Aug 28 04:20:24 PDT 2007
2305: -- For PPR Event
2306: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2307: p_tagName => 'firePartialAction');
2308: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2309: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2310: jdr_docbuilder.addchild(p_parent => l_sing_select,
2311: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2312: p_groupingTagName => 'primaryClientAction',
2305: -- For PPR Event
2306: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2307: p_tagName => 'firePartialAction');
2308: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2309: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2310: jdr_docbuilder.addchild(p_parent => l_sing_select,
2311: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2312: p_groupingTagName => 'primaryClientAction',
2313: p_child => ppr_event);
2306: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2307: p_tagName => 'firePartialAction');
2308: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2309: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2310: jdr_docbuilder.addchild(p_parent => l_sing_select,
2311: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2312: p_groupingTagName => 'primaryClientAction',
2313: p_child => ppr_event);
2314: -- Device Integration Project End.
2307: p_tagName => 'firePartialAction');
2308: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qaselect');
2309: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2310: jdr_docbuilder.addchild(p_parent => l_sing_select,
2311: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2312: p_groupingTagName => 'primaryClientAction',
2313: p_child => ppr_event);
2314: -- Device Integration Project End.
2315:
2323:
2324: END create_table_selection;
2325:
2326: -- create table single selection region with radio button
2327: FUNCTION create_table_footer RETURN jdr_docbuilder.element IS
2328:
2329: l_add_btn jdr_docbuilder.element := NULL;
2330: l_footer jdr_docbuilder.element := NULL;
2331: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_FOOTER';
2325:
2326: -- create table single selection region with radio button
2327: FUNCTION create_table_footer RETURN jdr_docbuilder.element IS
2328:
2329: l_add_btn jdr_docbuilder.element := NULL;
2330: l_footer jdr_docbuilder.element := NULL;
2331: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_FOOTER';
2332: l_prompt VARCHAR2(50);
2333:
2326: -- create table single selection region with radio button
2327: FUNCTION create_table_footer RETURN jdr_docbuilder.element IS
2328:
2329: l_add_btn jdr_docbuilder.element := NULL;
2330: l_footer jdr_docbuilder.element := NULL;
2331: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_TABLE_FOOTER';
2332: l_prompt VARCHAR2(50);
2333:
2334: BEGIN
2335: -- create tableSelection
2336: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2337: -- create Button
2338: l_add_btn := create_jrad_region_item('addTableRow');
2339: jdr_docbuilder.setattribute(l_add_btn, 'id', 'addResultRow');
2340: jdr_docbuilder.setattribute(l_add_btn, 'autoInsertion', 'false');
2341:
2342: -- l_prompt := fnd_message.get_string('QA','QA_QWB_ADD_PROMPT');
2343: -- jdr_docbuilder.setattribute(l_add_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2336: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2337: -- create Button
2338: l_add_btn := create_jrad_region_item('addTableRow');
2339: jdr_docbuilder.setattribute(l_add_btn, 'id', 'addResultRow');
2340: jdr_docbuilder.setattribute(l_add_btn, 'autoInsertion', 'false');
2341:
2342: -- l_prompt := fnd_message.get_string('QA','QA_QWB_ADD_PROMPT');
2343: -- jdr_docbuilder.setattribute(l_add_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2344:
2339: jdr_docbuilder.setattribute(l_add_btn, 'id', 'addResultRow');
2340: jdr_docbuilder.setattribute(l_add_btn, 'autoInsertion', 'false');
2341:
2342: -- l_prompt := fnd_message.get_string('QA','QA_QWB_ADD_PROMPT');
2343: -- jdr_docbuilder.setattribute(l_add_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2344:
2345: l_footer := create_jrad_region_item('tableFooter');
2346: jdr_docbuilder.setattribute(l_footer, 'id', 'resultFooter');
2347:
2342: -- l_prompt := fnd_message.get_string('QA','QA_QWB_ADD_PROMPT');
2343: -- jdr_docbuilder.setattribute(l_add_btn, 'prompt', DBMS_XMLGEN.convert(l_prompt));
2344:
2345: l_footer := create_jrad_region_item('tableFooter');
2346: jdr_docbuilder.setattribute(l_footer, 'id', 'resultFooter');
2347:
2348: -- add button to footer
2349: add_child_to_parent(l_footer, l_add_btn, 'contents');
2350:
2354:
2355: END create_table_footer;
2356:
2357: -- add table action to table or advanced table
2358: PROCEDURE add_table_action(p_prnt_elm IN jdr_docbuilder.element ) IS
2359: l_tbl_act jdr_docbuilder.element := NULL;
2360: BEGIN
2361: -- add table actions to table or advanced table
2362: l_tbl_act := create_table_action_region;
2355: END create_table_footer;
2356:
2357: -- add table action to table or advanced table
2358: PROCEDURE add_table_action(p_prnt_elm IN jdr_docbuilder.element ) IS
2359: l_tbl_act jdr_docbuilder.element := NULL;
2360: BEGIN
2361: -- add table actions to table or advanced table
2362: l_tbl_act := create_table_action_region;
2363: add_child_to_parent(p_prnt_elm, l_tbl_act, 'tableActions');
2364: END add_table_action;
2365:
2366:
2367: -- add table single selection to table or advanced table
2368: PROCEDURE add_table_selection(p_prnt_elm IN jdr_docbuilder.element )IS
2369: l_tbl_s_sel jdr_docbuilder.element := NULL;
2370: BEGIN
2371: -- add ingle selection to table or advanced table
2372: l_tbl_s_sel := create_table_selection;
2365:
2366:
2367: -- add table single selection to table or advanced table
2368: PROCEDURE add_table_selection(p_prnt_elm IN jdr_docbuilder.element )IS
2369: l_tbl_s_sel jdr_docbuilder.element := NULL;
2370: BEGIN
2371: -- add ingle selection to table or advanced table
2372: l_tbl_s_sel := create_table_selection;
2373: add_child_to_parent(p_prnt_elm, l_tbl_s_sel, 'tableSelection');
2374: END add_table_selection;
2375:
2376:
2377: -- add footer to advanced table
2378: PROCEDURE add_table_footer(p_prnt_elm IN jdr_docbuilder.element) IS
2379: l_tbl_footer jdr_docbuilder.element := NULL;
2380: BEGIN
2381: -- add footer to table or advanced table
2382: l_tbl_footer := create_table_footer;
2375:
2376:
2377: -- add footer to advanced table
2378: PROCEDURE add_table_footer(p_prnt_elm IN jdr_docbuilder.element) IS
2379: l_tbl_footer jdr_docbuilder.element := NULL;
2380: BEGIN
2381: -- add footer to table or advanced table
2382: l_tbl_footer := create_table_footer;
2383: add_child_to_parent(p_prnt_elm, l_tbl_footer, 'footer');
2392: --
2393:
2394: PROCEDURE add_device_checkbox_to_parent(
2395: p_plan_id IN NUMBER,
2396: p_parent_region JDR_DOCBUILDER.ELEMENT) IS
2397:
2398: l_api_name CONSTANT VARCHAR2(50) := 'ADD_DEVICE_CHECKBOX_TO_PARENT';
2399: l_messageCompLayout JDR_DOCBUILDER.ELEMENT := NULL;
2400: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2395: p_plan_id IN NUMBER,
2396: p_parent_region JDR_DOCBUILDER.ELEMENT) IS
2397:
2398: l_api_name CONSTANT VARCHAR2(50) := 'ADD_DEVICE_CHECKBOX_TO_PARENT';
2399: l_messageCompLayout JDR_DOCBUILDER.ELEMENT := NULL;
2400: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2401: l_prompt VARCHAR2(100);
2402: l_element_prefix VARCHAR2(15) := g_element_prefix;
2403: l_element_suffix VARCHAR2(15) := g_device_element_suffix;
2396: p_parent_region JDR_DOCBUILDER.ELEMENT) IS
2397:
2398: l_api_name CONSTANT VARCHAR2(50) := 'ADD_DEVICE_CHECKBOX_TO_PARENT';
2399: l_messageCompLayout JDR_DOCBUILDER.ELEMENT := NULL;
2400: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2401: l_prompt VARCHAR2(100);
2402: l_element_prefix VARCHAR2(15) := g_element_prefix;
2403: l_element_suffix VARCHAR2(15) := g_device_element_suffix;
2404: l_attribute_code VARCHAR2(30);
2418: ORDER BY qpc.prompt_sequence;
2419:
2420: BEGIN
2421: log_error(g_pkg_name || l_api_name, 'Procedure BEGIN');
2422: l_messageCompLayout := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'messageComponentLayout');
2423: jdr_docbuilder.setAttribute(l_messageCompLayout, 'id', 'ChkBoxRN');
2424: jdr_docbuilder.setAttribute(l_messageCompLayout, 'rows', '1');
2425: jdr_docbuilder.setAttribute(l_messageCompLayout, 'columns', '4');
2426: log_error(g_pkg_name || l_api_name, 'message componenet layput created');
2419:
2420: BEGIN
2421: log_error(g_pkg_name || l_api_name, 'Procedure BEGIN');
2422: l_messageCompLayout := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'messageComponentLayout');
2423: jdr_docbuilder.setAttribute(l_messageCompLayout, 'id', 'ChkBoxRN');
2424: jdr_docbuilder.setAttribute(l_messageCompLayout, 'rows', '1');
2425: jdr_docbuilder.setAttribute(l_messageCompLayout, 'columns', '4');
2426: log_error(g_pkg_name || l_api_name, 'message componenet layput created');
2427:
2420: BEGIN
2421: log_error(g_pkg_name || l_api_name, 'Procedure BEGIN');
2422: l_messageCompLayout := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'messageComponentLayout');
2423: jdr_docbuilder.setAttribute(l_messageCompLayout, 'id', 'ChkBoxRN');
2424: jdr_docbuilder.setAttribute(l_messageCompLayout, 'rows', '1');
2425: jdr_docbuilder.setAttribute(l_messageCompLayout, 'columns', '4');
2426: log_error(g_pkg_name || l_api_name, 'message componenet layput created');
2427:
2428: FOR r in c LOOP
2421: log_error(g_pkg_name || l_api_name, 'Procedure BEGIN');
2422: l_messageCompLayout := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'messageComponentLayout');
2423: jdr_docbuilder.setAttribute(l_messageCompLayout, 'id', 'ChkBoxRN');
2424: jdr_docbuilder.setAttribute(l_messageCompLayout, 'rows', '1');
2425: jdr_docbuilder.setAttribute(l_messageCompLayout, 'columns', '4');
2426: log_error(g_pkg_name || l_api_name, 'message componenet layput created');
2427:
2428: FOR r in c LOOP
2429: l_char_item := create_jrad_region_item('messageCheckBox');
2429: l_char_item := create_jrad_region_item('messageCheckBox');
2430: l_prompt := get_prompt(p_plan_id, r.char_id);
2431: l_attribute_code := construct_code(l_element_prefix, r.char_id, l_element_suffix);
2432:
2433: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2434: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2435: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2436: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2437: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2430: l_prompt := get_prompt(p_plan_id, r.char_id);
2431: l_attribute_code := construct_code(l_element_prefix, r.char_id, l_element_suffix);
2432:
2433: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2434: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2435: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2436: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2437: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2438: add_child_to_parent(l_messageCompLayout, l_char_item,'contents');
2431: l_attribute_code := construct_code(l_element_prefix, r.char_id, l_element_suffix);
2432:
2433: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2434: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2435: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2436: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2437: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2438: add_child_to_parent(l_messageCompLayout, l_char_item,'contents');
2439: log_error(g_pkg_name || l_api_name, 'checkbox created for element: ' || l_prompt);
2432:
2433: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2434: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2435: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2436: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2437: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2438: add_child_to_parent(l_messageCompLayout, l_char_item,'contents');
2439: log_error(g_pkg_name || l_api_name, 'checkbox created for element: ' || l_prompt);
2440: END LOOP;
2433: jdr_docbuilder.setAttribute(l_char_item, 'id', l_attribute_code);
2434: jdr_docbuilder.setAttribute(l_char_item, 'prompt', l_prompt);
2435: jdr_docbuilder.setAttribute(l_char_item, 'unvalidated', 'true');
2436: jdr_docbuilder.setAttribute(l_char_item, 'serverUnvalidated', 'true');
2437: jdr_docbuilder.setAttribute(l_char_item, 'checked', 'true');
2438: add_child_to_parent(l_messageCompLayout, l_char_item,'contents');
2439: log_error(g_pkg_name || l_api_name, 'checkbox created for element: ' || l_prompt);
2440: END LOOP;
2441:
2443: log_error(g_pkg_name || l_api_name, 'Procedure END');
2444: END add_device_checkbox_to_parent;
2445:
2446: FUNCTION create_device_button_region
2447: RETURN JDR_DOCBUILDER.ELEMENT IS
2448: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_BUTTON_REGION';
2449: l_button_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2450: l_button_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2451: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2445:
2446: FUNCTION create_device_button_region
2447: RETURN JDR_DOCBUILDER.ELEMENT IS
2448: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_BUTTON_REGION';
2449: l_button_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2450: l_button_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2451: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2452: l_prompt VARCHAR2(30);
2453:
2446: FUNCTION create_device_button_region
2447: RETURN JDR_DOCBUILDER.ELEMENT IS
2448: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_BUTTON_REGION';
2449: l_button_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2450: l_button_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2451: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2452: l_prompt VARCHAR2(30);
2453:
2454: --PPRTEST
2447: RETURN JDR_DOCBUILDER.ELEMENT IS
2448: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_BUTTON_REGION';
2449: l_button_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2450: l_button_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2451: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2452: l_prompt VARCHAR2(30);
2453:
2454: --PPRTEST
2455: ppr_event jdr_docbuilder.ELEMENT;
2451: l_submit_button JDR_DOCBUILDER.ELEMENT := NULL;
2452: l_prompt VARCHAR2(30);
2453:
2454: --PPRTEST
2455: ppr_event jdr_docbuilder.ELEMENT;
2456: BEGIN
2457: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2458: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2459: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2454: --PPRTEST
2455: ppr_event jdr_docbuilder.ELEMENT;
2456: BEGIN
2457: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2458: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2459: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2460: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2461: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2462: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2455: ppr_event jdr_docbuilder.ELEMENT;
2456: BEGIN
2457: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2458: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2459: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2460: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2461: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2462: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2463:
2456: BEGIN
2457: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2458: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2459: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2460: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2461: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2462: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2463:
2464: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2457: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2458: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2459: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2460: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2461: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2462: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2463:
2464: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2465: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2458: l_button_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2459: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'id', 'ReadButtonRowLayout');
2460: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2461: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2462: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2463:
2464: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2465: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2466: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2460: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'width', '100%');
2461: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2462: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2463:
2464: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2465: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2466: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2467: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2468: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2461: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'hAlign', 'end');
2462: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2463:
2464: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2465: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2466: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2467: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2468: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2469:
2462: jdr_docbuilder.setAttribute(l_button_rowlayout_region, 'vAlign', 'top');
2463:
2464: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2465: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2466: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2467: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2468: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2469:
2470: l_submit_button := create_jrad_region_item('submitButton');
2463:
2464: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2465: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2466: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2467: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2468: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2469:
2470: l_submit_button := create_jrad_region_item('submitButton');
2471: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2464: l_button_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2465: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'id', 'ReadButtonCellLayout');
2466: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'width', '100%');
2467: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'hAlign', 'end');
2468: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2469:
2470: l_submit_button := create_jrad_region_item('submitButton');
2471: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2472: jdr_docbuilder.setAttribute(l_submit_button, 'id', 'ReadDeviceButton');
2468: jdr_docbuilder.setAttribute(l_button_cellformat_region, 'vAlign', 'top');
2469:
2470: l_submit_button := create_jrad_region_item('submitButton');
2471: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2472: jdr_docbuilder.setAttribute(l_submit_button, 'id', 'ReadDeviceButton');
2473: jdr_docbuilder.setAttribute(l_submit_button, 'prompt', l_prompt);
2474: jdr_docbuilder.setAttribute(l_submit_button, 'unvalidated', 'true');
2475: -- bug 6737113
2476: -- Added accessKey for Read Device as O.
2469:
2470: l_submit_button := create_jrad_region_item('submitButton');
2471: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2472: jdr_docbuilder.setAttribute(l_submit_button, 'id', 'ReadDeviceButton');
2473: jdr_docbuilder.setAttribute(l_submit_button, 'prompt', l_prompt);
2474: jdr_docbuilder.setAttribute(l_submit_button, 'unvalidated', 'true');
2475: -- bug 6737113
2476: -- Added accessKey for Read Device as O.
2477: -- bhsankar Tue Jan 22 04:12:09 PST 2008
2470: l_submit_button := create_jrad_region_item('submitButton');
2471: l_prompt := DBMS_XMLGEN.convert(fnd_message.get_string('QA','QA_QWB_READ_DEV_BUTTON_LABEL'));
2472: jdr_docbuilder.setAttribute(l_submit_button, 'id', 'ReadDeviceButton');
2473: jdr_docbuilder.setAttribute(l_submit_button, 'prompt', l_prompt);
2474: jdr_docbuilder.setAttribute(l_submit_button, 'unvalidated', 'true');
2475: -- bug 6737113
2476: -- Added accessKey for Read Device as O.
2477: -- bhsankar Tue Jan 22 04:12:09 PST 2008
2478: jdr_docbuilder.setAttribute(l_submit_button, 'accessKey', '0');
2474: jdr_docbuilder.setAttribute(l_submit_button, 'unvalidated', 'true');
2475: -- bug 6737113
2476: -- Added accessKey for Read Device as O.
2477: -- bhsankar Tue Jan 22 04:12:09 PST 2008
2478: jdr_docbuilder.setAttribute(l_submit_button, 'accessKey', '0');
2479: jdr_docbuilder.setAttribute(l_submit_button, 'serverUnvalidated', 'true');
2480:
2481: --For PPR
2482: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2475: -- bug 6737113
2476: -- Added accessKey for Read Device as O.
2477: -- bhsankar Tue Jan 22 04:12:09 PST 2008
2478: jdr_docbuilder.setAttribute(l_submit_button, 'accessKey', '0');
2479: jdr_docbuilder.setAttribute(l_submit_button, 'serverUnvalidated', 'true');
2480:
2481: --For PPR
2482: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2483: p_tagName => 'firePartialAction');
2478: jdr_docbuilder.setAttribute(l_submit_button, 'accessKey', '0');
2479: jdr_docbuilder.setAttribute(l_submit_button, 'serverUnvalidated', 'true');
2480:
2481: --For PPR
2482: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2483: p_tagName => 'firePartialAction');
2484: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2485: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2486:
2480:
2481: --For PPR
2482: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2483: p_tagName => 'firePartialAction');
2484: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2485: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2486:
2487: jdr_docbuilder.addchild(p_parent => l_submit_button,
2488: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2481: --For PPR
2482: ppr_event := JDR_DOCBUILDER.createElement(p_namespace => JDR_DOCBUILDER.UI_NS,
2483: p_tagName => 'firePartialAction');
2484: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2485: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2486:
2487: jdr_docbuilder.addchild(p_parent => l_submit_button,
2488: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2489: p_groupingTagName => 'primaryClientAction',
2483: p_tagName => 'firePartialAction');
2484: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2485: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2486:
2487: jdr_docbuilder.addchild(p_parent => l_submit_button,
2488: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2489: p_groupingTagName => 'primaryClientAction',
2490: p_child => ppr_event);
2491:
2484: jdr_docbuilder.setAttribute(ppr_event, 'event', 'qadevice');
2485: jdr_docbuilder.setAttribute(ppr_event, 'unvalidated', 'true');
2486:
2487: jdr_docbuilder.addchild(p_parent => l_submit_button,
2488: p_groupingNS => JDR_DOCBUILDER.UI_NS,
2489: p_groupingTagName => 'primaryClientAction',
2490: p_child => ppr_event);
2491:
2492: add_child_to_parent(l_button_cellformat_region,l_submit_button,'contents');
2496:
2497: END create_device_button_region;
2498:
2499: FUNCTION create_device_checkbox_region(
2500: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
2501:
2502: l_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2503: l_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2504: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2498:
2499: FUNCTION create_device_checkbox_region(
2500: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
2501:
2502: l_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2503: l_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2504: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2505: BEGIN
2506: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2499: FUNCTION create_device_checkbox_region(
2500: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
2501:
2502: l_rowlayout_region JDR_DOCBUILDER.ELEMENT := NULL;
2503: l_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2504: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2505: BEGIN
2506: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2507: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2503: l_cellformat_region JDR_DOCBUILDER.ELEMENT := NULL;
2504: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2505: BEGIN
2506: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2507: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2508: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2509: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2510:
2511: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2504: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_CHECKBOX_REGION';
2505: BEGIN
2506: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2507: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2508: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2509: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2510:
2511: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2512: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2505: BEGIN
2506: log_error(g_pkg_name || l_api_name, 'Function BEGIN');
2507: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2508: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2509: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2510:
2511: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2512: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2513: jdr_docbuilder.setAttribute(l_cellformat_region, 'width', '100%');
2507: l_rowlayout_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'rowLayout');
2508: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2509: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2510:
2511: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2512: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2513: jdr_docbuilder.setAttribute(l_cellformat_region, 'width', '100%');
2514:
2515: add_device_checkbox_to_parent(p_plan_id, l_cellformat_region);
2508: jdr_docbuilder.setAttribute(l_rowlayout_region, 'id', 'ChkBoxRowLayout');
2509: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2510:
2511: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2512: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2513: jdr_docbuilder.setAttribute(l_cellformat_region, 'width', '100%');
2514:
2515: add_device_checkbox_to_parent(p_plan_id, l_cellformat_region);
2516: add_child_to_parent(l_rowlayout_region,l_cellformat_region,'contents');
2509: jdr_docbuilder.setAttribute(l_rowlayout_region, 'width', '100%');
2510:
2511: l_cellformat_region := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, 'cellFormat');
2512: jdr_docbuilder.setAttribute(l_cellformat_region, 'id', 'ChkBoxCellFormat');
2513: jdr_docbuilder.setAttribute(l_cellformat_region, 'width', '100%');
2514:
2515: add_device_checkbox_to_parent(p_plan_id, l_cellformat_region);
2516: add_child_to_parent(l_rowlayout_region,l_cellformat_region,'contents');
2517: log_error(g_pkg_name || l_api_name, 'Function END');
2521:
2522: FUNCTION create_device_region(
2523: p_plan_id IN NUMBER,
2524: p_device_region_code IN VARCHAR2 DEFAULT g_eqr_device_prefix,
2525: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
2526: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2527: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2528: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2529: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2523: p_plan_id IN NUMBER,
2524: p_device_region_code IN VARCHAR2 DEFAULT g_eqr_device_prefix,
2525: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
2526: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2527: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2528: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2529: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2530: l_checkbox_region JDR_DOCBUILDER.ELEMENT := NULL;
2531:
2524: p_device_region_code IN VARCHAR2 DEFAULT g_eqr_device_prefix,
2525: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
2526: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2527: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2528: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2529: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2530: l_checkbox_region JDR_DOCBUILDER.ELEMENT := NULL;
2531:
2532: l_prompt VARCHAR2(100) := null;
2525: p_parent_region_prefix IN VARCHAR2 DEFAULT NULL) RETURN JDR_DOCBUILDER.ELEMENT IS
2526: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2527: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2528: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2529: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2530: l_checkbox_region JDR_DOCBUILDER.ELEMENT := NULL;
2531:
2532: l_prompt VARCHAR2(100) := null;
2533:
2526: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_DEVICE_REGION';
2527: l_device_region_hdr JDR_DOCBUILDER.ELEMENT := NULL;
2528: l_table_layout_region JDR_DOCBUILDER.ELEMENT := NULL;
2529: l_button_region JDR_DOCBUILDER.ELEMENT := NULL;
2530: l_checkbox_region JDR_DOCBUILDER.ELEMENT := NULL;
2531:
2532: l_prompt VARCHAR2(100) := null;
2533:
2534:
2572: l_saved PLS_INTEGER;
2573: l_err_num NUMBER;
2574: l_err_msg VARCHAR2(100);
2575:
2576: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2577: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2578: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2579: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2580: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2573: l_err_num NUMBER;
2574: l_err_msg VARCHAR2(100);
2575:
2576: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2577: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2578: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2579: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2580: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2581:
2574: l_err_msg VARCHAR2(100);
2575:
2576: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2577: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2578: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2579: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2580: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2581:
2582: --
2575:
2576: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2577: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2578: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2579: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2580: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2581:
2582: --
2583: -- 12.1 Device Integration Project
2576: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2577: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2578: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2579: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2580: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2581:
2582: --
2583: -- 12.1 Device Integration Project
2584: -- Functions to create the device region
2584: -- Functions to create the device region
2585: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
2586: --
2587: l_device_region_code VARCHAR2(35) := NULL;
2588: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
2589: l_api_name CONSTANT VARCHAR2(50) := 'map_plan_eqr_single';
2590:
2591: BEGIN
2592: -- this version of map_plan_eqr_single takes in prefix of top region, data region and comment region
2644: add_child_to_parent(l_top_region, l_attachments_region, 'contents');
2645: END IF;
2646:
2647: -- save the document
2648: l_saved := JDR_DOCBUILDER.SAVE;
2649:
2650: log_error(g_pkg_name || l_api_name, ' Function END');
2651:
2652: EXCEPTION
2681: l_saved PLS_INTEGER;
2682: l_err_num NUMBER;
2683: l_err_msg VARCHAR2(100);
2684:
2685: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2686: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2687: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2688: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2689: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2682: l_err_num NUMBER;
2683: l_err_msg VARCHAR2(100);
2684:
2685: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2686: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2687: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2688: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2689: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2690:
2683: l_err_msg VARCHAR2(100);
2684:
2685: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2686: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2687: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2688: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2689: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2690:
2691: BEGIN
2684:
2685: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2686: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2687: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2688: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2689: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2690:
2691: BEGIN
2692: -- Similar to map_plan_eqr_single logic
2685: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2686: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2687: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2688: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2689: l_attachments_region JDR_DOCBUILDER.ELEMENT := NULL;
2690:
2691: BEGIN
2692: -- Similar to map_plan_eqr_single logic
2693:
2723: add_child_to_parent(l_top_region, l_attachments_region, 'contents');
2724: END IF;
2725:
2726: -- save the document
2727: l_saved := JDR_DOCBUILDER.SAVE;
2728:
2729: EXCEPTION
2730:
2731: WHEN OTHERS THEN
2787:
2788:
2789: FUNCTION create_item_for_mult_vqr( p_plan_id IN NUMBER,
2790: p_char_id IN NUMBER,
2791: x_char_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT,
2792: x_char_dtl_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT)
2793: RETURN VARCHAR2 IS
2794:
2795: l_vo_attribute_name VARCHAR2(50);
2788:
2789: FUNCTION create_item_for_mult_vqr( p_plan_id IN NUMBER,
2790: p_char_id IN NUMBER,
2791: x_char_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT,
2792: x_char_dtl_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT)
2793: RETURN VARCHAR2 IS
2794:
2795: l_vo_attribute_name VARCHAR2(50);
2796: l_attr_code VARCHAR2(50);
2801: c_datatype VARCHAR2(30);
2802:
2803: l_displayed_flag NUMBER;
2804:
2805: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2806: l_char_item JDR_DOCBUILDER.ELEMENT;
2807: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2808: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2809:
2802:
2803: l_displayed_flag NUMBER;
2804:
2805: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2806: l_char_item JDR_DOCBUILDER.ELEMENT;
2807: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2808: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2809:
2810: l_datatype qa_chars.datatype%TYPE;
2803: l_displayed_flag NUMBER;
2804:
2805: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2806: l_char_item JDR_DOCBUILDER.ELEMENT;
2807: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2808: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2809:
2810: l_datatype qa_chars.datatype%TYPE;
2811:
2804:
2805: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2806: l_char_item JDR_DOCBUILDER.ELEMENT;
2807: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2808: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2809:
2810: l_datatype qa_chars.datatype%TYPE;
2811:
2812:
2812:
2813: BEGIN
2814: l_attr_code := construct_code(g_element_prefix, p_char_id);
2815: l_col_code := 'column' || l_attr_code;
2816: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
2817: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
2818:
2819:
2820: l_char_item := create_region_item_for_vqr(p_plan_id, p_char_id,
2813: BEGIN
2814: l_attr_code := construct_code(g_element_prefix, p_char_id);
2815: l_col_code := 'column' || l_attr_code;
2816: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
2817: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
2818:
2819:
2820: l_char_item := create_region_item_for_vqr(p_plan_id, p_char_id,
2821: g_element_prefix, g_vqr_multiple_layout);
2822: l_char_dtl_item := create_region_item_for_vqr(p_plan_id, p_char_id,
2823: g_dtl_element_prefix, g_vqr_multiple_layout);
2824:
2825: l_vo_attribute_name := get_export_vo_attribute_name(p_plan_id, p_char_id);
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: g_dtl_element_prefix, g_vqr_multiple_layout);
2824:
2825: l_vo_attribute_name := get_export_vo_attribute_name(p_plan_id, p_char_id);
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: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2824:
2825: l_vo_attribute_name := get_export_vo_attribute_name(p_plan_id, p_char_id);
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: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2832: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2825: l_vo_attribute_name := get_export_vo_attribute_name(p_plan_id, p_char_id);
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: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2832: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2833: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
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: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2832: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2833: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2834:
2835:
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: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2832: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2833: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2834:
2835:
2836: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2829: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2830:
2831: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2832: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2833: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2834:
2835:
2836: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2837:
2835:
2836: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2837:
2838: l_hrd_code := 'colHdr' || l_attr_code;
2839: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2840: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2841: l_prompt := get_prompt(p_plan_id, p_char_id);
2842: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2843: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2836: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2837:
2838: l_hrd_code := 'colHdr' || l_attr_code;
2839: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2840: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2841: l_prompt := get_prompt(p_plan_id, p_char_id);
2842: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2843: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2844: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2838: l_hrd_code := 'colHdr' || l_attr_code;
2839: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2840: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2841: l_prompt := get_prompt(p_plan_id, p_char_id);
2842: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2843: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2844: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2845: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2846:
2839: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2840: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2841: l_prompt := get_prompt(p_plan_id, p_char_id);
2842: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2843: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2844: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2845: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2846:
2847: l_datatype := qa_chars_api.datatype(p_char_id);
2840: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2841: l_prompt := get_prompt(p_plan_id, p_char_id);
2842: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2843: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2844: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2845: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2846:
2847: l_datatype := qa_chars_api.datatype(p_char_id);
2848: c_datatype := convert_data_type(l_datatype);
2845: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2846:
2847: l_datatype := qa_chars_api.datatype(p_char_id);
2848: c_datatype := convert_data_type(l_datatype);
2849: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2850:
2851: -- jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
2852: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'dataType', c_datatype);
2853:
2847: l_datatype := qa_chars_api.datatype(p_char_id);
2848: c_datatype := convert_data_type(l_datatype);
2849: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2850:
2851: -- jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
2852: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'dataType', c_datatype);
2853:
2854: x_char_item := l_col_hdr;
2855: x_char_dtl_item := l_char_dtl_item;
2848: c_datatype := convert_data_type(l_datatype);
2849: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2850:
2851: -- jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);
2852: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'dataType', c_datatype);
2853:
2854: x_char_item := l_col_hdr;
2855: x_char_dtl_item := l_char_dtl_item;
2856:
2857: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
2858: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
2859:
2860: if c_displayed_flag = 'true' then
2861: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2862: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2863: end if;
2864:
2865: return c_displayed_flag;
2858: c_displayed_flag := convert_boolean_flag(l_displayed_flag);
2859:
2860: if c_displayed_flag = 'true' then
2861: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2862: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2863: end if;
2864:
2865: return c_displayed_flag;
2866:
2867:
2868: END create_item_for_mult_vqr;
2869:
2870: PROCEDURE create_special_item_mult_vqr( p_attribute_code IN VARCHAR2,
2871: x_char_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT,
2872: x_char_dtl_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT)
2873: IS
2874:
2875: l_vo_attribute_name VARCHAR2(50);
2868: END create_item_for_mult_vqr;
2869:
2870: PROCEDURE create_special_item_mult_vqr( p_attribute_code IN VARCHAR2,
2871: x_char_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT,
2872: x_char_dtl_item OUT NOCOPY JDR_DOCBUILDER.ELEMENT)
2873: IS
2874:
2875: l_vo_attribute_name VARCHAR2(50);
2876: l_attr_code VARCHAR2(50);
2877: l_col_code VARCHAR2(50);
2878: l_hrd_code VARCHAR2(50);
2879: l_prompt VARCHAR2(50);
2880:
2881: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2882: l_char_item JDR_DOCBUILDER.ELEMENT;
2883: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2884: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2885:
2878: l_hrd_code VARCHAR2(50);
2879: l_prompt VARCHAR2(50);
2880:
2881: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2882: l_char_item JDR_DOCBUILDER.ELEMENT;
2883: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2884: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2885:
2886: BEGIN
2879: l_prompt VARCHAR2(50);
2880:
2881: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2882: l_char_item JDR_DOCBUILDER.ELEMENT;
2883: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2884: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2885:
2886: BEGIN
2887:
2880:
2881: l_col_hdr JDR_DOCBUILDER.ELEMENT;
2882: l_char_item JDR_DOCBUILDER.ELEMENT;
2883: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2884: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2885:
2886: BEGIN
2887:
2888: l_attr_code := construct_code(g_element_prefix, p_attribute_code);
2886: BEGIN
2887:
2888: l_attr_code := construct_code(g_element_prefix, p_attribute_code);
2889: l_col_code := 'column' || l_attr_code;
2890: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
2891: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
2892:
2893: l_char_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2894: g_element_prefix, g_vqr_multiple_layout);
2887:
2888: l_attr_code := construct_code(g_element_prefix, p_attribute_code);
2889: l_col_code := 'column' || l_attr_code;
2890: l_col_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'column');
2891: jdr_docbuilder.setattribute(l_col_hdr, 'id', l_col_code);
2892:
2893: l_char_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2894: g_element_prefix, g_vqr_multiple_layout);
2895: l_char_dtl_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2894: g_element_prefix, g_vqr_multiple_layout);
2895: l_char_dtl_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2896: g_dtl_element_prefix, g_vqr_multiple_layout);
2897:
2898: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2899: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2900: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2901:
2902: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2895: l_char_dtl_item := create_special_region_item (p_attribute_code, 'messageStyledText',
2896: g_dtl_element_prefix, g_vqr_multiple_layout);
2897:
2898: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2899: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2900: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2901:
2902: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2903:
2896: g_dtl_element_prefix, g_vqr_multiple_layout);
2897:
2898: jdr_docbuilder.setAttribute(l_char_item, 'sortable', 'true');
2899: jdr_docbuilder.setAttribute(l_char_dtl_item, 'sortable', 'true');
2900: jdr_docbuilder.setAttribute(l_col_hdr, 'sortable' , 'true');
2901:
2902: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2903:
2904: l_hrd_code := 'colHdr' || l_attr_code;
2901:
2902: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2903:
2904: l_hrd_code := 'colHdr' || l_attr_code;
2905: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2906: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2907: l_prompt := get_special_item_label(p_attribute_code);
2908: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2909: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2902: add_child_to_parent(l_col_hdr, l_char_item, 'contents');
2903:
2904: l_hrd_code := 'colHdr' || l_attr_code;
2905: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2906: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2907: l_prompt := get_special_item_label(p_attribute_code);
2908: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2909: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2910: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2904: l_hrd_code := 'colHdr' || l_attr_code;
2905: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2906: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2907: l_prompt := get_special_item_label(p_attribute_code);
2908: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2909: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2910: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2911: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2912:
2905: l_sort_hdr := jdr_docbuilder.createElement(jdr_docbuilder.oa_ns, 'sortableHeader');
2906: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2907: l_prompt := get_special_item_label(p_attribute_code);
2908: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2909: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2910: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2911: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2912:
2913:
2906: jdr_docbuilder.setAttribute(l_sort_hdr, 'id', l_hrd_code);
2907: l_prompt := get_special_item_label(p_attribute_code);
2908: jdr_docbuilder.setAttribute(l_sort_hdr, 'prompt', l_prompt);
2909: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2910: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2911: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2912:
2913:
2914: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2910: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2911: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2912:
2913:
2914: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2915:
2916: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2917: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2918:
2912:
2913:
2914: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2915:
2916: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2917: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2918:
2919:
2920: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2913:
2914: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2915:
2916: jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
2917: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2918:
2919:
2920: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2921: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2917: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
2918:
2919:
2920: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2921: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2922: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2923: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2924: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2925:
2918:
2919:
2920: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2921: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2922: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2923: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2924: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2925:
2926:
2919:
2920: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2921: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2922: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2923: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2924: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2925:
2926:
2927:
2920: l_vo_attribute_name := get_hc_export_vo_attr_name(p_attribute_code);
2921: jdr_docbuilder.setAttribute(l_char_item, 'viewName', g_export_vo_name);
2922: jdr_docbuilder.setAttribute(l_char_item, 'viewAttr', l_vo_attribute_name);
2923: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewName', g_export_vo_name);
2924: jdr_docbuilder.setAttribute(l_char_dtl_item, 'viewAttr', l_vo_attribute_name);
2925:
2926:
2927:
2928: x_char_item := l_col_hdr;
2949: l_displayed_flag NUMBER;
2950: c_displayed_flag VARCHAR2(10);
2951:
2952:
2953: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2954: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2955: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2956: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2957: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2950: c_displayed_flag VARCHAR2(10);
2951:
2952:
2953: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2954: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2955: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2956: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2957: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2958: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2951:
2952:
2953: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2954: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2955: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2956: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2957: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2958: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2959: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2952:
2953: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2954: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2955: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2956: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2957: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2958: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2959: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2960:
2953: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
2954: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2955: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2956: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2957: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2958: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2959: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2960:
2961:
2954: l_top_region JDR_DOCBUILDER.ELEMENT := NULL;
2955: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2956: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2957: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2958: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2959: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2960:
2961:
2962: CURSOR plan_chars (p_char_type VARCHAR2)IS
2955: l_data_region JDR_DOCBUILDER.ELEMENT := NULL;
2956: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
2957: l_comments_region JDR_DOCBUILDER.ELEMENT := NULL;
2958: l_char_item JDR_DOCBUILDER.ELEMENT := NULL;
2959: l_char_dtl_item JDR_DOCBUILDER.ELEMENT := NULL;
2960:
2961:
2962: CURSOR plan_chars (p_char_type VARCHAR2)IS
2963: SELECT qpc.char_id
2984: l_top_doc := create_top_document(g_jrad_region_path || l_top_region_code);
2985:
2986: l_prompt := get_region_prompt('DATA');
2987: l_top_region := create_jrad_region (l_top_region_code, 'advancedTable', l_prompt, null, g_vqr_multiple_layout);
2988: jdr_docbuilder.setAttribute(l_top_region, 'width', '100%');
2989: JDR_DOCBUILDER.setTopLevelElement(l_top_doc, l_top_region);
2990: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_export_vo_name);
2991:
2992: -- create the detail container region
2985:
2986: l_prompt := get_region_prompt('DATA');
2987: l_top_region := create_jrad_region (l_top_region_code, 'advancedTable', l_prompt, null, g_vqr_multiple_layout);
2988: jdr_docbuilder.setAttribute(l_top_region, 'width', '100%');
2989: JDR_DOCBUILDER.setTopLevelElement(l_top_doc, l_top_region);
2990: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_export_vo_name);
2991:
2992: -- create the detail container region
2993: l_dtl_region_code := construct_code(g_vqr_mult_dtl_prefix, p_plan_id);
2986: l_prompt := get_region_prompt('DATA');
2987: l_top_region := create_jrad_region (l_top_region_code, 'advancedTable', l_prompt, null, g_vqr_multiple_layout);
2988: jdr_docbuilder.setAttribute(l_top_region, 'width', '100%');
2989: JDR_DOCBUILDER.setTopLevelElement(l_top_doc, l_top_region);
2990: JDR_DOCBUILDER.setAttribute(l_top_region, 'viewName', g_export_vo_name);
2991:
2992: -- create the detail container region
2993: l_dtl_region_code := construct_code(g_vqr_mult_dtl_prefix, p_plan_id);
2994: l_dtl_region := create_jrad_region(l_dtl_region_code, 'stackLayout', null, '-1');
3013: add_child_to_parent(l_top_region, l_char_item, 'contents');
3014: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3015:
3016: if c_displayed_flag = 'false' then
3017: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
3018: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', c_displayed_flag);
3019: elsif c_displayed_flag = 'true' then
3020: if l_counter < 5 then
3021: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3014: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3015:
3016: if c_displayed_flag = 'false' then
3017: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
3018: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', c_displayed_flag);
3019: elsif c_displayed_flag = 'true' then
3020: if l_counter < 5 then
3021: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3022: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3017: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
3018: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', c_displayed_flag);
3019: elsif c_displayed_flag = 'true' then
3020: if l_counter < 5 then
3021: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3022: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3023: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3024: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3025: l_counter := l_counter + 1;
3018: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', c_displayed_flag);
3019: elsif c_displayed_flag = 'true' then
3020: if l_counter < 5 then
3021: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3022: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3023: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3024: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3025: l_counter := l_counter + 1;
3026: else
3019: elsif c_displayed_flag = 'true' then
3020: if l_counter < 5 then
3021: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3022: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3023: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3024: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3025: l_counter := l_counter + 1;
3026: else
3027: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3020: if l_counter < 5 then
3021: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3022: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3023: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3024: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3025: l_counter := l_counter + 1;
3026: else
3027: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3028: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3023: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3024: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3025: l_counter := l_counter + 1;
3026: else
3027: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3028: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3029: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3030: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3031: end if;
3024: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3025: l_counter := l_counter + 1;
3026: else
3027: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3028: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3029: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3030: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3031: end if;
3032: end if;
3025: l_counter := l_counter + 1;
3026: else
3027: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3028: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3029: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3030: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3031: end if;
3032: end if;
3033:
3026: else
3027: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3028: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3029: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3030: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3031: end if;
3032: end if;
3033:
3034: end loop;
3038: create_special_item_mult_vqr(g_qa_created_by_attribute, l_char_item, l_char_dtl_item);
3039: add_child_to_parent(l_top_region, l_char_item, 'contents');
3040: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3041: if l_counter < 5 then
3042: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3043: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3044: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3045: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3046: l_counter := l_counter + 1;
3039: add_child_to_parent(l_top_region, l_char_item, 'contents');
3040: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3041: if l_counter < 5 then
3042: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3043: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3044: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3045: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3046: l_counter := l_counter + 1;
3047: else
3040: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3041: if l_counter < 5 then
3042: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3043: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3044: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3045: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3046: l_counter := l_counter + 1;
3047: else
3048: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3041: if l_counter < 5 then
3042: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3043: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3044: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3045: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3046: l_counter := l_counter + 1;
3047: else
3048: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3049: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3044: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3045: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3046: l_counter := l_counter + 1;
3047: else
3048: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3049: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3050: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3051: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3052: end if;
3045: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3046: l_counter := l_counter + 1;
3047: else
3048: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3049: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3050: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3051: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3052: end if;
3053:
3046: l_counter := l_counter + 1;
3047: else
3048: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3049: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3050: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3051: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3052: end if;
3053:
3054:
3047: else
3048: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3049: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3050: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3051: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3052: end if;
3053:
3054:
3055:
3057: create_special_item_mult_vqr(g_collection_id_attribute, l_char_item, l_char_dtl_item);
3058: add_child_to_parent(l_top_region, l_char_item, 'contents');
3059: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3060: if l_counter < 5 then
3061: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3062: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3063: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3064: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3065: l_counter := l_counter + 1;
3058: add_child_to_parent(l_top_region, l_char_item, 'contents');
3059: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3060: if l_counter < 5 then
3061: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3062: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3063: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3064: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3065: l_counter := l_counter + 1;
3066: else
3059: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3060: if l_counter < 5 then
3061: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3062: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3063: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3064: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3065: l_counter := l_counter + 1;
3066: else
3067: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3060: if l_counter < 5 then
3061: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3062: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3063: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3064: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3065: l_counter := l_counter + 1;
3066: else
3067: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3068: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3063: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3064: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3065: l_counter := l_counter + 1;
3066: else
3067: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3068: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3069: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3070: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3071: end if;
3064: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3065: l_counter := l_counter + 1;
3066: else
3067: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3068: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3069: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3070: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3071: end if;
3072:
3065: l_counter := l_counter + 1;
3066: else
3067: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3068: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3069: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3070: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3071: end if;
3072:
3073:
3066: else
3067: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3068: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3069: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3070: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3071: end if;
3072:
3073:
3074:
3075: create_special_item_mult_vqr(g_last_update_date_attribute, l_char_item, l_char_dtl_item);
3076: add_child_to_parent(l_top_region, l_char_item, 'contents');
3077: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3078: if l_counter < 5 then
3079: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3080: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3081: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3082: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3083: l_counter := l_counter + 1;
3076: add_child_to_parent(l_top_region, l_char_item, 'contents');
3077: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3078: if l_counter < 5 then
3079: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3080: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3081: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3082: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3083: l_counter := l_counter + 1;
3084: else
3077: add_child_to_parent(l_data_region, l_char_dtl_item, 'contents');
3078: if l_counter < 5 then
3079: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3080: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3081: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3082: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3083: l_counter := l_counter + 1;
3084: else
3085: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3078: if l_counter < 5 then
3079: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'true');
3080: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'false');
3081: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3082: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3083: l_counter := l_counter + 1;
3084: else
3085: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3086: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3081: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3082: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3083: l_counter := l_counter + 1;
3084: else
3085: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3086: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3087: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3088: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3089: end if;
3082: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'false');
3083: l_counter := l_counter + 1;
3084: else
3085: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3086: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3087: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3088: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3089: end if;
3090:
3083: l_counter := l_counter + 1;
3084: else
3085: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3086: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3087: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3088: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3089: end if;
3090:
3091:
3084: else
3085: jdr_docbuilder.setAttribute(l_char_item, 'rendered', 'false');
3086: jdr_docbuilder.setAttribute(l_char_dtl_item, 'rendered', 'true');
3087: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'false');
3088: -- jdr_docbuilder.setAttribute(l_char_dtl_item, 'queryable', 'true');
3089: end if;
3090:
3091:
3092:
3101: end if;
3102: -- add to comment items to the region
3103: c_displayed_flag := create_item_for_mult_vqr(p_plan_id, rec.char_id, l_char_item, l_char_dtl_item);
3104: add_child_to_parent(l_comments_region, l_char_dtl_item, 'contents');
3105: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
3106: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', 'OraTableDetail');
3107:
3108: -- if c_displayed_flag = 'true' then
3109: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3102: -- add to comment items to the region
3103: c_displayed_flag := create_item_for_mult_vqr(p_plan_id, rec.char_id, l_char_item, l_char_dtl_item);
3104: add_child_to_parent(l_comments_region, l_char_dtl_item, 'contents');
3105: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
3106: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', 'OraTableDetail');
3107:
3108: -- if c_displayed_flag = 'true' then
3109: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3110: -- end if;
3105: jdr_docbuilder.setAttribute(l_char_item, 'rendered', c_displayed_flag);
3106: jdr_docbuilder.setAttribute(l_char_item, 'styleClass', 'OraTableDetail');
3107:
3108: -- if c_displayed_flag = 'true' then
3109: -- jdr_docbuilder.setAttribute(l_char_item, 'queryable', 'true');
3110: -- end if;
3111:
3112: end loop;
3113:
3119: -- now add the detail region to the main region
3120: add_child_to_parent(l_top_region, l_dtl_region, 'detail');
3121:
3122: -- save the document
3123: l_saved := JDR_DOCBUILDER.SAVE;
3124:
3125: EXCEPTION
3126:
3127: WHEN OTHERS THEN
3147: l_err_num NUMBER;
3148: l_err_msg VARCHAR2(100);
3149: l_char_count NUMBER := NULL;
3150:
3151: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
3152: l_table_region JDR_DOCBUILDER.ELEMENT := NULL;
3153: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
3154:
3155: --
3148: l_err_msg VARCHAR2(100);
3149: l_char_count NUMBER := NULL;
3150:
3151: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
3152: l_table_region JDR_DOCBUILDER.ELEMENT := NULL;
3153: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
3154:
3155: --
3156: -- 12.1 Device Integration Project
3149: l_char_count NUMBER := NULL;
3150:
3151: l_top_doc JDR_DOCBUILDER.DOCUMENT := NULL;
3152: l_table_region JDR_DOCBUILDER.ELEMENT := NULL;
3153: l_dtl_region JDR_DOCBUILDER.ELEMENT := NULL;
3154:
3155: --
3156: -- 12.1 Device Integration Project
3157: -- Variables for adding device region
3157: -- Variables for adding device region
3158: -- to the multi row layout.
3159: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
3160: --
3161: l_stk_region JDR_DOCBUILDER.ELEMENT := NULL;
3162: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
3163: l_stk_region_code varchar2(35) := NULL;
3164: l_device_region_code varchar2(35) := NULL;
3165: l_prompt VARCHAR2(30);
3158: -- to the multi row layout.
3159: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
3160: --
3161: l_stk_region JDR_DOCBUILDER.ELEMENT := NULL;
3162: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
3163: l_stk_region_code varchar2(35) := NULL;
3164: l_device_region_code varchar2(35) := NULL;
3165: l_prompt VARCHAR2(30);
3166: BEGIN
3231: add_table_selection(l_table_region);
3232: add_table_action(l_table_region);
3233:
3234: -- save the document
3235: l_saved := JDR_DOCBUILDER.SAVE;
3236:
3237: EXCEPTION
3238:
3239: WHEN OTHERS THEN
3269: l_err_num NUMBER;
3270: l_err_msg VARCHAR2(100);
3271: l_char_count NUMBER := NULL;
3272:
3273: l_top_doc jdr_docbuilder.DOCUMENT := NULL;
3274: l_table_region jdr_docbuilder.element := NULL;
3275: l_dtl_region jdr_docbuilder.element := NULL;
3276:
3277: l_tbl_act jdr_docbuilder.element := NULL;
3270: l_err_msg VARCHAR2(100);
3271: l_char_count NUMBER := NULL;
3272:
3273: l_top_doc jdr_docbuilder.DOCUMENT := NULL;
3274: l_table_region jdr_docbuilder.element := NULL;
3275: l_dtl_region jdr_docbuilder.element := NULL;
3276:
3277: l_tbl_act jdr_docbuilder.element := NULL;
3278: l_tbl_s_sel jdr_docbuilder.element := NULL;
3271: l_char_count NUMBER := NULL;
3272:
3273: l_top_doc jdr_docbuilder.DOCUMENT := NULL;
3274: l_table_region jdr_docbuilder.element := NULL;
3275: l_dtl_region jdr_docbuilder.element := NULL;
3276:
3277: l_tbl_act jdr_docbuilder.element := NULL;
3278: l_tbl_s_sel jdr_docbuilder.element := NULL;
3279: l_tbl_footer jdr_docbuilder.element := NULL;
3273: l_top_doc jdr_docbuilder.DOCUMENT := NULL;
3274: l_table_region jdr_docbuilder.element := NULL;
3275: l_dtl_region jdr_docbuilder.element := NULL;
3276:
3277: l_tbl_act jdr_docbuilder.element := NULL;
3278: l_tbl_s_sel jdr_docbuilder.element := NULL;
3279: l_tbl_footer jdr_docbuilder.element := NULL;
3280: l_api_name constant varchar2(50) := 'MAP_PLAN_ADV_TABLE_EQR';
3281:
3274: l_table_region jdr_docbuilder.element := NULL;
3275: l_dtl_region jdr_docbuilder.element := NULL;
3276:
3277: l_tbl_act jdr_docbuilder.element := NULL;
3278: l_tbl_s_sel jdr_docbuilder.element := NULL;
3279: l_tbl_footer jdr_docbuilder.element := NULL;
3280: l_api_name constant varchar2(50) := 'MAP_PLAN_ADV_TABLE_EQR';
3281:
3282: --
3275: l_dtl_region jdr_docbuilder.element := NULL;
3276:
3277: l_tbl_act jdr_docbuilder.element := NULL;
3278: l_tbl_s_sel jdr_docbuilder.element := NULL;
3279: l_tbl_footer jdr_docbuilder.element := NULL;
3280: l_api_name constant varchar2(50) := 'MAP_PLAN_ADV_TABLE_EQR';
3281:
3282: --
3283: -- 12.1 Device Integration Project
3284: -- Variables for adding device region
3285: -- to the multi row layout.
3286: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
3287: --
3288: l_stk_region JDR_DOCBUILDER.ELEMENT := NULL;
3289: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
3290: l_stk_region_code varchar2(35) := NULL;
3291: l_device_region_code varchar2(35) := NULL;
3292: l_prompt VARCHAR2(30);
3285: -- to the multi row layout.
3286: -- bhsankar Wed Oct 24 04:45:16 PDT 2007
3287: --
3288: l_stk_region JDR_DOCBUILDER.ELEMENT := NULL;
3289: l_device_region JDR_DOCBUILDER.ELEMENT := NULL;
3290: l_stk_region_code varchar2(35) := NULL;
3291: l_device_region_code varchar2(35) := NULL;
3292: l_prompt VARCHAR2(30);
3293:
3329: -- to the stack region (top document) already created.
3330: l_prompt := get_region_prompt('DATA');
3331:
3332: l_table_region := create_jrad_region (l_table_region_code, 'advancedTable', l_prompt, null);
3333: JDR_DOCBUILDER.setAttribute(l_table_region, 'viewName', g_vo_name);
3334: add_child_to_parent(l_stk_region, l_table_region, 'contents');
3335:
3336: -- 12.1 Device Integration Project End.
3337:
3362: add_table_action(l_table_region);
3363: add_table_footer(l_table_region);
3364:
3365: -- save the document
3366: l_saved := jdr_docbuilder.save;
3367: log_error(g_pkg_name || l_api_name, 'Saved Document. Function END');
3368:
3369: EXCEPTION
3370:
3557: --
3558:
3559: IF l_jrad_upgrade_ver IS NULL OR
3560: l_jrad_upgrade_ver < l_seed_ver OR
3561: NOT jdr_docbuilder.documentExists(l_eqr_single_doc) OR
3562: NOT jdr_docbuilder.documentExists(l_vqr_single_doc) OR
3563: NOT jdr_docbuilder.documentExists(l_vqr_multiple_doc) OR
3564: NOT jdr_docbuilder.documentExists(l_eqr_multiple_doc) THEN
3565: -- map plan. documents do not exist,
3558:
3559: IF l_jrad_upgrade_ver IS NULL OR
3560: l_jrad_upgrade_ver < l_seed_ver OR
3561: NOT jdr_docbuilder.documentExists(l_eqr_single_doc) OR
3562: NOT jdr_docbuilder.documentExists(l_vqr_single_doc) OR
3563: NOT jdr_docbuilder.documentExists(l_vqr_multiple_doc) OR
3564: NOT jdr_docbuilder.documentExists(l_eqr_multiple_doc) THEN
3565: -- map plan. documents do not exist,
3566: -- or of lower version than wanted.
3559: IF l_jrad_upgrade_ver IS NULL OR
3560: l_jrad_upgrade_ver < l_seed_ver OR
3561: NOT jdr_docbuilder.documentExists(l_eqr_single_doc) OR
3562: NOT jdr_docbuilder.documentExists(l_vqr_single_doc) OR
3563: NOT jdr_docbuilder.documentExists(l_vqr_multiple_doc) OR
3564: NOT jdr_docbuilder.documentExists(l_eqr_multiple_doc) THEN
3565: -- map plan. documents do not exist,
3566: -- or of lower version than wanted.
3567: map_plan(p_plan_id);
3560: l_jrad_upgrade_ver < l_seed_ver OR
3561: NOT jdr_docbuilder.documentExists(l_eqr_single_doc) OR
3562: NOT jdr_docbuilder.documentExists(l_vqr_single_doc) OR
3563: NOT jdr_docbuilder.documentExists(l_vqr_multiple_doc) OR
3564: NOT jdr_docbuilder.documentExists(l_eqr_multiple_doc) THEN
3565: -- map plan. documents do not exist,
3566: -- or of lower version than wanted.
3567: map_plan(p_plan_id);
3568: