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 241: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

237: if n=-1 then
238:
239: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [1]: Call to GROUPSTDDEV failed.';
240:
241: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
242: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
243: end if;
244: return 0;
245: end if;

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

238:
239: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [1]: Call to GROUPSTDDEV failed.';
240:
241: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
242: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
243: end if;
244: return 0;
245: end if;
246: std_dev(i) :=n;

Line 255: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

251: if n=-1 then
252:
253: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [2]: Call to GROUPSTDDEV failed.';
254:
255: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
256: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
257: end if;
258:
259: return 0;

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

252:
253: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [2]: Call to GROUPSTDDEV failed.';
254:
255: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
256: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
257: end if;
258:
259: return 0;
260:

Line 290: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

286:
287: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [END] NO_DATA_FOUND: ' ||
288: SQLERRM;
289:
290: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
291: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
292: End If;
293:
294: RETURN 0;

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

287: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [END] NO_DATA_FOUND: ' ||
288: SQLERRM;
289:
290: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
291: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
292: End If;
293:
294: RETURN 0;
295:

Line 301: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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

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

298: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CAL_SELECTIVITY: [END] OTHERS: ' ||
299: SQLERRM;
300:
301: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
302: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
303: END IF;
304:
305: RETURN 0;
306:

Line 393: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

389:
390: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.SELECTIVITY: [END] NO_DATA_FOUND: ' ||
391: SQLERRM;
392:
393: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
394: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
395: End If;
396:
397: RETURN 0;

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

390: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.SELECTIVITY: [END] NO_DATA_FOUND: ' ||
391: SQLERRM;
392:
393: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
394: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
395: End If;
396:
397: RETURN 0;
398:

Line 404: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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

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

401: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.SELECTIVITY: [END] OTHERS: ' ||
402: SQLERRM;
403:
404: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
405: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
406: END IF;
407:
408: RETURN 0;
409:

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

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

Line 546: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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

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

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

Line 557: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

553:
554: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX_WO_WORKER_ID: [END] OTHERS: ' ||
555: p_table_name || ': ' || SQLERRM;
556:
557: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
558: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
559: End If;
560:
561: END CREATE_INDEX_WO_WORKER_ID;

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

554: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX_WO_WORKER_ID: [END] OTHERS: ' ||
555: p_table_name || ': ' || SQLERRM;
556:
557: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
558: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
559: End If;
560:
561: END CREATE_INDEX_WO_WORKER_ID;
562:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1131: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

1127:
1128: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] NO_DATA_FOUND: ' ||
1129: p_table_name || ': ' || SQLERRM;
1130:
1131: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1132: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1133: End If;
1134:
1135: WHEN OTHERS THEN

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

1128: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] NO_DATA_FOUND: ' ||
1129: p_table_name || ': ' || SQLERRM;
1130:
1131: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1132: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1133: End If;
1134:
1135: WHEN OTHERS THEN
1136:

Line 1142: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

1138:
1139: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] OTHERS: ' ||
1140: p_table_name || ': ' || SQLERRM;
1141:
1142: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1143: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1144: End If;
1145:
1146: END CREATE_INDEX;

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

1139: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX: [END] OTHERS: ' ||
1140: p_table_name || ': ' || SQLERRM;
1141:
1142: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1143: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1144: End If;
1145:
1146: END CREATE_INDEX;
1147:

Line 1199: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

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

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

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

Line 1210: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

1206: RETCODE := 2;
1207: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES: [END] OTHERS: ' ||
1208: p_table_name || ': ' || SQLERRM;
1209:
1210: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1211: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1212: End If;
1213:
1214:

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

1207: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES: [END] OTHERS: ' ||
1208: p_table_name || ': ' || SQLERRM;
1209:
1210: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1211: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1212: End If;
1213:
1214:
1215: END DROP_TABLE_INDEXES;

Line 1249: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

1245: RETCODE := 2;
1246: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE: [END] OTHERS: ' ||
1247: p_table_name || ': ' || SQLERRM;
1248:
1249: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1250: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1251: End If;
1252:
1253: END TRUNCATE_TABLE;

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

1246: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE: [END] OTHERS: ' ||
1247: p_table_name || ': ' || SQLERRM;
1248:
1249: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1250: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1251: End If;
1252:
1253: END TRUNCATE_TABLE;
1254:

Line 1300: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

1296: RETCODE := 2;
1297: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX: [END] OTHERS: ' ||
1298: p_table_name || ': ' || SQLERRM;
1299:
1300: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1301: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1302: End If;
1303:
1304: END ANALYZE_TABLE_INDEX;

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

1297: ERRBUF := 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX: [END] OTHERS: ' ||
1298: p_table_name || ': ' || SQLERRM;
1299:
1300: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
1301: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1302: End If;
1303:
1304: END ANALYZE_TABLE_INDEX;
1305: