[Home] [Help]
19: IS
20: CURSOR std_op_res IS
21: SELECT
22: std_op_res.SR_INSTANCE_ID,
23: std_op_res.STANDARD_OPERATION_ID,
24: std_op_res.RESOURCE_ID,
25: std_op_res.OPERATION_CODE,
26: std_op_res.ORGANIZATION_ID,
27: std_op_res.DEPARTMENT_ID,
56: BEGIN
57: INSERT INTO MSC_STD_OP_RESOURCES
58: ( PLAN_ID,
59: SR_INSTANCE_ID,
60: STANDARD_OPERATION_ID ,
61: RESOURCE_ID,
62: OPERATION_CODE,
63: ORGANIZATION_ID,
64: DEPARTMENT_ID,
76: CREATED_BY)
77: VALUES
78: ( -1,
79: c_rec.SR_INSTANCE_ID,
80: c_rec.STANDARD_OPERATION_ID ,
81: c_rec.RESOURCE_ID,
82: c_rec.OPERATION_CODE,
83: c_rec.ORGANIZATION_ID,
84: c_rec.DEPARTMENT_ID,
1482: msro.NET_PLANNING_PERCENT,
1483: msro.SETUP_DURATION,
1484: msro.TEAR_DOWN_DURATION,
1485: msro.UOM_CODE,
1486: msro.STANDARD_OPERATION_CODE,
1487: msro.STEP_QUANTITY,
1488: msro.STEP_QUANTITY_UOM,
1489: msro.DELETED_FLAG,
1490: msro.SR_INSTANCE_ID,
1557: ||' NET_PLANNING_PERCENT, '
1558: ||' SETUP_DURATION, '
1559: ||' TEAR_DOWN_DURATION, '
1560: ||' UOM_CODE, '
1561: ||' STANDARD_OPERATION_CODE, '
1562: ||' STEP_QUANTITY, '
1563: ||' STEP_QUANTITY_UOM, '
1564: ||' SR_INSTANCE_ID, '
1565: ||' ORGANIZATION_ID, '
1590: ||' msro.NET_PLANNING_PERCENT, '
1591: ||' msro.SETUP_DURATION, '
1592: ||' msro.TEAR_DOWN_DURATION, '
1593: ||' msro.UOM_CODE, '
1594: ||' msro.STANDARD_OPERATION_CODE, '
1595: ||' msro.STEP_QUANTITY, '
1596: ||' msro.STEP_QUANTITY_UOM, '
1597: ||' msro.SR_INSTANCE_ID, '
1598: ||' msro.ORGANIZATION_ID, '
1667: ||' NET_PLANNING_PERCENT, '
1668: ||' SETUP_DURATION, '
1669: ||' TEAR_DOWN_DURATION, '
1670: ||' UOM_CODE, '
1671: ||' STANDARD_OPERATION_CODE, '
1672: ||' STEP_QUANTITY, '
1673: ||' STEP_QUANTITY_UOM, '
1674: ||' SR_INSTANCE_ID, '
1675: ||' ORGANIZATION_ID, '
1700: ||' :NET_PLANNING_PERCENT, '
1701: ||' :SETUP_DURATION, '
1702: ||' :TEAR_DOWN_DURATION, '
1703: ||' :UOM_CODE, '
1704: ||' :STANDARD_OPERATION_CODE, '
1705: ||' :STEP_QUANTITY, '
1706: ||' :STEP_QUANTITY_UOM, '
1707: ||' :SR_INSTANCE_ID, '
1708: ||' :ORGANIZATION_ID, '
1755: NET_PLANNING_PERCENT= c_rec.NET_PLANNING_PERCENT,
1756: SETUP_DURATION= c_rec.SETUP_DURATION,
1757: TEAR_DOWN_DURATION= c_rec.TEAR_DOWN_DURATION,
1758: UOM_CODE= c_rec.UOM_CODE,
1759: STANDARD_OPERATION_CODE= c_rec.STANDARD_OPERATION_CODE,
1760: STEP_QUANTITY= c_rec.STEP_QUANTITY,
1761: STEP_QUANTITY_UOM= c_rec.STEP_QUANTITY_UOM,
1762: ORGANIZATION_ID = c_rec.ORGANIZATION_ID,
1763: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1791: c_rec.NET_PLANNING_PERCENT,
1792: c_rec.SETUP_DURATION,
1793: c_rec.TEAR_DOWN_DURATION,
1794: c_rec.UOM_CODE,
1795: c_rec.STANDARD_OPERATION_CODE,
1796: c_rec.STEP_QUANTITY,
1797: c_rec.STEP_QUANTITY_UOM,
1798: c_rec.SR_INSTANCE_ID,
1799: c_rec.ORGANIZATION_ID,