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_LEAD_LINES_LOG

Line 78: Migrate_AS_LEAD_LINES_LOG(ERRBUF,

74: p_Debug_Flag);
75: Migrate_FST_SALES_CATEGORIES(ERRBUF,
76: RETCODE,
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,

Line 882: Migrate product_category_id and product_cat_set_id into AS_LEAD_LINES_LOG table

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: */
884: PROCEDURE Migrate_AS_LEAD_LINES_LOG(
885: ERRBUF OUT NOCOPY VARCHAR2,
886: RETCODE OUT NOCOPY VARCHAR2,

Line 884: PROCEDURE Migrate_AS_LEAD_LINES_LOG(

880:
881: /*
882: Migrate product_category_id and product_cat_set_id into AS_LEAD_LINES_LOG table
883: */
884: PROCEDURE Migrate_AS_LEAD_LINES_LOG(
885: ERRBUF OUT NOCOPY VARCHAR2,
886: RETCODE OUT NOCOPY VARCHAR2,
887: p_Debug_Flag IN VARCHAR2 Default 'N'
888: ) IS

Line 897: from as_lead_lines_log;

893: l_debug BOOLEAN := false;
894:
895: CURSOR Get_Min_Id IS
896: select min(log_id)
897: from as_lead_lines_log;
898:
899: CURSOR Get_Max_Id IS
900: select max(log_id)
901: from as_lead_lines_log;

Line 901: from as_lead_lines_log;

897: from as_lead_lines_log;
898:
899: CURSOR Get_Max_Id IS
900: select max(log_id)
901: from as_lead_lines_log;
902:
903: CURSOR Get_Next_Val IS
904: select AS_LEAD_LINES_LOG_S.nextval
905: from dual;

Line 904: select AS_LEAD_LINES_LOG_S.nextval

900: select max(log_id)
901: from as_lead_lines_log;
902:
903: CURSOR Get_Next_Val IS
904: select AS_LEAD_LINES_LOG_S.nextval
905: from dual;
906:
907: BEGIN
908: -- First load the schema name

Line 937: Create_Temp_Index('AS_LEAD_LINES_LOG','LOG_ID,INTEREST_TYPE_ID,PRIMARY_INTEREST_CODE_ID,SECONDARY_INTEREST_CODE_ID',l_debug);

933: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Maximum Id found:' || l_max_id);
934: end if;
935:
936: -- Create temporary index to improve the performance
937: Create_Temp_Index('AS_LEAD_LINES_LOG','LOG_ID,INTEREST_TYPE_ID,PRIMARY_INTEREST_CODE_ID,SECONDARY_INTEREST_CODE_ID',l_debug);
938:
939: -- Initialize counter
940: l_count := l_min_id;
941:

Line 949: update as_lead_lines_log l

945: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Current loop count:' || l_count);
946: end if;
947:
948: -- Update interest type
949: update as_lead_lines_log l
950: set (product_category_id, product_cat_set_id) =
951: (select int.product_category_id, int.product_cat_set_id
952: from as_interest_types_b int
953: where l.interest_type_id = int.interest_type_id)

Line 961: update as_lead_lines_log l

957: and l.primary_interest_code_id is null
958: and l.secondary_interest_code_id is null;
959:
960: -- Update primary interest code
961: update as_lead_lines_log l
962: set (product_category_id, product_cat_set_id) =
963: (select int.product_category_id, int.product_cat_set_id
964: from as_interest_codes_b int
965: where l.primary_interest_code_id = int.interest_code_id)

Line 972: update as_lead_lines_log l

968: and l.primary_interest_code_id is not null
969: and l.secondary_interest_code_id is null;
970:
971: -- Update secondary interest code
972: update as_lead_lines_log l
973: set (product_category_id, product_cat_set_id) =
974: (select int.product_category_id, int.product_cat_set_id
975: from as_interest_codes_b int
976: where l.secondary_interest_code_id = int.interest_code_id)

Line 989: Drop_Temp_Index('AS_LEAD_LINES_LOG',l_debug);

985: end loop;
986: commit;
987:
988: -- Drop temporary index
989: Drop_Temp_Index('AS_LEAD_LINES_LOG',l_debug);
990:
991: If l_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
992: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Migration for Opportunity Logs finished successfully');
993: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 1005: END Migrate_AS_LEAD_LINES_LOG;

1001: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1002: IF l_status = TRUE THEN
1003: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1004: END IF ;
1005: END Migrate_AS_LEAD_LINES_LOG;
1006:
1007: /*
1008: Migrate product_category_id and product_cat_set_id into AS_SALES_CREDITS_DENORM table
1009: */

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

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;
1451: update as_prod_worksheet_lines set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1452: commit;