APPS.IEX_SCORE_NEW_PVT dependencies on AD_DDL

Line 2176: ad_ddl.do_ddl( l_prod,

2172: IEX_DEBUG_PUB.logMessage('Schema:'||l_prod);
2173: IEX_DEBUG_PUB.LogMessage('Truncating IEX_SCORE_HISTORIES');
2174:
2175:
2176: ad_ddl.do_ddl( l_prod,
2177: 'IEX',
2178: AD_DDL.TRUNCATE_TABLE,
2179: 'TRUNCATE TABLE IEX_SCORE_HISTORIES',
2180: 'IEX_SCORE_HISTORIES' );

Line 2178: AD_DDL.TRUNCATE_TABLE,

2174:
2175:
2176: ad_ddl.do_ddl( l_prod,
2177: 'IEX',
2178: AD_DDL.TRUNCATE_TABLE,
2179: 'TRUNCATE TABLE IEX_SCORE_HISTORIES',
2180: 'IEX_SCORE_HISTORIES' );
2181:
2182: IEX_DEBUG_PUB.LogMessage('Truncated IEX_SCORE_HISTORIES');

Line 2192: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');

2188: 'IEX_SCORE_HISTORIES_S value to 10000');
2189:
2190: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY -1';
2191: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY -1' ;
2192: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');
2193:
2194: EXECUTE IMMEDIATE 'select IEX_SCORE_HISTORIES_S.NEXTVAL +1 FROM DUAL' into v_num;
2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before altering Sequence IEX_SCORE_HISTORIES_S value is: '|| v_num);
2196:

Line 2200: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');

2196:
2197: if v_num <> 10000 then
2198: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY '|| ((v_num -10000)* -1);
2199: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY ' || ((v_num -10000)* -1);
2200: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');
2201: EXECUTE IMMEDIATE 'select IEX_SCORE_HISTORIES_S.NEXTVAL FROM DUAL' into v_num;
2202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is: 10000');
2203: else
2204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is already 10000, so no need to change it again');

Line 2208: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');

2204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is already 10000, so no need to change it again');
2205: end if;
2206: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2207: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2208: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');
2209: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is set to 10000');
2210: END;
2211: --End bug 8605501 gnramasa 20th Oct 09
2212: