APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_SPEC_RESULTS

Line 61: gmd_spec_results sr

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
65: AND r2.delete_mark = 0

Line 94: gmd_spec_results sr,

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
98: AND r.test_id = p_test_id

Line 471: add_spec_tab_out gmd_api_pub.gmd_spec_results_tab;

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;
475:

Line 737: IF NOT GMD_SPEC_RESULTS_PVT.lock_row

733: END IF;
734:
735:
736:
737: IF NOT GMD_SPEC_RESULTS_PVT.lock_row
738: ( p_event_spec_disp_id => l_event_spec_disp_id,
739: p_result_id => temp_table_rslt_row.child_result_id
740: ) THEN
741: RAISE FND_API.G_EXC_ERROR;

Line 744: UPDATE GMD_SPEC_RESULTS

740: ) THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
744: UPDATE GMD_SPEC_RESULTS
745: SET IN_SPEC_IND = l_validate_res.in_spec,
746: evaluation_ind = l_validate_res.evaluation_ind,
747: action_code = l_validate_res.result_action_code,
748: last_update_date = SYSDATE,