APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_TEST_VALUES_B

Line 1607: FROM gmd_test_values_b

1603: attribute28,
1604: attribute29,
1605: attribute30,
1606: attribute_category
1607: FROM gmd_test_values_b
1608: WHERE decode(migration_status,NULL,'NM') <> 'MO';
1609:
1610: /* Updated record status to migrated */
1611: UPDATE gmd_test_values_b

Line 1611: UPDATE gmd_test_values_b

1607: FROM gmd_test_values_b
1608: WHERE decode(migration_status,NULL,'NM') <> 'MO';
1609:
1610: /* Updated record status to migrated */
1611: UPDATE gmd_test_values_b
1612: SET migration_status = 'MO';
1613:
1614: l_rec_count := SQL%ROWCOUNT;
1615:

Line 1618: p_table_name => 'GMD_TEST_VALUES_B',

1614: l_rec_count := SQL%ROWCOUNT;
1615:
1616: GMA_MIGRATION.gma_insert_message (
1617: p_run_id => p_migration_id,
1618: p_table_name => 'GMD_TEST_VALUES_B',
1619: p_DB_ERROR => '',
1620: p_param1 => '',
1621: p_param2 => l_rec_count,
1622: p_param3 => '',

Line 1639: p_table_name => 'GMD_TEST_VALUES_B',

1635: WHEN OTHERS THEN
1636: x_return_status := 'U';
1637: GMA_MIGRATION.gma_insert_message (
1638: p_run_id => p_migration_id,
1639: p_table_name => 'GMD_TEST_VALUES_B',
1640: p_DB_ERROR => sqlerrm,
1641: p_param1 => '',
1642: p_param2 => '',
1643: p_param3 => '',

Line 1654: p_table_name => 'GMD_TEST_VALUES_B',

1650: p_base_message => 'Failed to migrate test values base due to '||sqlerrm);
1651:
1652: GMA_MIGRATION.gma_insert_message (
1653: p_run_id => p_migration_id,
1654: p_table_name => 'GMD_TEST_VALUES_B',
1655: p_DB_ERROR => '',
1656: p_param1 => '',
1657: p_param2 => '',
1658: p_param3 => '',

Line 1721: gmd_test_values_b b

1717: t.last_update_date,
1718: t.last_updated_by,
1719: t.last_update_login
1720: FROM gmd_test_values_tl t,
1721: gmd_test_values_b b
1722: WHERE t.qcassy_val_id = b.qcassy_val_id AND
1723: decode(t.migration_status,NULL,'NM') <> 'MO';
1724:
1725: /* Updated record status to migrated */