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_QC_TEST_VALUES_GRP dependencies on GMD_QC_TESTS

Line 113: FROM GMD_QC_TESTS_B

109: return(null);
110: END IF;
111:
112: SELECT test_type INTO l_test_type
113: FROM GMD_QC_TESTS_B
114: WHERE test_id = p_test_id ;
115:
116: IF l_test_type = 'L' THEN
117: SELECT DISPLAY_LABEL_NUMERIC_RANGE INTO l_test_value_desc

Line 173: SELECT test_type,display_precision,delete_mark FROM GMD_QC_TESTS_B

169: l_progress VARCHAR2(3);
170: l_delete_mark NUMBER(5);
171:
172: CURSOR cr_get_test_type(l_test_id NUMBER) IS
173: SELECT test_type,display_precision,delete_mark FROM GMD_QC_TESTS_B
174: WHERE test_id = p_test_id ;
175:
176:
177: BEGIN

Line 207: IF GMD_QC_TESTS_GRP.test_exist_in_spec(p_test_id => p_test_id) THEN

203: FND_MESSAGE.SET_TOKEN('TEST',TO_CHAR(p_test_id));
204: FND_MSG_PUB.ADD;
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: IF GMD_QC_TESTS_GRP.test_exist_in_spec(p_test_id => p_test_id) THEN
208: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_USED_IN_SPEC');
209: FND_MESSAGE.SET_TOKEN('TEST',TO_CHAR(p_test_id));
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;

Line 470: p_gmd_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE,

466:
467: ===========================================================================*/
468:
469: PROCEDURE VALIDATE_AFTER_INSERT_ALL(
470: p_gmd_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE,
471: x_gmd_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,
472: x_return_status OUT NOCOPY VARCHAR2,
473: x_message_data OUT NOCOPY VARCHAR2) IS
474:

Line 471: x_gmd_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,

467: ===========================================================================*/
468:
469: PROCEDURE VALIDATE_AFTER_INSERT_ALL(
470: p_gmd_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE,
471: x_gmd_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,
472: x_return_status OUT NOCOPY VARCHAR2,
473: x_message_data OUT NOCOPY VARCHAR2) IS
474:
475:

Line 486: x_gmd_qc_tests_rec := p_gmd_qc_tests_rec;

482: l_progress := '010';
483:
484: x_return_status := FND_API.G_RET_STS_SUCCESS ;
485:
486: x_gmd_qc_tests_rec := p_gmd_qc_tests_rec;
487:
488:
489: IF x_gmd_qc_tests_rec.test_id IS NULL THEN
490: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_CODE_NULL');

Line 489: IF x_gmd_qc_tests_rec.test_id IS NULL THEN

485:
486: x_gmd_qc_tests_rec := p_gmd_qc_tests_rec;
487:
488:
489: IF x_gmd_qc_tests_rec.test_id IS NULL THEN
490: FND_MESSAGE.SET_NAME('GMD','GMD_TEST_ID_CODE_NULL');
491: FND_MSG_PUB.ADD;
492: RAISE FND_API.G_EXC_ERROR;
493: END IF;

Line 496: IF x_gmd_qc_tests_rec.test_type in ('V','T','L') THEN

492: RAISE FND_API.G_EXC_ERROR;
493: END IF;
494:
495: -- atleast one test value record must be there.
496: IF x_gmd_qc_tests_rec.test_type in ('V','T','L') THEN
497: SELECT NVL(COUNT(1),0) INTO l_test_values_count
498: FROM GMD_QC_TEST_VALUES_B
499: WHERE test_id = x_gmd_qc_tests_rec.test_id ;
500:

Line 499: WHERE test_id = x_gmd_qc_tests_rec.test_id ;

495: -- atleast one test value record must be there.
496: IF x_gmd_qc_tests_rec.test_type in ('V','T','L') THEN
497: SELECT NVL(COUNT(1),0) INTO l_test_values_count
498: FROM GMD_QC_TEST_VALUES_B
499: WHERE test_id = x_gmd_qc_tests_rec.test_id ;
500:
501: IF l_test_values_count = 0 THEN
502: FND_MESSAGE.SET_NAME('GMD','GMD_NO_TEST_VALUES');
503: FND_MESSAGE.SET_TOKEN('TEST',x_gmd_qc_tests_rec.test_code);

