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_ASSIGN_PUB dependencies on JTF_TAE_INDEX_CREATION_PVT

Line 364: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||

360: --- [2] ---
361: -----------
362: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
363: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [1] Call to ' ||
364: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
365: 'for ' || l_matches_target);
366:
367: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
368: p_table_name => l_matches_target

Line 367: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

363: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [1] Call to ' ||
364: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
365: 'for ' || l_matches_target);
366:
367: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
368: p_table_name => l_matches_target
369: , x_return_status => x_return_status );
370:
371: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 374: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

370:
371: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
372:
373: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [1] Call to ' ||
374: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
375: l_matches_target;
376:
377: RAISE FND_API.G_EXC_ERROR;
378:

Line 386: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||

382: --- [3] ---
383: -----------
384: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
385: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [2] Call to ' ||
386: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
387: 'for ' || l_winners_target);
388:
389: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
390: p_table_name => l_winners_target

Line 389: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

385: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [2] Call to ' ||
386: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
387: 'for ' || l_winners_target);
388:
389: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
390: p_table_name => l_winners_target
391: , x_return_status => x_return_status );
392:
393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 396: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

392:
393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
394:
395: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [2] Call to ' ||
396: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
397: l_winners_target;
398:
399: RAISE FND_API.G_EXC_ERROR;
400:

Line 515: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||

511: --- [5] ---
512: -----------
513: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
514: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [5] Call to ' ||
515: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
516: 'for ' || l_trans_target);
517:
518: -- Analyze _TRANS table
519: -- JDOCHERT: 04/10/03: bug#2896552

Line 520: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

516: 'for ' || l_trans_target);
517:
518: -- Analyze _TRANS table
519: -- JDOCHERT: 04/10/03: bug#2896552
520: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
521: p_table_name => l_trans_target
522: , p_percent => 99
523: , x_return_status => x_return_status );
524:

Line 527: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||

523: , x_return_status => x_return_status );
524:
525: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
526: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [5] Call to ' ||
527: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
528: l_trans_target;
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531:

Line 619: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||

615: --- [9] ---
616: -----------
617: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
618: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [9] Call to ' ||
619: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
620: 'for ' || l_matches_target);
621:
622: -- Analyze Matches table
623: -- JDOCHERT: 04/10/03: bug#2896552

Line 624: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

620: 'for ' || l_matches_target);
621:
622: -- Analyze Matches table
623: -- JDOCHERT: 04/10/03: bug#2896552
624: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
625: p_table_name => l_matches_target
626: , p_percent => 20
627: , x_return_status => x_return_status );
628:

Line 631: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||

627: , x_return_status => x_return_status );
628:
629: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
630: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [9] Call to ' ||
631: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
632: l_matches_target;
633: RAISE FND_API.G_EXC_ERROR;
634: END IF;
635:

Line 645: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

641: 'MULTI-LEVEL TABLE CLEANUP BEGINS...');
642:
643: ----dbms_output.put_line('10.1: Truncate Level Winners Tables ');
644: -- 10.1: Truncate Level Winners Tables
645: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
646: p_table_name => l_terr_L1_target
647: , x_return_status => x_return_status );
648:
649: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 651: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

647: , x_return_status => x_return_status );
648:
649: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
650: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.1] Call to ' ||
651: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
652: l_terr_L1_target;
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655:

Line 656: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

652: l_terr_L1_target;
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655:
656: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
657: p_table_name => l_terr_L2_target
658: , x_return_status => x_return_status );
659:
660: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 662: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

658: , x_return_status => x_return_status );
659:
660: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
661: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.2] Call to ' ||
662: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
663: l_terr_L2_target;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:

Line 667: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

663: l_terr_L2_target;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:
667: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
668: p_table_name => l_terr_L3_target
669: , x_return_status => x_return_status );
670:
671: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 673: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

669: , x_return_status => x_return_status );
670:
671: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
672: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.3] Call to ' ||
673: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
674: l_terr_L3_target;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;
677:

Line 678: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

674: l_terr_L3_target;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;
677:
678: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
679: p_table_name => l_terr_L4_target
680: , x_return_status => x_return_status );
681:
682: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 684: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

680: , x_return_status => x_return_status );
681:
682: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
683: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.4] Call to ' ||
684: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
685: l_terr_L4_target;
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688:

Line 689: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

685: l_terr_L4_target;
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688:
689: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
690: p_table_name => l_terr_L5_target
691: , x_return_status => x_return_status );
692:
693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 695: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

691: , x_return_status => x_return_status );
692:
693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
694: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.5] Call to ' ||
695: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
696: l_terr_L5_target;
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:

Line 700: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

696: l_terr_L5_target;
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
701: p_table_name => l_terr_WT_target
702: , x_return_status => x_return_status );
703:
704: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 706: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

702: , x_return_status => x_return_status );
703:
704: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
705: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.6] Call to ' ||
706: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
707: l_terr_WT_target;
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710:

Line 735: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

731: );
732:
733: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
734: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.1] Call to ' ||
735: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
736: l_terr_L1_target;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:

Line 740: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

736: l_terr_L1_target;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:
740: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
741: p_table_name => l_terr_L1_target
742: , p_percent => 20
743: , x_return_status => x_return_status );
744:

Line 761: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

757: );
758:
759: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
760: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.2] Call to ' ||
761: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
762: l_terr_L2_target;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:

Line 766: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

762: l_terr_L2_target;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
767: p_table_name => l_terr_L2_target
768: , p_percent => 20
769: , x_return_status => x_return_status );
770:

Line 786: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

782: );
783:
784: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
785: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.3] Call to ' ||
786: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
787: l_terr_L3_target;
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790:

Line 791: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

787: l_terr_L3_target;
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790:
791: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
792: p_table_name => l_terr_L3_target
793: , p_percent => 20
794: , x_return_status => x_return_status );
795:

Line 811: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

807: );
808:
809: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
810: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.4] Call to ' ||
811: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
812: l_terr_L4_target;
813: RAISE FND_API.G_EXC_ERROR;
814: END IF;
815:

Line 816: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

812: l_terr_L4_target;
813: RAISE FND_API.G_EXC_ERROR;
814: END IF;
815:
816: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
817: p_table_name => l_terr_L4_target
818: , p_percent => 20
819: , x_return_status => x_return_status );
820:

Line 836: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

832: );
833:
834: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
835: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.5] Call to ' ||
836: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
837: l_terr_L5_target;
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;
840:

Line 841: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

837: l_terr_L5_target;
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;
840:
841: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
842: p_table_name => l_terr_L5_target
843: , p_percent => 20
844: , x_return_status => x_return_status );
845:

Line 861: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

857: );
858:
859: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
860: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.6] Call to ' ||
861: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
862: l_terr_WT_target;
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;
865:

Line 866: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

862: l_terr_WT_target;
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;
865:
866: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
867: p_table_name => l_terr_WT_target
868: , p_percent => 20
869: , x_return_status => x_return_status );
870:

Line 1129: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||

1125: --- [13] ---
1126: -----------
1127: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1128: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [13] Call to ' ||
1129: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
1130: 'for ' || l_winners_target);
1131:
1132: /* Build Index on Winners table */
1133: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_winners_target

Line 1133: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_winners_target

1129: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
1130: 'for ' || l_winners_target);
1131:
1132: /* Build Index on Winners table */
1133: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_winners_target
1134: , p_trans_object_type_id
1135: , p_source_id
1136: , l_return_status );
1137:

Line 1140: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||

1136: , l_return_status );
1137:
1138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1139: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [13] Call to ' ||
1140: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
1141: l_winners_target;
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144:

Line 1150: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||

1146: --- [14] ---
1147: -----------
1148: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1149: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [14] Call to ' ||
1150: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
1151: 'for ' || l_winners_target);
1152:
1153: /* Analyze Winners table */
1154: /* JDOCHERT: 04/10/03: bug#2896552 */

Line 1155: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

1151: 'for ' || l_winners_target);
1152:
1153: /* Analyze Winners table */
1154: /* JDOCHERT: 04/10/03: bug#2896552 */
1155: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
1156: p_table_name => l_winners_target
1157: , p_percent => 20
1158: , x_return_status => x_return_status );
1159:

Line 1162: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||

