DBA Data[Home] [Help]

APPS.CCT_MQD_PUB dependencies on CCT_KEYVALUE_VARR

Line 15: p_kvp IN cct_keyvalue_varr,

11: p_commit IN VARCHAR2,
12: p_app_id IN NUMBER,
13: p_item_type IN NUMBER,
14: p_classification IN VARCHAR2,
15: p_kvp IN cct_keyvalue_varr,
16: p_server_group_name IN VARCHAR2,
17: p_direction IN VARCHAR2,
18: p_ih_item_type IN VARCHAR2,
19: x_return_status OUT NOCOPY VARCHAR2 ,

Line 181: l_kvp cct_keyvalue_varr := cct_keyvalue_varr();

177: l_msg_data varchar2(256);
178: l_classification varchar2(1024);
179: x_err_num NUMBER;
180: x_err_msg VARCHAR2(256);
181: l_kvp cct_keyvalue_varr := cct_keyvalue_varr();
182: dequeue_options dbms_aq.dequeue_options_t;
183: message_properties dbms_aq.message_properties_t;
184: message_handle RAW(16);
185: message SYSTEM.cct_qde_response;

Line 232: x_kvp := CCT_COLLECTION_UTIL_PUB.CCT_KeyValue_Varr_ToString(message.kvp);

228: x_app_id := 172;
229: x_item_id := message.item_id;
230: x_item_type := message.item_type;
231: x_classification := message.classification;
232: x_kvp := CCT_COLLECTION_UTIL_PUB.CCT_KeyValue_Varr_ToString(message.kvp);
233: exception
234: when no_messages then
235: x_item_id := -1;
236: x_item_type := -1;

Line 262: x_kvp := CCT_COLLECTION_UTIL_PUB.CCT_KeyValue_Varr_ToString(l_kvp);

258: x_item_id => x_item_id,
259: x_item_type => x_item_type,
260: x_classification => x_classification,
261: x_kvp => l_kvp);
262: x_kvp := CCT_COLLECTION_UTIL_PUB.CCT_KeyValue_Varr_ToString(l_kvp);
263: end;
264: end if;
265:
266: --dbms_output.put_line('CCT_MQD_PUB.GET_NEXT_MEDIA_ITEM '