APPS.AHL_PRD_UTIL_PKG dependencies on AHL_UTIL_UC_PKG

Line 285: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

281: BEGIN
282: -- Check if item_instance_id is input to the API.
283: IF p_item_instance_id IS NOT NULL
284: THEN
285: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
286: p_unit_header_id => null,
287: p_instance_id => p_item_instance_id
288: );
289: -- If visit_id is input

Line 303: IF AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

299:
300: -- If visit header has item instance info.
301: IF l_instance_id IS NOT NULL
302: THEN
303: IF AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
304: p_unit_header_id => null,
305: p_instance_id => l_instance_id
306: ) = FND_API.G_TRUE
307: THEN

Line 313: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

309: END IF;
310:
311: ELSE
312: -- If visit task has item instance info.
313: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
314: p_unit_header_id => null,
315: p_instance_id => l_item_instance_id
316: );
317: END IF;

Line 327: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

323: THEN
324: OPEN c_get_ue_instance_id(p_ue_id);
325: FETCH c_get_ue_instance_id INTO l_instance_id;
326: CLOSE c_get_ue_instance_id;
327: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
328: p_unit_header_id => null,
329: p_instance_id => l_instance_id
330: );
331: -- If workorder id is input to the API.

Line 337: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(

333: THEN
334: OPEN c_get_wo_item_details(p_workorder_id);
335: FETCH c_get_wo_item_details INTO l_item_instance_id, l_instance_id;
336: CLOSE c_get_wo_item_details;
337: RETURN AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
338: p_unit_header_id => null,
339: p_instance_id => nvl(l_instance_id, l_item_instance_id) );
340: END IF;
341: