DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_CMP_UTIL_PKG

Line 243: IF (AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_prd_workorder_rec.visit_id) = 'Y') THEN

239: * non-serialized instance due to an Open work order (Visit MWO).
240: * We have explicitly added a workaround to avoid having non-serialized instance in Visit MWO while its creation,
241: * hence the same instance should be used while updation as well.
242: */
243: IF (AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_prd_workorder_rec.visit_id) = 'Y') THEN
244:
245: OPEN get_instance_id_csr (l_prd_workorder_rec.wip_entity_id);
246: FETCH get_instance_id_csr INTO l_prd_workorder_rec.item_instance_id;
247: CLOSE get_instance_id_csr;

Line 6732: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_x_prd_workorder_tbl(p_x_prd_workorder_tbl.FIRST).visit_id);

6728: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011
6729: * There is no need to consider resource requirements for Stage workorders in case of
6730: * Component Visits as there won't be any Stage associated with them.
6731: */
6732: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_x_prd_workorder_tbl(p_x_prd_workorder_tbl.FIRST).visit_id);
6733: IF (l_is_comp_visit = 'N') THEN
6734: IF ( G_DEBUG = 'Y' ) THEN
6735: AHL_DEBUG_PUB.debug( l_api_name || ' - Invoking Process_stage_jobs API. Total MR workorders: ' || total_mr_workorders );
6736: END IF;