Line 503: FND_MESSAGE.SET_TOKEN('TEST',x_gmd_qc_tests_rec.test_code);

499: WHERE test_id = x_gmd_qc_tests_rec.test_id ;
500:
501: IF l_test_values_count = 0 THEN
502: FND_MESSAGE.SET_NAME('GMD','GMD_NO_TEST_VALUES');
503: FND_MESSAGE.SET_TOKEN('TEST',x_gmd_qc_tests_rec.test_code);
504: FND_MSG_PUB.ADD;
505: RAISE FND_API.G_EXC_ERROR;
506: END IF;
507: END IF;

Line 511: IF x_gmd_qc_tests_rec.test_type = 'L' THEN

507: END IF;
508:
509: l_progress := '020';
510:
511: IF x_gmd_qc_tests_rec.test_type = 'L' THEN
512: GMD_QC_TEST_VALUES_GRP.CHECK_RANGE_OVERLAP(
513: p_test_id => x_gmd_qc_tests_rec.test_id,
514: x_min_range => l_min_range,
515: x_max_range => l_max_range,

Line 513: p_test_id => x_gmd_qc_tests_rec.test_id,

509: l_progress := '020';
510:
511: IF x_gmd_qc_tests_rec.test_type = 'L' THEN
512: GMD_QC_TEST_VALUES_GRP.CHECK_RANGE_OVERLAP(
513: p_test_id => x_gmd_qc_tests_rec.test_id,
514: x_min_range => l_min_range,
515: x_max_range => l_max_range,
516: x_return_status => x_return_status,
517: x_message_data => x_message_data);

Line 523: IF x_gmd_qc_tests_rec.exp_error_type = 'N' AND l_min_range IS NOT NULL AND l_max_range IS NOT NULL THEN

519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
520: RETURN;
521: END IF;
522:
523: IF x_gmd_qc_tests_rec.exp_error_type = 'N' AND l_min_range IS NOT NULL AND l_max_range IS NOT NULL THEN
524: gmd_qc_tests_grp.validate_all_exp_error(
525: p_validation_level => 'SPEC',
526: p_exp_error_type => x_gmd_qc_tests_rec.exp_error_type,
527: p_below_spec_min => x_gmd_qc_tests_rec.below_spec_min,

Line 524: gmd_qc_tests_grp.validate_all_exp_error(

520: RETURN;
521: END IF;
522:
523: IF x_gmd_qc_tests_rec.exp_error_type = 'N' AND l_min_range IS NOT NULL AND l_max_range IS NOT NULL THEN
524: gmd_qc_tests_grp.validate_all_exp_error(
525: p_validation_level => 'SPEC',
526: p_exp_error_type => x_gmd_qc_tests_rec.exp_error_type,
527: p_below_spec_min => x_gmd_qc_tests_rec.below_spec_min,
528: p_below_min_action_code => x_gmd_qc_tests_rec.below_min_action_code,

Line 526: p_exp_error_type => x_gmd_qc_tests_rec.exp_error_type,

522:
523: IF x_gmd_qc_tests_rec.exp_error_type = 'N' AND l_min_range IS NOT NULL AND l_max_range IS NOT NULL THEN
524: gmd_qc_tests_grp.validate_all_exp_error(
525: p_validation_level => 'SPEC',
526: p_exp_error_type => x_gmd_qc_tests_rec.exp_error_type,
527: p_below_spec_min => x_gmd_qc_tests_rec.below_spec_min,
528: p_below_min_action_code => x_gmd_qc_tests_rec.below_min_action_code,
529: p_above_spec_min => x_gmd_qc_tests_rec.above_spec_min,
530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,

Line 527: p_below_spec_min => x_gmd_qc_tests_rec.below_spec_min,

523: IF x_gmd_qc_tests_rec.exp_error_type = 'N' AND l_min_range IS NOT NULL AND l_max_range IS NOT NULL THEN
524: gmd_qc_tests_grp.validate_all_exp_error(
525: p_validation_level => 'SPEC',
526: p_exp_error_type => x_gmd_qc_tests_rec.exp_error_type,
527: p_below_spec_min => x_gmd_qc_tests_rec.below_spec_min,
528: p_below_min_action_code => x_gmd_qc_tests_rec.below_min_action_code,
529: p_above_spec_min => x_gmd_qc_tests_rec.above_spec_min,
530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,
531: p_below_spec_max => x_gmd_qc_tests_rec.below_spec_max,

Line 528: p_below_min_action_code => x_gmd_qc_tests_rec.below_min_action_code,

524: gmd_qc_tests_grp.validate_all_exp_error(
525: p_validation_level => 'SPEC',
526: p_exp_error_type => x_gmd_qc_tests_rec.exp_error_type,
527: p_below_spec_min => x_gmd_qc_tests_rec.below_spec_min,
528: p_below_min_action_code => x_gmd_qc_tests_rec.below_min_action_code,
529: p_above_spec_min => x_gmd_qc_tests_rec.above_spec_min,
530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,
531: p_below_spec_max => x_gmd_qc_tests_rec.below_spec_max,
532: p_below_max_action_code => x_gmd_qc_tests_rec.below_max_action_code,

Line 529: p_above_spec_min => x_gmd_qc_tests_rec.above_spec_min,

525: p_validation_level => 'SPEC',
526: p_exp_error_type => x_gmd_qc_tests_rec.exp_error_type,
527: p_below_spec_min => x_gmd_qc_tests_rec.below_spec_min,
528: p_below_min_action_code => x_gmd_qc_tests_rec.below_min_action_code,
529: p_above_spec_min => x_gmd_qc_tests_rec.above_spec_min,
530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,
531: p_below_spec_max => x_gmd_qc_tests_rec.below_spec_max,
532: p_below_max_action_code => x_gmd_qc_tests_rec.below_max_action_code,
533: p_above_spec_max => x_gmd_qc_tests_rec.above_spec_max,

Line 530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,

526: p_exp_error_type => x_gmd_qc_tests_rec.exp_error_type,
527: p_below_spec_min => x_gmd_qc_tests_rec.below_spec_min,
528: p_below_min_action_code => x_gmd_qc_tests_rec.below_min_action_code,
529: p_above_spec_min => x_gmd_qc_tests_rec.above_spec_min,
530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,
531: p_below_spec_max => x_gmd_qc_tests_rec.below_spec_max,
532: p_below_max_action_code => x_gmd_qc_tests_rec.below_max_action_code,
533: p_above_spec_max => x_gmd_qc_tests_rec.above_spec_max,
534: p_above_max_action_code => x_gmd_qc_tests_rec.above_max_action_code,

Line 531: p_below_spec_max => x_gmd_qc_tests_rec.below_spec_max,

527: p_below_spec_min => x_gmd_qc_tests_rec.below_spec_min,
528: p_below_min_action_code => x_gmd_qc_tests_rec.below_min_action_code,
529: p_above_spec_min => x_gmd_qc_tests_rec.above_spec_min,
530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,
531: p_below_spec_max => x_gmd_qc_tests_rec.below_spec_max,
532: p_below_max_action_code => x_gmd_qc_tests_rec.below_max_action_code,
533: p_above_spec_max => x_gmd_qc_tests_rec.above_spec_max,
534: p_above_max_action_code => x_gmd_qc_tests_rec.above_max_action_code,
535: p_test_min => l_min_range,

Line 532: p_below_max_action_code => x_gmd_qc_tests_rec.below_max_action_code,

528: p_below_min_action_code => x_gmd_qc_tests_rec.below_min_action_code,
529: p_above_spec_min => x_gmd_qc_tests_rec.above_spec_min,
530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,
531: p_below_spec_max => x_gmd_qc_tests_rec.below_spec_max,
532: p_below_max_action_code => x_gmd_qc_tests_rec.below_max_action_code,
533: p_above_spec_max => x_gmd_qc_tests_rec.above_spec_max,
534: p_above_max_action_code => x_gmd_qc_tests_rec.above_max_action_code,
535: p_test_min => l_min_range,
536: p_test_max => l_max_range,

Line 533: p_above_spec_max => x_gmd_qc_tests_rec.above_spec_max,

529: p_above_spec_min => x_gmd_qc_tests_rec.above_spec_min,
530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,
531: p_below_spec_max => x_gmd_qc_tests_rec.below_spec_max,
532: p_below_max_action_code => x_gmd_qc_tests_rec.below_max_action_code,
533: p_above_spec_max => x_gmd_qc_tests_rec.above_spec_max,
534: p_above_max_action_code => x_gmd_qc_tests_rec.above_max_action_code,
535: p_test_min => l_min_range,
536: p_test_max => l_max_range,
537: x_return_status => x_return_status,

Line 534: p_above_max_action_code => x_gmd_qc_tests_rec.above_max_action_code,

530: p_above_min_action_code => x_gmd_qc_tests_rec.above_min_action_code,
531: p_below_spec_max => x_gmd_qc_tests_rec.below_spec_max,
532: p_below_max_action_code => x_gmd_qc_tests_rec.below_max_action_code,
533: p_above_spec_max => x_gmd_qc_tests_rec.above_spec_max,
534: p_above_max_action_code => x_gmd_qc_tests_rec.above_max_action_code,
535: p_test_min => l_min_range,
536: p_test_max => l_max_range,
537: x_return_status => x_return_status,
538: x_message_data => x_message_data );

Line 545: UPDATE GMD_QC_TESTS_B

541: RETURN;
542: END IF;
543: END IF;
544:
545: UPDATE GMD_QC_TESTS_B
546: SET min_value_num = l_min_range,
547: max_value_num = l_max_range
548: WHERE
549: test_id = x_gmd_qc_tests_rec.test_id ;

Line 549: test_id = x_gmd_qc_tests_rec.test_id ;

545: UPDATE GMD_QC_TESTS_B
546: SET min_value_num = l_min_range,
547: max_value_num = l_max_range
548: WHERE
549: test_id = x_gmd_qc_tests_rec.test_id ;
550:
551: x_gmd_qc_tests_rec.min_value_num := l_min_range;
552: x_gmd_qc_tests_rec.max_value_num := l_max_range;
553:

Line 551: x_gmd_qc_tests_rec.min_value_num := l_min_range;

547: max_value_num = l_max_range
548: WHERE
549: test_id = x_gmd_qc_tests_rec.test_id ;
550:
551: x_gmd_qc_tests_rec.min_value_num := l_min_range;
552: x_gmd_qc_tests_rec.max_value_num := l_max_range;
553:
554: END IF; -- :gmd_qc_tests.test_type = 'L'
555:

Line 552: x_gmd_qc_tests_rec.max_value_num := l_max_range;

548: WHERE
549: test_id = x_gmd_qc_tests_rec.test_id ;
550:
551: x_gmd_qc_tests_rec.min_value_num := l_min_range;
552: x_gmd_qc_tests_rec.max_value_num := l_max_range;
553:
554: END IF; -- :gmd_qc_tests.test_type = 'L'
555:
556: l_progress := '030';

Line 554: END IF; -- :gmd_qc_tests.test_type = 'L'

550:
551: x_gmd_qc_tests_rec.min_value_num := l_min_range;
552: x_gmd_qc_tests_rec.max_value_num := l_max_range;
553:
554: END IF; -- :gmd_qc_tests.test_type = 'L'
555:
556: l_progress := '030';
557:
558: IF x_gmd_qc_tests_rec.test_type = 'T' THEN

Line 558: IF x_gmd_qc_tests_rec.test_type = 'T' THEN

554: END IF; -- :gmd_qc_tests.test_type = 'L'
555:
556: l_progress := '030';
557:
558: IF x_gmd_qc_tests_rec.test_type = 'T' THEN
559: SELECT MIN(text_range_seq),MAX(text_range_seq)
560: INTO l_min_range,l_max_range
561: FROM GMD_QC_TEST_VALUES_B
562: WHERE test_id = x_gmd_qc_tests_rec.test_id;

Line 562: WHERE test_id = x_gmd_qc_tests_rec.test_id;

558: IF x_gmd_qc_tests_rec.test_type = 'T' THEN
559: SELECT MIN(text_range_seq),MAX(text_range_seq)
560: INTO l_min_range,l_max_range
561: FROM GMD_QC_TEST_VALUES_B
562: WHERE test_id = x_gmd_qc_tests_rec.test_id;
563:
564: UPDATE GMD_QC_TESTS_B
565: SET min_value_num = l_min_range,
566: max_value_num = l_max_range

Line 564: UPDATE GMD_QC_TESTS_B

560: INTO l_min_range,l_max_range
561: FROM GMD_QC_TEST_VALUES_B
562: WHERE test_id = x_gmd_qc_tests_rec.test_id;
563:
564: UPDATE GMD_QC_TESTS_B
565: SET min_value_num = l_min_range,
566: max_value_num = l_max_range
567: WHERE
568: test_id = x_gmd_qc_tests_rec.test_id ;

Line 568: test_id = x_gmd_qc_tests_rec.test_id ;

564: UPDATE GMD_QC_TESTS_B
565: SET min_value_num = l_min_range,
566: max_value_num = l_max_range
567: WHERE
568: test_id = x_gmd_qc_tests_rec.test_id ;
569:
570: x_gmd_qc_tests_rec.min_value_num := l_min_range;
571: x_gmd_qc_tests_rec.max_value_num := l_max_range;
572:

Line 570: x_gmd_qc_tests_rec.min_value_num := l_min_range;

566: max_value_num = l_max_range
567: WHERE
568: test_id = x_gmd_qc_tests_rec.test_id ;
569:
570: x_gmd_qc_tests_rec.min_value_num := l_min_range;
571: x_gmd_qc_tests_rec.max_value_num := l_max_range;
572:
573: END IF; -- end of :gmd_qc_tests.test_type = 'T'
574:

Line 571: x_gmd_qc_tests_rec.max_value_num := l_max_range;

567: WHERE
568: test_id = x_gmd_qc_tests_rec.test_id ;
569:
570: x_gmd_qc_tests_rec.min_value_num := l_min_range;
571: x_gmd_qc_tests_rec.max_value_num := l_max_range;
572:
573: END IF; -- end of :gmd_qc_tests.test_type = 'T'
574:
575: EXCEPTION

Line 573: END IF; -- end of :gmd_qc_tests.test_type = 'T'

569:
570: x_gmd_qc_tests_rec.min_value_num := l_min_range;
571: x_gmd_qc_tests_rec.max_value_num := l_max_range;
572:
573: END IF; -- end of :gmd_qc_tests.test_type = 'T'
574:
575: EXCEPTION
576: WHEN FND_API.G_EXC_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 666: p_gmd_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE,

662: END VALIDATE_BEFORE_DELETE ;
663:
664:
665: PROCEDURE VALIDATE_AFTER_DELETE_ALL(
666: p_gmd_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE,
667: x_gmd_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,
668: x_return_status OUT NOCOPY VARCHAR2,
669: x_message_data OUT NOCOPY VARCHAR2) IS
670:

Line 667: x_gmd_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,

663:
664:
665: PROCEDURE VALIDATE_AFTER_DELETE_ALL(
666: p_gmd_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE,
667: x_gmd_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,
668: x_return_status OUT NOCOPY VARCHAR2,
669: x_message_data OUT NOCOPY VARCHAR2) IS
670:
671: l_progress VARCHAR2(3);

Line 675: p_gmd_qc_tests_rec => p_gmd_qc_tests_rec,

671: l_progress VARCHAR2(3);
672:
673: BEGIN
674: VALIDATE_AFTER_INSERT_ALL(
675: p_gmd_qc_tests_rec => p_gmd_qc_tests_rec,
676: x_gmd_qc_tests_rec => x_gmd_qc_tests_rec,
677: x_return_status => x_return_status,
678: x_message_data => x_message_data ) ;
679:

Line 676: x_gmd_qc_tests_rec => x_gmd_qc_tests_rec,

672:
673: BEGIN
674: VALIDATE_AFTER_INSERT_ALL(
675: p_gmd_qc_tests_rec => p_gmd_qc_tests_rec,
676: x_gmd_qc_tests_rec => x_gmd_qc_tests_rec,
677: x_return_status => x_return_status,
678: x_message_data => x_message_data ) ;
679:
680: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN