[Home] [Help]
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,
1806: X_eng_item_id IN NUMBER,
1807: X_mfg_item_id IN NUMBER,
1811: )
1812: IS
1813: BEGIN
1814:
1815: INSERT INTO CST_ELEMENTAL_COSTS(
1816: COST_ELEMENT_ID,
1817: COST_UPDATE_ID,
1818: CREATED_BY,
1819: CREATION_DATE,
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:
1849: EXCEPTION
1847: AND ORGANIZATION_ID = X_org_id;
1848:
1849: EXCEPTION
1850: WHEN OTHERS THEN
1851: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_ELEMENTAL_COSTS',
1852: stmt_num => 1013,
1853: message_name => 'ENG_ENUBRT_ERROR',
1854: token => SQLERRM);
1855:
1852: stmt_num => 1013,
1853: message_name => 'ENG_ENUBRT_ERROR',
1854: token => SQLERRM);
1855:
1856: END C_CST_ELEMENTAL_COSTS;
1857:
1858: END ENG_COPY_TABLE_ROWS_PKG;
1859: