eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_AQ_UTILITIES dependencies on XDP_WF_CHANNELQ_TYPE

Line 227: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

223: p_priority IN NUMBER DEFAULT 100,
224: p_return_code OUT NOCOPY NUMBER,
225: p_error_description OUT NOCOPY VARCHAR2)
226: IS
227: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
228: lv_EnqueueOptions DBMS_AQ.ENQUEUE_OPTIONS_T;
229: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
230: lv_MsgID RAW(16);
231: lv_date date := sysdate;

Line 236: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE(

232:
233: BEGIN
234:
235: p_return_code := 0;
236: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE(
237: NULL,
238: NULL,
239: NULL,
240: NULL,

Line 297: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

293: -- Dequeue an order from the pending order queue
294: --
295: PROCEDURE Pending_Order_DQ
296: IS
297: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
298: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
299: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
300: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
301: lv_MsgID RAW(16);

Line 298: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

294: --
295: PROCEDURE Pending_Order_DQ
296: IS
297: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
298: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
299: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
300: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
301: lv_MsgID RAW(16);
302: lv_return_code NUMBER;

Line 468: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

464: p_correlation_id IN VARCHAR2,
465: x_message_key OUT NOCOPY VARCHAR2,
466: x_queue_timed_out OUT NOCOPY VARCHAR2 )
467: IS
468: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
469: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
470: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
471: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
472: lv_MsgID RAW(16);

Line 469: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

465: x_message_key OUT NOCOPY VARCHAR2,
466: x_queue_timed_out OUT NOCOPY VARCHAR2 )
467: IS
468: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
469: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
470: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
471: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
472: lv_MsgID RAW(16);
473: lv_return_code NUMBER;

Line 626: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

622: p_wf_item_type IN varchar2,
623: p_wf_item_key IN Varchar2)
624:
625: IS
626: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
627: lv_EnqueueOptions DBMS_AQ.ENQUEUE_OPTIONS_T;
628: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
629: lv_MsgID RAW(16);
630:

Line 635: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE(

631: lv_date date := sysdate;
632:
633: BEGIN
634:
635: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE(
636: NULL,
637: NULL,
638: p_wf_item_type,
639: p_wf_item_key,

Line 699: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

695: -- Dequeue from order processor queue
696: --
697: PROCEDURE Start_OrderProcessor_Workflow
698: IS
699: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
700: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
701: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
702: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
703: lv_MsgID RAW(16);

Line 700: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

696: --
697: PROCEDURE Start_OrderProcessor_Workflow
698: IS
699: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
700: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
701: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
702: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
703: lv_MsgID RAW(16);
704: lv_return_code NUMBER;

Line 820: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

816: x_message_key OUT NOCOPY VARCHAR2,
817: x_queue_timed_out OUT NOCOPY VARCHAR2 )
818:
819: IS
820: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
821: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
822: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
823: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
824: lv_MsgID RAW(16);

Line 821: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

817: x_queue_timed_out OUT NOCOPY VARCHAR2 )
818:
819: IS
820: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
821: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
822: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
823: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
824: lv_MsgID RAW(16);
825: lv_return_code NUMBER;

Line 915: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

911: p_return_code OUT NOCOPY NUMBER,
912: p_error_description OUT NOCOPY VARCHAR2)
913:
914: IS
915: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
916: lv_EnqueueOptions DBMS_AQ.ENQUEUE_OPTIONS_T;
917: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
918: lv_MsgID RAW(16);
919: lv_date date := sysdate;

Line 933: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE(

929:
930: BEGIN
931:
932: p_return_code := 0;
933: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE(
934: NULL,
935: NULL,
936: p_wf_item_type,
937: p_wf_item_key,

Line 988: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

984: -- Dequeue from workitem queue
985: --
986: Procedure Start_Workitem_Workflow
987: IS
988: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
989: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
990: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
991: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
992: lv_MsgID RAW(16);

Line 989: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

985: --
986: Procedure Start_Workitem_Workflow
987: IS
988: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
989: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
990: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
991: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
992: lv_MsgID RAW(16);
993: lv_return_code NUMBER;

Line 1111: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

1107: p_correlation_id IN VARCHAR2,
1108: x_message_key OUT NOCOPY VARCHAR2,
1109: x_queue_timed_out OUT NOCOPY VARCHAR2 )
1110: IS
1111: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1112: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
1113: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
1114: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1115: lv_MsgID RAW(16);

Line 1112: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

1108: x_message_key OUT NOCOPY VARCHAR2,
1109: x_queue_timed_out OUT NOCOPY VARCHAR2 )
1110: IS
1111: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1112: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
1113: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
1114: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1115: lv_MsgID RAW(16);
1116:

Line 1220: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

1216: p_priority in number default 100,
1217: p_return_code OUT NOCOPY NUMBER,
1218: p_error_description OUT NOCOPY VARCHAR2)
1219: IS
1220: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1221: lv_EnqueueOptions DBMS_AQ.ENQUEUE_OPTIONS_T;
1222: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1223: lv_MsgID RAW(16);
1224: lv_date date := sysdate;

Line 1238: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE

1234:
1235: BEGIN
1236: p_return_code := 0;
1237:
1238: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE
1239: ( NULL,
1240: NULL,
1241: p_wf_item_type,
1242: p_wf_item_key,

Line 1290: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

1286: -- through dequeue
1287: --
1288: PROCEDURE Start_FA_Workflow
1289: IS
1290: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1291: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
1292: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
1293: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1294: lv_MsgID RAW(16);

Line 1291: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

1287: --
1288: PROCEDURE Start_FA_Workflow
1289: IS
1290: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1291: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
1292: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
1293: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1294: lv_MsgID RAW(16);
1295: lv_return_code NUMBER;

Line 1405: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

1401: p_correlation_id IN VARCHAR2,
1402: x_message_key OUT NOCOPY VARCHAR2,
1403: x_queue_timed_out OUT NOCOPY VARCHAR2 )
1404: IS
1405: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1406: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
1407: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
1408: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1409: lv_MsgID RAW(16);

Line 1406: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

1402: x_message_key OUT NOCOPY VARCHAR2,
1403: x_queue_timed_out OUT NOCOPY VARCHAR2 )
1404: IS
1405: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1406: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
1407: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
1408: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1409: lv_MsgID RAW(16);
1410:

Line 1499: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

1495: p_fa_instance_id IN number,
1496: p_return_code OUT NOCOPY NUMBER,
1497: p_error_description OUT NOCOPY VARCHAR2) IS
1498:
1499: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1500: lv_EnqueueOptions DBMS_AQ.ENQUEUE_OPTIONS_T;
1501: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1502: lv_MsgID RAW(16);
1503: lv_jobNum NUMBER;

Line 1508: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE(

1504:
1505: BEGIN
1506:
1507: p_return_code := 0;
1508: lv_wf_object := SYSTEM.XDP_WF_CHANNELQ_TYPE(
1509: p_channel_name,
1510: p_fe_name,
1511: p_wf_item_type,
1512: p_wf_item_key,

Line 1555: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

1551: -- through dequeue
1552: --
1553: PROCEDURE Resume_Next_WF IS
1554:
1555: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1556: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
1557: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1558: lv_MsgID RAW(16);
1559: lv_return_code NUMBER;

Line 1688: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

1684: p_correlation_id IN VARCHAR2,
1685: x_message_key OUT NOCOPY VARCHAR2,
1686: x_queue_timed_out OUT NOCOPY VARCHAR2 )
1687: IS
1688: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
1689: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
1690: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
1691: lv_MsgID RAW(16);
1692:

Line 2975: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

2971: p_correlation_id IN VARCHAR2 )
2972:
2973: IS
2974:
2975: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
2976: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
2977: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
2978: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
2979: lv_MsgID RAW(16);

Line 2976: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

2972:
2973: IS
2974:
2975: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
2976: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
2977: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
2978: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
2979: lv_MsgID RAW(16);
2980: lv_return_code NUMBER;

Line 3042: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

3038: p_correlation_id IN VARCHAR2 )
3039:
3040: IS
3041:
3042: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
3043: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
3044: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
3045: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
3046: lv_MsgID RAW(16);

Line 3043: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

3039:
3040: IS
3041:
3042: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
3043: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
3044: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
3045: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
3046: lv_MsgID RAW(16);
3047: lv_return_code NUMBER;

Line 3118: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

3114: p_correlation_id IN VARCHAR2 )
3115:
3116: IS
3117:
3118: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
3119: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
3120: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
3121: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
3122: lv_MsgID RAW(16);

Line 3119: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;

3115:
3116: IS
3117:
3118: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
3119: lv_tmp SYSTEM.XDP_WF_CHANNELQ_TYPE;
3120: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
3121: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
3122: lv_MsgID RAW(16);
3123: lv_return_code NUMBER;

Line 3213: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

3209: p_correlation_id IN VARCHAR2 )
3210:
3211: IS
3212:
3213: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
3214: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
3215: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
3216: lv_MsgID RAW(16);
3217: lv_return_code NUMBER;

Line 3767: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;

3763: */
3764: PROCEDURE DQ_XDP_WF_CHANNEL_REPROCESS
3765:
3766: IS
3767: lv_wf_object SYSTEM.XDP_WF_CHANNELQ_TYPE;
3768: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
3769: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
3770: lv_MsgID RAW(16);
3771: lv_queue_timed_out VARCHAR2(1);