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.20.12010000.1 2008/07/24 09:54:19 appldev 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.20.12010000.1 2008/07/24 09:54:19 appldev 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 2446: GMD_RESULTS_GRP.check_experimental_error ( x_rec

2442: x_rec.result_num := ROUND(to_number(x_rec.result) ,x_rec.display_precision);
2443: x_rec.result := ROUND(to_number(x_rec.result) ,x_rec.display_precision);
2444:
2445: IF x_rec.test_type in ('N', 'L', 'E') THEN
2446: GMD_RESULTS_GRP.check_experimental_error ( x_rec
2447: , l_return_status );
2448: IF (l_return_status <> 'S') THEN
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: END IF;

Line 2582: gmd_results_grp.change_sample_disposition

2578: END LOOP; -- Spec Tests Loop
2579:
2580: -- Now all the test adding business is over. So let's see it the sample disposition
2581: -- can be changed to Complete
2582: gmd_results_grp.change_sample_disposition
2583: ( p_sample_id => l_sample.sample_id
2584: , x_change_disp_to => l_change_disp_to
2585: , x_return_status => l_return_status
2586: , x_message_data => l_message_data

Line 2805: x_results_rec_tbl OUT NOCOPY GMD_RESULTS_GRP.gmd_results_rec_tbl,

2801: p_sample_id IN NUMBER,
2802: p_source_spec_id IN NUMBER,
2803: p_target_spec_id IN NUMBER,
2804: p_event_spec_disp_id IN NUMBER,
2805: x_results_rec_tbl OUT NOCOPY GMD_RESULTS_GRP.gmd_results_rec_tbl,
2806: x_return_status OUT NOCOPY VARCHAR2) IS
2807:
2808:
2809: /* Local Variables */

Line 2820: l_results_rec_tbl GMD_RESULTS_GRP.gmd_results_rec_tbl;

2816: l_display_label VARCHAR2(80);
2817: l_spec_ind VARCHAR2(1);
2818: l_test_id NUMBER;
2819:
2820: l_results_rec_tbl GMD_RESULTS_GRP.gmd_results_rec_tbl;
2821:
2822: x_test_ids GMD_API_PUB.number_tab;
2823: l_sample_id GMD_API_PUB.number_tab;
2824: return_status VARCHAR2(1);

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

2948: i := 0;
2949:
2950: -- Added Sep24 for getting tests without results
2951: l_sample_id(1) := p_sample_id;
2952: GMD_RESULTS_GRP.populate_result_data_points(p_sample_ids => l_sample_id,
2953: p_event_spec_disp_id => p_event_spec_disp_id,
2954: x_return_status => x_return_status);
2955:
2956: -- Get the results for each sample and spec

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

3088: IF (l_debug = 'Y') THEN
3089: gmd_debug.put_line('Got the Test and Spec info');
3090: END IF;
3091:
3092: l_results_rec_tbl(i).in_spec := GMD_RESULTS_GRP.rslt_is_in_spec(p_source_spec_id,
3093: l_results_rec_tbl(i).test_id,
3094: l_results_rec_tbl(i).result_num,
3095: l_results_rec_tbl(i).result_char);
3096: IF (l_debug = 'Y') THEN

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

3095: l_results_rec_tbl(i).result_char);
3096: IF (l_debug = 'Y') THEN
3097: gmd_debug.put_line('in spec res '||l_results_rec_tbl(i).in_spec);
3098: END IF;
3099: l_results_rec_tbl(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec( p_target_spec_id,
3100: l_results_rec_tbl(i).test_id,
3101: l_results_rec_tbl(i).result_num,
3102: l_results_rec_tbl(i).result_char);
3103: IF (l_debug = 'Y') THEN

Line 3113: GMD_RESULTS_GRP.compare_rslt_and_spec(p_sample_id,

3109:
3110: j := i;
3111: l_spec_id := p_target_spec_id;
3112:
3113: GMD_RESULTS_GRP.compare_rslt_and_spec(p_sample_id,
3114: l_spec_id,
3115: x_test_ids,
3116: return_status);
3117:

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

3123: CLOSE c_get_type;
3124: l_results_rec_tbl(i).test_code := LocalTypeRec.test_code;
3125: l_results_rec_tbl(i).test_type := LocalTypeRec.test_type;
3126: l_results_rec_tbl(i).spec_test_id := l_test_id;
3127: l_results_rec_tbl(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec( p_target_spec_id,
3128: l_test_id,
3129: l_results_rec_tbl(i).result_num,
3130: l_results_rec_tbl(i).result_char);
3131: IF (l_debug = 'Y') THEN

Line 4838: x_comresults_tab OUT NOCOPY GMD_RESULTS_GRP.gmd_comres_tab,

4834: (
4835: p_composite_spec_disp_id IN NUMBER,
4836: p_source_spec_id IN NUMBER,
4837: p_target_spec_id IN NUMBER,
4838: x_comresults_tab OUT NOCOPY GMD_RESULTS_GRP.gmd_comres_tab,
4839: x_return_status OUT NOCOPY VARCHAR2) IS
4840:
4841: -- Local Variables
4842:

Line 4856: l_comres_tab GMD_RESULTS_GRP.gmd_comres_tab;

4852: l_mode_char VARCHAR2(80);
4853: l_median_num NUMBER;
4854: l_median_char VARCHAR2(80);
4855:
4856: l_comres_tab GMD_RESULTS_GRP.gmd_comres_tab;
4857: return_status VARCHAR2(1);
4858: x_test_ids GMD_API_PUB.number_tab;
4859:
4860:

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

4989: END IF;
4990: CLOSE c_get_spec_test_char;
4991:
4992: END IF;
4993: l_comres_tab(i).in_spec := GMD_RESULTS_GRP.rslt_is_in_spec
4994: ( p_source_spec_id, l_test_id, l_comres_tab(i).result_num, l_comres_tab(i).result_char);
4995: IF (l_debug = 'Y') THEN
4996: gmd_debug.put_line('in speca '||l_comres_tab(i).in_spec);
4997: END IF;

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

4994: ( p_source_spec_id, l_test_id, l_comres_tab(i).result_num, l_comres_tab(i).result_char);
4995: IF (l_debug = 'Y') THEN
4996: gmd_debug.put_line('in speca '||l_comres_tab(i).in_spec);
4997: END IF;
4998: l_comres_tab(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec
4999: ( p_target_spec_id, l_test_id, l_comres_tab(i).result_num, l_comres_tab(i).result_char);
5000: IF (l_debug = 'Y') THEN
5001: gmd_debug.put_line('in spec '||l_comres_tab(i).spec_in_spec);
5002: END IF;

Line 5010: GMD_RESULTS_GRP.compare_cmpst_rslt_and_spec

5006: END LOOP; -- Composite Results test Loop
5007: j := i;
5008: l_spec_id := p_target_spec_id;
5009:
5010: GMD_RESULTS_GRP.compare_cmpst_rslt_and_spec
5011: (p_composite_spec_disp_id, l_spec_id, x_test_ids, return_status);
5012:
5013: FOR k in 1..x_test_ids.COUNT LOOP
5014: i := i + k;

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

5044: END IF;
5045: CLOSE c_get_spec_test_char;
5046: END IF;
5047:
5048: l_comres_tab(i).spec_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec
5049: ( p_target_spec_id, l_test_id, l_comres_tab(i).result_num, l_comres_tab(i).result_char);
5050: IF (l_debug = 'Y') THEN
5051: gmd_debug.put_line('in spec1 '||l_comres_tab(i).spec_in_spec);
5052: END IF;

Line 5551: p_result_rec.in_spec := GMD_RESULTS_GRP.rslt_is_in_spec

5547: --#. be a spec. So we can use the canned in_spec function.
5548: --#. With additional tests, there is not a spec.
5549: --#. ===================================================
5550:
5551: p_result_rec.in_spec := GMD_RESULTS_GRP.rslt_is_in_spec
5552: (p_spec_id => p_result_rec.spec_id,
5553: p_test_id => p_result_rec.test_id,
5554: p_rslt_value_num => p_result_rec.result_num,
5555: p_rslt_value_char => p_result_rec.result_char);

Line 5567: GMD_RESULTS_GRP.check_experimental_error ( p_result_rec

5563: END IF;
5564:
5565: IF p_result_rec.test_type in ('N', 'L', 'E') THEN
5566:
5567: GMD_RESULTS_GRP.check_experimental_error ( p_result_rec
5568: , x_return_status );
5569: IF (x_return_status <> 'S') THEN
5570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5571: END IF;

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

6038: x_rec.additional_test_ind :=l_additional_test_ind;
6039: x_rec.min_num := l_min_value_num;
6040: x_rec.max_num := l_max_value_num;
6041:
6042: GMD_RESULTS_GRP.validate_result(x_rec,l_return_status);
6043: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6044: RAISE FND_API.G_EXC_ERROR;
6045: END IF;
6046: --Updating the gmd_spec_results table, with proper values

Line 6961: gmd_results_grp.composite_exist(

6957:
6958: l_composite_exist := 'N';
6959: l_composite_valid := 'N';
6960:
6961: gmd_results_grp.composite_exist(
6962: p_sampling_event_id => l_sampling_event.sampling_event_id
6963: , p_event_spec_disp_id => NULL
6964: , x_composite_exist => l_composite_exist
6965: , x_composite_valid => l_composite_valid

Line 6975: GMD_RESULTS_GRP.get_sample_ids_for_se(l_sampling_event.sampling_event_id,

6971:
6972: IF ((l_composite_exist = 'N') OR
6973: (l_composite_exist = 'Y' AND l_composite_valid = 'N')) THEN
6974: -- Get all the sample IDs for this Sampling Event
6975: GMD_RESULTS_GRP.get_sample_ids_for_se(l_sampling_event.sampling_event_id,
6976: l_sample_ids,
6977: l_return_status);
6978: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6979: RAISE FND_API.G_EXC_ERROR;

Line 6983: GMD_RESULTS_GRP.populate_result_data_points

6979: RAISE FND_API.G_EXC_ERROR;
6980: END IF;
6981:
6982: -- Populate Session Temp Table with Data Points
6983: GMD_RESULTS_GRP.populate_result_data_points
6984: (p_sample_ids => l_sample_ids,
6985: p_event_spec_disp_id => l_event_spec_disp_id,
6986: x_return_status => l_return_status);
6987: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 6992: GMD_RESULTS_GRP.create_composite_rows

6988: RAISE FND_API.G_EXC_ERROR;
6989: END IF;
6990:
6991: -- Create new Composite Rows
6992: GMD_RESULTS_GRP.create_composite_rows
6993: (p_event_spec_disp_id => l_event_spec_disp_id,
6994: x_return_Status => l_return_status);
6995: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6996: RAISE FND_API.G_EXC_ERROR;

Line 7217: l_rslt_tbl gmd_results_grp.rslt_tbl;

7213: --| |
7214: --+========================================================================+
7215: -- End of comments
7216: IS
7217: l_rslt_tbl gmd_results_grp.rslt_tbl;
7218: l_return_status VARCHAR2(10);
7219: l_sts BOOLEAN;
7220: l_start_date DATE := GMA_CORE_PKG.get_date_constant_d('SY$MIN_DATE');
7221:

Line 7267: END gmd_results_grp;

7263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7264:
7265: END update_exptest_value_null;
7266:
7267: END gmd_results_grp;