APPS.ENG_CHANGE_TEXT_UTIL dependencies on AD_CTX_DDL

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

376: PROCEDURE Sync_Index ( p_idx_name IN VARCHAR2 DEFAULT NULL )
377: IS
378: BEGIN
379:
380: AD_CTX_DDL.Sync_Index ( idx_name => NVL(g_Index_Owner || '.' || p_idx_name, g_Index_Owner ||'.'|| g_Index_Name) );
381:
382: EXCEPTION
383: WHEN ORA20000_TEXT_EXCEPTION THEN
384: --DRG-10502 index string does not exist

Line 423: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full

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

Line 425: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited

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

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

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

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

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

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

439: l_maxtime := NULL;
440: END IF;
441:
442: AD_CTX_DDL.Optimize_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name
443: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
444: , maxtime => l_maxtime);
445:
446: RETCODE := l_success;
447: ERRBUF := FND_MESSAGE.Get_String('EGO', 'EGO_OPTIMINDEX_SUCCESS');