APPS.INV_GMI_MIGRATION dependencies on GMI_CATEGORY_SETS

Line 481: SELECT * FROM gmi_category_sets

477: l_functional_area_id NUMBER;
478: l_category_set_id NUMBER;
479:
480: CURSOR c_opm_category_sets IS
481: SELECT * FROM gmi_category_sets
482: WHERE migrated_ind is NULL AND
483: OPM_CLASS in ('ALLOC_CLASS','SEQ_CLASS','SUB_STANDARD_CLASS',
484: 'TECH_CLASS','GL_CLASS','COST_CLASS','GL_BUSINESS_CLASS',
485: 'GL_PRODUCT_LINE');

Line 495: p_table_name => 'GMI_CATEGORY_SETS',

491: GMA_COMMON_LOGGING.gma_migration_central_log (
492: p_run_id => p_migration_run_id,
493: p_log_level => FND_LOG.LEVEL_PROCEDURE,
494: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
495: p_table_name => 'GMI_CATEGORY_SETS',
496: p_context => 'CATEGORY SETS',
497: p_param1 => NULL,
498: p_param2 => NULL,
499: p_param3 => NULL,

Line 523: p_table_name => 'GMI_CATEGORY_SETS',

519: GMA_COMMON_LOGGING.gma_migration_central_log (
520: p_run_id => p_migration_run_id,
521: p_log_level => FND_LOG.LEVEL_PROCEDURE,
522: p_message_token => 'GMI_MIG_CAT_SET_ASSIGNED',
523: p_table_name => 'GMI_CATEGORY_SETS',
524: p_context => 'CATEGORY SETS',
525: p_param1 => c.user_opm_class,
526: p_param2 => NULL,
527: p_param3 => NULL,

Line 543: UPDATE gmi_category_sets

539: WHERE
540: functional_area_id = l_functional_area_id and
541: category_set_id = -1;
542:
543: UPDATE gmi_category_sets
544: SET migrated_ind = 1
545: WHERE opm_class = c.opm_class;
546:
547: IF (p_commit <> FND_API.G_FALSE) THEN

Line 560: p_table_name => 'GMI_CATEGORY_SETS',

556: GMA_COMMON_LOGGING.gma_migration_central_log (
557: p_run_id => p_migration_run_id,
558: p_log_level => FND_LOG.LEVEL_PROCEDURE,
559: p_message_token => 'GMI_MIG_NO_FUNC_AREA',
560: p_table_name => 'GMI_CATEGORY_SETS',
561: p_context => 'CATEGORY SETS',
562: p_param1 => c.user_opm_class,
563: p_param2 => NULL,
564: p_param3 => NULL,

Line 577: p_table_name => 'GMI_CATEGORY_SETS',

573: GMA_COMMON_LOGGING.gma_migration_central_log (
574: p_run_id => p_migration_run_id,
575: p_log_level => FND_LOG.LEVEL_PROCEDURE,
576: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
577: p_table_name => 'GMI_CATEGORY_SETS',
578: p_context => 'CATEGORY SETS',
579: p_param1 => NULL,
580: p_param2 => NULL,
581: p_param3 => NULL,

Line 594: p_table_name => 'GMI_CATEGORY_SETS',

590: GMA_COMMON_LOGGING.gma_migration_central_log (
591: p_run_id => p_migration_run_id,
592: p_log_level => FND_LOG.LEVEL_ERROR,
593: p_message_token => 'GMA_MIGRATION_DB_ERROR',
594: p_table_name => 'GMI_CATEGORY_SETS',
595: p_context => 'CATEGORY SETS',
596: p_param1 => NULL,
597: p_param2 => NULL,
598: p_param3 => NULL,