450: ,p_entity_id => p_line_id
451: ,p_line_id => p_line_id);
452:
453:
454: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
455: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
456: END IF;
457:
458: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
451: ,p_line_id => p_line_id);
452:
453:
454: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
455: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
456: END IF;
457:
458: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
459: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
454: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
455: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
456: END IF;
457:
458: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
459: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
460: END IF;
461:
462:
455: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
456: END IF;
457:
458: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
459: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
460: END IF;
461:
462:
463: -- Check whether EC/ASO products are installed. Call lock_row only if we
463: -- Check whether EC/ASO products are installed. Call lock_row only if we
464: -- need to call Process_Requests_And_Notify to notify OC or to process
465: -- acknowledgements.
466:
467: IF ( (OE_GLOBALS.G_EC_INSTALLED <> 'Y') AND
468: (OE_GLOBALS.G_ASO_INSTALLED <> 'Y') AND
469: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'N') )
470: THEN
471: SELECT cancelled_flag,
464: -- need to call Process_Requests_And_Notify to notify OC or to process
465: -- acknowledgements.
466:
467: IF ( (OE_GLOBALS.G_EC_INSTALLED <> 'Y') AND
468: (OE_GLOBALS.G_ASO_INSTALLED <> 'Y') AND
469: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'N') )
470: THEN
471: SELECT cancelled_flag,
472: lock_control,
651:
652:
653: -- Check whether we need to call Process_Requests_And_Notify.
654:
655: IF ( (OE_GLOBALS.G_RECURSION_MODE = 'Y') AND
656: (OE_GLOBALS.G_EC_INSTALLED <> 'Y') AND
657: (OE_GLOBALS.G_ASO_INSTALLED <> 'Y') AND
658: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'N') )
659: THEN
652:
653: -- Check whether we need to call Process_Requests_And_Notify.
654:
655: IF ( (OE_GLOBALS.G_RECURSION_MODE = 'Y') AND
656: (OE_GLOBALS.G_EC_INSTALLED <> 'Y') AND
657: (OE_GLOBALS.G_ASO_INSTALLED <> 'Y') AND
658: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'N') )
659: THEN
660: --Customer Acceptance
653: -- Check whether we need to call Process_Requests_And_Notify.
654:
655: IF ( (OE_GLOBALS.G_RECURSION_MODE = 'Y') AND
656: (OE_GLOBALS.G_EC_INSTALLED <> 'Y') AND
657: (OE_GLOBALS.G_ASO_INSTALLED <> 'Y') AND
658: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'N') )
659: THEN
660: --Customer Acceptance
661: -- Modified for bug 16037930