eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_JRAD_PKG dependencies on JDR_DOCBUILDER

Line 802: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS

798:
799:
800: FUNCTION create_jrad_region (
801: p_region_code IN VARCHAR2,
802: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
803:
804: l_region_style VARCHAR2(30);
805: l_row_id VARCHAR2(30);
806: l_plan_name qa_plans.name%TYPE;

Line 807: topLevel JDR_DOCBUILDER.ELEMENT := NULL;

803:
804: l_region_style VARCHAR2(30);
805: l_row_id VARCHAR2(30);
806: l_plan_name qa_plans.name%TYPE;
807: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
808:
809: l_prompt VARCHAR2(30);
810:
811: CURSOR c IS

Line 826: topLevel := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, l_region_style);

822: CLOSE c;
823:
824:
825: l_region_style := get_region_style(p_region_code);
826: topLevel := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, l_region_style);
827:
828: -- rkaza. 02/26/2004. bug 3461988.
829: -- Prompt of the EQR region should be Data for EAM EQR page.
830: -- EAM vqr table regions should have a width 100%

Line 840: jdr_docbuilder.setAttribute(topLevel, 'text', l_prompt);

836: OR (instr(p_region_code, g_checkout_eqr_prefix) <> 0)
837: --dgupta: End R12 EAM Integration. Bug 4345492
838: OR (instr(p_region_code, g_txn_op_prefix) <> 0) then
839: l_prompt := fnd_message.get_string('QA', 'QA_SS_RN_PROMPT_DATA');
840: jdr_docbuilder.setAttribute(topLevel, 'text', l_prompt);
841: END IF;
842:
843: IF (instr(p_region_code, g_work_vqr_prefix) <> 0)
844: OR (instr(p_region_code, g_asset_vqr_prefix) <> 0)

Line 850: jdr_docbuilder.setAttribute(topLevel, 'width', '100%');

846: OR (instr(p_region_code, g_checkin_vqr_prefix) <> 0)
847: OR (instr(p_region_code, g_checkout_vqr_prefix) <> 0)
848: --dgupta: End R12 EAM Integration. Bug 4345492
849: OR (instr(p_region_code, g_op_vqr_prefix) <> 0) then
850: jdr_docbuilder.setAttribute(topLevel, 'width', '100%');
851: END IF;
852:
853: jdr_docbuilder.setAttribute(topLevel, 'prompt', l_plan_name);
854: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);

Line 853: jdr_docbuilder.setAttribute(topLevel, 'prompt', l_plan_name);

849: OR (instr(p_region_code, g_op_vqr_prefix) <> 0) then
850: jdr_docbuilder.setAttribute(topLevel, 'width', '100%');
851: END IF;
852:
853: jdr_docbuilder.setAttribute(topLevel, 'prompt', l_plan_name);
854: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);
855: jdr_docbuilder.setAttribute(topLevel, 'id', p_region_code);
856:
857: IF (instr(p_region_code, g_pc_vqr_sin_prefix) <> 0) THEN

Line 854: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);

850: jdr_docbuilder.setAttribute(topLevel, 'width', '100%');
851: END IF;
852:
853: jdr_docbuilder.setAttribute(topLevel, 'prompt', l_plan_name);
854: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);
855: jdr_docbuilder.setAttribute(topLevel, 'id', p_region_code);
856:
857: IF (instr(p_region_code, g_pc_vqr_sin_prefix) <> 0) THEN
858: jdr_docbuilder.setAttribute(topLevel, 'headerDisabled', 'true');

Line 855: jdr_docbuilder.setAttribute(topLevel, 'id', p_region_code);

851: END IF;
852:
853: jdr_docbuilder.setAttribute(topLevel, 'prompt', l_plan_name);
854: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);
855: jdr_docbuilder.setAttribute(topLevel, 'id', p_region_code);
856:
857: IF (instr(p_region_code, g_pc_vqr_sin_prefix) <> 0) THEN
858: jdr_docbuilder.setAttribute(topLevel, 'headerDisabled', 'true');
859: ELSIF (instr(p_region_code, g_pc_vqr_prefix) <> 0) THEN

Line 858: jdr_docbuilder.setAttribute(topLevel, 'headerDisabled', 'true');

854: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);
855: jdr_docbuilder.setAttribute(topLevel, 'id', p_region_code);
856:
857: IF (instr(p_region_code, g_pc_vqr_sin_prefix) <> 0) THEN
858: jdr_docbuilder.setAttribute(topLevel, 'headerDisabled', 'true');
859: ELSIF (instr(p_region_code, g_pc_vqr_prefix) <> 0) THEN
860: --ilawler - bug #3462025 - Mon Feb 23 17:19:07 2004
861: --Set width of table to be 90%
862: jdr_docbuilder.setAttribute(topLevel, 'width', '90%');

Line 862: jdr_docbuilder.setAttribute(topLevel, 'width', '90%');

858: jdr_docbuilder.setAttribute(topLevel, 'headerDisabled', 'true');
859: ELSIF (instr(p_region_code, g_pc_vqr_prefix) <> 0) THEN
860: --ilawler - bug #3462025 - Mon Feb 23 17:19:07 2004
861: --Set width of table to be 90%
862: jdr_docbuilder.setAttribute(topLevel, 'width', '90%');
863: END IF;
864:
865: -- Tracking Bug : 3209719
866: -- Added for OAC complicance

Line 869: jdr_docbuilder.setAttribute(topLevel, 'shortDesc', fnd_message.get_string('QA','QA_OAC_RESULTS_TABLE'));

