DBA Data[Home] [Help]

APPS.AHL_PRD_UTIL_PKG dependencies on AHL_UTIL_UC_PKG

Line 272: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

268: BEGIN
269: -- Check if item_instance_id is input to the API.
270: IF p_item_instance_id IS NOT NULL
271: THEN
272: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
273: p_unit_header_id => null,
274: p_instance_id => p_item_instance_id
275: );
276: -- If visit_id is input

Line 290: IF AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

286:
287: -- If visit header has item instance info.
288: IF l_instance_id IS NOT NULL
289: THEN
290: IF AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
291: p_unit_header_id => null,
292: p_instance_id => l_instance_id
293: ) = FND_API.G_TRUE
294: THEN

Line 300: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

296: END IF;
297:
298: ELSE
299: -- If visit task has item instance info.
300: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
301: p_unit_header_id => null,
302: p_instance_id => l_item_instance_id
303: );
304: END IF;

Line 314: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

310: THEN
311: OPEN c_get_ue_instance_id(p_ue_id);
312: FETCH c_get_ue_instance_id INTO l_instance_id;
313: CLOSE c_get_ue_instance_id;
314: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
315: p_unit_header_id => null,
316: p_instance_id => l_instance_id
317: );
318: -- If workorder id is input to the API.

Line 324: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

320: THEN
321: OPEN c_get_wo_item_details(p_workorder_id);
322: FETCH c_get_wo_item_details INTO l_item_instance_id, l_instance_id;
323: CLOSE c_get_wo_item_details;
324: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
325: p_unit_header_id => null,
326: p_instance_id => nvl(l_instance_id, l_item_instance_id) );
327: END IF;
328: