[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,
1488: msro.NET_PLANNING_PERCENT,
1489: msro.SETUP_DURATION,
1490: msro.TEAR_DOWN_DURATION,
1491: msro.UOM_CODE,
1492: msro.STANDARD_OPERATION_CODE,
1493: msro.STEP_QUANTITY,
1494: msro.STEP_QUANTITY_UOM,
1495: msro.DELETED_FLAG,
1496: msro.SR_INSTANCE_ID,
1563: ||' NET_PLANNING_PERCENT, '
1564: ||' SETUP_DURATION, '
1565: ||' TEAR_DOWN_DURATION, '
1566: ||' UOM_CODE, '
1567: ||' STANDARD_OPERATION_CODE, '
1568: ||' STEP_QUANTITY, '
1569: ||' STEP_QUANTITY_UOM, '
1570: ||' SR_INSTANCE_ID, '
1571: ||' ORGANIZATION_ID, '
1596: ||' msro.NET_PLANNING_PERCENT, '
1597: ||' msro.SETUP_DURATION, '
1598: ||' msro.TEAR_DOWN_DURATION, '
1599: ||' msro.UOM_CODE, '
1600: ||' msro.STANDARD_OPERATION_CODE, '
1601: ||' msro.STEP_QUANTITY, '
1602: ||' msro.STEP_QUANTITY_UOM, '
1603: ||' msro.SR_INSTANCE_ID, '
1604: ||' msro.ORGANIZATION_ID, '
1673: ||' NET_PLANNING_PERCENT, '
1674: ||' SETUP_DURATION, '
1675: ||' TEAR_DOWN_DURATION, '
1676: ||' UOM_CODE, '
1677: ||' STANDARD_OPERATION_CODE, '
1678: ||' STEP_QUANTITY, '
1679: ||' STEP_QUANTITY_UOM, '
1680: ||' SR_INSTANCE_ID, '
1681: ||' ORGANIZATION_ID, '
1706: ||' :NET_PLANNING_PERCENT, '
1707: ||' :SETUP_DURATION, '
1708: ||' :TEAR_DOWN_DURATION, '
1709: ||' :UOM_CODE, '
1710: ||' :STANDARD_OPERATION_CODE, '
1711: ||' :STEP_QUANTITY, '
1712: ||' :STEP_QUANTITY_UOM, '
1713: ||' :SR_INSTANCE_ID, '
1714: ||' :ORGANIZATION_ID, '
1761: NET_PLANNING_PERCENT= c_rec.NET_PLANNING_PERCENT,
1762: SETUP_DURATION= c_rec.SETUP_DURATION,
1763: TEAR_DOWN_DURATION= c_rec.TEAR_DOWN_DURATION,
1764: UOM_CODE= c_rec.UOM_CODE,
1765: STANDARD_OPERATION_CODE= c_rec.STANDARD_OPERATION_CODE,
1766: STEP_QUANTITY= c_rec.STEP_QUANTITY,
1767: STEP_QUANTITY_UOM= c_rec.STEP_QUANTITY_UOM,
1768: ORGANIZATION_ID = c_rec.ORGANIZATION_ID,
1769: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1797: c_rec.NET_PLANNING_PERCENT,
1798: c_rec.SETUP_DURATION,
1799: c_rec.TEAR_DOWN_DURATION,
1800: c_rec.UOM_CODE,
1801: c_rec.STANDARD_OPERATION_CODE,
1802: c_rec.STEP_QUANTITY,
1803: c_rec.STEP_QUANTITY_UOM,
1804: c_rec.SR_INSTANCE_ID,
1805: c_rec.ORGANIZATION_ID,