865: -- Tracking Bug : 3209719
866: -- Added for OAC complicance
867: -- ilawler Tue Oct 21 15:24:26 2003
868: IF l_region_style = 'table' THEN
869: jdr_docbuilder.setAttribute(topLevel, 'shortDesc', fnd_message.get_string('QA','QA_OAC_RESULTS_TABLE'));
870: ELSIF l_region_style = 'labeledFieldLayout' THEN
871: --ilawler - bug #3462025 - Mon Feb 23 17:42:47 2004
872: --when using the labeledFieldLayout, suggest 2 columns
873: jdr_docbuilder.setAttribute(topLevel, 'columns', '2');

Line 873: jdr_docbuilder.setAttribute(topLevel, 'columns', '2');

869: jdr_docbuilder.setAttribute(topLevel, 'shortDesc', fnd_message.get_string('QA','QA_OAC_RESULTS_TABLE'));
870: ELSIF l_region_style = 'labeledFieldLayout' THEN
871: --ilawler - bug #3462025 - Mon Feb 23 17:42:47 2004
872: --when using the labeledFieldLayout, suggest 2 columns
873: jdr_docbuilder.setAttribute(topLevel, 'columns', '2');
874: END IF;
875:
876: RETURN topLevel;
877:

Line 908: p_input_elem IN jdr_docbuilder.Element) IS

904: PROCEDURE add_lov_relations (
905: p_plan_id IN NUMBER,
906: p_char_id IN NUMBER,
907: p_attribute_code IN VARCHAR2,
908: p_input_elem IN jdr_docbuilder.Element) IS
909:
910:
911: err_num NUMBER;
912: err_msg VARCHAR2(100);

Line 921: lovMap jdr_docbuilder.ELEMENT;

917: l_lov_attribute_code VARCHAR2(30);
918: l_base_attribute_code VARCHAR2(30);
919: l_parents ParentArray;
920:
921: lovMap jdr_docbuilder.ELEMENT;
922:
923:
924: BEGIN
925:

Line 930: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

926: -- This function adds lov relations for a region item.
927: -- Here the region item corresponds to a collection plan element.
928:
929: --Criteria
930: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
931: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
932: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
933: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
934: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

Line 931: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);

927: -- Here the region item corresponds to a collection plan element.
928:
929: --Criteria
930: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
931: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
932: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
933: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
934: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
935: lovMap);

Line 932: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);

928:
929: --Criteria
930: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
931: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
932: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
933: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
934: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
935: lovMap);
936: --Result

Line 933: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');

929: --Criteria
930: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
931: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
932: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
933: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
934: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
935: lovMap);
936: --Result
937: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

Line 934: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

930: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
931: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
932: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
933: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
934: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
935: lovMap);
936: --Result
937: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
938: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);

Line 937: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

933: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
934: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
935: lovMap);
936: --Result
937: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
938: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
939: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
940: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
941: lovMap);

Line 938: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);

934: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
935: lovMap);
936: --Result
937: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
938: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
939: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
940: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
941: lovMap);
942: --Org Id

Line 939: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);

935: lovMap);
936: --Result
937: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
938: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
939: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
940: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
941: lovMap);
942: --Org Id
943: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

Line 940: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

936: --Result
937: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
938: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
939: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
940: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
941: lovMap);
942: --Org Id
943: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
944: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);

Line 943: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

939: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
940: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
941: lovMap);
942: --Org Id
943: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
944: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
945: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
946: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
947: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

Line 944: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);

940: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
941: lovMap);
942: --Org Id
943: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
944: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
945: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
946: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
947: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
948: lovMap);

Line 945: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);

941: lovMap);
942: --Org Id
943: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
944: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
945: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
946: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
947: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
948: lovMap);
949: --Plan Id

Line 946: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');

942: --Org Id
943: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
944: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
945: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
946: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
947: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
948: lovMap);
949: --Plan Id
950: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

Line 947: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

943: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
944: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
945: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
946: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
947: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
948: lovMap);
949: --Plan Id
950: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
951: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);

Line 950: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

946: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
947: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
948: lovMap);
949: --Plan Id
950: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
951: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
952: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
953: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
954: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

Line 951: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);

947: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
948: lovMap);
949: --Plan Id
950: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
951: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
952: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
953: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
954: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
955: lovMap);

Line 952: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);

948: lovMap);
949: --Plan Id
950: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
951: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
952: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
953: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
954: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
955: lovMap);
956:

Line 953: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');

949: --Plan Id
950: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
951: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
952: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
953: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
954: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
955: lovMap);
956:
957:

Line 954: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

950: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
951: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
952: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
953: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
954: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
955: lovMap);
956:
957:
958: get_dependencies(p_char_id, l_parents);

Line 984: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS,

980: --
981:
982: l_base_attribute_code := cons_base_attribute_code(g_element_prefix, l_parents(i));
983:
984: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS,
985: 'lovMap');
986: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
987: l_base_attribute_code);
988: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);

Line 986: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',

982: l_base_attribute_code := cons_base_attribute_code(g_element_prefix, l_parents(i));
983:
984: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS,
985: 'lovMap');
986: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
987: l_base_attribute_code);
988: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
989: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
990: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

Line 988: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);

984: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS,
985: 'lovMap');
986: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
987: l_base_attribute_code);
988: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
989: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
990: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
991: lovMap);
992: END IF;

Line 989: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');

985: 'lovMap');
986: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
987: l_base_attribute_code);
988: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
989: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
990: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
991: lovMap);
992: END IF;
993:

Line 990: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

986: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
987: l_base_attribute_code);
988: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
989: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
990: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
991: lovMap);
992: END IF;
993:
994: END LOOP;

Line 1017: RETURN jdr_docbuilder.ELEMENT IS

1013:
1014: FUNCTION create_id_item_for_eqr (
1015: p_plan_id IN NUMBER,
1016: p_char_id IN NUMBER)
1017: RETURN jdr_docbuilder.ELEMENT IS
1018:
1019: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
1020: l_id_elem jdr_docbuilder.ELEMENT := NULL;
1021:

