DBA Data[Home] [Help]

APPS.GMD_QM_CONC_REPLACE_PKG dependencies on GMD_QC_TESTS_B

Line 36: p_gmd_test_rec IN gmd_qc_tests_b%ROWTYPE

32: END IF;
33: END DEBUG;
34:
35: PROCEDURE set_test_values (
36: p_gmd_test_rec IN gmd_qc_tests_b%ROWTYPE
37: , poptional_ind IN VARCHAR2 DEFAULT NULL
38: , pprint_spec_ind IN VARCHAR2 DEFAULT NULL
39: , pprint_result_ind IN VARCHAR2 DEFAULT NULL
40: , ptarget_value IN VARCHAR2 DEFAULT NULL

Line 331: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

327: l_error_text VARCHAR2 (2000);
328: l_dummy_cnt NUMBER;
329: -- Define different table types
330: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
331: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
332: l_gmd_spec_rec gmd_specifications_b%ROWTYPE;
333: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;
334: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
335: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;

Line 403: FROM gmd_qc_tests_b

399: AND concurrent_id = TO_NUMBER (pconcurrent_id);
400:
401: CURSOR get_gmd_test1 (p_test_name IN VARCHAR2) IS
402: SELECT *
403: FROM gmd_qc_tests_b
404: WHERE test_code = p_test_name;
405:
406: CURSOR get_gmd_test2 (p_test_id IN NUMBER) IS
407: SELECT *

Line 408: FROM gmd_qc_tests_b

404: WHERE test_code = p_test_name;
405:
406: CURSOR get_gmd_test2 (p_test_id IN NUMBER) IS
407: SELECT *
408: FROM gmd_qc_tests_b
409: WHERE test_id = p_test_id;
410:
411: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
412: SELECT *

Line 425: , gmd_qc_tests_b tst

421:
422: CURSOR check_spec_test2 (p_spec_id IN NUMBER, p_test_name IN VARCHAR2) IS
423: SELECT 1
424: FROM gmd_spec_tests_b sptst
425: , gmd_qc_tests_b tst
426: WHERE sptst.spec_id = p_spec_id
427: AND sptst.test_id = tst.test_id
428: AND tst.test_code = p_test_name;
429:

Line 773: DEBUG (' fetch gmd_qc_tests_b, test id ' || l_spec_test_rec.test_id);

769: p_spec_tests_rec => l_spec_test_rec
770: , x_test_values_rec => l_test_values_rec);
771:
772: DEBUG (' test_rec.test_type ' || l_gmd_test_rec.test_type);
773: DEBUG (' fetch gmd_qc_tests_b, test id ' || l_spec_test_rec.test_id);
774:
775: set_test_values (p_gmd_test_rec => l_gmd_test_rec
776: , poptional_ind => poptional_ind
777: , pprint_spec_ind => pprint_spec_ind

Line 1517: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

1513: , ptest_priority IN VARCHAR2 DEFAULT NULL
1514: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE
1515: , x_return_status OUT NOCOPY VARCHAR2
1516: ) IS
1517: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
1518: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
1519: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
1520: l_seq NUMBER;
1521:

Line 1524: FROM gmd_qc_tests_b

1520: l_seq NUMBER;
1521:
1522: CURSOR get_gmd_test (p_test_name IN VARCHAR2) IS
1523: SELECT *
1524: FROM gmd_qc_tests_b
1525: WHERE test_code = p_test_name;
1526:
1527: -- Bug# 5882074 get the char test values
1528: CURSOR get_char_test_values (p_test_id IN VARCHAR2, p_num_value IN NUMBER) IS

Line 1810: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

1806: , x_return_status OUT NOCOPY VARCHAR2
1807: ) IS
1808: l_from_spec_test_rec gmd_spec_tests_b%ROWTYPE;
1809: l_to_spec_test_rec gmd_spec_tests_b%ROWTYPE;
1810: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
1811: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
1812: l_row_id VARCHAR2 (200);
1813:
1814: CURSOR get_spec_test_rec (p_spec_id IN NUMBER, p_test_id IN NUMBER) IS

Line 1822: FROM gmd_qc_tests_b

