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_PLAN_CHARS

Line 100: l_prompt qa_plan_chars.prompt%TYPE;

96:
97: FUNCTION get_prompt (p_plan_id IN NUMBER,
98: p_char_id IN NUMBER) RETURN VARCHAR2 IS
99:
100: l_prompt qa_plan_chars.prompt%TYPE;
101: l_uom_code qa_plan_chars.uom_code%TYPE;
102: BEGIN
103: -- The function is the standard way to compute prompt
104: -- taking uom_code into account

Line 101: l_uom_code qa_plan_chars.uom_code%TYPE;

97: FUNCTION get_prompt (p_plan_id IN NUMBER,
98: p_char_id IN NUMBER) RETURN VARCHAR2 IS
99:
100: l_prompt qa_plan_chars.prompt%TYPE;
101: l_uom_code qa_plan_chars.uom_code%TYPE;
102: BEGIN
103: -- The function is the standard way to compute prompt
104: -- taking uom_code into account
105: l_prompt := qa_plan_element_api.get_prompt(p_plan_id, p_char_id);

Line 161: -- For others, it returns results column name in qa plan chars.

157:
158: BEGIN
159:
160: -- For hardcoded elements, it returns developer name,
161: -- For others, it returns results column name in qa plan chars.
162:
163: column_name := qa_core_pkg.get_result_column_name (p_char_id, p_plan_id);
164: column_name := replace(column_name, 'CHARACTER', 'Character');
165: column_name := replace(column_name, 'COMMENT', 'Comment');

Line 752: FROM QA_PLAN_CHARS

748: -- in the header region of a multirow block.
749: --
750: SELECT char_id BULK COLLECT INTO elements_array
751: FROM (SELECT char_id
752: FROM QA_PLAN_CHARS
753: WHERE plan_id = p_plan_id
754: AND enabled_flag = 1
755: ORDER BY mandatory_flag, prompt_sequence)
756: WHERE rownum <=5;

Line 837: -- rkaza. 10/22/2003. 3280307. shold not use exists_qa_plan_chars

833: -- Bug 2751198
834: -- Add dependency to LOV only if the element exists in the plan
835: -- This is achieved by adding the following IF statement
836:
837: -- rkaza. 10/22/2003. 3280307. shold not use exists_qa_plan_chars
838: -- array might not have been initialized. use element_in_plan
839: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id, l_parents(i)) THEN
840: IF qa_plan_element_api.element_in_plan(p_plan_id, l_parents(i)) THEN
841: l_lov_attribute_code := g_lov_attribute_dependency || to_char(i);

Line 839: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id, l_parents(i)) THEN

835: -- This is achieved by adding the following IF statement
836:
837: -- rkaza. 10/22/2003. 3280307. shold not use exists_qa_plan_chars
838: -- array might not have been initialized. use element_in_plan
839: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id, l_parents(i)) THEN
840: IF qa_plan_element_api.element_in_plan(p_plan_id, l_parents(i)) THEN
841: l_lov_attribute_code := g_lov_attribute_dependency || to_char(i);
842: --
843: -- MOAC Project. 4637896

Line 1217: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;

1213: c_datatype VARCHAR2(30);
1214: c_mandatory_flag VARCHAR2(5);
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;

Line 1218: l_read_only_flag qa_plan_chars.read_only_flag%TYPE;

1214: c_mandatory_flag VARCHAR2(5);
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

Line 1221: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;

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
1225: -- skolluku Mon Apr 9 04:59:34 PDT 2007

Line 1226: --l_prompt qa_plan_chars.prompt%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
1225: -- skolluku Mon Apr 9 04:59:34 PDT 2007
1226: --l_prompt qa_plan_chars.prompt%TYPE;
1227: l_prompt VARCHAR2(100);
1228:
1229: -- Bug 4506400. New variable.
1230: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.

Line 1245: l_show_required_flag qa_plan_chars.mandatory_flag%TYPE;

1241: ppr_event jdr_docbuilder.ELEMENT;
1242:
1243: online_act_flg PLS_INTEGER := 0;
1244:
1245: l_show_required_flag qa_plan_chars.mandatory_flag%TYPE;
1246: c_show_required_flag VARCHAR2(5);
1247: BEGIN
1248: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1249:

Line 1462: --l_prompt qa_plan_chars.prompt%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
1462: --l_prompt qa_plan_chars.prompt%TYPE;
1463: l_prompt VARCHAR2(100);
1464:
1465: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1466: -- "Displayed Flag" not honoured in VQR. Added the following

Line 1469: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;

1465: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1466: -- "Displayed Flag" not honoured in VQR. Added the following
1467: -- variables.
1468: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1469: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1470: c_displayed_flag VARCHAR2(10);
1471:
1472:
1473: l_char_item jdr_docbuilder.ELEMENT;

Line 1627: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;

1623: l_hrd_code VARCHAR2(30);
1624: l_prompt VARCHAR2(30);
1625: l_mode VARCHAR2(15) := g_eqr_advtable_layout;
1626:
1627: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1628: c_mandatory_flag VARCHAR2(5);
1629:
1630: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1631: c_displayed_flag VARCHAR2(10);

Line 1630: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;

1626:
1627: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1628: c_mandatory_flag VARCHAR2(5);
1629:
1630: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1631: c_displayed_flag VARCHAR2(10);
1632: BEGIN
1633: log_error(g_pkg_name || l_api_name, 'BEGIN');
1634: l_attr_code := construct_code(p_element_prefix, p_char_id);

Line 1786: FROM qa_plan_chars qpc,

1782: -- skolluku
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

Line 2408: FROM qa_plan_chars qpc,

2404: l_attribute_code VARCHAR2(30);
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

Line 2762: qa_plan_chars qpc

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;
2766:

Line 2964: FROM qa_plan_chars qpc,

2960:
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

Line 3587: qa_plan_element_api.refetch_qa_plan_chars(p_plan_id);

3583: -- such as turning mandatory flag on/off will not be
3584: -- immediately reflected in QWB.
3585: -- bso Mon May 1 17:43:03 PDT 2006
3586: --
3587: qa_plan_element_api.refetch_qa_plan_chars(p_plan_id);
3588:
3589: COMMIT;
3590:
3591: END map_on_demand;