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_GRP

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