1158: , x_return_status => x_return_status );
1159:
1160: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1161: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [14] Call to ' ||
1162: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
1163: l_winners_target;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166:

Line 1293: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_trans_target

1289:
1290: END IF; -- what usage
1291:
1292:
1293: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_trans_target
1294: , x_return_status => x_return_status );
1295:
1296: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1297:

Line 1299: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||

1295:
1296: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1297:
1298: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [1] Call to ' ||
1299: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||
1300: l_trans_target;
1301:
1302: RAISE FND_API.G_EXC_ERROR;
1303:

Line 1306: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_matches_target

1302: RAISE FND_API.G_EXC_ERROR;
1303:
1304: END IF;
1305:
1306: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_matches_target
1307: , x_return_status => x_return_status );
1308:
1309: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1310:

Line 1313: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||

1309: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1310:
1311:
1312: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [2] Call to ' ||
1313: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||
1314: l_matches_target;
1315:
1316: RAISE FND_API.G_EXC_ERROR;
1317:

Line 1320: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_winners_target

1316: RAISE FND_API.G_EXC_ERROR;
1317:
1318: END IF;
1319:
1320: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_winners_target
1321: , x_return_status => x_return_status );
1322:
1323: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1324:

Line 1327: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||

1323: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1324:
1325:
1326: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [3] Call to ' ||
1327: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||
1328: l_winners_target;
1329:
1330: RAISE FND_API.G_EXC_ERROR;
1331:

Line 1537: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||

1533: --- [P01] --- TRUNCATE TRANS
1534: -------------
1535: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P01] Call to ' ||
1537: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1538: 'for ' || l_trans_target);
1539:
1540: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1541: p_table_name => l_trans_target

Line 1540: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P01] Call to ' ||
1537: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1538: 'for ' || l_trans_target);
1539:
1540: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1541: p_table_name => l_trans_target
1542: , x_return_status => x_return_status );
1543:
1544: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1546: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

1542: , x_return_status => x_return_status );
1543:
1544: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1545: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P01] Call to ' ||
1546: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1547: l_trans_target;
1548:
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;

Line 1558: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||

1554: --- [P02] --- TRUNCATE MATCHES
1555: -------------
1556: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1557: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P02] Call to ' ||
1558: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1559: 'for ' || l_matches_target);
1560:
1561:
1562: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 1562: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1558: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1559: 'for ' || l_matches_target);
1560:
1561:
1562: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1563: p_table_name => l_matches_target
1564: , x_return_status => x_return_status);
1565:
1566: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 1566: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1562: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1563: p_table_name => l_matches_target
1564: , x_return_status => x_return_status);
1565:
1566: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1567: p_table_name => l_matches_target
1568: , x_return_status => x_return_status );
1569:
1570: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1572: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

1568: , x_return_status => x_return_status );
1569:
1570: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1571: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P02] Call to ' ||
1572: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1573: l_matches_target;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;
1576:

Line 1582: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||

1578: --- [P03] --- TRUNCATE WINNERS
1579: -------------
1580: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1581: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P03] Call to ' ||
1582: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1583: 'for ' || l_winners_target);
1584:
1585: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1586: p_table_name => l_winners_target

Line 1585: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1581: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P03] Call to ' ||
1582: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1583: 'for ' || l_winners_target);
1584:
1585: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1586: p_table_name => l_winners_target
1587: , x_return_status => x_return_status);
1588:
1589: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 1589: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1585: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1586: p_table_name => l_winners_target
1587: , x_return_status => x_return_status);
1588:
1589: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1590: p_table_name => l_winners_target
1591: , x_return_status => x_return_status );
1592:
1593: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1595: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

1591: , x_return_status => x_return_status );
1592:
1593: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1594: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P03] Call to ' ||
1595: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1596: l_winners_target;
1597: RAISE FND_API.G_EXC_ERROR;
1598: END IF;
1599:

Line 1607: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1603: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1604: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1605: 'MULTI-LEVEL TABLE CLEANUP BEGINS...');
1606:
1607: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1608: p_table_name => l_terr_L1_target
1609: , x_return_status => x_return_status);
1610:
1611: ----dbms_output.put_line('10.1: Truncate Level Winners Tables ');

Line 1613: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1609: , x_return_status => x_return_status);
1610:
1611: ----dbms_output.put_line('10.1: Truncate Level Winners Tables ');
1612: -- 10.1: Truncate Level Winners Tables
1613: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1614: p_table_name => l_terr_L1_target
1615: , x_return_status => x_return_status );
1616:
1617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1619: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

1615: , x_return_status => x_return_status );
1616:
1617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1618: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1619: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1620: l_terr_L1_target;
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:

Line 1624: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1620: l_terr_L1_target;
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1625: p_table_name => l_terr_L2_target
1626: , x_return_status => x_return_status);
1627:
1628: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 1628: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1624: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1625: p_table_name => l_terr_L2_target
1626: , x_return_status => x_return_status);
1627:
1628: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1629: p_table_name => l_terr_L2_target
1630: , x_return_status => x_return_status );
1631:
1632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1634: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

1630: , x_return_status => x_return_status );
1631:
1632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1633: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1634: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1635: l_terr_L2_target;
1636: RAISE FND_API.G_EXC_ERROR;
1637: END IF;
1638:

Line 1640: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1636: RAISE FND_API.G_EXC_ERROR;
1637: END IF;
1638:
1639:
1640: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1641: p_table_name => l_terr_L3_target
1642: , x_return_status => x_return_status);
1643:
1644: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 1644: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1640: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1641: p_table_name => l_terr_L3_target
1642: , x_return_status => x_return_status);
1643:
1644: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1645: p_table_name => l_terr_L3_target
1646: , x_return_status => x_return_status );
1647:
1648: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1650: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

1646: , x_return_status => x_return_status );
1647:
1648: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1649: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1650: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1651: l_terr_L3_target;
1652: RAISE FND_API.G_EXC_ERROR;
1653: END IF;
1654:

Line 1655: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1651: l_terr_L3_target;
1652: RAISE FND_API.G_EXC_ERROR;
1653: END IF;
1654:
1655: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1656: p_table_name => l_terr_L4_target
1657: , x_return_status => x_return_status);
1658:
1659: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 1659: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1655: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1656: p_table_name => l_terr_L4_target
1657: , x_return_status => x_return_status);
1658:
1659: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1660: p_table_name => l_terr_L4_target
1661: , x_return_status => x_return_status );
1662:
1663: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1665: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

1661: , x_return_status => x_return_status );
1662:
1663: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1664: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1665: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1666: l_terr_L4_target;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669:

Line 1671: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669:
1670:
1671: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1672: p_table_name => l_terr_L5_target
1673: , x_return_status => x_return_status);
1674:
1675: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 1675: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1671: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1672: p_table_name => l_terr_L5_target
1673: , x_return_status => x_return_status);
1674:
1675: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1676: p_table_name => l_terr_L5_target
1677: , x_return_status => x_return_status );
1678:
1679: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1681: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

1677: , x_return_status => x_return_status );
1678:
1679: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1680: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1681: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1682: l_terr_L5_target;
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685:

Line 1687: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685:
1686:
1687: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1688: p_table_name => l_terr_WT_target
1689: , x_return_status => x_return_status);
1690:
1691: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 1691: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1687: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1688: p_table_name => l_terr_WT_target
1689: , x_return_status => x_return_status);
1690:
1691: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1692: p_table_name => l_terr_WT_target
1693: , x_return_status => x_return_status );
1694:
1695: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1697: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||

1693: , x_return_status => x_return_status );
1694:
1695: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1696: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1697: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1698: l_terr_WT_target;
1699: RAISE FND_API.G_EXC_ERROR;
1700: END IF;
1701:

Line 1707: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API BEGINS ' ||

1703: --- [P04] --- DROP INDEXES for TRANS TABLE ONLY (WE KEEP INDEXES FOR MATCHES AND WINNERS )
1704: -------------
1705: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1706: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P04] Call to ' ||
1707: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API BEGINS ' ||
1708: 'for ' || l_trans_target);
1709:
1710: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_trans_target
1711: , x_return_status => x_return_status );

Line 1710: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_trans_target

1706: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P04] Call to ' ||
1707: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API BEGINS ' ||
1708: 'for ' || l_trans_target);
1709:
1710: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_trans_target
1711: , x_return_status => x_return_status );
1712:
1713: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1714:

Line 1716: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||

1712:
1713: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1714:
1715: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P04] Call to ' ||
1716: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||
1717: l_trans_target;
1718:
1719: RAISE FND_API.G_EXC_ERROR;
1720:

Line 2049: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||

2045: --- [P02] ---
2046: -------------
2047: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2048: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P02] Call to ' ||
2049: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
2050: 'for ' || l_trans_target);
2051:
2052: /* Analyze _TRANS table */
2053: /* JDOCHERT: 04/10/03: bug#2896552 */

Line 2054: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

2050: 'for ' || l_trans_target);
2051:
2052: /* Analyze _TRANS table */
2053: /* JDOCHERT: 04/10/03: bug#2896552 */
2054: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
2055: p_table_name => l_trans_target
2056: , p_percent => 99
2057: , x_return_status => x_return_status );
2058:

Line 2061: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||

2057: , x_return_status => x_return_status );
2058:
2059: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2060: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P02] Call to ' ||
2061: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
2062: l_trans_target;
2063: RAISE FND_API.G_EXC_ERROR;
2064: END IF;
2065:

Line 2103: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||

2099: --- [P04.1] ---
2100: -----------
2101: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2102: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.1] Call to ' ||
2103: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2104: 'for ' || l_matches_target);
2105:
2106: /* Build Index on Winners table */
2107: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_matches_target

Line 2107: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_matches_target

2103: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2104: 'for ' || l_matches_target);
2105:
2106: /* Build Index on Winners table */
2107: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_matches_target
2108: , p_trans_object_type_id
2109: , p_source_id
2110: , l_return_status
2111: , p_target_type);

Line 2115: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||

2111: , p_target_type);
2112:
2113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2114: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.1] Call to ' ||
2115: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2116: l_matches_target;
2117: RAISE FND_API.G_EXC_ERROR;
2118: END IF;
2119:

Line 2122: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||

2118: END IF;
2119:
2120: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2121: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.2] Call to ' ||
2122: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2123: 'for ' || l_winners_target);
2124:
2125: /* Build Index on Winners table */
2126: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_winners_target

Line 2126: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_winners_target

2122: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2123: 'for ' || l_winners_target);
2124:
2125: /* Build Index on Winners table */
2126: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_winners_target
2127: , p_trans_object_type_id
2128: , p_source_id
2129: , l_return_status
2130: , p_target_type );

Line 2134: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||

2130: , p_target_type );
2131:
2132: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2133: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.2] Call to ' ||
2134: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2135: l_winners_target;
2136: RAISE FND_API.G_EXC_ERROR;
2137: END IF;
2138:

Line 2142: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||

2138:
2139:
2140: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2141: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.3] Call to ' ||
2142: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2143: 'for ' || l_terr_L1_target);
2144:
2145: /* Build Index on Winners table */
2146: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L1_target

Line 2146: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L1_target

2142: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2143: 'for ' || l_terr_L1_target);
2144:
2145: /* Build Index on Winners table */
2146: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L1_target
2147: , p_trans_object_type_id
2148: , p_source_id
2149: , l_return_status
2150: , p_target_type );

Line 2154: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||

2150: , p_target_type );
2151:
2152: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2153: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.3] Call to ' ||
2154: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2155: l_terr_L1_target;
2156: RAISE FND_API.G_EXC_ERROR;
2157: END IF;
2158:

Line 2162: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||

2158:
2159:
2160: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2161: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.4] Call to ' ||
2162: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2163: 'for ' || l_terr_L2_target);
2164:
2165: /* Build Index on Winners table */
2166: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L2_target

Line 2166: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L2_target

2162: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2163: 'for ' || l_terr_L2_target);
2164:
2165: /* Build Index on Winners table */
2166: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L2_target
2167: , p_trans_object_type_id
2168: , p_source_id
2169: , l_return_status
2170: , p_target_type );

Line 2174: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||

2170: , p_target_type );
2171:
2172: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2173: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.4] Call to ' ||
2174: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2175: l_terr_L2_target;
2176: RAISE FND_API.G_EXC_ERROR;
2177: END IF;
2178:

Line 2183: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||

