APPS.XDP_AQ_UTILITIES dependencies on XDP_DQ_CONFIGURATION

Line 43: xdp_dq_configuration;

39: exception_queue_name,
40: NVL(max_retries,0) max_retries,
41: is_aq_flag
42: from
43: xdp_dq_configuration;
44:
45: BEGIN
46:
47: p_return_code := 0;

Line 168: xdp_dq_configuration

164: CURSOR lc_aq IS
165: select
166: internal_q_name
167: from
168: xdp_dq_configuration
169: where
170: is_aq_flag = 'Y';
171:
172: BEGIN

Line 195: xdp_dq_configuration

191: CURSOR lc_aq IS
192: select
193: distinct queue_table_name
194: from
195: xdp_dq_configuration
196: where
197: is_aq_flag = 'Y';
198:
199: BEGIN

Line 2062: FROM XDP_dq_configuration

2058: BEGIN
2059:
2060: SELECT state
2061: INTO lv_q_state
2062: FROM XDP_dq_configuration
2063: WHERE internal_q_name = p_queue_name;
2064:
2065: RETURN lv_q_state;
2066:

Line 2091: from xdp_dq_configuration;

2087: IS
2088: lv_exists varchar2(1);
2089: CURSOR lc_q IS
2090: select rowid
2091: from xdp_dq_configuration;
2092:
2093: BEGIN
2094:
2095: p_return_code := 0;

Line 2097: update XDP_dq_configuration

2093: BEGIN
2094:
2095: p_return_code := 0;
2096: if p_queue_name is not null then
2097: update XDP_dq_configuration
2098: set last_updated_by = FND_GLOBAL.USER_ID,
2099: last_update_date = sysdate,
2100: last_update_login = FND_GLOBAL.LOGIN_ID,
2101: state = 'DISABLED'

Line 2105: update XDP_dq_configuration

2101: state = 'DISABLED'
2102: where internal_q_name = UPPER(p_queue_name);
2103: else
2104: FOR lv_rec in lc_q loop
2105: update XDP_dq_configuration
2106: set state = 'DISABLED',
2107: last_updated_by = FND_GLOBAL.USER_ID,
2108: last_update_date = sysdate,
2109: last_update_login = FND_GLOBAL.LOGIN_ID

Line 2134: from xdp_dq_configuration;

2130: IS
2131: lv_exists varchar2(1);
2132: CURSOR lc_q IS
2133: select rowid
2134: from xdp_dq_configuration;
2135:
2136: BEGIN
2137:
2138: p_return_code := 0;

Line 2140: update XDP_dq_configuration

2136: BEGIN
2137:
2138: p_return_code := 0;
2139: if p_queue_name is not null then
2140: update XDP_dq_configuration
2141: set state = 'ENABLED',
2142: last_updated_by = FND_GLOBAL.USER_ID,
2143: last_update_date = sysdate,
2144: last_update_login = FND_GLOBAL.LOGIN_ID

Line 2148: update XDP_dq_configuration

2144: last_update_login = FND_GLOBAL.LOGIN_ID
2145: where internal_q_name = UPPER(p_queue_name);
2146: else
2147: FOR lv_rec IN lc_q LOOP
2148: update XDP_dq_configuration
2149: set state = 'ENABLED',
2150: last_updated_by = FND_GLOBAL.USER_ID,
2151: last_update_date = sysdate,
2152: last_update_login = FND_GLOBAL.LOGIN_ID

Line 2176: from xdp_dq_configuration;

2172: p_error_description OUT NOCOPY VARCHAR2)
2173: IS
2174: CURSOR lc_q IS
2175: select rowid
2176: from xdp_dq_configuration;
2177:
2178: BEGIN
2179: p_return_code := 0;
2180: if p_queue_name is not null then

Line 2181: update XDP_dq_configuration

2177:
2178: BEGIN
2179: p_return_code := 0;
2180: if p_queue_name is not null then
2181: update XDP_dq_configuration
2182: set state = 'SHUTDOWN',
2183: last_updated_by = FND_GLOBAL.USER_ID,
2184: last_update_date = sysdate,
2185: last_update_login = FND_GLOBAL.LOGIN_ID

Line 2189: update XDP_dq_configuration

2185: last_update_login = FND_GLOBAL.LOGIN_ID
2186: where internal_q_name = UPPER(p_queue_name);
2187: else
2188: FOR lv_rec IN lc_q LOOP
2189: update XDP_dq_configuration
2190: set state = 'SHUTDOWN',
2191: last_updated_by = FND_GLOBAL.USER_ID,
2192: last_update_date = sysdate,
2193: last_update_login = FND_GLOBAL.LOGIN_ID