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_PLAN_ELEMENT_API dependencies on QA_CHARS_API

Line 622: AND (qa_chars_api.hardcoded_column(element_id) IS NOT NULL)

618: FUNCTION normalized (element_id IN NUMBER)
619: RETURN BOOLEAN IS
620: BEGIN
621: RETURN (NOT keyflex(element_id))
622: AND (qa_chars_api.hardcoded_column(element_id) IS NOT NULL)
623: AND (qa_chars_api.fk_meaning(element_id) IS NOT NULL)
624: AND (qa_chars_api.fk_lookup_type(element_id) <> 2);
625: END normalized;
626:

Line 623: AND (qa_chars_api.fk_meaning(element_id) IS NOT NULL)

619: RETURN BOOLEAN IS
620: BEGIN
621: RETURN (NOT keyflex(element_id))
622: AND (qa_chars_api.hardcoded_column(element_id) IS NOT NULL)
623: AND (qa_chars_api.fk_meaning(element_id) IS NOT NULL)
624: AND (qa_chars_api.fk_lookup_type(element_id) <> 2);
625: END normalized;
626:
627:

Line 624: AND (qa_chars_api.fk_lookup_type(element_id) <> 2);

620: BEGIN
621: RETURN (NOT keyflex(element_id))
622: AND (qa_chars_api.hardcoded_column(element_id) IS NOT NULL)
623: AND (qa_chars_api.fk_meaning(element_id) IS NOT NULL)
624: AND (qa_chars_api.fk_lookup_type(element_id) <> 2);
625: END normalized;
626:
627:
628: FUNCTION derived (element_id IN NUMBER)

Line 642: RETURN (qa_chars_api.hardcoded_column(element_id) IS NOT NULL)

638:
639: FUNCTION primitive (element_id IN NUMBER)
640: RETURN BOOLEAN IS
641: BEGIN
642: RETURN (qa_chars_api.hardcoded_column(element_id) IS NOT NULL)
643: AND NOT (normalized(element_id));
644: END primitive;
645:
646:

Line 652: RETURN qa_chars_api.hardcoded_column(element_id) IS NOT NULL;

648: RETURN BOOLEAN IS
649:
650: BEGIN
651:
652: RETURN qa_chars_api.hardcoded_column(element_id) IS NOT NULL;
653:
654: END hardcoded;
655:
656:

Line 662: RETURN qa_chars_api.datatype(element_id);

658: RETURN NUMBER IS
659:
660: BEGIN
661:
662: RETURN qa_chars_api.datatype(element_id);
663:
664: END get_element_datatype;
665:
666:

Line 686: lower_limit := qa_chars_api.lower_reasonable_limit(element_id);

682: -- shkalyan Tue Jun 22 2004
683: -- If spec_id is present but, element is not in spec, then,
684: -- element spec should not be used.
685: IF ( NVL(spec_id, 0) <= 0 ) THEN
686: lower_limit := qa_chars_api.lower_reasonable_limit(element_id);
687: upper_limit := qa_chars_api.upper_reasonable_limit(element_id);
688: ELSE
689: lower_limit := NULL;
690: upper_limit := NULL;

Line 687: upper_limit := qa_chars_api.upper_reasonable_limit(element_id);

683: -- If spec_id is present but, element is not in spec, then,
684: -- element spec should not be used.
685: IF ( NVL(spec_id, 0) <= 0 ) THEN
686: lower_limit := qa_chars_api.lower_reasonable_limit(element_id);
687: upper_limit := qa_chars_api.upper_reasonable_limit(element_id);
688: ELSE
689: lower_limit := NULL;
690: upper_limit := NULL;
691: END IF;

Line 784: lower_limit := qa_chars_api.lower_reasonable_limit(p_element_id);

780: FETCH char_uom into l_spec_char_uom;
781: CLOSE char_uom;
782:
783: -- Get the spec limits defined on the elemnt level
784: lower_limit := qa_chars_api.lower_reasonable_limit(p_element_id);
785: upper_limit := qa_chars_api.upper_reasonable_limit(p_element_id);
786:
787: -- Check if the UOM on the plan level is different that that on the
788: -- element level in which case perform the conversion

Line 785: upper_limit := qa_chars_api.upper_reasonable_limit(p_element_id);

781: CLOSE char_uom;
782:
783: -- Get the spec limits defined on the elemnt level
784: lower_limit := qa_chars_api.lower_reasonable_limit(p_element_id);
785: upper_limit := qa_chars_api.upper_reasonable_limit(p_element_id);
786:
787: -- Check if the UOM on the plan level is different that that on the
788: -- element level in which case perform the conversion
789: IF l_plan_char_uom <> l_spec_char_uom THEN

Line 967: RETURN qa_chars_api.sql_validation_string(element_id) IS NOT NULL;

963: RETURN BOOLEAN IS
964:
965: BEGIN
966:
967: RETURN qa_chars_api.sql_validation_string(element_id) IS NOT NULL;
968:
969: END sql_validation_exists;
970:
971:

Line 1006: RETURN qa_chars_api.datatype(element_id);

1002: ELSIF NOT primitive(element_id) THEN
1003: RETURN qa_ss_const.number_datatype;
1004:
1005: ELSE
1006: RETURN qa_chars_api.datatype(element_id);
1007:
1008: END IF;
1009:
1010: END get_actual_datatype;

Line 2533: RETURN qa_chars_api.sql_validation_string(element_id);

2529:
2530: FUNCTION get_sql_validation_string (element_id IN NUMBER)
2531: RETURN VARCHAR2 IS
2532: BEGIN
2533: RETURN qa_chars_api.sql_validation_string(element_id);
2534: END get_sql_validation_string;
2535:
2536:
2537: FUNCTION get_result_column_name (plan_id IN NUMBER, element_id IN NUMBER)

Line 2549: name := qa_chars_api.hardcoded_column(element_id);

2545: name VARCHAR2(30);
2546:
2547: BEGIN
2548:
2549: name := qa_chars_api.hardcoded_column(element_id);
2550:
2551: IF (name IS NULL) THEN
2552: name := qpc_result_column_name(plan_id, element_id);
2553: END IF;

Line 2589: sql_string := qa_chars_api.format_sql_for_lov(sql_string,

2585:
2586: ELSIF sql_validation_exists(x_char_id) THEN
2587:
2588: sql_string := get_sql_validation_string(x_char_id);
2589: sql_string := qa_chars_api.format_sql_for_lov(sql_string,
2590: org_id, user_id);
2591:
2592: --
2593: -- Bug 1474995. Adding filter to the user-defined SQL.

Line 5107: sql_string := qa_chars_api.format_sql_for_validation (sql_string,

5103:
5104: sql_string := get_sql_validation_string(qa_ss_const.transaction_type);
5105:
5106:
5107: sql_string := qa_chars_api.format_sql_for_validation (sql_string,
5108: p_org_id, p_user_id);
5109:
5110: IF value_in_sql (sql_string, p_value) THEN
5111: result := TRUE;

Line 5177: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||

5173: p_child_char_id = qa_ss_const.locator OR
5174: p_child_char_id = qa_ss_const.comp_locator OR
5175: p_child_char_id = qa_ss_const.to_locator OR
5176: p_child_char_id = qa_ss_const.rma_number ) THEN
5177: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||
5178: ' from qa_results '||
5179: ' where plan_id = :p_plan_id '||
5180: ' and collection_id = :p_collection_id '||
5181: ' and occurrence = :p_occurrence';