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_RESOURCE_ACCUM_DETAILS

Line 1091: -- Function : Archive and Purge data for table PA_Resource_Accum_Details

1087: -- Start of comments
1088: -- API name : PA_ResAccumDetails
1089: -- Type : Private
1090: -- Pre-reqs : None
1091: -- Function : Archive and Purge data for table PA_Resource_Accum_Details
1092: -- Parameters : See common list above
1093: -- End of comments
1094: PROCEDURE pa_resaccumdetails
1095: ( p_purge_batch_id IN NUMBER,

Line 1177: FROM pa_Resource_Accum_Details pad

1173: PROGRAM_APPLICATION_ID,
1174: PROGRAM_ID,
1175: PROGRAM_UPDATE_DATE,
1176: ADW_NOTIFY_FLAG
1177: FROM pa_Resource_Accum_Details pad
1178: WHERE pad.project_id = p_project_id
1179: AND rownum < l_commit_size;
1180: /*Code Changes for Bug No.2984871 start */
1181: l_NoOfRecordsIns := SQL%ROWCOUNT ;

Line 1196: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;

1192: -- joins the original and the archived table on the basis of a
1193: -- unique key and uses rowid of records in original table to hit
1194: -- the records to be deleted
1195:
1196: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;
1197: /* commented and modified as below for performance reasons. Archive Purge 11.5
1198: DELETE FROM pa_resource_accum_details pad
1199: WHERE (pad.rowid) IN
1200: ( SELECT pad1.rowid

Line 1198: DELETE FROM pa_resource_accum_details pad

1194: -- the records to be deleted
1195:
1196: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;
1197: /* commented and modified as below for performance reasons. Archive Purge 11.5
1198: DELETE FROM pa_resource_accum_details pad
1199: WHERE (pad.rowid) IN
1200: ( SELECT pad1.rowid
1201: FROM pa_resource_accum_details pad1,
1202: PA_RES_ACCUM_DETAILS_AR pad2

Line 1201: FROM pa_resource_accum_details pad1,

1197: /* commented and modified as below for performance reasons. Archive Purge 11.5
1198: DELETE FROM pa_resource_accum_details pad
1199: WHERE (pad.rowid) IN
1200: ( SELECT pad1.rowid
1201: FROM pa_resource_accum_details pad1,
1202: PA_RES_ACCUM_DETAILS_AR pad2
1203: WHERE pad1.txn_accum_id = pad2.txn_accum_id
1204: AND pad1.resource_list_assignment_id =
1205: pad2.resource_list_assignment_id

Line 1209: DELETE FROM pa_resource_accum_details pad

1205: pad2.resource_list_assignment_id
1206: AND pad2.purge_project_id=p_project_id
1207: ) ;
1208: */
1209: DELETE FROM pa_resource_accum_details pad
1210: WHERE (pad.txn_accum_id, pad.resource_list_assignment_id) IN
1211: ( SELECT pad2.txn_accum_id, pad2.resource_list_assignment_id
1212: FROM PA_RES_ACCUM_DETAILS_AR pad2
1213: WHERE pad2.purge_project_id=p_project_id

Line 1219: pa_debug.debug( ' ->After delete from pa_resource_accum_details ') ;

1215: /*Code Changes for Bug No.2984871 start */
1216: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1217: /*Code Changes for Bug No.2984871 end */
1218:
1219: pa_debug.debug( ' ->After delete from pa_resource_accum_details ') ;
1220: END IF ;
1221: ELSE
1222:
1223: l_commit_size := p_commit_size ;

Line 1228: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;

1224:
1225: -- If the archive option is not selected then the delete will
1226: -- be based on the commit size.
1227:
1228: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;
1229: /* commented and modified as below for performance reasons. Archive Purge 11.5
1230: DELETE FROM pa_resource_accum_details pad
1231: WHERE (pad.rowid) IN
1232: ( SELECT pad.rowid

Line 1230: DELETE FROM pa_resource_accum_details pad

1226: -- be based on the commit size.
1227:
1228: pa_debug.debug( ' ->Before delete from pa_resource_accum_details ') ;
1229: /* commented and modified as below for performance reasons. Archive Purge 11.5
1230: DELETE FROM pa_resource_accum_details pad
1231: WHERE (pad.rowid) IN
1232: ( SELECT pad.rowid
1233: FROM pa_resource_accum_details pad
1234: WHERE pad.project_id = p_project_id

Line 1233: FROM pa_resource_accum_details pad

1229: /* commented and modified as below for performance reasons. Archive Purge 11.5
1230: DELETE FROM pa_resource_accum_details pad
1231: WHERE (pad.rowid) IN
1232: ( SELECT pad.rowid
1233: FROM pa_resource_accum_details pad
1234: WHERE pad.project_id = p_project_id
1235: AND rownum <= l_commit_size
1236: ) ;
1237: */

Line 1238: DELETE FROM pa_resource_accum_details pad

1234: WHERE pad.project_id = p_project_id
1235: AND rownum <= l_commit_size
1236: ) ;
1237: */
1238: DELETE FROM pa_resource_accum_details pad
1239: WHERE pad.project_id = p_project_id
1240: AND rownum <= l_commit_size;
1241: /*Code Changes for Bug No.2984871 start */
1242: l_NoOfRecordsDel := SQL%ROWCOUNT ;

Line 1244: pa_debug.debug( ' ->After delete from pa_resource_accum_details ') ;

1240: AND rownum <= l_commit_size;
1241: /*Code Changes for Bug No.2984871 start */
1242: l_NoOfRecordsDel := SQL%ROWCOUNT ;
1243: /*Code Changes for Bug No.2984871 end */
1244: pa_debug.debug( ' ->After delete from pa_resource_accum_details ') ;
1245: END IF ;
1246:
1247: /*Code Changes for Bug No.2984871 start */
1248: IF l_NoOfRecordsDel = 0 THEN

Line 1265: p_table_name => 'PA_RESOURCE_ACCUM_DETAILS',

1261: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1262: pa_purge.CommitProcess
1263: (p_purge_batch_id => p_purge_batch_id,
1264: p_project_id => p_project_id,
1265: p_table_name => 'PA_RESOURCE_ACCUM_DETAILS',
1266: p_NoOfRecordsIns => l_NoOfRecordsIns,
1267: p_NoOfRecordsDel => l_NoOfRecordsDel,
1268: x_err_code => x_err_code,
1269: x_err_stack => x_err_stack,

Line 1895: pa_debug.debug('*-> About to purge PA_Resource_Accum_Details ') ;

1891: x_err_stack => x_err_stack,
1892: x_err_stage => x_err_stage
1893: ) ;
1894:
1895: pa_debug.debug('*-> About to purge PA_Resource_Accum_Details ') ;
1896: pa_purge_summary.PA_ResAccumDetails
1897: (p_purge_batch_id => p_purge_batch_id,
1898: p_project_id => p_project_id,
1899: p_txn_to_date => p_txn_to_date,