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 QA_PLAN_CHARS

Line 262: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache

258: END retrieve_id;
259:
260: -- Bug 3769260. shkalyan 29 July 2004.
261: -- Removed the get_label function which was getting prompt from
262: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache
263:
264: /*
265: FUNCTION get_label (p_plan_id IN NUMBER, p_element_id IN NUMBER)
266: RETURN VARCHAR2 IS

Line 270: FROM qa_plan_chars

266: RETURN VARCHAR2 IS
267:
268: CURSOR c IS
269: SELECT prompt
270: FROM qa_plan_chars
271: WHERE plan_id = p_plan_id
272: AND char_id = p_element_id;
273:
274: label qa_plan_chars.prompt%TYPE;

Line 274: label qa_plan_chars.prompt%TYPE;

270: FROM qa_plan_chars
271: WHERE plan_id = p_plan_id
272: AND char_id = p_element_id;
273:
274: label qa_plan_chars.prompt%TYPE;
275:
276: BEGIN
277:
278: -- This functions retrieves the plan char prompt. This is used

Line 996: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id,

992: -- anagarwa
993: -- Bug 2751198
994: -- Add dependency to LOV only if the element exists in the plan
995: -- This is achieved by adding the following IF statement
996: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id,
997: -- l_parents(i)) THEN
998:
999: -- rkaza. 10/22/2003. 3209804. shold not use exists_qa_plan_chars
1000: -- array might not have been initialized. use element_in_plan

Line 999: -- rkaza. 10/22/2003. 3209804. shold not use exists_qa_plan_chars

995: -- This is achieved by adding the following IF statement
996: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id,
997: -- l_parents(i)) THEN
998:
999: -- rkaza. 10/22/2003. 3209804. shold not use exists_qa_plan_chars
1000: -- array might not have been initialized. use element_in_plan
1001:
1002: IF qa_plan_element_api.element_in_plan(p_plan_id,
1003: l_parents(i)) THEN

Line 1214: l_prompt qa_plan_chars.prompt%TYPE;

1210: -- Added this function to get the prompt and concatenate the UOM
1211: FUNCTION get_prompt (p_plan_id IN NUMBER,
1212: p_char_id IN NUMBER) RETURN VARCHAR2 IS
1213:
1214: l_prompt qa_plan_chars.prompt%TYPE;
1215: l_uom_code qa_plan_chars.uom_code%TYPE;
1216: BEGIN
1217: -- The function is the standard way to compute prompt
1218: -- taking uom_code into account

Line 1215: l_uom_code qa_plan_chars.uom_code%TYPE;

1211: FUNCTION get_prompt (p_plan_id IN NUMBER,
1212: p_char_id IN NUMBER) RETURN VARCHAR2 IS
1213:
1214: l_prompt qa_plan_chars.prompt%TYPE;
1215: l_uom_code qa_plan_chars.uom_code%TYPE;
1216: BEGIN
1217: -- The function is the standard way to compute prompt
1218: -- taking uom_code into account
1219: l_prompt := qa_plan_element_api.get_prompt(p_plan_id, p_char_id);

Line 1236: -- Removed these attributes since the cursor to get from qa_plan_chars

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.
1238: /*
1239: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1240: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;

Line 1239: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;

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.
1238: /*
1239: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1240: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1241: c_prompt qa_plan_chars.prompt%TYPE;
1242: c_char_name qa_chars.name%TYPE;
1243: c_datatype qa_chars.datatype%TYPE;

Line 1240: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;

1236: -- Removed these attributes since the cursor to get from qa_plan_chars
1237: -- and qa_chars are removed.
1238: /*
1239: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1240: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1241: c_prompt qa_plan_chars.prompt%TYPE;
1242: c_char_name qa_chars.name%TYPE;
1243: c_datatype qa_chars.datatype%TYPE;
1244: c_readonly_flag NUMBER;

Line 1241: c_prompt qa_plan_chars.prompt%TYPE;

1237: -- and qa_chars are removed.
1238: /*
1239: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1240: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1241: c_prompt qa_plan_chars.prompt%TYPE;
1242: c_char_name qa_chars.name%TYPE;
1243: c_datatype qa_chars.datatype%TYPE;
1244: c_readonly_flag NUMBER;
1245: */

Line 1258: -- l_prompt qa_plan_chars.prompt%TYPE;

1254: -- Bug 6491622
1255: -- Changing the length of the local variable l_prompt
1256: -- to a higher value - 100 and commenting out the existing code
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:

Line 1274: FROM qa_plan_chars

1270: -- and qa_plan_element_api are used instead.
1271: /*
1272: CURSOR c1 IS
1273: SELECT displayed_flag, mandatory_flag, prompt, read_only_flag
1274: FROM qa_plan_chars
1275: WHERE plan_id = p_plan_id
1276: AND char_id = p_char_id;
1277:
1278: CURSOR c2 IS

Line 1461: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache

1457: l_data_type := convert_data_type(qa_chars_api.datatype(p_char_id));
1458:
1459: -- Bug 3769260. shkalyan 29 July 2004.
1460: -- Removed the get_label function which was getting prompt from
1461: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache
1462:
1463: -- Bug 5455658. SHKALYAN 20-Sep-2006
1464: -- modified to invoke a local function which calls
1465: -- qa_plan_element_api.get_prompt and concatenates the UOM

Line 1797: FROM qa_plan_chars

1793: -- elements at the end.
1794: -- skolluku
1795: CURSOR c IS
1796: SELECT char_id
1797: FROM qa_plan_chars
1798: WHERE plan_id = p_plan_id
1799: AND enabled_flag = 1 ORDER BY displayed_flag, prompt_sequence;
1800:
1801: BEGIN

Line 1999: FROM qa_plan_chars

1995: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1996:
1997: CURSOR c IS
1998: SELECT char_id
1999: FROM qa_plan_chars
2000: WHERE plan_id = p_plan_id
2001: AND enabled_flag = 1
2002: ORDER BY PROMPT_SEQUENCE;
2003: