DBA Data[Home] [Help]

APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_TEST_VALUES_TL

Line 1720: FROM gmd_test_values_tl t,

1716: t.created_by,
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:

Line 1726: UPDATE gmd_test_values_tl

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 */
1726: UPDATE gmd_test_values_tl
1727: SET migration_status = 'MO';
1728:
1729: l_rec_count := SQL%ROWCOUNT;
1730:

Line 1733: p_table_name => 'GMD_TEST_VALUES_TL',

1729: l_rec_count := SQL%ROWCOUNT;
1730:
1731: GMA_MIGRATION.gma_insert_message (
1732: p_run_id => p_migration_id,
1733: p_table_name => 'GMD_TEST_VALUES_TL',
1734: p_DB_ERROR => '',
1735: p_param1 => '',
1736: p_param2 => l_rec_count,
1737: p_param3 => '',

Line 1754: p_table_name => 'GMD_TEST_VALUES_TL',

1750: WHEN OTHERS THEN
1751: x_return_status := 'U';
1752: GMA_MIGRATION.gma_insert_message (
1753: p_run_id => p_migration_id,
1754: p_table_name => 'GMD_TEST_VALUES_TL',
1755: p_DB_ERROR => sqlerrm,
1756: p_param1 => '',
1757: p_param2 => '',
1758: p_param3 => '',

Line 1769: p_table_name => 'GMD_TEST_VALUES_TL',

1765: p_base_message => 'Failed to migrate test values translated due to '||sqlerrm);
1766:
1767: GMA_MIGRATION.gma_insert_message (
1768: p_run_id => p_migration_id,
1769: p_table_name => 'GMD_TEST_VALUES_TL',
1770: p_DB_ERROR => '',
1771: p_param1 => '',
1772: p_param2 => '',
1773: p_param3 => '',