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 725: return qa_chars_api.hardcoded_column(p_id);

721: -- ntungare
722: --
723: IF(p_id = qa_ss_const.po_number OR
724: p_id = qa_ss_const.party_name) THEN
725: return qa_chars_api.hardcoded_column(p_id);
726: END IF;
727:
728: return construct_code(p_element_prefix,p_id);
729:

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

921: l_id_elem jdr_docbuilder.ELEMENT := NULL;
922:
923: BEGIN
924:
925: l_vo_attribute_name := qa_chars_api.hardcoded_column(p_char_id);
926: l_id_elem := create_jrad_region_item('formValue');
927:
928: -- set properties
929: jdr_docbuilder.setAttribute(l_id_elem, 'id', l_vo_attribute_name);

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

1030:
1031: -- po_header_id
1032: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1033: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PoHeaderId');
1034: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1035: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1036: lovMap);
1037: --
1038: -- bug 5383667

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

1047:
1048: -- PartyId
1049: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1050: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyId');
1051: jdr_docbuilder.setAttribute(lovMap, 'resultTo', qa_chars_api.hardcoded_column(p_char_id));
1052: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1053: lovMap);
1054:
1055: END IF; -- PO Number

Line 1219: l_datatype qa_chars.datatype%TYPE;

1215: c_read_only_flag VARCHAR2(5);
1216:
1217: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1218: l_read_only_flag qa_plan_chars.read_only_flag%TYPE;
1219: l_datatype qa_chars.datatype%TYPE;
1220: l_data_entry_hint qa_chars.data_entry_hint%TYPE := null;
1221: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1222: -- Bug 5926317
1223: -- Changing the length of the local variable l_prompt

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

1216:
1217: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1218: l_read_only_flag qa_plan_chars.read_only_flag%TYPE;
1219: l_datatype qa_chars.datatype%TYPE;
1220: l_data_entry_hint qa_chars.data_entry_hint%TYPE := null;
1221: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1222: -- Bug 5926317
1223: -- Changing the length of the local variable l_prompt
1224: -- to a higher value - 100 and commenting out the existing code

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

1271: l_mandatory_flag := qa_plan_element_api.qpc_mandatory_flag(p_plan_id, p_char_id);
1272: END IF;
1273:
1274: l_prompt := get_prompt(p_plan_id, p_char_id);
1275: l_datatype := qa_chars_api.datatype(p_char_id);
1276: l_data_entry_hint := qa_chars_api.data_entry_hint(p_char_id);
1277: l_read_only_flag := qa_plan_element_api.qpc_read_only_flag(p_plan_id, p_char_id);
1278:
1279: l_attribute_code := construct_code(p_element_prefix, p_char_id);

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

1272: END IF;
1273:
1274: l_prompt := get_prompt(p_plan_id, p_char_id);
1275: l_datatype := qa_chars_api.datatype(p_char_id);
1276: l_data_entry_hint := qa_chars_api.data_entry_hint(p_char_id);
1277: l_read_only_flag := qa_plan_element_api.qpc_read_only_flag(p_plan_id, p_char_id);
1278:
1279: l_attribute_code := construct_code(p_element_prefix, p_char_id);
1280: l_item_style := compute_item_style(p_plan_id, p_char_id);

Line 1457: l_datatype qa_chars.datatype%TYPE;

1453:
1454: l_attribute_code VARCHAR2(30);
1455: l_item_style VARCHAR2(30) DEFAULT 'messageStyledText';
1456: l_vo_attribute_name VARCHAR2(30);
1457: l_datatype qa_chars.datatype%TYPE;
1458: -- Bug 5926317
1459: -- Changing the length of the local variable l_prompt
1460: -- to a higher value - 100 and commenting out the existing code
1461: -- skolluku Mon Apr 9 04:59:34 PDT 2007

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

1474:
1475: BEGIN
1476: l_prompt := get_prompt(p_plan_id, p_char_id);
1477: l_attribute_code := construct_code(p_element_prefix, p_char_id);
1478: l_datatype := qa_chars_api.datatype(p_char_id);
1479:
1480: l_char_item := create_jrad_region_item(l_item_style);
1481: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1482: -- "Displayed Flag" not honoured in VQR. Get the displayed flag.

Line 1787: qa_chars qc

1783: --
1784: CURSOR c IS
1785: SELECT qpc.char_id
1786: FROM qa_plan_chars qpc,
1787: qa_chars qc
1788: WHERE qc.char_id = qpc.char_id
1789: AND qpc.enabled_flag = 1
1790: AND qpc.plan_id = p_plan_id
1791: AND ((p_char_type = 'NonComments' AND qc.datatype <> g_comments_datatype) OR

Line 2409: qa_chars qc,

2405:
2406: CURSOR c IS
2407: SELECT qpc.char_id
2408: FROM qa_plan_chars qpc,
2409: qa_chars qc,
2410: qa_device_info qdi
2411: WHERE qc.char_id = qpc.char_id
2412: AND nvl(qpc.enabled_flag, 2) = 1
2413: AND nvl(qpc.device_flag, 2) = 1

Line 2761: from qa_chars qc,

2757: l_vo_attr_name VARCHAR2(50);
2758: BEGIN
2759: select upper(translate(qc.name,' ''*{}','_____'))
2760: into l_vo_attr_name
2761: from qa_chars qc,
2762: qa_plan_chars qpc
2763: where qc.char_id = qpc.char_id
2764: and qpc.plan_id = p_plan_id
2765: and qpc.char_id = p_char_id;

Line 2810: l_datatype qa_chars.datatype%TYPE;

2806: l_char_item JDR_DOCBUILDER.ELEMENT;
2807: l_char_dtl_item JDR_DOCBUILDER.ELEMENT;
2808: l_sort_hdr JDR_DOCBUILDER.ELEMENT;
2809:
2810: l_datatype qa_chars.datatype%TYPE;
2811:
2812:
2813: BEGIN
2814: l_attr_code := construct_code(g_element_prefix, p_char_id);

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

2843: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortable' , 'yes');
2844: jdr_docbuilder.setAttribute(l_sort_hdr, 'sortState' , 'yes');
2845: add_child_to_parent(l_col_hdr, l_sort_hdr, 'columnHeader');
2846:
2847: l_datatype := qa_chars_api.datatype(p_char_id);
2848: c_datatype := convert_data_type(l_datatype);
2849: jdr_docbuilder.setAttribute(l_char_dtl_item, 'styleClass', 'OraTableDetail');
2850:
2851: -- jdr_docbuilder.setAttribute(l_char_item, 'dataType', c_datatype);

Line 2965: qa_chars qc

2961:
2962: CURSOR plan_chars (p_char_type VARCHAR2)IS
2963: SELECT qpc.char_id
2964: FROM qa_plan_chars qpc,
2965: qa_chars qc
2966: WHERE qc.char_id = qpc.char_id
2967: AND qpc.enabled_flag = 1
2968: AND qpc.plan_id = p_plan_id
2969: AND ((p_char_type = 'NonComments' AND qc.datatype <> g_comments_datatype) OR