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.PA_PURGE_SUMMARY dependencies on PA_PROJECT_ACCUM_COMMITMENTS

Line 264: -- Function : Archive and Purge data for table PA_PROJECT_ACCUM_COMMITMENTS

260: -- Start of comments
261: -- API name : PA_ProjAccumCommitments
262: -- Type : Private
263: -- Pre-reqs : None
264: -- Function : Archive and Purge data for table PA_PROJECT_ACCUM_COMMITMENTS
265: -- Parameters : See common list above
266: -- End of comments
267:
268: PROCEDURE PA_ProjAccumCommitments

Line 304: pa_debug.debug( ' ->Before insert into PA_Project_Accum_Commitments') ;

300: -- table and same number deleted from the original table
301:
302: l_commit_size := p_commit_size / 2 ;
303:
304: pa_debug.debug( ' ->Before insert into PA_Project_Accum_Commitments') ;
305:
306: -- The archive table name is different from the original table to limit
307: -- table name to 30 characters.
308:

Line 365: FROM pa_project_accum_commitments pac

361: pac.REQUEST_ID,
362: pac.PROGRAM_APPLICATION_ID,
363: pac.PROGRAM_ID,
364: pac.PROGRAM_UPDATE_DATE
365: FROM pa_project_accum_commitments pac
366: /* commented and modified as below for performance reasons. Archive Purge 11.5
367: WHERE (pac.rowid) IN
368: ( SELECT pac1.rowid
369: FROM pa_project_accum_commitments pac1,

Line 369: FROM pa_project_accum_commitments pac1,

365: FROM pa_project_accum_commitments pac
366: /* commented and modified as below for performance reasons. Archive Purge 11.5
367: WHERE (pac.rowid) IN
368: ( SELECT pac1.rowid
369: FROM pa_project_accum_commitments pac1,
370: pa_project_accum_headers pah
371: WHERE pac1.project_accum_id=pah.project_accum_id
372: AND pah.project_id = p_project_id
373: AND rownum < l_commit_size

Line 388: pa_debug.debug( ' ->After insert into PA_Project_Accum_Commitments') ;

384: /*Code Changes for Bug No.2984871 start */
385: l_NoOfRecordsIns := SQL%ROWCOUNT ;
386: /*Code Changes for Bug No.2984871 end */
387:
388: pa_debug.debug( ' ->After insert into PA_Project_Accum_Commitments') ;
389:
390: /*Code Changes for Bug No.2984871 start */
391: IF l_NoOfRecordsIns > 0 THEN
392: /*Code Changes for Bug No.2984871 end*/

Line 395: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;

391: IF l_NoOfRecordsIns > 0 THEN
392: /*Code Changes for Bug No.2984871 end*/
393: -- The algorithm for deleting records from original table
394: -- depends on whether records are being archived or not.
395: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;
396: /* commented and modified as below for performance reasons. Archive Purge 11.5
397: DELETE FROM pa_project_accum_commitments PAC
398: WHERE (pac.rowid) IN
399: ( SELECT pac1.rowid

Line 397: DELETE FROM pa_project_accum_commitments PAC

393: -- The algorithm for deleting records from original table
394: -- depends on whether records are being archived or not.
395: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;
396: /* commented and modified as below for performance reasons. Archive Purge 11.5
397: DELETE FROM pa_project_accum_commitments PAC
398: WHERE (pac.rowid) IN
399: ( SELECT pac1.rowid
400: FROM pa_project_accum_commitments pac1,
401: PA_PRJ_ACCUM_COMMIT_AR pac2

Line 400: FROM pa_project_accum_commitments pac1,

396: /* commented and modified as below for performance reasons. Archive Purge 11.5
397: DELETE FROM pa_project_accum_commitments PAC
398: WHERE (pac.rowid) IN
399: ( SELECT pac1.rowid
400: FROM pa_project_accum_commitments pac1,
401: PA_PRJ_ACCUM_COMMIT_AR pac2
402: WHERE pac1.project_accum_id = pac2.project_accum_id
403: AND pac2.purge_project_id=p_project_id
404: ) ;

Line 406: DELETE FROM pa_project_accum_commitments PAC

402: WHERE pac1.project_accum_id = pac2.project_accum_id
403: AND pac2.purge_project_id=p_project_id
404: ) ;
405: */
406: DELETE FROM pa_project_accum_commitments PAC
407: WHERE (pac.project_accum_id) IN
408: ( SELECT pac2.project_accum_id
409: FROM PA_PRJ_ACCUM_COMMIT_AR pac2
410: WHERE pac2.purge_project_id=p_project_id

Line 415: pa_debug.debug( ' ->After delete from pa_project_accum_commitments ') ;

411: ) ;
412: /*Code Changes for Bug No.2984871 start */
413: l_NoOfRecordsDel := SQL%ROWCOUNT ;
414: /*Code Changes for Bug No.2984871 end */
415: pa_debug.debug( ' ->After delete from pa_project_accum_commitments ') ;
416: END IF ;
417: ELSE
418:
419: l_commit_size := p_commit_size ;

Line 424: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;

420:
421: -- If the archive option is not selected then the delete will
422: -- be based on the commit size.
423:
424: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;
425: /* commented and modified as below for performance reasons. Archive Purge 11.5
426: DELETE FROM pa_project_accum_commitments pac
427: WHERE (pac.rowid) IN
428: ( SELECT pac1.rowid

Line 426: DELETE FROM pa_project_accum_commitments pac

422: -- be based on the commit size.
423:
424: pa_debug.debug( ' ->Before delete from pa_project_accum_commitments ') ;
425: /* commented and modified as below for performance reasons. Archive Purge 11.5
426: DELETE FROM pa_project_accum_commitments pac
427: WHERE (pac.rowid) IN
428: ( SELECT pac1.rowid
429: FROM pa_project_accum_commitments pac1,
430: pa_project_accum_headers pah

Line 429: FROM pa_project_accum_commitments pac1,

425: /* commented and modified as below for performance reasons. Archive Purge 11.5
426: DELETE FROM pa_project_accum_commitments pac
427: WHERE (pac.rowid) IN
428: ( SELECT pac1.rowid
429: FROM pa_project_accum_commitments pac1,
430: pa_project_accum_headers pah
431: WHERE pac1.project_accum_id=pah.project_accum_id
432: AND pah.project_id = p_project_id
433: AND rownum <= l_commit_size

Line 437: DELETE FROM pa_project_accum_commitments pac

433: AND rownum <= l_commit_size
434: ) ;
435: */
436:
437: DELETE FROM pa_project_accum_commitments pac
438: WHERE (pac.project_accum_id) IN
439: ( SELECT pah.project_accum_id
440: FROM pa_project_accum_headers pah
441: WHERE pah.project_id = p_project_id

Line 449: pa_debug.debug( ' ->After delete from pa_project_accum_commitments ') ;

445: /*Code Changes for Bug No.2984871 start */
446: l_NoOfRecordsDel := SQL%ROWCOUNT ;
447: /*Code Changes for Bug No.2984871 end */
448:
449: pa_debug.debug( ' ->After delete from pa_project_accum_commitments ') ;
450: END IF ;
451:
452: /*Code Changes for Bug No.2984871 start */
453: IF l_NoOfRecordsDel = 0 THEN

Line 469: p_table_name => 'PA_PROJECT_ACCUM_COMMITMENTS',

465: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
466: pa_purge.CommitProcess
467: (p_purge_batch_id => p_purge_batch_id,
468: p_project_id => p_project_id,
469: p_table_name => 'PA_PROJECT_ACCUM_COMMITMENTS',
470: p_NoOfRecordsIns => l_NoOfRecordsIns,
471: p_NoOfRecordsDel => l_NoOfRecordsDel,
472: x_err_code => x_err_code,
473: x_err_stack => x_err_stack,

Line 748: FROM pa_project_accum_commitments pab,

744:
745: --Fix for bug#7701114
746: DELETE FROM pa_project_accum_budgets ppab
747: WHERE (ppab.project_accum_id) IN (SELECT pab.project_accum_id
748: FROM pa_project_accum_commitments pab,
749: pa_project_accum_headers pah
750: WHERE pab.project_accum_id=pah.project_accum_id
751: AND pah.project_id = p_project_id
752: /* 2485577 */ AND pah.project_accum_id <> g_def_proj_accum_id)

Line 1856: pa_debug.debug('*-> About to purge PA_Project_Accum_Commitments ') ;

1852: pa_debug.debug('*-> About to purge Summary data ') ;
1853:
1854: -- Call the procedures to archive/purge data for each summary table
1855: --
1856: pa_debug.debug('*-> About to purge PA_Project_Accum_Commitments ') ;
1857: pa_purge_summary.PA_ProjAccumCommitments
1858: (p_purge_batch_id => p_purge_batch_id,
1859: p_project_id => p_project_id,
1860: p_txn_to_date => p_txn_to_date,