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