APPS.GME_TRANSFORM_BATCH dependencies on GME_RESOURCE_TXNS

Line 63: p_table_name => 'GME_RESOURCE_TXNS',

59: gma_common_logging.gma_migration_central_log
60: (p_run_id => p_migration_run_id,
61: p_log_level => fnd_log.level_procedure,
62: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
63: p_table_name => 'GME_RESOURCE_TXNS',
64: p_context => 'REASON_ID',
65: p_app_short_name => 'GMA');
66: update_reason_id(p_migration_run_id);
67:

Line 388: UPDATE gme_resource_txns t

384: END update_from_doc_no;
385:
386: PROCEDURE update_reason_id(p_migration_run_id NUMBER) IS
387: BEGIN
388: UPDATE gme_resource_txns t
389: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
390: gma_common_logging.gma_migration_central_log
391: (p_run_id => p_migration_run_id,
392: p_log_level => fnd_log.level_procedure,

Line 394: p_table_name => 'GME_RESOURCE_TXNS',

390: gma_common_logging.gma_migration_central_log
391: (p_run_id => p_migration_run_id,
392: p_log_level => fnd_log.level_procedure,
393: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
394: p_table_name => 'GME_RESOURCE_TXNS',
395: p_context => 'REASON_ID',
396: p_param1 => SQL%ROWCOUNT,
397: p_app_short_name => 'GMA');
398: UPDATE gme_resource_txns_mig t

Line 398: UPDATE gme_resource_txns_mig t

394: p_table_name => 'GME_RESOURCE_TXNS',
395: p_context => 'REASON_ID',
396: p_param1 => SQL%ROWCOUNT,
397: p_app_short_name => 'GMA');
398: UPDATE gme_resource_txns_mig t
399: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
400: gma_common_logging.gma_migration_central_log
401: (p_run_id => p_migration_run_id,
402: p_log_level => fnd_log.level_procedure,

Line 404: p_table_name => 'GME_RESOURCE_TXNS_MIG',

400: gma_common_logging.gma_migration_central_log
401: (p_run_id => p_migration_run_id,
402: p_log_level => fnd_log.level_procedure,
403: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
404: p_table_name => 'GME_RESOURCE_TXNS_MIG',
405: p_context => 'REASON_ID',
406: p_param1 => SQL%ROWCOUNT,
407: p_app_short_name => 'GMA');
408: END update_reason_id;