APPS.INV_GMI_MIGRATION dependencies on GMI_CATEGORY_SETS

Line 442: SELECT * FROM gmi_category_sets

438: l_functional_area_id NUMBER;
439: l_category_set_id NUMBER;
440:
441: CURSOR c_opm_category_sets IS
442: SELECT * FROM gmi_category_sets
443: WHERE migrated_ind is NULL AND
444: OPM_CLASS in ('ALLOC_CLASS','SEQ_CLASS','SUB_STANDARD_CLASS',
445: 'TECH_CLASS','GL_CLASS','COST_CLASS','GL_BUSINESS_CLASS',
446: 'GL_PRODUCT_LINE');

Line 456: p_table_name => 'GMI_CATEGORY_SETS',

452: GMA_COMMON_LOGGING.gma_migration_central_log (
453: p_run_id => p_migration_run_id,
454: p_log_level => FND_LOG.LEVEL_PROCEDURE,
455: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
456: p_table_name => 'GMI_CATEGORY_SETS',
457: p_context => 'CATEGORY SETS',
458: p_param1 => NULL,
459: p_param2 => NULL,
460: p_param3 => NULL,

Line 484: p_table_name => 'GMI_CATEGORY_SETS',

480: GMA_COMMON_LOGGING.gma_migration_central_log (
481: p_run_id => p_migration_run_id,
482: p_log_level => FND_LOG.LEVEL_PROCEDURE,
483: p_message_token => 'GMI_MIG_CAT_SET_ASSIGNED',
484: p_table_name => 'GMI_CATEGORY_SETS',
485: p_context => 'CATEGORY SETS',
486: p_param1 => c.user_opm_class,
487: p_param2 => NULL,
488: p_param3 => NULL,

Line 504: UPDATE gmi_category_sets

500: WHERE
501: functional_area_id = l_functional_area_id and
502: category_set_id = -1;
503:
504: UPDATE gmi_category_sets
505: SET migrated_ind = 1
506: WHERE opm_class = c.opm_class;
507:
508: IF (p_commit <> FND_API.G_FALSE) THEN

Line 521: p_table_name => 'GMI_CATEGORY_SETS',

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

Line 538: p_table_name => 'GMI_CATEGORY_SETS',

534: GMA_COMMON_LOGGING.gma_migration_central_log (
535: p_run_id => p_migration_run_id,
536: p_log_level => FND_LOG.LEVEL_PROCEDURE,
537: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
538: p_table_name => 'GMI_CATEGORY_SETS',
539: p_context => 'CATEGORY SETS',
540: p_param1 => NULL,
541: p_param2 => NULL,
542: p_param3 => NULL,

Line 555: p_table_name => 'GMI_CATEGORY_SETS',

551: GMA_COMMON_LOGGING.gma_migration_central_log (
552: p_run_id => p_migration_run_id,
553: p_log_level => FND_LOG.LEVEL_ERROR,
554: p_message_token => 'GMA_MIGRATION_DB_ERROR',
555: p_table_name => 'GMI_CATEGORY_SETS',
556: p_context => 'CATEGORY SETS',
557: p_param1 => NULL,
558: p_param2 => NULL,
559: p_param3 => NULL,