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 125: --| gmd_samples_grp.update_lot_grade_batch |

121: --| Chetan Nagar 23-Apr-2004 B3584185 |
122: --| Added gmd_stability_spec_vrs to |
123: --| the UNION query |
124: --| nsrivast 25-Jul-05 Updated call to api |
125: --| gmd_samples_grp.update_lot_grade_batch |
126: --+========================================================================+
127: -- End of comments
128:
129: PROCEDURE create_rslt_and_spec_rslt_rows

Line 131: p_sample IN GMD_SAMPLES%ROWTYPE

127: -- End of comments
128:
129: PROCEDURE create_rslt_and_spec_rslt_rows
130: (
131: p_sample IN GMD_SAMPLES%ROWTYPE
132: , p_migration IN VARCHAR2
133: , x_event_spec_disp OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
134: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE
135: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab

Line 1320: p_sample IN GMD_SAMPLES%ROWTYPE

1316: -- End of comments
1317:
1318: PROCEDURE add_tests_to_sample
1319: (
1320: p_sample IN GMD_SAMPLES%ROWTYPE
1321: , p_test_ids IN GMD_API_PUB.number_tab
1322: , p_event_spec_disp_id IN NUMBER
1323: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
1324: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab

Line 1371: l_sample GMD_SAMPLES%ROWTYPE;

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

Line 1405: IF NOT (gmd_samples_pvt.fetch_row(

1401: l_user_id := FND_GLOBAL.user_id;
1402: l_date := SYSDATE;
1403:
1404: -- Fetch the Sample Record
1405: IF NOT (gmd_samples_pvt.fetch_row(
1406: p_samples => p_sample,
1407: x_samples => l_sample)
1408: )
1409: THEN

Line 1701: -- UPDATE gmd_samples

1697: -- disposition of the sample must be set back to "In Progress"
1698:
1699: -- B3005589 The sample disposition is stored in gmd_sample_spec_disp.
1700: -- So the following update is not required.
1701: -- UPDATE gmd_samples
1702: -- SET sample_disposition = '2I',
1703: -- last_updated_by = l_user_id,
1704: -- last_update_date = l_date
1705: -- WHERE sample_id = l_sample.sample_id

Line 1920: l_sample GMD_SAMPLES%ROWTYPE;

1916: )
1917: IS
1918:
1919: -- Local Variables
1920: l_sample GMD_SAMPLES%ROWTYPE;
1921: l_test_ids GMD_API_PUB.number_tab;
1922: l_results_tab GMD_API_PUB.gmd_results_tab;
1923: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
1924:

Line 2161: l_sample GMD_SAMPLES%ROWTYPE;

2157:
2158: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
2159: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
2160: l_spec_result GMD_SPEC_RESULTS%ROWTYPE;
2161: l_sample GMD_SAMPLES%ROWTYPE;
2162:
2163: l_in_sample GMD_SAMPLES%ROWTYPE;
2164: l_out_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
2165:

Line 2163: l_in_sample GMD_SAMPLES%ROWTYPE;

2159: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
2160: l_spec_result GMD_SPEC_RESULTS%ROWTYPE;
2161: l_sample GMD_SAMPLES%ROWTYPE;
2162:
2163: l_in_sample GMD_SAMPLES%ROWTYPE;
2164: l_out_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
2165:
2166: -- Exceptions
2167: e_sample_fetch_error EXCEPTION;

Line 2187: IF NOT (GMD_SAMPLES_PVT.fetch_row(

2183:
2184: -- Make sure we have the sample record
2185: -- l_sample.sample_id := p_sample_id;
2186: l_in_sample.sample_id := p_sample_id;
2187: IF NOT (GMD_SAMPLES_PVT.fetch_row(
2188: p_samples => l_in_sample,
2189: x_samples => l_sample)
2190: )
2191: THEN

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

3492: --| composite samples. |
3493: --| |
3494: --| HISTORY |
3495: --| Chetan Nagar 04-Sep-2002 Created. |
3496: --| Chetan Nagar 09-Dec-2002 Changed disposition from gmd_samples|
3497: --| To gmd_sample_spec_disp. |
3498: --| |
3499: --+========================================================================+
3500: -- End of comments

Line 3515: gmd_samples s

3511: CURSOR c_sample(p_sampling_event_id NUMBER) IS
3512: SELECT s.sample_id
3513: FROM gmd_event_spec_disp esd,
3514: gmd_sample_spec_disp ssd,
3515: gmd_samples s
3516: WHERE esd.sampling_event_id = p_sampling_event_id
3517: AND esd.spec_used_for_lot_attrib_ind = 'Y'
3518: AND esd.event_spec_disp_id = ssd.event_spec_disp_id
3519: AND ssd.sample_id = s.sample_id

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

3595: --| Jeff Baird 12-Nov-2002 Bug #2626977 Removed reference to |
3596: --| SY$MIN_DATE profile. |
3597: --| Manish Gupta 13-Jan-2004 Bug #B3373760, changed 50(Zero) to |
3598: --| 5O(Letter O) |
3599: --| Manish Gupta 20-Jan-2004 Bug #B3358298, Included gmd_samples|
3600: --| so that the retain_as samples are |
3601: --| Excluded. |
3602: --+========================================================================+
3603: -- End of comments

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

3636: ||' last_value(r.result_id)'
3637: ||' over (partition by r.test_id order by NVL(r.result_date, :l_start_date),'
3638: ||' r.test_replicate_cnt'
3639: ||' range between unbounded preceding and unbounded following) rmax_id'
3640: ||' FROM gmd_results r, gmd_spec_results sr, gmd_samples s'
3641: ||' WHERE r.result_id = sr.result_id'
3642: ||' AND r.sample_id = :l_sample_id'
3643: ||' AND sr.event_spec_disp_id = :l_event_spec_disp_id'
3644: ||' AND nvl(sr.evaluation_ind, ' || '''' || 'XX' || '''' || ') not in ('

Line 5123: gmd_samples_grp.update_lot_grade_batch( -- nsrivast

5119:
5120: IF p_lot_status IS NOT NULL THEN -- #3
5121: -- no grade, no composite id,
5122: --rconv
5123: gmd_samples_grp.update_lot_grade_batch( -- nsrivast
5124: p_sample_id => p_sample_id
5125: , p_composite_spec_disp_id => NULL
5126: , p_to_lot_status_id => p_lot_status
5127: , p_from_lot_status_id => NULL --p_from_lot_status

Line 5789: FROM gmd_samples s,

5785: -- Test Groups Enh Bug# 3447472
5786: CURSOR c_exp_test IS
5787: SELECT t.test_id, t.test_code, t.expression, t.display_precision,
5788: t.report_precision, r.result_id, r.result_value_num
5789: FROM gmd_samples s,
5790: gmd_results r,
5791: gmd_spec_results sr,
5792: gmd_qc_tests_b t
5793: WHERE s.sample_id = r.sample_id

Line 6117: l_sample_in GMD_SAMPLES%ROWTYPE;

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

Line 6118: l_sample GMD_SAMPLES%ROWTYPE;

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

Line 6125: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

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;
6125: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;
6126:
6127: -- Exceptions
6128: e_sample_fetch_error EXCEPTION;
6129: e_sampling_event_fetch_error EXCEPTION;

Line 6144: IF NOT (GMD_SAMPLES_PVT.fetch_row(

6140: x_return_status := FND_API.G_RET_STS_SUCCESS;
6141:
6142: -- Get the sample record
6143: l_sample_in.sample_id := p_sample_id;
6144: IF NOT (GMD_SAMPLES_PVT.fetch_row(
6145: p_samples => l_sample_in,
6146: x_samples => l_sample)
6147: )
6148: THEN

Line 6352: -- by calling GMD_SAMPLES_GRP.update_sample_comp_disp

6348: -- So change the disposition of
6349: -- 1. sample_spec_disp
6350: -- 2. sampling_events (only if one sample required, OR atleast sample_req_cnt are Complete)
6351: -- 3. event_spec_disp (only if one sample required, OR atleast sample_req_cnt are Complete)
6352: -- by calling GMD_SAMPLES_GRP.update_sample_comp_disp
6353: -- =======================================================
6354:
6355: -- Prepare IN parameter
6356: l_update_disp_rec.sample_id := l_sample.sample_id;

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

6362:
6363:
6364:
6365: IF (l_debug = 'Y') THEN
6366: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_sample_spec_disp.disposition);
6367: END IF;
6368:
6369: GMD_SAMPLES_GRP.update_sample_comp_disp(
6370: p_update_disp_rec => l_update_disp_rec

Line 6369: GMD_SAMPLES_GRP.update_sample_comp_disp(

6365: IF (l_debug = 'Y') THEN
6366: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_sample_spec_disp.disposition);
6367: END IF;
6368:
6369: GMD_SAMPLES_GRP.update_sample_comp_disp(
6370: p_update_disp_rec => l_update_disp_rec
6371: , p_to_disposition => l_change_disp_to
6372: , x_return_status => x_return_status
6373: , x_message_data => x_message_data);

Line 6448: gmd_samples s,

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
6450: WHERE s.sample_id = p_sample_id
6451: AND s.sampling_event_id = se.sampling_event_id
6452: AND se.sampling_event_id = esd.sampling_event_id

Line 6463: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

6459: AND ssd.delete_mark = 0
6460: ;
6461:
6462: l_sample_rec c_sample_dtl%ROWTYPE;
6463: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;
6464:
6465: l_change_disp_to VARCHAR2(4);
6466: l_disposition VARCHAR2(4);
6467:

Line 6747: -- by calling GMD_SAMPLES_GRP.update_sample_comp_disp

6743: -- So change the disposition of
6744: -- 1. sample_spec_disp
6745: -- 2. sampling_events (only if one sample required)
6746: -- 3. event_spec_disp (only if one sample required)
6747: -- by calling GMD_SAMPLES_GRP.update_sample_comp_disp
6748: --
6749: -- If there are more than one sample required then user
6750: -- has to go through composite results path to set the
6751: -- Event Disposition.

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

6760: l_update_disp_rec.curr_disposition := l_sample_rec.disposition;
6761:
6762:
6763: IF (l_debug = 'Y') THEN
6764: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);
6765: END IF;
6766:
6767: GMD_SAMPLES_GRP.update_sample_comp_disp(
6768: p_update_disp_rec => l_update_disp_rec

Line 6767: GMD_SAMPLES_GRP.update_sample_comp_disp(

6763: IF (l_debug = 'Y') THEN
6764: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);
6765: END IF;
6766:
6767: GMD_SAMPLES_GRP.update_sample_comp_disp(
6768: p_update_disp_rec => l_update_disp_rec
6769: , p_to_disposition => l_change_disp_to
6770: , x_return_status => x_return_status
6771: , x_message_data => l_message_data);

Line 6884: l_update_disp_rec GMD_SAMPLES_GRP.update_disp_rec;

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;
6885:
6886: l_event_spec_disp_id NUMBER;
6887: l_composite_spec_disp_id NUMBER;
6888: l_composite_exist VARCHAR2(1);

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

7108: l_update_disp_rec.sampling_event_id := l_sampling_event.sampling_event_id;
7109: l_update_disp_rec.curr_disposition := l_spec_dtl.disposition;
7110:
7111: IF (l_debug = 'Y') THEN
7112: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);
7113: END IF;
7114:
7115: GMD_SAMPLES_GRP.update_sample_comp_disp(
7116: p_update_disp_rec => l_update_disp_rec

Line 7115: GMD_SAMPLES_GRP.update_sample_comp_disp(

7111: IF (l_debug = 'Y') THEN
7112: gmd_debug.put_line (' Call GMD_SAMPLES_GRP.update_sample_comp_disp '|| l_change_disp_to);
7113: END IF;
7114:
7115: GMD_SAMPLES_GRP.update_sample_comp_disp(
7116: p_update_disp_rec => l_update_disp_rec
7117: , p_to_disposition => l_change_disp_to
7118: , x_return_status => l_return_status
7119: , x_message_data => l_message_data);

Line 7132: FROM gmd_samples

7128:
7129: -- Get the orgn_code for the sampling event
7130: SELECT organization_id
7131: INTO l_organization_id
7132: FROM gmd_samples
7133: WHERE sampling_event_id = l_sampling_event.sampling_event_id
7134: AND rownum = 1 ;
7135:
7136: -- Get the reason code from quality configuration/parameters

Line 7148: gmd_samples_grp.update_lot_grade_batch( --nsrivast

7144: CLOSE Cur_quality_config;
7145:
7146: --rconv
7147:
7148: gmd_samples_grp.update_lot_grade_batch( --nsrivast
7149: p_sample_id => NULL
7150: , p_composite_spec_disp_id => l_composite_spec_disp_id
7151: , p_to_lot_status_id => l_lot_status_id
7152: , p_from_lot_status_id => NULL --l_lot_status_id

Line 7198: , p_sample_id IN gmd_samples.sample_id%TYPE

7194: END composite_and_change_lot;
7195:
7196: PROCEDURE update_exptest_value_null
7197: (p_exp_ref_test_id IN gmd_qc_tests_b.test_id%TYPE
7198: , p_sample_id IN gmd_samples.sample_id%TYPE
7199: , p_event_spec_disp_id IN gmd_sample_spec_disp.event_spec_disp_id%TYPE
7200: , x_return_status OUT NOCOPY VARCHAR2
7201: )
7202: --Start of comments

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

7223: SELECT DISTINCT test_id
7224: FROM gmd_qc_test_values_b val
7225: WHERE expression_ref_test_id = l_exp_ref_test_id ;
7226:
7227: CURSOR exp_tests_need_calc ( l_sample_id gmd_samples.sample_id%TYPE,
7228: l_test_id gmd_qc_tests_b.test_id%TYPE,
7229: l_event_spec_disp_id gmd_sample_spec_disp.event_spec_disp_id%TYPE)
7230: IS
7231: SELECT r.result_id