[Home] [Help]
30:
31: --IF G_Debug AND p_debug_source = G_DEBUG_TRIGGER THEN
32: -- Write debug message to message stack
33: IF l_debug THEN
34: AS_UTILITY_PVT.Debug_Message(p_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, p_mssg);
35: END IF;
36: --END IF;
37:
38: IF p_debug_source = G_DEBUG_CONCURRENT THEN
205:
206: BEGIN
207: RETCODE := 0;
208: --Code modified for bug12771336
209: INSERT /*+ PARALLEL(SCD, as_utility_pvt.get_degree_parallelism) APPEND */ into as_sales_credits_denorm SCD
210: (sales_credit_id,
211: last_update_date,
212: last_updated_by,
213: creation_date,
321: opp_worst_forecast_amount,
322: opp_forecast_amount,
323: opp_best_forecast_amount
324: )
325: Select /*+ PARALLEL(SC, as_utility_pvt.get_degree_parallelism) USE_HASH(LEAD, CUST) */ sc.sales_credit_id,
326:
327:
328:
329: sysdate,
723: END Bulk_update_sc_Denorm;
724:
725: PROCEDURE Refresh_SC_Denorm(ERRBUF OUT NOCOPY varchar2, RETCODE OUT NOCOPY varchar2) IS
726: CURSOR scd_columns IS
727: SELECT /*+ PARALLEL(scdh, as_utility_pvt.get_degree_parallelism) */ sales_credit_id,
728: cust.party_name,
729: cmptr.party_name,
730: cust.party_type,
731: arlkp.meaning customer_category,
928: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'PREFERRED_CURRENCY used: '||G_PREFERRED_CURRENCY);
929: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'CONVERSION_TYPE used: '||G_CONVERSION_TYPE);
930: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'PERIOD_TYPE used: '||G_PERIOD_TYPE);
931:
932: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'DEGREE OF PARALLELISM used: '||as_utility_pvt.get_degree_parallelism);
933: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
934: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM REUSE STORAGE';
935: clear_snapshots;
936: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
933: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
934: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM REUSE STORAGE';
935: clear_snapshots;
936: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
937: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
938: IF (RETCODE = 0) THEN
939: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
940: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
941: COMMIT;
936: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
937: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
938: IF (RETCODE = 0) THEN
939: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
940: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
941: COMMIT;
942: END IF;
943: IF (RETCODE = 0) THEN
944: insert_scd (ERRBUF, RETCODE, l_scd_cnt);
945: COMMIT;
946: END IF;
947: IF (RETCODE = 0) THEN
948: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Building indexes on AS_SALES_CREDITS_DENORM');
949: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);
950: COMMIT;
951: END IF;
952: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Total records inserted into AS_SALES_CREDITS_DENORMS = ' || l_scd_cnt);
953: ELSIF (p_mode = 2) THEN