DBA Data[Home] [Help]

APPS.XDP_AQ_UTILITIES dependencies on XDP_ORDER_OBJ

Line 2022: l_OrderObj SYSTEM.XDP_ORDER_OBJ;

2018: p_ObjectType VARCHAR2,
2019: p_ReturnCode OUT NOCOPY NUMBER,
2020: p_ErrorDescription OUT NOCOPY VARCHAR2) IS
2021:
2022: l_OrderObj SYSTEM.XDP_ORDER_OBJ;
2023: l_EnqueueOptions DBMS_AQ.ENQUEUE_OPTIONS_T;
2024: l_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
2025: l_MsgID RAW(16);
2026:

Line 2029: l_OrderObj := SYSTEM.XDP_ORDER_OBJ(

2025: l_MsgID RAW(16);
2026:
2027: BEGIN
2028:
2029: l_OrderObj := SYSTEM.XDP_ORDER_OBJ(
2030: p_OrderID,
2031: p_ObjectType);
2032:
2033: l_EnqueueOptions.visibility := DBMS_AQ.ON_COMMIT;

Line 2034: l_MessageProperties.exception_queue := G_XDP_SCHEMA||'.'||'XDP_ORDER_OBJ_Excep_Q';

2030: p_OrderID,
2031: p_ObjectType);
2032:
2033: l_EnqueueOptions.visibility := DBMS_AQ.ON_COMMIT;
2034: l_MessageProperties.exception_queue := G_XDP_SCHEMA||'.'||'XDP_ORDER_OBJ_Excep_Q';
2035:
2036:
2037: DBMS_AQ.ENQUEUE (
2038: queue_name => G_XDP_SCHEMA||'.'||'XDP_ORDER_OBJ_Q',

Line 2038: queue_name => G_XDP_SCHEMA||'.'||'XDP_ORDER_OBJ_Q',

2034: l_MessageProperties.exception_queue := G_XDP_SCHEMA||'.'||'XDP_ORDER_OBJ_Excep_Q';
2035:
2036:
2037: DBMS_AQ.ENQUEUE (
2038: queue_name => G_XDP_SCHEMA||'.'||'XDP_ORDER_OBJ_Q',
2039: enqueue_options => l_EnqueueOptions,
2040: message_properties => l_MessageProperties,
2041: payload => l_OrderObj,
2042: msgid => l_MsgID);