APPS.PA_PURGE_SUMMARY dependencies on PA_TXN_ACCUM_AR

Line 1338: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_AR') ;

1334:
1335: l_commit_size := p_commit_size / 2 ;
1336:
1337:
1338: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_AR') ;
1339:
1340: INSERT INTO PA_Txn_Accum_AR
1341: (
1342: PURGE_BATCH_ID,

Line 1340: INSERT INTO PA_Txn_Accum_AR

1336:
1337:
1338: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_AR') ;
1339:
1340: INSERT INTO PA_Txn_Accum_AR
1341: (
1342: PURGE_BATCH_ID,
1343: PURGE_RELEASE,
1344: PURGE_PROJECT_ID,

Line 1473: pa_debug.debug( ' ->After insert into PA_Txn_Accum_AR') ;

1469: /*Code Changes for Bug No.2984871 start */
1470: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1471: /*Code Changes for Bug No.2984871 end */
1472:
1473: pa_debug.debug( ' ->After insert into PA_Txn_Accum_AR') ;
1474:
1475: /*Code Changes for Bug No.2984871 start */
1476: IF l_NoOfRecordsIns > 0 THEN
1477: /*Code Changes for Bug No.2984871 end */

Line 1491: pa_txn_accum_ar ta2

1487: DELETE FROM pa_txn_accum ta
1488: WHERE (ta.rowid) IN
1489: ( SELECT ta1.rowid
1490: FROM pa_txn_accum ta1,
1491: pa_txn_accum_ar ta2
1492: WHERE ta1.txn_accum_id = ta2.txn_accum_id
1493: AND ta2.purge_project_id = p_project_id
1494: ) ;
1495: */

Line 1499: FROM pa_txn_accum_ar ta2

1495: */
1496: DELETE FROM pa_txn_accum ta
1497: WHERE (ta.txn_accum_id) IN
1498: ( SELECT ta2.txn_accum_id
1499: FROM pa_txn_accum_ar ta2
1500: WHERE ta2.purge_project_id = p_project_id
1501: ) ;
1502: /*Code Changes for Bug No.2984871 start */
1503: l_NoOfRecordsDel := SQL%ROWCOUNT ;