[Home] [Help]
88:
89: /* Cursor to get data based on recipe ID and input and output qty. */
90: CURSOR get_val IS
91: SELECT v.*
92: FROM gmd_recipe_validity_rules v, gmd_recipes r, gmd_status s
93: WHERE v.recipe_id = r.recipe_id
94: AND v.validity_rule_status = s.status_code
95: AND v.recipe_id = NVL(P_RECIPE_ID, v.recipe_id)
96: AND ( r.recipe_no = NVL(p_recipe_no, r.recipe_no) AND r.recipe_version = nvl(p_recipe_version, r.recipe_version) )
119:
120: /* Cursor to get data based on item. */
121: CURSOR get_val_item(l_quantity NUMBER) IS
122: SELECT v.*
123: FROM gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_status_b s,
124: mtl_system_items_kfv I, fm_matl_dtl d
125: WHERE v.recipe_id = r.recipe_id
126: AND v.validity_rule_status = s.status_code
127: AND i.inventory_item_id = v.inventory_item_id
1251:
1252: --Cursor to get data based on recipe ID
1253: CURSOR Get_val_recipe IS
1254: SELECT v.*
1255: FROM Gmd_recipe_validity_rules V, Gmd_recipes R, Gmd_status S
1256: WHERE V.Recipe_id = R.Recipe_id
1257: AND V.Validity_rule_status = S.Status_code
1258: AND V.Recipe_id = NVL (P_recipe_id, V.Recipe_id)
1259: AND v.delete_mark = 0
1262: --Cursor to get data based on item.
1263:
1264: CURSOR Get_val_item IS
1265: SELECT V.*
1266: FROM Gmd_recipe_validity_rules V,
1267: Gmd_recipes R,
1268: Gmd_status S
1269: WHERE V.Recipe_id = R.Recipe_id
1270: AND V.Validity_rule_status = S.Status_code
1642: --
1643: -- HISTORY
1644: -- Thomas Daniel 16-Nov-2005 Created.
1645: --===================================================================== */
1646: PROCEDURE insert_val_temp_tbl (p_val_rec IN GMD_RECIPE_VALIDITY_RULES%ROWTYPE
1647: ,p_unit_cost IN NUMBER
1648: ,p_total_cost IN NUMBER) IS
1649: BEGIN
1650: INSERT INTO GMD_VAL_RULE_GTMP(