APPS.PA_PURGE_SUMMARY dependencies on PA_RES_ACCUM_DETAILS_AR

Line 1131: pa_debug.debug( ' ->Before insert into PA_RES_ACCUM_DETAILS_AR') ;

1127:
1128: l_commit_size := p_commit_size / 2 ;
1129:
1130:
1131: pa_debug.debug( ' ->Before insert into PA_RES_ACCUM_DETAILS_AR') ;
1132:
1133: INSERT INTO PA_RES_ACCUM_DETAILS_AR
1134: (
1135: PURGE_BATCH_ID,

Line 1133: INSERT INTO PA_RES_ACCUM_DETAILS_AR

1129:
1130:
1131: pa_debug.debug( ' ->Before insert into PA_RES_ACCUM_DETAILS_AR') ;
1132:
1133: INSERT INTO PA_RES_ACCUM_DETAILS_AR
1134: (
1135: PURGE_BATCH_ID,
1136: PURGE_RELEASE,
1137: PURGE_PROJECT_ID,

Line 1184: pa_debug.debug( ' ->After insert into PA_RES_ACCUM_DETAILS_AR') ;

1180: /*Code Changes for Bug No.2984871 start */
1181: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1182: /*Code Changes for Bug No.2984871 end */
1183:
1184: pa_debug.debug( ' ->After insert into PA_RES_ACCUM_DETAILS_AR') ;
1185:
1186: /*Code Changes for Bug No.2984871 start */
1187: IF l_NoOfRecordsIns > 0 THEN
1188: /*Code Changes for Bug No.2984871 end */

Line 1202: PA_RES_ACCUM_DETAILS_AR pad2

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
1206: AND pad2.purge_project_id=p_project_id

Line 1212: FROM PA_RES_ACCUM_DETAILS_AR pad2

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
1214: ) ;
1215: /*Code Changes for Bug No.2984871 start */
1216: l_NoOfRecordsDel := SQL%ROWCOUNT ;