DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1388: PROCEDURE C_MTL_ITEM_SUB_INVENTORIES (

1384: token => SQLERRM);
1385:
1386: END C_CST_ITEM_COST_DETAILS;
1387:
1388: PROCEDURE C_MTL_ITEM_SUB_INVENTORIES (
1389: X_org_id IN NUMBER,
1390: X_master_org IN NUMBER,
1391: X_eng_item_id IN NUMBER,
1392: X_mfg_item_id IN NUMBER,

Line 1400: INSERT INTO MTL_ITEM_SUB_INVENTORIES(

1396: )
1397: IS
1398: BEGIN
1399:
1400: INSERT INTO MTL_ITEM_SUB_INVENTORIES(
1401: ATTRIBUTE1,
1402: ATTRIBUTE10,
1403: ATTRIBUTE11,
1404: ATTRIBUTE12,

Line 1488: FROM MTL_ITEM_SUB_INVENTORIES

1484: SECONDARY_INVENTORY,
1485: SOURCE_ORGANIZATION_ID,
1486: SOURCE_SUBINVENTORY,
1487: SOURCE_TYPE
1488: FROM MTL_ITEM_SUB_INVENTORIES
1489: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1490: AND ORGANIZATION_ID = X_master_org;-- Bug:3264573 X_org_id;
1491:
1492: EXCEPTION

Line 1494: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_SUB_INVENTORIES',

1490: AND ORGANIZATION_ID = X_master_org;-- Bug:3264573 X_org_id;
1491:
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_SUB_INVENTORIES',
1495: stmt_num => 1008,
1496: message_name => 'ENG_ENUBRT_ERROR',
1497: token => SQLERRM);
1498:

Line 1499: END C_MTL_ITEM_SUB_INVENTORIES;

1495: stmt_num => 1008,
1496: message_name => 'ENG_ENUBRT_ERROR',
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,