eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on JTF_TAE_INDEX_CREATION_PVT

Line 1: PACKAGE BODY jtf_tae_index_creation_pvt AS

1: PACKAGE BODY jtf_tae_index_creation_pvt AS
2: /*$Header: jtftaeib.pls 120.3.12020000.2 2012/12/04 05:41:24 swpoddar ship $*/
3: /* -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TAE_INDEX_CREATION_PVT

2: /*$Header: jtftaeib.pls 120.3.12020000.2 2012/12/04 05:41:24 swpoddar ship $*/
3: /* -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTF_TAE_INDEX_CREATION_PVT
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- This package will contain package body for calculating selectivity,
10: -- and for creating indices on columns

Line 76: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.GROUPSTDDEV: [END] NO_DATA_FOUND: ' ||

72:
73: EXCEPTION
74: WHEN NO_DATA_FOUND THEN
75:
76: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.GROUPSTDDEV: [END] NO_DATA_FOUND: ' ||
77: SQLERRM;
78:
79: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
80: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 87: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.GROUPSTDDEV: [END] OTHERS: ' ||

83: RETURN -1;
84:
85: WHEN OTHERS THEN
86:
87: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.GROUPSTDDEV: [END] OTHERS: ' ||
88: SQLERRM;
89:
90: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
91: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 240: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [1]: Call to GROUPSTDDEV failed.';

236: if flag(i)=1 or std_dev(i)is null
237: then n := Groupstddev(p_table_name, v_colname(i) );
238: if n=-1 then
239:
240: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [1]: Call to GROUPSTDDEV failed.';
241:
242: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
243: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
244: end if;

Line 254: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [2]: Call to GROUPSTDDEV failed.';

250: then n := Groupstddev(p_table_name, v_colname(i+1) );
251: -- -1 : error
252: if n=-1 then
253:
254: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [2]: Call to GROUPSTDDEV failed.';
255:
256: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
257: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
258: end if;

Line 288: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [END] NO_DATA_FOUND: ' ||

284:
285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN
287:
288: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [END] NO_DATA_FOUND: ' ||
289: SQLERRM;
290:
291: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
292: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 299: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [END] OTHERS: ' ||

295: RETURN 0;
296:
297: WHEN OTHERS THEN
298:
299: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [END] OTHERS: ' ||
300: SQLERRM;
301:
302: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
303: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 391: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.SELECTIVITY: [END] NO_DATA_FOUND: ' ||

387:
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390:
391: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.SELECTIVITY: [END] NO_DATA_FOUND: ' ||
392: SQLERRM;
393:
394: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
395: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 402: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.SELECTIVITY: [END] OTHERS: ' ||

398: RETURN 0;
399:
400: WHEN OTHERS THEN
401:
402: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.SELECTIVITY: [END] OTHERS: ' ||
403: SQLERRM;
404:
405: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
406: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 545: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX_WO_WORKER_ID: [END] SCHEMA NAME FOUND CORRESPONDING TO JTF APPLICATION. ';

541: WHEN L_SCHEMA_NOTFOUND THEN
542:
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544:
545: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX_WO_WORKER_ID: [END] SCHEMA NAME FOUND CORRESPONDING TO JTF APPLICATION. ';
546:
547: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
548: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
549: End If;

Line 555: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX_WO_WORKER_ID: [END] OTHERS: ' ||

551: WHEN OTHERS THEN
552:
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
554:
555: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX_WO_WORKER_ID: [END] OTHERS: ' ||
556: p_table_name || ': ' || SQLERRM;
557:
558: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
559: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 1129: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] NO_DATA_FOUND: ' ||

1125: WHEN NO_DATA_FOUND THEN
1126:
1127: x_return_status := FND_API.G_RET_STS_ERROR ;
1128:
1129: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] NO_DATA_FOUND: ' ||
1130: p_table_name || ': ' || SQLERRM;
1131:
1132: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1133: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 1140: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] OTHERS: ' ||

1136: WHEN OTHERS THEN
1137:
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139:
1140: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] OTHERS: ' ||
1141: p_table_name || ': ' || SQLERRM;
1142:
1143: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1144: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 1198: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES: [END] SCHEMA NAME FOUND CORRESPONDING TO JTF APPLICATION. ';

1194: WHEN L_SCHEMA_NOTFOUND THEN
1195:
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1197: RETCODE := 2;
1198: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES: [END] SCHEMA NAME FOUND CORRESPONDING TO JTF APPLICATION. ';
1199:
1200: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1201: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1202: End If;

Line 1208: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES: [END] OTHERS: ' ||

1204: WHEN OTHERS THEN
1205:
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1207: RETCODE := 2;
1208: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES: [END] OTHERS: ' ||
1209: p_table_name || ': ' || SQLERRM;
1210:
1211: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1212: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 1247: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE: [END] OTHERS: ' ||

1243: WHEN OTHERS THEN
1244:
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1246: RETCODE := 2;
1247: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE: [END] OTHERS: ' ||
1248: p_table_name || ': ' || SQLERRM;
1249:
1250: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1251: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 1298: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX: [END] OTHERS: ' ||

1294: WHEN OTHERS THEN
1295:
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1297: RETCODE := 2;
1298: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX: [END] OTHERS: ' ||
1299: p_table_name || ': ' || SQLERRM;
1300:
1301: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1302: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 1308: END JTF_TAE_INDEX_CREATION_PVT;

1304:
1305: END ANALYZE_TABLE_INDEX;
1306:
1307:
1308: END JTF_TAE_INDEX_CREATION_PVT;