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_PUB dependencies on GMD_SPEC_RESULTS

Line 26: * VALUE_IN_REPORT_PRECISION in GMD_SPEC_RESULTS*

22: * magupta 3492836: Reserve Sample Id Validation *
23: * *
24: * Sulipta Tripathy Bug # 3848483 Added new fields in update *
25: * statement. TESTER_ID in GMD_RESULTS *
26: * VALUE_IN_REPORT_PRECISION in GMD_SPEC_RESULTS*
27: * Modified cond. to update GMD_SPEC_RESULTS *
28: * even if eval_ind is NULL. *
29: * B.Stone 9-Sep-2004 Bug 3763419; Added Guaranteed by *
30: * Manufacturer evaluation with the same *

Line 27: * Modified cond. to update GMD_SPEC_RESULTS *

23: * *
24: * Sulipta Tripathy Bug # 3848483 Added new fields in update *
25: * statement. TESTER_ID in GMD_RESULTS *
26: * VALUE_IN_REPORT_PRECISION in GMD_SPEC_RESULTS*
27: * Modified cond. to update GMD_SPEC_RESULTS *
28: * even if eval_ind is NULL. *
29: * B.Stone 9-Sep-2004 Bug 3763419; Added Guaranteed by *
30: * Manufacturer evaluation with the same *
31: * business rules asApproved with Variance;*

Line 82: , x_spec_results_rec OUT NOCOPY GMD_SPEC_RESULTS%ROWTYPE

78: , p_validation_level IN NUMBER
79: , p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC
80: , p_user_name IN VARCHAR2
81: , x_results_rec OUT NOCOPY GMD_RESULTS%ROWTYPE
82: , x_spec_results_rec OUT NOCOPY GMD_SPEC_RESULTS%ROWTYPE
83: , x_return_status OUT NOCOPY VARCHAR2
84: , x_msg_count OUT NOCOPY NUMBER
85: , x_msg_data OUT NOCOPY VARCHAR2
86: , p_user_responsibility_id IN NUMBER DEFAULT NULL /*NSRIVAST, INVCONV*/

Line 97: l_spec_results_row_in GMD_SPEC_RESULTS%ROWTYPE;

93: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
94: l_results_rec GMD_RESULTS_PUB.RESULTS_REC;
95: l_tests_rec GMD_QC_TESTS%ROWTYPE;
96: l_samples_rec GMD_SAMPLES%ROWTYPE;
97: l_spec_results_row_in GMD_SPEC_RESULTS%ROWTYPE;
98: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
99: l_spec_tests_in GMD_SPEC_TESTS%ROWTYPE;
100: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
101: l_results_row_in GMD_RESULTS%ROWTYPE;

Line 98: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;

94: l_results_rec GMD_RESULTS_PUB.RESULTS_REC;
95: l_tests_rec GMD_QC_TESTS%ROWTYPE;
96: l_samples_rec GMD_SAMPLES%ROWTYPE;
97: l_spec_results_row_in GMD_SPEC_RESULTS%ROWTYPE;
98: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
99: l_spec_tests_in GMD_SPEC_TESTS%ROWTYPE;
100: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
101: l_results_row_in GMD_RESULTS%ROWTYPE;
102: l_results_row GMD_RESULTS%ROWTYPE;

Line 161: add_spec_tab_out gmd_api_pub.gmd_spec_results_tab;

157:
158: l_sample gmd_samples%rowtype;
159: test_ids gmd_api_pub.number_tab;
160: add_rslt_tab_out gmd_api_pub.gmd_results_tab;
161: add_spec_tab_out gmd_api_pub.gmd_spec_results_tab;
162:
163: -- 14635099 end
164:
165:

Line 610: select in_spec_ind into l_result_value_char from gmd_spec_results WHERE result_id = l_results_row.result_id;

606: --=================================
607:
608: IF l_tests_rec.test_type = 'E' THEN --RLNAGARA BUG#5076736
609: select result_value_num into l_validate_res.result_num from gmd_results WHERE result_id = l_results_row.result_id;
610: select in_spec_ind into l_result_value_char from gmd_spec_results WHERE result_id = l_results_row.result_id;
611: END IF;
612:
613: -- Bug 3468300: added consumed qty, test uom and reserve sample id
614: UPDATE GMD_RESULTS

Line 774: IF NOT GMD_SPEC_RESULTS_PVT.lock_row

770: /* Bug # 3848483 Update the spec results even if eval_ind is NULL - Commenting the condition */
771: -- IF NVL(l_validate_res.evaluation_ind, p_results_rec.eval_ind) is NOT NULL THEN
772:
773:
774: IF NOT GMD_SPEC_RESULTS_PVT.lock_row
775: ( p_event_spec_disp_id => l_event_spec_disp_id,
776: p_result_id => l_results_row.result_id
777: ) THEN
778: RAISE FND_API.G_EXC_ERROR;

Line 832: UPDATE GMD_SPEC_RESULTS

828:
829:
830:
831:
832: UPDATE GMD_SPEC_RESULTS
833: SET IN_SPEC_IND = l_validate_res.in_spec,
834: evaluation_ind = l_validate_res.evaluation_ind,
835: -- NVL(l_validate_res.evaluation_ind,p_results_rec.eval_ind), -- pal CT wants to be able to pass null as in the UI BUT wants system to update /* Bug # 3848483 Swapped args. l_validate_res takes precedence BUT wait - see above */
836: action_code = NVL(p_results_rec.action_code,

Line 853: IF NOT GMD_SPEC_RESULTS_PVT.fetch_row

849:
850: l_spec_results_row_in.event_spec_disp_id := l_event_spec_disp_id;
851: l_spec_results_row_in.result_id := l_results_row.result_id;
852:
853: IF NOT GMD_SPEC_RESULTS_PVT.fetch_row
854: ( p_spec_results => l_spec_results_row_in,
855: x_spec_results => l_spec_results_row
856: ) THEN
857:

Line 1013: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab

1009: , p_sample_rec IN GMD_SAMPLES%ROWTYPE
1010: , p_test_id_tab IN GMD_API_PUB.number_tab
1011: , p_event_spec_disp_id IN NUMBER
1012: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
1013: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
1014: , x_return_status OUT NOCOPY VARCHAR2
1015: , x_msg_count OUT NOCOPY NUMBER
1016: , x_msg_data OUT NOCOPY VARCHAR2
1017: )

Line 1025: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;

1021: l_msg_count NUMBER :=0;
1022: l_msg_data VARCHAR2(2000);
1023: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1024: l_results_tab GMD_API_PUB.gmd_results_tab;
1025: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
1026: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
1027: l_user_id NUMBER(15);
1028: l_date DATE := SYSDATE;
1029: l_event_spec_disp_id NUMBER;

Line 1026: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;

1022: l_msg_data VARCHAR2(2000);
1023: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1024: l_results_tab GMD_API_PUB.gmd_results_tab;
1025: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
1026: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
1027: l_user_id NUMBER(15);
1028: l_date DATE := SYSDATE;
1029: l_event_spec_disp_id NUMBER;
1030: l_event_spec_exists NUMBER;