276: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
277: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');
278: END IF;
279:
280: l_user_id := FND_GLOBAL.user_id;
281: l_login_id := FND_GLOBAL.login_id;
282: l_global_prim_currency := BIS_COMMON_PARAMETERS.Get_Currency_code ;
283:
284: INSERT/*+ APPEND PARALLEL(QOTHDR)*/ INTO ASO_BI_QUOTE_HDRS_ALL QOTHDR
277: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');
278: END IF;
279:
280: l_user_id := FND_GLOBAL.user_id;
281: l_login_id := FND_GLOBAL.login_id;
282: l_global_prim_currency := BIS_COMMON_PARAMETERS.Get_Currency_code ;
283:
284: INSERT/*+ APPEND PARALLEL(QOTHDR)*/ INTO ASO_BI_QUOTE_HDRS_ALL QOTHDR
285: (quote_number,
379: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
380: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');
381: END IF;
382:
383: l_user_id := FND_GLOBAL.user_id;
384: l_login_id := FND_GLOBAL.login_id;
385:
386: EXECUTE IMMEDIATE
387: 'MERGE INTO ASO_BI_QUOTE_HDRS_ALL QOTHDR
380: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');
381: END IF;
382:
383: l_user_id := FND_GLOBAL.user_id;
384: l_login_id := FND_GLOBAL.login_id;
385:
386: EXECUTE IMMEDIATE
387: 'MERGE INTO ASO_BI_QUOTE_HDRS_ALL QOTHDR
388: USING(SELECT quote_number,