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_CONTROL_PVT

Line 79: If JTF_TAE_CONTROL_PVT.G_DEBUG 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);
81: End If;
82:
83: RETURN -1;

Line 80: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
81: End If;
82:
83: RETURN -1;
84:

Line 90: If JTF_TAE_CONTROL_PVT.G_DEBUG 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);
92: END IF;
93:
94: RETURN -1;

Line 91: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
92: END IF;
93:
94: RETURN -1;
95:

Line 242: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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;
245: return 0;
246: end if;

Line 243: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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;
245: return 0;
246: end if;
247: std_dev(i) :=n;

Line 256: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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;
259:
260: return 0;

Line 257: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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;
259:
260: return 0;
261:

Line 291: If JTF_TAE_CONTROL_PVT.G_DEBUG 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);
293: End If;
294:
295: RETURN 0;

Line 292: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
293: End If;
294:
295: RETURN 0;
296:

Line 302: If JTF_TAE_CONTROL_PVT.G_DEBUG 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);
304: END IF;
305:
306: RETURN 0;

Line 303: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
304: END IF;
305:
306: RETURN 0;
307:

Line 394: If JTF_TAE_CONTROL_PVT.G_DEBUG 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);
396: End If;
397:
398: RETURN 0;

Line 395: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
396: End If;
397:
398: RETURN 0;
399:

Line 405: If JTF_TAE_CONTROL_PVT.G_DEBUG 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);
407: END IF;
408:
409: RETURN 0;

Line 406: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
407: END IF;
408:
409: RETURN 0;
410:

Line 496: jtf_tae_control_pvt.write_log(2, 'New Mode index corresponding to index ' || l_index_name(i) || ' is not created.');

492:
493: if (l_no_of_indexes > 0) then
494: FOR i IN l_index_name.FIRST .. l_index_name.LAST LOOP
495: if (length(l_index_name(i)) >= 30) then
496: jtf_tae_control_pvt.write_log(2, 'New Mode index corresponding to index ' || l_index_name(i) || ' is not created.');
497:
498: else
499: /* Get all the column names for the index except worker_id */
500: OPEN column_name_c(l_index_name(i), l_owner(i));

Line 547: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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;
550:
551: WHEN OTHERS THEN

Line 548: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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;
550:
551: WHEN OTHERS THEN
552:

Line 558: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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);
560: End If;
561:
562: END CREATE_INDEX_WO_WORKER_ID;

Line 559: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
560: End If;
561:
562: END CREATE_INDEX_WO_WORKER_ID;
563:

Line 748: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index for TRANS table');

744:
745:
746: -- indexes for TRANS table
747: IF ( UPPER(p_table_name) LIKE 'JTF_TAE%_TRANS') THEN
748: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index for TRANS table');
749:
750: /* CREATE Static UNIQUE KEY Index */
751: -- OIC processing
752: IF p_run_mode = 'OIC_TAP' THEN

Line 769: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with statement : ' || v_statement);

765: -- EIHSU: added worker_id 06/12/2003
766: v_statement := v_statement || ' ( ' || 'WORKER_ID, ' ||'TRANS_OBJECT_ID, TRANS_DETAIL_OBJECT_ID ) ';
767: v_statement := v_statement || s_statement;
768:
769: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with statement : ' || v_statement);
770: EXECUTE IMMEDIATE v_statement;
771: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');
772:
773: /* ARPATEL Bug#3597884 05/10/2004 */

Line 771: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');

767: v_statement := v_statement || s_statement;
768:
769: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with statement : ' || v_statement);
770: EXECUTE IMMEDIATE v_statement;
771: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');
772:
773: /* ARPATEL Bug#3597884 05/10/2004 */
774: alter_statement := 'ALTER INDEX ' || l_ora_username || '.' || l_trans_idx_name || ' NOPARALLEL';
775: EXECUTE IMMEDIATE alter_statement;

Line 908: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with statement : ' || v_statement);

904: v_statement := v_statement || s_statement;
905:
906: IF l_create_index_flag = 'Y' THEN
907: --dbms_output.put_line(' building index');
908: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with statement : ' || v_statement);
909: EXECUTE IMMEDIATE v_statement;
910: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');
911:
912: /* ARPATEL Bug#3597884 05/10/2004 */

Line 910: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');

906: IF l_create_index_flag = 'Y' THEN
907: --dbms_output.put_line(' building index');
908: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with statement : ' || v_statement);
909: EXECUTE IMMEDIATE v_statement;
910: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');
911:
912: /* ARPATEL Bug#3597884 05/10/2004 */
913: IF prd_nulltae_mul_of_4841 = 'Y' OR prd_nulltae_mul_of_324347 = 'Y'
914: THEN

Line 1040: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with statement : ' || v_statement);

1036: v_statement := v_statement || s_statement;
1037:
1038: IF l_create_index_flag = 'Y' THEN
1039: --dbms_output.put_line(' building rev_ index');
1040: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with statement : ' || v_statement);
1041: EXECUTE IMMEDIATE v_statement;
1042: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');
1043:
1044: /* ARPATEL Bug#3597884 05/10/2004 */

Line 1042: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');

1038: IF l_create_index_flag = 'Y' THEN
1039: --dbms_output.put_line(' building rev_ index');
1040: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with statement : ' || v_statement);
1041: EXECUTE IMMEDIATE v_statement;
1042: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');
1043:
1044: /* ARPATEL Bug#3597884 05/10/2004 */
1045: IF prd_rev_nulltae_mul_of_324347 = 'Y'
1046: THEN

Line 1066: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with no worker_id');

1062: END LOOP;
1063:
1064: /* Create the indexes without worker_id column for new mode */
1065: IF (p_table_name IN ('JTF_TAE_1001_ACCOUNT_TRANS', 'JTF_TAE_1001_LEAD_TRANS', 'JTF_TAE_1001_OPPOR_TRANS')) THEN
1066: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with no worker_id');
1067: CREATE_INDEX_WO_WORKER_ID ( p_table_name
1068: ,s_statement
1069: ,x_Return_Status);
1070: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');

Line 1070: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');

1066: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Creating index on trans table with no worker_id');
1067: CREATE_INDEX_WO_WORKER_ID ( p_table_name
1068: ,s_statement
1069: ,x_Return_Status);
1070: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Done creating index');
1071: END IF;
1072:
1073: /*
1074: -- index for MATCHES table

Line 1132: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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);
1134: End If;
1135:
1136: WHEN OTHERS THEN

Line 1133: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
1134: End If;
1135:
1136: WHEN OTHERS THEN
1137:

Line 1143: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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);
1145: End If;
1146:
1147: END CREATE_INDEX;

Line 1144: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
1145: End If;
1146:
1147: END CREATE_INDEX;
1148:

Line 1200: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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;
1203:
1204: WHEN OTHERS THEN

Line 1201: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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;
1203:
1204: WHEN OTHERS THEN
1205:

Line 1211: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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);
1213: End If;
1214:
1215:

Line 1212: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
1213: End If;
1214:
1215:
1216: END DROP_TABLE_INDEXES;

Line 1250: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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);
1252: End If;
1253:
1254: END TRUNCATE_TABLE;

Line 1251: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
1252: End If;
1253:
1254: END TRUNCATE_TABLE;
1255:

Line 1301: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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);
1303: End If;
1304:
1305: END ANALYZE_TABLE_INDEX;

Line 1302: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

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);
1303: End If;
1304:
1305: END ANALYZE_TABLE_INDEX;
1306: