DBA Data[Home] [Help]

APPS.JTF_FM_UTL_V dependencies on DBMS_AQ

Line 1193: l_enqueue_options dbms_aq.enqueue_options_t;

1189: l_login_user_id NUMBER := -1;
1190: l_login_user_status NUMBER;
1191: l_Error_Msg VARCHAR2(32767);
1192: l_request_queue VARCHAR2(50) := NULL;
1193: l_enqueue_options dbms_aq.enqueue_options_t;
1194: l_message_properties dbms_aq.message_properties_t;
1195: l_message_handle RAW(16);
1196: l_message VARCHAR2(32767) := '';
1197: l_dtd VARCHAR2(32767);

Line 1194: l_message_properties dbms_aq.message_properties_t;

1190: l_login_user_status NUMBER;
1191: l_Error_Msg VARCHAR2(32767);
1192: l_request_queue VARCHAR2(50) := NULL;
1193: l_enqueue_options dbms_aq.enqueue_options_t;
1194: l_message_properties dbms_aq.message_properties_t;
1195: l_message_handle RAW(16);
1196: l_message VARCHAR2(32767) := '';
1197: l_dtd VARCHAR2(32767);
1198: l_mesg RAW(32767);

Line 1668: dbms_aq.enqueue(queue_name => l_request_queue,

1664: JTF_FM_UTL_V.PRINT_MESSAGE('set the priority',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1665:
1666: -- Enqueue the request in to the Request queue for the fulfillment Processor
1667:
1668: dbms_aq.enqueue(queue_name => l_request_queue,
1669: enqueue_options => l_enqueue_options,
1670: message_properties => l_message_properties,
1671: payload => l_mesg, msgid => l_message_handle);
1672: