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_RESULT_TRANSFER_GRP dependencies on GMD_RESULTS

Line 53: FROM gmd_results r1

49: p_parent_sample_id IN NUMBER) IS
50: SELECT distinct r1.seq,
51: r1.test_id,
52: r1.test_method_id
53: FROM gmd_results r1
54: WHERE r1.sample_id = p_child_sample_id
55: AND r1.result_value_char IS NULL
56: AND r1.result_value_num IS NULL
57: AND r1.reserve_sample_id IS NULL

Line 60: FROM gmd_results r2,

56: AND r1.result_value_num IS NULL
57: AND r1.reserve_sample_id IS NULL
58: and r1.delete_mark = 0
59: AND r1.test_id IN (SELECT distinct r2.test_id
60: FROM gmd_results r2,
61: gmd_spec_results sr
62: WHERE r2.sample_id = p_parent_sample_id
63: AND r2.result_id = sr.result_id
64: AND r2.test_method_id = r1.test_method_id

Line 75: FROM gmd_results r

71: p_test_id IN NUMBER,
72: p_test_method_id IN NUMBER) IS
73: SELECT r.result_id,
74: r.TEST_REPLICATE_CNT
75: FROM gmd_results r
76: WHERE r.sample_id = p_child_sample_id
77: AND r.test_id = p_test_id
78: AND r.test_method_id = p_test_method_id
79: AND r.result_value_char IS NULL

Line 93: FROM gmd_results r,

89: r.result_value_char,
90: r.result_value_num,
91: r.result_date,
92: r.test_method_id
93: FROM gmd_results r,
94: gmd_spec_results sr,
95: gmd_sample_spec_disp ssd,
96: gmd_event_spec_disp esd
97: WHERE r.sample_id = p_parent_sample_id

Line 230: FROM gmd_results

226: --This parent_result_id should not be used previously for the same sample
227: BEGIN
228: SELECT 'Y'
229: INTO l_prev_used
230: FROM gmd_results
231: WHERE sample_id = p_child_id
232: and parent_result_id = c_get_parent_sample_row.result_id
233: AND rownum =1;
234: EXCEPTION

Line 249: IF NOT GMD_RESULTS_PVT.LOCK_ROW ( p_result_id => c_get_child_sample_row.result_id ) THEN

245: IF (l_prev_used = 'N') THEN
246:
247: l_common_test_count := l_common_test_count +1;
248:
249: IF NOT GMD_RESULTS_PVT.LOCK_ROW ( p_result_id => c_get_child_sample_row.result_id ) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: l_test_code := get_test_code(l_test_id);
253:

Line 384: gmd_results b

380: b.ATTRIBUTE28,
381: b.ATTRIBUTE29,
382: b.ATTRIBUTE30
383: FROM GMD_RESULT_TRANSFER_GT A,
384: gmd_results b
385: WHERE b.result_id = a.parent_result_id
386: ;
387:
388: CURSOR Cur_get_test(p_test_id IN NUMBER) IS

Line 470: add_rslt_tab_out gmd_api_pub.gmd_results_tab;

466: order by orgn_code;
467: l_action_code c_action_code%ROWTYPE;
468: l_sample gmd_samples%rowtype;
469: test_ids gmd_api_pub.number_tab;
470: add_rslt_tab_out gmd_api_pub.gmd_results_tab;
471: add_spec_tab_out gmd_api_pub.gmd_spec_results_tab;
472: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
473: l_lot_number mtl_lot_numbers.lot_number%TYPE;
474: l_update_instance_id NUMBER;

Line 476: l_validate_res gmd_results_grp.result_data;

472: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
473: l_lot_number mtl_lot_numbers.lot_number%TYPE;
474: l_update_instance_id NUMBER;
475:
476: l_validate_res gmd_results_grp.result_data;
477: l_message_data VARCHAR2(100);
478:
479: l_return_status VARCHAR2(100);
480: -- l_sample_disp VARCHAR2(3);

Line 487: l_test_qty GMD_RESULTS.TEST_QTY%TYPE;

483: l_spec_tests_in GMD_SPEC_TESTS%ROWTYPE;
484: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
485: l_tests_rec_in GMD_QC_TESTS%ROWTYPE;
486: l_tests_rec GMD_QC_TESTS%ROWTYPE;
487: l_test_qty GMD_RESULTS.TEST_QTY%TYPE;
488: l_test_qty_uom GMD_RESULTS.TEST_QTY_UOM%TYPE;
489:
490: l_in_spec VARCHAR2(1);
491: l_place NUMBER:=0;

Line 488: l_test_qty_uom GMD_RESULTS.TEST_QTY_UOM%TYPE;

484: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
485: l_tests_rec_in GMD_QC_TESTS%ROWTYPE;
486: l_tests_rec GMD_QC_TESTS%ROWTYPE;
487: l_test_qty GMD_RESULTS.TEST_QTY%TYPE;
488: l_test_qty_uom GMD_RESULTS.TEST_QTY_UOM%TYPE;
489:
490: l_in_spec VARCHAR2(1);
491: l_place NUMBER:=0;
492: l_msg VARCHAR2(150);

Line 494: l_rslt_tbl gmd_results_grp.rslt_tbl;

490: l_in_spec VARCHAR2(1);
491: l_place NUMBER:=0;
492: l_msg VARCHAR2(150);
493: p_copy_flex VARCHAR2(1);
494: l_rslt_tbl gmd_results_grp.rslt_tbl;
495: l_composite_flag VARCHAR2(1) := 'N';
496: l_sample_active_cnt NUMBER;
497:
498:

Line 499: l_rslt_tbl_expression gmd_results_grp.rslt_tbl;

495: l_composite_flag VARCHAR2(1) := 'N';
496: l_sample_active_cnt NUMBER;
497:
498:
499: l_rslt_tbl_expression gmd_results_grp.rslt_tbl;
500: l_return_status_expression VARCHAR2(10);
501:
502:
503: BEGIN

Line 643: -- gmd_results_grp.validate_result(l_validate_res,

639:
640:
641:
642:
643: -- gmd_results_grp.validate_result(l_validate_res,
644: -- l_return_status);
645: GMD_RESULTS_GRP.validate_result
646: ( p_result_rec => l_validate_res,
647: x_return_status => l_return_status

Line 645: GMD_RESULTS_GRP.validate_result

641:
642:
643: -- gmd_results_grp.validate_result(l_validate_res,
644: -- l_return_status);
645: GMD_RESULTS_GRP.validate_result
646: ( p_result_rec => l_validate_res,
647: x_return_status => l_return_status
648: );
649: l_place := 35;

Line 664: UPDATE gmd_results

660:
661:
662:
663:
664: UPDATE gmd_results
665: SET result_value_char = temp_table_rslt_row.result_value_char,
666: result_value_num = temp_table_rslt_row.result_value_num,
667: update_instance_id = l_update_instance_id,
668: result_date = temp_table_rslt_row.result_date,

Line 715: gmd_results_grp.calc_expression

711: --B3356274 Now atleast one result is updated, so need to mark the composite result as invalid...
712: l_composite_flag := 'Y';
713:
714: IF (l_validate_res.test_type = 'E') THEN
715: gmd_results_grp.calc_expression
716: ( p_sample_id => p_sample_id
717: , p_event_spec_disp_id => l_event_spec_disp_id
718: , p_spec_id => l_spec_tests.spec_id
719: , x_rslt_tbl => l_rslt_tbl

Line 729: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'GMD_RESULTS',

725: END IF;
726:
727:
728: IF (p_copy_attachment = 'Y') THEN
729: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'GMD_RESULTS',
730: X_from_pk1_value => temp_table_rslt_row.parent_result_id,
731: X_to_entity_name => 'GMD_RESULTS',
732: x_to_pk1_value => temp_table_rslt_row.child_result_id);
733: END IF;

Line 731: X_to_entity_name => 'GMD_RESULTS',

727:
728: IF (p_copy_attachment = 'Y') THEN
729: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'GMD_RESULTS',
730: X_from_pk1_value => temp_table_rslt_row.parent_result_id,
731: X_to_entity_name => 'GMD_RESULTS',
732: x_to_pk1_value => temp_table_rslt_row.child_result_id);
733: END IF;
734:
735:

Line 770: from gmd_results

766: l_sample.sample_id := p_sample_id;
767: test_ids(1) := temp_table_rslt_row.test_id;
768: select test_qty,test_qty_uom
769: into l_test_qty, l_test_qty_uom
770: from gmd_results
771: where result_id = temp_table_rslt_row.child_result_id;
772:
773: gmd_results_grp.add_tests_to_sample
774: (p_sample => l_sample

Line 773: gmd_results_grp.add_tests_to_sample

769: into l_test_qty, l_test_qty_uom
770: from gmd_results
771: where result_id = temp_table_rslt_row.child_result_id;
772:
773: gmd_results_grp.add_tests_to_sample
774: (p_sample => l_sample
775: ,p_test_ids => test_ids
776: ,p_event_spec_disp_id => l_event_spec_disp_id
777: ,x_results_tab => add_rslt_tab_out

Line 813: gmd_results_grp.calc_expression

809: END LOOP;
810:
811: -- Bug 3892771
812: -- Need to calculate expressions
813: gmd_results_grp.calc_expression
814: ( p_sample_id => p_sample_id
815: , p_event_spec_disp_id => l_event_spec_disp_id
816: , p_spec_id => l_spec_tests.spec_id
817: , x_rslt_tbl => l_rslt_tbl_expression

Line 841: GMD_RESULTS_GRP.se_recomposite_required ( p_sampling_event_id => p_sampling_event_id

837: END;
838: END IF;
839:
840: IF (nvl(l_sample_active_cnt, 0) > 1) THEN
841: GMD_RESULTS_GRP.se_recomposite_required ( p_sampling_event_id => p_sampling_event_id
842: , p_event_spec_disp_id => l_event_spec_disp_id
843: , x_return_status => l_return_status
844: );
845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 852: GMD_RESULTS_GRP.change_sample_disposition

848: END IF;
849:
850:
851: --B3356274, end invalidate composite result on result association
852: GMD_RESULTS_GRP.change_sample_disposition
853: ( p_sample_id => p_sample_id,
854: x_change_disp_to => x_sample_disp,
855: x_return_status => l_return_status,
856: x_message_data => l_message_data

Line 866: l_in_spec := gmd_results_grp.rslt_is_in_spec(l_spec_id,

862: p_copy_flex := 'Y';
863: END IF;
864: FOR c_temp_table_cmpt_row IN c_temp_table_cmpt LOOP
865: l_place := 50;
866: l_in_spec := gmd_results_grp.rslt_is_in_spec(l_spec_id,
867: c_temp_table_cmpt_row.test_id,
868: to_char(c_temp_table_cmpt_row.mean),
869: c_temp_table_cmpt_row.mode_char);
870: l_place := 55;