[Home] [Help]
33: g_denom_rate := 1;
34: g_num_rate := 1;
35:
36: /* Get the BIX global currency */
37: SELECT fnd_profile.value('BIX_DM_PREFERRED_CURRENCY')
38: INTO l_global_curr
39: FROM dual;
40:
41: /* Get the user currency */
38: INTO l_global_curr
39: FROM dual;
40:
41: /* Get the user currency */
42: SELECT fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY')
43: INTO l_user_curr
44: FROM dual;
45:
46: /* Get the format mask for the user currency */
50: /* get the exchange rate according to BIX conversion type and sysdate */
51: IF (l_global_curr <> l_user_curr) THEN
52:
53: /* Get the BIX conversion type */
54: SELECT fnd_profile.value('BIX_DM_CURR_CONVERSION_TYPE')
55: INTO l_conv_type
56: FROM dual;
57:
58: /* Get the exchange rate as per sysdate */
445: l_temp_date DATE;
446: BEGIN
447:
448: /* Fetch the icx date format mask ; paramters from and to date is passed to the package in this format */
449: g_nls_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
450:
451: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , Agent Group */
452: /* Site , Classification , Period Indicator , From date and Time , To Date and Time */
453: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
528: /* This is needed to convert the lead and opportunity amount to user currency */
529: get_exchange_rate();
530:
531: /* Get the User preferred time range (1/2 or 1 or 2 or 4 hour or 1 day) */
532: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')
533: INTO g_time_range
534: FROM dual;
535:
536: /* If there is no user prefered time range , set it to 1/2 hour */
561: END IF;
562:
563: /* If the user has selected "All" for agent group paramter , display the default group of the user */
564: IF (l_group_id = -999) THEN
565: SELECT fnd_profile.value('BIX_DM_DEFAULT_GROUP')
566: INTO l_group_id
567: FROM dual;
568: END IF;
569: