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 339: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

335: l_error_text VARCHAR2 (2000);
336: l_dummy_cnt NUMBER;
337: -- Define different table types
338: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
339: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
340: l_gmd_spec_rec gmd_specifications_b%ROWTYPE;
341: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;
342: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
343: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;

Line 412: FROM gmd_qc_tests_b

408: AND concurrent_id = TO_NUMBER (pconcurrent_id);
409:
410: CURSOR get_gmd_test1 (p_test_name IN VARCHAR2) IS
411: SELECT *
412: FROM gmd_qc_tests_b
413: WHERE test_code = p_test_name;
414:
415: CURSOR get_gmd_test2 (p_test_id IN NUMBER) IS
416: SELECT *

Line 417: FROM gmd_qc_tests_b

413: WHERE test_code = p_test_name;
414:
415: CURSOR get_gmd_test2 (p_test_id IN NUMBER) IS
416: SELECT *
417: FROM gmd_qc_tests_b
418: WHERE test_id = p_test_id;
419:
420: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
421: SELECT *

Line 434: , gmd_qc_tests_b tst

430:
431: CURSOR check_spec_test2 (p_spec_id IN NUMBER, p_test_name IN VARCHAR2) IS
432: SELECT 1
433: FROM gmd_spec_tests_b sptst
434: , gmd_qc_tests_b tst
435: WHERE sptst.spec_id = p_spec_id
436: AND sptst.test_id = tst.test_id
437: AND tst.test_code = p_test_name;
438:

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

845: p_spec_tests_rec => l_spec_test_rec
846: , x_test_values_rec => l_test_values_rec);
847:
848: DEBUG (' test_rec.test_type ' || l_gmd_test_rec.test_type);
849: DEBUG (' fetch gmd_qc_tests_b, test id ' || l_spec_test_rec.test_id);
850:
851: set_test_values (p_gmd_test_rec => l_gmd_test_rec
852: , poptional_ind => poptional_ind
853: , pprint_spec_ind => pprint_spec_ind

Line 1624: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

1620: , ptest_priority IN VARCHAR2 DEFAULT NULL
1621: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE
1622: , x_return_status OUT NOCOPY VARCHAR2
1623: ) IS
1624: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
1625: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
1626: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
1627: l_seq NUMBER;
1628:

Line 1631: FROM gmd_qc_tests_b

1627: l_seq NUMBER;
1628:
1629: CURSOR get_gmd_test (p_test_name IN VARCHAR2) IS
1630: SELECT *
1631: FROM gmd_qc_tests_b
1632: WHERE test_code = p_test_name;
1633:
1634: -- Bug# 5882074 get the char test values
1635: CURSOR get_char_test_values (p_test_id IN VARCHAR2, p_num_value IN NUMBER) IS

Line 1917: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

1913: , x_return_status OUT NOCOPY VARCHAR2
1914: ) IS
1915: l_from_spec_test_rec gmd_spec_tests_b%ROWTYPE;
1916: l_to_spec_test_rec gmd_spec_tests_b%ROWTYPE;
1917: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
1918: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
1919: l_row_id VARCHAR2 (200);
1920:
1921: CURSOR get_spec_test_rec (p_spec_id IN NUMBER, p_test_id IN NUMBER) IS

Line 1929: FROM gmd_qc_tests_b

1925: AND test_id = p_test_id;
1926:
1927: CURSOR get_test_rec (p_test_name IN VARCHAR2) IS
1928: SELECT *
1929: FROM gmd_qc_tests_b
1930: WHERE test_code = p_test_name;
1931: BEGIN
1932: x_return_status := fnd_api.g_ret_sts_success;
1933:

Line 2001: p_gmd_test_rec IN gmd_qc_tests_b%ROWTYPE

1997: default_log ('Default spectest from spectest result in Error');
1998: END default_spectest_from_spectest;
1999:
2000: PROCEDURE set_test_values (
2001: p_gmd_test_rec IN gmd_qc_tests_b%ROWTYPE
2002: , poptional_ind IN VARCHAR2 DEFAULT NULL
2003: , pprint_spec_ind IN VARCHAR2 DEFAULT NULL
2004: , pprint_result_ind IN VARCHAR2 DEFAULT NULL
2005: , ptarget_value IN VARCHAR2 DEFAULT NULL

Line 2026: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

2022: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
2023: l_report_precision gmd_spec_tests_b.report_precision%TYPE;
2024: l_store_precision gmd_spec_tests_b.display_precision%TYPE;
2025: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
2026: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
2027: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
2028:
2029: l_precision VARCHAR2(50); --RLNAGARA Bug 6972284
2030: l_min_max_target NUMBER; --RLNAGARA Bug 6972284

Line 2481: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

2477: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE
2478: , x_return_status OUT NOCOPY VARCHAR2
2479: ) IS
2480: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
2481: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
2482: l_exist NUMBER;
2483: l_seq NUMBER;
2484: l_return_status VARCHAR2 (1);
2485: l_check BOOLEAN;

Line 2489: FROM gmd_qc_tests_b

2485: l_check BOOLEAN;
2486:
2487: CURSOR get_gmd_test (p_test_name IN VARCHAR2) IS
2488: SELECT *
2489: FROM gmd_qc_tests_b
2490: WHERE test_code = p_test_name;
2491:
2492: CURSOR check_spec_test (p_spec_id IN NUMBER, p_test_name IN VARCHAR2) IS
2493: SELECT 1

Line 2495: , gmd_qc_tests_b tst

2491:
2492: CURSOR check_spec_test (p_spec_id IN NUMBER, p_test_name IN VARCHAR2) IS
2493: SELECT 1
2494: FROM gmd_spec_tests_b sptst
2495: , gmd_qc_tests_b tst
2496: WHERE sptst.spec_id = p_spec_id
2497: AND sptst.test_id = tst.test_id
2498: AND tst.test_code = p_test_name;
2499:

Line 2505: , gmd_qc_tests_b t

2501: SELECT t.test_code
2502: , t.test_id
2503: , t.expression
2504: FROM gmd_spec_tests_b s
2505: , gmd_qc_tests_b t
2506: WHERE s.spec_id = p_spec_id
2507: AND s.test_id = t.test_id
2508: AND t.test_type <> 'E';
2509: BEGIN

Line 2604: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;

2600: , p_spec_name IN VARCHAR2
2601: , p_test_name IN VARCHAR2
2602: , x_return_status OUT NOCOPY VARCHAR2
2603: ) IS
2604: l_gmd_test_rec gmd_qc_tests_b%ROWTYPE;
2605: l_exist NUMBER;
2606: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
2607: l_seq NUMBER;
2608: l_return_status VARCHAR2 (1);

Line 2612: FROM gmd_qc_tests_b

2608: l_return_status VARCHAR2 (1);
2609:
2610: CURSOR get_gmd_test (p_test_name IN VARCHAR2) IS
2611: SELECT *
2612: FROM gmd_qc_tests_b
2613: WHERE test_id = TO_NUMBER (p_test_name);
2614:
2615: CURSOR check_spec_test (p_spec_id IN NUMBER, p_test_id IN NUMBER) IS
2616: SELECT 1

Line 2626: , gmd_qc_tests_b t

2622: SELECT t.test_code
2623: , t.test_id
2624: , t.expression
2625: FROM gmd_spec_tests_b s
2626: , gmd_qc_tests_b t
2627: WHERE s.spec_id = p_spec_id
2628: AND s.test_id = t.test_id
2629: AND t.test_type = 'E';
2630: BEGIN