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_AK_MAPPING_API dependencies on QA_PLAN_CHARS

Line 250: FROM qa_plan_chars

246: RETURN VARCHAR2 IS
247:
248: CURSOR c IS
249: SELECT prompt
250: FROM qa_plan_chars
251: WHERE plan_id = p_plan_id
252: AND char_id = p_element_id;
253:
254: label qa_plan_chars.prompt%TYPE;

Line 254: label qa_plan_chars.prompt%TYPE;

250: FROM qa_plan_chars
251: WHERE plan_id = p_plan_id
252: AND char_id = p_element_id;
253:
254: label qa_plan_chars.prompt%TYPE;
255:
256: BEGIN
257:
258: -- This functions retrieves the plan char prompt. This is used

Line 275: FROM qa_plan_chars

271: RETURN NUMBER IS
272:
273: CURSOR c IS
274: SELECT prompt_sequence
275: FROM qa_plan_chars
276: WHERE plan_id = p_plan_id
277: AND char_id = p_element_id;
278:
279: sequence qa_plan_chars.prompt_sequence%TYPE;

Line 279: sequence qa_plan_chars.prompt_sequence%TYPE;

275: FROM qa_plan_chars
276: WHERE plan_id = p_plan_id
277: AND char_id = p_element_id;
278:
279: sequence qa_plan_chars.prompt_sequence%TYPE;
280:
281: BEGIN
282:
283: -- This functions retrieves the plan char display sequence.

Line 1667: l_qa_plan_chars_row qa_plan_chars%ROWTYPE;

1663: l_data_type VARCHAR2(30);
1664: l_varchar2_default VARCHAR2(150) DEFAULT null;
1665: l_number_default NUMBER DEFAULT null;
1666: l_date_default DATE DEFAULT null;
1667: l_qa_plan_chars_row qa_plan_chars%ROWTYPE;
1668: l_qa_chars_row qa_chars%ROWTYPE;
1669: l_display_sequence NUMBER;
1670:
1671: err_num NUMBER;

Line 1676: FROM qa_plan_chars

1672: err_msg VARCHAR2(100);
1673:
1674: CURSOR c1 IS
1675: SELECT *
1676: FROM qa_plan_chars
1677: WHERE plan_id = p_plan_id
1678: AND char_id = p_char_id;
1679:
1680: CURSOR c2 IS

Line 1690: FETCH c1 INTO l_qa_plan_chars_row;

1686:
1687: -- This procedure adds a region item to the plan's eqr region.
1688:
1689: OPEN c1;
1690: FETCH c1 INTO l_qa_plan_chars_row;
1691: CLOSE c1;
1692:
1693: OPEN c2;
1694: FETCH c2 INTO l_qa_chars_row;

Line 1716: l_display_flag := convert_flag(l_qa_plan_chars_row.displayed_flag);

1712: END IF;
1713:
1714: l_vo_attribute_name := get_vo_attribute_name(p_char_id, p_plan_id);
1715:
1716: l_display_flag := convert_flag(l_qa_plan_chars_row.displayed_flag);
1717:
1718: l_item_style := compute_item_style(p_appendix, p_char_id);
1719:
1720: l_required_flag := convert_flag(l_qa_plan_chars_row.mandatory_flag);

Line 1720: l_required_flag := convert_flag(l_qa_plan_chars_row.mandatory_flag);

