APPS.GMD_NPD_MIGRATE dependencies on GMD_RECIPES_B

Line 1046: FROM gmd_recipes_b chld,

1042: /* ------------------ CURSORS ---------------------- */
1043:
1044: CURSOR Cur_get_recipe IS
1045: SELECT chld.recipe_id, mst.recipe_id master_recipe_id
1046: FROM gmd_recipes_b chld,
1047: (SELECT recipe_id, owner_organization_id, recipe_no, formula_id, routing_id
1048: FROM gmd_recipes_b
1049: WHERE recipe_type = 0 ) mst,
1050: Mtl_parameters org

Line 1048: FROM gmd_recipes_b

1044: CURSOR Cur_get_recipe IS
1045: SELECT chld.recipe_id, mst.recipe_id master_recipe_id
1046: FROM gmd_recipes_b chld,
1047: (SELECT recipe_id, owner_organization_id, recipe_no, formula_id, routing_id
1048: FROM gmd_recipes_b
1049: WHERE recipe_type = 0 ) mst,
1050: Mtl_parameters org
1051: WHERE org.master_organization_id = mst.owner_organization_id
1052: AND chld.owner_organization_id = org.organization_id

Line 1067: p_table_name => 'GMD_RECIPES_B',

1063: GMA_COMMON_LOGGING.gma_migration_central_log (
1064: p_run_id => P_migration_run_id,
1065: p_log_level => FND_LOG.LEVEL_EVENT,
1066: p_message_token => 'GMA_MIGRATION_STARTED',
1067: p_table_name => 'GMD_RECIPES_B',
1068: p_context => 'GMD_RECIPE_TYPE',
1069: p_param1 => NULL,
1070: p_param2 => NULL,
1071: p_param3 => NULL,

Line 1081: UPDATE gmd_recipes_b

1077:
1078: /* Running the Migration */
1079:
1080: /* Select all the master organizations and update them to "General" recipe type */
1081: UPDATE gmd_recipes_b
1082: SET recipe_type = 0
1083: WHERE recipe_type IS NULL
1084: AND owner_organization_id IN ( SELECT DISTINCT owner_organization_id
1085: FROM gmd_recipes_b r

Line 1085: FROM gmd_recipes_b r

1081: UPDATE gmd_recipes_b
1082: SET recipe_type = 0
1083: WHERE recipe_type IS NULL
1084: AND owner_organization_id IN ( SELECT DISTINCT owner_organization_id
1085: FROM gmd_recipes_b r
1086: WHERE EXISTS (SELECT 1
1087: FROM mtl_parameters o
1088: WHERE o.master_organization_id = r.owner_organization_id));
1089:

Line 1091: UPDATE gmd_recipes_b

1087: FROM mtl_parameters o
1088: WHERE o.master_organization_id = r.owner_organization_id));
1089:
1090: /* Now lets update the rest of the recipe types as "Site" */
1091: UPDATE gmd_recipes_b
1092: SET recipe_type = 1
1093: WHERE recipe_type IS NULL;
1094:
1095: /* Now lets update the master recipe id for the recipes */

Line 1097: UPDATE gmd_recipes_b

1093: WHERE recipe_type IS NULL;
1094:
1095: /* Now lets update the master recipe id for the recipes */
1096: FOR l_recipe_rec IN Cur_get_recipe LOOP
1097: UPDATE gmd_recipes_b
1098: SET master_recipe_id = l_recipe_rec.master_recipe_id
1099: WHERE recipe_id = l_recipe_rec.recipe_id;
1100: END LOOP;
1101:

Line 1112: p_table_name => 'GMD_RECIPES_B',

1108: GMA_COMMON_LOGGING.gma_migration_central_log (
1109: p_run_id => P_migration_run_id,
1110: p_log_level => FND_LOG.LEVEL_EVENT,
1111: p_message_token => 'GMA_MIGRATION_COMPLETED',
1112: p_table_name => 'GMD_RECIPES_B',
1113: p_context => 'GMD_RECIPE_TYPE',
1114: p_param1 => NULL,
1115: p_param2 => NULL,
1116: p_param3 => NULL,

Line 1132: p_table_name => 'GMD_RECIPES_B',

1128: GMA_COMMON_LOGGING.gma_migration_central_log (
1129: p_run_id => P_migration_run_id,
1130: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1131: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1132: p_table_name => 'GMD_RECIPES_B',
1133: p_context => 'GMD_RECIPE_TYPE',
1134: p_param1 => NULL,
1135: p_param2 => NULL,
1136: p_param3 => NULL,

Line 1146: p_table_name => 'GMD_RECIPES_B',

1142: GMA_COMMON_LOGGING.gma_migration_central_log (
1143: p_run_id => P_migration_run_id,
1144: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1145: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1146: p_table_name => 'GMD_RECIPES_B',
1147: p_context => 'GMD_RECIPE_TYPE',
1148: p_param1 => NULL,
1149: p_param2 => NULL,
1150: p_param3 => NULL,