Line 1020: l_id_elem jdr_docbuilder.ELEMENT := NULL;

1016: p_char_id IN NUMBER)
1017: RETURN jdr_docbuilder.ELEMENT IS
1018:
1019: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
1020: l_id_elem jdr_docbuilder.ELEMENT := NULL;
1021:
1022: BEGIN
1023:
1024: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);

Line 1025: l_id_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'formValue');

1021:
1022: BEGIN
1023:
1024: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
1025: l_id_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'formValue');
1026:
1027: -- set properties
1028: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1029: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);

Line 1028: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);

1024: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
1025: l_id_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'formValue');
1026:
1027: -- set properties
1028: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1029: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);
1030: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
1031: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
1032:

Line 1029: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);

1025: l_id_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'formValue');
1026:
1027: -- set properties
1028: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1029: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);
1030: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
1031: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
1032:
1033: return l_id_elem;

Line 1030: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);

1026:
1027: -- set properties
1028: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1029: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);
1030: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
1031: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
1032:
1033: return l_id_elem;
1034:

Line 1031: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');

1027: -- set properties
1028: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1029: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);
1030: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
1031: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
1032:
1033: return l_id_elem;
1034:
1035: END create_id_item_for_eqr;

Line 1091: p_char_item IN jdr_docbuilder.Element) IS

1087: PROCEDURE process_normalized_lov (
1088: p_plan_id IN NUMBER,
1089: p_char_id IN NUMBER,
1090: p_attribute_code IN VARCHAR2,
1091: p_char_item IN jdr_docbuilder.Element) IS
1092:
1093: lovMap jdr_docbuilder.ELEMENT;
1094: l_lov_region VARCHAR2(100);
1095:

Line 1093: lovMap jdr_docbuilder.ELEMENT;

1089: p_char_id IN NUMBER,
1090: p_attribute_code IN VARCHAR2,
1091: p_char_item IN jdr_docbuilder.Element) IS
1092:
1093: lovMap jdr_docbuilder.ELEMENT;
1094: l_lov_region VARCHAR2(100);
1095:
1096: BEGIN
1097:

Line 1100: jdr_docbuilder.setAttribute(p_char_item,

1096: BEGIN
1097:
1098: IF(p_char_id = qa_ss_const.po_number) THEN
1099: l_lov_region := qa_ssqr_jrad_pkg.g_jrad_lov_dir_path || get_lov_region_name(p_plan_id,p_char_id);
1100: jdr_docbuilder.setAttribute(p_char_item,
1101: 'externalListOfValues',
1102: l_lov_region);
1103: --Criteria
1104: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

Line 1104: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

1100: jdr_docbuilder.setAttribute(p_char_item,
1101: 'externalListOfValues',
1102: l_lov_region);
1103: --Criteria
1104: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1105: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1106: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1107: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1108: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');

Line 1105: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);

1101: 'externalListOfValues',
1102: l_lov_region);
1103: --Criteria
1104: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1105: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1106: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1107: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1108: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1109: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',

Line 1106: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);

1102: l_lov_region);
1103: --Criteria
1104: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1105: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1106: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1107: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1108: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1109: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1110: lovMap);

Line 1107: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');

1103: --Criteria
1104: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1105: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1106: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1107: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1108: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1109: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1110: lovMap);
1111: -- po_header_id

Line 1108: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');

1104: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1105: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1106: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1107: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1108: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1109: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1110: lovMap);
1111: -- po_header_id
1112: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

Line 1109: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',

1105: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1106: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1107: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1108: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1109: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1110: lovMap);
1111: -- po_header_id
1112: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1113: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');

Line 1112: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

1108: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1109: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1110: lovMap);
1111: -- po_header_id
1112: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1113: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1114: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1115: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1116: lovMap);

Line 1113: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');

1109: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1110: lovMap);
1111: -- po_header_id
1112: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1113: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1114: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1115: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1116: lovMap);
1117:

Line 1114: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));

1110: lovMap);
1111: -- po_header_id
1112: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1113: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1114: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1115: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1116: lovMap);
1117:
1118: END IF; -- PO Number

Line 1115: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',

1111: -- po_header_id
1112: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1113: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1114: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1115: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1116: lovMap);
1117:
1118: END IF; -- PO Number
1119:

Line 1132: p_char_item IN jdr_docbuilder.Element) IS

1128: PROCEDURE process_regular_lov (
1129: p_plan_id IN NUMBER,
1130: p_char_id IN NUMBER,
1131: p_attribute_code IN VARCHAR2,
1132: p_char_item IN jdr_docbuilder.Element) IS
1133:
1134: BEGIN
1135:
1136: jdr_docbuilder.setAttribute(p_char_item, 'externalListOfValues',

Line 1136: jdr_docbuilder.setAttribute(p_char_item, 'externalListOfValues',

1132: p_char_item IN jdr_docbuilder.Element) IS
1133:
1134: BEGIN
1135:
1136: jdr_docbuilder.setAttribute(p_char_item, 'externalListOfValues',
1137: g_jrad_lov_path);
1138:
1139: add_lov_relations(p_plan_id, p_char_id, p_attribute_code, p_char_item);
1140:

Line 1153: p_char_item IN jdr_docbuilder.Element) IS

1149: PROCEDURE process_messageLovInput (
1150: p_plan_id IN NUMBER,
1151: p_char_id IN NUMBER,
1152: p_attribute_code IN VARCHAR2,
1153: p_char_item IN jdr_docbuilder.Element) IS
1154:
1155:
1156:
1157: BEGIN

Line 1203: p_prefix IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS

1199:
1200: FUNCTION create_region_item_for_eqr (
1201: p_char_id IN NUMBER,
1202: p_plan_id IN NUMBER,
1203: p_prefix IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
1204:
1205: -- Bug 3769260. shkalyan 29 July 2004.
1206: -- Removed these attributes since the cursor to get from qa_plan_chars
1207: -- and qa_chars are removed.

Line 1231: child1 jdr_docbuilder.ELEMENT;

1227: -- bhsankar Tue Oct 16 23:21:38 PDT 2007
1228: -- l_prompt qa_plan_chars.prompt%TYPE;
1229: l_prompt VARCHAR2(100);
1230:
1231: child1 jdr_docbuilder.ELEMENT;
1232:
1233: -- Tracking Bug : 3104827
1234: -- Added for Read Only Flag for Collection Plan Enhancement
1235: -- saugupta Thu Aug 28 08:58:53 PDT 2003

Line 1301: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);

1297: -- defined at the element level only and this is not desired.
1298: -- l_prompt := qa_chars_api.prompt( p_char_id );
1299: l_prompt := get_prompt(p_plan_id, p_char_id);
1300:
1301: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1302: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1303: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1304: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);

Line 1302: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);

1298: -- l_prompt := qa_chars_api.prompt( p_char_id );
1299: l_prompt := get_prompt(p_plan_id, p_char_id);
1300:
1301: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1302: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1303: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1304: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1306: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);

Line 1303: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);

1299: l_prompt := get_prompt(p_plan_id, p_char_id);
1300:
1301: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1302: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1303: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1304: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1306: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1307: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);

Line 1304: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);

1300:
1301: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1302: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1303: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1304: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1306: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1307: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1308: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);

Line 1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);

1301: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1302: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1303: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1304: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1306: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1307: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1308: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1309: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);

Line 1306: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);

1302: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1303: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1304: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1306: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1307: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1308: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1309: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);
1310:

Line 1307: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);

1303: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1304: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1306: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1307: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1308: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1309: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);
1310:
1311: -- Tracking Bug : 3104827

Line 1308: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);

1304: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1306: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1307: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1308: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1309: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);
1310:
1311: -- Tracking Bug : 3104827
1312: -- Added for Read Only Flag Collection Plan Enhancement

Line 1309: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);

1305: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1306: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1307: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1308: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1309: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);
1310:
1311: -- Tracking Bug : 3104827
1312: -- Added for Read Only Flag Collection Plan Enhancement
1313: -- saugupta Thu Aug 28 08:59:59 PDT 2003

Line 1315: jdr_docbuilder.setAttribute(child1, 'readOnly', l_readonly_flag);

1311: -- Tracking Bug : 3104827
1312: -- Added for Read Only Flag Collection Plan Enhancement
1313: -- saugupta Thu Aug 28 08:59:59 PDT 2003
1314:
1315: jdr_docbuilder.setAttribute(child1, 'readOnly', l_readonly_flag);
1316:
1317: -- At this point, if the element has lovs then we must determine
1318: -- what are its dependency and populate lov_relations
1319: -- with this information.

Line 1353: RETURN JDR_DOCBUILDER.ELEMENT IS

1349: p_attribute_code IN VARCHAR2,
1350: p_plan_id IN VARCHAR2,
1351: p_prefix IN VARCHAR2,
1352: p_char_id IN NUMBER)
1353: RETURN JDR_DOCBUILDER.ELEMENT IS
1354:
1355: l_row_id VARCHAR2(30);
1356: l_element_id NUMBER;
1357: l_region_code VARCHAR2(30);

Line 1374: child1 jdr_docbuilder.ELEMENT;

1370: -- l_label_long VARCHAR2(30) DEFAULT NULL;
1371: l_label_long VARCHAR2(100) DEFAULT NULL;
1372: l_data_type VARCHAR2(30);
1373:
1374: child1 jdr_docbuilder.ELEMENT;
1375:
1376: err_num NUMBER;
1377: err_msg VARCHAR2(100);
1378:

Line 1428: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);

1424: OR (instr(l_region_code, g_op_vqr_prefix) <> 0) THEN
1425: l_query_flag := 'true';
1426: END IF;
1427:
1428: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1429: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1430: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1431: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1432: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);

Line 1429: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);

1425: l_query_flag := 'true';
1426: END IF;
1427:
1428: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1429: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1430: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1431: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1432: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1433: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);

Line 1430: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');

1426: END IF;
1427:
1428: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1429: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1430: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1431: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1432: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1433: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1434: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);

Line 1431: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);

1427:
1428: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1429: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1430: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1431: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1432: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1433: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1434: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1435: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);

Line 1432: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);

1428: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1429: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1430: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1431: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1432: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1433: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1434: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1435: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);
1436:

Line 1433: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);

1429: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1430: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1431: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1432: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1433: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1434: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1435: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);
1436:
1437: --ilawler - bug #3462025 - Mon Feb 23 17:48:09 2004

Line 1434: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);

1430: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1431: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1432: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1433: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1434: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1435: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);
1436:
1437: --ilawler - bug #3462025 - Mon Feb 23 17:48:09 2004
1438: --set the right CSS Class for data elements

Line 1435: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);

1431: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1432: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1433: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1434: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1435: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);
1436:
1437: --ilawler - bug #3462025 - Mon Feb 23 17:48:09 2004
1438: --set the right CSS Class for data elements
1439: IF (instr(l_region_code, g_pc_vqr_sin_prefix) <> 0) THEN

Line 1440: jdr_docbuilder.setAttribute(child1, 'styleClass', 'OraDataText');

1436:
1437: --ilawler - bug #3462025 - Mon Feb 23 17:48:09 2004
1438: --set the right CSS Class for data elements
1439: IF (instr(l_region_code, g_pc_vqr_sin_prefix) <> 0) THEN
1440: jdr_docbuilder.setAttribute(child1, 'styleClass', 'OraDataText');
1441: END IF;
1442:
1443: IF l_query_flag IS NOT NULL THEN
1444: --dbms_output.put_line('found a queryable');

Line 1445: jdr_docbuilder.setAttribute(child1, 'queryable', l_query_flag);

1441: END IF;
1442:
1443: IF l_query_flag IS NOT NULL THEN
1444: --dbms_output.put_line('found a queryable');
1445: jdr_docbuilder.setAttribute(child1, 'queryable', l_query_flag);
1446: END IF;
1447: RETURN child1;
1448:
1449: -- dbms_output.put_line('Adding Item (S) : ' || l_region_code || ' ' ||

Line 1468: RETURN jdr_docbuilder.ELEMENT IS

1464: p_attribute_code IN VARCHAR2,
1465: p_plan_id IN VARCHAR2,
1466: p_prefix IN VARCHAR2,
1467: p_region_code IN VARCHAR2)
1468: RETURN jdr_docbuilder.ELEMENT IS
1469:
1470: l_row_id VARCHAR2(30);
1471: l_element_id NUMBER;
1472: l_region_code VARCHAR2(30);

Line 1488: special_elem jdr_docbuilder.ELEMENT := NULL;

1484: l_description VARCHAR2(240) DEFAULT NULL;
1485: --l_query_flag VARCHAR2(1) DEFAULT 'N';
1486: l_data_type VARCHAR2(30);
1487:
1488: special_elem jdr_docbuilder.ELEMENT := NULL;
1489: l_entityMap jdr_docbuilder.ELEMENT := NULL;
1490:
1491: err_num NUMBER;
1492: err_msg VARCHAR2(100);

Line 1489: l_entityMap jdr_docbuilder.ELEMENT := NULL;

1485: --l_query_flag VARCHAR2(1) DEFAULT 'N';
1486: l_data_type VARCHAR2(30);
1487:
1488: special_elem jdr_docbuilder.ELEMENT := NULL;
1489: l_entityMap jdr_docbuilder.ELEMENT := NULL;
1490:
1491: err_num NUMBER;
1492: err_msg VARCHAR2(100);
1493:

Line 1629: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,

1625: -- Assign a datatype of DATETIME to last_update_date.
1626: l_data_type := convert_data_type(qa_ss_const.datetime_datatype);
1627: END IF;
1628:
1629: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1630: l_item_style);
1631: jdr_docbuilder.setAttribute(special_elem, 'id', p_attribute_code);
1632:
1633: if (l_view_usage_name is not null) then

Line 1631: jdr_docbuilder.setAttribute(special_elem, 'id', p_attribute_code);

1627: END IF;
1628:
1629: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1630: l_item_style);
1631: jdr_docbuilder.setAttribute(special_elem, 'id', p_attribute_code);
1632:
1633: if (l_view_usage_name is not null) then
1634: jdr_docbuilder.setAttribute(special_elem, 'viewName',
1635: l_view_usage_name);

