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_GRP dependencies on GMD_SAMPLING_EVENTS

Line 250: l_sampling_event gmd_sampling_events%ROWTYPE;

246: l_event_spec_disp_id NUMBER(15);
247: l_return_status VARCHAR2(1);
248: l_meaning VARCHAR2(80);
249:
250: l_sampling_event gmd_sampling_events%ROWTYPE;
251: l_event_spec_disp gmd_event_spec_disp%ROWTYPE;
252: l_sample_spec_disp gmd_sample_spec_disp%ROWTYPE;
253: l_results gmd_results%ROWTYPE;
254: l_spec_results gmd_spec_results%ROWTYPE;

Line 256: l_in_sampling_event gmd_sampling_events%ROWTYPE;

252: l_sample_spec_disp gmd_sample_spec_disp%ROWTYPE;
253: l_results gmd_results%ROWTYPE;
254: l_spec_results gmd_spec_results%ROWTYPE;
255:
256: l_in_sampling_event gmd_sampling_events%ROWTYPE;
257: l_in_event_spec_disp gmd_event_spec_disp%ROWTYPE;
258: l_out_event_spec_disp gmd_event_spec_disp%ROWTYPE;
259: l_out_results gmd_results%ROWTYPE;
260:

Line 357: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(

353:
354: -- Now that we have sampling_event_id, fetch the sampling event record
355: -- l_sampling_event.sampling_event_id := p_sample.sampling_event_id;
356: l_in_sampling_event.sampling_event_id := p_sample.sampling_event_id;
357: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(
358: p_sampling_events => l_in_sampling_event,
359: x_sampling_events => l_sampling_event)
360: )
361: THEN

Line 745: UPDATE gmd_sampling_events

741:
742: IF NOT (l_sampling_event.disposition IN ('1P', '2I')) THEN
743: -- Set the disposition of the Sampling Event
744: -- back to "In Progress"
745: UPDATE gmd_sampling_events
746: SET disposition = '2I',
747: last_updated_by = l_user_id,
748: last_update_date = l_date
749: WHERE sampling_event_id = l_sampling_event.sampling_event_id

Line 1447: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

1443: l_viability_duration NUMBER;
1444: l_resources GMD_TEST_METHODS_B.RESOURCES%TYPE;
1445:
1446: l_sample GMD_SAMPLES%ROWTYPE;
1447: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
1448: l_results GMD_RESULTS%ROWTYPE;
1449: l_spec_results GMD_SPEC_RESULTS%ROWTYPE;
1450: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
1451:

Line 1452: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

1448: l_results GMD_RESULTS%ROWTYPE;
1449: l_spec_results GMD_SPEC_RESULTS%ROWTYPE;
1450: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
1451:
1452: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
1453: l_in_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
1454: l_out_results GMD_RESULTS%ROWTYPE;
1455:
1456: -- Exceptions

