APPS.GMD_RESULTS_GRP dependencies on STANDARD

Line 3792: l_standard_deviation NUMBER;

3788: l_high_char VARCHAR2(80);
3789: l_low_num NUMBER;
3790: l_low_char VARCHAR2(80);
3791: l_range NUMBER;
3792: l_standard_deviation NUMBER;
3793:
3794: l_display_precision NUMBER(2);
3795: l_t_display_precision NUMBER(2);
3796: l_st_display_precision NUMBER(2);

Line 3917: l_standard_deviation := NULL;

3913: l_high_char := NULL;
3914: l_low_num := NULL;
3915: l_low_char := NULL;
3916: l_range := NULL;
3917: l_standard_deviation := NULL;
3918:
3919: IF (l_debug = 'Y') THEN
3920: gmd_debug.put_line(' Processing Test ID-' || test_rec.test_id);
3921: END IF;

Line 3994: -- 6. Standard Deviation

3990: IF (l_debug = 'Y') THEN
3991: gmd_debug.put_line(' l_low_num - '|| l_low_num ||' l_low_char-'|| l_low_char);
3992: END IF;
3993:
3994: -- 6. Standard Deviation
3995: qc_standard_deviation( p_test_id => test_rec.test_id
3996: , x_stddev => l_standard_deviation
3997: , x_return_status => l_return_status);
3998:

Line 3995: qc_standard_deviation( p_test_id => test_rec.test_id

3991: gmd_debug.put_line(' l_low_num - '|| l_low_num ||' l_low_char-'|| l_low_char);
3992: END IF;
3993:
3994: -- 6. Standard Deviation
3995: qc_standard_deviation( p_test_id => test_rec.test_id
3996: , x_stddev => l_standard_deviation
3997: , x_return_status => l_return_status);
3998:
3999: IF (l_return_status <> 'S') THEN

Line 3996: , x_stddev => l_standard_deviation

3992: END IF;
3993:
3994: -- 6. Standard Deviation
3995: qc_standard_deviation( p_test_id => test_rec.test_id
3996: , x_stddev => l_standard_deviation
3997: , x_return_status => l_return_status);
3998:
3999: IF (l_return_status <> 'S') THEN
4000: RAISE FND_API.G_EXC_ERROR;

Line 4004: l_standard_deviation := round(l_standard_deviation, l_display_precision);

4000: RAISE FND_API.G_EXC_ERROR;
4001: END IF;
4002:
4003: IF (l_test_type in ('N', 'L', 'E')) THEN
4004: l_standard_deviation := round(l_standard_deviation, l_display_precision);
4005: END IF;
4006: IF (l_debug = 'Y') THEN
4007: gmd_debug.put_line(' l_standard_deviation - '|| l_standard_deviation);
4008: END IF;

Line 4007: gmd_debug.put_line(' l_standard_deviation - '|| l_standard_deviation);

4003: IF (l_test_type in ('N', 'L', 'E')) THEN
4004: l_standard_deviation := round(l_standard_deviation, l_display_precision);
4005: END IF;
4006: IF (l_debug = 'Y') THEN
4007: gmd_debug.put_line(' l_standard_deviation - '|| l_standard_deviation);
4008: END IF;
4009:
4010: -- Now, we have all the composite values for the test so create
4011: -- a new record in GMD_COMPOSITE_RESULTS

Line 4030: l_composite_result.STANDARD_DEVIATION := l_standard_deviation;

4026: l_composite_result.RANGE := l_high_num - l_low_num;
4027: ELSE
4028: l_composite_result.RANGE := NULL;
4029: END IF;
4030: l_composite_result.STANDARD_DEVIATION := l_standard_deviation;
4031:
4032: l_composite_result.IN_SPEC_IND :=
4033: rslt_is_in_spec
4034: (p_spec_id => l_spec_id,

Line 4738: --| API Name : qc_standard_deviation |

4734:
4735:
4736: --Start of comments
4737: --+========================================================================+
4738: --| API Name : qc_standard_deviation |
4739: --| TYPE : Group |
4740: --| Notes : WRITE SOMETHING HERE |
4741: --| |
4742: --| |

Line 4750: PROCEDURE qc_standard_deviation

4746: --| |
4747: --+========================================================================+
4748: -- End of comments
4749:
4750: PROCEDURE qc_standard_deviation
4751: (
4752: p_test_id IN NUMBER
4753: , x_stddev OUT NOCOPY NUMBER
4754: , x_return_status OUT NOCOPY VARCHAR2

Line 4779: gmd_debug.put_line('Entering Procedure - QC_STANDARD_DEVIATION');

4775:
4776: BEGIN
4777:
4778: IF (l_debug = 'Y') THEN
4779: gmd_debug.put_line('Entering Procedure - QC_STANDARD_DEVIATION');
4780: END IF;
4781:
4782: -- Initialize API return status to success
4783: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4797: gmd_debug.put_line('Leaving Procedure - QC_STANDARD_DEVIATION');

4793: CLOSE c_stddev;
4794: END IF;
4795:
4796: IF (l_debug = 'Y') THEN
4797: gmd_debug.put_line('Leaving Procedure - QC_STANDARD_DEVIATION');
4798: END IF;
4799:
4800: RETURN;
4801:

Line 4809: 'PACKAGE','qc_standard_deviation',

4805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4807: WHEN OTHERS THEN
4808: GMD_API_PUB.Log_Message('GMD_API_ERROR',
4809: 'PACKAGE','qc_standard_deviation',
4810: 'ERROR', SUBSTR(SQLERRM,1,100));
4811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4812:
4813: END qc_standard_deviation;

Line 4813: END qc_standard_deviation;

4809: 'PACKAGE','qc_standard_deviation',
4810: 'ERROR', SUBSTR(SQLERRM,1,100));
4811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4812:
4813: END qc_standard_deviation;
4814:
4815: --+========================================================================+
4816: --| API Name : get_composite_rslt |
4817: --| TYPE : Group |