APPS.DOM_DOC_TEXT_UTIL dependencies on AD_CTX_DDL

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

228: PROCEDURE Sync_Index ( p_idx_name IN VARCHAR2 DEFAULT NULL )
229: IS
230: BEGIN
231:
232: AD_CTX_DDL.Sync_Index ( idx_name => NVL(g_Index_Owner || '.' || p_idx_name, g_Index_Owner ||'.'|| g_Index_Name) );
233:
234: EXCEPTION
235: WHEN others THEN
236: DOM_DOC_TEXT_PVT.Log_Line ('DOM_DOC_TEXT_UTIL : Error in Sync Index');

Line 266: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full

262: PROCEDURE Optimize_Index
263: (
264: ERRBUF OUT NOCOPY VARCHAR2
265: , RETCODE OUT NOCOPY NUMBER
266: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full
267: , p_dummy IN VARCHAR2 DEFAULT NULL
268: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
269: )
270: IS

Line 268: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited

264: ERRBUF OUT NOCOPY VARCHAR2
265: , RETCODE OUT NOCOPY NUMBER
266: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full
267: , p_dummy IN VARCHAR2 DEFAULT NULL
268: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
269: )
270: IS
271:
272: Mctx INV_ITEM_MSG.Msg_Ctx_type;

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

273: l_api_name CONSTANT VARCHAR2(30) := 'Optimize_Index';
274: l_success CONSTANT NUMBER := 0;
275: l_error CONSTANT NUMBER := 2;
276: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
277: l_maxtime NUMBER := NVL(p_maxtime,AD_CTX_DDL.Maxtime_Unlimited);
278:
279: BEGIN
280:
281: IF p_optlevel ='FAST' THEN

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

281: IF p_optlevel ='FAST' THEN
282: l_maxtime := NULL;
283: END IF;
284:
285: AD_CTX_DDL.Optimize_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name
286: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
287: , maxtime => l_maxtime);
288: --gyedla Create Message
289: RETCODE := l_success;

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

282: l_maxtime := NULL;
283: END IF;
284:
285: AD_CTX_DDL.Optimize_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name
286: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
287: , maxtime => l_maxtime);
288: --gyedla Create Message
289: RETCODE := l_success;
290: ERRBUF := FND_MESSAGE.Get_String('DOM', 'DOM_OPTIMINDEX_SUCCESS');