DBA Data[Home] [Help]

APPS.ASO_BI_QUOTE_FACT_PVT dependencies on FND_GLOBAL

Line 280: l_user_id := FND_GLOBAL.user_id;

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

Line 281: l_login_id := FND_GLOBAL.login_id;

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,

Line 383: l_user_id := FND_GLOBAL.user_id;

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

Line 384: l_login_id := FND_GLOBAL.login_id;

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,