APPS.PA_PURGE_SUMMARY dependencies on PA_RES_ACCUM_DETAILS_AR

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

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

Line 1132: INSERT INTO PA_RES_ACCUM_DETAILS_AR

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

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

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

Line 1201: PA_RES_ACCUM_DETAILS_AR pad2

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

Line 1211: FROM PA_RES_ACCUM_DETAILS_AR pad2

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