eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CCT_CALLCENTER_UTIL_PUB dependencies on CCT_COLLECTION_UTIL_PUB

Line 44: l_result:=CCT_COLLECTION_UTIL_PUB.PUT(l_paramValue,l_param,l_value);

40: Open c_mware_params(l_middleware_id);
41:
42: Loop
43: Fetch c_mware_params into l_param,l_value;
44: l_result:=CCT_COLLECTION_UTIL_PUB.PUT(l_paramValue,l_param,l_value);
45: Exit When c_mware_params%NOTFOUND;
46: End loop;
47:
48: Close c_mware_params;

Line 89: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_OVERLAY',l_key_exists);

85: getMiddlewareparam(p_resource_id,l_middleware_id,l_param_value);
86:
87: If l_middleware_id<>G_MIDDLEWARE_NOT_FOUND THEN
88:
89: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_OVERLAY',l_key_exists);
90: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
91: l_site_overlay:=l_value;
92: end if;
93: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'OUTGOING_PREFIX',l_key_exists);

Line 90: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

86:
87: If l_middleware_id<>G_MIDDLEWARE_NOT_FOUND THEN
88:
89: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_OVERLAY',l_key_exists);
90: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
91: l_site_overlay:=l_value;
92: end if;
93: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'OUTGOING_PREFIX',l_key_exists);
94: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

Line 93: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'OUTGOING_PREFIX',l_key_exists);

89: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_OVERLAY',l_key_exists);
90: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
91: l_site_overlay:=l_value;
92: end if;
93: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'OUTGOING_PREFIX',l_key_exists);
94: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
95: l_outgoing_prefix:=l_value;
96: end if;
97: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_AREA_CODE',l_key_exists);

Line 94: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

90: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
91: l_site_overlay:=l_value;
92: end if;
93: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'OUTGOING_PREFIX',l_key_exists);
94: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
95: l_outgoing_prefix:=l_value;
96: end if;
97: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_AREA_CODE',l_key_exists);
98: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

Line 97: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_AREA_CODE',l_key_exists);

93: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'OUTGOING_PREFIX',l_key_exists);
94: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
95: l_outgoing_prefix:=l_value;
96: end if;
97: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_AREA_CODE',l_key_exists);
98: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
99: l_site_area_code:=l_value;
100: end if;
101: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_COUNTRY_CODE',l_key_exists);

Line 98: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

94: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
95: l_outgoing_prefix:=l_value;
96: end if;
97: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_AREA_CODE',l_key_exists);
98: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
99: l_site_area_code:=l_value;
100: end if;
101: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_COUNTRY_CODE',l_key_exists);
102: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

Line 101: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_COUNTRY_CODE',l_key_exists);

97: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_AREA_CODE',l_key_exists);
98: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
99: l_site_area_code:=l_value;
100: end if;
101: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_COUNTRY_CODE',l_key_exists);
102: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
103: l_site_country_code:=l_value;
104: end if;
105: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'DOMESTIC_PREFIX',l_key_exists);

Line 102: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

98: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
99: l_site_area_code:=l_value;
100: end if;
101: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_COUNTRY_CODE',l_key_exists);
102: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
103: l_site_country_code:=l_value;
104: end if;
105: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'DOMESTIC_PREFIX',l_key_exists);
106: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

Line 105: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'DOMESTIC_PREFIX',l_key_exists);

101: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'SITE_COUNTRY_CODE',l_key_exists);
102: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
103: l_site_country_code:=l_value;
104: end if;
105: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'DOMESTIC_PREFIX',l_key_exists);
106: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
107: l_domestic_prefix:=l_value;
108: end if;
109: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'IDD_PREFIX',l_key_exists);

Line 106: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

102: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
103: l_site_country_code:=l_value;
104: end if;
105: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'DOMESTIC_PREFIX',l_key_exists);
106: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
107: l_domestic_prefix:=l_value;
108: end if;
109: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'IDD_PREFIX',l_key_exists);
110: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

Line 109: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'IDD_PREFIX',l_key_exists);

105: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'DOMESTIC_PREFIX',l_key_exists);
106: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
107: l_domestic_prefix:=l_value;
108: end if;
109: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'IDD_PREFIX',l_key_exists);
110: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
111: l_idd_prefix:=l_value;
112: end if;
113: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'LOCAL_NUM_MAX_LENGTH',l_key_exists);

Line 110: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

106: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
107: l_domestic_prefix:=l_value;
108: end if;
109: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'IDD_PREFIX',l_key_exists);
110: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
111: l_idd_prefix:=l_value;
112: end if;
113: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'LOCAL_NUM_MAX_LENGTH',l_key_exists);
114: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

Line 113: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'LOCAL_NUM_MAX_LENGTH',l_key_exists);

109: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'IDD_PREFIX',l_key_exists);
110: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
111: l_idd_prefix:=l_value;
112: end if;
113: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'LOCAL_NUM_MAX_LENGTH',l_key_exists);
114: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
115: l_local_num_max_length:=l_value;
116: end if;
117:

Line 114: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then

110: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
111: l_idd_prefix:=l_value;
112: end if;
113: l_value:=CCT_COLLECTION_UTIL_PUB.GET(l_param_value,'LOCAL_NUM_MAX_LENGTH',l_key_exists);
114: if(l_key_exists=CCT_COLLECTION_UTIL_PUB.G_TRUE) then
115: l_local_num_max_length:=l_value;
116: end if;
117:
118: x_dialableNumber:=TO_NUMBER(L_OUTGOING_PREFIX||To_char(p_country_code)||to_char(p_area_code)||to_char(p_localNumber));