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.GMD_QM_CONC_REPLACE_PKG dependencies on GMD_SPEC_TESTS_B

Line 62: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE

58: , ptarget_max IN VARCHAR2 DEFAULT NULL
59: , preport_precision IN VARCHAR2 DEFAULT NULL
60: , pstore_precision IN VARCHAR2 DEFAULT NULL
61: , ptest_priority IN VARCHAR2 DEFAULT NULL
62: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE
63: , x_return_status OUT NOCOPY VARCHAR2
64: );
65:
66: PROCEDURE default_spectest_from_spectest (

Line 79: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE

75: , ptarget_max IN VARCHAR2 DEFAULT NULL
76: , preport_precision IN VARCHAR2 DEFAULT NULL
77: , pstore_precision IN VARCHAR2 DEFAULT NULL
78: , ptest_priority IN VARCHAR2 DEFAULT NULL
79: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE
80: , x_return_status OUT NOCOPY VARCHAR2
81: );
82:
83: PROCEDURE add_spec_test_rec (

Line 87: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE

83: PROCEDURE add_spec_test_rec (
84: p_spec_id IN NUMBER
85: , p_test_name IN VARCHAR2
86: , p_spec_name IN VARCHAR2
87: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE
88: , x_return_status OUT NOCOPY VARCHAR2
89: );
90:
91: PROCEDURE del_spec_test_rec (

Line 99: p_spec_tests_rec IN gmd_spec_tests_b%ROWTYPE

95: , x_return_status OUT NOCOPY VARCHAR2
96: );
97:
98: PROCEDURE init_test_values_rec (
99: p_spec_tests_rec IN gmd_spec_tests_b%ROWTYPE
100: , x_test_values_rec IN OUT NOCOPY gmd_qm_conc_replace_pkg.test_values
101: );
102:
103: PROCEDURE insert_spec_test_rec (

Line 104: p_spec_test_rec IN gmd_spec_tests_b%ROWTYPE

100: , x_test_values_rec IN OUT NOCOPY gmd_qm_conc_replace_pkg.test_values
101: );
102:
103: PROCEDURE insert_spec_test_rec (
104: p_spec_test_rec IN gmd_spec_tests_b%ROWTYPE
105: , x_return_status OUT NOCOPY VARCHAR2
106: );
107:
108: PROCEDURE insert_new_spec_rec (

Line 330: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;

326: l_rowcount NUMBER;
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;

Line 333: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;

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;
336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;

Line 334: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;

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;
336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
338: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;

Line 335: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;

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;
336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
338: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;

Line 336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;

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;
336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
338: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;

Line 337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;

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;
336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
338: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
341: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;

Line 338: l_min_value_num gmd_spec_tests_b.min_value_num%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;
336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
338: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
341: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
342: l_report_precision gmd_spec_tests_b.report_precision%TYPE;

Line 339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;

335: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
338: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
341: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
342: l_report_precision gmd_spec_tests_b.report_precision%TYPE;
343: l_store_precision gmd_spec_tests_b.display_precision%TYPE;

Line 340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;

336: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
338: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
341: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
342: l_report_precision gmd_spec_tests_b.report_precision%TYPE;
343: l_store_precision gmd_spec_tests_b.display_precision%TYPE;
344: l_test_priority gmd_spec_tests_b.test_priority%TYPE;

Line 341: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;

337: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
338: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
341: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
342: l_report_precision gmd_spec_tests_b.report_precision%TYPE;
343: l_store_precision gmd_spec_tests_b.display_precision%TYPE;
344: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
345: l_target_min VARCHAR2 (80);

Line 342: l_report_precision gmd_spec_tests_b.report_precision%TYPE;

338: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
341: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
342: l_report_precision gmd_spec_tests_b.report_precision%TYPE;
343: l_store_precision gmd_spec_tests_b.display_precision%TYPE;
344: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
345: l_target_min VARCHAR2 (80);
346: l_target_max VARCHAR2 (80);

Line 343: l_store_precision gmd_spec_tests_b.display_precision%TYPE;

339: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
341: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
342: l_report_precision gmd_spec_tests_b.report_precision%TYPE;
343: l_store_precision gmd_spec_tests_b.display_precision%TYPE;
344: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
345: l_target_min VARCHAR2 (80);
346: l_target_max VARCHAR2 (80);
347: l_old_status gmd_specifications_b.spec_status%TYPE;

Line 344: l_test_priority gmd_spec_tests_b.test_priority%TYPE;

340: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
341: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
342: l_report_precision gmd_spec_tests_b.report_precision%TYPE;
343: l_store_precision gmd_spec_tests_b.display_precision%TYPE;
344: l_test_priority gmd_spec_tests_b.test_priority%TYPE;
345: l_target_min VARCHAR2 (80);
346: l_target_max VARCHAR2 (80);
347: l_old_status gmd_specifications_b.spec_status%TYPE;
348: l_new_status gmd_specifications_b.spec_status%TYPE;

Line 418: FROM gmd_spec_tests_b

414: WHERE spec_id = p_spec_id;
415:
416: CURSOR check_spec_test (p_spec_id IN NUMBER, p_test_id IN NUMBER) IS
417: SELECT 1
418: FROM gmd_spec_tests_b
419: WHERE spec_id = p_spec_id
420: AND test_id = p_test_id;
421:
422: CURSOR check_spec_test2 (p_spec_id IN NUMBER, p_test_name IN VARCHAR2) IS

Line 424: FROM gmd_spec_tests_b sptst

420: AND test_id = p_test_id;
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;

Line 432: FROM gmd_spec_tests_b

428: AND tst.test_code = p_test_name;
429:
430: CURSOR get_spec_test_by_spec (p_spec_id IN NUMBER) IS
431: SELECT *
432: FROM gmd_spec_tests_b
433: WHERE spec_id = p_spec_id;
434:
435: -- Bug# 5882074 cursor definition to check for organization
436: CURSOR cur_check_item_org(p_org_id IN NUMBER, p_spec_id IN NUMBER) IS

Line 588: l_from := ' from gmd_spec_tests_b spts ' || ' , gmd_qc_tests qcts ';

584: l_query_test_name := pnew_name;
585: l_select := 'select spts.* '; --Bug#5973270. Included spts.
586:
587: IF l_query_test_name IS NOT NULL THEN
588: l_from := ' from gmd_spec_tests_b spts ' || ' , gmd_qc_tests qcts ';
589: l_where :=
590: ' Where spts.test_id = qcts.test_id '
591: || ' and spts.spec_id = ' || get_object_rec.object_id
592: || ' and qcts.test_code = ' || '''' || l_query_test_name || '''';

Line 594: l_from := ' from gmd_spec_tests_b spts ';

590: ' Where spts.test_id = qcts.test_id '
591: || ' and spts.spec_id = ' || get_object_rec.object_id
592: || ' and qcts.test_code = ' || '''' || l_query_test_name || '''';
593: ELSE
594: l_from := ' from gmd_spec_tests_b spts ';
595: l_where := ' Where spts.spec_id = ' || get_object_rec.object_id;
596: END IF;
597:
598: l_query := l_select || l_from || l_where;

Line 832: DEBUG (' update gmd_spec_tests_b, spec_id ' || l_spec_test_rec.spec_id);

828: default_log (' No New spec is creted ');
829: END IF;
830:
831: IF (l_new_spec = 'N') THEN
832: DEBUG (' update gmd_spec_tests_b, spec_id ' || l_spec_test_rec.spec_id);
833: DEBUG (' update gmd_spec_tests_b, test_id ' || l_spec_test_rec.test_id);
834:
835: UPDATE gmd_spec_tests_b
836: SET optional_ind = l_test_values_rec.optional_ind

Line 833: DEBUG (' update gmd_spec_tests_b, test_id ' || l_spec_test_rec.test_id);

829: END IF;
830:
831: IF (l_new_spec = 'N') THEN
832: DEBUG (' update gmd_spec_tests_b, spec_id ' || l_spec_test_rec.spec_id);
833: DEBUG (' update gmd_spec_tests_b, test_id ' || l_spec_test_rec.test_id);
834:
835: UPDATE gmd_spec_tests_b
836: SET optional_ind = l_test_values_rec.optional_ind
837: , print_spec_ind = l_test_values_rec.print_spec_ind

Line 835: UPDATE gmd_spec_tests_b

831: IF (l_new_spec = 'N') THEN
832: DEBUG (' update gmd_spec_tests_b, spec_id ' || l_spec_test_rec.spec_id);
833: DEBUG (' update gmd_spec_tests_b, test_id ' || l_spec_test_rec.test_id);
834:
835: UPDATE gmd_spec_tests_b
836: SET optional_ind = l_test_values_rec.optional_ind
837: , print_spec_ind = l_test_values_rec.print_spec_ind
838: , print_result_ind = l_test_values_rec.print_result_ind
839: , target_value_num = l_test_values_rec.target_value_num

Line 1309: FROM gmd_spec_tests_b

1305: END IF;
1306:
1307: -- Bug# 5882074 assign back the sequence from the old test.
1308: SELECT seq INTO l_seq
1309: FROM gmd_spec_tests_b
1310: WHERE spec_id = get_object_rec.object_id
1311: AND test_id = TO_NUMBER (pold_name);
1312:
1313: l_spec_test_rec.seq := l_seq;

Line 1514: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE

1510: , ptarget_max IN VARCHAR2 DEFAULT NULL
1511: , preport_precision IN VARCHAR2 DEFAULT NULL
1512: , pstore_precision IN VARCHAR2 DEFAULT NULL
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;

Line 1518: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;

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:
1522: CURSOR get_gmd_test (p_test_name IN VARCHAR2) IS

Line 1697: FROM gmd_spec_tests_b

1693:
1694: l_seq := 0;
1695: SELECT MAX (seq) + 10
1696: INTO l_seq
1697: FROM gmd_spec_tests_b
1698: WHERE spec_id = p_spec_id;
1699:
1700: l_spec_test_rec.min_value_char := l_test_values_rec.min_value_char;
1701: l_spec_test_rec.max_value_char := l_test_values_rec.max_value_char;

Line 1805: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE

1801: , ptarget_max IN VARCHAR2 DEFAULT NULL
1802: , preport_precision IN VARCHAR2 DEFAULT NULL
1803: , pstore_precision IN VARCHAR2 DEFAULT NULL
1804: , ptest_priority IN VARCHAR2 DEFAULT NULL
1805: , p_spec_test_rec IN OUT NOCOPY gmd_spec_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;

Line 1808: l_from_spec_test_rec gmd_spec_tests_b%ROWTYPE;

1804: , ptest_priority IN VARCHAR2 DEFAULT NULL
1805: , p_spec_test_rec IN OUT NOCOPY gmd_spec_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);

Line 1809: l_to_spec_test_rec gmd_spec_tests_b%ROWTYPE;

1805: , p_spec_test_rec IN OUT NOCOPY gmd_spec_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:

Line 1816: FROM gmd_spec_tests_b

1812: l_row_id VARCHAR2 (200);
1813:
1814: CURSOR get_spec_test_rec (p_spec_id IN NUMBER, p_test_id IN NUMBER) IS
1815: SELECT *
1816: FROM gmd_spec_tests_b
1817: WHERE spec_id = p_spec_id
1818: AND test_id = p_test_id;
1819:
1820: CURSOR get_test_rec (p_test_name IN VARCHAR2) IS

Line 1907: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;

1903: , ptest_priority IN VARCHAR2 DEFAULT NULL
1904: , x_return_status OUT NOCOPY VARCHAR2
1905: , x_test_values_rec IN OUT NOCOPY gmd_qm_conc_replace_pkg.test_values
1906: ) IS
1907: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;
1908: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
1909: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
1910: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;

Line 1908: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;

1904: , x_return_status OUT NOCOPY VARCHAR2
1905: , x_test_values_rec IN OUT NOCOPY gmd_qm_conc_replace_pkg.test_values
1906: ) IS
1907: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;
1908: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
1909: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
1910: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;

Line 1909: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;

1905: , x_test_values_rec IN OUT NOCOPY gmd_qm_conc_replace_pkg.test_values
1906: ) IS
1907: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;
1908: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
1909: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
1910: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;

Line 1910: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;

1906: ) IS
1907: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;
1908: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
1909: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
1910: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;

Line 1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;

1907: l_optional_ind gmd_spec_tests_b.optional_ind%TYPE;
1908: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
1909: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
1910: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
1915: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;

Line 1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;

1908: l_print_spec_ind gmd_spec_tests_b.print_spec_ind%TYPE;
1909: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
1910: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
1915: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
1916: l_report_precision gmd_spec_tests_b.report_precision%TYPE;

Line 1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;

1909: l_print_result_ind gmd_spec_tests_b.print_result_ind%TYPE;
1910: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
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;

Line 1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;

1910: l_target_value_num gmd_spec_tests_b.target_value_num%TYPE;
1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
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;

Line 1915: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;

1911: l_target_value_char gmd_spec_tests_b.target_value_char%TYPE;
1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
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;

Line 1916: l_report_precision gmd_spec_tests_b.report_precision%TYPE;

1912: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
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;

Line 1917: l_store_precision gmd_spec_tests_b.display_precision%TYPE;

1913: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
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:

Line 1918: l_test_priority gmd_spec_tests_b.test_priority%TYPE;

1914: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
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

Line 2367: , p_spec_test_rec IN OUT NOCOPY gmd_spec_tests_b%ROWTYPE

2363: PROCEDURE add_spec_test_rec (
2364: p_spec_id IN NUMBER
2365: , p_test_name IN VARCHAR2
2366: , p_spec_name IN VARCHAR2
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;

Line 2370: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;

2366: , p_spec_name IN VARCHAR2
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);

Line 2384: FROM gmd_spec_tests_b sptst

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
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;

Line 2394: FROM gmd_spec_tests_b s

2390: CURSOR find_nonexp_spec_test (p_spec_id IN NUMBER) IS
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';

Line 2505: FROM gmd_spec_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
2505: FROM gmd_spec_tests_b
2506: WHERE spec_id = p_spec_id
2507: AND test_id = p_test_id;
2508:
2509: CURSOR find_exp_spec_test (p_spec_id IN NUMBER) IS

Line 2513: FROM gmd_spec_tests_b s

2509: CURSOR find_exp_spec_test (p_spec_id IN NUMBER) IS
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';

Line 2566: DELETE gmd_spec_tests_b

2562: || ' '
2563: || 'Test Name: '
2564: || l_gmd_test_rec.test_code);
2565:
2566: DELETE gmd_spec_tests_b
2567: WHERE spec_id = p_spec_id
2568: AND test_id = l_gmd_test_rec.test_id;
2569: ELSE
2570: -- DELTEST but spec_test does NOT exist, throw out an error msg

Line 2590: p_spec_tests_rec IN gmd_spec_tests_b%ROWTYPE

2586: default_log ('Delete spec test error ' || SQLERRM);
2587: END del_spec_test_rec;
2588:
2589: PROCEDURE init_test_values_rec (
2590: p_spec_tests_rec IN gmd_spec_tests_b%ROWTYPE
2591: , x_test_values_rec IN OUT NOCOPY gmd_qm_conc_replace_pkg.test_values
2592: ) IS
2593: BEGIN
2594: x_test_values_rec.optional_ind := p_spec_tests_rec.optional_ind;

Line 2609: p_spec_test_rec IN gmd_spec_tests_b%ROWTYPE

2605: x_test_values_rec.test_priority := p_spec_tests_rec.test_priority;
2606: END init_test_values_rec;
2607:
2608: PROCEDURE insert_spec_test_rec (
2609: p_spec_test_rec IN gmd_spec_tests_b%ROWTYPE
2610: , x_return_status OUT NOCOPY VARCHAR2
2611: ) IS
2612: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
2613: l_row_id VARCHAR2 (200);

Line 2612: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;

2608: PROCEDURE insert_spec_test_rec (
2609: p_spec_test_rec IN gmd_spec_tests_b%ROWTYPE
2610: , x_return_status OUT NOCOPY VARCHAR2
2611: ) IS
2612: l_spec_test_rec gmd_spec_tests_b%ROWTYPE;
2613: l_row_id VARCHAR2 (200);
2614: BEGIN
2615: l_spec_test_rec := p_spec_test_rec;
2616: DEBUG ('Inserting spec test rec ');