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_ACTUALS

Line 807: -- Function : Archive and Purge data for table PA_Project_Accum_Actuals

803: -- Start of comments
804: -- API name : PA_ProjAccumActuals
805: -- Type : Private
806: -- Pre-reqs : None
807: -- Function : Archive and Purge data for table PA_Project_Accum_Actuals
808: -- Parameters : See common list above
809: -- End of comments
810: PROCEDURE pa_projaccumactuals
811: ( p_purge_batch_id IN NUMBER,

Line 954: FROM pa_Project_Accum_Actuals paa

950: REQUEST_ID,
951: PROGRAM_APPLICATION_ID,
952: PROGRAM_ID,
953: PROGRAM_UPDATE_DATE
954: FROM pa_Project_Accum_Actuals paa
955: /* commented and modified as below for performance reasons. Archive Purge 11.5
956: WHERE (paa.rowid) IN
957: (SELECT paa1.rowid FROM pa_project_accum_actuals paa1,
958: pa_project_accum_headers pah

Line 957: (SELECT paa1.rowid FROM pa_project_accum_actuals paa1,

953: PROGRAM_UPDATE_DATE
954: FROM pa_Project_Accum_Actuals paa
955: /* commented and modified as below for performance reasons. Archive Purge 11.5
956: WHERE (paa.rowid) IN
957: (SELECT paa1.rowid FROM pa_project_accum_actuals paa1,
958: pa_project_accum_headers pah
959: WHERE paa1.project_accum_id=pah.project_accum_id
960: AND pah.project_id = p_project_id
961: AND rownum < l_commit_size

Line 976: pa_debug.debug( ' ->After insert into PA_Project_Accum_Actuals') ;

972: /*Code Changes for Bug No.2984871 start */
973: l_NoOfRecordsIns := SQL%ROWCOUNT ;
974: /*Code Changes for Bug No.2984871 end */
975:
976: pa_debug.debug( ' ->After insert into PA_Project_Accum_Actuals') ;
977:
978: IF l_NoOfRecordsIns > 0 THEN
979: -- The algorithm for deleting records from original table
980: -- depends on whether records are being archived or not.

Line 986: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;

982: -- joins the original and the archived table on the basis of a
983: -- unique key and uses rowid of records in original table to hit
984: -- the records to be deleted
985:
986: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;
987: /* commented and modified as below for performance reasons. Archive Purge 11.5
988: DELETE FROM pa_project_accum_actuals paa
989: WHERE (paa.rowid) IN
990: ( SELECT paa1.rowid

Line 988: DELETE FROM pa_project_accum_actuals paa

984: -- the records to be deleted
985:
986: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;
987: /* commented and modified as below for performance reasons. Archive Purge 11.5
988: DELETE FROM pa_project_accum_actuals paa
989: WHERE (paa.rowid) IN
990: ( SELECT paa1.rowid
991: FROM pa_project_accum_Actuals paa1,
992: PA_PRJ_ACCUM_ACTUALS_AR paa2

Line 991: FROM pa_project_accum_Actuals paa1,

987: /* commented and modified as below for performance reasons. Archive Purge 11.5
988: DELETE FROM pa_project_accum_actuals paa
989: WHERE (paa.rowid) IN
990: ( SELECT paa1.rowid
991: FROM pa_project_accum_Actuals paa1,
992: PA_PRJ_ACCUM_ACTUALS_AR paa2
993: WHERE paa1.project_accum_id = paa2.project_accum_id
994: AND paa2.purge_project_id = p_project_id
995: ) ;

Line 997: DELETE FROM pa_project_accum_actuals paa

993: WHERE paa1.project_accum_id = paa2.project_accum_id
994: AND paa2.purge_project_id = p_project_id
995: ) ;
996: */
997: DELETE FROM pa_project_accum_actuals paa
998: WHERE (paa.project_accum_id) IN
999: ( SELECT paa2.project_accum_id
1000: FROM PA_PRJ_ACCUM_ACTUALS_AR paa2
1001: WHERE paa2.purge_project_id = p_project_id

Line 1007: pa_debug.debug( ' ->After delete from pa_project_accum_actuals ') ;

1003: /*Code Changes for Bug No.2984871 start */
1004: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1005: /*Code Changes for Bug No.2984871 end*/
1006:
1007: pa_debug.debug( ' ->After delete from pa_project_accum_actuals ') ;
1008: END IF ;
1009: ELSE
1010:
1011: l_commit_size := p_commit_size ;

Line 1016: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;

1012:
1013: -- If the archive option is not selected then the delete will
1014: -- be based on the commit size.
1015:
1016: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;
1017: /* commented and modified as below for performance reasons. Archive Purge 11.5
1018: DELETE from pa_project_accum_actuals paa
1019: WHERE (paa.rowid) IN
1020: ( SELECT paa1.rowid

Line 1018: DELETE from pa_project_accum_actuals paa

1014: -- be based on the commit size.
1015:
1016: pa_debug.debug( ' ->Before delete from pa_project_accum_actuals ') ;
1017: /* commented and modified as below for performance reasons. Archive Purge 11.5
1018: DELETE from pa_project_accum_actuals paa
1019: WHERE (paa.rowid) IN
1020: ( SELECT paa1.rowid
1021: FROM pa_project_accum_actuals paa1,
1022: pa_project_accum_headers pah

Line 1021: FROM pa_project_accum_actuals paa1,

1017: /* commented and modified as below for performance reasons. Archive Purge 11.5
1018: DELETE from pa_project_accum_actuals paa
1019: WHERE (paa.rowid) IN
1020: ( SELECT paa1.rowid
1021: FROM pa_project_accum_actuals paa1,
1022: pa_project_accum_headers pah
1023: WHERE paa1.project_accum_id=pah.project_accum_id
1024: AND pah.project_id = p_project_id
1025: AND rownum <= l_commit_size

Line 1028: DELETE from pa_project_accum_actuals paa

1024: AND pah.project_id = p_project_id
1025: AND rownum <= l_commit_size
1026: ) ;
1027: */
1028: DELETE from pa_project_accum_actuals paa
1029: WHERE (paa.project_accum_id) IN
1030: ( SELECT pah.project_accum_id
1031: FROM pa_project_accum_headers pah
1032: WHERE pah.project_id = p_project_id

Line 1041: pa_debug.debug( ' ->After delete from pa_project_accum_actuals ') ;

1037: /*Code Changes for Bug No.2984871 start */
1038: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1039: /*Code Changes for Bug No.2984871 end */
1040:
1041: pa_debug.debug( ' ->After delete from pa_project_accum_actuals ') ;
1042: END IF ;
1043:
1044: IF l_NoOfRecordsDel = 0 THEN
1045:

Line 1058: p_table_name => 'PA_PROJECT_ACCUM_ACTUALS',

1054: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1055: pa_purge.CommitProcess
1056: (p_purge_batch_id => p_purge_batch_id,
1057: p_project_id => p_project_id,
1058: p_table_name => 'PA_PROJECT_ACCUM_ACTUALS',
1059: p_NoOfRecordsIns => l_NoOfRecordsIns,
1060: p_NoOfRecordsDel => l_NoOfRecordsDel,
1061: x_err_code => x_err_code,
1062: x_err_stack => x_err_stack,

Line 1869: pa_debug.debug('*-> About to purge PA_Project_Accum_Actuals') ;

1865: x_err_stack => x_err_stack,
1866: x_err_stage => x_err_stage
1867: ) ;
1868:
1869: pa_debug.debug('*-> About to purge PA_Project_Accum_Actuals') ;
1870: pa_purge_summary.PA_ProjAccumActuals
1871: (p_purge_batch_id => p_purge_batch_id,
1872: p_project_id => p_project_id,
1873: p_txn_to_date => p_txn_to_date,