APPS.BIX_KPI_AGENT_RPT_PKG dependencies on DUAL

Line 39: FROM dual;

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 */
42: SELECT fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY')
43: INTO l_user_curr

Line 44: 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 */
47: g_format_mask := fnd_currency.get_format_mask(l_user_curr, 30);
48:

Line 56: FROM dual;

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 */
59: bix_util_pkg.get_conversion_rate(l_global_curr, l_user_curr, sysdate, l_conv_type,
60: g_denom_rate, g_num_rate, l_status);

Line 514: FROM dual;

510:
511: /* Get the ICX Session Id */
512: SELECT icx_sec.g_session_id
513: INTO g_session_id
514: FROM dual;
515:
516: /* Delete the rows from the table bix_dm_report for the current icx session and report */
517: /* so that we donot display the leftover rows from the previous execution of the report */
518: DELETE bix_dm_report

Line 525: FROM dual;

521:
522: /* Fetch the sysdate */
523: SELECT sysdate
524: INTO g_sysdate
525: FROM dual;
526:
527: /* Get the exchange rate from BIX global currency to user preferred currency */
528: /* This is needed to convert the lead and opportunity amount to user currency */
529: get_exchange_rate();

Line 534: FROM dual;

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 */
537: IF g_time_range IS NULL THEN
538: g_time_range := 1;

Line 556: FROM dual;

552: /* g_agent_group = "not null" : User has navigated to the report from the parameter page */
553: IF (g_parent IS NOT NULL) THEN
554: SELECT TO_NUMBER(substr(g_parent, 2, decode(instr(g_parent,'c'), 0, length(g_parent), instr(g_parent,'c')-2)))
555: INTO l_group_id
556: FROM dual;
557: ELSIF (g_agent_group IS NOT NULL) THEN
558: l_group_id := TO_NUMBER(g_agent_group);
559: ELSE
560: RETURN;

Line 567: FROM dual;

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:
570: /* l_group_id = "null" : user has selected "All" as agent group paramter and (s)he is not assigned to any default group */
571: IF (l_group_id IS NULL) THEN