2179:
2180:
2181: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2182: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.5] Call to ' ||
2183: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2184: 'for ' || l_terr_L3_target);
2185:
2186: /* Build Index on Winners table */
2187: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L3_target

Line 2187: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L3_target

2183: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2184: 'for ' || l_terr_L3_target);
2185:
2186: /* Build Index on Winners table */
2187: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L3_target
2188: , p_trans_object_type_id
2189: , p_source_id
2190: , l_return_status
2191: , p_target_type );

Line 2195: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||

2191: , p_target_type );
2192:
2193: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2194: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.5] Call to ' ||
2195: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2196: l_terr_L3_target;
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199:

Line 2204: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||

2200:
2201:
2202: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2203: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.6] Call to ' ||
2204: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2205: 'for ' || l_terr_L4_target);
2206:
2207: /* Build Index on Winners table */
2208: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L4_target

Line 2208: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L4_target

2204: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2205: 'for ' || l_terr_L4_target);
2206:
2207: /* Build Index on Winners table */
2208: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L4_target
2209: , p_trans_object_type_id
2210: , p_source_id
2211: , l_return_status
2212: , p_target_type );

Line 2216: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||

2212: , p_target_type );
2213:
2214: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2215: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.6] Call to ' ||
2216: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2217: l_terr_L4_target;
2218: RAISE FND_API.G_EXC_ERROR;
2219: END IF;
2220:

Line 2224: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||

2220:
2221:
2222: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2223: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.7] Call to ' ||
2224: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2225: 'for ' || l_terr_L5_target);
2226:
2227: /* Build Index on Winners table */
2228: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L5_target

Line 2228: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L5_target

2224: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2225: 'for ' || l_terr_L5_target);
2226:
2227: /* Build Index on Winners table */
2228: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_L5_target
2229: , p_trans_object_type_id
2230: , p_source_id
2231: , l_return_status
2232: , p_target_type );

Line 2236: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||

2232: , p_target_type );
2233:
2234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2235: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.7] Call to ' ||
2236: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2237: l_terr_L5_target;
2238: RAISE FND_API.G_EXC_ERROR;
2239: END IF;
2240:

Line 2244: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||

2240:
2241:
2242: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2243: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.8] Call to ' ||
2244: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2245: 'for ' || l_terr_WT_target);
2246:
2247: /* Build Index on Winners table */
2248: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_WT_target

Line 2248: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_WT_target

2244: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2245: 'for ' || l_terr_WT_target);
2246:
2247: /* Build Index on Winners table */
2248: JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX( l_terr_WT_target
2249: , p_trans_object_type_id
2250: , p_source_id
2251: , l_return_status
2252: , p_target_type );

Line 2256: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||

2252: , p_target_type );
2253:
2254: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2255: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.8] Call to ' ||
2256: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2257: l_terr_WT_target;
2258: RAISE FND_API.G_EXC_ERROR;
2259: END IF;
2260:

Line 2586: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||

2582: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2583: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2584: p_worker_id ||
2585: '[P02] Call to ' ||
2586: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
2587: 'for ' || l_matches_target);
2588: /* Analyze Matches table */
2589: /* JDOCHERT: 04/10/03: bug#2896552 */
2590: --dbms_output.put_line('GET_WINNERS_PARALLEL ANALYZING MATCHES TABLE ');

Line 2592: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

2588: /* Analyze Matches table */
2589: /* JDOCHERT: 04/10/03: bug#2896552 */
2590: --dbms_output.put_line('GET_WINNERS_PARALLEL ANALYZING MATCHES TABLE ');
2591:
2592: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
2593: p_table_name => l_matches_target
2594: , p_percent => 20
2595: , x_return_status => x_return_status );
2596: --dbms_output.put_line('GET_WINNERS_PARALLEL ANALYZING MATCHES TABLE ... COMPLETE ');

Line 2601: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||

2597:
2598: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2599: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2600: p_worker_id || '[P02] Call to ' ||
2601: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
2602: l_matches_target;
2603: RAISE FND_API.G_EXC_ERROR;
2604: END IF;
2605:

Line 2633: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

2629: );
2630:
2631: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2632: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.1] Call to ' ||
2633: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2634: l_terr_L1_target;
2635: RAISE FND_API.G_EXC_ERROR;
2636: END IF;
2637:

Line 2641: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

2637:
2638: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2639: COMMIT;
2640:
2641: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
2642: p_table_name => l_terr_L1_target
2643: , p_percent => 20
2644: , x_return_status => x_return_status );
2645:

Line 2659: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

2655: );
2656:
2657: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2658: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.2] Call to ' ||
2659: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2660: l_terr_L2_target;
2661: RAISE FND_API.G_EXC_ERROR;
2662: END IF;
2663:

Line 2667: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

2663:
2664: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2665: COMMIT;
2666:
2667: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
2668: p_table_name => l_terr_L2_target
2669: , p_percent => 20
2670: , x_return_status => x_return_status );
2671:

Line 2685: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

2681: );
2682:
2683: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2684: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [P03] Call to ' ||
2685: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2686: l_terr_L3_target;
2687: RAISE FND_API.G_EXC_ERROR;
2688: END IF;
2689:

Line 2693: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

2689:
2690: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2691: COMMIT;
2692:
2693: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
2694: p_table_name => l_terr_L3_target
2695: , p_percent => 20
2696: , x_return_status => x_return_status );
2697:

Line 2711: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

2707: );
2708:
2709: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2710: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.4] Call to ' ||
2711: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2712: l_terr_L4_target;
2713: RAISE FND_API.G_EXC_ERROR;
2714: END IF;
2715:

Line 2719: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

2715:
2716: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2717: COMMIT;
2718:
2719: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
2720: p_table_name => l_terr_L4_target
2721: , p_percent => 20
2722: , x_return_status => x_return_status );
2723:

Line 2738: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

2734:
2735:
2736: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2737: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.5] Call to ' ||
2738: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2739: l_terr_L5_target;
2740: RAISE FND_API.G_EXC_ERROR;
2741: END IF;
2742:

Line 2746: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

2742:
2743: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2744: COMMIT;
2745:
2746: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
2747: p_table_name => l_terr_L5_target
2748: , p_percent => 20
2749: , x_return_status => x_return_status );
2750:

Line 2763: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||

2759: );
2760:
2761: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2762: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.6] Call to ' ||
2763: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2764: l_terr_WT_target;
2765: RAISE FND_API.G_EXC_ERROR;
2766: END IF;
2767:

Line 2771: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

2767:
2768: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2769: COMMIT;
2770:
2771: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
2772: p_table_name => l_terr_WT_target
2773: , p_percent => 20
2774: , x_return_status => x_return_status );
2775:

Line 3073: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||

3069: --- [P04] --- ANALYZE WINNERS TABLE
3070: -------------
3071: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [P05] Call to ' ||
3073: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
3074: 'for ' || l_winners_target);
3075:
3076: /* Analyze Winners table */
3077: /* JDOCHERT: 04/10/03: bug#2896552 */

Line 3078: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3074: 'for ' || l_winners_target);
3075:
3076: /* Analyze Winners table */
3077: /* JDOCHERT: 04/10/03: bug#2896552 */
3078: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3079: p_table_name => l_winners_target
3080: , p_percent => 20
3081: , x_return_status => x_return_status );
3082:

Line 3085: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||

3081: , x_return_status => x_return_status );
3082:
3083: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3084: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [P05] Call to ' ||
3085: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
3086: l_winners_target;
3087: RAISE FND_API.G_EXC_ERROR;
3088: END IF;
3089:

Line 3876: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE( p_table_name => p_table_name

3872: l_terr_WT_target VARCHAR2(30);
3873: BEGIN
3874:
3875: IF UPPER(p_table_name) LIKE 'JTF_TAE%NM_TRANS' THEN
3876: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE( p_table_name => p_table_name
3877: , x_return_status => x_return_status);
3878: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => p_table_name
3879: , x_return_status => x_return_status);
3880: END IF;

Line 3878: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => p_table_name

3874:
3875: IF UPPER(p_table_name) LIKE 'JTF_TAE%NM_TRANS' THEN
3876: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE( p_table_name => p_table_name
3877: , x_return_status => x_return_status);
3878: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => p_table_name
3879: , x_return_status => x_return_status);
3880: END IF;
3881:
3882: l_source_id := -1001;

Line 3932: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

3928: END IF; -- what usage
3929:
3930: -------------
3931: --- TRUNCATE MATCHES
3932: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3933: p_table_name => l_matches_target
3934: , x_return_status => x_return_status );
3935:
3936: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 3936: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

3932: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3933: p_table_name => l_matches_target
3934: , x_return_status => x_return_status );
3935:
3936: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3937: p_table_name => l_matches_target
3938: , x_return_status => x_return_status);
3939: -------------
3940: --- TRUNCATE WINNERS

Line 3941: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

3937: p_table_name => l_matches_target
3938: , x_return_status => x_return_status);
3939: -------------
3940: --- TRUNCATE WINNERS
3941: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3942: p_table_name => l_winners_target
3943: , x_return_status => x_return_status );
3944:
3945: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 3945: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

3941: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3942: p_table_name => l_winners_target
3943: , x_return_status => x_return_status );
3944:
3945: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3946: p_table_name => l_winners_target
3947: , x_return_status => x_return_status);
3948: -------------
3949: --- Level Tables

Line 3950: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

3946: p_table_name => l_winners_target
3947: , x_return_status => x_return_status);
3948: -------------
3949: --- Level Tables
3950: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3951: p_table_name => l_terr_L1_target
3952: , x_return_status => x_return_status );
3953:
3954: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 3954: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

3950: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3951: p_table_name => l_terr_L1_target
3952: , x_return_status => x_return_status );
3953:
3954: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3955: p_table_name => l_terr_L1_target
3956: , x_return_status => x_return_status);
3957:
3958: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 3958: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

3954: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3955: p_table_name => l_terr_L1_target
3956: , x_return_status => x_return_status);
3957:
3958: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3959: p_table_name => l_terr_L2_target
3960: , x_return_status => x_return_status );
3961:
3962: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 3962: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

3958: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3959: p_table_name => l_terr_L2_target
3960: , x_return_status => x_return_status );
3961:
3962: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3963: p_table_name => l_terr_L2_target
3964: , x_return_status => x_return_status);
3965:
3966: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 3966: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

3962: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3963: p_table_name => l_terr_L2_target
3964: , x_return_status => x_return_status);
3965:
3966: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3967: p_table_name => l_terr_L3_target
3968: , x_return_status => x_return_status );
3969:
3970: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 3970: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

3966: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3967: p_table_name => l_terr_L3_target
3968: , x_return_status => x_return_status );
3969:
3970: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3971: p_table_name => l_terr_L3_target
3972: , x_return_status => x_return_status);
3973:
3974: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 3974: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

3970: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3971: p_table_name => l_terr_L3_target
3972: , x_return_status => x_return_status);
3973:
3974: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3975: p_table_name => l_terr_L4_target
3976: , x_return_status => x_return_status );
3977:
3978: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 3978: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

3974: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3975: p_table_name => l_terr_L4_target
3976: , x_return_status => x_return_status );
3977:
3978: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3979: p_table_name => l_terr_L4_target
3980: , x_return_status => x_return_status);
3981:
3982: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 3982: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

3978: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3979: p_table_name => l_terr_L4_target
3980: , x_return_status => x_return_status);
3981:
3982: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3983: p_table_name => l_terr_L5_target
3984: , x_return_status => x_return_status );
3985:
3986: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 3986: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

3982: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3983: p_table_name => l_terr_L5_target
3984: , x_return_status => x_return_status );
3985:
3986: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3987: p_table_name => l_terr_L5_target
3988: , x_return_status => x_return_status);
3989:
3990: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 3990: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

3986: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3987: p_table_name => l_terr_L5_target
3988: , x_return_status => x_return_status);
3989:
3990: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3991: p_table_name => l_terr_WT_target
3992: , x_return_status => x_return_status );
3993:
3994: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 3994: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

3990: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
3991: p_table_name => l_terr_WT_target
3992: , x_return_status => x_return_status );
3993:
3994: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3995: p_table_name => l_terr_WT_target
3996: , x_return_status => x_return_status);
3997:
3998: x_return_status := FND_API.G_RET_STS_SUCCESS;