APPS.CCT_QDE_PUB dependencies on CCT_KEYVALUE_VARR

Line 108: p_kvp IN cct_keyvalue_varr,

104: p_app_id IN NUMBER,
105: p_item_id IN NUMBER,
106: p_item_type IN NUMBER,
107: p_classification IN VARCHAR2,
108: p_kvp IN cct_keyvalue_varr,
109: p_delay IN NUMBER,
110: x_return_status OUT NOCOPY VARCHAR2 ,
111: x_msg_count OUT NOCOPY NUMBER ,
112: x_msg_data OUT NOCOPY VARCHAR2

Line 218: p_kvp IN cct_keyvalue_varr,

214: p_classification IN VARCHAR2,
215: p_route_result IN VARCHAR2,
216: p_is_route_to_all IN VARCHAR2,
217: p_is_reroute IN VARCHAR2,
218: p_kvp IN cct_keyvalue_varr,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2
222: )

Line 235: l_kvp cct_keyvalue_varr;

231: BIT_NOT_SET EXCEPTION;
232: RESOURCE_NOT_LOCKED EXCEPTION;
233: l_route_result VARCHAR2(2000);
234: l_agent_id number;
235: l_kvp cct_keyvalue_varr;
236: enqueue_options dbms_aq.enqueue_options_t;
237: message_properties dbms_aq.message_properties_t;
238: message_handle RAW(16);
239: message SYSTEM.cct_qde_response;

Line 456: x_kvp OUT NOCOPY cct_keyvalue_varr

452: x_app_id OUT NOCOPY NUMBER,
453: x_item_id OUT NOCOPY NUMBER,
454: x_item_type OUT NOCOPY NUMBER,
455: x_classification OUT NOCOPY VARCHAR2,
456: x_kvp OUT NOCOPY cct_keyvalue_varr
457: )
458: IS
459: l_api_name CONSTANT VARCHAR2(30) := 'GET_NEXT_ITEM';
460: l_api_version CONSTANT NUMBER := 1.0;

Line 497: x_kvp := cct_keyvalue_varr();

493: x_msg_data := null;
494: x_item_id := -1;
495: x_item_type := -1;
496: x_classification := null;
497: x_kvp := cct_keyvalue_varr();
498:
499: -- API body
500:
501: --dbms_output.put_line('GET_NEXT_ITEM: agent_id = ' || p_agent_id