1730: token => SQLERRM);
1731:
1732: END C_MTL_PENDING_ITEM_STATUS;
1733:
1734: PROCEDURE C_CST_STANDARD_COSTS (
1735: X_org_id IN NUMBER,
1736: X_master_org IN NUMBER,
1737: X_eng_item_id IN NUMBER,
1738: X_mfg_item_id IN NUMBER,
1742: )
1743: IS
1744: BEGIN
1745:
1746: INSERT INTO CST_STANDARD_COSTS(
1747: COST_UPDATE_ID,
1748: CREATED_BY,
1749: CREATION_DATE,
1750: INTRANSIT_ADJUSTMENT_QUANTITY,
1760: PROGRAM_APPLICATION_ID,
1761: PROGRAM_ID,
1762: PROGRAM_UPDATE_DATE,
1763: REQUEST_ID,
1764: STANDARD_COST,
1765: STANDARD_COST_REVISION_DATE,
1766: WIP_ADJUSTMENT_QUANTITY,
1767: WIP_ADJUSTMENT_VALUE)
1768: SELECT
1761: PROGRAM_ID,
1762: PROGRAM_UPDATE_DATE,
1763: REQUEST_ID,
1764: STANDARD_COST,
1765: STANDARD_COST_REVISION_DATE,
1766: WIP_ADJUSTMENT_QUANTITY,
1767: WIP_ADJUSTMENT_VALUE)
1768: SELECT
1769: COST_UPDATE_ID,
1782: PROGRAM_APPLICATION_ID,
1783: PROGRAM_ID,
1784: PROGRAM_UPDATE_DATE,
1785: REQUEST_ID,
1786: STANDARD_COST,
1787: STANDARD_COST_REVISION_DATE,
1788: WIP_ADJUSTMENT_QUANTITY,
1789: WIP_ADJUSTMENT_VALUE
1790: FROM CST_STANDARD_COSTS
1783: PROGRAM_ID,
1784: PROGRAM_UPDATE_DATE,
1785: REQUEST_ID,
1786: STANDARD_COST,
1787: STANDARD_COST_REVISION_DATE,
1788: WIP_ADJUSTMENT_QUANTITY,
1789: WIP_ADJUSTMENT_VALUE
1790: FROM CST_STANDARD_COSTS
1791: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1786: STANDARD_COST,
1787: STANDARD_COST_REVISION_DATE,
1788: WIP_ADJUSTMENT_QUANTITY,
1789: WIP_ADJUSTMENT_VALUE
1790: FROM CST_STANDARD_COSTS
1791: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1792: AND ORGANIZATION_ID = X_org_id;
1793:
1794: EXCEPTION
1792: AND ORGANIZATION_ID = X_org_id;
1793:
1794: EXCEPTION
1795: WHEN OTHERS THEN
1796: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_STANDARD_COSTS',
1797: stmt_num => 1012,
1798: message_name => 'ENG_ENUBRT_ERROR',
1799: token => SQLERRM);
1800:
1797: stmt_num => 1012,
1798: message_name => 'ENG_ENUBRT_ERROR',
1799: token => SQLERRM);
1800:
1801: END C_CST_STANDARD_COSTS;
1802:
1803: PROCEDURE C_CST_ELEMENTAL_COSTS (
1804: X_org_id IN NUMBER,
1805: X_master_org IN NUMBER,
1825: PROGRAM_APPLICATION_ID,
1826: PROGRAM_ID,
1827: PROGRAM_UPDATE_DATE,
1828: REQUEST_ID,
1829: STANDARD_COST)
1830: SELECT
1831: COST_ELEMENT_ID,
1832: COST_UPDATE_ID,
1833: to_number(Fnd_Profile.Value('USER_ID')),
1840: PROGRAM_APPLICATION_ID,
1841: PROGRAM_ID,
1842: PROGRAM_UPDATE_DATE,
1843: REQUEST_ID,
1844: STANDARD_COST
1845: FROM CST_ELEMENTAL_COSTS
1846: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1847: AND ORGANIZATION_ID = X_org_id;
1848: