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 FND_DATE

Line 73: fnd_date.canonical_to_date(p_archive_start_date));

69: parameter_value)
70: values
71: (p_conc_request_id,
72: 'ARCHIVE_START_DATE',
73: fnd_date.canonical_to_date(p_archive_start_date));
74:
75: insert into QP_ARCH_CRITERIA_LINES
76: (request_id,
77: parameter_name,

Line 81: fnd_date.canonical_to_date(p_archive_end_date));

77: parameter_name,
78: parameter_value)
79: values(p_conc_request_id,
80: 'ARCHIVE_END_DATE',
81: fnd_date.canonical_to_date(p_archive_end_date));
82:
83: END IF;
84:
85: END INSERT_CRITERIA;

Line 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;

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;
354: END IF;

Line 361: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))

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:
365: IF SQL%NOTFOUND THEN

Line 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)

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:
365: IF SQL%NOTFOUND THEN
366: EXIT;

Line 376: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))

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:
380: IF SQL%NOTFOUND THEN

Line 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)

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:
380: IF SQL%NOTFOUND THEN
381: EXIT;

Line 391: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))

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:
395: IF SQL%NOTFOUND THEN

Line 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)

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:
395: IF SQL%NOTFOUND THEN
396: EXIT;

Line 406: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))

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:
410: IF SQL%NOTFOUND THEN

Line 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)

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:
410: IF SQL%NOTFOUND THEN
411: EXIT;

Line 421: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))

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:
425: IF SQL%NOTFOUND THEN

Line 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)

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:
425: IF SQL%NOTFOUND THEN
426: EXIT;

Line 436: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))

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:
440: IF SQL%NOTFOUND THEN

Line 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)

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:
440: IF SQL%NOTFOUND THEN
441: EXIT;

Line 451: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))

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:
455: IF SQL%NOTFOUND THEN

Line 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)

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:
455: IF SQL%NOTFOUND THEN
456: EXIT;