APPS.GMD_RESULTS_GRP dependencies on STANDARD

Line 3961: l_standard_deviation NUMBER;

3957: l_high_char VARCHAR2(80);
3958: l_low_num NUMBER;
3959: l_low_char VARCHAR2(80);
3960: l_range NUMBER;
3961: l_standard_deviation NUMBER;
3962:
3963: l_display_precision NUMBER(2);
3964: l_t_display_precision NUMBER(2);
3965: l_st_display_precision NUMBER(2);

Line 4086: l_standard_deviation := NULL;

4082: l_high_char := NULL;
4083: l_low_num := NULL;
4084: l_low_char := NULL;
4085: l_range := NULL;
4086: l_standard_deviation := NULL;
4087:
4088: IF (l_debug = 'Y') THEN
4089: gmd_debug.put_line(' Processing Test ID-' || test_rec.test_id);
4090: END IF;

Line 4163: -- 6. Standard Deviation

4159: IF (l_debug = 'Y') THEN
4160: gmd_debug.put_line(' l_low_num - '|| l_low_num ||' l_low_char-'|| l_low_char);
4161: END IF;
4162:
4163: -- 6. Standard Deviation
4164: qc_standard_deviation( p_test_id => test_rec.test_id
4165: , x_stddev => l_standard_deviation
4166: , x_return_status => l_return_status);
4167:

Line 4164: qc_standard_deviation( p_test_id => test_rec.test_id

4160: gmd_debug.put_line(' l_low_num - '|| l_low_num ||' l_low_char-'|| l_low_char);
4161: END IF;
4162:
4163: -- 6. Standard Deviation
4164: qc_standard_deviation( p_test_id => test_rec.test_id
4165: , x_stddev => l_standard_deviation
4166: , x_return_status => l_return_status);
4167:
4168: IF (l_return_status <> 'S') THEN

Line 4165: , x_stddev => l_standard_deviation

4161: END IF;
4162:
4163: -- 6. Standard Deviation
4164: qc_standard_deviation( p_test_id => test_rec.test_id
4165: , x_stddev => l_standard_deviation
4166: , x_return_status => l_return_status);
4167:
4168: IF (l_return_status <> 'S') THEN
4169: RAISE FND_API.G_EXC_ERROR;

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

4169: RAISE FND_API.G_EXC_ERROR;
4170: END IF;
4171:
4172: IF (l_test_type in ('N', 'L', 'E')) THEN
4173: l_standard_deviation := round(l_standard_deviation, l_display_precision);
4174: END IF;
4175: IF (l_debug = 'Y') THEN
4176: gmd_debug.put_line(' l_standard_deviation - '|| l_standard_deviation);
4177: END IF;

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

4172: IF (l_test_type in ('N', 'L', 'E')) THEN
4173: l_standard_deviation := round(l_standard_deviation, l_display_precision);
4174: END IF;
4175: IF (l_debug = 'Y') THEN
4176: gmd_debug.put_line(' l_standard_deviation - '|| l_standard_deviation);
4177: END IF;
4178:
4179: -- Now, we have all the composite values for the test so create
4180: -- a new record in GMD_COMPOSITE_RESULTS

Line 4199: l_composite_result.STANDARD_DEVIATION := l_standard_deviation;

4195: l_composite_result.RANGE := l_high_num - l_low_num;
4196: ELSE
4197: l_composite_result.RANGE := NULL;
4198: END IF;
4199: l_composite_result.STANDARD_DEVIATION := l_standard_deviation;
4200:
4201: l_composite_result.IN_SPEC_IND :=
4202: rslt_is_in_spec
4203: (p_spec_id => l_spec_id,

Line 4907: --| API Name : qc_standard_deviation |

4903:
4904:
4905: --Start of comments
4906: --+========================================================================+
4907: --| API Name : qc_standard_deviation |
4908: --| TYPE : Group |
4909: --| Notes : WRITE SOMETHING HERE |
4910: --| |
4911: --| |

Line 4919: PROCEDURE qc_standard_deviation

4915: --| |
4916: --+========================================================================+
4917: -- End of comments
4918:
4919: PROCEDURE qc_standard_deviation
4920: (
4921: p_test_id IN NUMBER
4922: , x_stddev OUT NOCOPY NUMBER
4923: , x_return_status OUT NOCOPY VARCHAR2

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

4944:
4945: BEGIN
4946:
4947: IF (l_debug = 'Y') THEN
4948: gmd_debug.put_line('Entering Procedure - QC_STANDARD_DEVIATION');
4949: END IF;
4950:
4951: -- Initialize API return status to success
4952: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4962: CLOSE c_stddev;
4963: END IF;
4964:
4965: IF (l_debug = 'Y') THEN
4966: gmd_debug.put_line('Leaving Procedure - QC_STANDARD_DEVIATION');
4967: END IF;
4968:
4969: RETURN;
4970:

Line 4978: 'PACKAGE','qc_standard_deviation',

4974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4976: WHEN OTHERS THEN
4977: GMD_API_PUB.Log_Message('GMD_API_ERROR',
4978: 'PACKAGE','qc_standard_deviation',
4979: 'ERROR', SUBSTR(SQLERRM,1,100));
4980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4981:
4982: END qc_standard_deviation;

Line 4982: END qc_standard_deviation;

4978: 'PACKAGE','qc_standard_deviation',
4979: 'ERROR', SUBSTR(SQLERRM,1,100));
4980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4981:
4982: END qc_standard_deviation;
4983:
4984: --+========================================================================+
4985: --| API Name : get_composite_rslt |
4986: --| TYPE : Group |