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_RESULTS_GRP dependencies on GMD_RESULTS_GRP

Line 1: PACKAGE BODY gmd_results_grp AS

1: PACKAGE BODY gmd_results_grp AS
2: --$Header: GMDGRESB.pls 120.29.12020000.5 2012/12/05 17:59:43 plowe ship $
3:
4: -- Global variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RESULTS_GRP';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RESULTS_GRP';

1: PACKAGE BODY gmd_results_grp AS
2: --$Header: GMDGRESB.pls 120.29.12020000.5 2012/12/05 17:59:43 plowe ship $
3:
4: -- Global variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RESULTS_GRP';
6: --Bug 3222090, magupta removed call to FND_PROFILE.VALUE('AFLOG_ENABLED')
7: --forward decl.
8: function set_debug_flag return varchar2;
9: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 32: --| Package Name : GMD_RESULTS_GRP |

28: --| Redwood Shores, CA, USA |
29: --| All rights reserved. |
30: --+==========================================================================+
31: --| File Name : GMDGRESB.pls |
32: --| Package Name : GMD_RESULTS_GRP |
33: --| Type : Group |
34: --| |
35: --| Notes |
36: --| This package contains group layer APIs for Results Entity |

Line 2580: GMD_RESULTS_GRP.check_experimental_error ( x_rec

2576: END IF;
2577:
2578:
2579: IF x_rec.test_type in ('N', 'L', 'E') THEN
2580: GMD_RESULTS_GRP.check_experimental_error ( x_rec
2581: , l_return_status );
2582: IF (l_return_status <> 'S') THEN
2583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2584: END IF;

Line 2631: gmd_debug.put_line(' gmd_results_grp.make_target_spec_the_base_spec Insert Error from GMD_SPEC_RESULTS_PVT.Insert_Row RAISE e_spec_results_insert_error ');

2627: THEN
2628: -- Insert Error
2629:
2630: IF (l_debug = 'Y') THEN
2631: gmd_debug.put_line(' gmd_results_grp.make_target_spec_the_base_spec Insert Error from GMD_SPEC_RESULTS_PVT.Insert_Row RAISE e_spec_results_insert_error ');
2632: END IF;
2633:
2634: RAISE e_spec_results_insert_error;
2635: END IF;

Line 2733: gmd_results_grp.change_sample_disposition

2729: END LOOP; -- Spec Tests Loop
2730:
2731: -- Now all the test adding business is over. So let's see it the sample disposition
2732: -- can be changed to Complete
2733: gmd_results_grp.change_sample_disposition
2734: ( p_sample_id => l_sample.sample_id
2735: , x_change_disp_to => l_change_disp_to
2736: , x_return_status => l_return_status
2737: , x_message_data => l_message_data

Line 2973: x_results_rec_tbl OUT NOCOPY GMD_RESULTS_GRP.gmd_results_rec_tbl,

2969: p_sample_id IN NUMBER,
2970: p_source_spec_id IN NUMBER,
2971: p_target_spec_id IN NUMBER,
2972: p_event_spec_disp_id IN NUMBER,
2973: x_results_rec_tbl OUT NOCOPY GMD_RESULTS_GRP.gmd_results_rec_tbl,
2974: x_return_status OUT NOCOPY VARCHAR2) IS
2975:
2976:
2977: /* Local Variables */

Line 2988: l_results_rec_tbl GMD_RESULTS_GRP.gmd_results_rec_tbl;

2984: l_display_label VARCHAR2(80);
2985: l_spec_ind VARCHAR2(1);
2986: l_test_id NUMBER;
2987:
2988: l_results_rec_tbl GMD_RESULTS_GRP.gmd_results_rec_tbl;
2989:
2990: x_test_ids GMD_API_PUB.number_tab;
2991: l_sample_id GMD_API_PUB.number_tab;
2992: return_status VARCHAR2(1);

Line 3120: GMD_RESULTS_GRP.populate_result_data_points(p_sample_ids => l_sample_id,

3116: i := 0;
3117:
3118: -- Added Sep24 for getting tests without results
3119: l_sample_id(1) := p_sample_id;
3120: GMD_RESULTS_GRP.populate_result_data_points(p_sample_ids => l_sample_id,
3121: p_event_spec_disp_id => p_event_spec_disp_id,
3122: x_return_status => x_return_status);
3123:
3124: -- Get the results for each sample and spec

Line 3260: l_results_rec_tbl(i).in_spec := GMD_RESULTS_GRP.rslt_is_in_spec(p_source_spec_id,

3256: IF (l_debug = 'Y') THEN
3257: gmd_debug.put_line('Got the Test and Spec info');
3258: END IF;
3259:
3260: l_results_rec_tbl(i).in_spec := GMD_RESULTS_GRP.rslt_is_in_spec(p_source_spec_id,
3261: l_results_rec_tbl(i).test_id,
3262: l_results_rec_tbl(i).result_num,
3263: l_results_rec_tbl(i).result_char);
3264: IF (l_debug = 'Y') THEN

Line 3267: l_results_rec_tbl(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec( p_target_spec_id,

3263: l_results_rec_tbl(i).result_char);
3264: IF (l_debug = 'Y') THEN
3265: gmd_debug.put_line('in spec res '||l_results_rec_tbl(i).in_spec);
3266: END IF;
3267: l_results_rec_tbl(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec( p_target_spec_id,
3268: l_results_rec_tbl(i).test_id,
3269: l_results_rec_tbl(i).result_num,
3270: l_results_rec_tbl(i).result_char);
3271:

Line 3282: GMD_RESULTS_GRP.compare_rslt_and_spec(p_sample_id,

3278:
3279: j := i;
3280: l_spec_id := p_target_spec_id;
3281:
3282: GMD_RESULTS_GRP.compare_rslt_and_spec(p_sample_id,
3283: l_spec_id,
3284: x_test_ids,
3285: return_status);
3286:

Line 3296: l_results_rec_tbl(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec( p_target_spec_id,

3292: CLOSE c_get_type;
3293: l_results_rec_tbl(i).test_code := LocalTypeRec.test_code;
3294: l_results_rec_tbl(i).test_type := LocalTypeRec.test_type;
3295: l_results_rec_tbl(i).spec_test_id := l_test_id;
3296: l_results_rec_tbl(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec( p_target_spec_id,
3297: l_test_id,
3298: l_results_rec_tbl(i).result_num,
3299: l_results_rec_tbl(i).result_char);
3300: IF (l_debug = 'Y') THEN

Line 5007: x_comresults_tab OUT NOCOPY GMD_RESULTS_GRP.gmd_comres_tab,

5003: (
5004: p_composite_spec_disp_id IN NUMBER,
5005: p_source_spec_id IN NUMBER,
5006: p_target_spec_id IN NUMBER,
5007: x_comresults_tab OUT NOCOPY GMD_RESULTS_GRP.gmd_comres_tab,
5008: x_return_status OUT NOCOPY VARCHAR2) IS
5009:
5010: -- Local Variables
5011:

Line 5025: l_comres_tab GMD_RESULTS_GRP.gmd_comres_tab;

5021: l_mode_char VARCHAR2(80);
5022: l_median_num NUMBER;
5023: l_median_char VARCHAR2(80);
5024:
5025: l_comres_tab GMD_RESULTS_GRP.gmd_comres_tab;
5026: return_status VARCHAR2(1);
5027: x_test_ids GMD_API_PUB.number_tab;
5028:
5029:

Line 5162: l_comres_tab(i).in_spec := GMD_RESULTS_GRP.rslt_is_in_spec

5158: END IF;
5159: CLOSE c_get_spec_test_char;
5160:
5161: END IF;
5162: l_comres_tab(i).in_spec := GMD_RESULTS_GRP.rslt_is_in_spec
5163: ( p_source_spec_id, l_test_id, l_comres_tab(i).result_num, l_comres_tab(i).result_char);
5164: IF (l_debug = 'Y') THEN
5165: gmd_debug.put_line('in speca '||l_comres_tab(i).in_spec);
5166: END IF;

Line 5167: l_comres_tab(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec

5163: ( p_source_spec_id, l_test_id, l_comres_tab(i).result_num, l_comres_tab(i).result_char);
5164: IF (l_debug = 'Y') THEN
5165: gmd_debug.put_line('in speca '||l_comres_tab(i).in_spec);
5166: END IF;
5167: l_comres_tab(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec
5168: ( p_target_spec_id, l_test_id, l_comres_tab(i).result_num, l_comres_tab(i).result_char);
5169: IF (l_debug = 'Y') THEN
5170: gmd_debug.put_line('in spec '||l_comres_tab(i).spec_in_spec);
5171: END IF;

Line 5179: GMD_RESULTS_GRP.compare_cmpst_rslt_and_spec

5175: END LOOP; -- Composite Results test Loop
5176: j := i;
5177: l_spec_id := p_target_spec_id;
5178:
5179: GMD_RESULTS_GRP.compare_cmpst_rslt_and_spec
5180: (p_composite_spec_disp_id, l_spec_id, x_test_ids, return_status);
5181:
5182: FOR k in 1..x_test_ids.COUNT LOOP
5183: i := i + k;

Line 5217: l_comres_tab(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec

5213: END IF;
5214: CLOSE c_get_spec_test_char;
5215: END IF;
5216:
5217: l_comres_tab(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec
5218: ( p_target_spec_id, l_test_id, l_comres_tab(i).result_num, l_comres_tab(i).result_char);
5219: IF (l_debug = 'Y') THEN
5220: gmd_debug.put_line('in spec1 '||l_comres_tab(i).spec_in_spec);
5221: END IF;

Line 5722: p_result_rec.in_spec := GMD_RESULTS_GRP.rslt_is_in_spec

5718: --#. be a spec. So we can use the canned in_spec function.
5719: --#. With additional tests, there is not a spec.
5720: --#. ===================================================
5721:
5722: p_result_rec.in_spec := GMD_RESULTS_GRP.rslt_is_in_spec
5723: (p_spec_id => p_result_rec.spec_id,
5724: p_test_id => p_result_rec.test_id,
5725: p_rslt_value_num => p_result_rec.result_num,
5726: p_rslt_value_char => p_result_rec.result_char);

Line 5742: GMD_RESULTS_GRP.check_experimental_error ( p_result_rec

5738: END IF;
5739:
5740: IF p_result_rec.test_type in ('N', 'L', 'E') THEN
5741:
5742: GMD_RESULTS_GRP.check_experimental_error ( p_result_rec
5743: , x_return_status );
5744: IF (x_return_status <> 'S') THEN
5745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5746: END IF;

Line 6279: GMD_RESULTS_GRP.validate_result(x_rec,l_return_status);

6275: x_rec.additional_test_ind :=l_additional_test_ind;
6276: x_rec.min_num := l_min_value_num;
6277: x_rec.max_num := l_max_value_num;
6278:
6279: GMD_RESULTS_GRP.validate_result(x_rec,l_return_status);
6280: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6281: RAISE FND_API.G_EXC_ERROR;
6282: END IF;
6283: --Updating the gmd_spec_results table, with proper values

Line 7338: gmd_results_grp.composite_exist(

7334:
7335: l_composite_exist := 'N';
7336: l_composite_valid := 'N';
7337:
7338: gmd_results_grp.composite_exist(
7339: p_sampling_event_id => l_sampling_event.sampling_event_id
7340: , p_event_spec_disp_id => NULL
7341: , x_composite_exist => l_composite_exist
7342: , x_composite_valid => l_composite_valid

Line 7352: GMD_RESULTS_GRP.get_sample_ids_for_se(l_sampling_event.sampling_event_id,

7348:
7349: IF ((l_composite_exist = 'N') OR
7350: (l_composite_exist = 'Y' AND l_composite_valid = 'N')) THEN
7351: -- Get all the sample IDs for this Sampling Event
7352: GMD_RESULTS_GRP.get_sample_ids_for_se(l_sampling_event.sampling_event_id,
7353: l_sample_ids,
7354: l_return_status);
7355: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7356: RAISE FND_API.G_EXC_ERROR;

Line 7360: GMD_RESULTS_GRP.populate_result_data_points

7356: RAISE FND_API.G_EXC_ERROR;
7357: END IF;
7358:
7359: -- Populate Session Temp Table with Data Points
7360: GMD_RESULTS_GRP.populate_result_data_points
7361: (p_sample_ids => l_sample_ids,
7362: p_event_spec_disp_id => l_event_spec_disp_id,
7363: x_return_status => l_return_status);
7364: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 7369: GMD_RESULTS_GRP.create_composite_rows

7365: RAISE FND_API.G_EXC_ERROR;
7366: END IF;
7367:
7368: -- Create new Composite Rows
7369: GMD_RESULTS_GRP.create_composite_rows
7370: (p_event_spec_disp_id => l_event_spec_disp_id,
7371: x_return_Status => l_return_status);
7372: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7373: RAISE FND_API.G_EXC_ERROR;

Line 7594: l_rslt_tbl gmd_results_grp.rslt_tbl;

7590: --| |
7591: --+========================================================================+
7592: -- End of comments
7593: IS
7594: l_rslt_tbl gmd_results_grp.rslt_tbl;
7595: l_return_status VARCHAR2(10);
7596: l_sts BOOLEAN;
7597: l_start_date DATE := GMA_CORE_PKG.get_date_constant_d('SY$MIN_DATE');
7598:

Line 7726: END gmd_results_grp;

7722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7723:
7724: END populate_result_data_points_r;
7725:
7726: END gmd_results_grp;