APPS.EGO_ITEM_TEXT_UTIL dependencies on AD_CTX_DDL

Line 783: ,message => 'Before Calling the AD_CTX_DDL.Sync_Index'

779: BEGIN
780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
781: fnd_log.string(log_level => FND_LOG.LEVEL_PROCEDURE
782: ,module => 'fnd.plsql.EGO_ITEM_TEXT_UTIL.SYNC_INDEX'
783: ,message => 'Before Calling the AD_CTX_DDL.Sync_Index'
784: );
785: END IF;
786:
787: -------------------------------------------------------------------------------

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

790: -- cannot cannot be run at the same time for a single index.
791: -------------------------------------------------------------------------------
792: --EXECUTE IMMEDIATE 'ALTER INDEX ' || g_Index_Owner ||'.'|| g_Index_Name || ' REBUILD ONLINE PARAMETERS (''SYNC'')';
793:
794: AD_CTX_DDL.Sync_Index ( idx_name => NVL(p_idx_name, g_Index_Owner ||'.'|| g_Index_Name) );
795:
796: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
797: fnd_log.string(log_level => FND_LOG.LEVEL_PROCEDURE
798: ,module => 'fnd.plsql.EGO_ITEM_TEXT_UTIL.SYNC_INDEX'

Line 799: ,message => 'After Calling the AD_CTX_DDL.Sync_Index'

795:
796: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
797: fnd_log.string(log_level => FND_LOG.LEVEL_PROCEDURE
798: ,module => 'fnd.plsql.EGO_ITEM_TEXT_UTIL.SYNC_INDEX'
799: ,message => 'After Calling the AD_CTX_DDL.Sync_Index'
800: );
801: END IF;
802: /*
803: EXCEPTION

Line 819: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full

815: PROCEDURE Optimize_Index
816: (
817: ERRBUF OUT NOCOPY VARCHAR2
818: , RETCODE OUT NOCOPY NUMBER
819: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full
820: , p_dummy IN VARCHAR2 DEFAULT NULL
821: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
822: )
823: IS

Line 821: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited

817: ERRBUF OUT NOCOPY VARCHAR2
818: , RETCODE OUT NOCOPY NUMBER
819: , p_optlevel IN VARCHAR2 DEFAULT AD_CTX_DDL.Optlevel_Full
820: , p_dummy IN VARCHAR2 DEFAULT NULL
821: , p_maxtime IN NUMBER DEFAULT AD_CTX_DDL.Maxtime_Unlimited
822: )
823: IS
824:
825: Mctx INV_ITEM_MSG.Msg_Ctx_type;

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

826: l_api_name CONSTANT VARCHAR2(30) := 'Optimize_Index';
827: l_success CONSTANT NUMBER := 0;
828: l_error CONSTANT NUMBER := 2;
829: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
830: l_maxtime NUMBER := NVL(p_maxtime,AD_CTX_DDL.Maxtime_Unlimited);
831:
832: BEGIN
833:
834: INV_ITEM_MSG.Initialize;

Line 845: INV_ITEM_MSG.Debug(Mctx, 'Started AD_CTX_DDL.Optimize_Index..');

841: Mctx.Package_Name := G_PKG_NAME;
842: Mctx.Procedure_Name := l_api_name;
843:
844: IF (l_debug = 1) THEN
845: INV_ITEM_MSG.Debug(Mctx, 'Started AD_CTX_DDL.Optimize_Index..');
846: INV_ITEM_MSG.Debug(Mctx, 'Optimization Level :'||p_optlevel);
847: INV_ITEM_MSG.Debug(Mctx, 'Maximum Optimization Time :'||p_maxtime);
848: END IF;
849:

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

851: IF p_optlevel ='FAST' THEN
852: l_maxtime := NULL;
853: END IF;
854:
855: AD_CTX_DDL.Optimize_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name
856: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
857: , maxtime => l_maxtime);
858:
859: IF (l_debug = 1) THEN

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

852: l_maxtime := NULL;
853: END IF;
854:
855: AD_CTX_DDL.Optimize_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name
856: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
857: , maxtime => l_maxtime);
858:
859: IF (l_debug = 1) THEN
860: INV_ITEM_MSG.Debug(Mctx, 'Completed AD_CTX_DDL.Optimize_Index..');

Line 860: INV_ITEM_MSG.Debug(Mctx, 'Completed AD_CTX_DDL.Optimize_Index..');

856: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
857: , maxtime => l_maxtime);
858:
859: IF (l_debug = 1) THEN
860: INV_ITEM_MSG.Debug(Mctx, 'Completed AD_CTX_DDL.Optimize_Index..');
861: END IF;
862:
863: RETCODE := l_success;
864: ERRBUF := FND_MESSAGE.Get_String('EGO', 'EGO_OPTIMINDEX_SUCCESS');

Line 1165: -- AD_CTX_DDL.Sync_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name );

1161: -- Sync the index after the statement level event on a source table.
1162: -- This should no longer be used.
1163: -------------------------------------------------------------------------
1164: --ELSIF ( p_scope IN ('STATEMENT', 'STMT') ) THEN
1165: -- AD_CTX_DDL.Sync_Index ( idx_name => g_Index_Owner ||'.'|| g_Index_Name );
1166:
1167: ELSE
1168: Raise_Application_Error (-20001, 'Process_Source_Table_Event: Invalid parameter value: p_scope = ' || p_scope);
1169: