APPS.AS_INT_TYP_COD_MIGRATION dependencies on AS_FST_SALES_CATEGORIES

Line 653: Migrate product_category_id and product_cat_set_id into AS_FST_SALES_CATEGORIES table

649: END IF ;
650: END Migrate_AS_LEAD_LINES_ALL;
651:
652: /*
653: Migrate product_category_id and product_cat_set_id into AS_FST_SALES_CATEGORIES table
654: */
655: PROCEDURE Migrate_FST_SALES_CATEGORIES(
656: ERRBUF OUT NOCOPY VARCHAR2,
657: RETCODE OUT NOCOPY VARCHAR2,

Line 668: from as_fst_sales_categories;

664: l_debug BOOLEAN := false;
665:
666: CURSOR Get_Min_Id IS
667: select min(fst_sales_category_id)
668: from as_fst_sales_categories;
669:
670: CURSOR Get_Max_Id IS
671: select max(fst_sales_category_id)
672: from as_fst_sales_categories;

Line 672: from as_fst_sales_categories;

668: from as_fst_sales_categories;
669:
670: CURSOR Get_Max_Id IS
671: select max(fst_sales_category_id)
672: from as_fst_sales_categories;
673:
674: CURSOR Get_Next_Val IS
675: select AS_FST_SALES_CATEGORIES_S.nextval
676: from dual;

Line 675: select AS_FST_SALES_CATEGORIES_S.nextval

671: select max(fst_sales_category_id)
672: from as_fst_sales_categories;
673:
674: CURSOR Get_Next_Val IS
675: select AS_FST_SALES_CATEGORIES_S.nextval
676: from dual;
677:
678: BEGIN
679: -- First load the schema name

Line 708: Create_Temp_Index('AS_FST_SALES_CATEGORIES','FST_SALES_CATEGORY_ID,INTEREST_TYPE_ID',l_debug);

704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Maximum Id found:' || l_max_id);
705: end if;
706:
707: -- Create temporary index to improve the performance
708: Create_Temp_Index('AS_FST_SALES_CATEGORIES','FST_SALES_CATEGORY_ID,INTEREST_TYPE_ID',l_debug);
709:
710: -- Initialize counter
711: l_count := l_min_id;
712:

Line 720: update as_fst_sales_categories l

716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Current loop count:' || l_count);
717: end if;
718:
719: -- Update interest type
720: update as_fst_sales_categories l
721: set (product_category_id, product_cat_set_id) =
722: (select int.product_category_id, int.product_cat_set_id
723: from as_interest_types_b int
724: where l.interest_type_id = int.interest_type_id)

Line 737: Drop_Temp_Index('AS_FST_SALES_CATEGORIES',l_debug);

733: end loop;
734: commit;
735:
736: -- Drop temporary index
737: Drop_Temp_Index('AS_FST_SALES_CATEGORIES',l_debug);
738:
739: If l_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
740: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Migration for Forecast Categories finished successfully');
741: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

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;
1453: */