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 202: l_sampling_event gmd_sampling_events%ROWTYPE;

198: l_event_spec_disp_id NUMBER(15);
199: l_return_status VARCHAR2(1);
200: l_meaning VARCHAR2(80);
201:
202: l_sampling_event gmd_sampling_events%ROWTYPE;
203: l_event_spec_disp gmd_event_spec_disp%ROWTYPE;
204: l_sample_spec_disp gmd_sample_spec_disp%ROWTYPE;
205: l_results gmd_results%ROWTYPE;
206: l_spec_results gmd_spec_results%ROWTYPE;

Line 208: l_in_sampling_event gmd_sampling_events%ROWTYPE;

204: l_sample_spec_disp gmd_sample_spec_disp%ROWTYPE;
205: l_results gmd_results%ROWTYPE;
206: l_spec_results gmd_spec_results%ROWTYPE;
207:
208: l_in_sampling_event gmd_sampling_events%ROWTYPE;
209: l_in_event_spec_disp gmd_event_spec_disp%ROWTYPE;
210: l_out_event_spec_disp gmd_event_spec_disp%ROWTYPE;
211: l_out_results gmd_results%ROWTYPE;
212:

Line 309: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(

305:
306: -- Now that we have sampling_event_id, fetch the sampling event record
307: -- l_sampling_event.sampling_event_id := p_sample.sampling_event_id;
308: l_in_sampling_event.sampling_event_id := p_sample.sampling_event_id;
309: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(
310: p_sampling_events => l_in_sampling_event,
311: x_sampling_events => l_sampling_event)
312: )
313: THEN

Line 692: UPDATE gmd_sampling_events

688:
689: IF NOT (l_sampling_event.disposition IN ('1P', '2I')) THEN
690: -- Set the disposition of the Sampling Event
691: -- back to "In Progress"
692: UPDATE gmd_sampling_events
693: SET disposition = '2I',
694: last_updated_by = l_user_id,
695: last_update_date = l_date
696: WHERE sampling_event_id = l_sampling_event.sampling_event_id

Line 1372: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

1368: l_viability_duration NUMBER;
1369: l_resources GMD_TEST_METHODS_B.RESOURCES%TYPE;
1370:
1371: l_sample GMD_SAMPLES%ROWTYPE;
1372: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
1373: l_results GMD_RESULTS%ROWTYPE;
1374: l_spec_results GMD_SPEC_RESULTS%ROWTYPE;
1375: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
1376:

Line 1377: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

1373: l_results GMD_RESULTS%ROWTYPE;
1374: l_spec_results GMD_SPEC_RESULTS%ROWTYPE;
1375: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
1376:
1377: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
1378: l_in_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
1379: l_out_results GMD_RESULTS%ROWTYPE;
1380:
1381: -- Exceptions

Line 1417: IF NOT (gmd_sampling_events_pvt.fetch_row(

1413:
1414:
1415: -- Fetch the Sampling Event Record
1416: l_in_sampling_event.sampling_event_id := l_sample.sampling_event_id;
1417: IF NOT (gmd_sampling_events_pvt.fetch_row(
1418: p_sampling_events => l_in_sampling_event,
1419: x_sampling_events => l_sampling_event)
1420: )
1421: THEN

Line 1733: UPDATE gmd_sampling_events

1729: -- Set the disposition of the Sampling Event
1730: -- back to "In Progress"
1731: -- Also set recomposite_ind to 'Y' since we modified the sampling event
1732: -- by adding a new test
1733: UPDATE gmd_sampling_events
1734: SET disposition = '2I',
1735: recomposite_ind = 'Y',
1736: last_updated_by = l_user_id,
1737: last_update_date = l_date

Line 3217: FROM gmd_sampling_events

3213: ;
3214:
3215: CURSOR c_composite_valid (p_sampling_event_id NUMBER) IS
3216: SELECT nvl(recomposite_ind, 'N')
3217: FROM gmd_sampling_events
3218: WHERE sampling_event_id = p_sampling_event_id
3219: ;
3220:
3221: -- Local Variables

Line 3380: UPDATE gmd_sampling_events

3376: FETCH c_composite INTO dummy;
3377: IF c_composite%FOUND THEN
3378: -- We have found that the Sampling Event is composited before.
3379: -- So update the sampling event that recomposite is required.
3380: UPDATE gmd_sampling_events
3381: SET recomposite_ind = 'Y'
3382: WHERE sampling_event_id = p_sampling_event_id;
3383: END IF;
3384: CLOSE c_composite;

Line 3456: UPDATE gmd_sampling_events

3452: FETCH c_composite INTO dummy;
3453: IF c_composite%FOUND THEN
3454: -- We have found that the Sampling Event is composited before.
3455: -- So update the sampling event that recomposite is required.
3456: UPDATE gmd_sampling_events
3457: SET recomposite_ind = 'Y'
3458: WHERE sampling_event_id =
3459: (SELECT sampling_event_id
3460: FROM gmd_event_spec_disp

Line 6119: l_sampling_event_in GMD_SAMPLING_EVENTS%ROWTYPE;

6115:
6116:
6117: l_sample_in GMD_SAMPLES%ROWTYPE;
6118: l_sample GMD_SAMPLES%ROWTYPE;
6119: l_sampling_event_in GMD_SAMPLING_EVENTS%ROWTYPE;
6120: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
6121: l_event_spec_disp_in GMD_EVENT_SPEC_DISP%ROWTYPE;
6122: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
6123: l_sample_spec_disp_in GMD_SAMPLE_SPEC_DISP%ROWTYPE;

Line 6120: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

6116:
6117: l_sample_in GMD_SAMPLES%ROWTYPE;
6118: l_sample GMD_SAMPLES%ROWTYPE;
6119: l_sampling_event_in GMD_SAMPLING_EVENTS%ROWTYPE;
6120: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
6121: l_event_spec_disp_in GMD_EVENT_SPEC_DISP%ROWTYPE;
6122: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
6123: l_sample_spec_disp_in GMD_SAMPLE_SPEC_DISP%ROWTYPE;
6124: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;

Line 6155: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(

6151: END IF;
6152:
6153: -- Get the sampling event record
6154: l_sampling_event_in.sampling_event_id := l_sample.sampling_event_id;
6155: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(
6156: p_sampling_events => l_sampling_event_in,
6157: x_sampling_events => l_sampling_event)
6158: )
6159: THEN

Line 6445: FROM gmd_sampling_events se,

6441: svr.control_lot_attrib_ind,
6442: svr.in_spec_lot_status_id,
6443: svr.out_of_spec_lot_status_id,
6444: s.organization_id
6445: FROM gmd_sampling_events se,
6446: gmd_event_spec_disp esd,
6447: gmd_sample_spec_disp ssd,
6448: gmd_samples s,
6449: gmd_com_spec_vrs_vl svr

Line 6786: FROM gmd_sampling_events

6782: -- In-Spec or Out-of-Spec Lot status.
6783:
6784: SELECT disposition
6785: INTO l_disposition
6786: FROM gmd_sampling_events
6787: WHERE sampling_event_id = l_sample_rec.sampling_event_id
6788: ;
6789:
6790: IF l_sample_rec.control_lot_attrib_ind = 'Y' THEN --RLNAGARA Bug5416103

Line 6879: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

6875: WHERE organization_id = p_organization_id
6876: AND transaction_reason_id IS NOT NULL;
6877:
6878:
6879: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
6880: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
6881:
6882: l_spec_dtl c_spec_dtl%ROWTYPE;
6883: l_sample_ids GMD_API_PUB.number_tab;

Line 6880: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;

6876: AND transaction_reason_id IS NOT NULL;
6877:
6878:
6879: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
6880: l_in_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
6881:
6882: l_spec_dtl c_spec_dtl%ROWTYPE;
6883: l_sample_ids GMD_API_PUB.number_tab;
6884: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

Line 6939: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(

6935: x_return_status := FND_API.G_RET_STS_SUCCESS;
6936:
6937: -- Now that we have sampling_event_id, fetch the sampling event record
6938: l_in_sampling_event.sampling_event_id := p_sampling_event_id;
6939: IF NOT (GMD_SAMPLING_EVENTS_PVT.fetch_row(
6940: p_sampling_events => l_in_sampling_event,
6941: x_sampling_events => l_sampling_event)
6942: )
6943: THEN