APPS.GMD_QC_MIGRATE_TO_1151J dependencies on QC_SMPL_MST

Line 104: qc_smpl_mst s

100: CURSOR c_results IS
101: SELECT min(s.sample_date),
102: max(s.sample_date)
103: FROM qc_rslt_mst r,
104: qc_smpl_mst s
105: WHERE r.qc_spec_id = c_qc_spec_id
106: and s.sample_id = r.sample_id;
107:
108: CURSOR c_rslt_date IS

Line 111: qc_smpl_mst s

107:
108: CURSOR c_rslt_date IS
109: SELECT min(s.sample_date)
110: FROM qc_rslt_mst r,
111: qc_smpl_mst s
112: WHERE r.qc_spec_id = o_qc_spec_id
113: and s.sample_id = r.sample_id;
114:
115: CURSOR c_chk_overlaps IS

Line 256: UPDATE qc_smpl_mst

252: UPDATE qc_rslt_mst
253: SET migration_status = 'DR'
254: WHERE qc_spec_id = o_qc_spec_id
255: or qc_spec_id = last_qc_spec_id;
256: UPDATE qc_smpl_mst
257: SET migration_status = 'DR'
258: WHERE sample_id IN (
259: select sample_id
260: from qc_rslt_mst

Line 352: UPDATE qc_smpl_mst s

348: UPDATE qc_rslt_mst
349: SET migration_status = 'UM'
350: WHERE qc_spec_id = o_qc_spec_id
351: or qc_spec_id = last_qc_spec_id;
352: UPDATE qc_smpl_mst s
353: SET migration_status = 'UM'
354: WHERE s.sample_id IN (
355: select sample_id
356: from qc_spec_mst sp,

Line 3906: FROM qc_smpl_mst

3902: attribute28,
3903: attribute29,
3904: attribute30,
3905: attribute_category
3906: FROM qc_smpl_mst
3907: WHERE migration_status is NULL ;
3908: smpl_rec c_get_samples%ROWTYPE;
3909:
3910: /* Get the spec validity rule from the mapping table */

Line 3954: FROM qc_smpl_mst

3950: organization but with a different record type since that used
3951: to be allowed */
3952: CURSOR c_check_dup IS
3953: SELECT count(*)
3954: FROM qc_smpl_mst
3955: WHERE orgn_code = smpl_rec.orgn_code
3956: and sample_no = smpl_rec.sample_no;
3957:
3958: -- Bug 3859406; replaced table all_tab_columns with fnd_columns;

Line 3991: p_table_name => 'QC_SMPL_MST',

3987: BEGIN
3988:
3989: GMA_MIGRATION.gma_insert_message (
3990: p_run_id => p_migration_id,
3991: p_table_name => 'QC_SMPL_MST',
3992: p_DB_ERROR => '',
3993: p_param1 => '',
3994: p_param2 => '',
3995: p_param3 => '',

Line 4593: p_table_name => 'QC_SMPL_MST',

4589:
4590: IF l_sm_tests_cnt = 0 then
4591: GMA_MIGRATION.gma_insert_message (
4592: p_run_id => p_migration_id,
4593: p_table_name => 'QC_SMPL_MST',
4594: p_DB_ERROR => '',
4595: p_param1 => 'Sample with results have with spec tests',
4596: p_param2 => 'Cannot match migrated spec ',
4597: p_param3 => 'Sample_id = '||smpl_rec.sample_id,

Line 5080: UPDATE qc_smpl_mst

5076: smpl_rec.last_update_login
5077: );
5078:
5079: /* Set status to migrated for record */
5080: UPDATE qc_smpl_mst
5081: SET migration_status = 'MO'
5082: WHERE sample_id = smpl_rec.sample_id;
5083:
5084: COMMIT;

Line 5096: p_table_name => 'QC_SMPL_MST',

5092: CLOSE c_get_samples;
5093:
5094: GMA_MIGRATION.gma_insert_message (
5095: p_run_id => p_migration_id,
5096: p_table_name => 'QC_SMPL_MST',
5097: p_DB_ERROR => '',
5098: p_param1 => '',
5099: p_param2 => l_rec_count,
5100: p_param3 => '',

Line 5115: p_table_name => 'QC_SMPL_MST',

5111: x_return_status := 'U';
5112: ROLLBACK TO SAVEPOINT Sample_Rec;
5113: GMA_MIGRATION.gma_insert_message (
5114: p_run_id => p_migration_id,
5115: p_table_name => 'QC_SMPL_MST',
5116: p_DB_ERROR => sqlerrm,
5117: p_param1 => '',
5118: p_param2 => '',
5119: p_param3 => '',

Line 5130: p_table_name => 'QC_SMPL_MST',

5126: p_base_message => 'Failed to migrate samples due to '||sqlerrm);
5127:
5128: GMA_MIGRATION.gma_insert_message (
5129: p_run_id => p_migration_id,
5130: p_table_name => 'QC_SMPL_MST',
5131: p_DB_ERROR => '',
5132: p_param1 => '',
5133: p_param2 => '',
5134: p_param3 => '',