APPS.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on MTL_INTERFACE_ERRORS

Line 803: DELETE mtl_interface_errors

799: IF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ALL THEN
800: --
801: -- delete all lines
802: --
803: DELETE mtl_interface_errors
804: WHERE table_name = G_ERROR_TABLE_NAME
805: AND transaction_id IN
806: (SELECT transaction_id
807: FROM ego_item_people_intf

Line 819: DELETE mtl_interface_errors

815: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN
816: --
817: -- delete all error lines
818: --
819: DELETE mtl_interface_errors
820: WHERE table_name = G_ERROR_TABLE_NAME
821: AND transaction_id IN
822: (SELECT transaction_id
823: FROM ego_item_people_intf

Line 1650: -- Errors are populated in MTL_INTERFACE_ERRORS

1646: -- API name : Load Interfance Lines
1647: -- TYPE : Public (called by SQL Loader)
1648: -- Pre-reqs : None
1649: -- FUNCTION : Process and Load interfance lines into FND_GRANTS.
1650: -- Errors are populated in MTL_INTERFACE_ERRORS
1651: BEGIN
1652: IF G_CURR_DATASET_ID = -1 THEN
1653: SELECT EGO_IPI_DATASET_ID_S.NEXTVAL
1654: INTO G_CURR_DATASET_ID

Line 1684: -- Errors are populated in MTL_INTERFACE_ERRORS

1680: -- API name : Load Interfance Lines
1681: -- TYPE : Public (called by Concurrent Program)
1682: -- Pre-reqs : None
1683: -- FUNCTION : Process and Load interfance lines into FND_GRANTS.
1684: -- Errors are populated in MTL_INTERFACE_ERRORS
1685:
1686: -- ======================================================================
1687: -- the record types used from other procedures
1688: -- noted down here for quick reference

Line 3014: ' FROM EGO_ITEM_PEOPLE_INTF INTF, MTL_INTERFACE_ERRORS MIERR '||

3010: ----------------------------------------------------------------
3011: l_err_msg_sql := 'SELECT INTF.ITEM_NUMBER as ITEM_NUMBER, '||
3012: ' INTF.ORGANIZATION_CODE as ORGANIZATION_CODE, '||
3013: ' MIERR.ERROR_MESSAGE as ERROR_MESSAGE '||
3014: ' FROM EGO_ITEM_PEOPLE_INTF INTF, MTL_INTERFACE_ERRORS MIERR '||
3015: ' WHERE MIERR.TRANSACTION_ID = INTF.TRANSACTION_ID '||
3016: ' AND MIERR.REQUEST_ID = INTF.REQUEST_ID '||
3017: ' AND MIERR.request_id = :1';
3018: