DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_SECONDARY_LOCATORS

Line 1501: PROCEDURE C_MTL_SECONDARY_LOCATORS (

1497: token => SQLERRM);
1498:
1499: END C_MTL_ITEM_SUB_INVENTORIES;
1500:
1501: PROCEDURE C_MTL_SECONDARY_LOCATORS (
1502: X_org_id IN NUMBER,
1503: X_master_org IN NUMBER,
1504: X_eng_item_id IN NUMBER,
1505: X_mfg_item_id IN NUMBER,

Line 1513: INSERT INTO MTL_SECONDARY_LOCATORS(

1509: )
1510: IS
1511: BEGIN
1512:
1513: INSERT INTO MTL_SECONDARY_LOCATORS(
1514: CREATED_BY,
1515: CREATION_DATE,
1516: INVENTORY_ITEM_ID,
1517: LAST_UPDATED_BY,

Line 1545: FROM MTL_SECONDARY_LOCATORS

1541: SECONDARY_LOCATOR,-- Bug:3264573 All the new missing columns added
1542: SUBINVENTORY_CODE,
1543: STATUS_ID,
1544: MAXIMUM_QUANTITY
1545: FROM MTL_SECONDARY_LOCATORS
1546: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1547: AND ORGANIZATION_ID = X_master_org; --Bug:3264573 X_org_id;
1548:
1549: EXCEPTION

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

1547: AND ORGANIZATION_ID = X_master_org; --Bug:3264573 X_org_id;
1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SECONDARY_LOCATORS',
1552: stmt_num => 1009,
1553: message_name => 'ENG_ENUBRT_ERROR',
1554: token => SQLERRM);
1555:

Line 1556: END C_MTL_SECONDARY_LOCATORS;

1552: stmt_num => 1009,
1553: message_name => 'ENG_ENUBRT_ERROR',
1554: token => SQLERRM);
1555:
1556: END C_MTL_SECONDARY_LOCATORS;
1557:
1558: PROCEDURE C_MTL_CROSS_REFERENCES (
1559: X_org_id IN NUMBER,
1560: X_master_org IN NUMBER,