APPS.GMD_RECIPE_MIGRATION dependencies on GMD_RECIPE_VAL

Line 157: FROM gmd_recipe_validity_rules;

153: CURSOR get_invalid_validity_rules
154: IS
155: SELECT recipe_validity_rule_id,
156: item_id
157: FROM gmd_recipe_validity_rules;
158:
159: /* Check if the item id exists in ic_item_mst table */
160: CURSOR get_valid_item ( v_item_id NUMBER )
161: IS

Line 248: gmd_recipe_val.recipe_name (

244: /* ================================ */
245: /* Based on Recipe_no and Recipe_version check if a recipe */
246: /* already exists in the database */
247: /* ================================= */
248: gmd_recipe_val.recipe_name (
249: p_api_version => 1.0,
250: p_init_msg_list => fnd_api.g_false,
251: p_commit => fnd_api.g_false,
252: p_recipe_no => l_recipe_no,

Line 390: gmd_recipe_val.recipe_name (

386: /* ================================ */
387: /* Based on Recipe_no and Recipe_version check if a recipe */
388: /* already exists in the database */
389: /* ================================= */
390: gmd_recipe_val.recipe_name (
391: p_api_version => 1.0,
392: p_init_msg_list => fnd_api.g_false,
393: p_commit => fnd_api.g_false,
394: p_recipe_no => l_recipe_no,

Line 623: /* Migrate data into gmd_recipe_validity_rules table */

619: CLOSE check_recipe_cust_exists;
620: END LOOP; /* for recipe customers */
621:
622: /* Step 4 : */
623: /* Migrate data into gmd_recipe_validity_rules table */
624: /* All effectvities are inserted into the validity rules table */
625:
626: INSERT INTO gmd_recipe_validity_rules
627: ( recipe_validity_rule_id,

Line 626: INSERT INTO gmd_recipe_validity_rules

622: /* Step 4 : */
623: /* Migrate data into gmd_recipe_validity_rules table */
624: /* All effectvities are inserted into the validity rules table */
625:
626: INSERT INTO gmd_recipe_validity_rules
627: ( recipe_validity_rule_id,
628: recipe_id,
629: orgn_code,
630: item_id,

Line 673: FROM gmd_recipe_validity_rules

669: delete_mark,
670: gmdfmval_pub.gmd_effectivity_locked_status ( fmeff_id )
671: FROM gmd_recipe_eff_assoc
672: WHERE NOT EXISTS ( SELECT 1
673: FROM gmd_recipe_validity_rules
674: WHERE recipe_validity_rule_id = fmeff_id );
675:
676: /* Step 5 */
677: /* Migrate data into the Recipe Materials Step table from

Line 758: UPDATE gmd_recipe_validity_rules

754: FROM fm_form_mst_b
755: WHERE formula_Status = '1000');
756:
757: /* Obsolete Vrs that are based on obsoleted Recipes */
758: UPDATE gmd_recipe_validity_rules
759: SET validity_rule_status = '1000'
760: WHERE recipe_id IN (SELECT recipe_id
761: FROM gmd_recipes_b
762: WHERE recipe_Status = '1000');

Line 853: /* Delete duplicate VR id from gmd_recipe_validity_rule table */

849: SAVEPOINT recipe_migration;
850: l_counter := 0;
851: END IF;
852:
853: /* Delete duplicate VR id from gmd_recipe_validity_rule table */
854: DELETE
855: FROM gmd_recipe_validity_rules
856: WHERE recipe_validity_rule_id = update_eff_rec.fmeff_id;
857:

Line 855: FROM gmd_recipe_validity_rules

851: END IF;
852:
853: /* Delete duplicate VR id from gmd_recipe_validity_rule table */
854: DELETE
855: FROM gmd_recipe_validity_rules
856: WHERE recipe_validity_rule_id = update_eff_rec.fmeff_id;
857:
858: insert_message (p_source_table => 'FM_FORM_EFF'
859: ,p_target_table => 'GMD_RECIPE_VALIDITY_RULES'

Line 859: ,p_target_table => 'GMD_RECIPE_VALIDITY_RULES'

855: FROM gmd_recipe_validity_rules
856: WHERE recipe_validity_rule_id = update_eff_rec.fmeff_id;
857:
858: insert_message (p_source_table => 'FM_FORM_EFF'
859: ,p_target_table => 'GMD_RECIPE_VALIDITY_RULES'
860: ,p_source_id => update_eff_rec.fmeff_id
861: ,p_target_id => l_fmeff_id
862: ,p_message => 'Deleted effectivity:'||update_eff_rec.fmeff_id||' Updated with effectivity:'||l_fmeff_id
863: ,p_error_type => 'E');

Line 933: gmd_recipe_validity_rules grv

929: recipe_validity_rule_id rule_id, grv.min_qty, grv.max_qty
930: FROM fm_form_mst_b ffm,
931: fm_matl_dtl fmd,
932: gmd_recipes_b gr,
933: gmd_recipe_validity_rules grv
934: WHERE ffm.formula_id = fmd.formula_id
935: AND ffm.formula_id = gr.formula_id
936: AND grv.orgn_code = ffm.orgn_code
937: AND grv.recipe_id = gr.recipe_id

Line 950: UPDATE gmd_recipe_validity_rules

946: BEGIN
947: FOR x_rec IN fixed_scaling LOOP
948: /* Update only those records whose quantities are incorrect, depending upon the UOM's */
949: IF x_rec.base_um = x_rec.conv_um THEN
950: UPDATE gmd_recipe_validity_rules
951: SET max_qty = x_rec.qty,
952: min_qty = x_rec.qty,
953: std_qty = x_rec.qty
954: WHERE recipe_validity_rule_id = x_rec.rule_id;

Line 971: UPDATE gmd_recipe_validity_rules

967: IF ( x_rec.min_qty <> x_out_qty
968: OR x_rec.max_qty <> x_out_qty
969: OR x_rec.std_qty <> x_out_qty
970: ) THEN
971: UPDATE gmd_recipe_validity_rules
972: SET max_qty = x_out_qty,
973: min_qty = x_out_qty,
974: std_qty = x_out_qty
975: WHERE recipe_validity_rule_id = x_rec.rule_id;