DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_SECONDARY_LOCATORS

Line 1516: PROCEDURE C_MTL_SECONDARY_LOCATORS (

1512: token => SQLERRM);
1513:
1514: END C_MTL_ITEM_SUB_INVENTORIES;
1515:
1516: PROCEDURE C_MTL_SECONDARY_LOCATORS (
1517: X_org_id IN NUMBER,
1518: X_master_org IN NUMBER,
1519: X_eng_item_id IN NUMBER,
1520: X_mfg_item_id IN NUMBER,

Line 1528: INSERT INTO MTL_SECONDARY_LOCATORS(

1524: )
1525: IS
1526: BEGIN
1527:
1528: INSERT INTO MTL_SECONDARY_LOCATORS(
1529: CREATED_BY,
1530: CREATION_DATE,
1531: INVENTORY_ITEM_ID,
1532: LAST_UPDATED_BY,

Line 1560: FROM MTL_SECONDARY_LOCATORS

1556: SECONDARY_LOCATOR,-- Bug:3264573 All the new missing columns added
1557: SUBINVENTORY_CODE,
1558: STATUS_ID,
1559: MAXIMUM_QUANTITY
1560: FROM MTL_SECONDARY_LOCATORS
1561: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1562: AND ORGANIZATION_ID = X_master_org; --Bug:3264573 X_org_id;
1563:
1564: EXCEPTION

Line 1566: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SECONDARY_LOCATORS',

1562: AND ORGANIZATION_ID = X_master_org; --Bug:3264573 X_org_id;
1563:
1564: EXCEPTION
1565: WHEN OTHERS THEN
1566: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SECONDARY_LOCATORS',
1567: stmt_num => 1009,
1568: message_name => 'ENG_ENUBRT_ERROR',
1569: token => SQLERRM);
1570:

Line 1571: END C_MTL_SECONDARY_LOCATORS;

1567: stmt_num => 1009,
1568: message_name => 'ENG_ENUBRT_ERROR',
1569: token => SQLERRM);
1570:
1571: END C_MTL_SECONDARY_LOCATORS;
1572:
1573: PROCEDURE C_MTL_CROSS_REFERENCES (
1574: X_org_id IN NUMBER,
1575: X_master_org IN NUMBER,