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_QUALITY_GRP dependencies on GMD_QUALITY_GRP

Line 1: PACKAGE BODY GMD_QUALITY_GRP AS

1: PACKAGE BODY GMD_QUALITY_GRP AS
2: /* $Header: GMDGQCMB.pls 120.1 2005/06/21 04:09:04 appldev ship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='GMD_QUALITY_GRP';

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

1: PACKAGE BODY GMD_QUALITY_GRP AS
2: /* $Header: GMDGQCMB.pls 120.1 2005/06/21 04:09:04 appldev ship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='GMD_QUALITY_GRP';
6:
7:
8: /* ************************************************************************ */
9: /* API name : get_display_precision */

Line 86: x_results GMD_QUALITY_GRP.inv_rslt_out_rec_type;

82: , x_return_status OUT NOCOPY VARCHAR2
83: )
84: IS
85: l_api_name VARCHAR2(100) := 'GET_INV_TEST_VALUE';
86: x_results GMD_QUALITY_GRP.inv_rslt_out_rec_type;
87: x_spec_tests GMD_QUALITY_GRP.inv_spec_out_rec_type;
88:
89: /* Bug#3412075 - Define the local variable */
90: l_spec_tests GMD_QUALITY_GRP.inv_spec_out_rec_type;

Line 87: x_spec_tests GMD_QUALITY_GRP.inv_spec_out_rec_type;

83: )
84: IS
85: l_api_name VARCHAR2(100) := 'GET_INV_TEST_VALUE';
86: x_results GMD_QUALITY_GRP.inv_rslt_out_rec_type;
87: x_spec_tests GMD_QUALITY_GRP.inv_spec_out_rec_type;
88:
89: /* Bug#3412075 - Define the local variable */
90: l_spec_tests GMD_QUALITY_GRP.inv_spec_out_rec_type;
91:

Line 90: l_spec_tests GMD_QUALITY_GRP.inv_spec_out_rec_type;

86: x_results GMD_QUALITY_GRP.inv_rslt_out_rec_type;
87: x_spec_tests GMD_QUALITY_GRP.inv_spec_out_rec_type;
88:
89: /* Bug#3412075 - Define the local variable */
90: l_spec_tests GMD_QUALITY_GRP.inv_spec_out_rec_type;
91:
92: l_inv_test_inp_rec GMD_QUALITY_GRP.INV_INP_REC_TYPE;
93:
94: BEGIN

Line 92: l_inv_test_inp_rec GMD_QUALITY_GRP.INV_INP_REC_TYPE;

88:
89: /* Bug#3412075 - Define the local variable */
90: l_spec_tests GMD_QUALITY_GRP.inv_spec_out_rec_type;
91:
92: l_inv_test_inp_rec GMD_QUALITY_GRP.INV_INP_REC_TYPE;
93:
94: BEGIN
95: -- Initialize API return status to success
96: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 112: GMD_QUALITY_GRP.get_inv_result_test_value

108: -- Call the fetch Results API
109: IF p_inv_test_inp_rec.plant_id IS NOT NULL THEN
110: l_inv_test_inp_rec.organization_id := p_inv_test_inp_rec.plant_id;
111:
112: GMD_QUALITY_GRP.get_inv_result_test_value
113: ( p_inv_rslt_inp_rec => l_inv_test_inp_rec
114: , x_inv_rslt_out_rec => x_results
115: , x_return_status => x_return_status);
116:

Line 121: GMD_QUALITY_GRP.get_inv_result_test_value

117: IF x_results.result_value IS NULL THEN
118: -- check if you get results using lab_id or organization_id
119: l_inv_test_inp_rec.organization_id := p_inv_test_inp_rec.organization_id;
120:
121: GMD_QUALITY_GRP.get_inv_result_test_value
122: ( p_inv_rslt_inp_rec => l_inv_test_inp_rec
123: , x_inv_rslt_out_rec => x_results
124: , x_return_status => x_return_status);
125: END IF;

Line 129: GMD_QUALITY_GRP.get_inv_result_test_value

125: END IF;
126: ELSE -- no plant_id provided, so use the lab or organization id
127: l_inv_test_inp_rec.organization_id := p_inv_test_inp_rec.organization_id;
128:
129: GMD_QUALITY_GRP.get_inv_result_test_value
130: ( p_inv_rslt_inp_rec => l_inv_test_inp_rec
131: , x_inv_rslt_out_rec => x_results
132: , x_return_status => x_return_status
133: );

Line 142: GMD_QUALITY_GRP.get_inv_spec_test_value

138:
139: IF p_inv_test_inp_rec.plant_id IS NOT NULL THEN
140: l_inv_test_inp_rec.organization_id := p_inv_test_inp_rec.plant_id;
141:
142: GMD_QUALITY_GRP.get_inv_spec_test_value
143: ( p_inv_spec_inp_rec => l_inv_test_inp_rec
144: , x_inv_spec_out_rec => x_spec_tests
145: , x_return_status => x_return_status
146: );

Line 155: GMD_QUALITY_GRP.get_inv_spec_test_value

151: IF x_spec_tests.level IN (41,51) THEN
152: -- check if you get results using lab_id or organization_id
153: l_inv_test_inp_rec.organization_id := p_inv_test_inp_rec.organization_id;
154:
155: GMD_QUALITY_GRP.get_inv_spec_test_value
156: ( p_inv_spec_inp_rec => l_inv_test_inp_rec
157: /* Bug#3412075 - Changed the parameter from x_spec_tests to l_spec_tests */
158: /* to avoid the overwriting of the data from the global sepc */
159: , x_inv_spec_out_rec => l_spec_tests

Line 170: GMD_QUALITY_GRP.get_inv_spec_test_value

166: END IF;
167: ELSE -- no plant_id provided, so use the lab or orgn ocde
168: l_inv_test_inp_rec.organization_id := p_inv_test_inp_rec.organization_id;
169:
170: GMD_QUALITY_GRP.get_inv_spec_test_value
171: ( p_inv_spec_inp_rec => l_inv_test_inp_rec
172: , x_inv_spec_out_rec => x_spec_tests
173: , x_return_status => x_return_status
174: );

Line 243: x_sampling_events GMD_QUALITY_GRP.sampling_events_tbl_type;

239: , x_return_status OUT NOCOPY VARCHAR2
240: )
241: IS
242: l_api_name VARCHAR2(100) := 'GET_INV_RESULT_TEST_VALUE';
243: x_sampling_events GMD_QUALITY_GRP.sampling_events_tbl_type;
244: x_results GMD_RESULTS_GRP.gmd_results_rec_tbl;
245: l_level_rec GMD_QUALITY_GRP.inv_inp_rec_type;
246: l_return_status VARCHAR2(1);
247: l_composite_spec_disp_id NUMBER;

Line 245: l_level_rec GMD_QUALITY_GRP.inv_inp_rec_type;

241: IS
242: l_api_name VARCHAR2(100) := 'GET_INV_RESULT_TEST_VALUE';
243: x_sampling_events GMD_QUALITY_GRP.sampling_events_tbl_type;
244: x_results GMD_RESULTS_GRP.gmd_results_rec_tbl;
245: l_level_rec GMD_QUALITY_GRP.inv_inp_rec_type;
246: l_return_status VARCHAR2(1);
247: l_composite_spec_disp_id NUMBER;
248: i NUMBER := 0;
249: l_row_num NUMBER := 0;

Line 329: GMD_QUALITY_GRP.get_appr_sampling_events

325: -- Initialize API return status to success
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327:
328: -- Get the list of approved sampling events
329: GMD_QUALITY_GRP.get_appr_sampling_events
330: ( p_inv_rslt_inp_rec => p_inv_rslt_inp_rec
331: , x_sampling_events_tbl => x_sampling_events
332: , x_return_status => x_return_status
333: );

Line 496: GMD_QUALITY_GRP.get_level

492: gmd_debug.put_line('Getting the level for inventory item_id '
493: ||X_sampling_events(l_row_num).organization_id);
494: END IF;
495:
496: GMD_QUALITY_GRP.get_level
497: ( p_inv_inp_rec => l_level_rec
498: , p_called_from => 'RESULT'
499: , x_level => x_inv_rslt_out_rec.level
500: , x_return_status => x_return_status

Line 690: l_level_rec GMD_QUALITY_GRP.inv_inp_rec_type;

686: )
687: IS
688: l_api_name VARCHAR2(100) := 'GET_INV_SPEC_TEST_VALUE';
689: l_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;
690: l_level_rec GMD_QUALITY_GRP.inv_inp_rec_type;
691: x_spec_id NUMBER;
692: x_spec_vr_id NUMBER;
693: x_msg_data VARCHAR2(2000);
694:

Line 798: GMD_QUALITY_GRP.get_level

794: l_level_rec.inventory_item_Id := p_inv_spec_inp_rec.inventory_item_Id ;
795: l_level_rec.grade_code := p_inv_spec_inp_rec.grade_code ;
796:
797: -- get the level
798: GMD_QUALITY_GRP.get_level
799: ( p_inv_inp_rec => l_level_rec
800: , p_called_from => 'TEST'
801: , x_level => x_inv_spec_out_rec.level
802: , x_return_status => x_return_status

Line 1003: END GMD_QUALITY_GRP;

999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1000: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1001: END get_level;
1002:
1003: END GMD_QUALITY_GRP;