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_SSQR_JRAD_PKG dependencies on QA_CHARS

Line 274: or qa_chars_api.datatype(p_element_id) = g_seq_datatype THEN

270:
271: BEGIN
272:
273: IF qa_plan_element_api.qpc_read_only_flag(p_plan_id, p_element_id) = 1
274: or qa_chars_api.datatype(p_element_id) = g_seq_datatype THEN
275: return 'messageStyledText';
276: ELSIF qa_plan_element_api.qpc_poplist_flag(p_plan_id,
277: p_element_id) = 1 then
278: return 'messageChoice';

Line 281: OR qa_chars_api.has_hardcoded_lov(p_element_id)) THEN

277: p_element_id) = 1 then
278: return 'messageChoice';
279: ELSIF (qa_plan_element_api.values_exist(p_plan_id, p_element_id)
280: OR qa_plan_element_api.sql_validation_exists(p_element_id)
281: OR qa_chars_api.has_hardcoded_lov(p_element_id)) THEN
282: return 'messageLovInput';
283: ELSE
284: return 'messageTextInput';
285: END IF;

Line 675: return qa_chars_api.hardcoded_column(p_id);

671: -- ntungare
672: --
673: IF(p_id = qa_ss_const.po_number OR
674: p_id = qa_ss_const.party_name) THEN
675: return qa_chars_api.hardcoded_column(p_id);
676: END IF;
677:
678: return construct_code(p_element_prefix,p_id);
679:

Line 875: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);

871: l_id_elem jdr_docbuilder.ELEMENT := NULL;
872:
873: BEGIN
874:
875: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
876: l_id_elem := create_jrad_region_item('formValue');
877:
878: -- set properties
879: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);

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

980:
981: -- po_header_id
982: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
983: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
984: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
985: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
986: lovMap);
987: --
988: -- bug 5383667

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

997:
998: -- PartyId
999: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1000: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1001: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1002: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1003: lovMap);
1004:
1005: END IF; -- PO Number

Line 1169: l_datatype qa_chars.datatype%TYPE;

1165: c_read_only_flag VARCHAR2(5);
1166:
1167: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1168: l_read_only_flag qa_plan_chars.read_only_flag%TYPE;
1169: l_datatype qa_chars.datatype%TYPE;
1170: l_data_entry_hint qa_chars.data_entry_hint%TYPE := null;
1171: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1172: -- Bug 5926317
1173: -- Changing the length of the local variable l_prompt

Line 1170: l_data_entry_hint qa_chars.data_entry_hint%TYPE := null;

1166:
1167: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1168: l_read_only_flag qa_plan_chars.read_only_flag%TYPE;
1169: l_datatype qa_chars.datatype%TYPE;
1170: l_data_entry_hint qa_chars.data_entry_hint%TYPE := null;
1171: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1172: -- Bug 5926317
1173: -- Changing the length of the local variable l_prompt
1174: -- to a higher value - 100 and commenting out the existing code

Line 1225: l_datatype := qa_chars_api.datatype(p_char_id);

1221: l_mandatory_flag := qa_plan_element_api.qpc_mandatory_flag(p_plan_id, p_char_id);
1222: END IF;
1223:
1224: l_prompt := get_prompt(p_plan_id, p_char_id);
1225: l_datatype := qa_chars_api.datatype(p_char_id);
1226: l_data_entry_hint := qa_chars_api.data_entry_hint(p_char_id);
1227: l_read_only_flag := qa_plan_element_api.qpc_read_only_flag(p_plan_id, p_char_id);
1228:
1229: l_attribute_code := construct_code(p_element_prefix, p_char_id);

Line 1226: l_data_entry_hint := qa_chars_api.data_entry_hint(p_char_id);

1222: END IF;
1223:
1224: l_prompt := get_prompt(p_plan_id, p_char_id);
1225: l_datatype := qa_chars_api.datatype(p_char_id);
1226: l_data_entry_hint := qa_chars_api.data_entry_hint(p_char_id);
1227: l_read_only_flag := qa_plan_element_api.qpc_read_only_flag(p_plan_id, p_char_id);
1228:
1229: l_attribute_code := construct_code(p_element_prefix, p_char_id);
1230: l_item_style := compute_item_style(p_plan_id, p_char_id);

Line 1407: l_datatype qa_chars.datatype%TYPE;

1403:
1404: l_attribute_code VARCHAR2(30);
1405: l_item_style VARCHAR2(30) DEFAULT 'messageStyledText';
1406: l_vo_attribute_name VARCHAR2(30);
1407: l_datatype qa_chars.datatype%TYPE;
1408: -- Bug 5926317
1409: -- Changing the length of the local variable l_prompt
1410: -- to a higher value - 100 and commenting out the existing code
1411: -- skolluku Mon Apr 9 04:59:34 PDT 2007

Line 1428: l_datatype := qa_chars_api.datatype(p_char_id);

1424:
1425: BEGIN
1426: l_prompt := get_prompt(p_plan_id, p_char_id);
1427: l_attribute_code := construct_code(p_element_prefix, p_char_id);
1428: l_datatype := qa_chars_api.datatype(p_char_id);
1429:
1430: l_char_item := create_jrad_region_item(l_item_style);
1431: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1432: -- "Displayed Flag" not honoured in VQR. Get the displayed flag.

Line 1719: qa_chars qc

1715:
1716: CURSOR c IS
1717: SELECT qpc.char_id
1718: FROM qa_plan_chars qpc,
1719: qa_chars qc
1720: WHERE qc.char_id = qpc.char_id
1721: AND qpc.enabled_flag = 1
1722: AND qpc.plan_id = p_plan_id
1723: AND ((p_char_type = 'NonComments' AND qc.datatype <> g_comments_datatype) OR

Line 2314: qa_chars qc,

2310:
2311: CURSOR c IS
2312: SELECT qpc.char_id
2313: FROM qa_plan_chars qpc,
2314: qa_chars qc,
2315: qa_device_info qdi
2316: WHERE qc.char_id = qpc.char_id
2317: AND nvl(qpc.enabled_flag, 2) = 1
2318: AND nvl(qpc.device_flag, 2) = 1

Line 2666: from qa_chars qc,

2662: l_vo_attr_name VARCHAR2(50);
2663: BEGIN
2664: select upper(translate(qc.name,' ''*{}','_____'))
2665: into l_vo_attr_name
2666: from qa_chars qc,
2667: qa_plan_chars qpc
2668: where qc.char_id = qpc.char_id
2669: and qpc.plan_id = p_plan_id
2670: and qpc.char_id = p_char_id;

Line 2715: l_datatype qa_chars.datatype%TYPE;

2711: l_char_item JDR_DOCBUILDER.ELEMENT;
2712: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2713: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2714:
2715: l_datatype qa_chars.datatype%TYPE;
2716:
2717:
2718: BEGIN
2719: l_attr_code := construct_code(g_element_prefix, p_char_id);

Line 2752: l_datatype := qa_chars_api.datatype(p_char_id);

2748: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2749: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2750: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2751:
2752: l_datatype := qa_chars_api.datatype(p_char_id);
2753: c_datatype := convert_data_type(l_datatype);
2754: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2755:
2756: -- jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);

Line 2870: qa_chars qc

2866:
2867: CURSOR plan_chars (p_char_type VARCHAR2)IS
2868: SELECT qpc.char_id
2869: FROM qa_plan_chars qpc,
2870: qa_chars qc
2871: WHERE qc.char_id = qpc.char_id
2872: AND qpc.enabled_flag = 1
2873: AND qpc.plan_id = p_plan_id
2874: AND ((p_char_type = 'NonComments' AND qc.datatype <> g_comments_datatype) OR