APPS.GMD_RESULTS_PUB dependencies on GMD_SAMPLES

Line 96: l_samples_rec GMD_SAMPLES%ROWTYPE;

92: l_msg_data VARCHAR2(2000);
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;

Line 158: l_sample gmd_samples%rowtype;

154: select retest_action_code
155: from gmd_quality_config
156: where organization_id = l_samples_rec.organization_id;
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:

Line 554: FROM gmd_samples

550: IF (p_results_rec.reserve_sample_id IS NOT NULL) THEN
551: BEGIN
552: SELECT sampling_event_id
553: INTO l_reserve_sampling_event_id
554: FROM gmd_samples
555: WHERE sample_id = p_results_rec.reserve_sample_id;
556: EXCEPTION
557: WHEN NO_DATA_FOUND THEN
558: GMD_API_PUB.Log_Message('GMD_INVALID_RESERVE_SMPL');

Line 722: gmd_samples_grp.update_remaining_qty

718: --=================================
719: IF ( NVL(p_results_rec.reserve_sample_id, 0) <> 0 ) THEN
720: -- Bug 3468300: added API/FORM field and test uom to update remaining qty call
721: -- B3600012 ST: RECORD RESULTS API ISSUES AMBIGUOUS ERROR
722: gmd_samples_grp.update_remaining_qty
723: (l_results_row.result_id, -- B3600012 changed from l_results_rec
724: p_results_rec.reserve_sample_id ,
725: l_results_row.consumed_qty ,
726: l_return_status

Line 733: gmd_samples_grp.update_remaining_qty

729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731:
732: ELSE
733: gmd_samples_grp.update_remaining_qty
734: (l_results_row.result_id, -- B3600012 changed from l_results_rec
735: l_results_row.sample_id ,
736: l_results_row.consumed_qty ,
737: l_return_status

Line 1009: , p_sample_rec IN GMD_SAMPLES%ROWTYPE

1005: , p_init_msg_list IN VARCHAR2
1006: , p_commit IN VARCHAR2
1007: , p_validation_level IN NUMBER
1008: , p_user_name IN VARCHAR2
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

Line 1275: x_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE,

1271:
1272: PROCEDURE GET_RESULT_INFO
1273: ( p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC,
1274: x_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,
1275: x_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE,
1276: x_return_status OUT NOCOPY VARCHAR2
1277: )
1278: IS
1279: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;

Line 1281: l_samples_rec GMD_SAMPLES%ROWTYPE;

1277: )
1278: IS
1279: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1280: l_tests_rec GMD_QC_TESTS%ROWTYPE;
1281: l_samples_rec GMD_SAMPLES%ROWTYPE;
1282:
1283: BEGIN
1284:
1285: -- Set out Variable

Line 1304: IF NOT GMD_SAMPLES_PVT.fetch_row

1300: l_samples_rec.sample_id := p_results_rec.sample_id;
1301: l_samples_rec.sample_no := p_results_rec.sample_no;
1302: l_samples_rec.organization_id := p_results_rec.organization_id; /*NSRIVAST, INVCONV*/
1303:
1304: IF NOT GMD_SAMPLES_PVT.fetch_row
1305: (
1306: p_samples => l_samples_rec,
1307: x_samples => x_samples_rec
1308: ) THEN

Line 1314: 'l_table_name', 'GMD_SAMPLES',

1310: END IF;
1311:
1312: IF x_samples_rec.delete_mark = 1 THEN
1313: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
1314: 'l_table_name', 'GMD_SAMPLES',
1315: 'l_column_name', 'SAMPLE_ID',
1316: 'l_key_value', x_samples_rec.sample_id);
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;