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.AS_INT_TYP_COD_MIGRATION dependencies on AS_INTERESTS_ALL

Line 81: Migrate_AS_INTERESTS_ALL(ERRBUF,

77: p_Debug_Flag);
78: Migrate_AS_LEAD_LINES_LOG(ERRBUF,
79: RETCODE,
80: p_Debug_Flag);
81: Migrate_AS_INTERESTS_ALL(ERRBUF,
82: RETCODE,
83: p_Debug_Flag);
84: Migrate_AS_SALES_C_DENORM(ERRBUF,
85: RETCODE,

Line 756: Migrate product_category_id and product_cat_set_id into AS_INTERESTS_ALL table

752: END IF ;
753: END Migrate_FST_SALES_CATEGORIES;
754:
755: /*
756: Migrate product_category_id and product_cat_set_id into AS_INTERESTS_ALL table
757: */
758: PROCEDURE Migrate_AS_INTERESTS_ALL(
759: ERRBUF OUT NOCOPY VARCHAR2,
760: RETCODE OUT NOCOPY VARCHAR2,

Line 758: PROCEDURE Migrate_AS_INTERESTS_ALL(

754:
755: /*
756: Migrate product_category_id and product_cat_set_id into AS_INTERESTS_ALL table
757: */
758: PROCEDURE Migrate_AS_INTERESTS_ALL(
759: ERRBUF OUT NOCOPY VARCHAR2,
760: RETCODE OUT NOCOPY VARCHAR2,
761: p_Debug_Flag IN VARCHAR2 Default 'N'
762: ) IS

Line 771: from as_interests_all;

767: l_debug BOOLEAN := false;
768:
769: CURSOR Get_Min_Id IS
770: select min(interest_id)
771: from as_interests_all;
772:
773: CURSOR Get_Max_Id IS
774: select max(interest_id)
775: from as_interests_all;

Line 775: from as_interests_all;

771: from as_interests_all;
772:
773: CURSOR Get_Max_Id IS
774: select max(interest_id)
775: from as_interests_all;
776:
777: CURSOR Get_Next_Val IS
778: select AS_INTERESTS_S.nextval
779: from dual;

Line 811: Create_Temp_Index('AS_INTERESTS_ALL','INTEREST_ID,INTEREST_TYPE_ID,PRIMARY_INTEREST_CODE_ID,SECONDARY_INTEREST_CODE_ID',l_debug);

807: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Maximum Id found:' || l_max_id);
808: end if;
809:
810: -- Create temporary index to improve the performance
811: Create_Temp_Index('AS_INTERESTS_ALL','INTEREST_ID,INTEREST_TYPE_ID,PRIMARY_INTEREST_CODE_ID,SECONDARY_INTEREST_CODE_ID',l_debug);
812:
813: -- Initialize counter
814: l_count := l_min_id;
815:

Line 823: update as_interests_all l

819: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Current loop count:' || l_count);
820: end if;
821:
822: -- Update interest type
823: update as_interests_all l
824: set (product_category_id, product_cat_set_id) =
825: (select int.product_category_id, int.product_cat_set_id
826: from as_interest_types_b int
827: where l.interest_type_id = int.interest_type_id)

Line 835: update as_interests_all l

831: and l.primary_interest_code_id is null
832: and l.secondary_interest_code_id is null;
833:
834: -- Update primary interest code
835: update as_interests_all l
836: set (product_category_id, product_cat_set_id) =
837: (select int.product_category_id, int.product_cat_set_id
838: from as_interest_codes_b int
839: where l.primary_interest_code_id = int.interest_code_id)

Line 846: update as_interests_all l

842: and l.primary_interest_code_id is not null
843: and l.secondary_interest_code_id is null;
844:
845: -- Update secondary interest code
846: update as_interests_all l
847: set (product_category_id, product_cat_set_id) =
848: (select int.product_category_id, int.product_cat_set_id
849: from as_interest_codes_b int
850: where l.secondary_interest_code_id = int.interest_code_id)

Line 863: Drop_Temp_Index('AS_INTERESTS_ALL',l_debug);

859: end loop;
860: commit;
861:
862: -- Drop temporary index
863: Drop_Temp_Index('AS_INTERESTS_ALL',l_debug);
864:
865: If l_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Migration for Product Interests finished successfully');
867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 879: END Migrate_AS_INTERESTS_ALL;

875: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
876: IF l_status = TRUE THEN
877: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
878: END IF ;
879: END Migrate_AS_INTERESTS_ALL;
880:
881: /*
882: Migrate product_category_id and product_cat_set_id into AS_LEAD_LINES_LOG table
883: */

Line 1446: update as_interests_all set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;

1442:
1443: /* For testing purposes we can use the following statements.
1444: Change the date as per requirements.
1445: update as_lead_lines_all set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1446: update as_interests_all set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1447: update as_sales_credits_denorm set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1448: update as_lead_lines_log set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1449: update as_fst_sales_categories set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1450: update as_opp_worksheet_lines set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;