1792: -- Product. Calculates Machine Time, Labor Time, Total Time
1793: -- and Process Volume for each of the 5 Processes/Line Ops
1794: -- passed to this procedure.
1795: --
1796: -- Insert these values into the table BOM_MIXED_MODEL_MAP_CELLS.
1797: -- REQUIRES : err_text out buffer to return error message
1798: -- MODIFIES : BOM_MIXED_MODEL_MAP_CELLS
1799: --
1800: -- ==========================================================================
1794: -- passed to this procedure.
1795: --
1796: -- Insert these values into the table BOM_MIXED_MODEL_MAP_CELLS.
1797: -- REQUIRES : err_text out buffer to return error message
1798: -- MODIFIES : BOM_MIXED_MODEL_MAP_CELLS
1799: --
1800: -- ==========================================================================
1801:
1802: PROCEDURE GetCells (
2424: -- above is my code***************************************
2425: <
2426: l_stmt_num := 68;
2427: IF(l_op_code IS NOT NULL) THEN
2428: INSERT INTO bom_mixed_model_map_cells
2429: (MIXED_MODEL_MAP_ID,
2430: GROUP_NUMBER,
2431: SEQUENCE_ID,
2432: PRODUCT_ITEM_ID,
2453: sysdate,
2454: p_user_id,
2455: sysdate);
2456: ELSE
2457: INSERT INTO bom_mixed_model_map_cells
2458: (MIXED_MODEL_MAP_ID,
2459: GROUP_NUMBER,
2460: SEQUENCE_ID,
2461: PRODUCT_ITEM_ID,