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_ENTITY dependencies on QP_ARCH_CRITERIA_HEADERS

Line 26: insert into QP_ARCH_CRITERIA_HEADERS

22: p_result_status VARCHAR2
23: )
24: IS
25: BEGIN
26: insert into QP_ARCH_CRITERIA_HEADERS
27: (request_id,
28: request_name,
29: request_type,
30: source_system,

Line 120: FROM QP_ARCH_CRITERIA_HEADERS

116:
117: -- Get the request id from the archive name
118:
119: SELECT request_id into l_request_id
120: FROM QP_ARCH_CRITERIA_HEADERS
121: WHERE nvl(request_name,'')=p_archive_name
122: and request_type = 'ARCHIVE'
123: and purge_flag = 'N';
124:

Line 172: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y

168: IF SQL%FOUND THEN
169: COMMIT;
170: END IF;
171:
172: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y
173:
174: UPDATE QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y' where request_id =l_request_id;
175: IF SQL%FOUND THEN
176: COMMIT;

Line 174: UPDATE QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y' where request_id =l_request_id;

170: END IF;
171:
172: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y
173:
174: UPDATE QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y' where request_id =l_request_id;
175: IF SQL%FOUND THEN
176: COMMIT;
177: END IF;
178:

Line 187: from QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

183: IF (p_entity_type is not null and p_entity is not null) THEN
184: --Get the count of records matching the purge criteria
185:
186: select count(*) into l_count
187: from QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
188: where c.request_id = a.request_id and
189: a.REQUEST_ID = b.REQUEST_ID
190: and c.purge_flag = 'N'
191: and c.REQUEST_TYPE = 'ARCHIVE'

Line 204: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

200: --Delete from QP_ARCH_LIST_HEADERS_TL
201:
202: LOOP
203: DELETE QP_ARCH_LIST_HEADERS_TL WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from
204: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
205: where c.request_id = a.request_id and
206: a.REQUEST_ID = b.REQUEST_ID
207: and c.purge_flag = 'N'
208: and c.REQUEST_TYPE = 'ARCHIVE'

Line 223: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

219: --Delete from QP_ARCH_LIST_HEADERS_B
220:
221: LOOP
222: DELETE QP_ARCH_LIST_HEADERS_B WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from
223: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
224: where c.request_id = a.request_id and
225: a.REQUEST_ID = b.REQUEST_ID
226: and c.purge_flag = 'N'
227: and c.REQUEST_TYPE = 'ARCHIVE'

Line 242: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

238: --Delete from QP_ARCH_LIST_LINES
239:
240: LOOP
241: DELETE QP_ARCH_LIST_LINES WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from
242: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
243: where c.request_id = a.request_id and
244: a.REQUEST_ID = b.REQUEST_ID
245: and c.purge_flag = 'N'
246: and c.REQUEST_TYPE = 'ARCHIVE'

Line 261: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

257: --Delete from QP_ARCH_PRICING_ATTRIBUTES
258:
259: LOOP
260: DELETE QP_ARCH_PRICING_ATTRIBUTES WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from
261: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
262: where c.request_id = a.request_id and
263: a.REQUEST_ID = b.REQUEST_ID
264: and c.purge_flag = 'N'
265: and c.REQUEST_TYPE = 'ARCHIVE'

Line 281: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

277:
278: LOOP
279: DELETE QP_ARCH_RLTD_MODIFIERS WHERE ARCH_PURG_REQUEST_ID in
280: (select c.request_id from
281: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
282: where c.request_id = a.request_id and
283: a.REQUEST_ID = b.REQUEST_ID
284: and c.purge_flag = 'N'
285: and c.REQUEST_TYPE = 'ARCHIVE'

Line 304: QP_ARCH_CRITERIA_HEADERS c

300: DELETE QP_ARCH_QUALIFIERS WHERE ARCH_PURG_REQUEST_ID in
301: (select c.request_id from
302: QP_ARCH_CRITERIA_LINES a ,
303: QP_ARCH_CRITERIA_LINES b ,
304: QP_ARCH_CRITERIA_HEADERS c
305: where c.request_id = a.request_id and
306: a.REQUEST_ID = b.REQUEST_ID
307: and c.purge_flag = 'N'
308: and c.REQUEST_TYPE = 'ARCHIVE'

Line 320: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y

316: END IF;
317: COMMIT;
318: END LOOP;
319:
320: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y
321:
322: LOOP
323: update QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y' WHERE request_id in (select c.request_id from
324: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

Line 323: update QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y' WHERE request_id in (select c.request_id from

319:
320: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y
321:
322: LOOP
323: update QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y' WHERE request_id in (select c.request_id from
324: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
325: where c.request_id = a.request_id and
326: a.REQUEST_ID = b.REQUEST_ID
327: and c.purge_flag = 'N'

Line 324: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

320: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y
321:
322: LOOP
323: update QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y' WHERE request_id in (select c.request_id from
324: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
325: where c.request_id = a.request_id and
326: a.REQUEST_ID = b.REQUEST_ID
327: and c.purge_flag = 'N'
328: and c.REQUEST_TYPE = 'ARCHIVE'

Line 349: SELECT count(*) into l_count FROM QP_ARCH_CRITERIA_HEADERS

345: IF (p_archive_start_date is not null and p_archive_end_date is not null) THEN
346:
347: --Get the count of records matching the purge criteria
348:
349: SELECT count(*) into l_count FROM QP_ARCH_CRITERIA_HEADERS
350: WHERE trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date)) and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code;
351:
352: IF l_count = 0 THEN
353: RAISE NO_DATA_FOUND;

Line 360: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS

356: --Delete from QP_ARCH_LIST_HEADERS_TL
357:
358: LOOP
359: DELETE QP_ARCH_LIST_HEADERS_TL
360: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS
361: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
362: and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code)
363: AND rownum <= 500;
364:

