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_CHARS

Line 1135: l_qa_chars_row qa_chars%ROWTYPE;

1131: l_created_by OUT NOCOPY NUMBER,
1132: l_last_updated_by OUT NOCOPY NUMBER,
1133: l_last_update_login OUT NOCOPY NUMBER) IS
1134:
1135: l_qa_chars_row qa_chars%ROWTYPE;
1136:
1137: CURSOR c IS
1138: SELECT * from qa_chars
1139: WHERE char_id = p_char_id;

Line 1138: SELECT * from qa_chars

1134:
1135: l_qa_chars_row qa_chars%ROWTYPE;
1136:
1137: CURSOR c IS
1138: SELECT * from qa_chars
1139: WHERE char_id = p_char_id;
1140:
1141: BEGIN
1142:

Line 1149: FETCH c INTO l_qa_chars_row;

1145: -- information in ak tables. This function retrieves those
1146: -- relevant information.
1147:
1148: OPEN c;
1149: FETCH c INTO l_qa_chars_row;
1150: CLOSE c;
1151:
1152: l_data_type := convert_data_type(l_qa_chars_row.datatype);
1153: l_label_length := length(l_qa_chars_row.prompt);

Line 1152: l_data_type := convert_data_type(l_qa_chars_row.datatype);

1148: OPEN c;
1149: FETCH c INTO l_qa_chars_row;
1150: CLOSE c;
1151:
1152: l_data_type := convert_data_type(l_qa_chars_row.datatype);
1153: l_label_length := length(l_qa_chars_row.prompt);
1154: l_name := l_qa_chars_row.name;
1155: l_label := l_qa_chars_row.prompt;
1156: l_item_style := 'TEXT_INPUT';

Line 1153: l_label_length := length(l_qa_chars_row.prompt);

1149: FETCH c INTO l_qa_chars_row;
1150: CLOSE c;
1151:
1152: l_data_type := convert_data_type(l_qa_chars_row.datatype);
1153: l_label_length := length(l_qa_chars_row.prompt);
1154: l_name := l_qa_chars_row.name;
1155: l_label := l_qa_chars_row.prompt;
1156: l_item_style := 'TEXT_INPUT';
1157: l_default_value := l_qa_chars_row.default_value;

Line 1154: l_name := l_qa_chars_row.name;

1150: CLOSE c;
1151:
1152: l_data_type := convert_data_type(l_qa_chars_row.datatype);
1153: l_label_length := length(l_qa_chars_row.prompt);
1154: l_name := l_qa_chars_row.name;
1155: l_label := l_qa_chars_row.prompt;
1156: l_item_style := 'TEXT_INPUT';
1157: l_default_value := l_qa_chars_row.default_value;
1158: l_created_by := l_qa_chars_row.created_by;

Line 1155: l_label := l_qa_chars_row.prompt;

1151:
1152: l_data_type := convert_data_type(l_qa_chars_row.datatype);
1153: l_label_length := length(l_qa_chars_row.prompt);
1154: l_name := l_qa_chars_row.name;
1155: l_label := l_qa_chars_row.prompt;
1156: l_item_style := 'TEXT_INPUT';
1157: l_default_value := l_qa_chars_row.default_value;
1158: l_created_by := l_qa_chars_row.created_by;
1159: l_last_updated_by := l_qa_chars_row.last_updated_by;

Line 1157: l_default_value := l_qa_chars_row.default_value;

1153: l_label_length := length(l_qa_chars_row.prompt);
1154: l_name := l_qa_chars_row.name;
1155: l_label := l_qa_chars_row.prompt;
1156: l_item_style := 'TEXT_INPUT';
1157: l_default_value := l_qa_chars_row.default_value;
1158: l_created_by := l_qa_chars_row.created_by;
1159: l_last_updated_by := l_qa_chars_row.last_updated_by;
1160: l_last_update_login := nvl(l_qa_chars_row.last_update_login,
1161: l_last_updated_by);

Line 1158: l_created_by := l_qa_chars_row.created_by;

1154: l_name := l_qa_chars_row.name;
1155: l_label := l_qa_chars_row.prompt;
1156: l_item_style := 'TEXT_INPUT';
1157: l_default_value := l_qa_chars_row.default_value;
1158: l_created_by := l_qa_chars_row.created_by;
1159: l_last_updated_by := l_qa_chars_row.last_updated_by;
1160: l_last_update_login := nvl(l_qa_chars_row.last_update_login,
1161: l_last_updated_by);
1162:

Line 1159: l_last_updated_by := l_qa_chars_row.last_updated_by;

1155: l_label := l_qa_chars_row.prompt;
1156: l_item_style := 'TEXT_INPUT';
1157: l_default_value := l_qa_chars_row.default_value;
1158: l_created_by := l_qa_chars_row.created_by;
1159: l_last_updated_by := l_qa_chars_row.last_updated_by;
1160: l_last_update_login := nvl(l_qa_chars_row.last_update_login,
1161: l_last_updated_by);
1162:
1163: END get_element_values;

Line 1160: l_last_update_login := nvl(l_qa_chars_row.last_update_login,

1156: l_item_style := 'TEXT_INPUT';
1157: l_default_value := l_qa_chars_row.default_value;
1158: l_created_by := l_qa_chars_row.created_by;
1159: l_last_updated_by := l_qa_chars_row.last_updated_by;
1160: l_last_update_login := nvl(l_qa_chars_row.last_update_login,
1161: l_last_updated_by);
1162:
1163: END get_element_values;
1164:

Line 1668: l_qa_chars_row qa_chars%ROWTYPE;

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;
1672: err_msg VARCHAR2(100);

Line 1682: FROM qa_chars

1678: AND char_id = p_char_id;
1679:
1680: CURSOR c2 IS
1681: SELECT *
1682: FROM qa_chars
1683: WHERE char_id = p_char_id;
1684:
1685: BEGIN
1686:

Line 1694: FETCH c2 INTO l_qa_chars_row;

1690: FETCH c1 INTO l_qa_plan_chars_row;
1691: CLOSE c1;
1692:
1693: OPEN c2;
1694: FETCH c2 INTO l_qa_chars_row;
1695: CLOSE c2;
1696:
1697: l_region_code := construct_ak_code(p_appendix, p_plan_id);
1698: l_attribute_code := construct_ak_code(g_element_appendix, p_char_id);

Line 1725: OR qa_chars_api.has_hardcoded_lov(p_char_id)) THEN

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)
1725: OR qa_chars_api.has_hardcoded_lov(p_char_id)) THEN
1726:
1727: -- dbms_output.put_line('Has Lov : ' || l_region_code || ' '
1728: -- || l_attribute_code);
1729:

Line 1734: l_data_type := convert_data_type(l_qa_chars_row.datatype);

1730: l_lov_region_code := g_lov_region;
1731:
1732: END IF;
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

Line 1763: X_ATTRIBUTE_LABEL_LENGTH => length(l_qa_chars_row.prompt),

1759: X_ATTRIBUTE_CODE => l_attribute_code,
1760: X_DISPLAY_SEQUENCE => l_display_sequence,
1761: X_NODE_DISPLAY_FLAG => l_display_flag,
1762: X_NODE_QUERY_FLAG => 'N',
1763: X_ATTRIBUTE_LABEL_LENGTH => length(l_qa_chars_row.prompt),
1764: X_BOLD => 'N',
1765: X_ITALIC => 'N',
1766: X_VERTICAL_ALIGNMENT => 'TOP',
1767: X_HORIZONTAL_ALIGNMENT => 'LEFT',

Line 1770: X_ATTRIBUTE_LABEL_LONG => l_qa_chars_row.prompt,

1766: X_VERTICAL_ALIGNMENT => 'TOP',
1767: X_HORIZONTAL_ALIGNMENT => 'LEFT',
1768: X_ITEM_STYLE => l_item_style,
1769: X_OBJECT_ATTRIBUTE_FLAG => 'N',
1770: X_ATTRIBUTE_LABEL_LONG => l_qa_chars_row.prompt,
1771: X_DESCRIPTION => l_qa_chars_row.name,
1772: X_SECURITY_CODE => null,
1773: X_UPDATE_FLAG => 'Y',
1774: X_REQUIRED_FLAG => l_required_flag,

Line 1771: X_DESCRIPTION => l_qa_chars_row.name,

1767: X_HORIZONTAL_ALIGNMENT => 'LEFT',
1768: X_ITEM_STYLE => l_item_style,
1769: X_OBJECT_ATTRIBUTE_FLAG => 'N',
1770: X_ATTRIBUTE_LABEL_LONG => l_qa_chars_row.prompt,
1771: X_DESCRIPTION => l_qa_chars_row.name,
1772: X_SECURITY_CODE => null,
1773: X_UPDATE_FLAG => 'Y',
1774: X_REQUIRED_FLAG => l_required_flag,
1775: X_DISPLAY_VALUE_LENGTH => l_qa_chars_row.display_length,

Line 1775: X_DISPLAY_VALUE_LENGTH => l_qa_chars_row.display_length,

1771: X_DESCRIPTION => l_qa_chars_row.name,
1772: X_SECURITY_CODE => null,
1773: X_UPDATE_FLAG => 'Y',
1774: X_REQUIRED_FLAG => l_required_flag,
1775: X_DISPLAY_VALUE_LENGTH => l_qa_chars_row.display_length,
1776: X_LOV_REGION_APPLICATION_ID => g_application_id,
1777: X_LOV_REGION_CODE => l_lov_region_code,
1778: X_LOV_FOREIGN_KEY_NAME => null,
1779: X_LOV_ATTRIBUTE_APPLICATION_ID => null,