DBA Data[Home] [Help]

APPS.CCT_AQ_PUB dependencies on CCT_IBMEDIA_TYPE

Line 54: message SYSTEM.cct_ibmedia_type;

50: l_api_version CONSTANT NUMBER := 1.0;
51: enqueue_options dbms_aq.enqueue_options_t;
52: message_properties dbms_aq.message_properties_t;
53: message_handle RAW(16);
54: message SYSTEM.cct_ibmedia_type;
55: final_xml_data1 VARCHAR2(2048);
56: server_group_name_null EXCEPTION;
57: server_group_id_null EXCEPTION;
58: xml_data1_null EXCEPTION;

Line 112: message := SYSTEM.cct_ibmedia_type(SYSDATE,p_server_group_id,p_app_id,final_xml_data1);

108: END IF;
109:
110: final_xml_data1 := p_xml_data1 || ';UUID:' || p_media_type;
111:
112: message := SYSTEM.cct_ibmedia_type(SYSDATE,p_server_group_id,p_app_id,final_xml_data1);
113:
114: --dbms_output.put_line ('ENQUEUE_ITEM: MessageCreated');
115:
116: dbms_aq.enqueue(queue_name => CCT_QUEUE.queue_name,

Line 264: message SYSTEM.cct_ibmedia_type;

260: l_api_version CONSTANT NUMBER := 1.0;
261: dequeue_options dbms_aq.dequeue_options_t;
262: message_properties dbms_aq.message_properties_t;
263: message_handle RAW(16);
264: message SYSTEM.cct_ibmedia_type;
265: server_group_id_null EXCEPTION;
266: no_messages exception;
267: pragma exception_init (no_messages, -25228);
268: