APPS.EGO_ITEM_AML_PVT dependencies on MTL_INTERFACE_ERRORS

Line 2399: DELETE MTL_INTERFACE_ERRORS

2395: IF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ALL THEN
2396: --
2397: -- delete all lines
2398: --
2399: DELETE MTL_INTERFACE_ERRORS
2400: WHERE table_name = l_table_name
2401: AND transaction_id IN
2402: (SELECT transaction_id
2403: FROM EGO_AML_INTF

Line 2414: DELETE MTL_INTERFACE_ERRORS

2410: ELSIF p_delete_line_type = EGO_ITEM_PUB.G_INTF_DELETE_ERROR THEN
2411: --
2412: -- delete all error lines
2413: --
2414: DELETE MTL_INTERFACE_ERRORS
2415: WHERE table_name = l_table_name
2416: AND transaction_id IN
2417: (SELECT transaction_id
2418: FROM EGO_AML_INTF

Line 2844: ' FROM EGO_AML_INTF INTF, MTL_INTERFACE_ERRORS MIERR '||

2840: l_err_msg_sql := 'SELECT INTF.ITEM_NUMBER as ITEM_NUMBER, '||
2841: ' INTF.ORGANIZATION_CODE as ORGANIZATINO_CODE, '||
2842: -- ' NULL AS REVISION_CODE, '||
2843: ' MIERR.ERROR_MESSAGE as ERROR_MESSAGE '||
2844: ' FROM EGO_AML_INTF INTF, MTL_INTERFACE_ERRORS MIERR '||
2845: ' WHERE MIERR.TRANSACTION_ID = INTF.TRANSACTION_ID '||
2846: ' AND MIERR.REQUEST_ID = INTF.REQUEST_ID '||
2847: ' AND MIERR.request_id = :1';
2848: EGO_ITEM_OPEN_INTERFACE_PVT.Write_Error_into_ConcurrentLog