DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_PENDING_ITEM_STATUS

Line 1677: PROCEDURE C_MTL_PENDING_ITEM_STATUS (

1673: END LOOP;
1674: /* End Bug : 4466566 */
1675: END C_MTL_CROSS_REFERENCES;
1676:
1677: PROCEDURE C_MTL_PENDING_ITEM_STATUS (
1678: X_org_id IN NUMBER,
1679: X_master_org IN NUMBER,
1680: X_eng_item_id IN NUMBER,
1681: X_mfg_item_id IN NUMBER,

Line 1689: INSERT INTO MTL_PENDING_ITEM_STATUS(

1685: )
1686: IS
1687: BEGIN
1688:
1689: INSERT INTO MTL_PENDING_ITEM_STATUS(
1690: CREATED_BY,
1691: CREATION_DATE,
1692: EFFECTIVE_DATE,
1693: IMPLEMENTED_DATE,

Line 1721: FROM MTL_PENDING_ITEM_STATUS

1717: PROGRAM_ID,
1718: PROGRAM_UPDATE_DATE,
1719: REQUEST_ID,
1720: STATUS_CODE
1721: FROM MTL_PENDING_ITEM_STATUS
1722: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1723: AND ORGANIZATION_ID = X_org_id;
1724:
1725: EXCEPTION

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

1723: AND ORGANIZATION_ID = X_org_id;
1724:
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_PENDING_ITEM_STATUS',
1728: stmt_num => 1011,
1729: message_name => 'ENG_ENUBRT_ERROR',
1730: token => SQLERRM);
1731:

Line 1732: END C_MTL_PENDING_ITEM_STATUS;

1728: stmt_num => 1011,
1729: message_name => 'ENG_ENUBRT_ERROR',
1730: token => SQLERRM);
1731:
1732: END C_MTL_PENDING_ITEM_STATUS;
1733:
1734: PROCEDURE C_CST_STANDARD_COSTS (
1735: X_org_id IN NUMBER,
1736: X_master_org IN NUMBER,