APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_QC_ASSAY_CLASS

Line 638: FROM gmd_qc_assay_class

634: attribute28,
635: attribute29,
636: attribute30,
637: attribute_category
638: FROM gmd_qc_assay_class
639: WHERE decode(migration_status,NULL,'NM') <> 'MO';
640:
641: INSERT INTO gmd_test_classes_tl
642: (

Line 663: FROM gmd_qc_assay_class

659: created_by,
660: last_update_date,
661: last_updated_by,
662: last_update_login
663: FROM gmd_qc_assay_class
664: WHERE decode(migration_status,NULL,'NM') <> 'MO';
665:
666:
667: /* Updated record status to migrated */

Line 668: UPDATE gmd_qc_assay_class

664: WHERE decode(migration_status,NULL,'NM') <> 'MO';
665:
666:
667: /* Updated record status to migrated */
668: UPDATE gmd_qc_assay_class
669: SET migration_status = 'MO';
670:
671: l_rec_count := SQL%ROWCOUNT;
672:

Line 675: p_table_name => 'GMD_QC_ASSAY_CLASS',

671: l_rec_count := SQL%ROWCOUNT;
672:
673: GMA_MIGRATION.gma_insert_message (
674: p_run_id => p_migration_id,
675: p_table_name => 'GMD_QC_ASSAY_CLASS',
676: p_DB_ERROR => '',
677: p_param1 => '',
678: p_param2 => l_rec_count,
679: p_param3 => '',

Line 696: p_table_name => 'GMD_QC_ASSAY_CLASS',

692: WHEN OTHERS THEN
693: x_return_status := 'U';
694: GMA_MIGRATION.gma_insert_message (
695: p_run_id => p_migration_id,
696: p_table_name => 'GMD_QC_ASSAY_CLASS',
697: p_DB_ERROR => sqlerrm,
698: p_param1 => '',
699: p_param2 => '',
700: p_param3 => '',

Line 711: p_table_name => 'GMD_QC_ASSAY_CLASS',

707: p_base_message => 'Failed to migrate assay classes due to '||sqlerrm);
708:
709: GMA_MIGRATION.gma_insert_message (
710: p_run_id => p_migration_id,
711: p_table_name => 'GMD_QC_ASSAY_CLASS',
712: p_DB_ERROR => '',
713: p_param1 => '',
714: p_param2 => '',
715: p_param3 => '',