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.AZ_VALIDATE_ACTIVE dependencies on AZ_REQUESTS

Line 24: UPDATE az_requests

20:
21: PROCEDURE validate_transforms AS
22: BEGIN
23:
24: UPDATE az_requests
25: SET active='N'
26: WHERE request_type = 'T'
27: AND selection_set IS NULL;
28:

Line 29: UPDATE az_requests req

25: SET active='N'
26: WHERE request_type = 'T'
27: AND selection_set IS NULL;
28:
29: UPDATE az_requests req
30: SET req.active = (
31: SELECT decode(strct.active, 'N', 'N', NULL, 'N', 'Y')
32: FROM az_structures_b strct
33: WHERE structure_code =

Line 36: FROM az_requests d,

32: FROM az_structures_b strct
33: WHERE structure_code =
34: (SELECT extractvalue(VALUE(e),
35: '/H/V[@N="StructureCode"]/text()')
36: FROM az_requests d,
37: TABLE(xmlsequence(extract(d.selection_set,
38: '/EXT/H/V[@N="StructureCode"]/..'))) e
39: WHERE req.job_name = d.job_name
40: AND req.user_id = d.user_id

Line 53: UPDATE az_requests

49:
50: PROCEDURE validate_loads AS
51: BEGIN
52:
53: UPDATE az_requests
54: SET active='N'
55: WHERE request_type = 'L'
56: AND selection_set IS NULL;
57:

Line 58: UPDATE az_requests req

54: SET active='N'
55: WHERE request_type = 'L'
56: AND selection_set IS NULL;
57:
58: UPDATE az_requests req
59: SET req.active = (
60: SELECT decode(strct.active, 'N', 'N', NULL, 'N', 'Y')
61: FROM az_structures_b strct
62: WHERE structure_code =

Line 65: FROM az_requests d,

61: FROM az_structures_b strct
62: WHERE structure_code =
63: (SELECT extractvalue(VALUE(e),
64: '/H/V[@N="StructureCode"]/text()')
65: FROM az_requests d,
66: TABLE(xmlsequence(extract(d.selection_set,
67: '/EXT/H/V[@N="StructureCode"]/..'))) e
68: WHERE req.job_name = d.job_name
69: AND req.user_id = d.user_id

Line 107: UPDATE az_requests

103: BEGIN
104:
105: activate_apis;
106:
107: UPDATE az_requests
108: SET active='N'
109: WHERE request_type = 'E'
110: AND selection_set IS NULL;
111:

Line 112: UPDATE az_requests

108: SET active='N'
109: WHERE request_type = 'E'
110: AND selection_set IS NULL;
111:
112: UPDATE az_requests
113: SET active = 'N'
114: WHERE request_type = 'E'
115: AND request_phase <> 'C'
116: AND request_status <> 'C'

Line 119: UPDATE az_requests req

115: AND request_phase <> 'C'
116: AND request_status <> 'C'
117: AND selection_set IS NOT NULL;
118:
119: UPDATE az_requests req
120: SET req.active = (
121: SELECT decode(COUNT(api.active), 0, 'N', 'R')
122: FROM az_structures_b strct, az_apis api
123: WHERE strct.structure_code = -- query b

Line 126: FROM az_requests d,

122: FROM az_structures_b strct, az_apis api
123: WHERE strct.structure_code = -- query b
124: (SELECT extractvalue(VALUE(e),
125: '/H/V[@N="StructureCode"]/text()')
126: FROM az_requests d,
127: TABLE(xmlsequence(extract(d.selection_set,
128: '/EXT/H/V[@N="StructureCode"]/..'))) e
129: WHERE req.job_name = d.job_name
130: AND req.user_id = d.user_id

Line 140: FROM az_requests d,

136: FROM az_structure_apis_b
137: WHERE structure_code IN
138: (SELECT extractvalue(VALUE(e),
139: '/H/V[@N="StructureCode"]/text()')
140: FROM az_requests d,
141: TABLE(xmlsequence(extract(d.selection_set,
142: '/EXT/H/V[@N="StructureCode"]/..'))) e
143: WHERE d.job_name = req.job_name
144: AND d.request_type = req.request_type

Line 149: FROM az_requests d,

145: AND d.user_id = req.user_id -- 2's first where
146: AND d.selection_set IS NOT NULL)
147: AND entity_code IN (SELECT extractvalue(VALUE(e),
148: '/H/V[@N="EntityOccuranceCode"]/text()')
149: FROM az_requests d,
150: TABLE(xmlsequence(extract(d.selection_set,
151: '/EXT/H/V[@N="EntityOccuranceCode"]/..'))) e
152: WHERE d.job_name = req.job_name
153: AND d.request_type = req.request_type

Line 162: UPDATE az_requests req

158: AND req.request_phase = 'C'
159: AND req.request_status = 'C'
160: AND req.selection_set IS NOT NULL;
161:
162: UPDATE az_requests req
163: SET req.active = (decode(
164: (SELECT 'Y'
165: FROM az_structures_b strct
166: WHERE structure_code = -- query b

Line 169: FROM az_requests d,

165: FROM az_structures_b strct
166: WHERE structure_code = -- query b
167: (SELECT extractvalue(VALUE(e),
168: '/H/V[@N="StructureCode"]/text()')
169: FROM az_requests d,
170: TABLE(xmlsequence(extract(d.selection_set,
171: '/EXT/H/V[@N="StructureCode"]/..'))) e
172: WHERE req.job_name = d.job_name
173: AND req.user_id = d.user_id

Line 195: UPDATE az_requests

191: BEGIN
192:
193: activate_apis;
194:
195: UPDATE az_requests
196: SET active='N'
197: WHERE selection_set IS NULL
198: AND job_name=p_job_name
199: AND request_type=p_request_type

Line 202: UPDATE az_requests req

198: AND job_name=p_job_name
199: AND request_type=p_request_type
200: AND user_id=p_user_id;
201:
202: UPDATE az_requests req
203: SET req.active = (
204: SELECT decode(COUNT(api.active), 0, 'N', 'R')
205: FROM az_structures_b strct, az_apis api
206: WHERE strct.structure_code = -- query b

Line 209: FROM az_requests d,

205: FROM az_structures_b strct, az_apis api
206: WHERE strct.structure_code = -- query b
207: (SELECT extractvalue(VALUE(e),
208: '/H/V[@N="StructureCode"]/text()')
209: FROM az_requests d,
210: TABLE(xmlsequence(extract(d.selection_set,
211: '/EXT/H/V[@N="StructureCode"]/..'))) e
212: WHERE req.job_name = d.job_name
213: AND req.user_id = d.user_id

Line 223: FROM az_requests d,

219: FROM az_structure_apis_b
220: WHERE structure_code IN
221: (SELECT extractvalue(VALUE(e),
222: '/H/V[@N="StructureCode"]/text()')
223: FROM az_requests d,
224: TABLE(xmlsequence(extract(d.selection_set,
225: '/EXT/H/V[@N="StructureCode"]/..'))) e
226: WHERE d.job_name = req.job_name
227: AND d.request_type = req.request_type

Line 232: FROM az_requests d,

228: AND d.user_id = req.user_id -- 2's first where
229: AND d.selection_set IS NOT NULL)
230: AND entity_code IN (SELECT extractvalue(VALUE(e),
231: '/H/V[@N="EntityOccuranceCode"]/text()')
232: FROM az_requests d,
233: TABLE(xmlsequence(extract(d.selection_set,
234: '/EXT/H/V[@N="EntityOccuranceCode"]/..'))) e
235: WHERE d.job_name = req.job_name
236: AND d.request_type = req.request_type

Line 245: UPDATE az_requests req

241: AND req.job_name=p_job_name
242: AND req.request_type=p_request_type
243: AND req.user_id=p_user_id;
244:
245: UPDATE az_requests req
246: SET req.active = (decode(
247: (SELECT 'Y'
248: FROM az_structures_b strct
249: WHERE structure_code = -- query b

Line 252: FROM az_requests d,

248: FROM az_structures_b strct
249: WHERE structure_code = -- query b
250: (SELECT extractvalue(VALUE(e),
251: '/H/V[@N="StructureCode"]/text()')
252: FROM az_requests d,
253: TABLE(xmlsequence(extract(d.selection_set,
254: '/EXT/H/V[@N="StructureCode"]/..'))) e
255: WHERE req.job_name = d.job_name
256: AND req.user_id = d.user_id

Line 270: FROM az_requests

266: COMMIT;
267:
268: SELECT active
269: INTO v_active
270: FROM az_requests
271: WHERE job_name = p_job_name
272: AND request_type = p_request_type
273: AND user_id = p_user_id;
274: