[Home] [Help]
286: | PROCEDURE NAME
287: | Update_Recipe_Routing_step_Row
288: |
289: | DESCRIPTION
290: | Update a row in GMD_RECIPE_ROUTING_STEPS
291: |
292: | INPUT PARAMETERS
293: | p_recipe_id NUMBER
294: | p_routingstep_id NUMBER
340: l_text_code := p_text_code;
341: END IF;
342:
343: UPDATE
344: GMD_RECIPE_ROUTING_STEPS
345: SET
346: STEP_QTY = p_step_qty,
347: TEXT_CODE = l_text_code,
348: LAST_UPDATED_BY = p_user_id,
377: | PROCEDURE NAME
378: | Create_Recipe_Routing_step_Row
379: |
380: | DESCRIPTION
381: | Create a row in GMD_RECIPE_ROUTING_STEPS
382: |
383: | INPUT PARAMETERS
384: | p_recipe_id NUMBER
385: | p_routingstep_id NUMBER
420:
421: x_return_code := 'S';
422: x_error_msg := '';
423:
424: INSERT INTO gmd_recipe_routing_steps
425: (RECIPE_ID
426: ,ROUTINGSTEP_ID
427: ,STEP_QTY
428: ,CREATED_BY
801:
802: BEGIN
803:
804: UPDATE
805: GMD_RECIPE_ROUTING_STEPS
806: SET
807: STEP_QTY = l_step_tbl(p_ind).step_qty,
808: MASS_QTY = l_step_tbl(p_ind).step_mass_qty,
809: VOLUME_QTY = l_step_tbl(p_ind).step_vol_qty
813:
814:
815: IF SQL%NOTFOUND THEN
816:
817: INSERT INTO gmd_recipe_routing_steps
818: (RECIPE_ID
819: ,ROUTINGSTEP_ID
820: ,STEP_QTY
821: ,CREATED_BY
1375:
1376: CLOSE Get_Step_Id;
1377:
1378: UPDATE
1379: gmd_recipe_routing_steps
1380: SET
1381: STEP_QTY = l_step_qty,
1382: LAST_UPDATED_BY = p_user_id,
1383: LAST_UPDATE_DATE = p_last_update_date,
1397: EXCEPTION
1398:
1399: WHEN NO_DATA_FOUND THEN
1400:
1401: INSERT INTO gmd_recipe_routing_steps
1402: (RECIPE_ID
1403: ,ROUTINGSTEP_ID
1404: ,STEP_QTY
1405: ,CREATED_BY
1462: | PROCEDURE NAME
1463: | Delete_Recipe_Step_Quantities
1464: |
1465: | DESCRIPTION
1466: | Delete all rows in GMD_RECIPE_ROUTING_STEPS
1467: |
1468: | INPUT PARAMETERS
1469: | p_recipe_id NUMBER
1470: |
1489: x_error_msg := '';
1490:
1491:
1492: DELETE FROM
1493: GMD_RECIPE_ROUTING_STEPS
1494: WHERE
1495: recipe_id = p_recipe_id;
1496:
1497:
1809: AND b.routing_id = l_recipe_rec.routing_id;
1810:
1811: CURSOR Get_Old_Stp IS
1812: SELECT a.routingstep_id
1813: FROM gmd_recipe_routing_steps a, fm_rout_dtl b
1814: WHERE a.recipe_id = p_recipe_id
1815: AND a.routingstep_id = b.routingstep_id
1816: AND b.routing_id = l_recipe_rec.routing_id;
1817:
1963:
1964: --- Delete old rows in recipe step table
1965: FOR old_step IN Get_Old_Stp LOOP
1966:
1967: DELETE gmd_recipe_routing_steps
1968: WHERE recipe_id = p_recipe_id AND
1969: routingstep_id = old_step.routingstep_id;
1970:
1971: END LOOP;
3241: WHERE recipe_id = p_copy_from_recipe_id;
3242:
3243: CURSOR Cur_get_rcp_stp IS
3244: SELECT *
3245: FROM gmd_recipe_routing_steps
3246: WHERE recipe_id = p_copy_from_recipe_id;
3247:
3248: CURSOR Cur_get_rcp_cust IS
3249: SELECT *
4390: ---
4391: l_txt_ind := 1;
4392:
4393: IF NOT l_copy_recipe THEN
4394: DELETE gmd_recipe_routing_steps WHERE recipe_id = p_copy_from_recipe_id;
4395: END IF;
4396:
4397: FOR i IN 1..l_rcp_stp_tbl.count LOOP
4398:
4406: l_text_code := l_rcp_stp_tbl(i).text_code;
4407: DELETE fm_text_tbl WHERE text_code = l_text_code;
4408: END IF;
4409:
4410: l_table_lnk := 'gmd_recipe_routing_steps' || '|' || x_recipe_id ||
4411: '|' || l_rcp_stp_tbl(i).routingstep_id;
4412:
4413: WHILE (l_txt_ind <= l_rcp_stp_text_tbl.COUNT AND
4414: l_rcp_stp_text_tbl(l_txt_ind).text_code =
4445: ---
4446: l_rcp_stp_tbl(i).recipe_id := x_recipe_id;
4447: l_rcp_stp_tbl(i).text_code := l_text_code;
4448:
4449: INSERT INTO gmd_recipe_routing_steps
4450: (recipe_id,
4451: routingstep_id,
4452: step_qty,
4453: created_by,