DBA Data[Home] [Help]

APPS.MTL_CROSS_REFERENCES_PVT dependencies on MTL_CROSS_REFERENCE_TYPES

Line 283: ,p_table_name => 'MTL_CROSS_REFERENCE_TYPES'

279: ,p_application_id => 'INV'
280: ,p_message_type => 'E'
281: ,p_entity_code => G_Entity_Code
282: ,p_entity_index => l_Xref_Indx
283: ,p_table_name => 'MTL_CROSS_REFERENCE_TYPES'
284: );
285: RAISE VALIDATION_ERROR;
286: END IF;
287:

Line 294: FROM MTL_CROSS_REFERENCE_TYPES

290: AND l_XRef_Rec.Cross_Reference_Type<> FND_API.G_MISS_CHAR THEN
291:
292: BEGIN -- cross reference type existance
293: SELECT 'x' INTO l_exists
294: FROM MTL_CROSS_REFERENCE_TYPES
295: WHERE cross_reference_type =l_XRef_Rec.Cross_Reference_Type
296: AND trunc(nvl(disable_date,sysdate)) >= trunc(sysdate);
297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN

Line 311: ,p_table_name => 'MTL_CROSS_REFERENCE_TYPES'

307: ,p_token_tbl => l_Token_Tbl
308: ,p_message_type => 'E'
309: ,p_entity_code => G_Entity_Code
310: ,p_entity_index => l_Xref_Indx
311: ,p_table_name => 'MTL_CROSS_REFERENCE_TYPES'
312: );
313: RAISE VALIDATION_ERROR;
314: END;
315: END IF ;