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 808: -- Function : Archive and Purge data for table PA_Project_Accum_Actuals

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

Line 955: FROM pa_Project_Accum_Actuals paa

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

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

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

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

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

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

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

Line 989: DELETE FROM pa_project_accum_actuals paa

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

Line 992: FROM pa_project_accum_Actuals paa1,

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

Line 998: DELETE FROM pa_project_accum_actuals paa

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

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

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

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

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

Line 1019: DELETE from pa_project_accum_actuals paa

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

Line 1022: FROM pa_project_accum_actuals paa1,

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

Line 1029: DELETE from pa_project_accum_actuals paa

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

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

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

Line 1059: p_table_name => 'PA_PROJECT_ACCUM_ACTUALS',

1055: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1056: pa_purge.CommitProcess
1057: (p_purge_batch_id => p_purge_batch_id,
1058: p_project_id => p_project_id,
1059: p_table_name => 'PA_PROJECT_ACCUM_ACTUALS',
1060: p_NoOfRecordsIns => l_NoOfRecordsIns,
1061: p_NoOfRecordsDel => l_NoOfRecordsDel,
1062: x_err_code => x_err_code,
1063: 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,