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 832: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS

828:
829:
830: FUNCTION create_jrad_region (
831: p_region_code IN VARCHAR2,
832: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
833:
834: l_region_style VARCHAR2(30);
835: l_row_id VARCHAR2(30);
836: l_plan_name qa_plans.name%TYPE;

Line 837: topLevel JDR_DOCBUILDER.ELEMENT := NULL;

833:
834: l_region_style VARCHAR2(30);
835: l_row_id VARCHAR2(30);
836: l_plan_name qa_plans.name%TYPE;
837: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
838:
839: l_prompt VARCHAR2(30);
840:
841: CURSOR c IS

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

852: CLOSE c;
853:
854:
855: l_region_style := get_region_style(p_region_code);
856: topLevel := JDR_DOCBUILDER.createElement(JDR_DOCBUILDER.OA_NS, l_region_style);
857:
858: -- rkaza. 02/26/2004. bug 3461988.
859: -- Prompt of the EQR region should be Data for EAM EQR page.
860: -- EAM vqr table regions should have a width 100%

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

866: OR (instr(p_region_code, g_checkout_eqr_prefix) <> 0)
867: --dgupta: End R12 EAM Integration. Bug 4345492
868: OR (instr(p_region_code, g_txn_op_prefix) <> 0) then
869: l_prompt := fnd_message.get_string('QA', 'QA_SS_RN_PROMPT_DATA');
870: jdr_docbuilder.setAttribute(topLevel, 'text', l_prompt);
871: END IF;
872:
873: IF (instr(p_region_code, g_work_vqr_prefix) <> 0)
874: OR (instr(p_region_code, g_asset_vqr_prefix) <> 0)

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

876: OR (instr(p_region_code, g_checkin_vqr_prefix) <> 0)
877: OR (instr(p_region_code, g_checkout_vqr_prefix) <> 0)
878: --dgupta: End R12 EAM Integration. Bug 4345492
879: OR (instr(p_region_code, g_op_vqr_prefix) <> 0) then
880: jdr_docbuilder.setAttribute(topLevel, 'width', '100%');
881: END IF;
882:
883: jdr_docbuilder.setAttribute(topLevel, 'prompt', l_plan_name);
884: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);

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

879: OR (instr(p_region_code, g_op_vqr_prefix) <> 0) then
880: jdr_docbuilder.setAttribute(topLevel, 'width', '100%');
881: END IF;
882:
883: jdr_docbuilder.setAttribute(topLevel, 'prompt', l_plan_name);
884: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);
885: jdr_docbuilder.setAttribute(topLevel, 'id', p_region_code);
886:
887: IF (instr(p_region_code, g_pc_vqr_sin_prefix) <> 0) THEN

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

880: jdr_docbuilder.setAttribute(topLevel, 'width', '100%');
881: END IF;
882:
883: jdr_docbuilder.setAttribute(topLevel, 'prompt', l_plan_name);
884: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);
885: jdr_docbuilder.setAttribute(topLevel, 'id', p_region_code);
886:
887: IF (instr(p_region_code, g_pc_vqr_sin_prefix) <> 0) THEN
888: jdr_docbuilder.setAttribute(topLevel, 'headerDisabled', 'true');

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

881: END IF;
882:
883: jdr_docbuilder.setAttribute(topLevel, 'prompt', l_plan_name);
884: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);
885: jdr_docbuilder.setAttribute(topLevel, 'id', p_region_code);
886:
887: IF (instr(p_region_code, g_pc_vqr_sin_prefix) <> 0) THEN
888: jdr_docbuilder.setAttribute(topLevel, 'headerDisabled', 'true');
889: ELSIF (instr(p_region_code, g_pc_vqr_prefix) <> 0) THEN

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

884: jdr_docbuilder.setAttribute(topLevel, 'regionName', l_plan_name);
885: jdr_docbuilder.setAttribute(topLevel, 'id', p_region_code);
886:
887: IF (instr(p_region_code, g_pc_vqr_sin_prefix) <> 0) THEN
888: jdr_docbuilder.setAttribute(topLevel, 'headerDisabled', 'true');
889: ELSIF (instr(p_region_code, g_pc_vqr_prefix) <> 0) THEN
890: --ilawler - bug #3462025 - Mon Feb 23 17:19:07 2004
891: --Set width of table to be 90%
892: jdr_docbuilder.setAttribute(topLevel, 'width', '90%');

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

888: jdr_docbuilder.setAttribute(topLevel, 'headerDisabled', 'true');
889: ELSIF (instr(p_region_code, g_pc_vqr_prefix) <> 0) THEN
890: --ilawler - bug #3462025 - Mon Feb 23 17:19:07 2004
891: --Set width of table to be 90%
892: jdr_docbuilder.setAttribute(topLevel, 'width', '90%');
893: END IF;
894:
895: -- Tracking Bug : 3209719
896: -- Added for OAC complicance

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

895: -- Tracking Bug : 3209719
896: -- Added for OAC complicance
897: -- ilawler Tue Oct 21 15:24:26 2003
898: IF l_region_style = 'table' THEN
899: jdr_docbuilder.setAttribute(topLevel, 'shortDesc', fnd_message.get_string('QA','QA_OAC_RESULTS_TABLE'));
900: ELSIF l_region_style = 'labeledFieldLayout' THEN
901: --ilawler - bug #3462025 - Mon Feb 23 17:42:47 2004
902: --when using the labeledFieldLayout, suggest 2 columns
903: jdr_docbuilder.setAttribute(topLevel, 'columns', '2');

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

899: jdr_docbuilder.setAttribute(topLevel, 'shortDesc', fnd_message.get_string('QA','QA_OAC_RESULTS_TABLE'));
900: ELSIF l_region_style = 'labeledFieldLayout' THEN
901: --ilawler - bug #3462025 - Mon Feb 23 17:42:47 2004
902: --when using the labeledFieldLayout, suggest 2 columns
903: jdr_docbuilder.setAttribute(topLevel, 'columns', '2');
904: END IF;
905:
906: RETURN topLevel;
907:

Line 938: p_input_elem IN jdr_docbuilder.Element) IS

934: PROCEDURE add_lov_relations (
935: p_plan_id IN NUMBER,
936: p_char_id IN NUMBER,
937: p_attribute_code IN VARCHAR2,
938: p_input_elem IN jdr_docbuilder.Element) IS
939:
940:
941: err_num NUMBER;
942: err_msg VARCHAR2(100);

Line 951: lovMap jdr_docbuilder.ELEMENT;

947: l_lov_attribute_code VARCHAR2(30);
948: l_base_attribute_code VARCHAR2(30);
949: l_parents ParentArray;
950:
951: lovMap jdr_docbuilder.ELEMENT;
952:
953:
954: BEGIN
955:

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

956: -- This function adds lov relations for a region item.
957: -- Here the region item corresponds to a collection plan element.
958:
959: --Criteria
960: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
961: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
962: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
963: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
964: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

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

957: -- Here the region item corresponds to a collection plan element.
958:
959: --Criteria
960: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
961: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
962: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
963: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
964: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
965: lovMap);

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

958:
959: --Criteria
960: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
961: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
962: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
963: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
964: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
965: lovMap);
966: --Result

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

959: --Criteria
960: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
961: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
962: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
963: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
964: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
965: lovMap);
966: --Result
967: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

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

960: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
961: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
962: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
963: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
964: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
965: lovMap);
966: --Result
967: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
968: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);

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

963: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
964: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
965: lovMap);
966: --Result
967: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
968: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
969: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
970: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
971: lovMap);

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

964: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
965: lovMap);
966: --Result
967: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
968: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
969: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
970: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
971: lovMap);
972: --Org Id

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

965: lovMap);
966: --Result
967: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
968: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
969: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
970: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
971: lovMap);
972: --Org Id
973: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

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

966: --Result
967: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
968: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
969: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
970: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
971: lovMap);
972: --Org Id
973: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
974: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);

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

969: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_code);
970: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
971: lovMap);
972: --Org Id
973: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
974: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
975: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
976: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
977: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

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

970: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
971: lovMap);
972: --Org Id
973: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
974: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
975: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
976: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
977: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
978: lovMap);

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

971: lovMap);
972: --Org Id
973: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
974: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
975: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
976: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
977: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
978: lovMap);
979: --Plan Id

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

972: --Org Id
973: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
974: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
975: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
976: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
977: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
978: lovMap);
979: --Plan Id
980: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

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

973: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
974: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_org_id_attribute);
975: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_org_id);
976: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
977: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
978: lovMap);
979: --Plan Id
980: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
981: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);

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

976: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
977: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
978: lovMap);
979: --Plan Id
980: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
981: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
982: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
983: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
984: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

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

977: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
978: lovMap);
979: --Plan Id
980: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
981: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
982: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
983: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
984: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
985: lovMap);

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

978: lovMap);
979: --Plan Id
980: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
981: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
982: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
983: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
984: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
985: lovMap);
986:

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

979: --Plan Id
980: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
981: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
982: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
983: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
984: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
985: lovMap);
986:
987:

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

980: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
981: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', g_plan_id_attribute);
982: jdr_docbuilder.setAttribute(lovMap, 'lovItem', g_lov_attribute_plan_id);
983: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
984: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
985: lovMap);
986:
987:
988: get_dependencies(p_char_id, l_parents);

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

1010: --
1011:
1012: l_base_attribute_code := cons_base_attribute_code(g_element_prefix, l_parents(i));
1013:
1014: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS,
1015: 'lovMap');
1016: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
1017: l_base_attribute_code);
1018: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);

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

1012: l_base_attribute_code := cons_base_attribute_code(g_element_prefix, l_parents(i));
1013:
1014: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS,
1015: 'lovMap');
1016: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
1017: l_base_attribute_code);
1018: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
1019: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
1020: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',

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

1014: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS,
1015: 'lovMap');
1016: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
1017: l_base_attribute_code);
1018: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
1019: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
1020: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
1021: lovMap);
1022: END IF;

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

1015: 'lovMap');
1016: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
1017: l_base_attribute_code);
1018: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
1019: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
1020: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
1021: lovMap);
1022: END IF;
1023:

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

1016: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom',
1017: l_base_attribute_code);
1018: jdr_docbuilder.setAttribute(lovMap, 'lovItem', l_lov_attribute_code);
1019: jdr_docbuilder.setAttribute(lovMap, 'programmaticQuery', 'true');
1020: jdr_docbuilder.addChild(p_input_elem, jdr_docbuilder.JRAD_NS, 'lovMappings',
1021: lovMap);
1022: END IF;
1023:
1024: END LOOP;

Line 1047: RETURN jdr_docbuilder.ELEMENT IS

1043:
1044: FUNCTION create_id_item_for_eqr (
1045: p_plan_id IN NUMBER,
1046: p_char_id IN NUMBER)
1047: RETURN jdr_docbuilder.ELEMENT IS
1048:
1049: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
1050: l_id_elem jdr_docbuilder.ELEMENT := NULL;
1051:

Line 1050: l_id_elem jdr_docbuilder.ELEMENT := NULL;

1046: p_char_id IN NUMBER)
1047: RETURN jdr_docbuilder.ELEMENT IS
1048:
1049: l_vo_attribute_name VARCHAR2(30) DEFAULT NULL;
1050: l_id_elem jdr_docbuilder.ELEMENT := NULL;
1051:
1052: BEGIN
1053:
1054: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);

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

1051:
1052: BEGIN
1053:
1054: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
1055: l_id_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'formValue');
1056:
1057: -- set properties
1058: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1059: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);

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

1054: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
1055: l_id_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'formValue');
1056:
1057: -- set properties
1058: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1059: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);
1060: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
1061: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
1062:

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

1055: l_id_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'formValue');
1056:
1057: -- set properties
1058: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1059: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);
1060: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
1061: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
1062:
1063: return l_id_elem;

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

1056:
1057: -- set properties
1058: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1059: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);
1060: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
1061: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
1062:
1063: return l_id_elem;
1064:

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

1057: -- set properties
1058: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);
1059: jdr_docbuilder.setAttribute(l_id_elem, 'viewName', g_eqr_view_usage_name);
1060: jdr_docbuilder.setAttribute(l_id_elem, 'viewAttr', l_vo_attribute_name);
1061: jdr_docbuilder.setAttribute(l_id_elem, 'dataType', 'NUMBER');
1062:
1063: return l_id_elem;
1064:
1065: END create_id_item_for_eqr;

Line 1121: p_char_item IN jdr_docbuilder.Element) IS

1117: PROCEDURE process_normalized_lov (
1118: p_plan_id IN NUMBER,
1119: p_char_id IN NUMBER,
1120: p_attribute_code IN VARCHAR2,
1121: p_char_item IN jdr_docbuilder.Element) IS
1122:
1123: lovMap jdr_docbuilder.ELEMENT;
1124: l_lov_region VARCHAR2(100);
1125:

Line 1123: lovMap jdr_docbuilder.ELEMENT;

1119: p_char_id IN NUMBER,
1120: p_attribute_code IN VARCHAR2,
1121: p_char_item IN jdr_docbuilder.Element) IS
1122:
1123: lovMap jdr_docbuilder.ELEMENT;
1124: l_lov_region VARCHAR2(100);
1125:
1126: BEGIN
1127:

Line 1130: jdr_docbuilder.setAttribute(p_char_item,

1126: BEGIN
1127:
1128: IF(p_char_id = qa_ss_const.po_number) THEN
1129: l_lov_region := qa_ssqr_jrad_pkg.g_jrad_lov_dir_path || get_lov_region_name(p_plan_id,p_char_id);
1130: jdr_docbuilder.setAttribute(p_char_item,
1131: 'externalListOfValues',
1132: l_lov_region);
1133: --Criteria
1134: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

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

1130: jdr_docbuilder.setAttribute(p_char_item,
1131: 'externalListOfValues',
1132: l_lov_region);
1133: --Criteria
1134: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1135: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1136: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1137: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1138: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');

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

1131: 'externalListOfValues',
1132: l_lov_region);
1133: --Criteria
1134: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1135: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1136: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1137: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1138: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1139: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',

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

1132: l_lov_region);
1133: --Criteria
1134: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1135: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1136: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1137: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1138: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1139: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1140: lovMap);

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

1133: --Criteria
1134: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1135: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1136: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1137: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1138: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1139: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1140: lovMap);
1141: -- po_header_id

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

1134: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1135: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1136: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1137: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1138: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1139: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1140: lovMap);
1141: -- po_header_id
1142: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');

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

1135: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1136: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1137: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1138: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1139: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1140: lovMap);
1141: -- po_header_id
1142: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1143: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');

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

1138: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1139: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1140: lovMap);
1141: -- po_header_id
1142: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1143: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1144: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1145: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1146: lovMap);

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

1139: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1140: lovMap);
1141: -- po_header_id
1142: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1143: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1144: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1145: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1146: lovMap);
1147:

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

1140: lovMap);
1141: -- po_header_id
1142: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1143: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1144: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1145: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1146: lovMap);
1147:
1148: END IF; -- PO Number

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

1141: -- po_header_id
1142: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1143: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1144: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1145: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1146: lovMap);
1147:
1148: END IF; -- PO Number
1149:

Line 1162: p_char_item IN jdr_docbuilder.Element) IS

1158: PROCEDURE process_regular_lov (
1159: p_plan_id IN NUMBER,
1160: p_char_id IN NUMBER,
1161: p_attribute_code IN VARCHAR2,
1162: p_char_item IN jdr_docbuilder.Element) IS
1163:
1164: BEGIN
1165:
1166: jdr_docbuilder.setAttribute(p_char_item, 'externalListOfValues',

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

1162: p_char_item IN jdr_docbuilder.Element) IS
1163:
1164: BEGIN
1165:
1166: jdr_docbuilder.setAttribute(p_char_item, 'externalListOfValues',
1167: g_jrad_lov_path);
1168:
1169: add_lov_relations(p_plan_id, p_char_id, p_attribute_code, p_char_item);
1170:

Line 1183: p_char_item IN jdr_docbuilder.Element) IS

1179: PROCEDURE process_messageLovInput (
1180: p_plan_id IN NUMBER,
1181: p_char_id IN NUMBER,
1182: p_attribute_code IN VARCHAR2,
1183: p_char_item IN jdr_docbuilder.Element) IS
1184:
1185:
1186:
1187: BEGIN

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

1229:
1230: FUNCTION create_region_item_for_eqr (
1231: p_char_id IN NUMBER,
1232: p_plan_id IN NUMBER,
1233: p_prefix IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
1234:
1235: -- Bug 3769260. shkalyan 29 July 2004.
1236: -- Removed these attributes since the cursor to get from qa_plan_chars
1237: -- and qa_chars are removed.

Line 1261: child1 jdr_docbuilder.ELEMENT;

1257: -- bhsankar Tue Oct 16 23:21:38 PDT 2007
1258: -- l_prompt qa_plan_chars.prompt%TYPE;
1259: l_prompt VARCHAR2(100);
1260:
1261: child1 jdr_docbuilder.ELEMENT;
1262:
1263: -- Tracking Bug : 3104827
1264: -- Added for Read Only Flag for Collection Plan Enhancement
1265: -- saugupta Thu Aug 28 08:58:53 PDT 2003

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

1341: -- hmakam.
1342:
1343: l_data_entry_hint := qa_chars_api.data_entry_hint(p_char_id);
1344:
1345: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1346: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1347: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1348: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1349: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);

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

1342:
1343: l_data_entry_hint := qa_chars_api.data_entry_hint(p_char_id);
1344:
1345: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1346: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1347: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1348: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1349: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1350: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);

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

1343: l_data_entry_hint := qa_chars_api.data_entry_hint(p_char_id);
1344:
1345: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1346: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1347: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1348: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1349: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1350: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1351: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);

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

1344:
1345: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1346: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1347: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1348: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1349: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1350: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1351: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1352: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);

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

1345: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1346: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1347: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1348: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1349: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1350: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1351: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1352: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1353: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);

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

1346: jdr_docbuilder.setAttribute(child1, 'id', l_attribute_code);
1347: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1348: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1349: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1350: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1351: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1352: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1353: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);
1354:

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

1347: jdr_docbuilder.setAttribute(child1, 'rendered', l_display_flag);
1348: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1349: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1350: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1351: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1352: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1353: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);
1354:
1355:

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

1348: jdr_docbuilder.setAttribute(child1, 'prompt', l_prompt);
1349: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1350: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1351: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1352: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1353: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);
1354:
1355:
1356: -- Bug 10372289.

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

1349: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_prompt);
1350: jdr_docbuilder.setAttribute(child1, 'required', l_required_flag);
1351: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1352: jdr_docbuilder.setAttribute(child1, 'viewName', g_eqr_view_usage_name);
1353: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_vo_attribute_name);
1354:
1355:
1356: -- Bug 10372289.
1357: -- Added code to display hints when quality data is entered

Line 1363: jdr_docbuilder.setAttribute(child1, 'tipType', qa_ssqr_jrad_pkg.g_tip_type);

1359: -- hmakam
1360:
1361: IF (l_data_entry_hint is not null) THEN
1362:
1363: jdr_docbuilder.setAttribute(child1, 'tipType', qa_ssqr_jrad_pkg.g_tip_type);
1364: jdr_docbuilder.setAttribute(child1, 'longTipRegion', qa_ssqr_jrad_pkg.g_long_tip_region);
1365:
1366: END IF;
1367:

Line 1364: jdr_docbuilder.setAttribute(child1, 'longTipRegion', qa_ssqr_jrad_pkg.g_long_tip_region);

1360:
1361: IF (l_data_entry_hint is not null) THEN
1362:
1363: jdr_docbuilder.setAttribute(child1, 'tipType', qa_ssqr_jrad_pkg.g_tip_type);
1364: jdr_docbuilder.setAttribute(child1, 'longTipRegion', qa_ssqr_jrad_pkg.g_long_tip_region);
1365:
1366: END IF;
1367:
1368: -- Tracking Bug : 3104827

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

1368: -- Tracking Bug : 3104827
1369: -- Added for Read Only Flag Collection Plan Enhancement
1370: -- saugupta Thu Aug 28 08:59:59 PDT 2003
1371:
1372: jdr_docbuilder.setAttribute(child1, 'readOnly', l_readonly_flag);
1373:
1374: -- At this point, if the element has lovs then we must determine
1375: -- what are its dependency and populate lov_relations
1376: -- with this information.

Line 1410: RETURN JDR_DOCBUILDER.ELEMENT IS

1406: p_attribute_code IN VARCHAR2,
1407: p_plan_id IN VARCHAR2,
1408: p_prefix IN VARCHAR2,
1409: p_char_id IN NUMBER)
1410: RETURN JDR_DOCBUILDER.ELEMENT IS
1411:
1412: l_row_id VARCHAR2(30);
1413: l_element_id NUMBER;
1414: l_region_code VARCHAR2(30);

Line 1431: child1 jdr_docbuilder.ELEMENT;

1427: -- l_label_long VARCHAR2(30) DEFAULT NULL;
1428: l_label_long VARCHAR2(100) DEFAULT NULL;
1429: l_data_type VARCHAR2(30);
1430:
1431: child1 jdr_docbuilder.ELEMENT;
1432:
1433: err_num NUMBER;
1434: err_msg VARCHAR2(100);
1435:

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

1481: OR (instr(l_region_code, g_op_vqr_prefix) <> 0) THEN
1482: l_query_flag := 'true';
1483: END IF;
1484:
1485: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1486: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1487: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1488: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1489: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);

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

1482: l_query_flag := 'true';
1483: END IF;
1484:
1485: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1486: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1487: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1488: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1489: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1490: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);

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

1483: END IF;
1484:
1485: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1486: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1487: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1488: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1489: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1490: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1491: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);

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

1484:
1485: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1486: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1487: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1488: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1489: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1490: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1491: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1492: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);

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

1485: child1 := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, l_item_style);
1486: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1487: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1488: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1489: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1490: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1491: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1492: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);
1493:

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

1486: jdr_docbuilder.setAttribute(child1, 'id', p_attribute_code);
1487: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1488: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1489: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1490: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1491: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1492: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);
1493:
1494: --ilawler - bug #3462025 - Mon Feb 23 17:48:09 2004

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

1487: jdr_docbuilder.setAttribute(child1, 'rendered', 'true');
1488: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1489: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1490: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1491: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1492: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);
1493:
1494: --ilawler - bug #3462025 - Mon Feb 23 17:48:09 2004
1495: --set the right CSS Class for data elements

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

1488: jdr_docbuilder.setAttribute(child1, 'prompt', l_label_long);
1489: jdr_docbuilder.setAttribute(child1, 'dataType', l_data_type);
1490: jdr_docbuilder.setAttribute(child1, 'shortDesc', l_label_long);
1491: jdr_docbuilder.setAttribute(child1, 'viewName', l_view_usage_name);
1492: jdr_docbuilder.setAttribute(child1, 'viewAttr', l_view_attribute_name);
1493:
1494: --ilawler - bug #3462025 - Mon Feb 23 17:48:09 2004
1495: --set the right CSS Class for data elements
1496: IF (instr(l_region_code, g_pc_vqr_sin_prefix) <> 0) THEN

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

1493:
1494: --ilawler - bug #3462025 - Mon Feb 23 17:48:09 2004
1495: --set the right CSS Class for data elements
1496: IF (instr(l_region_code, g_pc_vqr_sin_prefix) <> 0) THEN
1497: jdr_docbuilder.setAttribute(child1, 'styleClass', 'OraDataText');
1498: END IF;
1499:
1500: IF l_query_flag IS NOT NULL THEN
1501: --dbms_output.put_line('found a queryable');

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

1498: END IF;
1499:
1500: IF l_query_flag IS NOT NULL THEN
1501: --dbms_output.put_line('found a queryable');
1502: jdr_docbuilder.setAttribute(child1, 'queryable', l_query_flag);
1503: END IF;
1504: RETURN child1;
1505:
1506: -- dbms_output.put_line('Adding Item (S) : ' || l_region_code || ' ' ||

Line 1525: RETURN jdr_docbuilder.ELEMENT IS

1521: p_attribute_code IN VARCHAR2,
1522: p_plan_id IN VARCHAR2,
1523: p_prefix IN VARCHAR2,
1524: p_region_code IN VARCHAR2)
1525: RETURN jdr_docbuilder.ELEMENT IS
1526:
1527: l_row_id VARCHAR2(30);
1528: l_element_id NUMBER;
1529: l_region_code VARCHAR2(30);

Line 1545: special_elem jdr_docbuilder.ELEMENT := NULL;

1541: l_description VARCHAR2(240) DEFAULT NULL;
1542: --l_query_flag VARCHAR2(1) DEFAULT 'N';
1543: l_data_type VARCHAR2(30);
1544:
1545: special_elem jdr_docbuilder.ELEMENT := NULL;
1546: l_entityMap jdr_docbuilder.ELEMENT := NULL;
1547:
1548: err_num NUMBER;
1549: err_msg VARCHAR2(100);

Line 1546: l_entityMap jdr_docbuilder.ELEMENT := NULL;

1542: --l_query_flag VARCHAR2(1) DEFAULT 'N';
1543: l_data_type VARCHAR2(30);
1544:
1545: special_elem jdr_docbuilder.ELEMENT := NULL;
1546: l_entityMap jdr_docbuilder.ELEMENT := NULL;
1547:
1548: err_num NUMBER;
1549: err_msg VARCHAR2(100);
1550:

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

1682: -- Assign a datatype of DATETIME to last_update_date.
1683: l_data_type := convert_data_type(qa_ss_const.datetime_datatype);
1684: END IF;
1685:
1686: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1687: l_item_style);
1688: jdr_docbuilder.setAttribute(special_elem, 'id', p_attribute_code);
1689:
1690: if (l_view_usage_name is not null) then

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

1684: END IF;
1685:
1686: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1687: l_item_style);
1688: jdr_docbuilder.setAttribute(special_elem, 'id', p_attribute_code);
1689:
1690: if (l_view_usage_name is not null) then
1691: jdr_docbuilder.setAttribute(special_elem, 'viewName',
1692: l_view_usage_name);

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

1687: l_item_style);
1688: jdr_docbuilder.setAttribute(special_elem, 'id', p_attribute_code);
1689:
1690: if (l_view_usage_name is not null) then
1691: jdr_docbuilder.setAttribute(special_elem, 'viewName',
1692: l_view_usage_name);
1693: end if;
1694: if (l_view_attribute_name is not null) then
1695: jdr_docbuilder.setAttribute(special_elem, 'viewAttr',

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

1691: jdr_docbuilder.setAttribute(special_elem, 'viewName',
1692: l_view_usage_name);
1693: end if;
1694: if (l_view_attribute_name is not null) then
1695: jdr_docbuilder.setAttribute(special_elem, 'viewAttr',
1696: l_view_attribute_name);
1697: end if;
1698: if (l_label_long is not null) then
1699: jdr_docbuilder.setAttribute(special_elem, 'prompt',

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

1695: jdr_docbuilder.setAttribute(special_elem, 'viewAttr',
1696: l_view_attribute_name);
1697: end if;
1698: if (l_label_long is not null) then
1699: jdr_docbuilder.setAttribute(special_elem, 'prompt',
1700: l_label_long);
1701: end if;
1702: if (l_description is not null) then
1703: jdr_docbuilder.setAttribute(special_elem, 'shortDesc',

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

1699: jdr_docbuilder.setAttribute(special_elem, 'prompt',
1700: l_label_long);
1701: end if;
1702: if (l_description is not null) then
1703: jdr_docbuilder.setAttribute(special_elem, 'shortDesc',
1704: l_description);
1705: end if;
1706: if (l_image_file_name is not null) then
1707: jdr_docbuilder.setAttribute(special_elem, 'source',

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

1703: jdr_docbuilder.setAttribute(special_elem, 'shortDesc',
1704: l_description);
1705: end if;
1706: if (l_image_file_name is not null) then
1707: jdr_docbuilder.setAttribute(special_elem, 'source',
1708: l_image_file_name);
1709: end if;
1710: if (l_url is not null) then
1711: jdr_docbuilder.setAttribute(special_elem, 'destination',

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

1707: jdr_docbuilder.setAttribute(special_elem, 'source',
1708: l_image_file_name);
1709: end if;
1710: if (l_url is not null) then
1711: jdr_docbuilder.setAttribute(special_elem, 'destination',
1712: replace(l_url, '&', '&'));
1713: end if;
1714: if (l_data_type is not null) then
1715: jdr_docbuilder.setAttribute(special_elem, 'dataType', l_data_type);

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

1711: jdr_docbuilder.setAttribute(special_elem, 'destination',
1712: replace(l_url, '&', '&'));
1713: end if;
1714: if (l_data_type is not null) then
1715: jdr_docbuilder.setAttribute(special_elem, 'dataType', l_data_type);
1716: end if;
1717: if (l_entity_id is not null) then
1718: --special handling for attachments
1719: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,

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

1715: jdr_docbuilder.setAttribute(special_elem, 'dataType', l_data_type);
1716: end if;
1717: if (l_entity_id is not null) then
1718: --special handling for attachments
1719: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1720: 'entityMap');
1721: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1722: --
1723: -- Bug 8671769

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

1717: if (l_entity_id is not null) then
1718: --special handling for attachments
1719: l_entityMap := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1720: 'entityMap');
1721: jdr_docbuilder.setAttribute(l_entityMap, 'entityId', l_entity_id);
1722: --
1723: -- Bug 8671769
1724: -- Adding 'id' for the entity map so that the personalization works perfectly.
1725: -- skolluku

Line 1727: jdr_docbuilder.setAttribute(l_entityMap, 'id', 'qaEntityMap1');

1723: -- Bug 8671769
1724: -- Adding 'id' for the entity map so that the personalization works perfectly.
1725: -- skolluku
1726: --
1727: jdr_docbuilder.setAttribute(l_entityMap, 'id', 'qaEntityMap1');
1728:
1729: --ilawler - bug #3436725 - Thu Feb 12 14:39:38 2004
1730: --In VQR, set the attachment to be non-updateable/deletable/insertable
1731: IF (l_restrict_attachment = 'Y') THEN

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

1728:
1729: --ilawler - bug #3436725 - Thu Feb 12 14:39:38 2004
1730: --In VQR, set the attachment to be non-updateable/deletable/insertable
1731: IF (l_restrict_attachment = 'Y') THEN
1732: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');
1733: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
1734: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
1735: END IF;
1736:

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

1729: --ilawler - bug #3436725 - Thu Feb 12 14:39:38 2004
1730: --In VQR, set the attachment to be non-updateable/deletable/insertable
1731: IF (l_restrict_attachment = 'Y') THEN
1732: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');
1733: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
1734: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
1735: END IF;
1736:
1737: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,

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

1730: --In VQR, set the attachment to be non-updateable/deletable/insertable
1731: IF (l_restrict_attachment = 'Y') THEN
1732: jdr_docbuilder.setAttribute(l_entityMap, 'insertAllowed', 'false');
1733: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
1734: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
1735: END IF;
1736:
1737: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,
1738: 'entityMappings', l_entityMap);

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

1733: jdr_docbuilder.setAttribute(l_entityMap, 'updateAllowed', 'false');
1734: jdr_docbuilder.setAttribute(l_entityMap, 'deleteAllowed', 'false');
1735: END IF;
1736:
1737: jdr_docbuilder.addChild(special_elem, jdr_docbuilder.OA_NS,
1738: 'entityMappings', l_entityMap);
1739: end if;--entity id not null
1740:
1741: return special_elem;

Line 1768: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;

1764:
1765: err_num NUMBER;
1766: err_msg VARCHAR2(100);
1767:
1768: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1769: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1770: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1771: -- MOAC
1772: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;

Line 1769: topLevel JDR_DOCBUILDER.ELEMENT := NULL;

1765: err_num NUMBER;
1766: err_msg VARCHAR2(100);
1767:
1768: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1769: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1770: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1771: -- MOAC
1772: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1773:

Line 1770: child1 JDR_DOCBUILDER.ELEMENT := NULL;

1766: err_msg VARCHAR2(100);
1767:
1768: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1769: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1770: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1771: -- MOAC
1772: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1773:
1774: --

Line 1772: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;

1768: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1769: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1770: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1771: -- MOAC
1772: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1773:
1774: --
1775: -- Bug 9954346
1776: -- New boolean variable which will be set to true if the formValue

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

1804:
1805: l_region_code := construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver);
1806:
1807: --dbms_output.put_line('Entered EQR, path: "'||g_jrad_region_path||l_region_code||'", p_jrad_doc_ver: '||p_jrad_doc_ver);
1808: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');
1809:
1810: topLevel := create_jrad_region (l_region_code, p_plan_id);
1811: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);
1812:

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

1807: --dbms_output.put_line('Entered EQR, path: "'||g_jrad_region_path||l_region_code||'", p_jrad_doc_ver: '||p_jrad_doc_ver);
1808: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');
1809:
1810: topLevel := create_jrad_region (l_region_code, p_plan_id);
1811: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);
1812:
1813: OPEN c;
1814: LOOP
1815: FETCH c INTO l_element_id;

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

1826: -- IF (NOT action_target_element(p_plan_id, l_element_id)) THEN
1827:
1828: child1 := create_region_item_for_eqr(
1829: l_element_id, p_plan_id, p_prefix);
1830: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1831: 'contents', child1);
1832: --contents is the grouping name
1833:
1834: -- For MOAC : add normalized column.

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

1837: -- Moved existing code to outside loop and assigned true to l_po_num_exists flag.
1838: -- skolluku
1839: l_po_num_exists := true;
1840: -- l_id_item := create_id_item_for_eqr(p_plan_id,l_element_id);
1841: -- JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,'contents',l_id_item);
1842: END IF;
1843:
1844:
1845: -- END IF;

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

1850: -- Add the form value for PO Number, if required.
1851: -- skolluku
1852: IF (l_po_num_exists) THEN
1853: l_id_item := create_id_item_for_eqr(p_plan_id,qa_ss_const.po_number);
1854: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,'contents',l_id_item);
1855: END IF;
1856:
1857: child1 := add_special_region_item (
1858: p_attribute_code => g_org_id_attribute,

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

1859: p_plan_id => p_plan_id,
1860: p_prefix => p_prefix,
1861: p_region_code => l_region_code);
1862:
1863: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1864: 'contents', child1);
1865:
1866: child1 := add_special_region_item (
1867: p_attribute_code => g_org_code_attribute,

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

1867: p_attribute_code => g_org_code_attribute,
1868: p_plan_id => p_plan_id,
1869: p_prefix => p_prefix,
1870: p_region_code => l_region_code);
1871: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1872: 'contents', child1);
1873:
1874: child1 := add_special_region_item (
1875: p_attribute_code => g_plan_id_attribute,

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

1875: p_attribute_code => g_plan_id_attribute,
1876: p_plan_id => p_plan_id,
1877: p_prefix => p_prefix,
1878: p_region_code => l_region_code);
1879: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1880: 'contents', child1);
1881:
1882: child1 := add_special_region_item (
1883: p_attribute_code => g_plan_name_attribute,

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

1883: p_attribute_code => g_plan_name_attribute,
1884: p_plan_id => p_plan_id,
1885: p_prefix => p_prefix,
1886: p_region_code => l_region_code);
1887: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1888: 'contents', child1);
1889:
1890: child1 := add_special_region_item (
1891: p_attribute_code => g_process_status_attribute,

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

1891: p_attribute_code => g_process_status_attribute,
1892: p_plan_id => p_plan_id,
1893: p_prefix => p_prefix,
1894: p_region_code => l_region_code);
1895: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1896: 'contents', child1);
1897:
1898: child1 := add_special_region_item (
1899: p_attribute_code => g_source_code_attribute,

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

1899: p_attribute_code => g_source_code_attribute,
1900: p_plan_id => p_plan_id,
1901: p_prefix => p_prefix,
1902: p_region_code => l_region_code);
1903: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1904: 'contents', child1);
1905:
1906: child1 := add_special_region_item (
1907: p_attribute_code => g_source_line_id_attribute,

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

1907: p_attribute_code => g_source_line_id_attribute,
1908: p_plan_id => p_plan_id,
1909: p_prefix => p_prefix,
1910: p_region_code => l_region_code);
1911: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1912: 'contents', child1);
1913:
1914: child1 := add_special_region_item (
1915: p_attribute_code => g_po_agent_id_attribute,

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

1915: p_attribute_code => g_po_agent_id_attribute,
1916: p_plan_id => p_plan_id,
1917: p_prefix => p_prefix,
1918: p_region_code => l_region_code);
1919: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1920: 'contents', child1);
1921: -- added for attachments
1922:
1923: IF (instr(l_region_code, g_txn_work_prefix) <> 0)

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

1933: p_attribute_code => g_single_row_attachment,
1934: p_plan_id => p_plan_id,
1935: p_prefix => p_prefix,
1936: p_region_code => l_region_code);
1937: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1938: 'contents', child1);
1939: ELSE
1940: child1 := add_special_region_item (
1941: p_attribute_code => g_multi_row_attachment,

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

1941: p_attribute_code => g_multi_row_attachment,
1942: p_plan_id => p_plan_id,
1943: p_prefix => p_prefix,
1944: p_region_code => l_region_code);
1945: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1946: 'contents', child1);
1947: END IF;
1948:
1949: l_saved := JDR_DOCBUILDER.SAVE;

Line 1949: l_saved := JDR_DOCBUILDER.SAVE;

1945: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
1946: 'contents', child1);
1947: END IF;
1948:
1949: l_saved := JDR_DOCBUILDER.SAVE;
1950:
1951: --if saved went ok and a previous, lower version document exists
1952: --then try to delete the previous document
1953: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);

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

1950:
1951: --if saved went ok and a previous, lower version document exists
1952: --then try to delete the previous document
1953: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
1954: IF (l_saved = jdr_docbuilder.SUCCESS) AND
1955: (p_jrad_doc_ver > 1) AND
1956: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
1957: jdr_docbuilder.deleteDocument(l_old_doc_name);
1958: END IF;

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

1952: --then try to delete the previous document
1953: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
1954: IF (l_saved = jdr_docbuilder.SUCCESS) AND
1955: (p_jrad_doc_ver > 1) AND
1956: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
1957: jdr_docbuilder.deleteDocument(l_old_doc_name);
1958: END IF;
1959:
1960: --qa_ian_pkg.write_log('EQR Dumping Document(l_saved): "'||g_jrad_region_path || l_region_code||'"('||l_saved||')');

Line 1957: jdr_docbuilder.deleteDocument(l_old_doc_name);

1953: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
1954: IF (l_saved = jdr_docbuilder.SUCCESS) AND
1955: (p_jrad_doc_ver > 1) AND
1956: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
1957: jdr_docbuilder.deleteDocument(l_old_doc_name);
1958: END IF;
1959:
1960: --qa_ian_pkg.write_log('EQR Dumping Document(l_saved): "'||g_jrad_region_path || l_region_code||'"('||l_saved||')');
1961: --qa_ian_pkg.write_log(jdr_mds_internal.exportsingledocument(jdr_mds_internal.GETDOCUMENTID(g_jrad_region_path || l_region_code, 'DOCUMENT'), true));

Line 1993: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;

1989: err_num NUMBER;
1990: err_msg VARCHAR2(100);
1991: elmt_counter NUMBER;--parent-child results inquiry
1992:
1993: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1994: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1995: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1996:
1997: CURSOR c IS

Line 1994: topLevel JDR_DOCBUILDER.ELEMENT := NULL;

1990: err_msg VARCHAR2(100);
1991: elmt_counter NUMBER;--parent-child results inquiry
1992:
1993: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1994: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1995: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1996:
1997: CURSOR c IS
1998: SELECT char_id

Line 1995: child1 JDR_DOCBUILDER.ELEMENT := NULL;

1991: elmt_counter NUMBER;--parent-child results inquiry
1992:
1993: qa_jrad_doc JDR_DOCBUILDER.DOCUMENT := NULL;
1994: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
1995: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1996:
1997: CURSOR c IS
1998: SELECT char_id
1999: FROM qa_plan_chars

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

2007: l_region_code := construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver);
2008:
2009: --dbms_output.put_line('Entered VQR, path: "'||g_jrad_region_path||l_region_code||'", p_jrad_doc_ver: '||p_jrad_doc_ver);
2010:
2011: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');
2012:
2013: topLevel := create_jrad_region (l_region_code, p_plan_id);
2014: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);
2015:

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

