DBA Data[Home] [Help]

APPS.DOM_DOC_TEXT_UTIL dependencies on AD_CTX_DDL

Line 390: AD_CTX_DDL.Sync_Index ( idx_name => NVL(g_Index_Owner || '.' || p_idx_name, g_Index_Owner ||'.'|| g_Index_Name) );

386: PROCEDURE Sync_Index ( p_idx_name IN VARCHAR2 DEFAULT NULL )
387: IS
388: BEGIN
389:
390: AD_CTX_DDL.Sync_Index ( idx_name => NVL(g_Index_Owner || '.' || p_idx_name, g_Index_Owner ||'.'|| g_Index_Name) );
391:
392: EXCEPTION
393: WHEN others THEN
394: DOM_DOC_TEXT_PVT.Log_Line ('DOM_DOC_TEXT_UTIL : Error in Sync Index');

Line 424: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full

420: PROCEDURE Optimize_Index
421: (
422: ERRBUF OUT NOCOPY VARCHAR2
423: , RETCODE OUT NOCOPY NUMBER
424: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full
425: , p_dummy IN VARCHAR2 DEFAULT NULL
426: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
427: )
428: IS

Line 426: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited

422: ERRBUF OUT NOCOPY VARCHAR2
423: , RETCODE OUT NOCOPY NUMBER
424: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full
425: , p_dummy IN VARCHAR2 DEFAULT NULL
426: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
427: )
428: IS
429:
430: Mctx INV_ITEM_MSG.Msg_Ctx_type;

Line 435: l_maxtime NUMBER := NVL(p_maxtime,AD_CTX_DDL.Maxtime_Unlimited);

431: l_api_name CONSTANT VARCHAR2(30) := 'Optimize_Index';
432: l_success CONSTANT NUMBER := 0;
433: l_error CONSTANT NUMBER := 2;
434: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
435: l_maxtime NUMBER := NVL(p_maxtime,AD_CTX_DDL.Maxtime_Unlimited);
436:
437: BEGIN
438:
439: IF p_optlevel ='FAST' THEN

Line 443: AD_CTX_DDL.Optimize_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name

439: IF p_optlevel ='FAST' THEN
440: l_maxtime := NULL;
441: END IF;
442:
443: AD_CTX_DDL.Optimize_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name
444: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
445: , maxtime => l_maxtime);
446: --gyedla Create Message
447: RETCODE := l_success;

Line 444: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)

440: l_maxtime := NULL;
441: END IF;
442:
443: AD_CTX_DDL.Optimize_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name
444: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
445: , maxtime => l_maxtime);
446: --gyedla Create Message
447: RETCODE := l_success;
448: ERRBUF := FND_MESSAGE.Get_String('DOM', 'DOM_OPTIMINDEX_SUCCESS');