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 966: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id,

962: -- anagarwa
963: -- Bug 2751198
964: -- Add dependency to LOV only if the element exists in the plan
965: -- This is achieved by adding the following IF statement
966: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id,
967: -- l_parents(i)) THEN
968:
969: -- rkaza. 10/22/2003. 3209804. shold not use exists_qa_plan_chars
970: -- array might not have been initialized. use element_in_plan

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

965: -- This is achieved by adding the following IF statement
966: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id,
967: -- l_parents(i)) THEN
968:
969: -- rkaza. 10/22/2003. 3209804. shold not use exists_qa_plan_chars
970: -- array might not have been initialized. use element_in_plan
971:
972: IF qa_plan_element_api.element_in_plan(p_plan_id,
973: l_parents(i)) THEN

Line 1184: l_prompt qa_plan_chars.prompt%TYPE;

1180: -- Added this function to get the prompt and concatenate the UOM
1181: FUNCTION get_prompt (p_plan_id IN NUMBER,
1182: p_char_id IN NUMBER) RETURN VARCHAR2 IS
1183:
1184: l_prompt qa_plan_chars.prompt%TYPE;
1185: l_uom_code qa_plan_chars.uom_code%TYPE;
1186: BEGIN
1187: -- The function is the standard way to compute prompt
1188: -- taking uom_code into account

Line 1185: l_uom_code qa_plan_chars.uom_code%TYPE;

1181: FUNCTION get_prompt (p_plan_id IN NUMBER,
1182: p_char_id IN NUMBER) RETURN VARCHAR2 IS
1183:
1184: l_prompt qa_plan_chars.prompt%TYPE;
1185: l_uom_code qa_plan_chars.uom_code%TYPE;
1186: BEGIN
1187: -- The function is the standard way to compute prompt
1188: -- taking uom_code into account
1189: l_prompt := qa_plan_element_api.get_prompt(p_plan_id, p_char_id);

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

1202: p_plan_id IN NUMBER,
1203: p_prefix IN VARCHAR2) RETURN JDR_DOCBUILDER.ELEMENT IS
1204:
1205: -- Bug 3769260. shkalyan 29 July 2004.
1206: -- Removed these attributes since the cursor to get from qa_plan_chars
1207: -- and qa_chars are removed.
1208: /*
1209: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1210: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;

Line 1209: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;

1205: -- Bug 3769260. shkalyan 29 July 2004.
1206: -- Removed these attributes since the cursor to get from qa_plan_chars
1207: -- and qa_chars are removed.
1208: /*
1209: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1210: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1211: c_prompt qa_plan_chars.prompt%TYPE;
1212: c_char_name qa_chars.name%TYPE;
1213: c_datatype qa_chars.datatype%TYPE;

Line 1210: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;

1206: -- Removed these attributes since the cursor to get from qa_plan_chars
1207: -- and qa_chars are removed.
1208: /*
1209: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1210: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1211: c_prompt qa_plan_chars.prompt%TYPE;
1212: c_char_name qa_chars.name%TYPE;
1213: c_datatype qa_chars.datatype%TYPE;
1214: c_readonly_flag NUMBER;

Line 1211: c_prompt qa_plan_chars.prompt%TYPE;

1207: -- and qa_chars are removed.
1208: /*
1209: c_displayed_flag qa_plan_chars.displayed_flag%TYPE;
1210: c_mandatory_flag qa_plan_chars.mandatory_flag%TYPE;
1211: c_prompt qa_plan_chars.prompt%TYPE;
1212: c_char_name qa_chars.name%TYPE;
1213: c_datatype qa_chars.datatype%TYPE;
1214: c_readonly_flag NUMBER;
1215: */

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

1224: -- Bug 6491622
1225: -- Changing the length of the local variable l_prompt
1226: -- to a higher value - 100 and commenting out the existing code
1227: -- bhsankar Tue Oct 16 23:21:38 PDT 2007
1228: -- l_prompt qa_plan_chars.prompt%TYPE;
1229: l_prompt VARCHAR2(100);
1230:
1231: child1 jdr_docbuilder.ELEMENT;
1232:

Line 1244: FROM qa_plan_chars

1240: -- and qa_plan_element_api are used instead.
1241: /*
1242: CURSOR c1 IS
1243: SELECT displayed_flag, mandatory_flag, prompt, read_only_flag
1244: FROM qa_plan_chars
1245: WHERE plan_id = p_plan_id
1246: AND char_id = p_char_id;
1247:
1248: CURSOR c2 IS

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

1400: l_data_type := convert_data_type(qa_chars_api.datatype(p_char_id));
1401:
1402: -- Bug 3769260. shkalyan 29 July 2004.
1403: -- Removed the get_label function which was getting prompt from
1404: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache
1405:
1406: -- Bug 5455658. SHKALYAN 20-Sep-2006
1407: -- modified to invoke a local function which calls
1408: -- qa_plan_element_api.get_prompt and concatenates the UOM

Line 1713: FROM qa_plan_chars

1709: l_id_item JDR_DOCBUILDER.ELEMENT := NULL;
1710:
1711: CURSOR c IS
1712: SELECT char_id
1713: FROM qa_plan_chars
1714: WHERE plan_id = p_plan_id
1715: AND enabled_flag = 1;
1716:
1717: BEGIN

Line 1900: FROM qa_plan_chars

1896: child1 JDR_DOCBUILDER.ELEMENT := NULL;
1897:
1898: CURSOR c IS
1899: SELECT char_id
1900: FROM qa_plan_chars
1901: WHERE plan_id = p_plan_id
1902: AND enabled_flag = 1
1903: ORDER BY PROMPT_SEQUENCE;
1904: