APPS.ASO_ORDER_FEEDBACK_UPDATE_PVT dependencies on DBMS_AQ

Line 1844: l_eopt dbms_aq.enqueue_options_t;

1840: p_app_short_name IN VARCHAR2
1841: )
1842: IS
1843: l_enq_msgid RAW(16);
1844: l_eopt dbms_aq.enqueue_options_t;
1845: l_mprop dbms_aq.message_properties_t;
1846: l_expiration VARCHAR2(30);
1847: queue_name VARCHAR2(30);
1848: BEGIN

Line 1845: l_mprop dbms_aq.message_properties_t;

1841: )
1842: IS
1843: l_enq_msgid RAW(16);
1844: l_eopt dbms_aq.enqueue_options_t;
1845: l_mprop dbms_aq.message_properties_t;
1846: l_expiration VARCHAR2(30);
1847: queue_name VARCHAR2(30);
1848: BEGIN
1849:

Line 1854: l_mprop.expiration := dbms_aq.NEVER;

1850: FND_PROFILE.GET('ASO_OF_RETENTION_TIME', l_expiration);
1851: if l_expiration is not null then
1852: l_mprop.expiration := to_number(l_expiration);
1853: else
1854: l_mprop.expiration := dbms_aq.NEVER;
1855: end if;
1856:
1857: if p_queue_type = 'OF_QUEUE' then
1858: l_eopt.visibility := dbms_aq.ON_COMMIT;

Line 1858: l_eopt.visibility := dbms_aq.ON_COMMIT;

1854: l_mprop.expiration := dbms_aq.NEVER;
1855: end if;
1856:
1857: if p_queue_type = 'OF_QUEUE' then
1858: l_eopt.visibility := dbms_aq.ON_COMMIT;
1859: queue_name := ASO_QUEUE.ASO_OF_Q;
1860: ASO_CRM_Recipients(l_mprop.recipient_list);
1861: else
1862: queue_name := ASO_QUEUE.ASO_OF_EXCP_Q;

Line 1865: l_eopt.visibility := dbms_aq.IMMEDIATE;

1861: else
1862: queue_name := ASO_QUEUE.ASO_OF_EXCP_Q;
1863: l_mprop.recipient_list(0) := sys.aq$_agent(p_app_short_name, NULL, NULL);
1864: if p_commit = FND_API.G_TRUE then
1865: l_eopt.visibility := dbms_aq.IMMEDIATE;
1866: else
1867: l_eopt.visibility := dbms_aq.ON_COMMIT;
1868: end if;
1869: end if;

Line 1867: l_eopt.visibility := dbms_aq.ON_COMMIT;

1863: l_mprop.recipient_list(0) := sys.aq$_agent(p_app_short_name, NULL, NULL);
1864: if p_commit = FND_API.G_TRUE then
1865: l_eopt.visibility := dbms_aq.IMMEDIATE;
1866: else
1867: l_eopt.visibility := dbms_aq.ON_COMMIT;
1868: end if;
1869: end if;
1870:
1871: if l_mprop.recipient_list.COUNT >0 then

Line 1872: dbms_aq.enqueue (

1868: end if;
1869: end if;
1870:
1871: if l_mprop.recipient_list.COUNT >0 then
1872: dbms_aq.enqueue (
1873: queue_name => queue_name,
1874: enqueue_options => l_eopt,
1875: message_properties => l_mprop,
1876: payload => p_aso_order_feedback_type,

Line 1884: p_recipient_list OUT NOCOPY /* file.sql.39 change */ DBMS_AQ.aq$_recipient_list_t

1880: END ASO_Order_Feedback_ENQ;
1881:
1882: PROCEDURE ASO_CRM_Recipients
1883: (
1884: p_recipient_list OUT NOCOPY /* file.sql.39 change */ DBMS_AQ.aq$_recipient_list_t
1885: )
1886: IS
1887: l_lookup_code VARCHAR2(30);
1888: l_app_info BOOLEAN;