2010:
2011: qa_jrad_doc := JDR_DOCBUILDER.createDocument(g_jrad_region_path || l_region_code, 'en-US');
2012:
2013: topLevel := create_jrad_region (l_region_code, p_plan_id);
2014: JDR_DOCBUILDER.setTopLevelElement(qa_jrad_doc, topLevel);
2015:
2016: elmt_counter := 0; --parent-child results inquiry
2017: --initialize counter
2018: OPEN c;

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

2043: p_attribute_code => l_attribute_code,
2044: p_plan_id => p_plan_id,
2045: p_prefix => p_prefix,
2046: p_char_id => l_element_id);
2047: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2048: 'contents', child1);
2049: --contents is the grouping name
2050: -- END IF;
2051:

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

2060: p_attribute_code => l_attribute_code,
2061: p_plan_id => p_plan_id,
2062: p_prefix => p_prefix,
2063: p_char_id => l_element_id);
2064: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2065: 'contents', child1);
2066: --contents is the grouping name
2067: END IF;
2068:

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

2074: child1 := add_special_region_item (p_attribute_code => g_qa_created_by_attribute,
2075: p_plan_id => p_plan_id,
2076: p_prefix => p_prefix,
2077: p_region_code => l_region_code);
2078: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2079: 'contents', child1);
2080:
2081: child1 := add_special_region_item (p_attribute_code => g_collection_id_attribute,
2082: p_plan_id => p_plan_id,

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

2081: child1 := add_special_region_item (p_attribute_code => g_collection_id_attribute,
2082: p_plan_id => p_plan_id,
2083: p_prefix => p_prefix,
2084: p_region_code => l_region_code);
2085: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2086: 'contents', child1);
2087:
2088: child1 := add_special_region_item (p_attribute_code => g_last_update_date_attribute,
2089: p_plan_id => p_plan_id,

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

2088: child1 := add_special_region_item (p_attribute_code => g_last_update_date_attribute,
2089: p_plan_id => p_plan_id,
2090: p_prefix => p_prefix,
2091: p_region_code => l_region_code);
2092: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2093: 'contents', child1);
2094:
2095: -- added for attachments
2096: child1 := add_special_region_item (p_attribute_code => g_multi_row_attachment,

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

2096: child1 := add_special_region_item (p_attribute_code => g_multi_row_attachment,
2097: p_plan_id => p_plan_id,
2098: p_prefix => p_prefix,
2099: p_region_code => l_region_code);
2100: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2101: 'contents', child1);
2102:
2103: -- added for update capability
2104: IF (instr(l_region_code, g_work_vqr_prefix) <> 0)

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

2111: child1 := add_special_region_item (p_attribute_code => g_update_attribute,
2112: p_plan_id => p_plan_id,
2113: p_prefix => p_prefix,
2114: p_region_code => l_region_code);
2115: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2116: 'contents', child1);
2117: END IF;
2118:
2119: -- parent-child

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

2122: child1 := add_special_region_item (p_attribute_code => g_child_url_attribute,
2123: p_plan_id => p_plan_id,
2124: p_prefix => p_prefix,
2125: p_region_code => l_region_code);
2126: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2127: 'contents', child1);
2128:
2129: --below introduced for ui improvement
2130: --link to click and see all coll.elements for a vqr row

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

2137: child1 := add_special_region_item (p_attribute_code => g_vqr_all_elements_url,
2138: p_plan_id => p_plan_id,
2139: p_prefix => p_prefix,
2140: p_region_code => l_region_code);
2141: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,
2142: 'contents', child1);
2143: END IF;
2144: END IF; --end "outer if" stmt: "not" single row parent vqr region
2145:

Line 2146: l_saved := JDR_DOCBUILDER.SAVE;

2142: 'contents', child1);
2143: END IF;
2144: END IF; --end "outer if" stmt: "not" single row parent vqr region
2145:
2146: l_saved := JDR_DOCBUILDER.SAVE;
2147:
2148: --if saved went ok and a previous, lower version document exists
2149: --then try to delete the previous document
2150: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);

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

2147:
2148: --if saved went ok and a previous, lower version document exists
2149: --then try to delete the previous document
2150: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
2151: IF (l_saved = jdr_docbuilder.SUCCESS) AND
2152: (p_jrad_doc_ver > 1) AND
2153: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
2154: jdr_docbuilder.deleteDocument(l_old_doc_name);
2155: END IF;

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

2149: --then try to delete the previous document
2150: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
2151: IF (l_saved = jdr_docbuilder.SUCCESS) AND
2152: (p_jrad_doc_ver > 1) AND
2153: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
2154: jdr_docbuilder.deleteDocument(l_old_doc_name);
2155: END IF;
2156:
2157: --qa_ian_pkg.write_log('VQR Dumping Document(l_saved): "'||g_jrad_region_path || l_region_code||'"('||l_saved||')');

Line 2154: jdr_docbuilder.deleteDocument(l_old_doc_name);

2150: l_old_doc_name := g_jrad_region_path || construct_jrad_code(p_prefix, p_plan_id, p_jrad_doc_ver-1);
2151: IF (l_saved = jdr_docbuilder.SUCCESS) AND
2152: (p_jrad_doc_ver > 1) AND
2153: (jdr_docbuilder.documentExists(l_old_doc_name)) THEN
2154: jdr_docbuilder.deleteDocument(l_old_doc_name);
2155: END IF;
2156:
2157: --qa_ian_pkg.write_log('VQR Dumping Document(l_saved): "'||g_jrad_region_path || l_region_code||'"('||l_saved||')');
2158: --qa_ian_pkg.write_log(jdr_mds_internal.exportsingledocument(jdr_mds_internal.GETDOCUMENTID(g_jrad_region_path || l_region_code, 'DOCUMENT'), true));