APPS.QA_SPECS_PUB dependencies on QA_SPEC_CHARS

Line 301: FROM qa_spec_chars qsc, qa_specs qs

297: PROCEDURE check_for_spec_element(p_spec_id IN NUMBER) IS
298:
299: CURSOR c IS
300: SELECT 1
301: FROM qa_spec_chars qsc, qa_specs qs
302: WHERE qs.spec_id = p_spec_id
303: AND qs.common_spec_id = qsc.spec_id;
304:
305: l_dummy NUMBER;

Line 603: FROM qa_spec_chars

599: RETURN BOOLEAN IS
600:
601: CURSOR c IS
602: SELECT 1
603: FROM qa_spec_chars
604: WHERE spec_id = p_spec_id AND char_id = p_char_id;
605:
606: result BOOLEAN;
607: dummy NUMBER;

Line 1146: -- fields too into the qa_spec_chars table

1142: x_msg_data OUT NOCOPY VARCHAR2,
1143: x_return_status OUT NOCOPY VARCHAR2,
1144: -- 7430441.FP for Bug 7046198
1145: -- Added the attribute parameters in order to populate the DFF
1146: -- fields too into the qa_spec_chars table
1147: -- pdube Wed Sep 24 03:17:03 PDT 2008
1148: p_attribute_category IN VARCHAR2 := NULL,
1149: p_attribute1 IN VARCHAR2 := NULL,
1150: p_attribute2 IN VARCHAR2 := NULL,

Line 1251: -- The values getting inserted in to qa_spec_chars in the following insert

1247: END IF;
1248:
1249: l_enabled_flag := convert_flag(p_enabled_flag);
1250:
1251: -- The values getting inserted in to qa_spec_chars in the following insert
1252: -- statement were reversed.Changed the order of parameters for
1253: -- upper_reasonable_limit,lower_reasonable_limit,upper_user_defined_limit,
1254: -- lower_user_defined_limit.
1255: -- Bug 2715786.suramasw Wed Dec 18 23:08:20 PST 2002.

Line 1257: INSERT INTO qa_spec_chars(

1253: -- upper_reasonable_limit,lower_reasonable_limit,upper_user_defined_limit,
1254: -- lower_user_defined_limit.
1255: -- Bug 2715786.suramasw Wed Dec 18 23:08:20 PST 2002.
1256:
1257: INSERT INTO qa_spec_chars(
1258: spec_id,
1259: char_id,
1260: last_update_date,
1261: last_updated_by,

Line 1447: FROM qa_spec_chars

1443: --
1444: BEGIN
1445:
1446: DELETE
1447: FROM qa_spec_chars
1448: WHERE spec_id = p_spec_id;
1449:
1450: DELETE
1451: FROM qa_specs

Line 1463: FROM qa_spec_chars

1459:
1460: BEGIN
1461:
1462: DELETE
1463: FROM qa_spec_chars
1464: WHERE spec_id = p_spec_id
1465: AND char_id = p_element_id;
1466:
1467: END delete_spec_element_private;

Line 1842: INSERT INTO qa_spec_chars(

1838:
1839:
1840: -- Prevent this insertion if the spec being copied is a child spec
1841: IF NOT is_child_spec(l_spec_id) THEN
1842: INSERT INTO qa_spec_chars(
1843: spec_id,
1844: char_id,
1845: last_update_date,
1846: last_updated_by,

Line 1874: FROM qa_spec_chars

1870: upper_user_defined_limit,
1871: lower_user_defined_limit,
1872: upper_reasonable_limit,
1873: lower_reasonable_limit
1874: FROM qa_spec_chars
1875: WHERE spec_id = l_spec_id;
1876: END IF;
1877:
1878: --