Line 1634: jdr_docbuilder.setAttribute(special_elem, 'viewName',

1630: l_item_style);
1631: jdr_docbuilder.setAttribute(special_elem, 'id', p_attribute_code);
1632:
1633: if (l_view_usage_name is not null) then
1634: jdr_docbuilder.setAttribute(special_elem, 'viewName',
1635: l_view_usage_name);
1636: end if;
1637: if (l_view_attribute_name is not null) then
1638: jdr_docbuilder.setAttribute(special_elem, 'viewAttr',

Line 1638: jdr_docbuilder.setAttribute(special_elem, 'viewAttr',

1634: jdr_docbuilder.setAttribute(special_elem, 'viewName',
1635: l_view_usage_name);
1636: end if;
1637: if (l_view_attribute_name is not null) then
1638: jdr_docbuilder.setAttribute(special_elem, 'viewAttr',
1639: l_view_attribute_name);
1640: end if;
1641: if (l_label_long is not null) then
1642: jdr_docbuilder.setAttribute(special_elem, 'prompt',

Line 1642: jdr_docbuilder.setAttribute(special_elem, 'prompt',

1638: jdr_docbuilder.setAttribute(special_elem, 'viewAttr',
1639: l_view_attribute_name);
1640: end if;
1641: if (l_label_long is not null) then
1642: jdr_docbuilder.setAttribute(special_elem, 'prompt',
1643: l_label_long);
1644: end if;
1645: if (l_description is not null) then
1646: jdr_docbuilder.setAttribute(special_elem, 'shortDesc',

Line 1646: jdr_docbuilder.setAttribute(special_elem, 'shortDesc',

1642: jdr_docbuilder.setAttribute(special_elem, 'prompt',
1643: l_label_long);
1644: end if;
1645: if (l_description is not null) then
1646: jdr_docbuilder.setAttribute(special_elem, 'shortDesc',
1647: l_description);
1648: end if;
1649: if (l_image_file_name is not null) then
1650: jdr_docbuilder.setAttribute(special_elem, 'source',

Line 1650: jdr_docbuilder.setAttribute(special_elem, 'source',

1646: jdr_docbuilder.setAttribute(special_elem, 'shortDesc',
1647: l_description);
1648: end if;
1649: if (l_image_file_name is not null) then
1650: jdr_docbuilder.setAttribute(special_elem, 'source',
1651: l_image_file_name);
1652: end if;
1653: if (l_url is not null) then
1654: jdr_docbuilder.setAttribute(special_elem, 'destination',

Line 1654: jdr_docbuilder.setAttribute(special_elem, 'destination',

1650: jdr_docbuilder.setAttribute(special_elem, 'source',
1651: l_image_file_name);
1652: end if;
1653: if (l_url is not null) then
1654: jdr_docbuilder.setAttribute(special_elem, 'destination',
1655: replace(l_url, '&', '&'));
1656: end if;
1657: if (l_data_type is not null) then
1658: jdr_docbuilder.setAttribute(special_elem, 'dataType', l_data_type);

Line 1658: jdr_docbuilder.setAttribute(special_elem, 'dataType', l_data_type);

1654: jdr_docbuilder.setAttribute(special_elem, 'destination',
1655: replace(l_url, '&', '&'));
1656: end if;
1657: if (l_data_type is not null) then
1658: jdr_docbuilder.setAttribute(special_elem, 'dataType', l_data_type);
1659: end if;
1660: if (l_entity_id is not null) then
1661: --special handling for attachments
1662: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,

Line 1662: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,

1658: jdr_docbuilder.setAttribute(special_elem, 'dataType', l_data_type);
1659: end if;
1660: if (l_entity_id is not null) then
1661: --special handling for attachments
1662: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1663: 'entityMap');
1664: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1665:
1666: --ilawler - bug #3436725 - Thu Feb 12 14:39:38 2004

Line 1664: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);

1660: if (l_entity_id is not null) then
1661: --special handling for attachments
1662: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1663: 'entityMap');
1664: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1665:
1666: --ilawler - bug #3436725 - Thu Feb 12 14:39:38 2004
1667: --In VQR, set the attachment to be non-updateable/deletable/insertable
1668: IF (l_restrict_attachment = 'Y') THEN

Line 1669: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');

1665:
1666: --ilawler - bug #3436725 - Thu Feb 12 14:39:38 2004
1667: --In VQR, set the attachment to be non-updateable/deletable/insertable
1668: IF (l_restrict_attachment = 'Y') THEN
1669: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');
1670: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
1671: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
1672: END IF;
1673:

Line 1670: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');

1666: --ilawler - bug #3436725 - Thu Feb 12 14:39:38 2004
1667: --In VQR, set the attachment to be non-updateable/deletable/insertable
1668: IF (l_restrict_attachment = 'Y') THEN
1669: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');
1670: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
1671: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
1672: END IF;
1673:
1674: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,

Line 1671: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');

1667: --In VQR, set the attachment to be non-updateable/deletable/insertable
1668: IF (l_restrict_attachment = 'Y') THEN
1669: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');
1670: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
1671: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
1672: END IF;
1673:
1674: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,
1675: 'entityMappings', l_entityMap);

Line 1674: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,

1670: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
1671: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
1672: END IF;
1673:
1674: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,
1675: 'entityMappings', l_entityMap);
1676: end if;--entity id not null
1677:
1678: return special_elem;

Line 1705: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;

1701:
1702: err_num NUMBER;
1703: err_msg VARCHAR2(100);
1704:
1705: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1706: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1707: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1708: -- MOAC
1709: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;

Line 1706: topLevel JDR_DOCBUILDER.ELEMENT := NULL;

1702: err_num NUMBER;
1703: err_msg VARCHAR2(100);
1704:
1705: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1706: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1707: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1708: -- MOAC
1709: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1710:

Line 1707: child1 JDR_DOCBUILDER.ELEMENT := NULL;

1703: err_msg VARCHAR2(100);
1704:
1705: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1706: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1707: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1708: -- MOAC
1709: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1710:
1711: CURSOR c IS

Line 1709: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;

1705: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1706: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1707: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1708: -- MOAC
1709: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1710:
1711: CURSOR c IS
1712: SELECT char_id
1713: FROM qa_plan_chars

Line 1724: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');

1720:
1721: l_region_code := construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver);
1722:
1723: --dbms_output.put_line('Entered EQR, path: "'||g_jrad_region_path||l_region_code||'", p_jrad_doc_ver: '||p_jrad_doc_ver);
1724: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');
1725:
1726: topLevel := create_jrad_region (l_region_code, p_plan_id);
1727: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);
1728:

Line 1727: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);

1723: --dbms_output.put_line('Entered EQR, path: "'||g_jrad_region_path||l_region_code||'", p_jrad_doc_ver: '||p_jrad_doc_ver);
1724: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');
1725:
1726: topLevel := create_jrad_region (l_region_code, p_plan_id);
1727: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);
1728:
1729: OPEN c;
1730: LOOP
1731: FETCH c INTO l_element_id;

Line 1742: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1738: IF (NOT action_target_element(p_plan_id, l_element_id)) THEN
1739:
1740: child1 := create_region_item_for_eqr(
1741: l_element_id, p_plan_id, p_prefix);
1742: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1743: 'contents', child1);
1744: --contents is the grouping name
1745:
1746: -- For MOAC : add normalized column.

Line 1749: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,'contents',l_id_item);

1745:
1746: -- For MOAC : add normalized column.
1747: IF l_element_id = qa_ss_const.po_number THEN
1748: l_id_item := create_id_item_for_eqr(p_plan_id,l_element_id);
1749: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,'contents',l_id_item);
1750: END IF;
1751:
1752:
1753: END IF;

