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.QP_PURGE_PRICING_REQUESTS dependencies on QP_DEBUG_REQ

Line 25: SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ

21:
22: IF (l_no_of_days is not null) and (x_request_name is not null) THEN
23: l_request_name := x_request_name || '%';
24:
25: SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ
26: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
27: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
28: request_name like l_request_name;
29:

Line 36: DELETE QP_DEBUG_REQ_LINES WHERE request_id in

32: END IF;
33:
34:
35: LOOP
36: DELETE QP_DEBUG_REQ_LINES WHERE request_id in
37: (SELECT request_id FROM qp_debug_req
38: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
39: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
40: request_name like l_request_name

Line 37: (SELECT request_id FROM qp_debug_req

33:
34:
35: LOOP
36: DELETE QP_DEBUG_REQ_LINES WHERE request_id in
37: (SELECT request_id FROM qp_debug_req
38: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
39: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
40: request_name like l_request_name
41: ) AND rownum <= 500;

Line 50: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in

46: COMMIT;
47: END LOOP;
48:
49: LOOP
50: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
51: (SELECT request_id FROM qp_debug_req
52: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
53: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
54: request_name like l_request_name

Line 51: (SELECT request_id FROM qp_debug_req

47: END LOOP;
48:
49: LOOP
50: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
51: (SELECT request_id FROM qp_debug_req
52: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
53: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
54: request_name like l_request_name
55: ) AND rownum <= 500;

Line 64: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in

60: COMMIT;
61: END LOOP;
62:
63: LOOP
64: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
65: (SELECT request_id FROM qp_debug_req
66: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
67: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
68: request_name like l_request_name

Line 65: (SELECT request_id FROM qp_debug_req

61: END LOOP;
62:
63: LOOP
64: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
65: (SELECT request_id FROM qp_debug_req
66: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
67: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
68: request_name like l_request_name
69: ) AND rownum <= 500;

Line 78: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in

74: COMMIT;
75: END LOOP;
76:
77: LOOP
78: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
79: (SELECT request_id FROM qp_debug_req
80: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
81: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
82: request_name like l_request_name

Line 79: (SELECT request_id FROM qp_debug_req

75: END LOOP;
76:
77: LOOP
78: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
79: (SELECT request_id FROM qp_debug_req
80: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
81: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
82: request_name like l_request_name
83: ) AND rownum <= 500;

Line 93: (SELECT request_id FROM qp_debug_req

89: END LOOP;
90:
91: LOOP
92: DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in
93: (SELECT request_id FROM qp_debug_req
94: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
95: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
96: request_name like l_request_name
97: ) AND rownum <= 500;

Line 107: (SELECT request_id FROM qp_debug_req

103: END LOOP;
104:
105: LOOP
106: DELETE QP_DEBUG_TEXT WHERE request_id in
107: (SELECT request_id FROM qp_debug_req
108: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
109: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
110: request_name like l_request_name
111: ) AND rownum <= 500;

Line 120: DELETE QP_DEBUG_REQ

116: COMMIT;
117: END LOOP;
118:
119: LOOP
120: DELETE QP_DEBUG_REQ
121: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
122: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
123: request_name like l_request_name AND
124: rownum <= 500;

Line 136: SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ

132:
133: ELSIF (l_no_of_days is not null) and (x_request_name is null) THEN
134:
135:
136: SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ
137: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
138: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY');
139:
140: IF l_count = 0 THEN

Line 145: DELETE QP_DEBUG_REQ_LINES WHERE request_id in

141: RAISE NO_DATA_FOUND;
142: END IF;
143:
144: LOOP
145: DELETE QP_DEBUG_REQ_LINES WHERE request_id in
146: (SELECT request_id FROM qp_debug_req
147: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
148: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
149: ) AND rownum <= 500;

Line 146: (SELECT request_id FROM qp_debug_req

142: END IF;
143:
144: LOOP
145: DELETE QP_DEBUG_REQ_LINES WHERE request_id in
146: (SELECT request_id FROM qp_debug_req
147: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
148: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
149: ) AND rownum <= 500;
150:

Line 158: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in

154: COMMIT;
155: END LOOP;
156:
157: LOOP
158: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
159: (SELECT request_id FROM qp_debug_req
160: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
161: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
162: ) AND rownum <= 500;

Line 159: (SELECT request_id FROM qp_debug_req

155: END LOOP;
156:
157: LOOP
158: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
159: (SELECT request_id FROM qp_debug_req
160: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
161: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
162: ) AND rownum <= 500;
163:

Line 171: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in

167: COMMIT;
168: END LOOP;
169:
170: LOOP
171: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
172: (SELECT request_id FROM qp_debug_req
173: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
174: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
175: ) AND rownum <= 500;

Line 172: (SELECT request_id FROM qp_debug_req

168: END LOOP;
169:
170: LOOP
171: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
172: (SELECT request_id FROM qp_debug_req
173: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
174: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
175: ) AND rownum <= 500;
176:

Line 184: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in

180: COMMIT;
181: END LOOP;
182:
183: LOOP
184: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
185: (SELECT request_id FROM qp_debug_req
186: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
187: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
188: ) AND rownum <= 500;

Line 185: (SELECT request_id FROM qp_debug_req

181: END LOOP;
182:
183: LOOP
184: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
185: (SELECT request_id FROM qp_debug_req
186: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
187: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
188: ) AND rownum <= 500;
189:

Line 198: (SELECT request_id FROM qp_debug_req

194: END LOOP;
195:
196: LOOP
197: DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in
198: (SELECT request_id FROM qp_debug_req
199: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
200: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
201: ) AND rownum <= 500;
202:

Line 211: (SELECT request_id FROM qp_debug_req

207: END LOOP;
208:
209: LOOP
210: DELETE QP_DEBUG_TEXT WHERE request_id in
211: (SELECT request_id FROM qp_debug_req
212: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
213: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
214: ) AND rownum <= 500;
215:

Line 223: DELETE QP_DEBUG_REQ

219: COMMIT;
220: END LOOP;
221:
222: LOOP
223: DELETE QP_DEBUG_REQ
224: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
225: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
226: rownum <= 500;
227:

Line 240: SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ

236:
237: l_request_name := x_request_name || '%';
238:
239:
240: SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ
241: WHERE request_name like l_request_name;
242:
243: IF l_count = 0 THEN
244: RAISE NO_DATA_FOUND;

Line 248: DELETE QP_DEBUG_REQ_LINES WHERE request_id in

244: RAISE NO_DATA_FOUND;
245: END IF;
246:
247: LOOP
248: DELETE QP_DEBUG_REQ_LINES WHERE request_id in
249: (SELECT request_id FROM qp_debug_req
250: WHERE request_name like l_request_name
251: ) AND rownum <= 500;
252:

Line 249: (SELECT request_id FROM qp_debug_req

245: END IF;
246:
247: LOOP
248: DELETE QP_DEBUG_REQ_LINES WHERE request_id in
249: (SELECT request_id FROM qp_debug_req
250: WHERE request_name like l_request_name
251: ) AND rownum <= 500;
252:
253: IF SQL%NOTFOUND THEN

Line 260: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in

256: COMMIT;
257: END LOOP;
258:
259: LOOP
260: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
261: (SELECT request_id FROM qp_debug_req
262: WHERE request_name like l_request_name
263: ) AND rownum <= 500;
264:

Line 261: (SELECT request_id FROM qp_debug_req

257: END LOOP;
258:
259: LOOP
260: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
261: (SELECT request_id FROM qp_debug_req
262: WHERE request_name like l_request_name
263: ) AND rownum <= 500;
264:
265: IF SQL%NOTFOUND THEN

Line 272: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in

268: COMMIT;
269: END LOOP;
270:
271: LOOP
272: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
273: (SELECT request_id FROM qp_debug_req
274: WHERE request_name like l_request_name
275: ) AND rownum <= 500;
276:

Line 273: (SELECT request_id FROM qp_debug_req

269: END LOOP;
270:
271: LOOP
272: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
273: (SELECT request_id FROM qp_debug_req
274: WHERE request_name like l_request_name
275: ) AND rownum <= 500;
276:
277: IF SQL%NOTFOUND THEN

Line 284: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in

280: COMMIT;
281: END LOOP;
282:
283: LOOP
284: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
285: (SELECT request_id FROM qp_debug_req
286: WHERE request_name like l_request_name
287: ) AND rownum <= 500;
288:

Line 285: (SELECT request_id FROM qp_debug_req

281: END LOOP;
282:
283: LOOP
284: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
285: (SELECT request_id FROM qp_debug_req
286: WHERE request_name like l_request_name
287: ) AND rownum <= 500;
288:
289: IF SQL%NOTFOUND THEN

Line 297: (SELECT request_id FROM qp_debug_req

293: END LOOP;
294:
295: LOOP
296: DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in
297: (SELECT request_id FROM qp_debug_req
298: WHERE request_name like l_request_name
299: ) AND rownum <= 500;
300:
301: IF SQL%NOTFOUND THEN

Line 309: (SELECT request_id FROM qp_debug_req

305: END LOOP;
306:
307: LOOP
308: DELETE QP_DEBUG_TEXT WHERE request_id in
309: (SELECT request_id FROM qp_debug_req
310: WHERE request_name like l_request_name
311: ) AND rownum <= 500;
312:
313: IF SQL%NOTFOUND THEN

Line 320: DELETE QP_DEBUG_REQ

316: COMMIT;
317: END LOOP;
318:
319: LOOP
320: DELETE QP_DEBUG_REQ
321: WHERE request_name like l_request_name AND
322: rownum <= 500;
323:
324: IF SQL%NOTFOUND THEN

Line 333: SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ;

329:
330:
331: ELSIF (l_no_of_days is null) and (x_request_name is null) THEN
332:
333: SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ;
334:
335: IF l_count = 0 THEN
336: RAISE NO_DATA_FOUND;
337: END IF;

Line 341: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINES';

337: END IF;
338:
339: IF (FND_INSTALLATION.GET_APP_INFO('QP', l_status, l_industry, l_qp_schema)) THEN
340:
341: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINES';
342: EXECUTE IMMEDIATE l_stmt;
343:
344: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LDETS';
345: EXECUTE IMMEDIATE l_stmt;

Line 344: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LDETS';

340:
341: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINES';
342: EXECUTE IMMEDIATE l_stmt;
343:
344: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LDETS';
345: EXECUTE IMMEDIATE l_stmt;
346:
347: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINE_ATTRS';
348: EXECUTE IMMEDIATE l_stmt;

Line 347: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINE_ATTRS';

343:
344: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LDETS';
345: EXECUTE IMMEDIATE l_stmt;
346:
347: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINE_ATTRS';
348: EXECUTE IMMEDIATE l_stmt;
349:
350: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_RLTD_LINES';
351: EXECUTE IMMEDIATE l_stmt;

Line 350: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_RLTD_LINES';

346:
347: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINE_ATTRS';
348: EXECUTE IMMEDIATE l_stmt;
349:
350: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_RLTD_LINES';
351: EXECUTE IMMEDIATE l_stmt;
352:
353: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_FORMULA_STEP_VALUES';
354: EXECUTE IMMEDIATE l_stmt;

Line 359: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ';

355:
356: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_TEXT';
357: EXECUTE IMMEDIATE l_stmt;
358:
359: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ';
360: EXECUTE IMMEDIATE l_stmt;
361:
362: END IF;
363: