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_SAMPLES

Line 169: --| gmd_samples_grp.update_lot_grade_batch |

165: --| Chetan Nagar 23-Apr-2004 B3584185 |
166: --| Added gmd_stability_spec_vrs to |
167: --| the UNION query |
168: --| nsrivast 25-Jul-05 Updated call to api |
169: --| gmd_samples_grp.update_lot_grade_batch |
170: --| QZENG 15-Dec-2011: BUG 13476354 - added test_duration to cursor |
171: --| c_spec_tests, and set value to result.planned_result_date |
172: --+========================================================================+
173: -- End of comments

Line 177: p_sample IN GMD_SAMPLES%ROWTYPE

173: -- End of comments
174:
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

Line 1394: p_sample IN GMD_SAMPLES%ROWTYPE

1390: -- End of comments
1391:
1392: PROCEDURE add_tests_to_sample
1393: (
1394: p_sample IN GMD_SAMPLES%ROWTYPE
1395: , p_test_ids IN GMD_API_PUB.number_tab
1396: , p_event_spec_disp_id IN NUMBER
1397: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
1398: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab

Line 1446: l_sample GMD_SAMPLES%ROWTYPE;

1442: l_meaning VARCHAR2(80);
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;

Line 1481: IF NOT (gmd_samples_pvt.fetch_row(

1477: l_user_id := FND_GLOBAL.user_id;
1478: l_date := SYSDATE;
1479:
1480: -- Fetch the Sample Record
1481: IF NOT (gmd_samples_pvt.fetch_row(
1482: p_samples => p_sample,
1483: x_samples => l_sample)
1484: )
1485: THEN

Line 1783: -- UPDATE gmd_samples

1779: -- disposition of the sample must be set back to "In Progress"
1780:
1781: -- B3005589 The sample disposition is stored in gmd_sample_spec_disp.
1782: -- So the following update is not required.
1783: -- UPDATE gmd_samples
1784: -- SET sample_disposition = '2I',
1785: -- last_updated_by = l_user_id,
1786: -- last_update_date = l_date
1787: -- WHERE sample_id = l_sample.sample_id

Line 2002: l_sample GMD_SAMPLES%ROWTYPE;

1998: )
1999: IS
2000:
2001: -- Local Variables
2002: l_sample GMD_SAMPLES%ROWTYPE;
2003: l_test_ids GMD_API_PUB.number_tab;
2004: l_results_tab GMD_API_PUB.gmd_results_tab;
2005: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
2006:

Line 2248: l_sample GMD_SAMPLES%ROWTYPE;

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:
2250: l_in_sample GMD_SAMPLES%ROWTYPE;
2251: l_out_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
2252:

Line 2250: l_in_sample GMD_SAMPLES%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:
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;

Line 2274: IF NOT (GMD_SAMPLES_PVT.fetch_row(

2270:
2271: -- Make sure we have the sample record
2272: -- l_sample.sample_id := p_sample_id;
2273: l_in_sample.sample_id := p_sample_id;
2274: IF NOT (GMD_SAMPLES_PVT.fetch_row(
2275: p_samples => l_in_sample,
2276: x_samples => l_sample)
2277: )
2278: THEN

Line 3665: --| Chetan Nagar 09-Dec-2002 Changed disposition from gmd_samples|

3661: --| composite samples. |
3662: --| |
3663: --| HISTORY |
3664: --| Chetan Nagar 04-Sep-2002 Created. |
3665: --| Chetan Nagar 09-Dec-2002 Changed disposition from gmd_samples|
3666: --| To gmd_sample_spec_disp. |
3667: --| |
3668: --+========================================================================+
3669: -- End of comments

Line 3684: gmd_samples s

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'
3687: AND esd.event_spec_disp_id = ssd.event_spec_disp_id
3688: AND ssd.sample_id = s.sample_id

Line 3768: --| Manish Gupta 20-Jan-2004 Bug #B3358298, Included gmd_samples|

3764: --| Jeff Baird 12-Nov-2002 Bug #2626977 Removed reference to |
3765: --| SY$MIN_DATE profile. |
3766: --| Manish Gupta 13-Jan-2004 Bug #B3373760, changed 50(Zero) to |
3767: --| 5O(Letter O) |
3768: --| Manish Gupta 20-Jan-2004 Bug #B3358298, Included gmd_samples|
3769: --| so that the retain_as samples are |
3770: --| Excluded. |
3771: --+========================================================================+
3772: -- End of comments

Line 3809: ||' FROM gmd_results r, gmd_spec_results sr, gmd_samples s'

3805: ||' last_value(r.result_id)'
3806: ||' over (partition by r.test_id order by NVL(r.result_date, :l_start_date),'
3807: ||' r.test_replicate_cnt'
3808: ||' range between unbounded preceding and unbounded following) rmax_id'
3809: ||' FROM gmd_results r, gmd_spec_results sr, gmd_samples s'
3810: ||' WHERE r.result_id = sr.result_id'
3811: ||' AND r.sample_id = :l_sample_id'
3812: ||' AND sr.event_spec_disp_id = :l_event_spec_disp_id'
3813: ||' AND nvl(sr.evaluation_ind, ' || '''' || 'XX' || '''' || ') not in ('

Line 5292: gmd_samples_grp.update_lot_grade_batch( -- nsrivast

5288:
5289: IF p_lot_status IS NOT NULL THEN -- #3
5290: -- no grade, no composite id,
5291: --rconv
5292: gmd_samples_grp.update_lot_grade_batch( -- nsrivast
5293: p_sample_id => p_sample_id
5294: , p_composite_spec_disp_id => NULL
5295: , p_to_lot_status_id => p_lot_status
5296: , p_from_lot_status_id => NULL --p_from_lot_status

Line 5989: FROM gmd_samples s,

5985: -- Test Groups Enh Bug# 3447472
5986: CURSOR c_exp_test IS
5987: SELECT t.test_id, t.test_code, t.expression, t.display_precision,
5988: t.report_precision, r.result_id, r.result_value_num , r.test_replicate_cnt -- 14021970 added r.test_replicate_cnt
5989: FROM gmd_samples s,
5990: gmd_results r,
5991: gmd_spec_results sr,
5992: gmd_qc_tests_b t
5993: WHERE s.sample_id = r.sample_id

Line 6379: l_sample_in GMD_SAMPLES%ROWTYPE;

6375: l_change_disp_to VARCHAR2(4);
6376: l_qlty_config_present NUMBER; --RLNAGARA B5106039
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;

Line 6380: l_sample GMD_SAMPLES%ROWTYPE;

6376: l_qlty_config_present NUMBER; --RLNAGARA B5106039
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;

Line 6387: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

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:
6389: -- Exceptions
6390: e_sample_fetch_error EXCEPTION;
6391: e_sampling_event_fetch_error EXCEPTION;

Line 6406: IF NOT (GMD_SAMPLES_PVT.fetch_row(

6402: x_return_status := FND_API.G_RET_STS_SUCCESS;
6403:
6404: -- Get the sample record
6405: l_sample_in.sample_id := p_sample_id;
6406: IF NOT (GMD_SAMPLES_PVT.fetch_row(
6407: p_samples => l_sample_in,
6408: x_samples => l_sample)
6409: )
6410: THEN

Line 6673: -- by calling GMD_SAMPLES_GRP.update_sample_comp_disp

6669: -- So change the disposition of
6670: -- 1. sample_spec_disp
6671: -- 2. sampling_events (only if one sample required, OR atleast sample_req_cnt are Complete)
6672: -- 3. event_spec_disp (only if one sample required, OR atleast sample_req_cnt are Complete)
6673: -- by calling GMD_SAMPLES_GRP.update_sample_comp_disp
6674: -- =======================================================
6675:
6676: -- Prepare IN parameter
6677: l_update_disp_rec.sample_id := l_sample.sample_id;

Line 6687: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_sample_spec_disp.disposition);

6683:
6684:
6685:
6686: IF (l_debug = 'Y') THEN
6687: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_sample_spec_disp.disposition);
6688: END IF;
6689:
6690: GMD_SAMPLES_GRP.update_sample_comp_disp(
6691: p_update_disp_rec => l_update_disp_rec

Line 6690: GMD_SAMPLES_GRP.update_sample_comp_disp(

6686: IF (l_debug = 'Y') THEN
6687: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_sample_spec_disp.disposition);
6688: END IF;
6689:
6690: GMD_SAMPLES_GRP.update_sample_comp_disp(
6691: p_update_disp_rec => l_update_disp_rec
6692: , p_to_disposition => l_change_disp_to
6693: , x_return_status => x_return_status
6694: , x_message_data => x_message_data);

Line 6772: gmd_samples s,

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
6775: AND s.sampling_event_id = se.sampling_event_id
6776: AND se.sampling_event_id = esd.sampling_event_id

Line 6787: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

6783: AND ssd.delete_mark = 0
6784: ;
6785:
6786: l_sample_rec c_sample_dtl%ROWTYPE;
6787: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;
6788:
6789: l_change_disp_to VARCHAR2(4);
6790: l_disposition VARCHAR2(4);
6791:

Line 7120: -- by calling GMD_SAMPLES_GRP.update_sample_comp_disp

7116: -- So change the disposition of
7117: -- 1. sample_spec_disp
7118: -- 2. sampling_events (only if one sample required)
7119: -- 3. event_spec_disp (only if one sample required)
7120: -- by calling GMD_SAMPLES_GRP.update_sample_comp_disp
7121: --
7122: -- If there are more than one sample required then user
7123: -- has to go through composite results path to set the
7124: -- Event Disposition.

Line 7137: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);

7133: l_update_disp_rec.curr_disposition := l_sample_rec.disposition;
7134:
7135:
7136: IF (l_debug = 'Y') THEN
7137: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);
7138: END IF;
7139:
7140: GMD_SAMPLES_GRP.update_sample_comp_disp(
7141: p_update_disp_rec => l_update_disp_rec

Line 7140: GMD_SAMPLES_GRP.update_sample_comp_disp(

7136: IF (l_debug = 'Y') THEN
7137: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);
7138: END IF;
7139:
7140: GMD_SAMPLES_GRP.update_sample_comp_disp(
7141: p_update_disp_rec => l_update_disp_rec
7142: , p_to_disposition => l_change_disp_to
7143: , x_return_status => x_return_status
7144: , x_message_data => l_message_data);

Line 7261: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

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;
7262:
7263: l_event_spec_disp_id NUMBER;
7264: l_composite_spec_disp_id NUMBER;
7265: l_composite_exist VARCHAR2(1);

Line 7489: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);

7485: l_update_disp_rec.sampling_event_id := l_sampling_event.sampling_event_id;
7486: l_update_disp_rec.curr_disposition := l_spec_dtl.disposition;
7487:
7488: IF (l_debug = 'Y') THEN
7489: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);
7490: END IF;
7491:
7492: GMD_SAMPLES_GRP.update_sample_comp_disp(
7493: p_update_disp_rec => l_update_disp_rec

Line 7492: GMD_SAMPLES_GRP.update_sample_comp_disp(

7488: IF (l_debug = 'Y') THEN
7489: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);
7490: END IF;
7491:
7492: GMD_SAMPLES_GRP.update_sample_comp_disp(
7493: p_update_disp_rec => l_update_disp_rec
7494: , p_to_disposition => l_change_disp_to
7495: , x_return_status => l_return_status
7496: , x_message_data => l_message_data);

Line 7509: FROM gmd_samples

7505:
7506: -- Get the orgn_code for the sampling event
7507: SELECT organization_id
7508: INTO l_organization_id
7509: FROM gmd_samples
7510: WHERE sampling_event_id = l_sampling_event.sampling_event_id
7511: AND rownum = 1 ;
7512:
7513: -- Get the reason code from quality configuration/parameters

Line 7525: gmd_samples_grp.update_lot_grade_batch( --nsrivast

7521: CLOSE Cur_quality_config;
7522:
7523: --rconv
7524:
7525: gmd_samples_grp.update_lot_grade_batch( --nsrivast
7526: p_sample_id => NULL
7527: , p_composite_spec_disp_id => l_composite_spec_disp_id
7528: , p_to_lot_status_id => l_lot_status_id
7529: , p_from_lot_status_id => NULL --l_lot_status_id

Line 7575: , p_sample_id IN gmd_samples.sample_id%TYPE

7571: END composite_and_change_lot;
7572:
7573: PROCEDURE update_exptest_value_null
7574: (p_exp_ref_test_id IN gmd_qc_tests_b.test_id%TYPE
7575: , p_sample_id IN gmd_samples.sample_id%TYPE
7576: , p_event_spec_disp_id IN gmd_sample_spec_disp.event_spec_disp_id%TYPE
7577: , x_return_status OUT NOCOPY VARCHAR2
7578: )
7579: --Start of comments

Line 7604: CURSOR exp_tests_need_calc ( l_sample_id gmd_samples.sample_id%TYPE,

7600: SELECT DISTINCT test_id
7601: FROM gmd_qc_test_values_b val
7602: WHERE expression_ref_test_id = l_exp_ref_test_id ;
7603:
7604: CURSOR exp_tests_need_calc ( l_sample_id gmd_samples.sample_id%TYPE,
7605: l_test_id gmd_qc_tests_b.test_id%TYPE,
7606: l_event_spec_disp_id gmd_sample_spec_disp.event_spec_disp_id%TYPE)
7607: IS
7608: SELECT r.result_id

Line 7676: ||' FROM gmd_results r, gmd_spec_results sr, gmd_samples s'

7672: ||' SELECT result_id, test_id, 0, result_value_num, result_value_char FROM'
7673: ||' ('
7674: ||' SELECT r.result_id, r.test_id, r.result_value_num, r.result_value_char,'
7675: ||' r.result_date, r.test_replicate_cnt'
7676: ||' FROM gmd_results r, gmd_spec_results sr, gmd_samples s'
7677: ||' WHERE r.result_id = sr.result_id'
7678: ||' AND r.sample_id = :l_sample_id'
7679: ||' AND r.test_replicate_cnt = :l_test_replicate_cnt'
7680: ||' AND sr.event_spec_disp_id = :l_event_spec_disp_id'