DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1403: PROCEDURE C_MTL_ITEM_SUB_INVENTORIES (

1399: token => SQLERRM);
1400:
1401: END C_CST_ITEM_COST_DETAILS;
1402:
1403: PROCEDURE C_MTL_ITEM_SUB_INVENTORIES (
1404: X_org_id IN NUMBER,
1405: X_master_org IN NUMBER,
1406: X_eng_item_id IN NUMBER,
1407: X_mfg_item_id IN NUMBER,

Line 1415: INSERT INTO MTL_ITEM_SUB_INVENTORIES(

1411: )
1412: IS
1413: BEGIN
1414:
1415: INSERT INTO MTL_ITEM_SUB_INVENTORIES(
1416: ATTRIBUTE1,
1417: ATTRIBUTE10,
1418: ATTRIBUTE11,
1419: ATTRIBUTE12,

Line 1503: FROM MTL_ITEM_SUB_INVENTORIES

1499: SECONDARY_INVENTORY,
1500: SOURCE_ORGANIZATION_ID,
1501: SOURCE_SUBINVENTORY,
1502: SOURCE_TYPE
1503: FROM MTL_ITEM_SUB_INVENTORIES
1504: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1505: AND ORGANIZATION_ID = X_master_org;-- Bug:3264573 X_org_id;
1506:
1507: EXCEPTION

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

1505: AND ORGANIZATION_ID = X_master_org;-- Bug:3264573 X_org_id;
1506:
1507: EXCEPTION
1508: WHEN OTHERS THEN
1509: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_SUB_INVENTORIES',
1510: stmt_num => 1008,
1511: message_name => 'ENG_ENUBRT_ERROR',
1512: token => SQLERRM);
1513:

Line 1514: END C_MTL_ITEM_SUB_INVENTORIES;

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