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.

[Home] [Help]

APPS.PA_PURGE_SUMMARY dependencies on PA_RESOURCE_ACCUM_DETAILS

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

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

Line 1176: FROM pa_Resource_Accum_Details pad

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

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

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

Line 1197: DELETE FROM pa_resource_accum_details pad

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

Line 1200: FROM pa_resource_accum_details pad1,

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

Line 1208: DELETE FROM pa_resource_accum_details pad

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

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

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

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

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

Line 1229: DELETE FROM pa_resource_accum_details pad

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

Line 1232: FROM pa_resource_accum_details pad

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

Line 1237: DELETE FROM pa_resource_accum_details pad

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

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

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

Line 1264: p_table_name => 'PA_RESOURCE_ACCUM_DETAILS',

1260: pa_debug.debug( ' ->Calling pa_purge.CommitProcess ') ;
1261: pa_purge.CommitProcess
1262: (p_purge_batch_id => p_purge_batch_id,
1263: p_project_id => p_project_id,
1264: p_table_name => 'PA_RESOURCE_ACCUM_DETAILS',
1265: p_NoOfRecordsIns => l_NoOfRecordsIns,
1266: p_NoOfRecordsDel => l_NoOfRecordsDel,
1267: x_err_code => x_err_code,
1268: 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,