Line 375: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS

371: --Delete from QP_ARCH_LIST_HEADERS_B
372:
373: LOOP
374: DELETE QP_ARCH_LIST_HEADERS_B
375: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS
376: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
377: and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code)
378: AND rownum <= 500;
379:

Line 390: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS

386: --Delete from QP_ARCH_LIST_LINES
387:
388: LOOP
389: DELETE QP_ARCH_LIST_LINES
390: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS
391: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
392: and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code)
393: AND rownum <= 500;
394:

Line 405: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS

401: --Delete from QP_ARCH_PRICING_ATTRIBUTES
402:
403: LOOP
404: DELETE QP_ARCH_PRICING_ATTRIBUTES
405: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS
406: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
407: and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code)
408: AND rownum <= 500;
409:

Line 420: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS

416: --Delete from QP_ARCH_RLTD_MODIFIERS
417:
418: LOOP
419: DELETE QP_ARCH_RLTD_MODIFIERS
420: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS
421: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
422: and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code)
423: AND rownum <= 500;
424:

Line 435: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS

431: --Delete from QP_ARCH_QUALIFIERS
432:
433: LOOP
434: DELETE QP_ARCH_QUALIFIERS
435: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS
436: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
437: and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code)
438: AND rownum <= 500;
439:

Line 446: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y

442: END IF;
443: COMMIT;
444: END LOOP;
445:
446: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y
447:
448: LOOP
449: update QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y'
450: WHERE request_id in (select request_id from QP_ARCH_CRITERIA_HEADERS

Line 449: update QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y'

445:
446: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y
447:
448: LOOP
449: update QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y'
450: WHERE request_id in (select request_id from QP_ARCH_CRITERIA_HEADERS
451: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
452: and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code)
453: AND rownum <= 500;

Line 450: WHERE request_id in (select request_id from QP_ARCH_CRITERIA_HEADERS

446: --Update the purge_flag in the QP_ARCH_CRITERIA_HEADERS table to Y
447:
448: LOOP
449: update QP_ARCH_CRITERIA_HEADERS set PURGE_FLAG = 'Y'
450: WHERE request_id in (select request_id from QP_ARCH_CRITERIA_HEADERS
451: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
452: and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code)
453: AND rownum <= 500;
454:

Line 471: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES

467: commit;
468:
469: fnd_file.put_line(FND_FILE.LOG,'Purge completed successfully');
470:
471: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES
472:
473: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,
474: p_archive_start_date,p_archive_end_date,
475: l_user_id,l_conc_request_id,'S');

Line 483: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES

479:
480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN
482:
483: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES
484:
485: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,
486: p_archive_start_date,p_archive_end_date,
487: l_user_id,l_conc_request_id,'W');

Line 495: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES

491: retcode := 1;
492:
493: WHEN OTHERS THEN
494:
495: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES
496:
497: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,
498: p_archive_start_date,p_archive_end_date,
499: l_user_id,l_conc_request_id,'F');