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 55: , x_spec_results_rec OUT NOCOPY GMD_SPEC_RESULTS%ROWTYPE

51: , p_validation_level IN NUMBER
52: , p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC
53: , p_user_name IN VARCHAR2
54: , x_results_rec OUT NOCOPY GMD_RESULTS%ROWTYPE
55: , x_spec_results_rec OUT NOCOPY GMD_SPEC_RESULTS%ROWTYPE
56: , x_return_status OUT NOCOPY VARCHAR2
57: , x_msg_count OUT NOCOPY NUMBER
58: , x_msg_data OUT NOCOPY VARCHAR2
59: , p_user_responsibility_id IN NUMBER DEFAULT NULL /*NSRIVAST, INVCONV*/

Line 70: l_spec_results_row_in GMD_SPEC_RESULTS%ROWTYPE;

66: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
67: l_results_rec GMD_RESULTS_PUB.RESULTS_REC;
68: l_tests_rec GMD_QC_TESTS%ROWTYPE;
69: l_samples_rec GMD_SAMPLES%ROWTYPE;
70: l_spec_results_row_in GMD_SPEC_RESULTS%ROWTYPE;
71: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
72: l_spec_tests_in GMD_SPEC_TESTS%ROWTYPE;
73: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
74: l_results_row_in GMD_RESULTS%ROWTYPE;

Line 71: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;

67: l_results_rec GMD_RESULTS_PUB.RESULTS_REC;
68: l_tests_rec GMD_QC_TESTS%ROWTYPE;
69: l_samples_rec GMD_SAMPLES%ROWTYPE;
70: l_spec_results_row_in GMD_SPEC_RESULTS%ROWTYPE;
71: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
72: l_spec_tests_in GMD_SPEC_TESTS%ROWTYPE;
73: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
74: l_results_row_in GMD_RESULTS%ROWTYPE;
75: l_results_row GMD_RESULTS%ROWTYPE;

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

527: --=================================
528:
529: IF l_tests_rec.test_type = 'E' THEN --RLNAGARA BUG#5076736
530: select result_value_num into l_validate_res.result_num from gmd_results WHERE result_id = l_results_row.result_id;
531: select in_spec_ind into l_result_value_char from gmd_spec_results WHERE result_id = l_results_row.result_id;
532: END IF;
533:
534: -- Bug 3468300: added consumed qty, test uom and reserve sample id
535: UPDATE GMD_RESULTS

Line 637: IF NOT GMD_SPEC_RESULTS_PVT.lock_row

633: /* Bug # 3848483 Update the spec results even if eval_ind is NULL - Commenting the condition */
634: -- IF NVL(l_validate_res.evaluation_ind, p_results_rec.eval_ind) is NOT NULL THEN
635:
636:
637: IF NOT GMD_SPEC_RESULTS_PVT.lock_row
638: ( p_event_spec_disp_id => l_event_spec_disp_id,
639: p_result_id => l_results_row.result_id
640: ) THEN
641: RAISE FND_API.G_EXC_ERROR;

Line 646: UPDATE GMD_SPEC_RESULTS

642:
643: END IF;
644:
645: IF l_tests_rec.test_type <> 'E' THEN --RLNAGARA BUG#5076736
646: UPDATE GMD_SPEC_RESULTS
647: SET IN_SPEC_IND = l_validate_res.in_spec,
648: evaluation_ind = NVL(l_validate_res.evaluation_ind,p_results_rec.eval_ind), /* Bug # 3848483 Swapped args. l_validate_res takes precedence */
649: action_code = NVL(p_results_rec.action_code,
650: l_validate_res.result_action_code),

Line 663: IF NOT GMD_SPEC_RESULTS_PVT.fetch_row

659:
660: l_spec_results_row_in.event_spec_disp_id := l_event_spec_disp_id;
661: l_spec_results_row_in.result_id := l_results_row.result_id;
662:
663: IF NOT GMD_SPEC_RESULTS_PVT.fetch_row
664: ( p_spec_results => l_spec_results_row_in,
665: x_spec_results => l_spec_results_row
666: ) THEN
667:

Line 813: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab

809: , p_sample_rec IN GMD_SAMPLES%ROWTYPE
810: , p_test_id_tab IN GMD_API_PUB.number_tab
811: , p_event_spec_disp_id IN NUMBER
812: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
813: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
814: , x_return_status OUT NOCOPY VARCHAR2
815: , x_msg_count OUT NOCOPY NUMBER
816: , x_msg_data OUT NOCOPY VARCHAR2
817: )

Line 825: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;

821: l_msg_count NUMBER :=0;
822: l_msg_data VARCHAR2(2000);
823: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
824: l_results_tab GMD_API_PUB.gmd_results_tab;
825: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
826: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
827: l_user_id NUMBER(15);
828: l_date DATE := SYSDATE;
829: l_event_spec_disp_id NUMBER;

Line 826: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;

822: l_msg_data VARCHAR2(2000);
823: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
824: l_results_tab GMD_API_PUB.gmd_results_tab;
825: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
826: l_spec_results_row GMD_SPEC_RESULTS%ROWTYPE;
827: l_user_id NUMBER(15);
828: l_date DATE := SYSDATE;
829: l_event_spec_disp_id NUMBER;
830: l_event_spec_exists NUMBER;