Line 1493: IF NOT (gmd_sampling_events_pvt.fetch_row(

1489:
1490:
1491: -- Fetch the Sampling Event Record
1492: l_in_sampling_event.sampling_event_id := l_sample.sampling_event_id;
1493: IF NOT (gmd_sampling_events_pvt.fetch_row(
1494: p_sampling_events => l_in_sampling_event,
1495: x_sampling_events => l_sampling_event)
1496: )
1497: THEN

Line 1815: UPDATE gmd_sampling_events

1811: -- Set the disposition of the Sampling Event
1812: -- back to "In Progress"
1813: -- Also set recomposite_ind to 'Y' since we modified the sampling event
1814: -- by adding a new test
1815: UPDATE gmd_sampling_events
1816: SET disposition = '2I',
1817: recomposite_ind = 'Y',
1818: last_updated_by = l_user_id,
1819: last_update_date = l_date

Line 3386: FROM gmd_sampling_events

3382: ;
3383:
3384: CURSOR c_composite_valid (p_sampling_event_id NUMBER) IS
3385: SELECT nvl(recomposite_ind, 'N')
3386: FROM gmd_sampling_events
3387: WHERE sampling_event_id = p_sampling_event_id
3388: ;
3389:
3390: -- Local Variables

Line 3549: UPDATE gmd_sampling_events

3545: FETCH c_composite INTO dummy;
3546: IF c_composite%FOUND THEN
3547: -- We have found that the Sampling Event is composited before.
3548: -- So update the sampling event that recomposite is required.
3549: UPDATE gmd_sampling_events
3550: SET recomposite_ind = 'Y'
3551: WHERE sampling_event_id = p_sampling_event_id;
3552: END IF;
3553: CLOSE c_composite;

Line 3625: UPDATE gmd_sampling_events

3621: FETCH c_composite INTO dummy;
3622: IF c_composite%FOUND THEN
3623: -- We have found that the Sampling Event is composited before.
3624: -- So update the sampling event that recomposite is required.
3625: UPDATE gmd_sampling_events
3626: SET recomposite_ind = 'Y'
3627: WHERE sampling_event_id =
3628: (SELECT sampling_event_id
3629: FROM gmd_event_spec_disp

Line 6381: l_sampling_event_in GMD_SAMPLING_EVENTS%ROWTYPE;

6377:
6378:
6379: l_sample_in GMD_SAMPLES%ROWTYPE;
6380: l_sample GMD_SAMPLES%ROWTYPE;
6381: l_sampling_event_in GMD_SAMPLING_EVENTS%ROWTYPE;
6382: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
6383: l_event_spec_disp_in GMD_EVENT_SPEC_DISP%ROWTYPE;
6384: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
6385: l_sample_spec_disp_in GMD_SAMPLE_SPEC_DISP%ROWTYPE;

Line 6382: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

6378:
6379: l_sample_in GMD_SAMPLES%ROWTYPE;
6380: l_sample GMD_SAMPLES%ROWTYPE;
6381: l_sampling_event_in GMD_SAMPLING_EVENTS%ROWTYPE;
6382: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
6383: l_event_spec_disp_in GMD_EVENT_SPEC_DISP%ROWTYPE;
6384: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
6385: l_sample_spec_disp_in GMD_SAMPLE_SPEC_DISP%ROWTYPE;
6386: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;

Line 6417: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(

6413: END IF;
6414:
6415: -- Get the sampling event record
6416: l_sampling_event_in.sampling_event_id := l_sample.sampling_event_id;
6417: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(
6418: p_sampling_events => l_sampling_event_in,
6419: x_sampling_events => l_sampling_event)
6420: )
6421: THEN

Line 6769: FROM gmd_sampling_events se,

6765: svr.control_lot_attrib_ind,
6766: svr.in_spec_lot_status_id,
6767: svr.out_of_spec_lot_status_id,
6768: s.organization_id
6769: FROM gmd_sampling_events se,
6770: gmd_event_spec_disp esd,
6771: gmd_sample_spec_disp ssd,
6772: gmd_samples s,
6773: gmd_com_spec_vrs_vl svr

Line 7159: FROM gmd_sampling_events

7155: -- In-Spec or Out-of-Spec Lot status.
7156:
7157: SELECT disposition
7158: INTO l_disposition
7159: FROM gmd_sampling_events
7160: WHERE sampling_event_id = l_sample_rec.sampling_event_id
7161: ;
7162:
7163: IF l_sample_rec.control_lot_attrib_ind = 'Y' THEN --RLNAGARA Bug5416103

Line 7256: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

7252: WHERE organization_id = p_organization_id
7253: AND transaction_reason_id IS NOT NULL;
7254:
7255:
7256: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
7257: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
7258:
7259: l_spec_dtl c_spec_dtl%ROWTYPE;
7260: l_sample_ids GMD_API_PUB.number_tab;

Line 7257: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

7253: AND transaction_reason_id IS NOT NULL;
7254:
7255:
7256: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
7257: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
7258:
7259: l_spec_dtl c_spec_dtl%ROWTYPE;
7260: l_sample_ids GMD_API_PUB.number_tab;
7261: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

Line 7316: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(

7312: x_return_status := FND_API.G_RET_STS_SUCCESS;
7313:
7314: -- Now that we have sampling_event_id, fetch the sampling event record
7315: l_in_sampling_event.sampling_event_id := p_sampling_event_id;
7316: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(
7317: p_sampling_events => l_in_sampling_event,
7318: x_sampling_events => l_sampling_event)
7319: )
7320: THEN