APPS.IBE_BI_PMV_UTIL_PVT dependencies on FND_GLOBAL

Line 51: IF g_all_curr_count = -9999 or fnd_global.user_id <> g_userid THEN

47: IF p_MSITE_ID = 'ALL' THEN
48:
49: -- Check if currency count for ALL stores is cached or not
50: -- Since 'ALL' may mean different stores for different users, we are caching the count and currency code for a given user id
51: IF g_all_curr_count = -9999 or fnd_global.user_id <> g_userid THEN
52:
53: g_userid := fnd_global.user_id;
54:
55: SELECT COUNT(distinct f_curr.currency_code) new_count_number

Line 53: g_userid := fnd_global.user_id;

49: -- Check if currency count for ALL stores is cached or not
50: -- Since 'ALL' may mean different stores for different users, we are caching the count and currency code for a given user id
51: IF g_all_curr_count = -9999 or fnd_global.user_id <> g_userid THEN
52:
53: g_userid := fnd_global.user_id;
54:
55: SELECT COUNT(distinct f_curr.currency_code) new_count_number
56: INTO g_all_curr_count
57: FROM ibe_bi_currency_v f_curr

Line 74: IF g_all_curr_code IS NULL or fnd_global.user_id <> g_userid THEN

70: ELSE
71:
72: -- Check if currency code for all is already in cache or not
73: -- Since 'ALL' may mean different stores for different users, we are caching the count and currency code for a given user id
74: IF g_all_curr_code IS NULL or fnd_global.user_id <> g_userid THEN
75: g_userid := fnd_global.user_id;
76: select distinct currency_code
77: into g_all_curr_code
78: FROM ibe_bi_currency_v f_curr

Line 75: g_userid := fnd_global.user_id;

71:
72: -- Check if currency code for all is already in cache or not
73: -- Since 'ALL' may mean different stores for different users, we are caching the count and currency code for a given user id
74: IF g_all_curr_code IS NULL or fnd_global.user_id <> g_userid THEN
75: g_userid := fnd_global.user_id;
76: select distinct currency_code
77: into g_all_curr_code
78: FROM ibe_bi_currency_v f_curr
79: WHERE currency_code <> g_gp_currency