1818: AND test_id = p_test_id;
1819:
1820: CURSOR get_test_rec (p_test_name IN VARCHAR2) IS
1821: SELECT *
1822: FROM gmd_qc_tests_b
1823: WHERE test_code = p_test_name;
1824: BEGIN
1825: x_return_status := fnd_api.g_ret_sts_success;
1826:

Line 1894: p_gmd_test_rec IN gmd_qc_tests_b%ROWTYPE

1890: default_log ('Default spectest from spectest result in Error');
1891: END default_spectest_from_spectest;
1892:
1893: PROCEDURE set_test_values (
1894: p_gmd_test_rec IN gmd_qc_tests_b%ROWTYPE
1895: , poptional_ind IN VARCHAR2 DEFAULT NULL
1896: , pprint_spec_ind IN VARCHAR2 DEFAULT NULL
1897: , pprint_result_ind IN VARCHAR2 DEFAULT NULL
1898: , ptarget_value IN VARCHAR2 DEFAULT NULL

Line 1919: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

1915: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
1916: l_report_precision gmd_spec_tests_b.report_precision%TYPE;
1917: l_store_precision gmd_spec_tests_b.display_precision%TYPE;
1918: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
1919: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
1920: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
1921:
1922: l_precision VARCHAR2(50); --RLNAGARA Bug 6972284
1923: l_min_max_target NUMBER; --RLNAGARA Bug 6972284

Line 2371: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

2367: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE
2368: , x_return_status OUT NOCOPY VARCHAR2
2369: ) IS
2370: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
2371: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
2372: l_exist NUMBER;
2373: l_seq NUMBER;
2374: l_return_status VARCHAR2 (1);
2375: l_check BOOLEAN;

Line 2379: FROM gmd_qc_tests_b

2375: l_check BOOLEAN;
2376:
2377: CURSOR get_gmd_test (p_test_name IN VARCHAR2) IS
2378: SELECT *
2379: FROM gmd_qc_tests_b
2380: WHERE test_code = p_test_name;
2381:
2382: CURSOR check_spec_test (p_spec_id IN NUMBER, p_test_name IN VARCHAR2) IS
2383: SELECT 1

Line 2385: , gmd_qc_tests_b tst

2381:
2382: CURSOR check_spec_test (p_spec_id IN NUMBER, p_test_name IN VARCHAR2) IS
2383: SELECT 1
2384: FROM gmd_spec_tests_b sptst
2385: , gmd_qc_tests_b tst
2386: WHERE sptst.spec_id = p_spec_id
2387: AND sptst.test_id = tst.test_id
2388: AND tst.test_code = p_test_name;
2389:

Line 2395: , gmd_qc_tests_b t

2391: SELECT t.test_code
2392: , t.test_id
2393: , t.expression
2394: FROM gmd_spec_tests_b s
2395: , gmd_qc_tests_b t
2396: WHERE s.spec_id = p_spec_id
2397: AND s.test_id = t.test_id
2398: AND t.test_type <> 'E';
2399: BEGIN

Line 2492: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

2488: , p_spec_name IN VARCHAR2
2489: , p_test_name IN VARCHAR2
2490: , x_return_status OUT NOCOPY VARCHAR2
2491: ) IS
2492: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
2493: l_exist NUMBER;
2494: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
2495: l_seq NUMBER;
2496: l_return_status VARCHAR2 (1);

Line 2500: FROM gmd_qc_tests_b

2496: l_return_status VARCHAR2 (1);
2497:
2498: CURSOR get_gmd_test (p_test_name IN VARCHAR2) IS
2499: SELECT *
2500: FROM gmd_qc_tests_b
2501: WHERE test_id = TO_NUMBER (p_test_name);
2502:
2503: CURSOR check_spec_test (p_spec_id IN NUMBER, p_test_id IN NUMBER) IS
2504: SELECT 1

Line 2514: , gmd_qc_tests_b t

2510: SELECT t.test_code
2511: , t.test_id
2512: , t.expression
2513: FROM gmd_spec_tests_b s
2514: , gmd_qc_tests_b t
2515: WHERE s.spec_id = p_spec_id
2516: AND s.test_id = t.test_id
2517: AND t.test_type = 'E';
2518: BEGIN