APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_SPEC_RESULTS

Line 5168: -- gmd_spec_results

5164: -- HISTORY
5165: -- M. Grosser 24-Sep-2002 Added cursor to set value of column seq in
5166: -- gmd_results in procedure Migrate_Results
5167: -- M. Grosser 08-Oct-2002 Moved additional_test_ind from gmd_results to
5168: -- gmd_spec_results
5169: -- B. Stone 21-Jan-2004 Moved the Fetch to c_ids to outside the IF
5170: -- following IF statement so it will execute for
5171: -- all results; before it was only executing for
5172: -- results with specs ( qc_spec_id not = null )

Line 5188: l_in_spec_ind GMD_SPEC_RESULTS.in_spec_ind%TYPE;

5184:
5185: /* ------------- LOCAL VARIABLES ------------------- */
5186: l_sampling_event_id NUMBER;
5187: l_sample_spec_disp_id NUMBER;
5188: l_in_spec_ind GMD_SPEC_RESULTS.in_spec_ind%TYPE;
5189: l_rec_count NUMBER := 0;
5190: l_seq NUMBER;
5191: l_additional_test_ind VARCHAR2(4);
5192: l_qc_lab_orgn_code GMD_RESULTS.qc_lab_orgn_code%TYPE;

Line 5193: l_evaluation_ind GMD_SPEC_RESULTS.evaluation_ind%TYPE;

5189: l_rec_count NUMBER := 0;
5190: l_seq NUMBER;
5191: l_additional_test_ind VARCHAR2(4);
5192: l_qc_lab_orgn_code GMD_RESULTS.qc_lab_orgn_code%TYPE;
5193: l_evaluation_ind GMD_SPEC_RESULTS.evaluation_ind%TYPE;
5194: l_return_status VARCHAR2(4);
5195: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;
5196: l_test_seq NUMBER;
5197: l_retest_lot_exp_ind VARCHAR2(1);

Line 5590: INSERT INTO gmd_spec_results

5586: rslt_rec.attribute_category
5587: );
5588:
5589: /* Create record for acceptance against a particular spec */
5590: INSERT INTO gmd_spec_results
5591: (
5592: event_spec_disp_id,
5593: result_id,
5594: evaluation_ind,

Line 5629: p_message_token => 'aFTER insert into GMD_SPEC_RESULTS',

5625: p_param2 => '',
5626: p_param3 => '',
5627: p_param4 => '',
5628: p_param5 => '',
5629: p_message_token => 'aFTER insert into GMD_SPEC_RESULTS',
5630: p_message_type => 'P',
5631: p_line_no => '1',
5632: p_position => '',
5633: p_base_message => '');

Line 5746: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;

5742: /* ------------- LOCAL VARIABLES ------------------- */
5743: l_return_status VARCHAR2(4);
5744: l_event_spec_tab GMD_EVENT_SPEC_DISP%ROWTYPE;
5745: l_sample_spec_tab GMD_SAMPLE_SPEC_DISP%ROWTYPE;
5746: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
5747: l_results_tab GMD_API_PUB.gmd_results_tab;
5748: l_spec_vr_id NUMBER;
5749: l_temp NUMBER;
5750: l_date DATE;

Line 5802: ( SELECT /*+ INDEX(SR GMD_SPEC_RESULTS_PK) */

5798: gmd_event_spec_disp esd
5799: WHERE S.sampling_event_id = ESD.sampling_event_id
5800: AND S.SAMPLE_DISPOSITION = '2I'
5801: and NOT EXISTS
5802: ( SELECT /*+ INDEX(SR GMD_SPEC_RESULTS_PK) */
5803: 1
5804: FROM gmd_spec_results sr
5805: WHERE SR.EVENT_SPEC_DISP_ID = esd.EVENT_SPEC_DISP_ID
5806: AND SR.EVALUATION_IND IS NULL );

Line 5804: FROM gmd_spec_results sr

5800: AND S.SAMPLE_DISPOSITION = '2I'
5801: and NOT EXISTS
5802: ( SELECT /*+ INDEX(SR GMD_SPEC_RESULTS_PK) */
5803: 1
5804: FROM gmd_spec_results sr
5805: WHERE SR.EVENT_SPEC_DISP_ID = esd.EVENT_SPEC_DISP_ID
5806: AND SR.EVALUATION_IND IS NULL );
5807:
5808: CURSOR c_cnt_results (psample_id NUMBER) IS

Line 5811: gmd_spec_results sr

5807:
5808: CURSOR c_cnt_results (psample_id NUMBER) IS
5809: SELECT 1
5810: FROM gmd_results r,
5811: gmd_spec_results sr
5812: WHERE r.sample_id = psample_id
5813: AND sr.result_id = r.result_id
5814: AND sr.evaluation_ind is null ;
5815: -- End of Bug 3601780

Line 5871: p_table_name => 'GMD_SPEC_RESULTS',

5867: ELSE
5868: ROLLBACK;
5869: GMA_MIGRATION.gma_insert_message (
5870: p_run_id => p_migration_id,
5871: p_table_name => 'GMD_SPEC_RESULTS',
5872: p_DB_ERROR => sqlerrm,
5873: p_param1 => 'l_spec_vr_id= '||l_spec_vr_id,
5874: p_param2 => 'nores_rec.sample_id= '||nores_rec.sample_id,
5875: p_param3 => 'nores_rec.lot_retest_ind= '||nores_rec.lot_retest_ind,