1716: l_display_flag := convert_flag(l_qa_plan_chars_row.displayed_flag);
1717:
1718: l_item_style := compute_item_style(p_appendix, p_char_id);
1719:
1720: l_required_flag := convert_flag(l_qa_plan_chars_row.mandatory_flag);
1721:
1722: IF l_item_style = 'TEXT_INPUT' AND
1723: (qa_plan_element_api.values_exist(p_plan_id, p_char_id)
1724: OR qa_plan_element_api.sql_validation_exists(p_char_id)

Line 1737: l_varchar2_default := l_qa_plan_chars_row.default_value;

1733:
1734: l_data_type := convert_data_type(l_qa_chars_row.datatype);
1735:
1736: IF (l_data_type = 'VARCHAR2') THEN
1737: l_varchar2_default := l_qa_plan_chars_row.default_value;
1738: ELSIF (l_data_type = 'NUMBER') THEN
1739: l_number_default := to_number(l_qa_plan_chars_row.default_value);
1740: ELSE
1741: l_date_default := qltdate.any_to_date(l_qa_plan_chars_row.default_value);

Line 1739: l_number_default := to_number(l_qa_plan_chars_row.default_value);

1735:
1736: IF (l_data_type = 'VARCHAR2') THEN
1737: l_varchar2_default := l_qa_plan_chars_row.default_value;
1738: ELSIF (l_data_type = 'NUMBER') THEN
1739: l_number_default := to_number(l_qa_plan_chars_row.default_value);
1740: ELSE
1741: l_date_default := qltdate.any_to_date(l_qa_plan_chars_row.default_value);
1742: END IF;
1743:

Line 1741: l_date_default := qltdate.any_to_date(l_qa_plan_chars_row.default_value);

1737: l_varchar2_default := l_qa_plan_chars_row.default_value;
1738: ELSIF (l_data_type = 'NUMBER') THEN
1739: l_number_default := to_number(l_qa_plan_chars_row.default_value);
1740: ELSE
1741: l_date_default := qltdate.any_to_date(l_qa_plan_chars_row.default_value);
1742: END IF;
1743:
1744: -- work around needed for a ATG bug
1745: -- hidden items should be at the very end of all region items in a region.

Line 1748: l_display_sequence := l_qa_plan_chars_row.prompt_sequence +

1744: -- work around needed for a ATG bug
1745: -- hidden items should be at the very end of all region items in a region.
1746:
1747: IF (l_item_style = 'HIDDEN') THEN
1748: l_display_sequence := l_qa_plan_chars_row.prompt_sequence +
1749: g_hidden_element_increment;
1750: ELSE
1751: l_display_sequence :=l_qa_plan_chars_row.prompt_sequence;
1752: END IF;

Line 1751: l_display_sequence :=l_qa_plan_chars_row.prompt_sequence;

1747: IF (l_item_style = 'HIDDEN') THEN
1748: l_display_sequence := l_qa_plan_chars_row.prompt_sequence +
1749: g_hidden_element_increment;
1750: ELSE
1751: l_display_sequence :=l_qa_plan_chars_row.prompt_sequence;
1752: END IF;
1753:
1754: AK_REGION_ITEMS_PKG.insert_row (
1755: X_ROWID => l_row_id,

Line 1820: X_CREATED_BY => l_qa_plan_chars_row.created_by,

1816: X_POPLIST_VIEW_USAGE_NAME => null,
1817: X_USER_CUSTOMIZABLE => null, --5.5
1818: X_SORTBY_VIEW_ATTRIBUTE_NAME => null, --5.5
1819: X_CREATION_DATE => g_sysdate,
1820: X_CREATED_BY => l_qa_plan_chars_row.created_by,
1821: X_LAST_UPDATE_DATE => g_sysdate,
1822: X_LAST_UPDATED_BY => l_qa_plan_chars_row.last_updated_by,
1823: X_LAST_UPDATE_LOGIN => l_qa_plan_chars_row.last_updated_by,
1824: X_ATTRIBUTE_CATEGORY => null,

Line 1822: X_LAST_UPDATED_BY => l_qa_plan_chars_row.last_updated_by,

1818: X_SORTBY_VIEW_ATTRIBUTE_NAME => null, --5.5
1819: X_CREATION_DATE => g_sysdate,
1820: X_CREATED_BY => l_qa_plan_chars_row.created_by,
1821: X_LAST_UPDATE_DATE => g_sysdate,
1822: X_LAST_UPDATED_BY => l_qa_plan_chars_row.last_updated_by,
1823: X_LAST_UPDATE_LOGIN => l_qa_plan_chars_row.last_updated_by,
1824: X_ATTRIBUTE_CATEGORY => null,
1825: X_ATTRIBUTE1 => null,
1826: X_ATTRIBUTE2 => null,

Line 1823: X_LAST_UPDATE_LOGIN => l_qa_plan_chars_row.last_updated_by,

1819: X_CREATION_DATE => g_sysdate,
1820: X_CREATED_BY => l_qa_plan_chars_row.created_by,
1821: X_LAST_UPDATE_DATE => g_sysdate,
1822: X_LAST_UPDATED_BY => l_qa_plan_chars_row.last_updated_by,
1823: X_LAST_UPDATE_LOGIN => l_qa_plan_chars_row.last_updated_by,
1824: X_ATTRIBUTE_CATEGORY => null,
1825: X_ATTRIBUTE1 => null,
1826: X_ATTRIBUTE2 => null,
1827: X_ATTRIBUTE3 => null,

Line 2465: FROM qa_plan_chars

2461: err_msg VARCHAR2(100);
2462:
2463: CURSOR c IS
2464: SELECT char_id
2465: FROM qa_plan_chars
2466: WHERE plan_id = x_plan_id
2467: AND enabled_flag = 1;
2468:
2469: BEGIN

Line 2629: FROM qa_plan_chars

2625: elmt_counter NUMBER;--parent-child results inquiry
2626:
2627: CURSOR c IS
2628: SELECT char_id
2629: FROM qa_plan_chars
2630: WHERE plan_id = x_plan_id
2631: AND enabled_flag = 1
2632: ORDER BY PROMPT_SEQUENCE;
2633: