38: INTO l_count
39: FROM DUAL
40: WHERE EXISTS
41: (SELECT 'X'
42: FROM MTL_SYSTEM_ITEMS_B
43: WHERE LIFECYCLE_ID = p_lifecycle_id);
44: x_delete_ok := FND_API.G_FALSE;
45: l_message := 'EGO_ITEM_ASSOCIATED_LC';
46: EXCEPTION
135: INTO l_count
136: FROM DUAL
137: WHERE EXISTS
138: (SELECT 'X'
139: FROM MTL_SYSTEM_ITEMS_B
140: WHERE CURRENT_PHASE_ID = p_phase_id);
141: x_delete_ok := FND_API.G_FALSE;
142: l_message := 'EGO_ITEM_ASSOCIATED_PH';
143: EXCEPTION