APPS.GMD_RESULTS_PUB dependencies on GMD_SAMPLES

Line 69: l_samples_rec GMD_SAMPLES%ROWTYPE;

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

Line 475: FROM gmd_samples

471: IF (p_results_rec.reserve_sample_id IS NOT NULL) THEN
472: BEGIN
473: SELECT sampling_event_id
474: INTO l_reserve_sampling_event_id
475: FROM gmd_samples
476: WHERE sample_id = p_results_rec.reserve_sample_id;
477: EXCEPTION
478: WHEN NO_DATA_FOUND THEN
479: GMD_API_PUB.Log_Message('GMD_INVALID_RESERVE_SMPL');

Line 585: gmd_samples_grp.update_remaining_qty

581: --=================================
582: IF ( NVL(p_results_rec.reserve_sample_id, 0) <> 0 ) THEN
583: -- Bug 3468300: added API/FORM field and test uom to update remaining qty call
584: -- B3600012 ST: RECORD RESULTS API ISSUES AMBIGUOUS ERROR
585: gmd_samples_grp.update_remaining_qty
586: (l_results_row.result_id, -- B3600012 changed from l_results_rec
587: p_results_rec.reserve_sample_id ,
588: l_results_row.consumed_qty ,
589: l_return_status

Line 596: gmd_samples_grp.update_remaining_qty

592: RAISE FND_API.G_EXC_ERROR;
593: END IF;
594:
595: ELSE
596: gmd_samples_grp.update_remaining_qty
597: (l_results_row.result_id, -- B3600012 changed from l_results_rec
598: l_results_row.sample_id ,
599: l_results_row.consumed_qty ,
600: l_return_status

Line 809: , p_sample_rec IN GMD_SAMPLES%ROWTYPE

805: , p_init_msg_list IN VARCHAR2
806: , p_commit IN VARCHAR2
807: , p_validation_level IN NUMBER
808: , p_user_name IN VARCHAR2
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

Line 1075: x_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE,

1071:
1072: PROCEDURE GET_RESULT_INFO
1073: ( p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC,
1074: x_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,
1075: x_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE,
1076: x_return_status OUT NOCOPY VARCHAR2
1077: )
1078: IS
1079: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;

Line 1081: l_samples_rec GMD_SAMPLES%ROWTYPE;

1077: )
1078: IS
1079: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1080: l_tests_rec GMD_QC_TESTS%ROWTYPE;
1081: l_samples_rec GMD_SAMPLES%ROWTYPE;
1082:
1083: BEGIN
1084:
1085: -- Set out Variable

Line 1104: IF NOT GMD_SAMPLES_PVT.fetch_row

1100: l_samples_rec.sample_id := p_results_rec.sample_id;
1101: l_samples_rec.sample_no := p_results_rec.sample_no;
1102: l_samples_rec.organization_id := p_results_rec.organization_id; /*NSRIVAST, INVCONV*/
1103:
1104: IF NOT GMD_SAMPLES_PVT.fetch_row
1105: (
1106: p_samples => l_samples_rec,
1107: x_samples => x_samples_rec
1108: ) THEN

Line 1114: 'l_table_name', 'GMD_SAMPLES',

1110: END IF;
1111:
1112: IF x_samples_rec.delete_mark = 1 THEN
1113: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
1114: 'l_table_name', 'GMD_SAMPLES',
1115: 'l_column_name', 'SAMPLE_ID',
1116: 'l_key_value', x_samples_rec.sample_id);
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;