APPS.PA_PURGE_SUMMARY dependencies on PA_TXN_ACCUM_DETAILS_AR

Line 1624: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_Details_AR') ;

1620:
1621: l_commit_size := p_commit_size / 2 ;
1622:
1623:
1624: pa_debug.debug( ' ->Before insert into PA_Txn_Accum_Details_AR') ;
1625:
1626: -- Modified insert statement to use project_id from pa_txn_accum to select rows from
1627: -- pa_txn_accum_details as project_id may be null for some detail lines
1628: -- project_id is a not null column in pa_txn_accum.

Line 1630: INSERT INTO PA_Txn_Accum_Details_AR

1626: -- Modified insert statement to use project_id from pa_txn_accum to select rows from
1627: -- pa_txn_accum_details as project_id may be null for some detail lines
1628: -- project_id is a not null column in pa_txn_accum.
1629:
1630: INSERT INTO PA_Txn_Accum_Details_AR
1631: (
1632: PURGE_BATCH_ID,
1633: PURGE_RELEASE,
1634: PURGE_PROJECT_ID,

Line 1687: pa_debug.debug( ' ->After insert into PA_Txn_Accum_Details_AR') ;

1683: /*Code Changes for Bug No.2984871 start */
1684: l_NoOfRecordsIns := SQL%ROWCOUNT ;
1685: /*Code Changes for Bug No.2984871 end */
1686:
1687: pa_debug.debug( ' ->After insert into PA_Txn_Accum_Details_AR') ;
1688:
1689: IF l_NoOfRecordsIns > 0 THEN
1690: -- The algorithm for deleting records from original table
1691: -- depends on whether records are being archived or not.

Line 1703: pa_txn_accum_details_ar tad2

1699: DELETE FROM pa_txn_accum_details tad
1700: WHERE (tad.rowid) IN
1701: ( SELECT tad2.original_rowid
1702: FROM pa_txn_accum_details tad1,
1703: pa_txn_accum_details_ar tad2
1704: WHERE tad1.rowid = tad2.original_rowid
1705: -- AND tad1.project_id=tad2.project_id
1706: AND tad2.purge_project_id = p_project_id
1707: ) ;