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_EVENT_SPEC_DISP

Line 179: , x_event_spec_disp OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE

175: PROCEDURE create_rslt_and_spec_rslt_rows
176: (
177: p_sample IN GMD_SAMPLES%ROWTYPE
178: , p_migration IN VARCHAR2
179: , x_event_spec_disp OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
180: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE
181: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
182: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
183: , x_return_status OUT NOCOPY VARCHAR2

Line 251: l_event_spec_disp gmd_event_spec_disp%ROWTYPE;

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

Line 257: l_in_event_spec_disp gmd_event_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:
261: -- Exceptions

Line 258: l_out_event_spec_disp gmd_event_spec_disp%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:
261: -- Exceptions
262: e_sampling_event_fetch_error EXCEPTION;

Line 409: -- Check if we already have a record in GMD_EVENT_SPEC_DISP

405: l_date := SYSDATE;
406: l_seq := 0;
407: dummy := 0;
408:
409: -- Check if we already have a record in GMD_EVENT_SPEC_DISP
410: l_event_spec_disp_id := get_current_event_spec_disp_id(
411: l_sampling_event.sampling_event_id);
412:
413: IF (l_event_spec_disp_id IS NULL) THEN

Line 414: -- This is the first sample so create a record in GMD_EVENT_SPEC_DISP

410: l_event_spec_disp_id := get_current_event_spec_disp_id(
411: l_sampling_event.sampling_event_id);
412:
413: IF (l_event_spec_disp_id IS NULL) THEN
414: -- This is the first sample so create a record in GMD_EVENT_SPEC_DISP
415:
416: -- Construct the record
417: l_event_spec_disp.sampling_event_id := l_sampling_event.sampling_event_id;
418: l_event_spec_disp.spec_id := l_spec_id;

Line 432: -- We are ready for insert in GMD_EVENT_SPEC_DISP, so then lets do it.

428: l_event_spec_disp.created_by := l_user_id;
429: l_event_spec_disp.last_update_date := l_date;
430: l_event_spec_disp.last_updated_by := l_user_id;
431:
432: -- We are ready for insert in GMD_EVENT_SPEC_DISP, so then lets do it.
433: IF NOT(gmd_event_spec_disp_pvt.insert_row(
434: p_event_spec_disp => l_event_spec_disp,
435: x_event_spec_disp => l_out_event_spec_disp)
436: )

Line 433: IF NOT(gmd_event_spec_disp_pvt.insert_row(

429: l_event_spec_disp.last_update_date := l_date;
430: l_event_spec_disp.last_updated_by := l_user_id;
431:
432: -- We are ready for insert in GMD_EVENT_SPEC_DISP, so then lets do it.
433: IF NOT(gmd_event_spec_disp_pvt.insert_row(
434: p_event_spec_disp => l_event_spec_disp,
435: x_event_spec_disp => l_out_event_spec_disp)
436: )
437: THEN

Line 443: -- Fetch the GMD_EVENT_SPEC_DISP record

439: RAISE e_event_spec_disp_insert_error;
440: END IF;
441: l_event_spec_disp.event_spec_disp_id := l_out_event_spec_disp.event_spec_disp_id;
442: ELSE
443: -- Fetch the GMD_EVENT_SPEC_DISP record
444: -- l_event_spec_disp.event_spec_disp_id := l_event_spec_disp_id;
445: l_in_event_spec_disp.event_spec_disp_id := l_event_spec_disp_id;
446: IF NOT(gmd_event_spec_disp_pvt.fetch_row(
447: p_event_spec_disp => l_in_event_spec_disp,

Line 446: IF NOT(gmd_event_spec_disp_pvt.fetch_row(

442: ELSE
443: -- Fetch the GMD_EVENT_SPEC_DISP record
444: -- l_event_spec_disp.event_spec_disp_id := l_event_spec_disp_id;
445: l_in_event_spec_disp.event_spec_disp_id := l_event_spec_disp_id;
446: IF NOT(gmd_event_spec_disp_pvt.fetch_row(
447: p_event_spec_disp => l_in_event_spec_disp,
448: x_event_spec_disp => l_event_spec_disp)
449: )
450: THEN

Line 734: UPDATE gmd_event_spec_disp

730:
731: IF NOT (l_event_spec_disp.disposition IN ('1P', '2I')) THEN
732: -- Set the disposition of the Event spec disp
733: -- back to "In Progress"
734: UPDATE gmd_event_spec_disp
735: SET disposition = '2I',
736: last_updated_by = l_user_id,
737: last_update_date = l_date
738: WHERE event_spec_disp_id = l_event_spec_disp.event_spec_disp_id

Line 877: FROM gmd_event_spec_disp

873:
874: -- Cursors
875: CURSOR c_event_disp(p_sampling_event_id NUMBER) IS
876: SELECT event_spec_disp_id
877: FROM gmd_event_spec_disp
878: WHERE sampling_event_id = p_sampling_event_id
879: AND spec_used_for_lot_attrib_ind = 'Y'
880: AND delete_mark = 0
881: ;

Line 1450: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

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

Line 1453: l_in_event_spec_disp GMD_EVENT_SPEC_DISP%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
1457: e_results_insert_error EXCEPTION;

Line 1526: IF NOT (GMD_EVENT_SPEC_DISP_PVT.fetch_row(

1522: -- Fetch the Event Spec Record
1523: IF p_event_spec_disp_id IS NOT NULL THEN
1524: -- l_event_spec_disp.event_spec_disp_id := p_event_spec_disp_id;
1525: l_in_event_spec_disp.event_spec_disp_id := p_event_spec_disp_id;
1526: IF NOT (GMD_EVENT_SPEC_DISP_PVT.fetch_row(
1527: p_event_spec_disp => l_in_event_spec_disp,
1528: x_event_spec_disp => l_event_spec_disp)
1529: )
1530: THEN

Line 1803: UPDATE gmd_event_spec_disp

1799:
1800: IF (l_event_spec_disp.disposition <> '2I') THEN
1801: -- Set the disposition of the Event spec disp
1802: -- back to "In Progress"
1803: UPDATE gmd_event_spec_disp
1804: SET disposition = '2I',
1805: last_updated_by = l_user_id,
1806: last_update_date = l_date
1807: WHERE event_spec_disp_id = p_event_spec_disp_id

Line 2085: --| create a row in GMD_EVENT_SPEC_DISP and a row in |

2081: --| spec for a given sample. |
2082: --| |
2083: --| This procedure will first create any missing replicate |
2084: --| of the tests for the target spec in gmd_results. Then |
2085: --| create a row in GMD_EVENT_SPEC_DISP and a row in |
2086: --| GMD_SAMPLE_SPEC_DISP and a set of rows in |
2087: --| GMD_SPEC_RESULTS |
2088: --| |
2089: --| |

Line 2153: FROM gmd_event_spec_disp

2149: ;
2150:
2151: CURSOR c_event_spec (p_sampling_event_id NUMBER, p_spec_vr_id NUMBER) IS
2152: SELECT *
2153: FROM gmd_event_spec_disp
2154: WHERE sampling_event_id = p_sampling_event_id
2155: AND spec_vr_id = p_spec_vr_id
2156: AND spec_used_for_lot_attrib_ind = 'Y'
2157: ;

Line 2164: SELECT evaluation_ind from gmd_spec_results gsr, gmd_event_spec_disp esd --, gmd_sample_spec_disp ssd

2160: l_test_id GMD_QC_TESTS.test_id%TYPE;
2161: l_spec_id gmd_spec_tests_b.spec_id%TYPE;
2162:
2163: CURSOR c_evaluation_ind (p_result_id NUMBER, p_event_spec_disp_id NUMBER) IS
2164: SELECT evaluation_ind from gmd_spec_results gsr, gmd_event_spec_disp esd --, gmd_sample_spec_disp ssd
2165: WHERE gsr.result_id=p_result_id
2166: AND esd.event_spec_disp_id=p_event_spec_disp_id
2167: AND gsr.event_spec_disp_id=esd.event_spec_disp_id;
2168:

Line 2171: SELECT esd.event_spec_disp_id from gmd_event_spec_disp esd, gmd_sample_spec_disp ssd

2167: AND gsr.event_spec_disp_id=esd.event_spec_disp_id;
2168:
2169:
2170: CURSOR c_event_spec_disp_id (p_sample_id NUMBER) IS
2171: SELECT esd.event_spec_disp_id from gmd_event_spec_disp esd, gmd_sample_spec_disp ssd
2172: WHERE ssd.sample_id=p_sample_id
2173: AND esd.event_spec_disp_id=ssd.event_spec_disp_id
2174: AND esd.spec_used_for_lot_attrib_ind = 'Y';
2175:

Line 2245: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

2241: l_test_ids GMD_API_PUB.number_tab;
2242: l_results_tab GMD_API_PUB.gmd_results_tab;
2243: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
2244:
2245: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
2246: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
2247: l_spec_result GMD_SPEC_RESULTS%ROWTYPE;
2248: l_sample GMD_SAMPLES%ROWTYPE;
2249:

Line 2251: l_out_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

2247: l_spec_result GMD_SPEC_RESULTS%ROWTYPE;
2248: l_sample GMD_SAMPLES%ROWTYPE;
2249:
2250: l_in_sample GMD_SAMPLES%ROWTYPE;
2251: l_out_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
2252:
2253: -- Exceptions
2254: e_sample_fetch_error EXCEPTION;
2255: e_event_spec_disp_insert_error EXCEPTION;

Line 2351: UPDATE gmd_event_spec_disp

2347: FETCH c_event_spec INTO l_event_spec_disp;
2348: IF c_event_spec%NOTFOUND THEN
2349: -- Since the new spec is going to be the current one, change
2350: -- all the previous ones to NOT Current
2351: UPDATE gmd_event_spec_disp
2352: set spec_used_for_lot_attrib_ind = NULL
2353: where sampling_event_id = l_sample.sampling_event_id
2354: and spec_used_for_lot_attrib_ind = 'Y'
2355: ;

Line 2358: gmd_debug.put_line(' Updated all previous gmd_event_spec_disp to NOT-Current.');

2354: and spec_used_for_lot_attrib_ind = 'Y'
2355: ;
2356:
2357: IF (l_debug = 'Y') THEN
2358: gmd_debug.put_line(' Updated all previous gmd_event_spec_disp to NOT-Current.');
2359: END IF;
2360:
2361: -- Create a new record in GMD_EVENT_SPEC_DISP for the Target Spec
2362:

Line 2361: -- Create a new record in GMD_EVENT_SPEC_DISP for the Target Spec

2357: IF (l_debug = 'Y') THEN
2358: gmd_debug.put_line(' Updated all previous gmd_event_spec_disp to NOT-Current.');
2359: END IF;
2360:
2361: -- Create a new record in GMD_EVENT_SPEC_DISP for the Target Spec
2362:
2363: -- Construct the record
2364: l_event_spec_disp.SAMPLING_EVENT_ID := l_sample.sampling_event_id;
2365: l_event_spec_disp.SPEC_ID := p_target_spec_id;

Line 2379: -- We are ready for insert in GMD_EVENT_SPEC_DISP, so then lets do it.

2375: l_event_spec_disp.CREATED_BY := l_user_id;
2376: l_event_spec_disp.LAST_UPDATE_DATE := l_date;
2377: l_event_spec_disp.LAST_UPDATED_BY := l_user_id;
2378:
2379: -- We are ready for insert in GMD_EVENT_SPEC_DISP, so then lets do it.
2380: IF NOT(GMD_EVENT_SPEC_DISP_PVT.Insert_Row(
2381: p_event_spec_disp => l_event_spec_disp,
2382: x_event_spec_disp => l_out_event_spec_disp)
2383: )

Line 2380: IF NOT(GMD_EVENT_SPEC_DISP_PVT.Insert_Row(

2376: l_event_spec_disp.LAST_UPDATE_DATE := l_date;
2377: l_event_spec_disp.LAST_UPDATED_BY := l_user_id;
2378:
2379: -- We are ready for insert in GMD_EVENT_SPEC_DISP, so then lets do it.
2380: IF NOT(GMD_EVENT_SPEC_DISP_PVT.Insert_Row(
2381: p_event_spec_disp => l_event_spec_disp,
2382: x_event_spec_disp => l_out_event_spec_disp)
2383: )
2384: THEN

Line 2391: gmd_debug.put_line(' A new record is created in GMD_EVENT_SPEC_DISP. ID - ' || l_event_spec_disp.event_spec_disp_id);

2387: END IF;
2388: l_event_spec_disp.EVENT_SPEC_DISP_ID := l_out_event_spec_disp.EVENT_SPEC_DISP_ID;
2389:
2390: IF (l_debug = 'Y') THEN
2391: gmd_debug.put_line(' A new record is created in GMD_EVENT_SPEC_DISP. ID - ' || l_event_spec_disp.event_spec_disp_id);
2392: END IF;
2393:
2394: END IF;
2395: CLOSE c_event_spec;

Line 2824: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd

2820:
2821: -- Cursors
2822: CURSOR c_get_se_id (p_composite_spec_disp_id NUMBER) IS
2823: SELECT sampling_event_id
2824: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd
2825: WHERE csd.composite_spec_disp_id = p_composite_spec_disp_id
2826: AND csd.event_spec_disp_id = esd.event_spec_disp_id
2827: AND csd.latest_ind = 'Y'
2828: AND csd.delete_mark = 0

Line 3629: FROM gmd_event_spec_disp

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
3630: WHERE event_spec_disp_id = p_event_spec_disp_id);
3631: END IF;
3632: CLOSE c_composite;
3633:

Line 3682: FROM gmd_event_spec_disp esd,

3678:
3679: -- Bug 3079877: do not composite planning samples
3680: CURSOR c_sample(p_sampling_event_id NUMBER) IS
3681: SELECT s.sample_id
3682: FROM gmd_event_spec_disp esd,
3683: gmd_sample_spec_disp ssd,
3684: gmd_samples s
3685: WHERE esd.sampling_event_id = p_sampling_event_id
3686: AND esd.spec_used_for_lot_attrib_ind = 'Y'

Line 3928: FROM gmd_event_spec_disp

3924: ;
3925:
3926: CURSOR c_spec_id (p_event_spec_disp_id NUMBER) IS
3927: SELECT spec_id
3928: FROM gmd_event_spec_disp
3929: WHERE event_spec_disp_id = p_event_spec_disp_id
3930: ;
3931:
3932: CURSOR c_test_type (p_test_id NUMBER) IS

Line 6383: l_event_spec_disp_in GMD_EVENT_SPEC_DISP%ROWTYPE;

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;
6387: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

Line 6384: l_event_spec_disp GMD_EVENT_SPEC_DISP%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;
6387: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;
6388:

Line 6426: -- Check if we already have a record in GMD_EVENT_SPEC_DISP

6422: -- Fetch Error.
6423: RAISE e_sampling_event_fetch_error;
6424: END IF;
6425:
6426: -- Check if we already have a record in GMD_EVENT_SPEC_DISP
6427: l_event_spec_disp_in.event_spec_disp_id := get_current_event_spec_disp_id(
6428: l_sampling_event.sampling_event_id);
6429: -- Get the event spec disp record
6430: IF NOT (GMD_EVENT_SPEC_DISP_PVT.fetch_row(

Line 6430: IF NOT (GMD_EVENT_SPEC_DISP_PVT.fetch_row(

6426: -- Check if we already have a record in GMD_EVENT_SPEC_DISP
6427: l_event_spec_disp_in.event_spec_disp_id := get_current_event_spec_disp_id(
6428: l_sampling_event.sampling_event_id);
6429: -- Get the event spec disp record
6430: IF NOT (GMD_EVENT_SPEC_DISP_PVT.fetch_row(
6431: p_event_spec_disp => l_event_spec_disp_in,
6432: x_event_spec_disp => l_event_spec_disp)
6433: )
6434: THEN

Line 6770: gmd_event_spec_disp esd,

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
6774: WHERE s.sample_id = p_sample_id

Line 6822: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,

6818:
6819: CURSOR count_optional_tests(p_ssample_id number,
6820: p_event_spec_disp_id number ) IS
6821: SELECT st.optional_ind
6822: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,
6823: gmd_spec_tests_b st
6824: WHERE esd.event_spec_disp_id = p_event_spec_disp_id
6825: AND esd.event_spec_disp_id = sr.event_spec_disp_id
6826: AND sr.result_id = r.result_id

Line 6913: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,

6909:
6910: -- Select COUNT of Tests with Evaluation other then ACCEPT
6911: SELECT count(1)
6912: INTO l_count_with_spec
6913: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,
6914: gmd_spec_tests_b st
6915: WHERE esd.event_spec_disp_id = l_sample_rec.event_spec_disp_id
6916: AND esd.event_spec_disp_id = sr.event_spec_disp_id
6917: AND sr.result_id = r.result_id

Line 7030: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,

7026:
7027: -- Select COUNT of Tests with Evaluation other then ACCEPT
7028: SELECT count(1)
7029: INTO l_count_with_spec
7030: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,
7031: gmd_spec_tests_b st
7032: WHERE esd.event_spec_disp_id = l_sample_rec.event_spec_disp_id
7033: AND esd.event_spec_disp_id = sr.event_spec_disp_id
7034: AND sr.result_id = r.result_id

Line 7240: FROM gmd_event_spec_disp esd,

7236: svr.control_lot_attrib_ind,
7237: svr.in_spec_lot_status_id,
7238: svr.out_of_spec_lot_status_id,
7239: svr.organization_id
7240: FROM gmd_event_spec_disp esd,
7241: gmd_com_spec_vrs_vl svr,
7242: gmd_composite_spec_disp csd
7243: WHERE esd.event_spec_disp_id = p_event_spec_disp_id
7244: AND esd.spec_used_for_lot_attrib_ind = 'Y'

Line 7281: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

7277: l_reason_id gmd_quality_config.transaction_reason_id%TYPE;
7278:
7279:
7280: /*
7281: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
7282: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
7283: l_results GMD_RESULTS%ROWTYPE;
7284: l_spec_results GMD_SPEC_RESULTS%ROWTYPE;
7285:

Line 7286: l_in_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

7282: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
7283: l_results GMD_RESULTS%ROWTYPE;
7284: l_spec_results GMD_SPEC_RESULTS%ROWTYPE;
7285:
7286: l_in_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
7287: l_out_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
7288: l_out_results GMD_RESULTS%ROWTYPE;
7289: */
7290:

Line 7287: l_out_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

7283: l_results GMD_RESULTS%ROWTYPE;
7284: l_spec_results GMD_SPEC_RESULTS%ROWTYPE;
7285:
7286: l_in_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
7287: l_out_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
7288: l_out_results GMD_RESULTS%ROWTYPE;
7289: */
7290:
7291: -- Exception

Line 7422: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd,

7418: -- THE FOLLOWING
7419:
7420: SELECT count(1)
7421: INTO l_count_with_spec
7422: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd,
7423: gmd_composite_results cr, gmd_spec_tests_b st
7424: WHERE csd.event_spec_disp_id = l_event_spec_disp_id
7425: AND csd.latest_ind = 'Y'
7426: AND csd.event_spec_disp_id = esd.event_spec_disp_id

Line 7438: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd,

7434: ;
7435:
7436: SELECT count(1)
7437: INTO l_count_wo_spec
7438: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd,
7439: gmd_composite_results cr
7440: WHERE csd.event_spec_disp_id = l_event_spec_disp_id
7441: AND csd.latest_ind = 'Y'
7442: AND csd.event_spec_disp_id = esd.event_spec_disp_id