Line 1764: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1760: p_plan_id => p_plan_id,
1761: p_prefix => p_prefix,
1762: p_region_code => l_region_code);
1763:
1764: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1765: 'contents', child1);
1766:
1767: child1 := add_special_region_item (
1768: p_attribute_code => g_org_code_attribute,

Line 1772: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1768: p_attribute_code => g_org_code_attribute,
1769: p_plan_id => p_plan_id,
1770: p_prefix => p_prefix,
1771: p_region_code => l_region_code);
1772: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1773: 'contents', child1);
1774:
1775: child1 := add_special_region_item (
1776: p_attribute_code => g_plan_id_attribute,

Line 1780: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1776: p_attribute_code => g_plan_id_attribute,
1777: p_plan_id => p_plan_id,
1778: p_prefix => p_prefix,
1779: p_region_code => l_region_code);
1780: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1781: 'contents', child1);
1782:
1783: child1 := add_special_region_item (
1784: p_attribute_code => g_plan_name_attribute,

Line 1788: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1784: p_attribute_code => g_plan_name_attribute,
1785: p_plan_id => p_plan_id,
1786: p_prefix => p_prefix,
1787: p_region_code => l_region_code);
1788: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1789: 'contents', child1);
1790:
1791: child1 := add_special_region_item (
1792: p_attribute_code => g_process_status_attribute,

Line 1796: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1792: p_attribute_code => g_process_status_attribute,
1793: p_plan_id => p_plan_id,
1794: p_prefix => p_prefix,
1795: p_region_code => l_region_code);
1796: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1797: 'contents', child1);
1798:
1799: child1 := add_special_region_item (
1800: p_attribute_code => g_source_code_attribute,

Line 1804: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1800: p_attribute_code => g_source_code_attribute,
1801: p_plan_id => p_plan_id,
1802: p_prefix => p_prefix,
1803: p_region_code => l_region_code);
1804: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1805: 'contents', child1);
1806:
1807: child1 := add_special_region_item (
1808: p_attribute_code => g_source_line_id_attribute,

Line 1812: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1808: p_attribute_code => g_source_line_id_attribute,
1809: p_plan_id => p_plan_id,
1810: p_prefix => p_prefix,
1811: p_region_code => l_region_code);
1812: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1813: 'contents', child1);
1814:
1815: child1 := add_special_region_item (
1816: p_attribute_code => g_po_agent_id_attribute,

Line 1820: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1816: p_attribute_code => g_po_agent_id_attribute,
1817: p_plan_id => p_plan_id,
1818: p_prefix => p_prefix,
1819: p_region_code => l_region_code);
1820: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1821: 'contents', child1);
1822: -- added for attachments
1823:
1824: IF (instr(l_region_code, g_txn_work_prefix) <> 0)

Line 1838: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1834: p_attribute_code => g_single_row_attachment,
1835: p_plan_id => p_plan_id,
1836: p_prefix => p_prefix,
1837: p_region_code => l_region_code);
1838: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1839: 'contents', child1);
1840: ELSE
1841: child1 := add_special_region_item (
1842: p_attribute_code => g_multi_row_attachment,

Line 1846: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1842: p_attribute_code => g_multi_row_attachment,
1843: p_plan_id => p_plan_id,
1844: p_prefix => p_prefix,
1845: p_region_code => l_region_code);
1846: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1847: 'contents', child1);
1848: END IF;
1849:
1850: l_saved := JDR_DOCBUILDER.SAVE;

Line 1850: l_saved := JDR_DOCBUILDER.SAVE;

1846: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1847: 'contents', child1);
1848: END IF;
1849:
1850: l_saved := JDR_DOCBUILDER.SAVE;
1851:
1852: --if saved went ok and a previous, lower version document exists
1853: --then try to delete the previous document
1854: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);

Line 1855: IF (l_saved = jdr_docbuilder.SUCCESS) AND

1851:
1852: --if saved went ok and a previous, lower version document exists
1853: --then try to delete the previous document
1854: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
1855: IF (l_saved = jdr_docbuilder.SUCCESS) AND
1856: (p_jrad_doc_ver > 1) AND
1857: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
1858: jdr_docbuilder.deleteDocument(l_old_doc_name);
1859: END IF;

Line 1857: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN

1853: --then try to delete the previous document
1854: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
1855: IF (l_saved = jdr_docbuilder.SUCCESS) AND
1856: (p_jrad_doc_ver > 1) AND
1857: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
1858: jdr_docbuilder.deleteDocument(l_old_doc_name);
1859: END IF;
1860:
1861: --qa_ian_pkg.write_log('EQR Dumping Document(l_saved): "'||g_jrad_region_path || l_region_code||'"('||l_saved||')');

Line 1858: jdr_docbuilder.deleteDocument(l_old_doc_name);

1854: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
1855: IF (l_saved = jdr_docbuilder.SUCCESS) AND
1856: (p_jrad_doc_ver > 1) AND
1857: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
1858: jdr_docbuilder.deleteDocument(l_old_doc_name);
1859: END IF;
1860:
1861: --qa_ian_pkg.write_log('EQR Dumping Document(l_saved): "'||g_jrad_region_path || l_region_code||'"('||l_saved||')');
1862: --qa_ian_pkg.write_log(jdr_mds_internal.exportsingledocument(jdr_mds_internal.GETDOCUMENTID(g_jrad_region_path || l_region_code, 'DOCUMENT'), true));

Line 1894: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;

1890: err_num NUMBER;
1891: err_msg VARCHAR2(100);
1892: elmt_counter NUMBER;--parent-child results inquiry
1893:
1894: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1895: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1896: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1897:
1898: CURSOR c IS

Line 1895: topLevel JDR_DOCBUILDER.ELEMENT := NULL;

1891: err_msg VARCHAR2(100);
1892: elmt_counter NUMBER;--parent-child results inquiry
1893:
1894: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1895: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1896: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1897:
1898: CURSOR c IS
1899: SELECT char_id

Line 1896: child1 JDR_DOCBUILDER.ELEMENT := NULL;

1892: elmt_counter NUMBER;--parent-child results inquiry
1893:
1894: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1895: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1896: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1897:
1898: CURSOR c IS
1899: SELECT char_id
1900: FROM qa_plan_chars

Line 1912: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');

1908: l_region_code := construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver);
1909:
1910: --dbms_output.put_line('Entered VQR, path: "'||g_jrad_region_path||l_region_code||'", p_jrad_doc_ver: '||p_jrad_doc_ver);
1911:
1912: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');
1913:
1914: topLevel := create_jrad_region (l_region_code, p_plan_id);
1915: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);
1916:

Line 1915: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);

1911:
1912: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');
1913:
1914: topLevel := create_jrad_region (l_region_code, p_plan_id);
1915: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);
1916:
1917: elmt_counter := 0; --parent-child results inquiry
1918: --initialize counter
1919: OPEN c;

Line 1943: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1939: p_attribute_code => l_attribute_code,
1940: p_plan_id => p_plan_id,
1941: p_prefix => p_prefix,
1942: p_char_id => l_element_id);
1943: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1944: 'contents', child1);
1945: --contents is the grouping name
1946: END IF;
1947:

Line 1960: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1956: p_attribute_code => l_attribute_code,
1957: p_plan_id => p_plan_id,
1958: p_prefix => p_prefix,
1959: p_char_id => l_element_id);
1960: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1961: 'contents', child1);
1962: --contents is the grouping name
1963: END IF;
1964:

Line 1974: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1970: child1 := add_special_region_item (p_attribute_code => g_qa_created_by_attribute,
1971: p_plan_id => p_plan_id,
1972: p_prefix => p_prefix,
1973: p_region_code => l_region_code);
1974: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1975: 'contents', child1);
1976:
1977: child1 := add_special_region_item (p_attribute_code => g_collection_id_attribute,
1978: p_plan_id => p_plan_id,

Line 1981: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1977: child1 := add_special_region_item (p_attribute_code => g_collection_id_attribute,
1978: p_plan_id => p_plan_id,
1979: p_prefix => p_prefix,
1980: p_region_code => l_region_code);
1981: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1982: 'contents', child1);
1983:
1984: child1 := add_special_region_item (p_attribute_code => g_last_update_date_attribute,
1985: p_plan_id => p_plan_id,

Line 1988: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1984: child1 := add_special_region_item (p_attribute_code => g_last_update_date_attribute,
1985: p_plan_id => p_plan_id,
1986: p_prefix => p_prefix,
1987: p_region_code => l_region_code);
1988: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1989: 'contents', child1);
1990:
1991: -- added for attachments
1992: child1 := add_special_region_item (p_attribute_code => g_multi_row_attachment,

Line 1996: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

1992: child1 := add_special_region_item (p_attribute_code => g_multi_row_attachment,
1993: p_plan_id => p_plan_id,
1994: p_prefix => p_prefix,
1995: p_region_code => l_region_code);
1996: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1997: 'contents', child1);
1998:
1999: -- added for update capability
2000: IF (instr(l_region_code, g_work_vqr_prefix) <> 0)

Line 2011: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

2007: child1 := add_special_region_item (p_attribute_code => g_update_attribute,
2008: p_plan_id => p_plan_id,
2009: p_prefix => p_prefix,
2010: p_region_code => l_region_code);
2011: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2012: 'contents', child1);
2013: END IF;
2014:
2015: -- parent-child

Line 2022: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

2018: child1 := add_special_region_item (p_attribute_code => g_child_url_attribute,
2019: p_plan_id => p_plan_id,
2020: p_prefix => p_prefix,
2021: p_region_code => l_region_code);
2022: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2023: 'contents', child1);
2024:
2025: --below introduced for ui improvement
2026: --link to click and see all coll.elements for a vqr row

Line 2037: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,

2033: child1 := add_special_region_item (p_attribute_code => g_vqr_all_elements_url,
2034: p_plan_id => p_plan_id,
2035: p_prefix => p_prefix,
2036: p_region_code => l_region_code);
2037: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2038: 'contents', child1);
2039: END IF;
2040: END IF; --end "outer if" stmt: "not" single row parent vqr region
2041:

Line 2042: l_saved := JDR_DOCBUILDER.SAVE;

2038: 'contents', child1);
2039: END IF;
2040: END IF; --end "outer if" stmt: "not" single row parent vqr region
2041:
2042: l_saved := JDR_DOCBUILDER.SAVE;
2043:
2044: --if saved went ok and a previous, lower version document exists
2045: --then try to delete the previous document
2046: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);

Line 2047: IF (l_saved = jdr_docbuilder.SUCCESS) AND

2043:
2044: --if saved went ok and a previous, lower version document exists
2045: --then try to delete the previous document
2046: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
2047: IF (l_saved = jdr_docbuilder.SUCCESS) AND
2048: (p_jrad_doc_ver > 1) AND
2049: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
2050: jdr_docbuilder.deleteDocument(l_old_doc_name);
2051: END IF;

Line 2049: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN

2045: --then try to delete the previous document
2046: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
2047: IF (l_saved = jdr_docbuilder.SUCCESS) AND
2048: (p_jrad_doc_ver > 1) AND
2049: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
2050: jdr_docbuilder.deleteDocument(l_old_doc_name);
2051: END IF;
2052:
2053: --qa_ian_pkg.write_log('VQR Dumping Document(l_saved): "'||g_jrad_region_path || l_region_code||'"('||l_saved||')');

Line 2050: jdr_docbuilder.deleteDocument(l_old_doc_name);

2046: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
2047: IF (l_saved = jdr_docbuilder.SUCCESS) AND
2048: (p_jrad_doc_ver > 1) AND
2049: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
2050: jdr_docbuilder.deleteDocument(l_old_doc_name);
2051: END IF;
2052:
2053: --qa_ian_pkg.write_log('VQR Dumping Document(l_saved): "'||g_jrad_region_path || l_region_code||'"('||l_saved||')');
2054: --qa_ian_pkg.write_log(jdr_mds_internal.exportsingledocument(jdr_mds_internal.GETDOCUMENTID(g_jrad_region_path || l_region_code, 'DOCUMENT'), true));