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 702: FROM QA_PLAN_CHARS

698: -- in the header region of a multirow block.
699: --
700: SELECT char_id BULK COLLECT INTO elements_array
701: FROM (SELECT char_id
702: FROM QA_PLAN_CHARS
703: WHERE plan_id = p_plan_id
704: AND enabled_flag = 1
705: ORDER BY mandatory_flag, prompt_sequence)
706: WHERE rownum <=5;

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

783: -- Bug 2751198
784: -- Add dependency to LOV only if the element exists in the plan
785: -- This is achieved by adding the following IF statement
786:
787: -- rkaza. 10/22/2003. 3280307. shold not use exists_qa_plan_chars
788: -- array might not have been initialized. use element_in_plan
789: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id, l_parents(i)) THEN
790: IF qa_plan_element_api.element_in_plan(p_plan_id, l_parents(i)) THEN
791: l_lov_attribute_code := g_lov_attribute_dependency || to_char(i);

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

785: -- This is achieved by adding the following IF statement
786:
787: -- rkaza. 10/22/2003. 3280307. shold not use exists_qa_plan_chars
788: -- array might not have been initialized. use element_in_plan
789: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id, l_parents(i)) THEN
790: IF qa_plan_element_api.element_in_plan(p_plan_id, l_parents(i)) THEN
791: l_lov_attribute_code := g_lov_attribute_dependency || to_char(i);
792: --
793: -- MOAC Project. 4637896

Line 1167: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;

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

Line 1168: l_read_only_flag qa_plan_chars.read_only_flag%TYPE;

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

Line 1171: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;

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

Line 1176: --l_prompt qa_plan_chars.prompt%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
1175: -- skolluku Mon Apr 9 04:59:34 PDT 2007
1176: --l_prompt qa_plan_chars.prompt%TYPE;
1177: l_prompt VARCHAR2(100);
1178:
1179: -- Bug 4506400. New variable.
1180: -- srhariha. Mon Aug 29 05:07:41 PDT 2005.

Line 1195: l_show_required_flag qa_plan_chars.mandatory_flag%TYPE;

1191: ppr_event jdr_docbuilder.ELEMENT;
1192:
1193: online_act_flg PLS_INTEGER := 0;
1194:
1195: l_show_required_flag qa_plan_chars.mandatory_flag%TYPE;
1196: c_show_required_flag VARCHAR2(5);
1197: BEGIN
1198: l_displayed_flag := qa_plan_element_api.qpc_displayed_flag(p_plan_id, p_char_id);
1199:

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

Line 1419: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;

1415: -- Bug 4509114. OA Framework Integration project. UT bug fix.
1416: -- "Displayed Flag" not honoured in VQR. Added the following
1417: -- variables.
1418: -- srhariha. Thu Aug 4 21:04:49 PDT 2005.
1419: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1420: c_displayed_flag VARCHAR2(10);
1421:
1422:
1423: l_char_item jdr_docbuilder.ELEMENT;

Line 1577: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;

1573: l_hrd_code VARCHAR2(30);
1574: l_prompt VARCHAR2(30);
1575: l_mode VARCHAR2(15) := g_eqr_advtable_layout;
1576:
1577: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1578: c_mandatory_flag VARCHAR2(5);
1579:
1580: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1581: c_displayed_flag VARCHAR2(10);

Line 1580: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;

1576:
1577: l_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1578: c_mandatory_flag VARCHAR2(5);
1579:
1580: l_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1581: c_displayed_flag VARCHAR2(10);
1582: BEGIN
1583: log_error(g_pkg_name || l_api_name, 'BEGIN');
1584: l_attr_code := construct_code(p_element_prefix, p_char_id);

Line 1718: FROM qa_plan_chars qpc,

1714: l_api_name CONSTANT VARCHAR2(50) := 'ADD_PLAN_CHARS_TO_REGION';
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

Line 2313: FROM qa_plan_chars qpc,

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

Line 2667: qa_plan_chars qpc

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

Line 2869: FROM qa_plan_chars qpc,

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

Line 3483: qa_plan_element_api.refetch_qa_plan_chars(p_plan_id);

3479: -- such as turning mandatory flag on/off will not be
3480: -- immediately reflected in QWB.
3481: -- bso Mon May 1 17:43:03 PDT 2006
3482: --
3483: qa_plan_element_api.refetch_qa_plan_chars(p_plan_id);
3484:
3485: COMMIT;
3486:
3487: END map_on_demand;