APPS.AS_INT_TYP_COD_MIGRATION dependencies on AS_SALES_CREDITS_DENORM

Line 1008: Migrate product_category_id and product_cat_set_id into AS_SALES_CREDITS_DENORM table

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: */
1010: PROCEDURE Migrate_AS_SALES_C_DENORM(
1011: ERRBUF OUT NOCOPY VARCHAR2,
1012: RETCODE OUT NOCOPY VARCHAR2,

Line 1023: from as_sales_credits_denorm;

1019: l_debug BOOLEAN := false;
1020:
1021: CURSOR Get_Min_Id IS
1022: select min(sales_credit_id)
1023: from as_sales_credits_denorm;
1024:
1025: CURSOR Get_Max_Id IS
1026: select max(sales_credit_id)
1027: from as_sales_credits_denorm;

Line 1027: from as_sales_credits_denorm;

1023: from as_sales_credits_denorm;
1024:
1025: CURSOR Get_Max_Id IS
1026: select max(sales_credit_id)
1027: from as_sales_credits_denorm;
1028:
1029: CURSOR Get_Next_Val IS
1030: select AS_SALES_CREDITS_S.nextval
1031: from dual;

Line 1063: Create_Temp_Index('AS_SALES_CREDITS_DENORM','SALES_CREDIT_ID,INTEREST_TYPE_ID,PRIMARY_INTEREST_CODE_ID,SECONDARY_INTEREST_CODE_ID',l_debug);

1059: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Maximum Id found:' || l_max_id);
1060: end if;
1061:
1062: -- Create temporary index to improve the performance
1063: Create_Temp_Index('AS_SALES_CREDITS_DENORM','SALES_CREDIT_ID,INTEREST_TYPE_ID,PRIMARY_INTEREST_CODE_ID,SECONDARY_INTEREST_CODE_ID',l_debug);
1064:
1065: -- Initialize counter
1066: l_count := l_min_id;
1067:

Line 1075: update as_sales_credits_denorm l

1071: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Current loop count:' || l_count);
1072: end if;
1073:
1074: -- Update interest type
1075: update as_sales_credits_denorm l
1076: set (product_category_id, product_cat_set_id) =
1077: (select int.product_category_id, int.product_cat_set_id
1078: from as_interest_types_b int
1079: where l.interest_type_id = int.interest_type_id)

Line 1087: update as_sales_credits_denorm l

1083: and nvl(l.primary_interest_code_id,-1) = -1
1084: and nvl(l.secondary_interest_code_id,-1) = -1;
1085:
1086: -- Update primary interest code
1087: update as_sales_credits_denorm l
1088: set (product_category_id, product_cat_set_id) =
1089: (select int.product_category_id, int.product_cat_set_id
1090: from as_interest_codes_b int
1091: where l.primary_interest_code_id = int.interest_code_id)

Line 1098: update as_sales_credits_denorm l

1094: and nvl(l.primary_interest_code_id,-1) <> -1
1095: and nvl(l.secondary_interest_code_id,-1) = -1;
1096:
1097: -- Update secondary interest code
1098: update as_sales_credits_denorm l
1099: set (product_category_id, product_cat_set_id) =
1100: (select int.product_category_id, int.product_cat_set_id
1101: from as_interest_codes_b int
1102: where l.secondary_interest_code_id = int.interest_code_id)

Line 1115: Drop_Temp_Index('AS_SALES_CREDITS_DENORM',l_debug);

1111: end loop;
1112: commit;
1113:
1114: -- Drop temporary index
1115: Drop_Temp_Index('AS_SALES_CREDITS_DENORM',l_debug);
1116:
1117: If l_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1118: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Migration for Sales Credits finished successfully');
1119: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

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