DBA Data[Home] [Help]

APPS.CCT_CALLCENTER_UTIL_PUB dependencies on CCT_KEYVALUE_VARR

Line 6: x_param_value out nocopy CCT_KEYVALUE_VARR)

2: /* $Header: cctcutlb.pls 120.0 2005/06/02 09:41:01 appldev noship $ */
3:
4: Procedure getMiddlewareParam(p_resource_id IN Number Default Null,
5: x_middleware_id IN out nocopy Number,
6: x_param_value out nocopy CCT_KEYVALUE_VARR)
7: IS
8:
9: Cursor c_agent_mware(p_agent_id Number)
10: Is

Line 28: l_paramValue CCT_KEYVALUE_VARR:= CCT_KEYVALUE_VARR();

24: and nvl(v.f_deletedflag,'N')<>'D';
25: l_middleware_id Number:=G_MIDDLEWARE_NOT_FOUND;
26: l_param VARCHAR2(255);
27: l_value VARCHAR2(255);
28: l_paramValue CCT_KEYVALUE_VARR:= CCT_KEYVALUE_VARR();
29: l_result VARCHAR2(32);
30: Begin
31: If p_resource_id is not null then
32: Open c_agent_mware(p_resource_id);

Line 76: l_param_value CCT_KEYVALUE_VARR;

72: l_domestic_prefix VARCHAR2(32):=null;
73: l_idd_prefix VARCHAR2(32):=null;
74: l_local_num_max_length VARCHAR2(32):=null;
75:
76: l_param_value CCT_KEYVALUE_VARR;
77: l_middlewarE_id Number;
78: l_defaultDialNumber VARCHAR2(64);
79: l_key_exists VARCHAR2(32);
80: l_value VARCHAR2(32);