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_BUDGETS

Line 500: -- Function : Archive and Purge data for table PA_Project_Accum_Budgets

496: -- Start of comments
497: -- API name : PA_ProjAccumBudgets
498: -- Type : Private
499: -- Pre-reqs : None
500: -- Function : Archive and Purge data for table PA_Project_Accum_Budgets
501: -- Parameters : See common list above
502: -- End of comments
503: PROCEDURE pa_projaccumbudgets
504: ( p_purge_batch_id IN NUMBER,

Line 678: FROM pa_Project_Accum_Budgets pab

674: REQUEST_ID,
675: PROGRAM_APPLICATION_ID,
676: PROGRAM_ID,
677: PROGRAM_UPDATE_DATE
678: FROM pa_Project_Accum_Budgets pab
679: /* commented and modified as below for performance reasons. Archive Purge 11.5
680: WHERE (pab.rowid) IN
681: (SELECT pab1.rowid FROM pa_project_accum_budgets pab1,
682: Pa_project_accum_headers pah

Line 681: (SELECT pab1.rowid FROM pa_project_accum_budgets pab1,

677: PROGRAM_UPDATE_DATE
678: FROM pa_Project_Accum_Budgets pab
679: /* commented and modified as below for performance reasons. Archive Purge 11.5
680: WHERE (pab.rowid) IN
681: (SELECT pab1.rowid FROM pa_project_accum_budgets pab1,
682: Pa_project_accum_headers pah
683: WHERE pab1.project_accum_id=pah.project_accum_id
684: AND pah.project_id = p_project_id
685: AND rownum < l_commit_size

Line 699: pa_debug.debug( ' ->After insert into PA_Project_Accum_Budgets') ;

695: /*Code Changes for Bug No.2984871 start */
696: l_NoOfRecordsIns := SQL%ROWCOUNT ;
697: /*Code Changes for Bug No.2984871 end */
698:
699: pa_debug.debug( ' ->After insert into PA_Project_Accum_Budgets') ;
700:
701: /*Code Changes for Bug No.2984871 start */
702: IF l_NoOfRecordsIns > 0 THEN
703: /*Code Changes for Bug No.2984871 end */

Line 711: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;

707: -- joins the original and the archived table on the basis of a
708: -- unique key and uses rowid of records in original table to hit
709: -- the records to be deleted
710:
711: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;
712: /* commented and modified as below for performance reasons. Archive Purge 11.5
713: DELETE FROM pa_project_accum_budgets pab
714: WHERE (pab.rowid) IN
715: ( SELECT pab1.rowid

Line 713: DELETE FROM pa_project_accum_budgets pab

709: -- the records to be deleted
710:
711: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;
712: /* commented and modified as below for performance reasons. Archive Purge 11.5
713: DELETE FROM pa_project_accum_budgets pab
714: WHERE (pab.rowid) IN
715: ( SELECT pab1.rowid
716: FROM pa_project_accum_budgets pab1,
717: PA_PRJ_ACCUM_BUDGETS_AR pab2

Line 716: FROM pa_project_accum_budgets pab1,

712: /* commented and modified as below for performance reasons. Archive Purge 11.5
713: DELETE FROM pa_project_accum_budgets pab
714: WHERE (pab.rowid) IN
715: ( SELECT pab1.rowid
716: FROM pa_project_accum_budgets pab1,
717: PA_PRJ_ACCUM_BUDGETS_AR pab2
718: WHERE pab1.project_accum_id = pab2.project_accum_id
719: AND pab1.budget_type_code=pab2.budget_type_code
720: AND pab2.purge_project_id=p_project_id

Line 724: DELETE FROM pa_project_accum_budgets pab

720: AND pab2.purge_project_id=p_project_id
721: ) ;
722: */
723:
724: DELETE FROM pa_project_accum_budgets pab
725: WHERE (pab.project_accum_id) IN
726: ( SELECT pab2.project_accum_id
727: FROM PA_PRJ_ACCUM_BUDGETS_AR pab2
728: WHERE pab.budget_type_code=pab2.budget_type_code

Line 734: pa_debug.debug( ' ->After delete from pa_project_accum_budgets ') ;

730: ) ;
731: /*Code Changes for Bug No.2984871 start */
732: l_NoOfRecordsDel := SQL%ROWCOUNT ;
733: /*Code Changes for Bug No.2984871 end */
734: pa_debug.debug( ' ->After delete from pa_project_accum_budgets ') ;
735: END IF ;
736: ELSE
737:
738: l_commit_size := p_commit_size ;

Line 743: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;

739:
740: -- If the archive option is not selected then the delete will
741: -- be based on the commit size.
742:
743: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;
744:
745: DELETE FROM pa_project_accum_budgets pab
746: WHERE (pab.rowid) IN
747: ( SELECT pab.rowid

Line 745: DELETE FROM pa_project_accum_budgets pab

741: -- be based on the commit size.
742:
743: pa_debug.debug( ' ->Before delete from pa_project_accum_budgets ') ;
744:
745: DELETE FROM pa_project_accum_budgets pab
746: WHERE (pab.rowid) IN
747: ( SELECT pab.rowid
748: FROM pa_project_accum_commitments pab,
749: pa_project_accum_headers pah

Line 758: pa_debug.debug( ' ->After delete from pa_project_accum_budgets ') ;

754: ) ;
755: /*Code Changes for Bug No.2984871 start */
756: l_NoOfRecordsDel := SQL%ROWCOUNT ;
757: /*Code Changes for Bug No.2984871 end */
758: pa_debug.debug( ' ->After delete from pa_project_accum_budgets ') ;
759: END IF ;
760:
761: IF l_NoOfRecordsDel = 0 THEN
762: -- no more records to be purged then we exit the loop.

Line 776: p_table_name => 'PA_PROJECT_ACCUM_BUDGETS',

772: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
773: pa_purge.CommitProcess
774: (p_purge_batch_id => p_purge_batch_id,
775: p_project_id => p_project_id,
776: p_table_name => 'PA_PROJECT_ACCUM_BUDGETS',
777: p_NoOfRecordsIns => l_NoOfRecordsIns,
778: p_NoOfRecordsDel => l_NoOfRecordsDel,
779: x_err_code => x_err_code,
780: x_err_stack => x_err_stack,

Line 1882: pa_debug.debug('*-> About to purge PA_Project_Accum_Budgets ') ;

1878: x_err_stack => x_err_stack,
1879: x_err_stage => x_err_stage
1880: ) ;
1881:
1882: pa_debug.debug('*-> About to purge PA_Project_Accum_Budgets ') ;
1883: pa_purge_summary.PA_ProjAccumBudgets
1884: (p_purge_batch_id => p_purge_batch_id,
1885: p_project_id => p_project_id,
1886: p_txn_to_date => p_txn_to_date,