DBA Data[Home] [Help]

APPS.GMD_QC_MIGRATE_TO_1151J dependencies on QC_ACTN_MST_BAK

Line 841: FROM qc_actn_mst_bak

837: attribute28,
838: attribute29,
839: attribute30,
840: attribute_category
841: FROM qc_actn_mst_bak
842: WHERE decode(migration_status,NULL,'NM') <> 'MO';
843:
844: /* Insert action code description in translation table */
845: INSERT INTO gmd_actions_tl

Line 867: FROM qc_actn_mst_bak

863: created_by,
864: last_update_date,
865: last_updated_by,
866: last_update_login
867: FROM qc_actn_mst_bak
868: WHERE decode(migration_status,NULL,'NM') <> 'MO';
869:
870:
871: /* Updated record status to migrated */

Line 872: UPDATE qc_actn_mst_bak

868: WHERE decode(migration_status,NULL,'NM') <> 'MO';
869:
870:
871: /* Updated record status to migrated */
872: UPDATE qc_actn_mst_bak
873: SET migration_status = 'MO';
874:
875: l_rec_count := SQL%ROWCOUNT;
876:

Line 879: p_table_name => 'QC_ACTN_MST_BAK',

875: l_rec_count := SQL%ROWCOUNT;
876:
877: GMA_MIGRATION.gma_insert_message (
878: p_run_id => p_migration_id,
879: p_table_name => 'QC_ACTN_MST_BAK',
880: p_DB_ERROR => '',
881: p_param1 => '',
882: p_param2 => l_rec_count,
883: p_param3 => '',

Line 900: p_table_name => 'QC_ACTN_MST_BAK',

896: WHEN OTHERS THEN
897: x_return_status := 'U';
898: GMA_MIGRATION.gma_insert_message (
899: p_run_id => p_migration_id,
900: p_table_name => 'QC_ACTN_MST_BAK',
901: p_DB_ERROR => sqlerrm,
902: p_param1 => '',
903: p_param2 => '',
904: p_param3 => '',