DBA Data[Home] [Help]

APPS.WF_QUEUE dependencies on WF_MESSAGE_PAYLOAD_T

Line 1958: l_message system.wf_message_payload_t;

1954: l_url varchar2(4000);
1955: l_error_msg varchar2(240);
1956:
1957: l_more_data BOOLEAN := TRUE;
1958: l_message system.wf_message_payload_t;
1959: dequeue_options dbms_aq.dequeue_options_t;
1960: message_properties dbms_aq.message_properties_t;
1961: ii number := 0;
1962: l_loc number := 1;

Line 2578: ** Create a generic queue with the object type of WF_MESSAGE_PAYLOAD_T which

2574: END Generic_Queue_Update;
2575:
2576:
2577: /*
2578: ** Create a generic queue with the object type of WF_MESSAGE_PAYLOAD_T which
2579: ** is basically just a clob
2580: */
2581: procedure create_generic_queue
2582: (p_protocol IN VARCHAR2,

Line 2617: queue_payload_type => 'SYSTEM.WF_MESSAGE_PAYLOAD_T',

2613: ** Create New Queue Table
2614: */
2615: dbms_aqadm.create_queue_table (
2616: queue_table => wf_core.translate('WF_SCHEMA')||'.'||'WF_'||p_protocol||'_'||substr(p_inbound_outbound, 1, 1)||'_'||to_char(ii)||'_TABLE',
2617: queue_payload_type => 'SYSTEM.WF_MESSAGE_PAYLOAD_T',
2618: storage_clause => 'storage (initial 1m next 1m pctincrease 0 )',
2619: sort_list => 'PRIORITY,ENQ_TIME',
2620: comment => wf_core.translate('WORKFLOW_USER_QUEUE_TABLE')||' - '||
2621: wf_core.translate('WF_SCHEMA')||'.'||'WF_'||p_protocol||'_'||substr(p_inbound_outbound, 1, 1)||'_'||to_char(ii)||'_TABLE');

Line 2670: ** delete a generic queue with the object type of WF_MESSAGE_PAYLOAD_T which

2666:
2667: end create_generic_queue;
2668:
2669: /*
2670: ** delete a generic queue with the object type of WF_MESSAGE_PAYLOAD_T which
2671: ** is basically just a clob
2672: */
2673: procedure delete_generic_queue
2674: (p_protocol IN VARCHAR2,