71: FROM DUAL';
72: */
73:
74: BEGIN
75: IF (FND_PROFILE.DEFINED('BIX_EMAIL_GOAL')) THEN
76: l_cust_resp_time_goal := TO_NUMBER(FND_PROFILE.VALUE('BIX_EMAIL_GOAL'));
77: END IF;
78:
79: IF l_cust_resp_time_goal IS NULL THEN
72: */
73:
74: BEGIN
75: IF (FND_PROFILE.DEFINED('BIX_EMAIL_GOAL')) THEN
76: l_cust_resp_time_goal := TO_NUMBER(FND_PROFILE.VALUE('BIX_EMAIL_GOAL'));
77: END IF;
78:
79: IF l_cust_resp_time_goal IS NULL THEN
80: l_cust_resp_time_goal := 0;
84: l_cust_resp_time_goal := 0;
85: END;
86:
87: BEGIN
88: IF (FND_PROFILE.DEFINED('BIX_EMAIL_SLVL_GOAL')) THEN
89: l_service_level_goal := ROUND(TO_NUMBER(FND_PROFILE.VALUE('BIX_EMAIL_SLVL_GOAL')),1);
90: END IF;
91:
92: IF l_service_level_goal IS NULL THEN
85: END;
86:
87: BEGIN
88: IF (FND_PROFILE.DEFINED('BIX_EMAIL_SLVL_GOAL')) THEN
89: l_service_level_goal := ROUND(TO_NUMBER(FND_PROFILE.VALUE('BIX_EMAIL_SLVL_GOAL')),1);
90: END IF;
91:
92: IF l_service_level_goal IS NULL THEN
93: l_service_level_goal := 0;
100:
101: --
102: --Retrieve the dummy (unidentified) customer id which is used by EMC
103: --
104: IF (FND_PROFILE.DEFINED('IEM_DEFAULT_CUSTOMER_ID')) THEN
105: l_dummy_cust := TO_NUMBER(FND_PROFILE.VALUE('IEM_DEFAULT_CUSTOMER_ID'));
106: END IF;
107:
108: IF l_dummy_cust IS NULL THEN
101: --
102: --Retrieve the dummy (unidentified) customer id which is used by EMC
103: --
104: IF (FND_PROFILE.DEFINED('IEM_DEFAULT_CUSTOMER_ID')) THEN
105: l_dummy_cust := TO_NUMBER(FND_PROFILE.VALUE('IEM_DEFAULT_CUSTOMER_ID'));
106: END IF;
107:
108: IF l_dummy_cust IS NULL THEN
109: l_dummy_cust := -1;