APPS.PA_PURGE_SUMMARY dependencies on PA_TXN_ACCUM_AR

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

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

Line 1339: INSERT INTO PA_Txn_Accum_AR

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

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

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

Line 1490: pa_txn_accum_ar ta2

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

Line 1498: FROM pa_txn_accum_ar ta2

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