DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_PENDING_ITEM_STATUS

Line 1662: PROCEDURE C_MTL_PENDING_ITEM_STATUS (

1658: END LOOP;
1659: /* End Bug : 4466566 */
1660: END C_MTL_CROSS_REFERENCES;
1661:
1662: PROCEDURE C_MTL_PENDING_ITEM_STATUS (
1663: X_org_id IN NUMBER,
1664: X_master_org IN NUMBER,
1665: X_eng_item_id IN NUMBER,
1666: X_mfg_item_id IN NUMBER,

Line 1674: INSERT INTO MTL_PENDING_ITEM_STATUS(

1670: )
1671: IS
1672: BEGIN
1673:
1674: INSERT INTO MTL_PENDING_ITEM_STATUS(
1675: CREATED_BY,
1676: CREATION_DATE,
1677: EFFECTIVE_DATE,
1678: IMPLEMENTED_DATE,

Line 1706: FROM MTL_PENDING_ITEM_STATUS

1702: PROGRAM_ID,
1703: PROGRAM_UPDATE_DATE,
1704: REQUEST_ID,
1705: STATUS_CODE
1706: FROM MTL_PENDING_ITEM_STATUS
1707: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1708: AND ORGANIZATION_ID = X_org_id;
1709:
1710: EXCEPTION

Line 1712: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_PENDING_ITEM_STATUS',

1708: AND ORGANIZATION_ID = X_org_id;
1709:
1710: EXCEPTION
1711: WHEN OTHERS THEN
1712: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_PENDING_ITEM_STATUS',
1713: stmt_num => 1011,
1714: message_name => 'ENG_ENUBRT_ERROR',
1715: token => SQLERRM);
1716:

Line 1717: END C_MTL_PENDING_ITEM_STATUS;

1713: stmt_num => 1011,
1714: message_name => 'ENG_ENUBRT_ERROR',
1715: token => SQLERRM);
1716:
1717: END C_MTL_PENDING_ITEM_STATUS;
1718:
1719: PROCEDURE C_CST_STANDARD_COSTS (
1720: X_org_id IN NUMBER,
1721: X_master_org IN NUMBER,