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 1198: -- fields too into the qa_spec_chars table

1194: x_msg_data OUT NOCOPY VARCHAR2,
1195: x_return_status OUT NOCOPY VARCHAR2,
1196: -- 7430441.FP for Bug 7046198
1197: -- Added the attribute parameters in order to populate the DFF
1198: -- fields too into the qa_spec_chars table
1199: -- pdube Wed Sep 24 03:17:03 PDT 2008
1200: p_attribute_category IN VARCHAR2 := NULL,
1201: p_attribute1 IN VARCHAR2 := NULL,
1202: p_attribute2 IN VARCHAR2 := NULL,

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

1299: END IF;
1300:
1301: l_enabled_flag := convert_flag(p_enabled_flag);
1302:
1303: -- The values getting inserted in to qa_spec_chars in the following insert
1304: -- statement were reversed.Changed the order of parameters for
1305: -- upper_reasonable_limit,lower_reasonable_limit,upper_user_defined_limit,
1306: -- lower_user_defined_limit.
1307: -- Bug 2715786.suramasw Wed Dec 18 23:08:20 PST 2002.

Line 1309: INSERT INTO qa_spec_chars(

1305: -- upper_reasonable_limit,lower_reasonable_limit,upper_user_defined_limit,
1306: -- lower_user_defined_limit.
1307: -- Bug 2715786.suramasw Wed Dec 18 23:08:20 PST 2002.
1308:
1309: INSERT INTO qa_spec_chars(
1310: spec_id,
1311: char_id,
1312: last_update_date,
1313: last_updated_by,

Line 1499: FROM qa_spec_chars

1495: --
1496: BEGIN
1497:
1498: DELETE
1499: FROM qa_spec_chars
1500: WHERE spec_id = p_spec_id;
1501:
1502: DELETE
1503: FROM qa_specs

Line 1515: FROM qa_spec_chars

1511:
1512: BEGIN
1513:
1514: DELETE
1515: FROM qa_spec_chars
1516: WHERE spec_id = p_spec_id
1517: AND char_id = p_element_id;
1518:
1519: END delete_spec_element_private;

Line 1894: INSERT INTO qa_spec_chars(

1890:
1891:
1892: -- Prevent this insertion if the spec being copied is a child spec
1893: IF NOT is_child_spec(l_spec_id) THEN
1894: INSERT INTO qa_spec_chars(
1895: spec_id,
1896: char_id,
1897: last_update_date,
1898: last_updated_by,

Line 1926: FROM qa_spec_chars

1922: upper_user_defined_limit,
1923: lower_user_defined_limit,
1924: upper_reasonable_limit,
1925: lower_reasonable_limit
1926: FROM qa_spec_chars
1927: WHERE spec_id = l_spec_id;
1928: END IF;
1929:
1930: --