APPS.XDP_INTERFACES dependencies on XDP_WF_CHANNELQ_TYPE

Line 24: x_user_data OUT NOCOPY SYSTEM.XDP_WF_CHANNELQ_TYPE,

20: PROCEDURE Lock_and_Remove_Msg(
21: p_msg_id in raw,
22: p_queue_name in varchar2,
23: p_remove_flag in varchar2 DEFAULT 'Y',
24: x_user_data OUT NOCOPY SYSTEM.XDP_WF_CHANNELQ_TYPE,
25: x_lock_status OUT NOCOPY varchar2,
26: x_error OUT NOCOPY varchar2);
27:
28: --

Line 1049: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;

1045: return_code OUT NOCOPY NUMBER,
1046: error_description OUT NOCOPY VARCHAR2) IS
1047:
1048: lv_id NUMBER;
1049: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;
1050: lv_lock_status VARCHAR2(1);
1051: lv_msg_id RAW(16);
1052: lv_error VARCHAR2(1000);
1053: lv_state VARCHAR2(100);

Line 1251: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;

1247: lv_abort_wf BOOLEAN := FALSE;
1248: lv_state VARCHAR2(80);
1249: lv_in_queue VARCHAR2(1) := 'Y';
1250: lv_msg_id RAW(16);
1251: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;
1252: lv_lock_status VARCHAR2(1);
1253: lv_error VARCHAR2(1000);
1254: l_fa_item_key VARCHAR2(300);
1255: l_fa_item_type VARCHAR2(80);

Line 1653: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;

1649: lv_abort_wf BOOLEAN := FALSE;
1650: lv_state VARCHAR2(80);
1651: lv_in_queue VARCHAR2(1) := 'Y';
1652: lv_msg_id RAW(16);
1653: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;
1654: lv_lock_status VARCHAR2(1);
1655: lv_error VARCHAR2(1000);
1656:
1657: CURSOR lc_fa(l_order_id NUMBER) IS

Line 1919: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;

1915: IS
1916: lv_id number;
1917: lv_lock varchar2(1) := 'Y';
1918: lv_state varchar2(100);
1919: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;
1920: lv_lock_status varchar2(1);
1921: lv_error varchar2(1000);
1922:
1923: BEGIN

Line 2008: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;

2004: lv_item_type varchar2(80);
2005: lv_item_key varchar2(300);
2006: lv_state varchar2(100);
2007: lv_lock varchar2(1) := 'Y';
2008: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;
2009: lv_lock_status varchar2(1);
2010: lv_error varchar2(1000);
2011: BEGIN
2012:

Line 2172: x_user_data OUT NOCOPY SYSTEM.XDP_WF_CHANNELQ_TYPE,

2168: PROCEDURE Lock_and_Remove_Msg(
2169: p_msg_id in raw,
2170: p_queue_name in varchar2,
2171: p_remove_flag in varchar2 DEFAULT 'Y',
2172: x_user_data OUT NOCOPY SYSTEM.XDP_WF_CHANNELQ_TYPE,
2173: x_lock_status OUT NOCOPY varchar2,
2174: x_error OUT NOCOPY varchar2)
2175: IS
2176: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;

Line 2179: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;

2175: IS
2176: lv_DequeueOptions DBMS_AQ.DEQUEUE_OPTIONS_T;
2177: lv_MessageProperties DBMS_AQ.MESSAGE_PROPERTIES_T;
2178: lv_MsgID RAW(16);
2179: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;
2180:
2181: BEGIN
2182: if( p_msg_id is NULL ) then
2183: return;

Line 3468: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;

3464: lv_item_type VARCHAR2(80);
3465: lv_item_key VARCHAR2(300);
3466: lv_state VARCHAR2(100);
3467: lv_lock VARCHAR2(1) := 'Y';
3468: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;
3469: lv_lock_status VARCHAR2(1);
3470: lv_error VARCHAR2(1000);
3471: lv_fa_instance_id NUMBER;
3472:

Line 3715: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;

3711: IS
3712: lv_id NUMBER;
3713: lv_lock VARCHAR2(1) := 'Y';
3714: lv_state VARCHAR2(100);
3715: lv_user_data SYSTEM.XDP_WF_CHANNELQ_TYPE;
3716: lv_lock_status VARCHAR2(1);
3717: lv_error VARCHAR2(1000);
3718:
3719: e_xdp_wi_state_inprogress EXCEPTION;